biz_inventoryoptlog
<h4>biz_inventoryoptlog 库存操作明细表</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></td>
</tr>
<tr>
<td>InventoryID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>仓库Id</td>
</tr>
<tr>
<td>ToSubInventoryId</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>目标仓库</td>
</tr>
<tr>
<td>BizId</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>业务ID</td>
</tr>
<tr>
<td>Type</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></td>
</tr>
<tr>
<td>BatchNo</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>PrimaryUnit</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>主单位</td>
</tr>
<tr>
<td>PrimaryQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>主数量</td>
</tr>
<tr>
<td>SecondUnit</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>辅单位</td>
</tr>
<tr>
<td>SecondQty</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>辅数量</td>
</tr>
<tr>
<td>StorageDate</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>Comment</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Status</td>
<td>int(4)</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>InventoryType</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>规则优先:1.可用量 2.破损量 3.零货量</td>
</tr>
<tr>
<td>StorageBy</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>操作人</td>
</tr>
<tr>
<td>OwnOrderNo</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>所属单据编号</td>
</tr>
<tr>
<td>PrimaryQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原主数量,单位为主单位</td>
</tr>
<tr>
<td>PrimaryQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后主数量,单位为主单位</td>
</tr>
<tr>
<td>LockedQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原锁定数量,单位为主单位</td>
</tr>
<tr>
<td>LockedQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后锁定量,单位为主单位</td>
</tr>
<tr>
<td>DamagedQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原破损量,单位为主单位</td>
</tr>
<tr>
<td>DamagedQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后破损量,单位为主单位</td>
</tr>
<tr>
<td>LockDamagedQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原破损锁定量,单位为主单位</td>
</tr>
<tr>
<td>LockDamagedQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后破损锁定量,单位为主单位</td>
</tr>
<tr>
<td>ScatteredQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原零散量,单位为主单位</td>
</tr>
<tr>
<td>ScatteredQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后零散量,单位为主单位</td>
</tr>
<tr>
<td>LockScatteredQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原零散锁定量,单位为主单位</td>
</tr>
<tr>
<td>LockScatteredQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后零散锁定量,单位为主单位</td>
</tr>
<tr>
<td>TransitQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原在途数量,单位为主单位</td>
</tr>
<tr>
<td>TransitQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后在途数量,单位为主单位</td>
</tr>
<tr>
<td>WillTransitQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>原待转入数量,单位为主单位</td>
</tr>
<tr>
<td>WillTransitQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>操作后待转入数量,单位为主单位</td>
</tr>
<tr>
<td>LockOrderQtyBefore</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>订单出库操作前锁定量,单位为主单位</td>
</tr>
<tr>
<td>LockOrderQtyAfter</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>订单出库操作后锁定量,单位为主单位</td>
</tr>
</tbody>
</table>