FND Design Data [Home] [Help]

Table: CN_QUOTA_ASSIGNS_ALL

Product: CN - Incentive Compensation
Description: Elements assigned to a compensation plan
Implementation/DBA Data: TableCN.CN_QUOTA_ASSIGNS_ALL
Primary Key: CN_QUOTA_ASSIGNS_PK
  1. ColumnQUOTA_ASSIGN_ID
Primary Key: CN_QUOTA_ASSIGNS_UK1
  1. ColumnCOMP_PLAN_ID
  2. ColumnQUOTA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CN_QUOTA_ASSIGNS_ALL FK Joins to TableCN_QUOTAS_ALL CN_QUOTA_ASSIGNS_ALL.QUOTA_ID
CN_QUOTA_ASSIGNS_ALL FK Joins to TableCN_COMP_PLANS_ALL CN_QUOTA_ASSIGNS_ALL.COMP_PLAN_ID