Skip to content

title ​

doc_review_task_real_items

复核任务实际明细

字段 ​

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