FND Design Data [Home] [Help]

Table: AMS_LIST_RULE_FIELDS

Product: AMS - Marketing
Description: This table stores the details about fields used by any rule for identifying the duplicates.
Implementation/DBA Data: TableAMS.AMS_LIST_RULE_FIELDS
Primary Key: AMS_LIST_RULE_FIELDS_PK
  1. ColumnLIST_RULE_FIELD_ID
Primary Key: AMS_LIST_RULE_FIELDS_UK1
  1. ColumnFIELD_COLUMN_NAME
  2. ColumnFIELD_TABLE_NAME
  3. ColumnLIST_RULE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_LIST_RULE_FIELDS FK Joins to TableAMS_LIST_FIELDS_B AMS_LIST_RULE_FIELDS.FIELD_COLUMN_NAME
AMS_LIST_RULE_FIELDS.FIELD_TABLE_NAME
AMS_LIST_RULE_FIELDS FK Joins to TableAMS_LIST_RULES_ALL AMS_LIST_RULE_FIELDS.LIST_RULE_ID