biz_inventorytotal
<h4>biz_inventorytotal 库存总表</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></td>
</tr>
<tr>
<td>SubInventoryId</td>
<td>bigint(11)</td>
<td>YES</td>
<td></td>
<td>仓库Id</td>
</tr>
<tr>
<td>SubIvtCode</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>仓库code</td>
</tr>
<tr>
<td>SubIvtName</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>仓库名称</td>
</tr>
<tr>
<td>ProductNo</td>
<td>varchar(11)</td>
<td>YES</td>
<td></td>
<td>产品编码</td>
</tr>
<tr>
<td>MaterialIntro</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>物料说明</td>
</tr>
<tr>
<td>TotalTransitQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>总在途量,单位为主单位</td>
</tr>
<tr>
<td>TotalLockedQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>总锁定量,单位为主单位</td>
</tr>
<tr>
<td>TotalLessQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>总欠货量,主单位</td>
</tr>
<tr>
<td>TotalPrimaryQty</td>
<td>double</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>Spec</td>
<td>int(11)</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>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>ProductId</td>
<td>bigint(11)</td>
<td>YES</td>
<td></td>
<td>产品Id</td>
</tr>
<tr>
<td>DamagedQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>总破损数量</td>
</tr>
</tbody>
</table>