取货记录
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| freeItem6 (T+12.3) | 自由项7 | nvarchar | 300 | True | |
| quantity (T+12.3) | 数量 | decimal | 13 | True | |
| Amount (T+12.3) | 金额 | decimal | 13 | True | |
| freeItem9 (T+12.3) | 自由项10 | nvarchar | 300 | True | |
| inventorybarcode (T+12.3) | 条码 | nvarchar | 200 | True | |
| code (T+12.3) | 编号 | nvarchar | 50 | True | |
| idinventory (T+12.3) | 存货ID | int | 4 | False | |
| freeItem0 (T+12.3) | 自由项1 | nvarchar | 300 | True | |
| iscarriedforwardin (T+12.3) | 是否期间结转入 | tinyint | 1 | True | |
| idstore (T+12.3) | 门店ID | int | 4 | True | |
| key (T+12.3) | 识别码 | nvarchar | 50 | True | |
| freeItem2 (T+12.3) | 自由项3 | nvarchar | 300 | True | |
| userName (T+12.3) | 操作员 | nvarchar | 50 | True | |
| idunit (T+12.3) | 计量单位 | int | 4 | True | |
| memo (T+12.3) | 备注 | nvarchar | 200 | True | |
| freeItem7 (T+12.3) | 自由项8 | nvarchar | 300 | True | |
| freeItem8 (T+12.3) | 自由项9 | nvarchar | 300 | True | |
| idretaildetaildto (T+12.3) | 来源零售单明细ID | bigint | 8 | False | |
| idbaseunit (T+12.3) | 主计量ID | int | 4 | True | |
| retailvouchercode (T+12.3) | 来源零售单单号 | nvarchar | 50 | False | |
| Price (T+12.3) | 单价 | decimal | 13 | True | |
| quantity2 (T+12.3) | 数量2 | decimal | 13 | True | |
| RetailPrice (T+12.3) | 零售价 | decimal | 13 | True | |
| idunit2 (T+12.3) | 计量单位2 | int | 4 | True | |
| idretaildto (T+12.3) | 来源零售单ID | bigint | 8 | False | |
| idsubunit (T+12.3) | 辅计量ID | int | 4 | True | |
| freeItem1 (T+12.3) | 自由项2 | nvarchar | 300 | True | |
| freeItem5 (T+12.3) | 自由项6 | nvarchar | 300 | True | |
| idmarketingOrgan (T+12.3) | 营销机构ID | int | 4 | True | |
| isSaleOut (T+12.3) | 是否出库，取枚举档案 | int | 4 | True | |
| freeItem4 (T+12.3) | 自由项5 | nvarchar | 300 | True | |
| TaxPrice (T+12.3) | 含税价格 | decimal | 13 | True | |
| TS (T+12.3) | TS | timestamp | 8 | False | |
| batch (T+12.3) | 批号 | nvarchar | 50 | True | |
| TaxAmount (T+12.3) | 含税金额 | decimal | 13 | True | |
| userId (T+12.3) | 操作员ID | int | 4 | True | |
| freeItem3 (T+12.3) | 自由项4 | nvarchar | 300 | True | |
| poscode (T+12.3) | POS机号 | nvarchar | 50 | True | |
| expirydate (T+12.3) | 有效期 | datetime | 8 | True | |
| RetailAmount (T+12.3) | 零售金额 | decimal | 13 | True | |
| state (T+12.3) | 单据状态 | int | 4 | True | |
| POSID (T+12.3) | POS生成的ID | bigint | 8 | True | |
| VoucherDate (T+12.3) | 单据日期 | datetime | 8 | True | |
| IsPresent (T+12.3) | 是否赠品 | tinyint | 1 | True | |
| subquantity (T+12.3) | 辅数量 | decimal | 13 | True | |
| basequantity (T+12.3) | 主数量 | decimal | 13 | True | |
| UnitExchangeRate (T+12.3) | 换算率 | decimal | 13 | True | |
| id (T+12.3) | ID | int | 4 | False | |
| productiondate (T+12.3) | 生产日期 | datetime | 8 | True | |
| name (T+12.3) | 名称 | nvarchar | 200 | True | |
| CreatedTime (T+12.3) | 创建时间 | datetime | 8 | True | |
| iscarriedforwardout (T+12.3) | 是否期间结转出 | tinyint | 1 | True |
Copyright 2019 Chanjet Inc.