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_PERIODS_ALL

Product:	CN - Incentive Compensation
Description:	Salesperson compensation by period
Implementation/DBA Data:	CN.CN_SRP_PERIODS_ALL

Primary Key: CN_SRP_PERIODS_PK

SRP_PERIOD_ID

Primary Key: CN_SRP_PERIODS_UK1

SALESREP_ID
PERIOD_ID
CREDIT_TYPE_ID
ROLE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CN_SRP_PERIODS_ALL	CN_PERIOD_STATUSES_ALL	CN_SRP_PERIODS_ALL.PERIOD_ID
CN_SRP_PERIODS_ALL	CN_CREDIT_TYPES_ALL_B	CN_SRP_PERIODS_ALL.CREDIT_TYPE_ID
CN_SRP_PERIODS_ALL	CN_SRP_PLAN_ASSIGNS_ALL	CN_SRP_PERIODS_ALL.SRP_PLAN_ASSIGN_ID
CN_LEDGER_JOURNAL_ENTRIES_ALL	CN_SRP_PERIODS_ALL	CN_LEDGER_JOURNAL_ENTRIES_ALL.SRP_PERIOD_ID
CN_PROCESS_BATCHES_ALL	CN_SRP_PERIODS_ALL	CN_PROCESS_BATCHES_ALL.SRP_PERIOD_ID