Skip to content

title ​

inv_lot

商品批次库存

字段 ​

字段名类型大小注释主键非空关联
wh_idint8仓库ID√√
owner_idint8货主ID√√
item_idint8产品ID√√
lot_idint8批属性ID√√
quality_statusvarchar50质量状态√√dict.INV_QUALITY_STATUS
qtynumeric库存数量√
qty_innumeric计划入库数量√
qty_pre_allocatednumeric预分配数量√
qty_allocatednumeric分配数量√
qty_on_holdnumeric冻结数量√
qty_locknumeric锁定数量√
qty_profitnumeric计划溢数量√
qty_lossnumeric计划损数量√
create_byvarchar64创建者√
create_attimestamptz建立时间√
update_byvarchar64修改者√
update_attimestamptz更新时间√