预置常用凭证分录
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| summary (T+12.1) | 摘要 | nvarchar | 200 | True | |
| idaccount (T+12.1) | 科目id | int | 4 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| accountname (T+12.1) | 科目名称 | nvarchar | 200 | True | |
| price (T+12.1) | 单价 | decimal | 13 | True | |
| priuserdefnvc4 (T+12.1) | 字符专用自定义项4 | nvarchar | 60 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| origamountdr (T+12.1) | 借方原币 | decimal | 13 | True | |
| priuserdefdecm2 (T+12.1) | 数值专用自定义项2 | decimal | 13 | True | |
| priuserdefnvc2 (T+12.1) | 字符专用自定义项2 | nvarchar | 60 | True | |
| amountdr (T+12.1) | 借方本币 | decimal | 13 | True | |
| idReferenceDocDTO (T+12.1) | 常用凭证id | int | 4 | True | |
| accountcode (T+12.1) | 科目编码 | nvarchar | 200 | True | |
| amountcr (T+12.1) | 贷方本币 | decimal | 13 | True | |
| priuserdefdecm1 (T+12.1) | 数值专用自定义项1 | decimal | 13 | True | |
| AuxiliaryItems (T+12.1) | 辅助项 | nvarchar | 200 | True | |
| origamountcr (T+12.1) | 贷方 | decimal | 13 | True | |
| idcurrency (T+12.1) | 币种id | int | 4 | True | |
| priuserdefnvc1 (T+12.1) | 字符专用自定义项1 | nvarchar | 60 | True | |
| TradeKind (T+12.1) | 行业性质 | nvarchar | 100 | False | |
| exchangerate (T+12.1) | 汇率 | decimal | 13 | True | |
| quantitydr (T+12.1) | 借方数量 | decimal | 13 | True | |
| priuserdefnvc3 (T+12.1) | 字符专用自定义项3 | nvarchar | 60 | True | |
| priuserdefdecm3 (T+12.1) | 数值自定义项3 | decimal | 13 | True | |
| quantitycr (T+12.1) | 贷方数量 | decimal | 13 | True | |
| priuserdefdecm4 (T+12.1) | 数值自定义项4 | decimal | 13 | True |
Copyright 2019 Chanjet Inc.