biz_ordertransfee

<h4>biz_ordertransfee 物流核算</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>OrderTransDetailId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>物流明细ID</td> </tr> <tr> <td>OrederID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>订单ID</td> </tr> <tr> <td>OrderTransID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>物流发运单ID</td> </tr> <tr> <td>ArchiveDate</td> <td>datetime</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>EbsOrderNo</td> <td>varchar(10)</td> <td>YES</td> <td></td> <td>EBS订单号</td> </tr> <tr> <td>OrderNo</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>订单号</td> </tr> <tr> <td>TransNo</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>发运通知单号</td> </tr> <tr> <td>DealerName</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>经销商名称</td> </tr> <tr> <td>StartAddrName</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>起运地</td> </tr> <tr> <td>EndAddrName</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>目的地</td> </tr> <tr> <td>ShipDepotName</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>仓库名称</td> </tr> <tr> <td>TopClassName</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>产品一级分类</td> </tr> <tr> <td>ProductNo</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>产品编码</td> </tr> <tr> <td>ProductName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>产品名称</td> </tr> <tr> <td>PiecesNum</td> <td>double</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>PieceWeight</td> <td>double</td> <td>YES</td> <td></td> <td>单件重量</td> </tr> <tr> <td>Price</td> <td>double</td> <td>YES</td> <td></td> <td>运价</td> </tr> <tr> <td>FeeAmount</td> <td>double</td> <td>YES</td> <td></td> <td>总运价</td> </tr> <tr> <td>PayableAmount</td> <td>double</td> <td>YES</td> <td></td> <td>应付运价</td> </tr> <tr> <td>Mileage</td> <td>double</td> <td>YES</td> <td></td> <td>里程</td> </tr> <tr> <td>CarNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>承运车辆</td> </tr> <tr> <td>VehicleNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>承运车辆号码</td> </tr> <tr> <td>CarrierName</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>承运人</td> </tr> <tr> <td>CarrierIdNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>承运人身份证号</td> </tr> <tr> <td>Attribute1</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute2</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute3</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute4</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute5</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>1：销售——普通物流；2：销售——退货物流单3:杂项出库4:口头单；5:调拨——提货费用；6：调拨——承运费用</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>CheckMonth</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>核算月份</td> </tr> <tr> <td>TransPortID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>承运物流公司ID</td> </tr> <tr> <td>TransPortName</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>承运物流公司名称</td> </tr> <tr> <td>Type</td> <td>int(11)</td> <td>YES</td> <td></td> <td>核算类型：2：分拨核算，1：订单发货核算</td> </tr> <tr> <td>FeeAmountAdj</td> <td>double</td> <td>YES</td> <td></td> <td>总运价(调整后)</td> </tr> <tr> <td>PricingModel</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>结算方式</td> </tr> <tr> <td>Priceid</td> <td>bigint(11)</td> <td>YES</td> <td></td> <td>关联运价表的ID</td> </tr> <tr> <td>Status</td> <td>int(2)</td> <td>YES</td> <td></td> <td>1:新建；2:已修改;3:驳回;4.已确认</td> </tr> <tr> <td>Istemporary</td> <td>varchar(1)</td> <td>YES</td> <td></td> <td>Y 临时运价；N：长期运价</td> </tr> <tr> <td>quantity</td> <td>bigint(11)</td> <td>YES</td> <td>0</td> <td>数量</td> </tr> <tr> <td>batchno</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>批次</td> </tr> <tr> <td>notes</td> <td>varchar(100)</td> <td>YES</td> <td></td> <td>费用核算备注</td> </tr> </tbody> </table>