ARAP_Cancel_SecondDetail Table

Summary

应收应付冲销明细DTO

Columns

Column Name	Description	Datatype	Length	Allow Nulls
ts (T+12.1)	分布时间戳	timestamp	8	False
IdBusiType (T+12.1)	业务类型ID	int	4	True
voucherID (T+12.1)	单据ID	int	4	True
voucherDate (T+12.1)	单据日期	datetime	8	True
idvouchertype (T+12.1)	单据类型ID	int	4	True
IdMember (T+12.1)	会员ID	int	4	True
createdtime (T+12.1)	创建日期	datetime	8	True
Allowances (T+12.1)	折让(本币）	decimal	13	True
sourceorderid (T+12.1)	源头订单ID	int	4	True
origVoucherAmount (T+12.1)	单据金额	decimal	13	True
idnosettlepartner (T+12.1)	客户ID	int	4	True
ID (T+12.1)	主键	int	4	False
saleordercode (T+12.1)	销售订单号	nvarchar	50	True
idSettlePartner (T+12.1)	结算客户ID	int	4	True
origVoucherNoSettleAmount (T+12.1)	单据未结算金额	decimal	13	True
SourceVoucherMemo (T+12.1)	来源单据备注	nvarchar	200	True
arrivalDate (T+12.1)	到期日	datetime	8	True
currentAmount (T+12.1)	冲销金额(本币)	decimal	13	True
orignosettleamount (T+12.1)	未结算金额	decimal	13	True
Amount (T+12.1)	金额	decimal	13	True
exchangeRate (T+12.1)	汇率	decimal	13	True
origCurrentAmount (T+12.1)	冲销金额	decimal	13	True
origAmount (T+12.1)	原币金额	decimal	13	True
idArapCancelDTO (T+12.1)	核销类型ID	int	4	True
code (T+12.1)	编号	nvarchar	30	True
voucherDetailID (T+12.1)	单据明细ID	int	4	True
vouchertimestamp (T+12.1)	时间戳	nvarchar	32	True
idcurrency (T+12.1)	币种ID	int	4	True
voucherCode (T+12.1)	单据编号	nvarchar	30	True
nosettleamount (T+12.1)	未结算金额(本币)	decimal	13	True
OrigAllowances (T+12.1)	折让	decimal	13	True
sourceordercode (T+12.1)	源头订单号	nvarchar	50	True
saleorderid (T+12.1)	销售订单ID	int	4	True
detailID (T+12.1)	明细ID	int	4	True
idsourceordertype (T+12.1)	来源单据类型ID	int	4	True
idperson (T+12.1)	业务员ID	int	4	True
detailName (T+12.1)	明细名称	nvarchar	200	True
idproject (T+12.1)	项目ID	int	4	True
detailCode (T+12.1)	明细编码	nvarchar	50	True
IdDetailProject (T+12.1)	明细项目ID	int	4	True
iddepartment (T+12.1)	部门ID	int	4	True

Send feedback

ARAP_Cancel_SecondDetail Table (ARAP 往来现金) [T+12.1]

Summary

Columns