现金银行帐DTO
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| TotalDrAmount (T+12.1) | 借（收入）累计本币 | decimal | 13 | True | |
| Summary (T+12.2) | 摘要 | nvarchar | 1024 | True | |
| sourceVoucherID (T+12.1) | 来源单据ID | int | 4 | True | |
| TotalCrAmount (T+12.1) | 贷（支出）累计本币 | decimal | 13 | True | |
| iscarriedforwardin (T+12.1) | 是否结转来的单据 | tinyint | 1 | True | |
| ispullin (T+12.1) | 是否引入到手工日记账 | tinyint | 1 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| sourceVoucherAuditor (T+12.1) | 来源单据审核人 | nvarchar | 50 | True | |
| year (T+12.1) | 年 | int | 4 | True | |
| IdExpenseItem (T+12.1) | 费用档案ID | int | 4 | True | |
| inexchangerate (T+12.1) | 收入汇率 | decimal | 13 | True | |
| sourceVoucherCreatedTime (T+12.1) | 来源单据创建日期 | datetime | 8 | True | |
| sourceVoucherDate (T+12.1) | 单据日期 | datetime | 8 | True | |
| outamount (T+12.1) | 出库金额 | decimal | 13 | True | |
| OrigTotalCrAmount (T+12.1) | 贷（支出）累计金额 | decimal | 13 | True | |
| idproject (T+12.1) | 项目ID | int | 4 | True | |
| sourceVoucherMemo (T+12.1) | 来源单据备注 | nvarchar | 200 | True | |
| idsourcevouchertype (T+12.1) | 来源单据类型ID | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | True | |
| origAmount (T+12.1) | 原币金额 | decimal | 13 | True | |
| origOutAmount (T+12.1) | 支出金额 | decimal | 13 | True | |
| amount (T+12.1) | 金额 | decimal | 13 | True | |
| iscarriedforwardout (T+12.1) | 是否已结转 | tinyint | 1 | True | |
| sourceVoucherDocumentCode (T+12.1) | 来源单据票据号 | nvarchar | 30 | True | |
| IdMarketingOrgan (T+12.1) | 所属营销机构ID | int | 4 | True | |
| sourceVoucherMaker (T+12.1) | 来源单据制单人 | nvarchar | 50 | True | |
| idsourcevoucherbusinesstype (T+12.1) | 来源单据业务类型ID | int | 4 | True | |
| exchangerate (T+12.1) | 汇率 | decimal | 13 | True | |
| outexchangerate (T+12.1) | 转出汇率 | decimal | 13 | True | |
| period (T+12.1) | 期间 | int | 4 | True | |
| origInAmount (T+12.1) | 转入金额 | decimal | 13 | True | |
| IdOtherBankAccount (T+12.1) | 对方账号ID | int | 4 | True | |
| idsettlestyle (T+12.1) | 结算方式ID | int | 4 | True | |
| idbankaccount (T+12.1) | 账号ID | int | 4 | True | |
| sourceVoucherCode (T+12.1) | 来源单据编号 | nvarchar | 30 | True | |
| inamount (T+12.1) | 收入金额(本币) | decimal | 13 | True | |
| docId (T+12.1) | 凭证ID | nvarchar | 36 | True | |
| isPeriodBeginning (T+12.1) | 是否期初 | tinyint | 1 | True | |
| idperson (T+12.1) | 业务员ID | int | 4 | True | |
| createdtime (T+12.1) | 创建时间 | datetime | 8 | True | |
| IdIncome (T+12.1) | 收入档案ID | int | 4 | True | |
| SourceVoucherMakerId (T+12.1) | 制单人ID | int | 4 | True | |
| idpartner (T+12.1) | 往来单位ID | int | 4 | True | |
| iddepartment (T+12.1) | 部门ID | int | 4 | True | |
| OrigTotalDrAmount (T+12.1) | 借（收入）累计金额 | decimal | 13 | True | |
| sourceMultiSettleID (T+12.1) | 来源多结算ID | int | 4 | True | |
| SourceVoucherAuditDate (T+12.2) | 来源单据审核日期 | datetime | 8 | True |
Copyright 2019 Chanjet Inc.