FND Design Data [Home] [Help]

Table: SO_HEADERS_ALL

Product: OE - Order Entry
Description: Order header information
Implementation/DBA Data: TableOE.SO_HEADERS_ALL
Primary Key: SO_HEADERS_PK
  1. ColumnHEADER_ID
Primary Key: SO_HEADERS_UK1
  1. ColumnORDER_NUMBER
  2. ColumnORDER_TYPE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
SO_HEADERS_ALL FK Joins to TableRA_CUSTOMERS SO_HEADERS_ALL.CUSTOMER_ID
SO_HEADERS_ALL FK Joins to TableSO_AGREEMENTS_B SO_HEADERS_ALL.AGREEMENT_ID
SO_HEADERS_ALL FK Joins to Table% SO_HEADERS_ALL.ORDERED_BY_CONTACT_ID
SO_HEADERS_ALL FK Joins to Table% SO_HEADERS_ALL.INVOICE_TO_CONTACT_ID
SO_HEADERS_ALL FK Joins to Table% SO_HEADERS_ALL.SHIP_TO_CONTACT_ID
SO_HEADERS_ALL FK Joins to TableSO_HEADERS_ALL SO_HEADERS_ALL.SOURCE_HEADER_ID
SO_HEADERS_ALL FK Joins to TableFND_CURRENCIES SO_HEADERS_ALL.CURRENCY_CODE
SO_HEADERS_ALL FK Joins to TableSO_ORDER_TYPES_115_ALL SO_HEADERS_ALL.ORDER_TYPE_ID
SO_HEADERS_ALL FK Joins to TableSO_CYCLES SO_HEADERS_ALL.CYCLE_ID
SO_HEADERS_ALL FK Joins to TableRA_SALESREPS_ALL SO_HEADERS_ALL.SALESREP_ID
SO_HEADERS_ALL FK Joins to TableRA_SITE_USES_ALL SO_HEADERS_ALL.INVOICE_TO_SITE_USE_ID
SO_HEADERS_ALL FK Joins to TableRA_SITE_USES_ALL SO_HEADERS_ALL.SHIP_TO_SITE_USE_ID
SO_HEADERS_ALL FK Joins to TableSO_PRICE_LISTS_B SO_HEADERS_ALL.PRICE_LIST_ID
SO_HEADERS_ALL FK Joins to TableRA_TERMS_B SO_HEADERS_ALL.TERMS_ID
SO_HEADERS_ALL FK Joins to TableRA_RULES SO_HEADERS_ALL.ACCOUNTING_RULE_ID
TableAS_COLLATERAL_REQ_ALL FK Joins to SO_HEADERS_ALL AS_COLLATERAL_REQ_ALL.ORDER_NUMBER
TableCST_MARGIN_BUILD FK Joins to SO_HEADERS_ALL CST_MARGIN_BUILD.HEADER_ID
TableCST_MARGIN_TEMP FK Joins to SO_HEADERS_ALL CST_MARGIN_TEMP.HEADER_ID
TableICX_PANEL_SUMMARY FK Joins to SO_HEADERS_ALL ICX_PANEL_SUMMARY.LAST_ORDER_HEADER_ID
TableSO_HEADERS_ALL FK Joins to SO_HEADERS_ALL SO_HEADERS_ALL.SOURCE_HEADER_ID
TableSO_HOLD_RELEASES FK Joins to SO_HEADERS_ALL SO_HOLD_RELEASES.HOLD_ENTITY_ID
TableSO_HOLD_SOURCES_ALL FK Joins to SO_HEADERS_ALL SO_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
TableSO_LINES_ALL FK Joins to SO_HEADERS_ALL SO_LINES_ALL.HEADER_ID
TableSO_LINE_APPROVALS FK Joins to SO_HEADERS_ALL SO_LINE_APPROVALS.HEADER_ID
TableSO_NOTE_REFERENCES FK Joins to SO_HEADERS_ALL SO_NOTE_REFERENCES.HEADER_ID
TableSO_ORDER_APPROVALS FK Joins to SO_HEADERS_ALL SO_ORDER_APPROVALS.HEADER_ID
TableSO_ORDER_CANCELLATIONS FK Joins to SO_HEADERS_ALL SO_ORDER_CANCELLATIONS.HEADER_ID
TableSO_ORDER_HOLDS_ALL FK Joins to SO_HEADERS_ALL SO_ORDER_HOLDS_ALL.HEADER_ID
TableSO_PICKING_BATCHES_ALL FK Joins to SO_HEADERS_ALL SO_PICKING_BATCHES_ALL.HEADER_ID
TableSO_PICKING_HEADERS_ALL FK Joins to SO_HEADERS_ALL SO_PICKING_HEADERS_ALL.ORDER_HEADER_ID
TableSO_PICKING_RULES FK Joins to SO_HEADERS_ALL SO_PICKING_RULES.HEADER_ID
TableSO_PRICE_ADJUSTMENTS FK Joins to SO_HEADERS_ALL SO_PRICE_ADJUSTMENTS.HEADER_ID
TableSO_SALES_CREDITS FK Joins to SO_HEADERS_ALL SO_SALES_CREDITS.HEADER_ID