biz_discountproduct

<h4>biz_discountproduct 单品折列表</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>CreateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>CreateBy</td> <td>int(11)</td> <td>YES</td> <td></td> <td>创建人</td> </tr> <tr> <td>LastUpdateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>最后一次更新时间</td> </tr> <tr> <td>LastUpdateBy</td> <td>int(11)</td> <td>YES</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>DiscountAmount</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>折扣数量</td> </tr> <tr> <td>DiscountPieceAmount</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>折扣件数</td> </tr> <tr> <td>ProductId</td> <td>bigint(11)</td> <td>YES</td> <td></td> <td>产品ID</td> </tr> <tr> <td>AfterDiscountPrice</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>产品折后价</td> </tr> <tr> <td>OriginalPrice</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>产品原价</td> </tr> <tr> <td>DiscountRate</td> <td>double(11,4)</td> <td>YES</td> <td></td> <td>折扣率</td> </tr> <tr> <td>RemainAmount</td> <td>double(255,0)</td> <td>YES</td> <td>0</td> <td>剩余数量</td> </tr> <tr> <td>RemainPieceAmount</td> <td>double(11,0)</td> <td>YES</td> <td>0</td> <td>剩余件数</td> </tr> <tr> <td>BeginDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>起始日期</td> </tr> <tr> <td>EndDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>终止日期</td> </tr> <tr> <td>ImportNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>导入编号</td> </tr> <tr> <td>Attribute1</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute2</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>存放备注</td> </tr> <tr> <td>Attribute3</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute4</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute5</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table>