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

Product:	AR - Receivables
Description:	Defines the location and description for each of the value sets used in the Sales Tax Location flexfield
Implementation/DBA Data:	AR.AR_LOCATION_VALUES_OLD

Primary Key: AR_LOCATION_VALUES_UK1

LOCATION_SEGMENT_QUALIFIER
LOCATION_SEGMENT_VALUE
PARENT_SEGMENT_ID

Primary Key: AR_LOCATION_VALUES_UK2

LOCATION_SEGMENT_QUALIFIER
LOCATION_SEGMENT_VALUE
LOCATION_SEGMENT_ID

Primary Key: AR_LOCATION_VALUES_UK4

LOCATION_SEGMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_LOCATION_VALUES_OLD	GL_CODE_COMBINATIONS	AR_LOCATION_VALUES_OLD.TAX_ACCOUNT_CCID
AR_LOCATION_VALUES_OLD	AR_LOCATION_VALUES_OLD	AR_LOCATION_VALUES_OLD.PARENT_SEGMENT_ID
AR_LOCATION_ACCOUNTS_ALL	AR_LOCATION_VALUES_OLD	AR_LOCATION_ACCOUNTS_ALL.LOCATION_SEGMENT_ID
AR_LOCATION_RATES_OLD	AR_LOCATION_VALUES_OLD	AR_LOCATION_RATES_OLD.LOCATION_SEGMENT_ID
AR_LOCATION_VALUES_OLD	AR_LOCATION_VALUES_OLD	AR_LOCATION_VALUES_OLD.PARENT_SEGMENT_ID
AR_TAX_INTERFACE	AR_LOCATION_VALUES_OLD	AR_TAX_INTERFACE.LOCATION_SEGMENT_ID
JL_BR_AR_TX_EXC_FSC_ALL	AR_LOCATION_VALUES_OLD	JL_BR_AR_TX_EXC_FSC_ALL.SHIP_TO_SEGMENT_ID
JL_BR_AR_TX_EXC_ITM_ALL	AR_LOCATION_VALUES_OLD	JL_BR_AR_TX_EXC_ITM_ALL.SHIP_TO_SEGMENT_ID
JL_BR_AR_TX_LOCN_ALL	AR_LOCATION_VALUES_OLD	JL_BR_AR_TX_LOCN_ALL.SHIP_TO_SEGMENT_ID
JL_ZZ_AR_TX_LOCN_ALL	AR_LOCATION_VALUES_OLD	JL_ZZ_AR_TX_LOCN_ALL.SHIP_TO_SEGMENT_ID
RA_CUSTOMER_TRX_LINES_ALL	AR_LOCATION_VALUES_OLD	RA_CUSTOMER_TRX_LINES_ALL.LOCATION_SEGMENT_ID
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_9
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_10
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_1
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_2
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_3
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_4
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_5
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_6
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_7
RA_ITEM_EXCEPTION_RATES	AR_LOCATION_VALUES_OLD	RA_ITEM_EXCEPTION_RATES.LOCATION_ID_SEGMENT_8
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_7
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_8
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_9
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_10
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_1
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_2
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_3
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_4
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_5
RA_TAX_EXEMPTIONS_ALL	AR_LOCATION_VALUES_OLD	RA_TAX_EXEMPTIONS_ALL.LOCATION_ID_SEGMENT_6