付款申请单来源单据明细DTO
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
voucherCanReqAmount (T+13.0) | 单据可申请金额(本币) | decimal | 13 | True | |
voucherCode (T+13.0) | 单据编号 | nvarchar | 30 | True | |
SourceVoucherCode (T+13.0) | 来源单号 | nvarchar | 30 | True | |
allowances (T+13.0) | 折让(本币) | decimal | 13 | True | |
detailID (T+13.0) | 来源单据明细存货ID | int | 4 | True | |
detailName (T+13.0) | 来源单据明细存货名称 | nvarchar | 200 | True | |
idperson (T+13.0) | 来源单据业务员ID | int | 4 | True | |
sourceVoucherID (T+13.0) | 来源单据id | int | 4 | True | |
purchaseOrderCode (T+13.0) | 采购订单号 | nvarchar | 30 | True | |
origVoucherCanReqAmount (T+13.0) | 单据可申请金额 | decimal | 13 | True | |
origVoucherReqAmountThisTime (T+13.0) | 单据本次申请金额 | decimal | 13 | True | |
voucherAmount (T+13.0) | 单据金额(本币) | decimal | 13 | True | |
origAccPayoffAmount (T+13.0) | 累计支付金额 | decimal | 13 | True | |
depositAmount (T+13.0) | 原单定金金额(本币) | decimal | 13 | True | |
exchangeRate (T+13.0) | 汇率 | decimal | 13 | True | |
idarapPrepaymentRequisitionDTO (T+13.0) | 关联付款申请单主DTO的ID | int | 4 | True | |
iddetailProject (T+13.0) | 来源单据明细项目ID | int | 4 | True | |
voucherID (T+13.0) | 单据ID | int | 4 | True | |
origVoucherAccPayoffAmount (T+13.0) | 单据累计支付金额 | decimal | 13 | True | |
code (T+13.0) | 编号 | nvarchar | 30 | True | |
origAmount (T+13.0) | 来源单据金额 | decimal | 13 | True | |
VoucherEffectiveTimeStamp (T+13.0) | VoucherEffectiveTimeStamp | nvarchar | 64 | True | |
idproject (T+13.0) | 来源单据项目ID | int | 4 | True | |
saleOrderCode (T+13.0) | 销售订单号 | nvarchar | 30 | True | |
origDepositAmount (T+13.0) | 原单定金金额 | decimal | 13 | True | |
vouchertimestamp (T+13.0) | VoucherTimeStamp | nvarchar | 64 | True | |
voucherDetailID (T+13.0) | 单据明细ID | int | 4 | True | |
amount (T+13.0) | 来源单据金额(本币) | decimal | 13 | True | |
voucherAllowances (T+13.0) | 单据折让(本币) | decimal | 13 | True | |
sourceOrderID (T+13.0) | 源头订单ID | int | 4 | True | |
idsourceOrderType (T+13.0) | 源头订单类型ID | int | 4 | True | |
reqAmountThisTime (T+13.0) | 本次申请金额(本币) | decimal | 13 | True | |
origVoucherAmount (T+13.0) | 单据金额 | decimal | 13 | True | |
voucherAccPayoffAmount (T+13.0) | 单据累计支付金额(本币) | decimal | 13 | True | |
origCanReqAmount (T+13.0) | 可申请金额 | decimal | 13 | True | |
saleOrderID (T+13.0) | 销售订单ID | int | 4 | True | |
voucherReqAmountThisTime (T+13.0) | 单据本次申请金额(本币) | decimal | 13 | True | |
voucherDate (T+13.0) | 单据日期 | datetime | 8 | True | |
origReqAmountThisTime (T+13.0) | 本次申请金额 | decimal | 13 | True | |
origVoucherAllowances (T+13.0) | 单据折让 | decimal | 13 | True | |
id (T+13.0) | 主键 | int | 4 | False | |
detailCode (T+13.0) | 来源单据明细存货编码 | nvarchar | 50 | True | |
idcurrency (T+13.0) | 来源单据币种ID | int | 4 | True | |
idsourceVoucherType (T+13.0) | 来源单据的来源单据类型ID | int | 4 | True | |
origAllowances (T+13.0) | 折让 | decimal | 13 | True | |
ts (T+13.0) | 分布时间戳 | timestamp | 8 | True | |
canReqAmount (T+13.0) | 可申请金额(本币) | decimal | 13 | True | |
idvouchertype (T+13.0) | 来源单据单据类型 | int | 4 | True | |
purchaseOrderID (T+13.0) | 采购订单ID | int | 4 | True | |
iddepartment (T+13.0) | 来源单据部门ID | int | 4 | True | |
sourceOrderCode (T+13.0) | 源头订单号 | nvarchar | 30 | True | |
arrivalDate (T+13.0) | 付款到期日 | datetime | 8 | True | |
accPayoffAmount (T+13.0) | 累计支付金额(本币) | decimal | 13 | True |
Copyright 2019 Chanjet Inc.