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_PLAN_ASSIGNS_ALL

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

Primary Key: CN_SRP_PLAN_ASSIGNS_PK

SRP_PLAN_ASSIGN_ID

Primary Key: CN_SRP_PLAN_ASSIGNS_UK1

SALESREP_ID
COMP_PLAN_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CN_SRP_PLAN_ASSIGNS_ALL	CN_COMP_PLANS_ALL	CN_SRP_PLAN_ASSIGNS_ALL.COMP_PLAN_ID
CN_SRP_PLAN_ASSIGNS_ALL	CN_ROLE_PLANS_ALL	CN_SRP_PLAN_ASSIGNS_ALL.ROLE_PLAN_ID
CN_POSTING_DETAILS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_POSTING_DETAILS_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_PERIODS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_PERIODS_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_PERIOD_QUOTAS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_PERIOD_QUOTAS_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_PER_QUOTA_RC_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_PER_QUOTA_RC_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_QUOTA_ASSIGNS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_QUOTA_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_QUOTA_RULES_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_QUOTA_RULES_ALL.SRP_PLAN_ASSIGN_ID
CN_SRP_RATE_ASSIGNS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_RATE_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID