FND Design Data [Home] [Help]

Table: VEA_PARAMETER_MAPPINGS

Product: VEA - Automotive
Description: Mapping of trading partner selector program unit parameters with base layer program unit parameters
Implementation/DBA Data: TableVEA.VEA_PARAMETER_MAPPINGS
Primary Key: PK_VEA_PARAMETER_MAPPINGS
  1. ColumnLAYER_PROVIDER_CODE
  2. ColumnPARAMETER_MAPPING_ID
Primary Key: UK1_VEA_PARAMETER_MAPPINGS
  1. ColumnLAYER_PROVIDER_CODE
  2. ColumnLAYER_HEADER_ID
  3. ColumnTPS_PARAMETER_ID
  4. ColumnTPS_PARAMETER_LP_CODE
Primary Key: VEA_PARAMETER_MAPPINGS_PK
  1. ColumnLAYER_PROVIDER_CODE
  2. ColumnPARAMETER_MAPPING_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
VEA_PARAMETER_MAPPINGS FK Joins to TableVEA_LAYER_HEADERS VEA_PARAMETER_MAPPINGS.LAYER_PROVIDER_CODE
VEA_PARAMETER_MAPPINGS.LAYER_HEADER_ID
VEA_PARAMETER_MAPPINGS FK Joins to TableVEA_PARAMETERS VEA_PARAMETER_MAPPINGS.PROGRAM_UNIT_PARAM_LP_CODE
VEA_PARAMETER_MAPPINGS.PROGRAM_UNIT_PARAMETER_ID
VEA_PARAMETER_MAPPINGS FK Joins to TableVEA_PARAMETERS VEA_PARAMETER_MAPPINGS.TPS_PARAMETER_LP_CODE
VEA_PARAMETER_MAPPINGS.TPS_PARAMETER_ID