往来核销缓存
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| writeOffAmountDr (T+12.2) | 往来核销借方金额 | decimal | 13 | True | |
| idExAuxAcc10 (T+12.2) | 扩展辅助核算10 | int | 4 | True | |
| writeOffer (T+12.2) | 核销人 | nvarchar | 200 | True | |
| idExAuxAcc1 (T+12.2) | 扩展辅助核算1 | int | 4 | True | |
| idauxAccCustomer (T+12.2) | 客户id | int | 4 | True | |
| writeOffBatch (T+12.2) | 核销批号 | nvarchar | 200 | True | |
| idExAuxAcc9 (T+12.2) | 扩展辅助核算9 | int | 4 | True | |
| bizDate (T+12.2) | 单据日期 | datetime | 8 | True | |
| idExAuxAcc2 (T+12.2) | 扩展辅助核算2 | int | 4 | True | |
| idauxAccProject (T+12.2) | 项目id | int | 4 | True | |
| summary (T+12.2) | 摘要 | nvarchar | 200 | True | |
| bizNo (T+12.2) | 业务单号 | nvarchar | 200 | True | |
| writeOffNo (T+12.2) | 核销编号 | nvarchar | 200 | True | |
| writeOffOrigAmountDr (T+12.2) | 往来核销借方原币 | decimal | 13 | True | |
| docMadeDate (T+12.2) | 凭证制单日期 | datetime | 8 | True | |
| id (T+12.2) | 主键 | int | 4 | False | |
| writeOffDate (T+12.2) | 核销日期 | datetime | 8 | True | |
| idWriteOffHistory (T+12.2) | 往来核销id | int | 4 | True | |
| idauxAccInventory (T+12.2) | 存货id | int | 4 | True | |
| writeOffOrigAmountCr (T+12.2) | 往来核销贷方原币 | decimal | 13 | True | |
| idExAuxAcc7 (T+12.2) | 扩展辅助核算7 | int | 4 | True | |
| idauxAccPerson (T+12.2) | 人员id | int | 4 | True | |
| idExAuxAcc6 (T+12.2) | 扩展辅助核算6 | int | 4 | True | |
| writeOffAmountCr (T+12.2) | 往来核销贷方金额 | decimal | 13 | True | |
| idExAuxAcc5 (T+12.2) | 扩展辅助核算5 | int | 4 | True | |
| idExAuxAcc4 (T+12.2) | 扩展辅助核算4 | int | 4 | True | |
| idExAuxAcc8 (T+12.2) | 扩展辅助核算8 | int | 4 | True | |
| idauxAccDepartment (T+12.2) | 部门id | int | 4 | True | |
| idCurrency (T+12.2) | 币种id | int | 4 | True | |
| docSignNo (T+12.2) | 凭证核销号 | nvarchar | 200 | True | |
| idauxAccSupplier (T+12.2) | 供应商id | int | 4 | True | |
| ts (T+12.2) | 时间戳 | timestamp | 8 | False | |
| idExAuxAcc3 (T+12.2) | 扩展辅助核算3 | int | 4 | True |
Copyright 2019 Chanjet Inc.