Skip to content

title ​

doc_po_items

采购单汇总表

字段 ​

字段名类型大小注释主键非空关联
po_idint8采购订单ID√√
po_line_noint4行号√√
item_idint8商品ID√
lot_idint8批次ID√
batch_novarchar255批号√
production_datevarchar128生产日期√
valid_untilvarchar128有效期至√
amountnumeric金额√
print_production_datevarchar128打印生产日期√
print_valid_untilvarchar128打印有效期至√
pack_idint8包装ID√
qtynumeric数量√
asn_qtynumericASN数量√
primary_codevarchar128一级容器条码√
secondary_codevarchar128二级容器条码√
upn_idint8唯一码ID√
quality_statusvarchar50质量状态√
in_statusvarchar50入库状态√
pricenumeric单价√
approval_novarchar255批准文号√
reasonsvarchar50退货原因√
colorvarchar255颜色√
manufacturervarchar255生产厂家√
producing_areavarchar255产地√
create_byvarchar64创建者
create_attimestamptz建立时间
update_byvarchar64修改者
update_attimestamptz修改时间