应收应付辅助明细账DTO
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| isCarriedForwardOut (T+12.1) | 是否已结转 | tinyint | 1 | True | |
| detailPubuserdefnvc2 (T+12.1) | 体自定义项共有2 | nvarchar | 500 | True | |
| headPriuserdefnvc5 (T+12.1) | 头自定义项私有5 | nvarchar | 500 | True | |
| saleorderid (T+12.1) | 销售订单ID | int | 4 | True | |
| origAmount (T+12.1) | 原币金额 | decimal | 13 | True | |
| detailPubuserdefnvc1 (T+12.1) | 体自定义项共有1 | nvarchar | 500 | True | |
| detailID (T+12.1) | 明细ID | int | 4 | True | |
| detailCode (T+12.1) | 明细编码 | nvarchar | 50 | True | |
| extendFlag (T+12.1) | 扩展标志 | int | 4 | True | |
| headPubuserdefnvc2 (T+12.1) | 头自定义项公有2 | nvarchar | 500 | True | |
| isArFlag (T+12.1) | 是否应收标志 | tinyint | 1 | True | |
| detailName (T+12.1) | 明细名称 | nvarchar | 200 | True | |
| origSettleAmount (T+12.1) | 原币结算金额 | decimal | 13 | True | |
| headPubuserdefdecm6 (T+12.1) | 头自定义项数字公有6 | decimal | 13 | True | |
| auditBussinessFlag (T+12.1) | 业务是否审核 | tinyint | 1 | True | |
| voucherDetailID (T+12.1) | 单据明细ID | int | 4 | True | |
| headPriuserdefdecm1 (T+12.1) | 头自定义项数字私有1 | decimal | 13 | True | |
| headPubuserdefnvc3 (T+12.1) | 头自定义项公有3 | nvarchar | 500 | True | |
| iddepartment (T+12.1) | 部门ID | int | 4 | True | |
| year (T+12.1) | 年 | int | 4 | True | |
| bussinessFlag (T+12.1) | 业务标志 | nvarchar | 50 | True | |
| detailPubuserdefdecm4 (T+12.1) | 体自定义项数字共有4 | decimal | 13 | True | |
| registerDate (T+12.1) | 记帐日期 | datetime | 8 | True | |
| detailPubuserdefdecm2 (T+12.1) | 体自定义项数字共有2 | decimal | 13 | True | |
| headPubuserdefdecm4 (T+12.1) | 头自定义项数字公有4 | decimal | 13 | True | |
| headPubuserdefnvc6 (T+12.1) | 头自定义项公有6 | nvarchar | 500 | True | |
| idproject (T+12.1) | 项目ID | int | 4 | True | |
| origInAllowances (T+12.1) | 其中折让 | decimal | 13 | True | |
| auditFlag (T+12.1) | 是否审核 | tinyint | 1 | True | |
| headPriuserdefdecm5 (T+12.1) | 头自定义项数字私有5 | decimal | 13 | True | |
| detailPubuserdefdecm3 (T+12.1) | 体自定义项数字共有3 | decimal | 13 | True | |
| prepayFlag (T+12.1) | 是否预收预付 | tinyint | 1 | True | |
| headPriuserdefdecm2 (T+12.1) | 头自定义项数字私有2 | decimal | 13 | True | |
| arrivalDate (T+12.1) | 到期日 | datetime | 8 | True | |
| headPriuserdefdecm4 (T+12.1) | 头自定义项数字私有4 | decimal | 13 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| idpartner (T+12.1) | 结算往来单位ID | int | 4 | True | |
| headPubuserdefnvc5 (T+12.1) | 头自定义项公有5 | nvarchar | 500 | True | |
| detailtype (T+12.1) | 明细类型 | nvarchar | 50 | True | |
| cashAmount (T+12.1) | 现结金额(本币) | decimal | 13 | True | |
| headPubuserdefdecm2 (T+12.1) | 头自定义项数字公有2 | decimal | 13 | True | |
| amount (T+12.1) | 金额 | decimal | 13 | True | |
| headPriuserdefnvc1 (T+12.1) | 头自定义项私有1 | nvarchar | 500 | True | |
| idsourceordertype (T+12.1) | 来源单据类型ID | int | 4 | True | |
| detailPriuserdefdecm3 (T+12.1) | 体自定义项数字私有3 | decimal | 13 | True | |
| sourceordercode (T+12.1) | 源头订单号 | nvarchar | 50 | True | |
| headPubuserdefdecm1 (T+12.1) | 头自定义项数字公有1 | decimal | 13 | True | |
| headPriuserdefdecm6 (T+12.1) | 头自定义项数字私有6 | decimal | 13 | True | |
| detailPriuserdefdecm1 (T+12.1) | 体自定义项数字私有1 | decimal | 13 | True | |
| businessID (T+12.1) | 业务类型对应单据ID | int | 4 | True | |
| businessCode (T+12.1) | 业务类型处理编码 | nvarchar | 50 | True | |
| idperson (T+12.1) | 业务员ID | int | 4 | True | |
| idnosettlepartner (T+12.1) | 客户ID | int | 4 | True | |
| vouchertimestamp (T+12.1) | 时间戳 | nvarchar | 50 | True | |
| detailPubuserdefdecm1 (T+12.1) | 体自定义项数字共有1 | decimal | 13 | True | |
| headPubuserdefnvc4 (T+12.1) | 头自定义项公有4 | nvarchar | 500 | True | |
| detailPriuserdefnvc4 (T+12.1) | 体自定义项私有4 | nvarchar | 500 | True | |
| voucherDate (T+12.1) | 单据日期 | datetime | 8 | True | |
| IdMember (T+12.1) | 会员ID | int | 4 | True | |
| isCarriedForwardIn (T+12.1) | 是否结转来的单据 | tinyint | 1 | True | |
| idvouchertype (T+12.1) | 单据类型ID | int | 4 | True | |
| IdDetailProject (T+12.1) | 明细项目ID | int | 4 | True | |
| voucherID (T+12.1) | 单据ID | int | 4 | True | |
| headPubuserdefnvc1 (T+12.1) | 头自定义项公有1 | nvarchar | 500 | True | |
| flag (T+12.1) | 是否业务系统产生标志 | int | 4 | True | |
| headPriuserdefdecm3 (T+12.1) | 头自定义项数字私有3 | decimal | 13 | True | |
| saleordercode (T+12.1) | 销售订单号 | nvarchar | 50 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| detailPubuserdefnvc3 (T+12.1) | 体自定义项共有3 | nvarchar | 500 | True | |
| period (T+12.1) | 期间 | int | 4 | True | |
| detailPriuserdefnvc2 (T+12.1) | 体自定义项私有2 | nvarchar | 500 | True | |
| detailPubuserdefnvc4 (T+12.1) | 体自定义项共有4 | nvarchar | 500 | True | |
| createdtime (T+12.1) | 创建日期 | datetime | 8 | True | |
| IdMarketingOrgan (T+12.1) | 所属营销机构ID | int | 4 | True | |
| detailPriuserdefnvc3 (T+12.1) | 体自定义项私有3 | nvarchar | 500 | True | |
| exchangeRate (T+12.1) | 汇率 | decimal | 13 | True | |
| headPubuserdefdecm5 (T+12.1) | 头自定义项数字公有5 | decimal | 13 | True | |
| idcurrency (T+12.1) | 币种ID | int | 4 | True | |
| detailPriuserdefdecm4 (T+12.1) | 体自定义项数字私有4 | decimal | 13 | True | |
| headPriuserdefnvc4 (T+12.1) | 头自定义项私有4 | nvarchar | 500 | True | |
| sourceorderid (T+12.1) | 源头订单ID | int | 4 | True | |
| voucherCode (T+12.1) | 单据编号 | nvarchar | 30 | True | |
| idarapvouchertype (T+12.1) | 当前单据类型ID | int | 4 | True | |
| idbusitype (T+12.1) | 业务类型ID | int | 4 | True | |
| memo (T+12.1) | 备注 | nvarchar | 200 | True | |
| inAllowances (T+12.1) | 其中折让(本币) | decimal | 13 | True | |
| origCashAmount (T+12.1) | 现结金额 | decimal | 13 | True | |
| settleAmount (T+12.1) | 已收已付金额(本币) | decimal | 13 | True | |
| docId (T+12.1) | 凭证ID | nvarchar | 36 | True | |
| headPubuserdefdecm3 (T+12.1) | 头自定义项数字公有3 | decimal | 13 | True | |
| headPriuserdefnvc3 (T+12.1) | 头自定义项私有3 | nvarchar | 500 | True | |
| detailPriuserdefnvc1 (T+12.1) | 体自定义项私有1 | nvarchar | 500 | True | |
| headPriuserdefnvc2 (T+12.1) | 头自定义项私有2 | nvarchar | 500 | True | |
| headPriuserdefnvc6 (T+12.1) | 头自定义项私有6 | nvarchar | 500 | True | |
| detailPriuserdefdecm2 (T+12.1) | 体自定义项数字私有2 | decimal | 13 | True |
Copyright 2019 Chanjet Inc.