更新信用历史记录
用于保存每次更新信用的历史记录表
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
voucherCode (T+12.2) | 单据编码 | varchar | 200 | True | |
outunsettleamount (T+12.2) | 保存时点已出货未立账 | decimal | 13 | True | |
idcustomer (T+12.2) | 客户id | int | 4 | True | |
VoucherID (T+16.0) | 单据id | int | 4 | True | |
id (T+12.2) | 主键id | int | 4 | False | |
orderunoutamount (T+12.2) | 保存时已订未出货点金额 | decimal | 13 | True | |
orderunoutamountForAudit (T+12.2) | 审核时点已订未出货金额 | decimal | 13 | True | |
DtoName (T+16.0) | 单据Name | varchar | 50 | True | |
receiveuncancelamount (T+12.2) | 保存时点已出货未结款金额 | decimal | 13 | True | |
outunsettleamountForAudit (T+12.2) | 审核时点已出货未立账 | decimal | 13 | True | |
expenseSettleAmount (T+12.2) | 保存时点费用单金额 | decimal | 13 | True | |
salesettleamount (T+12.2) | 保存时点销售应收款金额 | decimal | 13 | True | |
operationType (T+12.2) | 操作类型 | varchar | 20 | True | |
updated (T+12.2) | 更新时间 | datetime | 8 | True | |
idclerk (T+12.2) | 业务员id | int | 4 | True | |
ts (T+12.2) | 时间戳 | timestamp | 8 | False | |
incomeunsettleamountForAudit (T+12.2) | 审核时点收入未结款金额 | decimal | 13 | True | |
expenseSettleAmountForAudit (T+12.2) | 审核时点费用单未结款金额 | decimal | 13 | True | |
incomeunsettleamount (T+12.2) | 保存时点收入未结款金额 | decimal | 13 | True | |
salesettleamountForAudit (T+12.2) | 审核时点销售应收款金额 | decimal | 13 | True | |
receiveuncancelamountForAudit (T+12.2) | 审核时点已出货未立账金额 | decimal | 13 | True |
Copyright 2016 Chanjet Inc.