Skip to content

title ​

doc_pre_alloc_items

预分配明细表

字段 ​

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