常用凭证的分录
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
amountcr (T+12.1) | 贷方本币 | decimal | 13 | True | |
idaccount (T+12.1) | 科目id | int | 4 | True | |
quantitydr (T+12.1) | 借方数量 | decimal | 13 | True | |
quantitycr (T+12.1) | 贷方数量 | decimal | 13 | True | |
price (T+12.1) | 单价 | decimal | 13 | True | |
idReferenceDocDTO (T+12.1) | 常用凭证的头id | int | 4 | True | |
ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
priuserdefdecm4 (T+12.1) | 数值自定义项4 | decimal | 13 | True | |
priuserdefnvc1 (T+12.1) | 字符专用自定义项1 | nvarchar | 500 | True | |
exchangerate (T+12.1) | 汇率 | decimal | 13 | True | |
origamountdr (T+12.1) | 借方原币 | decimal | 13 | True | |
code (T+12.1) | 编号 | nvarchar | 30 | True | |
sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
idUnit (T+12.1) | 计量单位id | int | 4 | True | |
accountname (T+12.1) | 科目名称 | nvarchar | 200 | True | |
priuserdefdecm2 (T+12.1) | 数值专用自定义项2 | decimal | 13 | True | |
priuserdefdecm3 (T+12.1) | 数值自定义项3 | decimal | 13 | True | |
accountcode (T+12.1) | 科目编码 | nvarchar | 200 | True | |
amountdr (T+12.1) | 借方本币 | decimal | 13 | True | |
id (T+12.1) | 主键 | int | 4 | False | |
AuxiliaryItems (T+12.1) | 辅助项 | nvarchar | 200 | True | |
origamountcr (T+12.1) | 贷方 | decimal | 13 | True | |
summary (T+12.1) | 摘要 | nvarchar | 200 | True | |
idcurrency (T+12.1) | 币种Id | int | 4 | True | |
priuserdefnvc4 (T+12.1) | 字符专用自定义项4 | nvarchar | 500 | True | |
priuserdefnvc3 (T+12.1) | 字符专用自定义项3 | nvarchar | 500 | True | |
priuserdefdecm1 (T+12.1) | 数值专用自定义项1 | decimal | 13 | True | |
priuserdefnvc2 (T+12.1) | 字符专用自定义项2 | nvarchar | 500 | True |
Copyright 2016 Chanjet Inc.