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: RA_CUSTOMERS

Product:	AR - Receivables
Description:	Customer information
Implementation/DBA Data:	AR.RA_CUSTOMERS

Primary Key: RA_CUSTOMERS_PK

CUSTOMER_ID

Primary Key: RA_CUSTOMERS_UK1

CUSTOMER_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
RA_CUSTOMERS	RA_SALESREPS_ALL	RA_CUSTOMERS.PRIMARY_SALESREP_ID
RA_CUSTOMERS	RA_SITE_USES_ALL	RA_CUSTOMERS.DUNNING_SITE_USE_ID
RA_CUSTOMERS	RA_SITE_USES_ALL	RA_CUSTOMERS.STATEMENT_SITE_USE_ID
RA_CUSTOMERS	SO_ORDER_TYPES_115_ALL	RA_CUSTOMERS.ORDER_TYPE_ID
RA_CUSTOMERS	SO_PRICE_LISTS_B	RA_CUSTOMERS.PRICE_LIST_ID
RA_CUSTOMERS	RA_TERMS_B	RA_CUSTOMERS.PAYMENT_TERM_ID
AR_CUSTOMER_PROFILES	RA_CUSTOMERS	AR_CUSTOMER_PROFILES.CUSTOMER_ID
AR_CUSTOMER_PROFILE_AMOUNTS	RA_CUSTOMERS	AR_CUSTOMER_PROFILE_AMOUNTS.CUSTOMER_ID
%	RA_CUSTOMERS
AS_ACCESSES_ALL_ALL	RA_CUSTOMERS	AS_ACCESSES_ALL_ALL.CUSTOMER_ID
AS_COLLATERAL_REQ_ALL	RA_CUSTOMERS	AS_COLLATERAL_REQ_ALL.CUSTOMER_ID
AS_EVENT_ENROLLMENTS_ALL	RA_CUSTOMERS	AS_EVENT_ENROLLMENTS_ALL.CUSTOMER_ID
AS_INTERESTS_ALL	RA_CUSTOMERS	AS_INTERESTS_ALL.CUSTOMER_ID
AS_LEADS_ALL	RA_CUSTOMERS	AS_LEADS_ALL.CUSTOMER_ID
AS_LIST_ENTRIES	RA_CUSTOMERS	AS_LIST_ENTRIES.CUSTOMER_ID
AS_SALESFORCE	RA_CUSTOMERS	AS_SALESFORCE.PARTNER_CUSTOMER_ID
AS_SCRIPT_ACTUAL_ANSWERS	RA_CUSTOMERS	AS_SCRIPT_ACTUAL_ANSWERS.CUSTOMER_ID
AS_TERRITORY_VALUES_ALL	RA_CUSTOMERS	AS_TERRITORY_VALUES_ALL.CUSTOMER_ID
ICX_PANEL_SUMMARY	RA_CUSTOMERS	ICX_PANEL_SUMMARY.CUSTOMER_ID
MRP_SR_ASSIGNMENTS	RA_CUSTOMERS	MRP_SR_ASSIGNMENTS.CUSTOMER_ID
MTL_CI_INTERFACE	RA_CUSTOMERS	MTL_CI_INTERFACE.CUSTOMER_ID
MTL_CI_XREFS_INTERFACE	RA_CUSTOMERS	MTL_CI_XREFS_INTERFACE.CUSTOMER_ID
MTL_CUSTOMER_ITEMS	RA_CUSTOMERS	MTL_CUSTOMER_ITEMS.CUSTOMER_ID
MTL_INTERCOMPANY_PARAMETERS	RA_CUSTOMERS	MTL_INTERCOMPANY_PARAMETERS.CUSTOMER_ID
OE_CUST_ITEM_SETTINGS	RA_CUSTOMERS	OE_CUST_ITEM_SETTINGS.CUSTOMER_ID
OE_HOLD_SOURCES_ALL	RA_CUSTOMERS	OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
PA_AGREEMENTS_ALL	RA_CUSTOMERS	PA_AGREEMENTS_ALL.CUSTOMER_ID
PA_PROJECT_CONTACTS	RA_CUSTOMERS	PA_PROJECT_CONTACTS.CUSTOMER_ID
PA_PROJECT_CUSTOMERS	RA_CUSTOMERS	PA_PROJECT_CUSTOMERS.CUSTOMER_ID
PN_PAYMENT_ITEMS_ALL	RA_CUSTOMERS	PN_PAYMENT_ITEMS_ALL.CUSTOMER_ID
PN_PAYMENT_TERMS_ALL	RA_CUSTOMERS	PN_PAYMENT_TERMS_ALL.CUSTOMER_ID
PO_LOCATION_ASSOCIATIONS	RA_CUSTOMERS	PO_LOCATION_ASSOCIATIONS.CUSTOMER_ID
QA_RESULTS	RA_CUSTOMERS	QA_RESULTS.CUSTOMER_ID
RA_ADDRESSES_ALL	RA_CUSTOMERS	RA_ADDRESSES_ALL.CUSTOMER_ID
%	RA_CUSTOMERS
RA_CUSTOMER_MERGE_HEADERS	RA_CUSTOMERS	RA_CUSTOMER_MERGE_HEADERS.DUPLICATE_ID
RA_CUSTOMER_RELATIONSHIPS_ALL	RA_CUSTOMERS	RA_CUSTOMER_RELATIONSHIPS_ALL.RELATED_CUSTOMER_ID
RA_CUSTOMER_RELATIONSHIPS_ALL	RA_CUSTOMERS	RA_CUSTOMER_RELATIONSHIPS_ALL.CUSTOMER_ID
RA_PHONES	RA_CUSTOMERS	RA_PHONES.CUSTOMER_ID
SO_AGREEMENTS_B	RA_CUSTOMERS	SO_AGREEMENTS_B.CUSTOMER_ID
SO_DISCOUNT_CUSTOMERS	RA_CUSTOMERS	SO_DISCOUNT_CUSTOMERS.CUSTOMER_ID
SO_HEADERS_ALL	RA_CUSTOMERS	SO_HEADERS_ALL.CUSTOMER_ID
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.SHIP_TO_CUSTOMER_ID
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.CUSTOMER_ID
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.CUSTOMER_NUMBER
SO_HEADERS_INTERFACE_ALL	RA_CUSTOMERS	SO_HEADERS_INTERFACE_ALL.INVOICE_CUSTOMER_ID
SO_HOLD_RELEASES	RA_CUSTOMERS	SO_HOLD_RELEASES.HOLD_ENTITY_ID
SO_HOLD_SOURCES_ALL	RA_CUSTOMERS	SO_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
SO_ORDER_APPROVALS	RA_CUSTOMERS	SO_ORDER_APPROVALS.CUSTOMER_ID
SO_PICKING_BATCHES_ALL	RA_CUSTOMERS	SO_PICKING_BATCHES_ALL.CUSTOMER_ID
SO_PICKING_RULES	RA_CUSTOMERS	SO_PICKING_RULES.CUSTOMER_ID
WSH_CALENDAR_ASSIGNMENTS	RA_CUSTOMERS	WSH_CALENDAR_ASSIGNMENTS.CUSTOMER_ID
WSH_DELIVERIES	RA_CUSTOMERS	WSH_DELIVERIES.CUSTOMER_ID
WSH_DELIVERY_TEMPLATES	RA_CUSTOMERS	WSH_DELIVERY_TEMPLATES.CUSTOMER_ID