交易凭证辅助信息
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| idinvlocation (T+12.1) | 货位id | int | 4 | True | |
| idsettlestyle (T+12.1) | 结算方式id | int | 4 | True | |
| idperson (T+12.1) | 人员id | int | 4 | True | |
| iddistrict (T+12.1) | 地区id | int | 4 | True | |
| idcurrency (T+12.1) | 币种id | int | 4 | True | |
| idexauxacc6 (T+12.1) | 扩展辅助核算6 | int | 4 | True | |
| idexauxacc1 (T+12.1) | 扩展辅助项1 | int | 4 | True | |
| price (T+12.1) | 单价 | decimal | 13 | True | |
| idbankaccount (T+12.1) | 账号id | int | 4 | True | |
| amount (T+12.1) | 金额 | decimal | 13 | True | |
| idsupplier (T+12.1) | 供应商id | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| duedate (T+12.1) | 到期日 | datetime | 8 | True | |
| voucherdate (T+12.1) | 单据日期 | datetime | 8 | True | |
| idexauxacc8 (T+12.1) | 扩展辅助核算8 | int | 4 | True | |
| idexauxacc4 (T+12.1) | 扩展辅助核算4 | int | 4 | True | |
| idUnit (T+12.1) | 计量单位id | int | 4 | True | |
| origamount (T+12.1) | 原币金额 | decimal | 13 | True | |
| idproject (T+12.1) | 项目id | int | 4 | True | |
| dcdirection (T+12.1) | 借贷方向 | int | 4 | True | |
| idwarehouse (T+12.1) | 仓库id | int | 4 | True | |
| idexauxacc3 (T+12.1) | 扩展辅助核算3 | int | 4 | True | |
| idexauxacc2 (T+12.1) | 扩展辅助核算2 | int | 4 | True | |
| quantity (T+12.1) | 数量 | decimal | 13 | True | |
| idcustomer (T+12.1) | 往来单位id | int | 4 | True | |
| idsupplierclass (T+12.1) | 供应商分类id | int | 4 | True | |
| iddocumentsusage (T+12.1) | 票据用途id | int | 4 | True | |
| iddepartment (T+12.1) | 部门id | int | 4 | True | |
| idinventory (T+12.1) | 存货id | int | 4 | True | |
| idexauxacc9 (T+12.1) | 扩展辅助核算9 | int | 4 | True | |
| invoicecode (T+12.1) | 票据号 | nvarchar | 50 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| idincome (T+12.1) | 收入id | int | 4 | True | |
| idprojectClass (T+12.1) | 项目分类id | int | 4 | True | |
| idTransactionEntryDTO (T+12.1) | 交易凭证分录id | int | 4 | True | |
| vouchercode (T+12.1) | 单据编号 | nvarchar | 50 | True | |
| idexauxacc7 (T+12.1) | 扩展辅助核算7 | int | 4 | True | |
| idclerk (T+12.1) | 业务员id | int | 4 | True | |
| idinrdstyle (T+12.1) | 出入库类别id | int | 4 | True | |
| idexauxacc5 (T+12.1) | 扩展辅助核算5 | int | 4 | True | |
| idbusitype (T+12.1) | 业务类型id | int | 4 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| idcustomerclass (T+12.1) | 往来单位分类id | int | 4 | True | |
| idvouchertype (T+12.1) | 单据类型id | int | 4 | True | |
| idexauxacc10 (T+12.1) | 扩展辅助核算10 | int | 4 | True | |
| idexpenseitem (T+12.1) | 费用id | int | 4 | True | |
| idinventoryclass (T+12.1) | 存货分类id | int | 4 | True | |
| AuditedDate (T+12.3) | 审核日期 | datetime | 8 | True | |
| idoutrdstyle (T+12.1) | 出库类别id | int | 4 | True |
Copyright 2019 Chanjet Inc.