现金银行日记账DTO
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| pubuserdefdecm2 (T+12.1) | 数值公用自定义项2 | decimal | 13 | True | |
| iscarriedforwardin (T+12.1) | 是否结转来的单据 | tinyint | 1 | True | |
| sourceVoucherCode (T+12.1) | 来源单据编号 | nvarchar | 50 | True | |
| period (T+12.1) | 期间 | decimal | 13 | True | |
| sourceVoucherID (T+12.1) | 来源单据ID | int | 4 | True | |
| makerid (T+12.1) | 制单人ID | int | 4 | True | |
| exchangeCr (T+12.1) | 贷(支出)汇率 | decimal | 13 | True | |
| summary (T+12.1) | 摘要 | nvarchar | 1024 | True | |
| priuserdefdecm1 (T+12.1) | 数值专用自定义项1 | decimal | 13 | True | |
| idperson (T+12.1) | 经手人ID | int | 4 | True | |
| IdOtherDepartment (T+12.1) | 对方部门ID | int | 4 | True | |
| billDate (T+12.1) | 票据日期 | datetime | 8 | True | |
| priuserdefnvc4 (T+12.1) | 字符专用自定义项4 | nvarchar | 500 | True | |
| amountCr (T+12.1) | 贷方本币 | decimal | 13 | True | |
| direction (T+12.1) | 借贷方向 | int | 4 | True | |
| iscarriedforwardout (T+12.1) | 是否已结转 | tinyint | 1 | True | |
| madedate (T+12.1) | 制单日期 | datetime | 8 | True | |
| sourceVoucherDate (T+12.1) | 单据日期 | datetime | 8 | True | |
| IdExpenseItem (T+12.1) | 费用档案ID | int | 4 | True | |
| auditor (T+12.1) | 审核人 | nvarchar | 50 | True | |
| billCode (T+12.1) | 票号 | nvarchar | 50 | True | |
| isPushAuto (T+12.1) | 是否推式生成 | tinyint | 1 | True | |
| idproject (T+12.1) | 项目ID | int | 4 | True | |
| ID (T+12.1) | 主键 | int | 4 | False | |
| idbankaccount (T+12.1) | 账号ID | int | 4 | True | |
| voucherdate (T+12.1) | 单据日期 | datetime | 8 | True | |
| isAuto (T+12.1) | 是否自动生成 | tinyint | 1 | True | |
| tickcode (T+12.1) | 勾对号 | nvarchar | 50 | True | |
| sourceMultiSettleID (T+12.1) | 来源多结算ID | int | 4 | True | |
| balance (T+12.1) | 本币余额 | decimal | 13 | True | |
| docid (T+12.1) | 凭证ID | nvarchar | 36 | True | |
| auditeddate (T+12.1) | 审核日期 | datetime | 8 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| reviser (T+12.1) | 修改人 | nvarchar | 50 | True | |
| voucherstate (T+12.1) | 单据状态 | int | 4 | True | |
| pubuserdefnvc4 (T+12.1) | 字符公用自定义项4 | nvarchar | 500 | True | |
| idProDepartment (T+12.1) | 经办部门ID | int | 4 | True | |
| origBalance (T+12.1) | 余额 | decimal | 13 | True | |
| pubuserdefnvc1 (T+12.1) | 字符公用自定义项1 | nvarchar | 500 | True | |
| tickdate (T+12.1) | 勾对日期 | datetime | 8 | True | |
| ismodifiedcode (T+12.1) | 是否手工修改单据编码 | tinyint | 1 | True | |
| maker (T+12.1) | 制单人 | nvarchar | 50 | True | |
| origAmountDr (T+12.1) | 借方原币 | decimal | 13 | True | |
| IdIncome (T+12.1) | 收入档案ID | int | 4 | True | |
| pubuserdefnvc2 (T+12.1) | 字符公用自定义项2 | nvarchar | 500 | True | |
| docclassno (T+12.1) | 凭证字号 | nvarchar | 50 | True | |
| pubuserdefdecm3 (T+12.1) | 数值公用自定义项3 | decimal | 13 | True | |
| priuserdefnvc3 (T+12.1) | 字符专用自定义项3 | nvarchar | 500 | True | |
| IdAccount (T+12.1) | 科目ID | int | 4 | True | |
| auditorid (T+12.1) | 审核人ID | int | 4 | True | |
| priuserdefdecm3 (T+12.1) | 数值自定义项3 | decimal | 13 | True | |
| memo (T+12.1) | 备注 | nvarchar | 200 | True | |
| exchangeDr (T+12.1) | 借(收入)汇率 | decimal | 13 | True | |
| idOtherPartner (T+12.1) | 对方单位ID | int | 4 | True | |
| priuserdefnvc1 (T+12.1) | 字符专用自定义项1 | nvarchar | 500 | True | |
| origAmountCr (T+12.1) | 贷方 | decimal | 13 | True | |
| IdOtherBankAccount (T+12.1) | 对方账号ID | int | 4 | True | |
| tickstate (T+12.1) | 勾对状态 | int | 4 | True | |
| idsettlestyle (T+12.1) | 结算方式ID | int | 4 | True | |
| pubuserdefdecm1 (T+12.1) | 数值公用自定义项1 | decimal | 13 | True | |
| pubuserdefnvc3 (T+12.1) | 字符公用自定义项3 | nvarchar | 500 | True | |
| priuserdefdecm4 (T+12.1) | 数值自定义项4 | decimal | 13 | True | |
| amountDr (T+12.1) | 借方本币 | decimal | 13 | True | |
| IdOtherProject (T+12.1) | 对方项目ID | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| IdMarketingOrgan (T+12.1) | 所属营销机构ID | int | 4 | True | |
| priuserdefdecm2 (T+12.1) | 数值专用自定义项2 | decimal | 13 | True | |
| priuserdefnvc2 (T+12.1) | 字符专用自定义项2 | nvarchar | 500 | True | |
| idsourcevouchertype (T+12.1) | 来源单据类型ID | int | 4 | True | |
| createdtime (T+12.1) | 创建时间 | datetime | 8 | True | |
| sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
| pubuserdefdecm4 (T+12.1) | 数值公用自定义项4 | decimal | 13 | True | |
| account (T+12.1) | 账号 | nvarchar | 50 | True | |
| year (T+12.1) | 年 | int | 4 | True |
Copyright 2019 Chanjet Inc.