Skip to content

title ​

inv_cmd

库存记账指令

字段 ​

字段名类型大小注释主键非空关联
cmd_idint8指令ID√√
cmd_line_noint4指令行号√√
order_idint8单据ID√
order_codevarchar255业务单号√
order_line_noint4单据行号√
order_typevarchar50单据类型√
order_biz_typevarchar50单据业务类型√
cmd_statevarchar50任务状态√
inv_levelvarchar50库存级别√
inv_typevarchar50记账类型√
inv_reasonvarchar50执行原因√
item_idint8商品号√
lot_idint8批次号√
loc_idint8货位ID√
primary_codevarchar128一级容器√
secondary_codevarchar128二级容器√
upn_idint8唯一码ID√
quality_statusvarchar50质量状态√
qtynumeric数量√
wh_idint8仓库ID√
owner_idint8货主ID√
create_attimestamptz创建时间
create_byvarchar64创建人
update_attimestamptz更新时间
update_byvarchar64更新人