test

test


init_payment

<h4>init_payment 货款表 init_payment:回款明细:用于手机报表中统计17年度累计回款。</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>PaymentAmount</td> <td>double</td> <td>YES</td> <td></td> <td>收款编号,门户收款标识</td> </tr> <tr> <td>PaymentDate</td> <td>datetime</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>

页面列表

ITEM_HTML