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_RULES_ALL_B

Product:	CN - Incentive Compensation
Description:	Rules for revenue classification. Input to the revenue classification generator.
Implementation/DBA Data:	CN.CN_RULES_ALL_B

Primary Key: CN_RULES_ALL_B_UK

RULE_ID
RULESET_ID
ORG_ID

Primary Key: CN_RULES_ALL_B_UK2

RULE_LEVEL

Primary Key: CN_RULES_PK

RULE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CN_RULES_ALL_B	CN_RULESETS_ALL_B	CN_RULES_ALL_B.RULESET_ID
CN_RULES_ALL_B	CN_REVENUE_CLASSES_ALL	CN_RULES_ALL_B.REVENUE_CLASS_ID
CN_ATTRIBUTE_RULES_ALL	CN_RULES_ALL_B	CN_ATTRIBUTE_RULES_ALL.RULE_ID CN_ATTRIBUTE_RULES_ALL.RULESET_ID CN_ATTRIBUTE_RULES_ALL.ORG_ID
CN_RULES_HIERARCHY_ALL	CN_RULES_ALL_B	CN_RULES_HIERARCHY_ALL.RULE_ID CN_RULES_HIERARCHY_ALL.RULESET_ID CN_RULES_HIERARCHY_ALL.ORG_ID
CN_RULES_HIERARCHY_ALL	CN_RULES_ALL_B	CN_RULES_HIERARCHY_ALL.PARENT_RULE_ID CN_RULES_HIERARCHY_ALL.RULESET_ID CN_RULES_HIERARCHY_ALL.ORG_ID
CN_RULE_ATTR_EXPRESSION_ALL	CN_RULES_ALL_B	CN_RULE_ATTR_EXPRESSION_ALL.RULE_ID