FND Design Data [Home] [Help]

Table: PO_HEADERS_ARCHIVE_ALL

Product: PO - Purchasing
Description: Archived purchase orders
Implementation/DBA Data: TablePO.PO_HEADERS_ARCHIVE_ALL
Primary Key: PO_HEADERS_ARCHIVE_PK
  1. ColumnPO_HEADER_ID
  2. ColumnREVISION_NUM
Primary Key: PO_HEADERS_ARCHIVE_UK1
  1. ColumnSEGMENT1
  2. ColumnREVISION_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_HEADERS_ARCHIVE_ALL FK Joins to TablePO_AGENTS PO_HEADERS_ARCHIVE_ALL.AGENT_ID
PO_HEADERS_ARCHIVE_ALL FK Joins to TablePO_HEADERS_ALL PO_HEADERS_ARCHIVE_ALL.FROM_HEADER_ID
PO_HEADERS_ARCHIVE_ALL FK Joins to TablePO_VENDORS PO_HEADERS_ARCHIVE_ALL.VENDOR_ID
PO_HEADERS_ARCHIVE_ALL FK Joins to TablePO_VENDOR_SITES_ALL PO_HEADERS_ARCHIVE_ALL.VENDOR_SITE_ID
PO_HEADERS_ARCHIVE_ALL FK Joins to TablePO_VENDOR_CONTACTS PO_HEADERS_ARCHIVE_ALL.VENDOR_CONTACT_ID
PO_HEADERS_ARCHIVE_ALL FK Joins to TableFND_CURRENCIES PO_HEADERS_ARCHIVE_ALL.CURRENCY_CODE
PO_HEADERS_ARCHIVE_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PO_HEADERS_ARCHIVE_ALL.RATE_TYPE
TableICX_PO_REVISIONS_TEMP FK Joins to PO_HEADERS_ARCHIVE_ALL ICX_PO_REVISIONS_TEMP.HEADER_ID
ICX_PO_REVISIONS_TEMP.REVISION_NUM