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_SITE_USES_ALL

Product:	AR - Receivables
Description:	Business purpose of a customer address
Implementation/DBA Data:	AR.RA_SITE_USES_ALL

Primary Key: RA_SITE_USES_PK

SITE_USE_ID

Primary Key: RA_SITE_USES_UK1

ADDRESS_ID
SITE_USE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
RA_SITE_USES_ALL	RA_SITE_USES_ALL	RA_SITE_USES_ALL.BILL_TO_SITE_USE_ID
RA_SITE_USES_ALL	%	RA_SITE_USES_ALL.FINCHRG_RECEIVABLES_TRX_ID
RA_SITE_USES_ALL	%	RA_SITE_USES_ALL.CONTACT_ID
RA_SITE_USES_ALL	RA_ADDRESSES_ALL	RA_SITE_USES_ALL.ADDRESS_ID
RA_SITE_USES_ALL	RA_TERMS_B	RA_SITE_USES_ALL.PAYMENT_TERM_ID
RA_SITE_USES_ALL	SO_ORDER_TYPES_115_ALL	RA_SITE_USES_ALL.ORDER_TYPE_ID
RA_SITE_USES_ALL	SO_PRICE_LISTS_B	RA_SITE_USES_ALL.PRICE_LIST_ID
RA_SITE_USES_ALL	RA_TERRITORIES	RA_SITE_USES_ALL.TERRITORY_ID
AR_CUSTOMER_PROFILES	RA_SITE_USES_ALL	AR_CUSTOMER_PROFILES.SITE_USE_ID
AR_CUSTOMER_PROFILE_AMOUNTS	RA_SITE_USES_ALL	AR_CUSTOMER_PROFILE_AMOUNTS.CUSTOMER_SITE_USE_ID
%	RA_SITE_USES_ALL
AS_SCRIPT_ACTUAL_ANSWERS	RA_SITE_USES_ALL	AS_SCRIPT_ACTUAL_ANSWERS.ADDRESS_ID
MRP_SR_ASSIGNMENTS	RA_SITE_USES_ALL	MRP_SR_ASSIGNMENTS.SHIP_TO_SITE_ID
MTL_INTERCOMPANY_PARAMETERS	RA_SITE_USES_ALL	MTL_INTERCOMPANY_PARAMETERS.CUSTOMER_SITE_ID
OE_HOLD_SOURCES_ALL	RA_SITE_USES_ALL	OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
PN_PAYMENT_ITEMS_ALL	RA_SITE_USES_ALL	PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL	RA_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PO_LOCATION_ASSOCIATIONS	RA_SITE_USES_ALL	PO_LOCATION_ASSOCIATIONS.SITE_USE_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_SITE_USES_ALL	RA_SITE_USES_ALL	RA_SITE_USES_ALL.BILL_TO_SITE_USE_ID
SO_AGREEMENTS_B	RA_SITE_USES_ALL	SO_AGREEMENTS_B.INVOICE_TO_SITE_USE_ID
SO_DISCOUNT_CUSTOMERS	RA_SITE_USES_ALL	SO_DISCOUNT_CUSTOMERS.SITE_USE_ID
SO_HEADERS_ALL	RA_SITE_USES_ALL	SO_HEADERS_ALL.INVOICE_TO_SITE_USE_ID
SO_HEADERS_ALL	RA_SITE_USES_ALL	SO_HEADERS_ALL.SHIP_TO_SITE_USE_ID
SO_HEADERS_INTERFACE_ALL	RA_SITE_USES_ALL	SO_HEADERS_INTERFACE_ALL.INVOICE_TO_SITE_USE_ID
SO_HEADERS_INTERFACE_ALL	RA_SITE_USES_ALL	SO_HEADERS_INTERFACE_ALL.SHIP_TO_SITE_USE_ID
SO_HOLD_RELEASES	RA_SITE_USES_ALL	SO_HOLD_RELEASES.HOLD_ENTITY_ID
SO_HOLD_SOURCES_ALL	RA_SITE_USES_ALL	SO_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
SO_LINES_ALL	RA_SITE_USES_ALL	SO_LINES_ALL.SHIP_TO_SITE_USE_ID
SO_LINES_INTERFACE_ALL	RA_SITE_USES_ALL	SO_LINES_INTERFACE_ALL.SHIP_TO_SITE_USE_ID
SO_PICKING_BATCHES_ALL	RA_SITE_USES_ALL	SO_PICKING_BATCHES_ALL.SITE_USE_ID
SO_PICKING_HEADERS_ALL	RA_SITE_USES_ALL	SO_PICKING_HEADERS_ALL.SHIP_TO_SITE_USE_ID
SO_PICKING_LINES_ALL	RA_SITE_USES_ALL	SO_PICKING_LINES_ALL.SHIP_TO_SITE_USE_ID
SO_PICKING_RULES	RA_SITE_USES_ALL	SO_PICKING_RULES.SITE_USE_ID
WSH_DELIVERIES	RA_SITE_USES_ALL	WSH_DELIVERIES.ULTIMATE_SHIP_TO_ID
WSH_DELIVERIES	RA_SITE_USES_ALL	WSH_DELIVERIES.INTERMEDIATE_SHIP_TO_ID
WSH_DELIVERY_TEMPLATES	RA_SITE_USES_ALL	WSH_DELIVERY_TEMPLATES.ULTIMATE_SHIP_TO_ID
WSH_DELIVERY_TEMPLATES	RA_SITE_USES_ALL	WSH_DELIVERY_TEMPLATES.INTERMEDIATE_SHIP_TO_ID