biz_ordertransdetail

<h4>biz_ordertransdetail 物流单明细信息表</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>LineId</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>发货通知单行Id</td> </tr> <tr> <td>Stat</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>物流单行状态</td> </tr> <tr> <td>TransName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>物流公司名称</td> </tr> <tr> <td>OrderTransID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>物流公司ID</td> </tr> <tr> <td>OrederID</td> <td>bigint(255)</td> <td>YES</td> <td></td> <td>订单ID（对应一个订单）</td> </tr> <tr> <td>OrderDetailID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>对应一个订单明细ID</td> </tr> <tr> <td>SignDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>签收日期</td> </tr> <tr> <td>ProductID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>产品ID</td> </tr> <tr> <td>TransEBS</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>EBS物流单号</td> </tr> <tr> <td>LotNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>批次号(来自EBS)</td> </tr> <tr> <td>Volume</td> <td>double</td> <td>YES</td> <td></td> <td>体积</td> </tr> <tr> <td>Quantity</td> <td>double</td> <td>YES</td> <td></td> <td>数量</td> </tr> <tr> <td>PiecesNum</td> <td>int(11)</td> <td>YES</td> <td></td> <td>件数</td> </tr> <tr> <td>Unit</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>单位</td> </tr> <tr> <td>Weight</td> <td>double</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>bigint(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>bigint(11)</td> <td>YES</td> <td></td> <td>最后一次更新人</td> </tr> <tr> <td>OrderTransEBSID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>EBS物流发运单ID</td> </tr> <tr> <td>ShipDepot</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>发货仓库</td> </tr> <tr> <td>Locator</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>货位</td> </tr> <tr> <td>ShipDepotCity</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>发货城市</td> </tr> <tr> <td>ShipSiteUseId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>收货地址</td> </tr> <tr> <td>TransportTypeID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>发运方式</td> </tr> <tr> <td>StartAddrCode</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>起始地编码</td> </tr> <tr> <td>EndAddrCode</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>目的地编码</td> </tr> <tr> <td>ArriveDay</td> <td>int(11)</td> <td>YES</td> <td></td> <td>预计到达时间</td> </tr> <tr> <td>TransType</td> <td>varchar(50)</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>ReturnReason</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>退货、退换货原因</td> </tr> <tr> <td>ReturnDetailId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>退换货原物流行Id</td> </tr> <tr> <td>ReturnedPiecesNum</td> <td>double</td> <td>YES</td> <td>0</td> <td>退货件数</td> </tr> <tr> <td>Type</td> <td>int(11) unsigned</td> <td>YES</td> <td></td> <td>发运单类型，1：普通物流单，2：退货物流单</td> </tr> <tr> <td>AllReturnStat</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>整行退货时状态</td> </tr> <tr> <td>FeeFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>退货行是否产生物流费用（0否 1是）</td> </tr> <tr> <td>ReturnedQuantity</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>退货数量</td> </tr> <tr> <td>PricingModel</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>计价方式</td> </tr> <tr> <td>LowestPrice</td> <td>double</td> <td>YES</td> <td>0</td> <td>最低运价</td> </tr> <tr> <td>FeeCreateFlag</td> <td>tinyint(4)</td> <td>YES</td> <td>0</td> <td>是否已生成物流核算数据（0否 1是2不计费）</td> </tr> <tr> <td>EbsSimStatus</td> <td>int(2)</td> <td>YES</td> <td></td> <td>发运单传传EBS并发状态</td> </tr> <tr> <td>EbsSimMasege</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>传EBS并发消息</td> </tr> <tr> <td>EbsTransQty</td> <td>int(11)</td> <td>YES</td> <td></td> <td>EBS发运数量</td> </tr> <tr> <td>InventoryType</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>规则优先：1.可用量 2.破损量 3.零货量</td> </tr> <tr> <td>AchieveQty</td> <td>int(15)</td> <td>YES</td> <td>0</td> <td>签收数量</td> </tr> <tr> <td>OrderPickupType</td> <td>int(2)</td> <td>YES</td> <td></td> <td>提货方式：2：订单客户自提，3：天猫客户自提</td> </tr> <tr> <td>TttSimStatus</td> <td>int(2)</td> <td>YES</td> <td></td> <td>同步条码系统状态</td> </tr> <tr> <td>StatDealer</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>物流单状态</td> </tr> <tr> <td>AchieveQtyDealer</td> <td>int(11)</td> <td>YES</td> <td></td> <td>经销商已签收数量</td> </tr> </tbody> </table>