FND Design Data [Home] [Help]

Table: CN_COMP_PLANS_ALL

Product: CN - Incentive Compensation
Description: Compensation Plans
Implementation/DBA Data: TableCN.CN_COMP_PLANS_ALL
Primary Key: CN_COMP_PLANS_PK
  1. ColumnCOMP_PLAN_ID
Primary Key: CN_COMP_PLANS_UK1
  1. ColumnNAME
  2. ColumnVERSION
Foreign Keys
Table
Foreign Table Foreign Key Column
TableCN_QUOTA_ASSIGNS_ALL FK Joins to CN_COMP_PLANS_ALL CN_QUOTA_ASSIGNS_ALL.COMP_PLAN_ID
TableCN_ROLE_PLANS_ALL FK Joins to CN_COMP_PLANS_ALL CN_ROLE_PLANS_ALL.COMP_PLAN_ID
TableCN_SRP_PLAN_ASSIGNS_ALL FK Joins to CN_COMP_PLANS_ALL CN_SRP_PLAN_ASSIGNS_ALL.COMP_PLAN_ID