init_invoice
<h4>init_invoice 货款表</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>DealerID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>经销商ID</td>
</tr>
<tr>
<td>DealerName</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>经销商名称</td>
</tr>
<tr>
<td>BelongToArea</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>所属销售区域—大区</td>
</tr>
<tr>
<td>Country</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>省区</td>
</tr>
<tr>
<td>BelongToProvince</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>销售区域 – 省份</td>
</tr>
<tr>
<td>ProductCate</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>品类</td>
</tr>
<tr>
<td>InvoiceAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>开票金额</td>
</tr>
<tr>
<td>InvoiceDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>开票日期</td>
</tr>
<tr>
<td>Period</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>累计区间</td>
</tr>
<tr>
<td>Type</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>区分事业部与电商,‘Y’:电商;‘N’事业部</td>
</tr>
</tbody>
</table>