字段名称 | 字段说明 | 字段长度 | 字段类型 | 是否唯一 |
---|---|---|---|---|
ID | 主键 | -1 | ID | 0 |
Code | 编号 | 32 | String | 0 |
Name | 名称 | 50 | String | 0 |
Shorthand | 助记码 | 50 | String | 0 |
Specification | 规格型号 | 60 | String | 0 |
ProductInfo | 品牌 | -1 | Enum | 0 |
ProcureBatch | 采购批量 | -1 | Decimal | 0 |
IsNew | 新品 | -1 | Bool | 0 |
MadeRecordDate | 建档日期 | -1 | DateTime | 0 |
StoreReplenishmentRule | 门店补货规则 | -1 | Enum | 0 |
CustomerReplenishmentRule | 客户补货规则 | -1 | Enum | 0 |
IsSuite | 成套件 | -1 | Bool | 0 |
IsWeigh | 称重 | -1 | Bool | 0 |
TaxRate | 税率 | -1 | Enum | 0 |
InvSCost | 参考成本 | -1 | Decimal | 0 |
LatestCost | 最新成本 | -1 | Decimal | 0 |
AvagCost | 平均成本 | -1 | Decimal | 0 |
IsLimitedWithdraw | 是否限额领料 | -1 | Bool | 0 |
IsBatch | 是否批号管理 | -1 | Bool | 0 |
IsQualityPeriod | 是否质保期管理 | -1 | Bool | 0 |
UnitByRetail | 零售常用单位 | 0 | DTO | 0 |
MarketingOrgan | 所属营销机构 | 0 | DTO | 0 |
IsLaborCost | 是否劳务费用 | -1 | Bool | 0 |
idMarketingOrgan | 所属营销机构ID | 0 | ID | 0 |
InventoryDescript | 存货描述 | 500 | string | 0 |
idUnitByRetail | 零售常用单位ID | 0 | ID | 0 |
ValueType | 计价方式 | -1 | Enum | 0 |
IsSale | 是否可销售 | -1 | Bool | 0 |
IsMadeSelf | 是否自制 | -1 | Bool | 0 |
IsPurchase | 是否外购 | -1 | Bool | 0 |
IsMaterial | 是否生产耗用 | -1 | Bool | 0 |
LowQuantity | 最低库存 | -1 | Decimal | 0 |
TopQuantity | 最高库存 | -1 | Decimal | 0 |
SafeQuantity | 安全库存 | -1 | Decimal | 0 |
Picture | 图片 | 50 | String | 0 |
Disabled | 停用 | -1 | Bool | 0 |
idinventoryClass | idinventoryClass | 0 | ID | 0 |
IsQualityCheck | 是否需要质检 | -1 | Bool | 0 |
IsMadeRequest | 是否委外 | -1 | Bool | 0 |
CreatedTime | 创建时间 | -1 | DateTime | 0 |
idwarehouse | idwarehouse | 0 | ID | 0 |
IsSingleUnit | 是否单计量 | -1 | Bool | 0 |
MadeDate | 创建时间 | -1 | DateTime | 0 |
Ts | 分布时间戳 | -1 | TimeStamp | 0 |
idinvLocation | idinvLocation | 0 | ID | 0 |
PickBatch | 领料批量 | -1 | Decimal | 0 |
StandardTurnoverDays | 标准周转天数 | -1 | Decimal | 0 |
PickBatchMethod | 领料批量处理方式 | -1 | Enum | 0 |
Updated | 更新时间 | 32 | DateTime | 0 |
UpdatedBy | 更新者 | 32 | String | 0 |
idunit | idunit | 0 | ID | 0 |
IsPhantom | 是否虚拟件 | -1 | Bool | 0 |
PlanAttribute | 计划属性 | -1 | Enum | 0 |
UnitType | 计量方式 | -1 | Enum | 0 |
idpartner | idpartner | 0 | ID | 0 |
idunitGroup | idunitGroup | 0 | ID | 0 |
InventoryClass | InventoryClass | 0 | DTO | 0 |
Warehouse | Warehouse | 0 | DTO | 0 |
InvLocation | InvLocation | 0 | DTO | 0 |
Unit | Unit | 0 | DTO | 0 |
Partner | Partner | 0 | DTO | 0 |
InvUnitPriceDTOs | InvUnitPriceDTOs | 0 | DTOCollection | 0 |
InventoryPriceDTOs | InventoryPriceDTOs | 0 | DTOCollection | 0 |
InvBarCodeDTOs | InvBarCodeDTOs | 0 | DTOCollection | 0 |
UnitGroup | UnitGroup | 0 | DTO | 0 |
priuserdefnvc1 | 字符自定义项1 | 60 | String | 0 |
priuserdefdecm1 | 数值自定义项1 | 100 | Decimal | 0 |
priuserdefnvc2 | 字符自定义项2 | 60 | String | 0 |
priuserdefdecm2 | 数值自定义项2 | 100 | Decimal | 0 |
Userfreeitem2 | Userfreeitem2 | -1 | Bool | 0 |
Userfreeitem1 | Userfreeitem1 | -1 | Bool | 0 |
Userfreeitem9 | Userfreeitem9 | -1 | Bool | 0 |
Userfreeitem8 | Userfreeitem8 | -1 | Bool | 0 |
Userfreeitem0 | Userfreeitem0 | -1 | Bool | 0 |
Userfreeitem4 | Userfreeitem4 | -1 | Bool | 0 |
Userfreeitem5 | Userfreeitem5 | -1 | Bool | 0 |
Userfreeitem7 | Userfreeitem7 | -1 | Bool | 0 |
Userfreeitem6 | Userfreeitem6 | -1 | Bool | 0 |
priuserdefnvc3 | 字符自定义项3 | 60 | String | 0 |
Userfreeitem3 | Userfreeitem3 | -1 | Bool | 0 |
MustInputFreeitem4 | MustInputFreeitem4 | -1 | Bool | 0 |
MustInputFreeitem7 | MustInputFreeitem7 | -1 | Bool | 0 |
MustInputFreeitem2 | MustInputFreeitem2 | -1 | Bool | 0 |
MustInputFreeitem3 | MustInputFreeitem3 | -1 | Bool | 0 |
MustInputFreeitem6 | MustInputFreeitem6 | -1 | Bool | 0 |
priuserdefdecm3 | 数值自定义项3 | 100 | Decimal | 0 |
MustInputFreeitem8 | MustInputFreeitem8 | -1 | Bool | 0 |
MustInputFreeitem0 | MustInputFreeitem0 | -1 | Bool | 0 |
MustInputFreeitem5 | MustInputFreeitem5 | -1 | Bool | 0 |
MustInputFreeitem9 | MustInputFreeitem9 | -1 | Bool | 0 |
MustInputFreeitem1 | MustInputFreeitem1 | -1 | Bool | 0 |
priuserdefnvc4 | 字符自定义项4 | 60 | String | 0 |
ProduceBatch | 生产批量 | -1 | Decimal | 0 |
priuserdefdecm4 | 数值自定义项4 | 100 | Decimal | 0 |
priuserdefnvc5 | 字符自定义项5 | 60 | String | 0 |
UnitByPurchase | UnitByPurchase | 0 | DTO | 0 |
idUnitByPurchase | idUnitByPurchase | -1 | ID | 0 |
UnitByStock | UnitByStock | 0 | DTO | 0 |
idUnitByStock | idUnitByStock | -1 | ID | 0 |
priuserdefdecm5 | 数值自定义项5 | 100 | Decimal | 0 |
idUnitBySale | idUnitBySale | -1 | ID | 0 |
UnitBySale | UnitBySale | 0 | DTO | 0 |
ImageFile | ImageFile | 500 | String | 0 |
idBarCodeSolution | idbarcodesolution | 0 | ID | 0 |
BarCodeSolution | barcodesolution | 0 | DTO | 0 |
ControlRangeFreeitem0 | ControlRangeFreeitem0 | -1 | Bool | 0 |
ControlRangeFreeitem1 | ControlRangeFreeitem1 | -1 | Bool | 0 |
ControlRangeFreeitem2 | ControlRangeFreeitem2 | -1 | Bool | 0 |
ControlRangeFreeitem3 | ControlRangeFreeitem3 | -1 | Bool | 0 |
idunitByManufacture | idunitByManufacture | 0 | ID | 0 |
UnitByManufacture | UnitByManufacture | 0 | DTO | 0 |
ControlRangeFreeitem4 | ControlRangeFreeitem4 | -1 | Bool | 0 |
ControlRangeFreeitem5 | ControlRangeFreeitem5 | -1 | Bool | 0 |
ControlRangeFreeitem6 | ControlRangeFreeitem6 | -1 | Bool | 0 |
ControlRangeFreeitem7 | ControlRangeFreeitem7 | -1 | Bool | 0 |
FreeItemsEnum | FreeItemsEnum | 0 | DTOCollection | 0 |
ControlRangeFreeitem8 | ControlRangeFreeitem8 | -1 | Bool | 0 |
ControlRangeFreeitem9 | ControlRangeFreeitem9 | -1 | Bool | 0 |
Sku | Sku | 0 | DTO | 0 |
idsku | idsku | 0 | ID | 0 |
HasEverChanged | 编码是否手工修改过 | 32 | String | 0 |
BatchRunNumber | 批次流水号 | -1 | Decimal | 0 |
ReNewGoodSellDays | 补货销量天数 | -1 | Int | 0 |
ReNewGoodAheadDays | 补货提前天数 | -1 | Int | 0 |