凭证和来源临时数据
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| name (T+12.2) | 名称 | nvarchar | 200 | True | |
| duedate (T+12.2) | 到期日 | datetime | 8 | True | |
| costamount (T+12.2) | 成本金额 | decimal | 13 | True | |
| code (T+12.2) | 编号 | nvarchar | 30 | True | |
| idIncome (T+12.2) | 收入ID | int | 4 | True | |
| voucherdetailid (T+12.2) | 单据明细id | int | 4 | True | |
| Amount (T+12.2) | 金额 | decimal | 13 | True | |
| idExpenseItem (T+12.2) | 费用id | int | 4 | True | |
| idclerck (T+12.2) | 人员 | int | 4 | True | |
| idcustomer (T+12.2) | 客户id | int | 4 | True | |
| voucherID (T+12.2) | 单据id | int | 4 | True | |
| idinventory (T+12.2) | 存货id | int | 4 | True | |
| iddepartment (T+12.2) | 部门id | int | 4 | True | |
| executedquantity (T+12.2) | 数量 | decimal | 13 | True | |
| AuditDate (T+15.0) | 审核日期 | datetime | 8 | True | |
| idbankaccount (T+12.2) | 账号 | int | 4 | True | |
| idvouchertype (T+12.2) | 单据类型 | int | 4 | True | |
| voucherDate (T+12.2) | 单据日期 | datetime | 8 | True | |
| idinrdstyle (T+12.2) | 入库类别id | int | 4 | True | |
| idBankAccount2 (T+12.2) | 账号2 | int | 4 | True | |
| idoutrdstyle (T+12.2) | 出库类别id | int | 4 | True | |
| idbusitype (T+12.2) | 业务类型 | int | 4 | True | |
| executedquantity2 (T+12.2) | 数量2 | decimal | 13 | True | |
| idcurrency (T+12.2) | 币种 | int | 4 | True | |
| voucherCode (T+12.2) | 单据编号 | nvarchar | 30 | True | |
| ts (T+12.2) | 主键 | timestamp | 8 | False | |
| billno (T+12.2) | 发票号 | nvarchar | 50 | True | |
| idsecondcustomer (T+12.2) | 第二客户id | int | 4 | True | |
| saledispatchcode (T+12.2) | 销售批号 | nvarchar | 50 | True | |
| idsecondsupplier (T+12.2) | 第二供应商id | int | 4 | True | |
| idbaesunit (T+12.2) | 主计量 | int | 4 | True | |
| sequencenumber (T+12.2) | 顺序号 | int | 4 | True | |
| OrigAmount (T+12.2) | 原币 | decimal | 13 | True | |
| VoucherTs (T+12.2) | 单据TS | binary | 8 | True | |
| saledispatchdate (T+12.2) | 销售日期 | datetime | 8 | True | |
| InvoiceCode (T+12.2) | 发票号码 | nvarchar | 200 | True | |
| Memo (T+12.2) | 备注 | nvarchar | 200 | True | |
| costprice (T+12.2) | 成本单价 | decimal | 13 | True | |
| userid (T+12.2) | 用户id | int | 4 | True | |
| selected (T+12.2) | 选择 | tinyint | 1 | True | |
| MergeCode (T+12.2) | 合并号 | nvarchar | 50 | True | |
| VoucherDetailTs (T+12.2) | 单据明细TS | binary | 8 | True | |
| id (T+12.2) | 主键 | int | 4 | False | |
| billdate (T+12.2) | 发票日期 | datetime | 8 | True | |
| SaleOrderCode (T+13.0) | 销售订单编号 | nvarchar | 500 | True | |
| idsupplier (T+12.2) | 供应商ID | int | 4 | True | |
| idproject (T+12.2) | 项目id | int | 4 | True |
Copyright 2016 Chanjet Inc.