biz_invoicedetail

<h4>biz_invoicedetail 发票信息表</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>InvoiceID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>LineId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>EBS行Id,</td> </tr> <tr> <td>LineNum</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>行号</td> </tr> <tr> <td>OrderNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>订单编号</td> </tr> <tr> <td>OrderLineNum</td> <td>int(11)</td> <td>YES</td> <td></td> <td>订单行号</td> </tr> <tr> <td>OrderDetailID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>EBSTransNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>EBS发货号</td> </tr> <tr> <td>ProductID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>产品</td> </tr> <tr> <td>InvoiceProductName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>开票品名</td> </tr> <tr> <td>Unit</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>计量单位</td> </tr> <tr> <td>Spec</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>规格</td> </tr> <tr> <td>Quantity</td> <td>double</td> <td>YES</td> <td></td> <td>数量</td> </tr> <tr> <td>UnitPrice</td> <td>double</td> <td>YES</td> <td></td> <td>销售单价</td> </tr> <tr> <td>Amount</td> <td>double</td> <td>YES</td> <td></td> <td>含税金额</td> </tr> <tr> <td>TaxRate</td> <td>double</td> <td>YES</td> <td></td> <td>税率</td> </tr> <tr> <td>Tax</td> <td>double</td> <td>YES</td> <td></td> <td>税额</td> </tr> <tr> <td>Type</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>发票类型，ORDER : 销售订单发票， DISC : 折扣折让发票</td> </tr> <tr> <td>DiscountDetailId</td> <td>bigint(50)</td> <td>YES</td> <td></td> <td>折扣折让Id</td> </tr> <tr> <td>DiscountAmount</td> <td>double</td> <td>YES</td> <td></td> <td>折扣金额</td> </tr> <tr> <td>State</td> <td>int(2)</td> <td>YES</td> <td></td> <td>状态</td> </tr> <tr> <td>BizOrderID</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> </tbody> </table>