biz_dealer

<h4>biz_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>PartyId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>EBS客户ID</td> </tr> <tr> <td>CustAccountId</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>EBS客户账户唯一键，创建订单接口，需要提供该值标识客户, 同时用作siebel同步经销商信息ID</td> </tr> <tr> <td>No</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>客户编号</td> </tr> <tr> <td>Name</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>客户名称</td> </tr> <tr> <td>BelongToArea</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>所属销售区域—大区</td> </tr> <tr> <td>BelongToProvince</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>销售区域 – 省份</td> </tr> <tr> <td>Country</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>省区</td> </tr> <tr> <td>Type</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>类型（一级，二级）</td> </tr> <tr> <td>RegistryNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>注册表标识</td> </tr> <tr> <td>Status</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>有效性状态 A：有效 I：无效</td> </tr> <tr> <td>MultiOrderTypeFlag</td> <td>bit(1)</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>Y代表属于电子商务，N代表不属于电子商务</td> </tr> <tr> <td>Attribute3</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>发送短信标识:Y：发送短信，N：不发送短息</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>Parent</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>父子关系</td> </tr> <tr> <td>AreaNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>地点编号</td> </tr> <tr> <td>DepartmentID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>部门ID</td> </tr> <tr> <td>GroupId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>DiscountID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>折扣折让ID</td> </tr> <tr> <td>Province</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>省份</td> </tr> <tr> <td>ProcessDefinitionID</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>订单审核流程定义ID</td> </tr> <tr> <td>DealerInvoiceID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>开票信息</td> </tr> <tr> <td>DelayInvoiceFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否可选暂不开票</td> </tr> <tr> <td>HighOpenFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否高开</td> </tr> <tr> <td>ControlAmountFlag</td> <td>bit(1)</td> <td>YES</td> <td>b'1'</td> <td>是否控制订单金额</td> </tr> <tr> <td>Abbreviation</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>经销商简称</td> </tr> <tr> <td>CanOrderType</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>可下单类型</td> </tr> <tr> <td>CareProvince</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>所属洗护省区</td> </tr> <tr> <td>GroupBuyFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否是团购客户</td> </tr> <tr> <td>Classification</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>经销类型（数据字典ID=52）</td> </tr> <tr> <td>OrderImportFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否可以导入订单</td> </tr> <tr> <td>ShortName</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>经销商简称</td> </tr> <tr> <td>Src</td> <td>int(11)</td> <td>YES</td> <td></td> <td>经销商来源</td> </tr> <tr> <td>DealerType</td> <td>int(11)</td> <td>YES</td> <td></td> <td>经销商类型</td> </tr> <tr> <td>HasInventory</td> <td>bit(1)</td> <td>YES</td> <td>b'0'</td> <td>是否已生成库存</td> </tr> <tr> <td>Editable</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否可编辑库存</td> </tr> <tr> <td>Attribute6</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>用于销售出货单介绍信息1</td> </tr> <tr> <td>Attribute7</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>用于销售出货单介绍信息2</td> </tr> <tr> <td>Attribute8</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>用于销售出货单介绍信息3</td> </tr> <tr> <td>ReceivereId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>收货单位（一级经销商Id）</td> </tr> <tr> <td>paymentremarktag</td> <td>varchar(1)</td> <td>YES</td> <td></td> <td>Y-录款需要填备注，N-录款不需要填备注</td> </tr> </tbody> </table>