辅助明细账
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| madedate (T+12.1) | 制单日期 | datetime | 8 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| idexauxacc10 (T+12.1) | 扩展辅助项10 | int | 4 | True | |
| docbusinesstype (T+12.1) | 凭证业务类型 | int | 4 | True | |
| docno (T+12.1) | 凭证编号 | nvarchar | 50 | True | |
| bizDate (T+12.1) | 业务日期 | datetime | 8 | True | |
| idauxAccSupplier (T+12.1) | 供应商id | int | 4 | True | |
| periodBeginOrigAmountDr (T+12.1) | 期初原币借方金额 | decimal | 13 | True | |
| idauxAccProject (T+12.1) | 项目id | int | 4 | True | |
| bookkeepername (T+12.1) | 记账人名称 | nvarchar | 50 | True | |
| idexauxacc2 (T+12.1) | 扩展辅助项2 | int | 4 | True | |
| cashiername (T+12.1) | 出纳名称 | nvarchar | 50 | True | |
| idexauxacc5 (T+12.1) | 扩展辅助项5 | int | 4 | True | |
| currentperiod (T+12.1) | 期间 | int | 4 | True | |
| origAmountDr (T+12.1) | 借方原币 | decimal | 13 | True | |
| idclerk (T+12.1) | 业务员id | int | 4 | True | |
| docsourcetype (T+12.1) | 单据来源 | int | 4 | True | |
| auditorname (T+12.1) | 审核人名称 | nvarchar | 50 | True | |
| idUnit (T+12.1) | 计量单位id | int | 4 | True | |
| summary (T+12.1) | 摘要 | nvarchar | 200 | True | |
| OrigAmountCr (T+12.1) | 贷方 | decimal | 13 | True | |
| quantityCr (T+12.1) | 贷方数量 | decimal | 13 | True | |
| sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
| idsettlestyle (T+12.1) | 结算方式id | int | 4 | True | |
| ispost (T+12.1) | 是否记账 | tinyint | 1 | True | |
| idexauxacc6 (T+12.1) | 扩展辅助项6 | int | 4 | True | |
| idexauxacc1 (T+12.1) | 扩展辅助项1 | int | 4 | True | |
| direction (T+12.1) | 借贷方向 | int | 4 | True | |
| periodBeginQuantityDr (T+12.1) | 期初借方数量 | decimal | 13 | True | |
| cashierauditdate (T+12.1) | 出纳签字日期 | datetime | 8 | True | |
| idexauxacc8 (T+12.1) | 扩展辅助项8 | int | 4 | True | |
| amountCr (T+12.1) | 贷方本币 | decimal | 13 | True | |
| periodBeginOrigAmountCr (T+12.1) | 期初原币贷方金额 | decimal | 13 | True | |
| auditdate (T+12.1) | 审核日期 | datetime | 8 | True | |
| billDate (T+12.1) | 票据日期 | datetime | 8 | True | |
| maker (T+12.1) | 制单人 | nvarchar | 50 | True | |
| makerId (T+12.1) | 制单人ID | int | 4 | True | |
| isdefrence (T+12.1) | 是否差异 | int | 4 | True | |
| idcurrency (T+12.1) | 币种id | int | 4 | True | |
| idaccount (T+12.1) | 科目id | int | 4 | False | |
| idexauxacc9 (T+12.1) | 扩展辅助项9 | int | 4 | True | |
| isPeriodBegin (T+12.1) | 是否期初 | tinyint | 1 | True | |
| rowno (T+12.1) | 分录行号 | nvarchar | 50 | True | |
| iscarriedforwardout (T+12.1) | 是否已结转 | tinyint | 1 | True | |
| idexauxacc7 (T+12.1) | 扩展辅助项7 | int | 4 | True | |
| periodBeginQuantityCr (T+12.1) | 期初贷方数量 | decimal | 13 | True | |
| dueDate (T+12.1) | 到期日 | datetime | 8 | True | |
| datafrom (T+12.1) | 数据来源 | int | 4 | True | |
| periodBeginAmountDr (T+12.1) | 期初本币借方金额 | decimal | 13 | True | |
| quantityDr (T+12.1) | 借方数量 | decimal | 13 | True | |
| idauxAccCustomer (T+12.1) | 往来单位id | int | 4 | True | |
| entryid (T+12.1) | 分录ID | int | 4 | True | |
| createdtime (T+12.1) | 创建时间 | datetime | 8 | True | |
| amountDr (T+12.1) | 借方本币 | decimal | 13 | True | |
| price (T+12.1) | 单价 | decimal | 13 | True | |
| iscarriedforwardin (T+12.1) | 是否结转来的单据 | tinyint | 1 | True | |
| idexauxacc4 (T+12.1) | 扩展辅助项4 | int | 4 | True | |
| idaccountingperiod (T+12.1) | 科目期初余额id | int | 4 | True | |
| year (T+12.1) | 年 | int | 4 | True | |
| idauxAccPerson (T+12.1) | 人员id | int | 4 | True | |
| billNo (T+12.1) | 票据号 | nvarchar | 200 | True | |
| idauxAccDepartment (T+12.1) | 部门id | int | 4 | True | |
| exchangerate (T+12.1) | 汇率 | decimal | 13 | True | |
| postdate (T+12.1) | 记账日期 | datetime | 8 | True | |
| docid (T+12.1) | 凭证ID | int | 4 | False | |
| bizNo (T+12.1) | 业务单号 | nvarchar | 200 | True | |
| idauxAccInventory (T+12.1) | 存货id | int | 4 | True | |
| idexauxacc3 (T+12.1) | 扩展辅助项3 | int | 4 | True | |
| DocDrCrType (T+12.1) | 凭证借贷类型 | int | 4 | True | |
| periodBeginAmountCr (T+12.1) | 期初本币贷方金额 | decimal | 13 | True | |
| auxiliaryinfoid (T+12.1) | 辅助信息ID | int | 4 | True | |
| idDocType (T+12.1) | 凭证类别id | int | 4 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| code (T+12.1) | 编号 | nvarchar | 30 | True |
Copyright 2019 Chanjet Inc.