部门存货价格DTO
invcost是公式计算值,invcostformula是页面显示值
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
idpricetrace (T+12.1) | 价格跟踪id | int | 4 | True | |
level2PriceFormula (T+12.1) | 二级批发价 | nvarchar | 1000 | True | |
ts (T+12.1) | 分布时间戳 | timestamp | 8 | True | |
level10Price (T+12.1) | 十级批发价 | nvarchar | 1000 | True | |
retailPrice (T+12.1) | 零售价 | nvarchar | 1000 | True | |
level7PriceFormula (T+12.1) | 七级批发价 | nvarchar | 1000 | True | |
level2Price (T+12.1) | 二级批发价 | nvarchar | 1000 | True | |
name (T+12.1) | 名称 | nvarchar | 200 | True | |
updatedBy (T+12.1) | 更新者 | nvarchar | 32 | True | |
iddepartment (T+12.1) | 部门id | int | 4 | True | |
level5PriceFormula (T+12.1) | 五级批发价 | nvarchar | 1000 | True | |
idunit (T+12.1) | 计量单位id | int | 4 | True | |
idinventory (T+12.1) | 存货id | int | 4 | True | |
level3Price (T+12.1) | 三级批发价 | nvarchar | 1000 | True | |
level4PriceFormula (T+12.1) | 四级批发价 | nvarchar | 1000 | True | |
level4Price (T+12.1) | 四级批发价 | nvarchar | 1000 | True | |
level3PriceFormula (T+12.1) | 三级批发价 | nvarchar | 1000 | True | |
level6Price (T+12.1) | 六级批发价 | nvarchar | 1000 | True | |
level1Price (T+12.1) | 一级批发价 | nvarchar | 1000 | True | |
code (T+12.1) | 编号 | nvarchar | 32 | True | |
lowestPrice (T+12.1) | 最低售价 | nvarchar | 1000 | True | |
level9PriceFormula (T+12.1) | 九级批发价 | nvarchar | 1000 | True | |
createdtime (T+12.1) | CreatedTime | datetime | 8 | True | |
Remarks (T+12.3) | 备注 | nvarchar | 200 | True | |
lowestPriceFormula (T+12.1) | 最低售价 | nvarchar | 1000 | True | |
level9Price (T+12.1) | 九级批发价 | nvarchar | 1000 | True | |
level8Price (T+12.1) | 八级批发价 | nvarchar | 1000 | True | |
idinventoryprice (T+12.1) | 价格本id | int | 4 | True | |
level6PriceFormula (T+12.1) | 六级批发价 | nvarchar | 1000 | True | |
level7Price (T+12.1) | 七级批发价 | nvarchar | 1000 | True | |
level8PriceFormula (T+12.1) | 八级批发价 | nvarchar | 1000 | True | |
level10PriceFormula (T+12.1) | 十级批发价 | nvarchar | 1000 | True | |
InvBarCode (T+12.3) | 条形码 | nvarchar | 128 | True | |
updated (T+12.1) | 更新时间 | datetime | 8 | True | |
level1PriceFormula (T+12.1) | 一级批发价 | nvarchar | 1000 | True | |
retailPriceFormula (T+12.1) | 普通客户价 | nvarchar | 1000 | True | |
level5Price (T+12.1) | 五级批发价 | nvarchar | 1000 | True | |
id (T+12.1) | 主键 | int | 4 | False |
Copyright 2019 Chanjet Inc.