FND Design Data [Home] [Help]

Table: CN_QUOTA_RULES_ALL

Product: CN - Incentive Compensation
Description: Revenue classes assigned to a plan element
Implementation/DBA Data: TableCN.CN_QUOTA_RULES_ALL
Primary Key: CN_QUOTA_RULES_PK
  1. ColumnQUOTA_RULE_ID
Primary Key: CN_QUOTA_RULES_UK1
  1. ColumnREVENUE_CLASS_ID
  2. ColumnQUOTA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CN_QUOTA_RULES_ALL FK Joins to TableCN_REVENUE_CLASSES_ALL CN_QUOTA_RULES_ALL.REVENUE_CLASS_ID
CN_QUOTA_RULES_ALL FK Joins to TableCN_QUOTAS_ALL CN_QUOTA_RULES_ALL.QUOTA_ID
TableCN_COMMISSION_LINES_ALL FK Joins to CN_QUOTA_RULES_ALL CN_COMMISSION_LINES_ALL.QUOTA_RULE_ID
TableCN_QUOTA_RULE_UPLIFTS_ALL FK Joins to CN_QUOTA_RULES_ALL CN_QUOTA_RULE_UPLIFTS_ALL.QUOTA_RULE_ID
TableCN_SRP_QUOTA_RULES_ALL FK Joins to CN_QUOTA_RULES_ALL CN_SRP_QUOTA_RULES_ALL.QUOTA_RULE_ID
TableCN_TRX_FACTORS_ALL FK Joins to CN_QUOTA_RULES_ALL CN_TRX_FACTORS_ALL.QUOTA_RULE_ID