biz_productinventorysum
<h4>biz_productinventorysum 经销商产品库存汇总</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>DealerID</td>
<td>bigint(20)</td>
<td>NO</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>Period</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>月份</td>
</tr>
<tr>
<td>Cate</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>品类</td>
</tr>
<tr>
<td>Unit</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>单位</td>
</tr>
<tr>
<td>Purchase</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>进货量</td>
</tr>
<tr>
<td>Sales</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>销量</td>
</tr>
<tr>
<td>Inventory</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>库存</td>
</tr>
<tr>
<td>TheoryInventory</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>理论库存</td>
</tr>
</tbody>
</table>