biz_dealeraddress

<h4>biz_dealeraddress 经销商地址表（包括收货地址和收单地址）</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>ID</td> <td>bigint(20)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>DealerID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>BusinessEntity</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>业务实体</td> </tr> <tr> <td>CustAccountId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>经销商账户Id</td> </tr> <tr> <td>CustAcctSiteId</td> <td>int(11)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>PartyId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>客户id</td> </tr> <tr> <td>PartySiteId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>客户地点id</td> </tr> <tr> <td>No</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>地址编号</td> </tr> <tr> <td>Stat</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>状态</td> </tr> <tr> <td>BillToFlag</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>开票地点标识 Y：是 N：否 P：主要地点</td> </tr> <tr> <td>ShipToFlag</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收货地点标识 Y：是 N：否 P：主要地点</td> </tr> <tr> <td>LocationId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>EBS地址id</td> </tr> <tr> <td>Country</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>国家</td> </tr> <tr> <td>Address</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>地址</td> </tr> <tr> <td>Province</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>省份</td> </tr> <tr> <td>City</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>市</td> </tr> <tr> <td>County</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>县/区</td> </tr> <tr> <td>Attribute1</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute2</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute3</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute4</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute5</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>CreateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>CreateBy</td> <td>int(11)</td> <td>YES</td> <td></td> <td>创建人</td> </tr> <tr> <td>LastUpdateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>最后一次更新时间</td> </tr> <tr> <td>LastUpdateBy</td> <td>int(11)</td> <td>YES</td> <td></td> <td>最后一次更新人</td> </tr> <tr> <td>Type</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>类型（一级，二级）</td> </tr> <tr> <td>CountyCode</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>IsChange</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>正在变更（1.是，0.否）</td> </tr> </tbody> </table>