biz_discountratio
<h4>biz_discountratio 返利比例表</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>ID</td>
</tr>
<tr>
<td>Type</td>
<td>int(4)</td>
<td>YES</td>
<td></td>
<td>核算类型：1：完成率，2：完成额</td>
</tr>
<tr>
<td>DiscountType</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>返利类型</td>
</tr>
<tr>
<td>DiscountDealerType</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>LowerLimitRate</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>完成率下限</td>
</tr>
<tr>
<td>UpperLimitRate</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>完成率上限</td>
</tr>
<tr>
<td>LowerLimitAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>额度下限</td>
</tr>
<tr>
<td>UpperLimitAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>额度上限</td>
</tr>
<tr>
<td>DiscountRatio</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>返利比例</td>
</tr>
<tr>
<td>StartTime</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>有效起始时间</td>
</tr>
<tr>
<td>EndTime</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>有效结束时间</td>
</tr>
</tbody>
</table>