Skip to content

title ​

doc_receipt_items

收货单明细表

字段 ​

字段名类型大小注释主键非空关联
receipt_idint8收货单ID√√
receipt_line_noint4收货单行号√√
in_statusvarchar50入库状态√
item_idint8商品ID√
pack_idint8包装ID√
lot_idint8批次ID√
quality_statusvarchar50质量状态√
qtynumeric收货数量√
put_qtynumeric上架数量√
plan_loc_idint8计划货位√
loc_idint8实际库位ID√
put_intentvarchar50入库意向√dict.PUT_INTENT
primary_codevarchar128一级容器编号√
secondary_codevarchar128二级容器编号√
upn_idint8唯一码ID√
container_idint8容器ID√
pricenumeric单价√
staff_idint8收货员ID√
remarkvarchar255备注√
old_receipt_line_noint4原收货行号√
asn_idint8预期到货通知单ID√
asn_line_noint4入库通知单行号√
create_byvarchar64创建者
create_attimestamptz建立时间√
update_byvarchar64修改者
update_attimestamptz更新时间√