biz_dealeraddress_dealer
<h4>biz_dealeraddress_dealer</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>