FND Design Data [Home] [Help]

Table: AR_LOCATION_VALUES

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: Not implemented in this database
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 FK Joins to TableGL_CODE_COMBINATIONS AR_LOCATION_VALUES.TAX_ACCOUNT_CCID
AR_LOCATION_VALUES FK Joins to TableAR_LOCATION_VALUES AR_LOCATION_VALUES.PARENT_SEGMENT_ID
TableAR_LOCATION_RATES FK Joins to AR_LOCATION_VALUES AR_LOCATION_RATES.LOCATION_SEGMENT_ID
TableAR_LOCATION_VALUES FK Joins to AR_LOCATION_VALUES AR_LOCATION_VALUES.PARENT_SEGMENT_ID
TableGR_DOCUMENT_RTK FK Joins to AR_LOCATION_VALUES GR_DOCUMENT_RTK.LOCATION_SEGMENT_QUALIFIER
GR_DOCUMENT_RTK.LOCATION_SEGMENT_VALUE
GR_DOCUMENT_RTK.PARENT_SEGMENT_ID
TableGR_ITEM_RIGHT_TO_KNOW FK Joins to AR_LOCATION_VALUES GR_ITEM_RIGHT_TO_KNOW.LOCATION_SEGMENT_QUALIFIER
GR_ITEM_RIGHT_TO_KNOW.LOCATION_SEGMENT_VALUE
GR_ITEM_RIGHT_TO_KNOW.PARENT_SEGMENT_ID