Skip to content

title ​

doc_review_task_items

复核任务明细

字段 ​

字段名类型大小注释主键非空关联
task_idint8任务id√√
task_line_noint4任务行号√√
out_statusvarchar50出库状态√
package_snvarchar255包裹流水号√
pack_idint8包装ID√
pack_levelvarchar50包装级别√
item_idint8商品ID√
lot_idint8批属性id√
loc_idint8库位id√
primary_codevarchar128一级容器√
secondary_codevarchar128二级容器√
upn_idint8唯一码ID√
quality_statusvarchar50质量状态√
qtynumeric库存数量√
review_qtynumeric复核数量√
short_qtynumeric短缺数量√
cancel_qtynumeric取消数量√
obtain_staff_idint8索取人ID√
obtain_timetimestamptz索取时间
confirm_staff_idint8确认人ID√
confirm_timetimestamptz确认时间
is_activevarchar50是否激活√
pick_real_idint8实际拣货ID√
so_idint8订单ID√
so_line_noint4订单行√
wave_idint8波次ID√
owner_idint8货主id√
wh_idint8仓库id√
create_byvarchar64创建人
create_attimestamptz创建时间
update_byvarchar64更新人
update_attimestamptz更新时间