biz_ordertrans_dealer
<h4>biz_ordertrans_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>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>归档时间&&状态变更为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>
</tbody>
</table>