FND Design Data [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: TableAR.AR_LOCATION_VALUES_OLD
Primary Key: AR_LOCATION_VALUES_UK1
  1. ColumnLOCATION_SEGMENT_QUALIFIER
  2. ColumnLOCATION_SEGMENT_VALUE
  3. ColumnPARENT_SEGMENT_ID
Primary Key: AR_LOCATION_VALUES_UK2
  1. ColumnLOCATION_SEGMENT_QUALIFIER
  2. ColumnLOCATION_SEGMENT_VALUE
  3. ColumnLOCATION_SEGMENT_ID
Primary Key: AR_LOCATION_VALUES_UK4
  1. ColumnLOCATION_SEGMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_LOCATION_VALUES_OLD FK Joins to TableGL_CODE_COMBINATIONS AR_LOCATION_VALUES_OLD.TAX_ACCOUNT_CCID
AR_LOCATION_VALUES_OLD FK Joins to TableAR_LOCATION_VALUES_OLD AR_LOCATION_VALUES_OLD.PARENT_SEGMENT_ID
TableAR_LOCATION_VALUES_OLD FK Joins to AR_LOCATION_VALUES_OLD AR_LOCATION_VALUES_OLD.PARENT_SEGMENT_ID
TableJL_BR_AR_TX_EXC_FSC_ALL FK Joins to AR_LOCATION_VALUES_OLD JL_BR_AR_TX_EXC_FSC_ALL.SHIP_TO_SEGMENT_ID
TableJL_BR_AR_TX_EXC_ITM_ALL FK Joins to AR_LOCATION_VALUES_OLD JL_BR_AR_TX_EXC_ITM_ALL.SHIP_TO_SEGMENT_ID
TableJL_BR_AR_TX_LOCN_ALL FK Joins to AR_LOCATION_VALUES_OLD JL_BR_AR_TX_LOCN_ALL.SHIP_TO_SEGMENT_ID
TableJL_ZZ_AR_TX_LOCN_ALL FK Joins to AR_LOCATION_VALUES_OLD JL_ZZ_AR_TX_LOCN_ALL.SHIP_TO_SEGMENT_ID
TableRA_CUSTOMER_TRX_LINES_ALL FK Joins to AR_LOCATION_VALUES_OLD RA_CUSTOMER_TRX_LINES_ALL.LOCATION_SEGMENT_ID