biz_inventory
<h4>biz_inventory 库存明细表</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>OrgName</td>
<td>varchar(255)</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>ProductCode</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>SubInventoryID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>子库ID</td>
</tr>
<tr>
<td>LocatorID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>货位ID</td>
</tr>
<tr>
<td>ProductVersion</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>产品版本</td>
</tr>
<tr>
<td>ProductVersionDesc</td>
<td>varchar(255)</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(15)</td>
<td>YES</td>
<td>0</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>0</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>BatchStatus</td>
<td>int(4)</td>
<td>YES</td>
<td></td>
<td>批次状态</td>
</tr>
<tr>
<td>ProductionDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>生产日期</td>
</tr>
<tr>
<td>InvalidDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>产品失效日期</td>
</tr>
<tr>
<td>LockedQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>锁定量,单位为主单位</td>
</tr>
<tr>
<td>TransitQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</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>StorageBy</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>AchievePreQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>提前接收批次的数量</td>
</tr>
<tr>
<td>AchievePreShipQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>提前接收批次已发运数量</td>
</tr>
<tr>
<td>DamagedQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>破损数量</td>
</tr>
<tr>
<td>ScatteredQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>零货量</td>
</tr>
<tr>
<td>LockScatteredQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>零货锁定量</td>
</tr>
<tr>
<td>LockDamagedQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>破损锁定量</td>
</tr>
<tr>
<td>LockManualQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>手动锁定量</td>
</tr>
<tr>
<td>WillTransitQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>待转入(分拨、子库转移目标仓库为本仓库未发运)</td>
</tr>
<tr>
<td>LockOrderQty</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>销售类(订单,杂出、口头单)出库锁定</td>
</tr>
<tr>
<td>Type</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>库存类型(1:白药库存 2:经销商库存)</td>
</tr>
<tr>
<td>DealerId</td>
<td>bigint(11)</td>
<td>YES</td>
<td></td>
<td>经销商Id</td>
</tr>
<tr>
<td>LastUpdateBy</td>
<td>bigint(11)</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>CreateDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>创建时间</td>
</tr>
</tbody>
</table>