主要信息:agent_id 采购员, poh.segment1 订单编号,poh.po_header_id 订单头id,poh.vendor_id 供应商id ,poh.vendor_site_id 供应商地点,poh.terms_id 账期,poh.type_lookup_code 订单类型
主要关联表:po_agents/po_agents_v 采购员
po_vendors/ po_vendor_sites_all 供应商/供应商地点
ap_terms /ra_terms_tl 账期
image.png
po_headers_all 采购订单头
SEGMENT1 == '编号'
COMMENTS == '说明'
TYPE_LOOKUP_CODE == ‘类型’ 1、标准采购订单
AUTHORIZATION_STATUS == '审批状态' 1、未完成
CREATION_DATE == ‘订单时间’
VENDOR_ID == ‘供应商标识码’
VENDOR_SITE_ID == ‘供应商地址标识码’
CURRENCY_CODE == ‘币种’
AGENT_ID == ‘采购员’
BLANKET_TOTAL_AMOUNT == ‘金额’
CLOSED_CODE == ‘关闭状态’
网友评论