Skip to content

title ​

doc_quality_items

质检单明细

字段 ​

字段名类型大小注释主键非空关联
quality_idint8质检单ID√√
quality_line_noint4质检单行号√√
in_statusvarchar50入库状态√
item_idint8商品ID√
lot_idint8批次ID√
pack_idint8包装ID√
primary_codevarchar255一级容器条码√
secondary_codevarchar255二级容器条码√
upn_idint8唯一码ID√
qtynumeric数量√
quality_qtynumeric质检数量√
qualified_qtynumeric合格数量√
unqualified_qtynumeric不合格数量√
reject_qtynumeric拒收数量√
quality_conclusionvarchar50质检结论√
super_doc_idint8上级单据ID√
super_doc_codevarchar128上级单据编号√
super_line_noint4上级单据行号√
super_in_stepvarchar50上级入库阶段√
create_byvarchar64创建者
create_attimestamptz建立时间
update_byvarchar64修改者
update_attimestamptz更新时间