eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: CN_SRP_QUOTA_ASSIGNS_ALL

Product:	CN - Incentive Compensation
Description:	Salesperson Plan Element Assignments
Implementation/DBA Data:	CN.CN_SRP_QUOTA_ASSIGNS_ALL

Primary Key: CN_SRP_QUOTA_ASSIGNS_PK

SRP_QUOTA_ASSIGN_ID

Primary Key: CN_SRP_QUOTA_ASSIGNS_UK1

SRP_PLAN_ASSIGN_ID
QUOTA_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_QUOTA_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_QUOTA_ASSIGNS_ALL	CN_RATE_SCHEDULES_ALL	CN_SRP_QUOTA_ASSIGNS_ALL.RATE_SCHEDULE_ID
CN_SRP_QUOTA_ASSIGNS_ALL	CN_QUOTAS_ALL	CN_SRP_QUOTA_ASSIGNS_ALL.QUOTA_ID
CN_SRP_PAYEE_ASSIGNS_ALL	CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_PAYEE_ASSIGNS_ALL.SRP_QUOTA_ASSIGN_ID
CN_SRP_PERIOD_QUOTAS_ALL	CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_PERIOD_QUOTAS_ALL.SRP_QUOTA_ASSIGN_ID
CN_SRP_QUOTA_RULES_ALL	CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_QUOTA_RULES_ALL.SRP_QUOTA_ASSIGN_ID
CN_SRP_RATE_ASSIGNS_ALL	CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_RATE_ASSIGNS_ALL.SRP_QUOTA_ASSIGN_ID