门店价格本DTO
invcost是公式计算值,invcostformula是页面显示值
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
StoreMemberPriceFormula (T+12.1) | 门店零售价 | nvarchar | 1000 | True | |
code (T+12.1) | 编号 | nvarchar | 32 | True | |
dimension (T+12.1) | 维度设置 | int | 4 | True | |
createdtime (T+12.1) | CreatedTime | datetime | 8 | True | |
InvBarCode (T+12.1) | 条形码 | nvarchar | 1000 | True | |
StoreLowestPrice (T+16.0) | 门店最低价 | decimal | 13 | True | |
StoreType (T+12.1) | 门店类型 | int | 4 | True | |
updatedBy (T+12.1) | 更新者 | nvarchar | 32 | True | |
idstore (T+12.1) | 门店id | int | 4 | True | |
iddistrict (T+12.1) | 地区id | int | 4 | True | |
SearchFlag (T+12.1) | 数据来源 | int | 4 | True | |
name (T+12.1) | 名称 | nvarchar | 200 | True | |
StoreRetailPriceFormula (T+12.1) | 门店零售价 | nvarchar | 1000 | True | |
updated (T+12.1) | 更新时间 | datetime | 8 | True | |
PriceKey (T+12.1) | 维度设置 | nvarchar | 36 | True | |
idinventory (T+12.1) | 存货id | int | 4 | True | |
Remarks (T+12.3) | 备注 | nvarchar | 200 | True | |
DataOperator (T+16.0) | 操作员 | nvarchar | 100 | True | |
retailPriceNew (T+12.1) | 零售价 | decimal | 17 | True | |
ts (T+12.1) | 分布时间戳 | timestamp | 8 | True | |
idunit (T+12.1) | 计量单位id | int | 4 | True | |
MemberPrice (T+12.1) | 会员价 | decimal | 17 | True | |
StoreMemberPrice (T+12.1) | 门店零售价 | nvarchar | 1000 | True | |
StoreRetailPrice (T+12.1) | 门店零售价 | nvarchar | 1000 | True | |
id (T+12.1) | 主键 | int | 4 | False | |
iddepartment (T+12.1) | 部门id | int | 4 | True |
Copyright 2016 Chanjet Inc.