Table: CN_SRP_PER_QUOTA_RC_ALL

Product:	CN - Incentive Compensation
Description:	Salesperson Revenue Classes by Period
Implementation/DBA Data:	CN.CN_SRP_PER_QUOTA_RC_ALL

Primary Key: CN_SRP_PER_QUOTA_RC_PK

1. SRP_PER_QUOTA_RC_ID

Primary Key: CN_SRP_PER_QUOTA_RC_UK1

1. SRP_PERIOD_QUOTA_ID
2. REVENUE_CLASS_ID

Primary Key: CN_SRP_PER_QUOTA_RC_UK2

1. SALESREP_ID
2. PERIOD_ID
3. QUOTA_ID
4. REVENUE_CLASS_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CN_SRP_PER_QUOTA_RC_ALL		CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_PER_QUOTA_RC_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_PER_QUOTA_RC_ALL		CN_QUOTAS_ALL	CN_SRP_PER_QUOTA_RC_ALL.QUOTA_ID
CN_SRP_PER_QUOTA_RC_ALL		CN_REVENUE_CLASSES_ALL	CN_SRP_PER_QUOTA_RC_ALL.REVENUE_CLASS_ID
CN_SRP_PER_QUOTA_RC_ALL		CN_SRP_PERIOD_QUOTAS_ALL	CN_SRP_PER_QUOTA_RC_ALL.SRP_PERIOD_QUOTA_ID