biz_cashflow

<h4>biz_cashflow</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>PaymentModeCode</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收款类型,DH：电汇,YHCDDZ:电子银行承兑汇票,SYCDDZ:电子商业承兑汇票,YHCDZZ：纸质银行承兑汇票,SYCDZZ：纸质商业承兑汇票</td> </tr> <tr> <td>TransId</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收款流水号</td> </tr> <tr> <td>BillNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>共享系统票据号</td> </tr> <tr> <td>TransType</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>交易类型100：货款</td> </tr> <tr> <td>BankTransNum</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>银行交易流水号</td> </tr> <tr> <td>DebitCreditFlag</td> <td>varchar(1)</td> <td>YES</td> <td></td> <td>收支方向</td> </tr> <tr> <td>OurBank</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>本方开户行</td> </tr> <tr> <td>OurBankAccountNum</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>本方账号</td> </tr> <tr> <td>OurBankAccount</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>本方户名</td> </tr> <tr> <td>OtherBankAccountNum</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>对方帐号</td> </tr> <tr> <td>OtherBankAccount</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>对方户名</td> </tr> <tr> <td>Remarks</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>备注</td> </tr> <tr> <td>ItemAbstract</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>摘要</td> </tr> <tr> <td>ItemPurpose</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>用途</td> </tr> <tr> <td>BankTransDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>交易日期</td> </tr> <tr> <td>Amount</td> <td>double(15,2)</td> <td>YES</td> <td></td> <td>交易金额</td> </tr> <tr> <td>CurrencyCode</td> <td>varchar(30)</td> <td>YES</td> <td></td> <td>币种</td> </tr> <tr> <td>BillNumber</td> <td>varchar(32)</td> <td>YES</td> <td></td> <td>票据号</td> </tr> <tr> <td>Ticketer</td> <td>varchar(32)</td> <td>YES</td> <td></td> <td>出票人</td> </tr> <tr> <td>TicketAcc</td> <td>varchar(60)</td> <td>YES</td> <td></td> <td>出票人帐号</td> </tr> <tr> <td>TicketBank</td> <td>varchar(32)</td> <td>YES</td> <td></td> <td>出票人开户银行行号</td> </tr> <tr> <td>TicketUnit</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>出票人开户银行名称</td> </tr> <tr> <td>Acceptor</td> <td>varchar(60)</td> <td>YES</td> <td></td> <td>承兑人</td> </tr> <tr> <td>AcceptorAcc</td> <td>varchar(32)</td> <td>YES</td> <td></td> <td>承兑人账号</td> </tr> <tr> <td>ReqNM</td> <td>varchar(60)</td> <td>YES</td> <td></td> <td>前一手持票人</td> </tr> <tr> <td>AcceptorBankNo</td> <td>varchar(32)</td> <td>YES</td> <td></td> <td>承兑人开户行行号</td> </tr> <tr> <td>AcceptorBankName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>承兑人开户行名称</td> </tr> <tr> <td>TicketDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>出票日期</td> </tr> <tr> <td>AcceptanceBillEnddate</td> <td>datetime</td> <td>YES</td> <td></td> <td>到期日期</td> </tr> <tr> <td>BillStatus</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>票据状态,18-待签收，19-已签收</td> </tr> <tr> <td>BoeStatus</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>共享系统单据状态</td> </tr> <tr> <td>ErpSyncStatus</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>共享系统凭证状态</td> </tr> <tr> <td>PaymentId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>录款id</td> </tr> <tr> <td>ClaimMessage</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>驳回或撤回原因</td> </tr> <tr> <td>Status</td> <td>int(11)</td> <td>YES</td> <td></td> <td>状态</td> </tr> <tr> <td>EasStatus</td> <td>int(4)</td> <td>YES</td> <td></td> <td>EAS同步状态</td> </tr> <tr> <td>EasMsg</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>EAS同步信息</td> </tr> <tr> <td>SyncStatus</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>单据同步状态</td> </tr> <tr> <td>SyncInfo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>单据同步信息</td> </tr> <tr> <td>DenyFlag</td> <td>int(4)</td> <td>YES</td> <td></td> <td>拒收标志,1拒收</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>CreateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>LastUpdateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table>