biz_ordertrans

<h4>biz_ordertrans 物流单信息表</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>Stat</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>物流单状态</td> </tr> <tr> <td>EntrustAddr</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>委托地点（合并后）</td> </tr> <tr> <td>ArriveDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>预计到达日期</td> </tr> <tr> <td>TransID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>物流公司ID</td> </tr> <tr> <td>TargetTransID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>目标物流公司</td> </tr> <tr> <td>OrederID</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>订单ID（合并后）</td> </tr> <tr> <td>DealerID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>经销商ID</td> </tr> <tr> <td>TransNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>物流单号(门户生成)</td> </tr> <tr> <td>Destination</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收货地址</td> </tr> <tr> <td>SendDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>发货日期</td> </tr> <tr> <td>TransEBS</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>EBS物流单号（合并后）</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>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>CreateGetTime</td> <td>datetime</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>GoToGetTime</td> <td>datetime</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>Weight</td> <td>double</td> <td>YES</td> <td></td> <td>总重</td> </tr> <tr> <td>Volume</td> <td>double</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>SignDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>实际签收时间</td> </tr> <tr> <td>Reply</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>提货说明（预约回复）</td> </tr> <tr> <td>TransportShipDepotID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>仓库ID</td> </tr> <tr> <td>AllReturnStat</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>整单退货时状态</td> </tr> <tr> <td>BarCodeTimeout</td> <td>datetime</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>UploadBarCodeSum</td> <td>double</td> <td>YES</td> <td>0</td> <td>已上传条码总数</td> </tr> <tr> <td>NeedBarCodeSum</td> <td>double</td> <td>YES</td> <td>0</td> <td>需上传的条码总数</td> </tr> <tr> <td>TransportCarrierID</td> <td>bigint(11)</td> <td>YES</td> <td></td> <td>承运车辆ID</td> </tr> <tr> <td>TransportVehicleID</td> <td>bigint(11)</td> <td>YES</td> <td></td> <td>承运人ID</td> </tr> <tr> <td>Mileage</td> <td>double</td> <td>YES</td> <td></td> <td>里程</td> </tr> <tr> <td>ArchiveDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>归档时间&amp;&amp;状态变更为EBS已退货的时间(整个物流单已退货后)</td> </tr> <tr> <td>ProductFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否包含为维护产品信息的物流明细(0 否 1是)</td> </tr> <tr> <td>Type</td> <td>int(11)</td> <td>YES</td> <td></td> <td>1：普通物流单，2：退货物流单，3. 杂项出库发运单</td> </tr> <tr> <td>GoToGetOptTime</td> <td>datetime</td> <td>YES</td> <td></td> <td>预约答复操作时间</td> </tr> <tr> <td>BarCodeFlag</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>是否生成条码</td> </tr> <tr> <td>LastCreateGetTime</td> <td>datetime</td> <td>YES</td> <td></td> <td>最晚预约时间</td> </tr> <tr> <td>LastGoToGetTime</td> <td>datetime</td> <td>YES</td> <td></td> <td>最晚回复时间</td> </tr> <tr> <td>LastSendTime</td> <td>datetime</td> <td>YES</td> <td></td> <td>最晚发运时间</td> </tr> <tr> <td>LastUploadBarCodeTime</td> <td>datetime</td> <td>YES</td> <td></td> <td>最晚上传条码时间</td> </tr> <tr> <td>LastUplodSignTime</td> <td>datetime</td> <td>YES</td> <td></td> <td>最晚上传签收单附件时间</td> </tr> <tr> <td>Remark</td> <td>varchar(255)</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>IsTmpFee</td> <td>tinyint(4)</td> <td>YES</td> <td>0</td> <td>是否以临时运价核算费用 0:否；1:是</td> </tr> </tbody> </table>