biz_reimbursement

<h4>biz_reimbursement EAS报账单</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>No</td> <td>varchar(20)</td> <td>YES</td> <td></td> <td>单据号</td> </tr> <tr> <td>BoeNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>共享系统单据号</td> </tr> <tr> <td>Type</td> <td>int(10)</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>Amount</td> <td>double(15,2)</td> <td>YES</td> <td></td> <td>金额</td> </tr> <tr> <td>BoeStatus</td> <td>varchar(10)</td> <td>YES</td> <td></td> <td>共享系统单据状态</td> </tr> <tr> <td>ErpSyncStatus</td> <td>varchar(10)</td> <td>YES</td> <td></td> <td>共享系统凭证状态</td> </tr> <tr> <td>PaymentStatus</td> <td>varchar(10)</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>DealerId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>经销商ID(预付款转移时存转出经销商ID)</td> </tr> <tr> <td>SrcDealerPaymentId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>转出经销商录款ID</td> </tr> <tr> <td>DistDealerPaymentId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>转入经销商录款ID</td> </tr> <tr> <td>BudgetCode</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>预算号</td> </tr> <tr> <td>BankBranchName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收款银行</td> </tr> <tr> <td>BankAccountNum</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收款账号</td> </tr> <tr> <td>BankAccountName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>收款人</td> </tr> <tr> <td>BankUnitedCode</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>联行号</td> </tr> <tr> <td>BankAccountType</td> <td>int(4)</td> <td>YES</td> <td></td> <td>支付类型1 对公,2 对私</td> </tr> <tr> <td>BankProvince</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>省</td> </tr> <tr> <td>BankCity</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>城市</td> </tr> <tr> <td>EmployeeNo</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>员工工号</td> </tr> <tr> <td>EmployeeName</td> <td>varchar(255)</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>CreateBy</td> <td>bigint(20)</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>bigint(20)</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>