Skip to content

title ​

doc_so_items

出库订单明细

字段 ​

字段名类型大小注释主键非空关联
so_idint8出库单id√√
so_line_noint4出库单行号√√
out_statusvarchar50出库状态√
item_idint8商品id√
lot_idint8批次id√
primary_codevarchar128一级容器√√
secondary_codevarchar128二级容器√√
upn_idint8唯一码ID√√
quality_statusvarchar50质量状态√
qtynumeric数量√
pre_alloc_qtynumeric预分配数量√
alloc_qtynumeric分配数量√
exception_qtynumeric异常数量√
cancel_qtynumeric取消数量√
wave_cancel_qtynumeric波次取消数量√
remarkvarchar255备注√
parent_order_codevarchar128客户订单编号√
parent_order_lineint4客户订单行号√
create_attimestamptz创建时间√
create_byvarchar64创建人√
update_attimestamptz更新时间√
update_byvarchar64更新人√