biz_inventorycollect
<h4>biz_inventorycollect</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>SivtId</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>SivtCode</td>
<td>varchar(50)</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>ProductNo</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>BatchNo</td>
<td>varchar(20)</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>PriQty0</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>生产数量</td>
</tr>
<tr>
<td>PriQty1</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>期初导入</td>
</tr>
<tr>
<td>PriQty2</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>分拨出库</td>
</tr>
<tr>
<td>PriQty3</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>分拨入库</td>
</tr>
<tr>
<td>PriQty4</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>订单发货出库</td>
</tr>
<tr>
<td>PriQty5</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>optLog 锁定</td>
</tr>
<tr>
<td>PriQty6</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>optLog 入库</td>
</tr>
<tr>
<td>PriQty7</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>optLog 出库</td>
</tr>
<tr>
<td>PriQty8</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>订单发货锁定</td>
</tr>
<tr>
<td>PriQty9</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>系统即时库存</td>
</tr>
<tr>
<td>resultA</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>PriQty1+PriQty0+PriQty3-PriQty2-PriQty4</td>
</tr>
<tr>
<td>resultC</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>PriQty1+PriQty0+PriQty5-PriQty6</td>
</tr>
</tbody>
</table>