Skip to content

title ​

doc_inventory_items

库存盘点明细

字段 ​

字段名类型大小注释主键非空关联
inventory_idint8盘点ID√√
inventory_line_noint4盘点单行号√√
inventory_statusvarchar50盘点状态√
item_idint8skuid√
lot_idint8批属性id√
loc_idint8库位id√
quality_statusvarchar50质量状态√
primary_codevarchar128一级容器编号√
secondary_codevarchar128二级容器编号√
upn_idint8唯一码ID√
qtynumeric库存数量√
real_qtynumeric实际库存数量√
owner_idint8货主id√
wh_idint8仓库id√
create_byvarchar64创建者√
create_attimestamptz建立时间
update_byvarchar64修改者√
update_attimestamptz更新时间
parent_inventory_idint8父级盘点ID
parent_inventory_line_noint4父级盘点单行号
diff_idint8盘点审核ID