客户折扣
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| idInventoryClass (T+12.2) | 存货分类id | int | 4 | True | |
| CorpBrand (T+12.2) | 品牌 | int | 4 | True | |
| updated (T+12.2) | 更改日期 | datetime | 8 | True | |
| Remarks (T+12.3) | 备注 | nvarchar | 200 | True | |
| dimension (T+12.2) | 维度 | int | 4 | True | |
| SearchFlag (T+12.2) | 查找功能用的特定标识位 | int | 4 | True | |
| updatedBy (T+12.2) | 更改者 | nvarchar | 32 | True | |
| Code (T+12.2) | code | nvarchar | 32 | True | |
| id (T+12.2) | id | int | 4 | False | |
| ts (T+12.2) | 时间戳 | timestamp | 8 | False | |
| createdtime (T+15.0) | 创建时间 | datetime | 8 | True | |
| PriceKey (T+12.2) | 提取数据用的字段(IdInventoryclass+IDpartnerclass+IDCustomer) | nvarchar | 34 | True | |
| name (T+12.2) | name,实际没有用到 | nvarchar | 200 | True | |
| idPartnerClass (T+12.2) | 往来单位分类id | int | 4 | True | |
| Discount (T+12.2) | 折扣率 | decimal | 13 | True | |
| idCustomer (T+12.2) | 客户id | int | 4 | True | |
| DiscountBasePrice (T+15.0) | 折扣基准价 | int | 4 | True |
Copyright 2016 Chanjet Inc.