Skip to content

title ​

doc_inner_move_items

移库单明细

字段 ​

字段名类型大小注释主键非空关联
inner_move_idint8库内库存转移单ID√√
inner_move_line_noint4库内库存转移单行号√√
inner_move_typevarchar50转移类型√√
sort_numberint4排序号√√
item_idint8商品ID√
lot_idint8批次ID√
quality_statusvarchar50质量状态√
loc_idint8库位ID√
source_loc_idint8原货位ID√
pallet_codevarchar128托盘条码√
source_pallet_codevarchar128原托盘条码√
box_codevarchar128箱条码√
source_box_codevarchar128箱条码√
grid_novarchar128格口号√
source_grid_novarchar128原格口号√
tray_codevarchar128跟踪号√
super_box_codevarchar128叠箱条码√
inner_move_staff_idint8操作员ID√
inner_move_statusvarchar50行状态√
create_byvarchar64创建者√
create_attimestamptz建立时间√
update_byvarchar64修改者√
update_attimestamptz更新时间√