Skip to content

title ​

doc_inv_diff

库存差异记录

字段 ​

字段名类型大小注释主键非空关联
diff_idint8差异ID√√
order_typevarchar50订单类型√
order_biz_typevarchar50订单业务类型√
doc_idint8订单ID√
doc_codevarchar128订单编号√
doc_line_noint4订单行号√
item_idint8skuid√
lot_idint8批属性id√
loc_idint8库位id√
primary_codevarchar128一级容器编号√
secondary_codevarchar128二级容器编号√
upn_idint8唯一码ID√
quality_statusvarchar50质量状态√
inv_qtynumeric库存数量√
qtynumeric差异数量√
owner_idint8货主id√
wh_idint8仓库id√
create_byvarchar64创建者√
create_attimestamptz建立时间
update_byvarchar64修改者√
update_attimestamptz更新时间
audit_statusvarchar50审批状态√
audit_reasonvarchar255审批原因