biz_discountdetail
<h4>biz_discountdetail 折扣折让明细表</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>DiscountID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>折扣折让ID</td>
</tr>
<tr>
<td>LineId</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>LineNum</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>DiscountNameID</td>
<td>bigint(11)</td>
<td>YES</td>
<td></td>
<td>折扣名称</td>
</tr>
<tr>
<td>Type</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>折扣类型</td>
</tr>
<tr>
<td>ExecuteDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>应用日期</td>
</tr>
<tr>
<td>IncludPayment</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否计入回款:0 不计入 1 计入</td>
</tr>
<tr>
<td>IncludPaymentAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>计入回款金额</td>
</tr>
<tr>
<td>UnIncludPaymentAmount</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>不计入回款金额</td>
</tr>
<tr>
<td>OffsetDiscount</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>冲抵折扣</td>
</tr>
<tr>
<td>Remittance</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>转出金额</td>
</tr>
<tr>
<td>UsedPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>已使用金额</td>
</tr>
<tr>
<td>InvoicePrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>生成发票金额</td>
</tr>
<tr>
<td>RemainPrice</td>
<td>double</td>
<td>YES</td>
<td></td>
<td>剩余金额</td>
</tr>
<tr>
<td>DiscountPrice</td>
<td>double(255,0)</td>
<td>YES</td>
<td></td>
<td>折扣金额</td>
</tr>
<tr>
<td>FrozenPrice</td>
<td>double</td>
<td>NO</td>
<td></td>
<td>冻结金额</td>
</tr>
<tr>
<td>Stat</td>
<td>tinyint(4)</td>
<td>YES</td>
<td></td>
<td>折扣折让状态 0; // 新增、待审核;1; // 审核通过;2; // 审核不通过;3:标记删除</td>
</tr>
<tr>
<td>Remark</td>
<td>varchar(255)</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>CreateDate</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>LastUpdateDate</td>
<td>datetime</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>保存系统生成折扣的biz_discountcountdetail的对应行ID</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>DType</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>类型(1.新增 2.冲抵 3.转出 4.转入5.自动生成高开折扣)</td>
</tr>
<tr>
<td>OwnerId</td>
<td>bigint(11)</td>
<td>YES</td>
<td></td>
<td>出时对应转出折扣id,转入时为转出的折扣id。冲抵时为冲抵折扣Id</td>
</tr>
<tr>
<td>ImportNo</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>导入编号</td>
</tr>
<tr>
<td>BigType</td>
<td>int(11)</td>
<td>YES</td>
<td>0</td>
<td>折扣大类(0 未分类 104 口腔类 103 洗护类 11336 采之汲 11335 礼盒)</td>
</tr>
</tbody>
</table>