biz_order

<h4>biz_order 订单表</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>订单状态</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>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>DealerType</td> <td>int(11)</td> <td>YES</td> <td></td> <td>无实际用途</td> </tr> <tr> <td>ReceiverDealerId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>收货的一级经销商id</td> </tr> <tr> <td>AccountPeriodID</td> <td>bigint(11)</td> <td>YES</td> <td></td> <td>所属账期</td> </tr> <tr> <td>remarks</td> <td>varchar(128)</td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table>