test

test


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>

页面列表

ITEM_HTML