eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: SO_HEADERS_INTERFACE_ALL

Product:	OE - Order Entry
Description:	Imported order header information
Implementation/DBA Data:	OE.SO_HEADERS_INTERFACE_ALL

Primary Key: SO_HEADERS_INTERFACE_PK

ORIGINAL_SYSTEM_REFERENCE

Foreign Keys

Table	Foreign Table	Foreign Key Column
SO_HEADERS_INTERFACE_ALL	SO_ORDER_NUMBER_SOURCES	SO_HEADERS_INTERFACE_ALL.ORDER_NUMBER_SOURCE_ID
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.SHIP_TO_CUSTOMER_ID
SO_HEADERS_INTERFACE_ALL	RA_ADDRESSES_ALL	SO_HEADERS_INTERFACE_ALL.SHIP_ADDRESS_ID
SO_HEADERS_INTERFACE_ALL	SO_PRICE_LISTS_B	SO_HEADERS_INTERFACE_ALL.PRICE_LIST_ID
SO_HEADERS_INTERFACE_ALL	RA_TERMS_B	SO_HEADERS_INTERFACE_ALL.TERMS_ID
SO_HEADERS_INTERFACE_ALL	SO_CYCLES	SO_HEADERS_INTERFACE_ALL.CYCLE_ID
SO_HEADERS_INTERFACE_ALL	SO_AGREEMENTS_B	SO_HEADERS_INTERFACE_ALL.AGREEMENT_ID
SO_HEADERS_INTERFACE_ALL	%	SO_HEADERS_INTERFACE_ALL.ORDERED_BY_CONTACT_ID
SO_HEADERS_INTERFACE_ALL	%	SO_HEADERS_INTERFACE_ALL.INVOICE_TO_CONTACT_ID
SO_HEADERS_INTERFACE_ALL	%	SO_HEADERS_INTERFACE_ALL.SHIP_TO_CONTACT_ID
SO_HEADERS_INTERFACE_ALL	RA_RULES	SO_HEADERS_INTERFACE_ALL.ACCOUNTING_RULE_ID
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.CUSTOMER_ID
SO_HEADERS_INTERFACE_ALL	RA_RULES	SO_HEADERS_INTERFACE_ALL.INVOICING_RULE_ID
SO_HEADERS_INTERFACE_ALL	SO_ORDER_TYPES_115_ALL	SO_HEADERS_INTERFACE_ALL.ORDER_TYPE
SO_HEADERS_INTERFACE_ALL	SO_ORDER_TYPES_115_ALL	SO_HEADERS_INTERFACE_ALL.ORDER_TYPE_ID
SO_HEADERS_INTERFACE_ALL	FND_CURRENCIES	SO_HEADERS_INTERFACE_ALL.CURRENCY_CODE
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.CUSTOMER_NUMBER
SO_HEADERS_INTERFACE_ALL	SO_RESULTS_B	SO_HEADERS_INTERFACE_ALL.ENTERED_STATE_ID
SO_HEADERS_INTERFACE_ALL	SO_ORDER_SOURCES_115	SO_HEADERS_INTERFACE_ALL.ORDER_SOURCE_ID
SO_HEADERS_INTERFACE_ALL	RA_SALESREPS_ALL	SO_HEADERS_INTERFACE_ALL.SALESREP_ID
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.INVOICE_CUSTOMER_ID
SO_HEADERS_INTERFACE_ALL	RA_SITE_USES_ALL	SO_HEADERS_INTERFACE_ALL.INVOICE_TO_SITE_USE_ID
SO_HEADERS_INTERFACE_ALL	RA_ADDRESSES_ALL	SO_HEADERS_INTERFACE_ALL.INVOICE_ADDRESS_ID
SO_HEADERS_INTERFACE_ALL	RA_SITE_USES_ALL	SO_HEADERS_INTERFACE_ALL.SHIP_TO_SITE_USE_ID
SO_LINES_INTERFACE_ALL	SO_HEADERS_INTERFACE_ALL	SO_LINES_INTERFACE_ALL.ORIGINAL_SYSTEM_REFERENCE
SO_PRICE_ADJUSTMENTS_INTERFACE	SO_HEADERS_INTERFACE_ALL	SO_PRICE_ADJUSTMENTS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE
SO_SALES_CREDITS_INTERFACE	SO_HEADERS_INTERFACE_ALL	SO_SALES_CREDITS_INTERFACE.ORIGINAL_SYSTEM_REFERENCE