收付款核销明细DTO
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| voucherCode (T+12.1) | 单据编号 | nvarchar | 30 | True | |
| sourceorderid (T+12.1) | 源头订单ID | int | 4 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| idperson (T+12.1) | 业务员ID | int | 4 | True | |
| ExternalVoucherCode (T+13.0) | 外部单据号 | nvarchar | 50 | True | |
| vouchertimestamp (T+12.1) | 时间戳 | nvarchar | 64 | True | |
| VoucherAmount (T+13.0) | 单据金额(本币) | decimal | 13 | True | |
| saleordercode (T+12.1) | 销售订单号 | nvarchar | 30 | True | |
| sourcevouchermemo (T+12.1) | 来源单据备注 | nvarchar | 200 | True | |
| Amount (T+13.0) | 金额(本币) | decimal | 13 | True | |
| payReqVoucherDetailID (T+13.0) | 付款申请单明细ID | int | 4 | True | |
| idproject (T+12.1) | 项目ID | int | 4 | True | |
| detailCode (T+12.1) | 明细编码 | nvarchar | 50 | True | |
| IdBusiType (T+12.1) | 业务类型 | int | 4 | True | |
| exchangeRate (T+12.1) | 汇率 | decimal | 13 | True | |
| origAmount (T+12.1) | 原币金额 | decimal | 13 | True | |
| idcurrency (T+12.1) | 币种ID | int | 4 | True | |
| currentAmount (T+12.1) | 冲销金额(本币) | decimal | 13 | True | |
| sourceordercode (T+12.1) | 源头订单号 | nvarchar | 30 | True | |
| origNoSettleAmount (T+12.1) | 未结算金额 | decimal | 13 | True | |
| detailID (T+12.1) | 明细ID | int | 4 | True | |
| saleorderid (T+12.1) | 销售订单ID | int | 4 | True | |
| allowancesAmount (T+12.1) | 折让分摊(本币) | decimal | 13 | True | |
| voucherDate (T+12.1) | 单据日期 | datetime | 8 | True | |
| idpartner (T+12.1) | 往来单位ID | int | 4 | True | |
| origVoucherAmount (T+12.1) | 单据金额 | decimal | 13 | True | |
| detailName (T+12.1) | 明细名称 | nvarchar | 200 | True | |
| voucherDetailID (T+12.1) | 单据明细ID | int | 4 | True | |
| IdMember (T+12.1) | 会员ID | int | 4 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| payReqVoucherCode (T+13.0) | 付款申请单编号 | nvarchar | 30 | True | |
| idsourceordertype (T+12.1) | 来源单据类型ID | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | True | |
| idArapReceivePaymentDTO (T+12.1) | 表头ID | int | 4 | True | |
| arrivalDate (T+12.1) | 到期日 | datetime | 8 | True | |
| voucherID (T+12.1) | 单据ID | int | 4 | True | |
| origAllowancesAmount (T+12.1) | 折让分摊 | decimal | 13 | True | |
| payReqVoucherID (T+13.0) | 付款申请单ID | int | 4 | True | |
| idvouchertype (T+12.1) | 单据类型ID | int | 4 | True | |
| idnosettlepartner (T+12.1) | 客户ID | int | 4 | True | |
| origCurrentAmount (T+12.1) | 冲销金额 | decimal | 13 | True | |
| origVoucherNoSettleAmount (T+12.1) | 单据未结算金额 | decimal | 13 | True | |
| iddepartment (T+12.1) | 部门ID | int | 4 | True | |
| IdDetailProject (T+12.1) | 明细项目ID | int | 4 | True |
Copyright 2019 Chanjet Inc.