Skip to content

title ​

doc_put_real_items

上架单实际明细

字段 ​

字段名类型大小注释主键非空关联
put_real_idint8实际上架明细ID√√
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数量√
loc_idint8库位ID√
inv_to_loc_idint8库存转移库位ID
put_staff_idint8上架员ID√
create_byvarchar64创建者√
create_attimestamptz建立时间
update_byvarchar64修改者√
update_attimestamptz更新时间