biz_order_dealer
<h4>biz_order_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(11)</td>
<td>NO</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>BusinessEntity</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>业务实体</td>
</tr>
<tr>
<td>ShipFromOrgId</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>发货组织</td>
</tr>
<tr>
<td>ShipSiteUseId</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>收货地点Id</td>
</tr>
<tr>
<td>BillSiteUseId</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>收单地点Id</td>
</tr>
<tr>
<td>PriceListId</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>价目表Id</td>
</tr>
<tr>
<td>ContractNo</td>
<td>varchar(20)</td>
<td>YES</td>
<td></td>
<td>合同号</td>
</tr>
<tr>
<td>BookedFlag</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>订单登记标识</td>
</tr>
<tr>
<td>OrderSource</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>订单导入来源 默认值:JKDP</td>
</tr>
<tr>
<td>OperationCode</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>操作类型,默认:INSERT</td>
</tr>
<tr>
<td>ConversionType</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>汇率类型,用于外币订单</td>
</tr>
<tr>
<td>ConversionRate</td>
<td>double(255,0)</td>
<td>YES</td>
<td></td>
<td>汇率</td>
</tr>
<tr>
<td>ConversionRateDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>汇率日期</td>
</tr>
<tr>
<td>CurrencyType</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>货币类型</td>
</tr>
<tr>
<td>PaymentTerm</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>付款条件</td>
</tr>
<tr>
<td>Type</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>订单类型</td>
</tr>
<tr>
<td>DealerID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>经销商ID</td>
</tr>
<tr>
<td>SumPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>总金额</td>
</tr>
<tr>
<td>Stat</td>
<td>tinyint(4)</td>
<td>YES</td>
<td></td>
<td>订单状态 -1为已取消 1为待复核 2为已复核</td>
</tr>
<tr>
<td>OrderDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>订购日期</td>
</tr>
<tr>
<td>DiscountPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>本单折扣</td>
</tr>
<tr>
<td>NetPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>净额</td>
</tr>
<tr>
<td>InvoiceRequire</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>开票要求</td>
</tr>
<tr>
<td>InvoiceDesc</td>
<td>varchar(240)</td>
<td>YES</td>
<td></td>
<td>开票备注</td>
</tr>
<tr>
<td>SalesrepId</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>销售者ID</td>
</tr>
<tr>
<td>ProcessInstanceId</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>审核流程实例ID</td>
</tr>
<tr>
<td>CreateBy</td>
<td>int(11)</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>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>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>EBS订单类型</td>
</tr>
<tr>
<td>Attribute3</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>退货原因/EBS取消原因</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>SimID</td>
<td>bigint(11)</td>
<td>YES</td>
<td></td>
<td>并发ID</td>
</tr>
<tr>
<td>SimState</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>并发返回状态</td>
</tr>
<tr>
<td>SimMsg</td>
<td>varchar(500)</td>
<td>YES</td>
<td></td>
<td>并发信息</td>
</tr>
<tr>
<td>EBSOrderNo</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>EBS订单编号</td>
</tr>
<tr>
<td>DealerInvoiceID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>开票信息</td>
</tr>
<tr>
<td>ReturnOrderId</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>被退货、换货订单Id</td>
</tr>
<tr>
<td>DealerAccountID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>预付款ID</td>
</tr>
<tr>
<td>RelativeOrderID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>退换货订单正或负订单ID</td>
</tr>
<tr>
<td>InvoiceAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>已开票金额</td>
</tr>
<tr>
<td>HaveToothGoods</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否包含牙膏产品(1.有 0.无)</td>
</tr>
<tr>
<td>IsHighOpen</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否为高开订单(1.是 0.否)</td>
</tr>
<tr>
<td>HighOpenPercent</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>高开比例</td>
</tr>
<tr>
<td>RealSumPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>高开金额</td>
</tr>
<tr>
<td>AuditDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>审核时间</td>
</tr>
<tr>
<td>AuditBy</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>PrintDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>PassComment</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>预付款不足通过审核说明</td>
</tr>
<tr>
<td>TempAddressFlag</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否使用临时收货地址</td>
</tr>
<tr>
<td>TempAddress</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>临时收货地址</td>
</tr>
<tr>
<td>TempProvince</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>临时地址-省</td>
</tr>
<tr>
<td>TempCity</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>临时地址-市</td>
</tr>
<tr>
<td>TempCounty</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>临时地址-县</td>
</tr>
<tr>
<td>TempCountyCode</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>临时地址县code</td>
</tr>
<tr>
<td>Reminded</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否提醒</td>
</tr>
<tr>
<td>OnlyWashGoods</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>只包含洗护类产品并且单品下单数量小于5(1.是;0.否)</td>
</tr>
<tr>
<td>EbsCreateDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>EBS创建时间</td>
</tr>
<tr>
<td>BigType</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>订单大类(0 未分类 104 口腔类 103 洗护类 11336 采之汲 11335 礼盒)</td>
</tr>
<tr>
<td>MinPieceAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>订单行件数最小值</td>
</tr>
<tr>
<td>DealerGroupBuyID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>下单时所选团购客户</td>
</tr>
<tr>
<td>SupDealerId</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>上级销售单位id</td>
</tr>
<tr>
<td>AccountPeriodID</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>所属账期ID</td>
</tr>
<tr>
<td>dealerType</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>客户类型</td>
</tr>
</tbody>
</table>