Skip to content

title ​

doc_pick_task_real_items

拣货任务实际明细

字段 ​

字段名类型大小注释主键非空关联
pick_real_idint8拣货任务实际明细ID√√
task_idint8任务id√
task_line_noint4任务行号√
out_statusvarchar50出库状态√
inv_levelvarchar50库存级别√
pack_idint8包装ID√
pack_levelvarchar50包装级别√
item_idint8商品ID√
lot_idint8批属性id√
loc_idint8库位id√
primary_codevarchar128一级容器√
secondary_codevarchar128二级容器√
upn_idint8唯一码ID√
quality_statusvarchar50质量状态√
qtynumeric库存数量√
inv_to_loc_idint8库存中转库位ID√
wave_idint8波次ID√
owner_idint8货主id√
wh_idint8仓库id√
is_activevarchar50是否激活√
create_byvarchar64创建人√
create_attimestamptz创建时间√
update_byvarchar64更新人√
update_attimestamptz更新时间√