biz_invoice

<h4>biz_invoice 发票信息表</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>int(11)</td> <td>YES</td> <td></td> <td>发票标识</td> </tr> <tr> <td>No</td> <td>varchar(50)</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>CustName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>开票客户名称</td> </tr> <tr> <td>Type</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>发票类型</td> </tr> <tr> <td>TaxRegNum</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>纳税登记号</td> </tr> <tr> <td>AddressAndPhone</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>开票地址及电话</td> </tr> <tr> <td>BankAccount</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>银行及账户</td> </tr> <tr> <td>TotalAmount</td> <td>double</td> <td>YES</td> <td></td> <td>总金额(含税)</td> </tr> <tr> <td>Payee</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收款人</td> </tr> <tr> <td>Reviewer</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>复核人</td> </tr> <tr> <td>InvoiceDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>开票日期</td> </tr> <tr> <td>CurrencyType</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>币种</td> </tr> <tr> <td>State</td> <td>int(11)</td> <td>YES</td> <td></td> <td>发票状态(未开票，已开票未邮寄，已开票已邮寄）</td> </tr> <tr> <td>Remark</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>备注</td> </tr> <tr> <td>TransSingleNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>快递单号</td> </tr> <tr> <td>TransCompany</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></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>InVoiceNature</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>发票性质：区分红字发票与非红字发票,'1387':红字发票.'1391':销售发票外部</td> </tr> <tr> <td>InvoiceSource</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>发票来源,'ORDER ENTRY'表正常发票</td> </tr> <tr> <td>OriginalNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>红字发票对应的原发票号</td> </tr> <tr> <td>MailDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>邮寄时间</td> </tr> <tr> <td>InvalidDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>发票作废日期</td> </tr> </tbody> </table>