Skip to content

title ​

doc_alloc_items

分配明细表

字段 ​

字段名类型大小注释主键非空关联
alloc_idint8分配ID√√
order_typevarchar50订单类型√
order_biz_typevarchar50单据业务类型√
out_statusvarchar50分配状态√
pack_levelvarchar50包装级别√
item_idint8产品ID√
lot_idint8批属性id√
pack_idint8包装ID√
quality_statusvarchar50质量状态√
target_pack_levelvarchar50目标包装级别√
loc_idint8库位id√
primary_codevarchar128一级容器√
secondary_codevarchar128箱条码√
upn_idint8唯一码ID√
inv_levelvarchar50库存级别√
qtynumeric分配数量√
cancel_qtynumeric取消数量√
is_mergevarchar50是否合并√
is_activevarchar50是否激活√dict.YESNO
rep_put_loc_idint8补货上架货位√
pre_alloc_idint8预分配ID√
rep_alloc_idint8关联补货ID√
rep_surplus_qtynumeric补货剩余数量√
is_rep_overvarchar50是否补货完成√
wave_idint8波次ID√
wh_idint8仓库id√
owner_idint8货主id√
create_byvarchar64创建者√
create_attimestamptz建立时间√
update_byvarchar64修改者√
update_attimestamptz更新时间√