Skip to content

title ​

doc_put_items

上架单明细表

字段 ​

字段名类型大小注释主键非空关联
put_idint8上架单ID√√
put_line_noint4上架单行号√√
in_statusvarchar50入库状态√
item_idint8商品ID√
pack_idint8包装ID√
lot_idint8库存批次ID√
quality_statusvarchar50质量状态√
primary_codevarchar128一级容器条码√
secondary_codevarchar128二级容器条码√
upn_idint8唯一码ID√
qtynumeric数量√
put_qtynumeric上架数量√
plan_loc_idint8计划库位ID√
loc_idint8库位ID√
inv_to_loc_idint8库存转移库位ID√
put_staff_idint8上架员ID√
rep_alloc_idint8补货分配ID√
receipt_idint8收货单ID√
receipt_line_noint4收货单行号√
asn_idint8预期到货通知单ID√
asn_line_noint4入库通知单行号√
create_byvarchar64创建者
create_attimestamptz建立时间√
update_byvarchar64修改者
update_attimestamptz更新时间√