主要信息：agent_id 采購員轩勘， poh.segment1 訂單編號(hào)，poh.po_header_id 訂單頭id怯邪，poh.vendor_id 供應(yīng)商id 绊寻，poh.vendor_site_id 供應(yīng)商地點(diǎn)，poh.terms_id 賬期悬秉，poh.type_lookup_code 訂單類型
主要關(guān)聯(lián)表：po_agents/po_agents_v 采購員
po_vendors/ po_vendor_sites_all 供應(yīng)商/供應(yīng)商地點(diǎn)
ap_terms /ra_terms_tl 賬期
image.png
po_headers_all 采購訂單頭
SEGMENT1 == '編號(hào)'
COMMENTS == '說明'
TYPE_LOOKUP_CODE == ‘類型’ 1澄步、標(biāo)準(zhǔn)采購訂單
image.png
AUTHORIZATION_STATUS == '審批狀態(tài)' 1、未完成
CREATION_DATE == ‘訂單時(shí)間’
VENDOR_ID == ‘供應(yīng)商標(biāo)識(shí)碼’
VENDOR_SITE_ID == ‘供應(yīng)商地址標(biāo)識(shí)碼’
CURRENCY_CODE == ‘幣種’
image.png
AGENT_ID == ‘采購員’
BLANKET_TOTAL_AMOUNT == ‘金額’
CLOSED_CODE == ‘關(guān)閉狀態(tài)’
