biz_orderdetail
<h4>biz_orderdetail 订单明细表</h4>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>类型长度</th>
<th>是否NULL</th>
<th>默认值</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>bigint(20)</td>
<td>NO</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>OrderID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>订单ID</td>
</tr>
<tr>
<td>LineNum</td>
<td>int(11)</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>PryUnit</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>主单位</td>
</tr>
<tr>
<td>SubUnit</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>辅单位</td>
</tr>
<tr>
<td>PieceAmount</td>
<td>double(11,2)</td>
<td>YES</td>
<td></td>
<td>件数</td>
</tr>
<tr>
<td>Amount</td>
<td>int(11)</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>RowPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>行总价</td>
</tr>
<tr>
<td>ShipmentNum</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>发运行号</td>
</tr>
<tr>
<td>OrganizID</td>
<td>bigint(11)</td>
<td>YES</td>
<td></td>
<td>发货组织</td>
</tr>
<tr>
<td>DepotID</td>
<td>varchar(768)</td>
<td>YES</td>
<td></td>
<td>发货库</td>
</tr>
<tr>
<td>TransID</td>
<td>bigint(255)</td>
<td>YES</td>
<td></td>
<td>物流ID</td>
</tr>
<tr>
<td>LineTypeId</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>行类型Id</td>
</tr>
<tr>
<td>PromiseDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>承诺日期</td>
</tr>
<tr>
<td>ShipDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>发运日期</td>
</tr>
<tr>
<td>type</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>购买类型(1.正常品 2.促销装 3.单品折)</td>
</tr>
<tr>
<td>Stat</td>
<td>tinyint(4)</td>
<td>YES</td>
<td></td>
<td>订单状态,3:待发运,</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>DisProductID</td>
<td>bigint(20)</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>ReturnOrderDetailId</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>被退货、换货订单明细Id</td>
</tr>
<tr>
<td>ReturnReason</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>退货、退换货原因</td>
</tr>
<tr>
<td>ShippedQuantity</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>已发货数量</td>
</tr>
<tr>
<td>InvoiceAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>已开票金额</td>
</tr>
<tr>
<td>InvoiceQuantity</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>已开票量</td>
</tr>
<tr>
<td>ClassCode</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>分类code用于排序</td>
</tr>
<tr>
<td>IsHighOpen</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否为高开订单(1.是 0.否)</td>
</tr>
<tr>
<td>RealPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>高开价</td>
</tr>
<tr>
<td>RealRowPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>高开行总价</td>
</tr>
<tr>
<td>OriginalPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>经销商下单单价</td>
</tr>
<tr>
<td>LessQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>OrderPickupType</td>
<td>int(2)</td>
<td>YES</td>
<td></td>
<td>提货方式:2:订单客户自提,3:天猫客户自提</td>
</tr>
</tbody>
</table>