biz_inventoryoptlog_dealer

<h4>biz_inventoryoptlog_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(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>