init_checkpayment
<h4>init_checkpayment 考核回款历史数据 init_checkpayment : 考核回款,用于经销商考核回款表的导出(后台、前台都有这个报表)。</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>CheckAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>考核回款金额</td>
</tr>
<tr>
<td>PayAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>已到账货款</td>
</tr>
<tr>
<td>DiscountAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>计入回款的返利金额</td>
</tr>
<tr>
<td>KQPayment</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>口腔回款金额</td>
</tr>
<tr>
<td>XHPayment</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>洗护回款金额</td>
</tr>
<tr>
<td>TakeDate</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>
</tbody>
</table>