核销明细账DTO
能够参与往来核销的数据初始放的地方,来源凭证和科目期初余额
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
idexauxacc9 (T+12.1) | 扩展辅助项9 | int | 4 | True | |
idcurrency (T+12.1) | 币种Id | int | 4 | False | |
billNo (T+12.1) | 票据号 | nvarchar | 200 | True | |
writeoffjournaltype (T+12.1) | 核销明细账类型 | int | 4 | True | |
iscarriedforwardin (T+12.1) | 是否结转来的单据 | tinyint | 1 | True | |
idauxAccInventory (T+12.1) | 存货id | int | 4 | True | |
dueDate (T+12.1) | 到期日 | datetime | 8 | True | |
idexauxacc6 (T+12.1) | 扩展辅助项6 | int | 4 | True | |
bizdate (T+12.1) | 业务日期 | datetime | 8 | True | |
idauxperiodbegindetail (T+12.1) | 科目辅助明细id | int | 4 | True | |
idexauxacc1 (T+12.1) | 扩展辅助项1 | int | 4 | True | |
summary (T+12.1) | 摘要 | nvarchar | 200 | True | |
origamount (T+12.1) | 原币金额 | decimal | 13 | True | |
idauxaccproject (T+12.1) | 项目id | int | 4 | True | |
price (T+12.1) | 单价 | decimal | 13 | True | |
ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
docmadedate (T+12.1) | 凭证日期 | datetime | 8 | True | |
idauxAccCustomer (T+12.1) | 往来单位id | int | 4 | True | |
iddocType (T+12.1) | 凭证类别id | int | 4 | True | |
idexauxacc5 (T+12.1) | 扩展辅助项5 | int | 4 | True | |
id (T+12.1) | 主键 | int | 4 | False | |
idexauxacc10 (T+12.1) | 扩展辅助项10 | int | 4 | True | |
idexauxacc2 (T+12.1) | 扩展辅助项2 | int | 4 | True | |
idexauxacc7 (T+12.1) | 扩展辅助项7 | int | 4 | True | |
iscarriedforwardout (T+12.1) | 是否已结转 | tinyint | 1 | True | |
idaccount (T+12.1) | 科目id | int | 4 | True | |
amount (T+12.1) | 金额 | decimal | 13 | True | |
idexauxacc4 (T+12.1) | 扩展辅助项4 | int | 4 | True | |
writeoffableorigamount (T+12.1) | 可核销原币金额 | decimal | 13 | True | |
writeoffedorigamount (T+12.1) | 已核销原币金额 | decimal | 13 | True | |
idauxAccDepartment (T+12.1) | 部门id | int | 4 | True | |
writeoffedamount (T+12.1) | 已核销本币金额 | decimal | 13 | True | |
docno (T+12.1) | 凭证编号 | nvarchar | 200 | True | |
bizno (T+12.1) | 业务单号 | nvarchar | 50 | True | |
idexauxacc3 (T+12.1) | 扩展辅助项3 | int | 4 | True | |
quantity (T+12.1) | 数量 | decimal | 13 | True | |
idjournal (T+12.1) | 明细账ID | int | 4 | True | |
idauxAccPerson (T+12.1) | 人员id | int | 4 | True | |
dcdirection (T+12.1) | 借贷方向 | int | 4 | True | |
billDate (T+12.1) | 票据日期 | datetime | 8 | True | |
writeoffableamount (T+12.1) | 可核销本币金额 | decimal | 13 | True | |
idexauxacc8 (T+12.1) | 扩展辅助项8 | int | 4 | True | |
idclerk (T+12.1) | 业务员id | int | 4 | True |
Copyright 2019 Chanjet Inc.