biz_discountproductlog

<h4>biz_discountproductlog 折扣品和赠品使用记录</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>ID</td> <td>bigint(20)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>DiscountProductID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>折扣品id</td> </tr> <tr> <td>ProductID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>产品id</td> </tr> <tr> <td>DealerID</td> <td>double(20,0)</td> <td>YES</td> <td></td> <td>经销商ID</td> </tr> <tr> <td>AmountBefore</td> <td>double(11,0)</td> <td>YES</td> <td></td> <td>变动前数量</td> </tr> <tr> <td>AmountAfter</td> <td>double(11,0)</td> <td>YES</td> <td></td> <td>变动后数量</td> </tr> <tr> <td>DiscountPriceBefore</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>变更前折扣价格</td> </tr> <tr> <td>DiscountPriceAfter</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>变更后折扣价格</td> </tr> <tr> <td>RemainAmountBefore</td> <td>double(11,0)</td> <td>YES</td> <td></td> <td>变动前剩余数量</td> </tr> <tr> <td>RemainAmountAfter</td> <td>double(11,0)</td> <td>YES</td> <td></td> <td>变动后剩余数量</td> </tr> <tr> <td>Type</td> <td>tinyint(4)</td> <td>YES</td> <td></td> <td>变动类型</td> </tr> <tr> <td>OrderNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>相关订单号</td> </tr> <tr> <td>OrderDetailID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>订单明细id</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> <tr> <td>CreateBy</td> <td>bigint(11)</td> <td>YES</td> <td></td> <td>创建人</td> </tr> <tr> <td>CreateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>OperateAmount</td> <td>double(11,0)</td> <td>YES</td> <td></td> <td>操作金额</td> </tr> </tbody> </table>