Skip to content

title ​

doc_pick_task_items

拣货任务明细

字段 ​

字段名类型大小注释主键非空关联
task_idint8任务id√√
task_line_noint4任务行号√√
out_statusvarchar50出库状态√
inv_levelvarchar50库存级别√
pack_idint8包装Id√
pack_levelvarchar50包装级别√
item_idint8商品ID√
lot_idint8批属性id√
wh_area_idint8库区ID√
loc_idint8库位id√
primary_codevarchar128一级容器√
secondary_codevarchar128二级容器√
upn_idint8唯一码ID√
quality_statusvarchar50质量状态√
qtynumeric数量√
pick_qtynumeric拣货数量√
short_qtynumeric短拣数量√
cancel_qtynumeric取消数量√
alloc_idint8分配ID√
obtain_staff_idint8索取人ID√
obtain_timetimestamptz索取时间
confirm_staff_idint8确认人ID√
confirm_timetimestamptz确认时间
is_activevarchar50是否激活√dict.YESNO
wave_idint8波次ID√
owner_idint8货主id√
wh_idint8仓库id√
create_byvarchar64创建人
create_attimestamptz创建时间
update_byvarchar64更新人
update_attimestamptz更新时间