科目期初余额的往来明细期初
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| idexauxacc2 (T+12.1) | 扩展辅助项2 | int | 4 | True | |
| origamount (T+12.1) | 原币金额 | decimal | 13 | True | |
| voucherdate (T+12.1) | 制单日期 | datetime | 8 | True | |
| idcurrencyDTO (T+12.1) | 币种id | int | 4 | False | |
| idexauxacc3 (T+12.1) | 扩展辅助项3 | int | 4 | True | |
| idauxacccustomer (T+12.1) | 往来单位id | int | 4 | True | |
| docno (T+12.1) | 凭证编号 | nvarchar | 200 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| idexauxacc5 (T+12.1) | 扩展辅助项5 | int | 4 | True | |
| summarry (T+12.1) | 摘要 | nvarchar | 100 | True | |
| idexauxacc6 (T+12.1) | 扩展辅助项6 | int | 4 | True | |
| duedate (T+12.1) | 到期日 | datetime | 8 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| idclerk (T+12.1) | 业务员id | int | 4 | True | |
| idauxaccperson (T+12.1) | 个人id | int | 4 | True | |
| idexauxacc10 (T+12.1) | 扩展辅助项10 | int | 4 | True | |
| idexauxacc8 (T+12.1) | 扩展辅助项8 | int | 4 | True | |
| idexauxacc9 (T+12.1) | 扩展辅助项9 | int | 4 | True | |
| idexauxacc4 (T+12.1) | 扩展辅助项4 | int | 4 | True | |
| idUnit (T+12.1) | 单位id | int | 4 | True | |
| idauxaccdepartment (T+12.1) | 部门id | int | 4 | True | |
| idexauxacc1 (T+12.1) | 扩展辅助项1 | int | 4 | True | |
| quantity (T+12.1) | 数量 | decimal | 13 | True | |
| amount (T+12.1) | 金额 | decimal | 13 | True | |
| dcdirection (T+12.1) | 借贷方向 | int | 4 | True | |
| idauxaccsupplier (T+12.1) | 往来单位id | int | 4 | True | |
| isfrompreyear (T+12.1) | 是否年结转入 | tinyint | 1 | True | |
| idauxaccinventory (T+12.1) | 存货id | int | 4 | True | |
| idAccountAuxPeriodBeginDTO (T+12.1) | 科目期初辅助明细id | int | 4 | True | |
| vouchercode (T+12.1) | 单据编号 | nvarchar | 50 | True | |
| sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
| idauxaccproject (T+12.1) | 项目id | int | 4 | True | |
| docdate (T+12.1) | 制单日期 | datetime | 8 | True | |
| idexauxacc7 (T+12.1) | 扩展辅助项7 | int | 4 | True | |
| idaccountDTO (T+12.1) | 科目id | int | 4 | True |
Copyright 2019 Chanjet Inc.