常用凭证的辅助信息
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| idauxAccInventory (T+12.1) | 存货id | int | 4 | True | |
| idexauxacc7 (T+12.1) | 扩展辅助项7 | int | 4 | True | |
| idauxAccSupplier (T+12.1) | 供应商id | int | 4 | True | |
| idauxAccProject (T+12.1) | 项目id | int | 4 | True | |
| billdate (T+12.1) | 票据日期 | datetime | 8 | True | |
| idexauxacc1 (T+12.1) | 扩展辅助项1 | int | 4 | True | |
| exchangerate (T+12.1) | 汇率 | decimal | 13 | True | |
| idbankAccount (T+12.1) | 账号id | int | 4 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| idexauxacc10 (T+12.1) | 扩展辅助项10 | int | 4 | True | |
| idauxAccPerson (T+12.1) | 个人id | int | 4 | True | |
| idexauxacc9 (T+12.1) | 扩展辅助项9 | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| duedate (T+12.1) | 到期日 | datetime | 8 | True | |
| idauxAccCustomer (T+12.1) | 往来单位id | int | 4 | True | |
| idexauxacc5 (T+12.1) | 扩展辅助项5 | int | 4 | True | |
| idexauxacc4 (T+12.1) | 扩展辅助项4 | int | 4 | True | |
| idexauxacc3 (T+12.1) | 扩展辅助项3 | int | 4 | True | |
| idexauxacc8 (T+12.1) | 扩展辅助项8 | int | 4 | True | |
| idsettlestyle (T+12.1) | 结算方式id | int | 4 | True | |
| idclerk (T+12.1) | 业务员id | int | 4 | True | |
| bizno (T+12.1) | 业务单号 | nvarchar | 50 | True | |
| idexauxacc6 (T+12.1) | 扩展辅助项6 | int | 4 | True | |
| idReferenceEntryDTO (T+12.1) | 常用凭证分录ID | int | 4 | True | |
| bizdate (T+12.1) | 业务日期 | datetime | 8 | True | |
| billno (T+12.1) | 票据号 | nvarchar | 50 | True | |
| idauxAccDepartment (T+12.1) | 部门id | int | 4 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| idexauxacc2 (T+12.1) | 扩展辅助项2 | int | 4 | True | |
| ReferenceDocId (T+12.1) | 参考凭证ID | int | 4 | True |
Copyright 2019 Chanjet Inc.