CN Tables (182)

CN - Incentive Compensation — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`CN_AIA_ORDER_CAPTURE`	186
`CN_ATTAIN_SCHEDULES`	25	This table will store the name of attainment schedule to be used on compensation contracts.
`CN_ATTAIN_TIERS`	26	CN_ATTAIN_TIERS contain the % of attainment of each attainment schedule to be shown on compensation contracts.
`CN_ATTRIBUTE_RULES_ALL`	35	Rule definitions used by the revenue classification generator code.
`CN_CALC_EDGES_ALL`	28	Contains information about Edges between formulas/performance measures
`CN_CALC_EXT_TABLES_ALL`	33	Contains information about the relationship between an external table and one of available OSC tables
`CN_CALC_EXT_TBL_DTLS_ALL`	28	Contains information about the mapping between columns of an external table and columns of an OSC tables for the purpose of SQL Join.
`CN_CALC_FORMULAS_ALL`	54	Contains information about calculation formula. You need one row for each calculation formula defined
`CN_CALC_SQL_EXPS_ALL`	35	This table contains the sql expressions used in calculation process.
`CN_CALC_SUBMISSION_BATCHES_ALL`	42	CN_CALC_SUBMISSION_BATCHES contains information about calculation
`CN_CALC_SUBMISSION_ENTRIES_ALL`	27	CN_CALC_SUBMISSION_ENTRIES contains information about salesperson to
`CN_CALC_SUB_QUOTAS_ALL`	26	Contains information about plan elements to be calculated in a calculation request
`CN_CALC_SUB_VALIDATIONS_ALL`	10
`CN_CAL_PER_INT_TYPES_ALL`	27	Accumulation Calendar Period Interval Types
`CN_CLRL_API_ALL`	23	API table to enter rulesets, rules and rule attributes to be loaded into OSC
`CN_COLLECTION_AIA`	139
`CN_COLUMN_IND_MAPS`	11	Not currently used.
`CN_COLUMN_MAPS_ALL`	23	Maps source columns to destination columns for AR column mappings.
`CN_COLUMN_TRG_MAPS`	9	Not currently used.
`CN_COMMISSION_HEADERS_ALL`	173	Stores the Direct credit transactions of a salesperson
`CN_COMMISSION_LINES_ALL`	126	Stores all transactions created as part of calculation.
`CN_COMM_LINES_API_ALL`	180	API for importing values into CN_COMMISSION_LINES
`CN_COMP_ANCHORS`	29	CN_COMP_ANCHORS contains compensation anchors information. User need to define if certain % of quota is achieved, what is the expected commi
`CN_COMP_PLANS_ALL`	37	Compensation Plans
`CN_COPY_REQUESTS_ALL`	22
`CN_CREDIT_CONV_FCTS_ALL`	31	Credit type conversion factors.
`CN_CREDIT_TYPES_ALL_B`	30	Credit Types
`CN_CREDIT_TYPES_ALL_TL`	12	Credit Types Information
`CN_CW_SETUP_TASKS_ALL_B`	14	Setup Tasks table
`CN_CW_SETUP_TASKS_ALL_TL`	12	Setup Tasks TL Table
`CN_CW_WORKBENCH_ITEMS_ALL_B`	12	Workbench Items
`CN_CW_WORKBENCH_ITEMS_ALL_TL`	12	Workbench Item
`CN_DIMENSIONS_ALL_B`	12	Stores dimensions of data.
`CN_DIMENSIONS_ALL_TL`	12	Stores dimensions of data (translated attributes)
`CN_DIM_EXPLOSION_ALL`	13	Denormalizes ancestral relationships
`CN_DIM_HIERARCHIES_ALL`	16	Interval level information for dimension hierarchies.
`CN_EVENTS_ALL_B`	12	Contains the various events used in the Collection and Classification processes.
`CN_EVENTS_ALL_TL`	12	Contains the multi-lingual event names used in the Collection and Classification processes.
`CN_EVENT_LOG_ALL`	25	Log for various system events.
`CN_FORMULA_INPUTS_ALL`	41	Contains information about input(s) for calculation formulas.
`CN_HEAD_HIERARCHIES_ALL_B`	12	Dimension hierarchies
`CN_HEAD_HIERARCHIES_ALL_TL`	13	Dimension hierarchies
`CN_HIERARCHIES_API_ALL`	19	Interface table used for uploading and downing hierarchies
`CN_HIERARCHY_EDGES_ALL`	11	Parent child relationships in hierarchies.
`CN_HIERARCHY_NODES_ALL`	17	Nodes in the hierarchy.
`CN_IMPORT_TYPES`	29	CN_IMPORT_TYPES store all module types can be imported into the application. You need one row for each module. For each imported module, the
`CN_IMP_HEADERS`	40	CN_IMP_HEADERS contains information for user imports.
`CN_IMP_LINES`	265	CN_IMP_LINES is the staging table for import process. It contains all mapped data transfered from user data file.
`CN_IMP_MAPS`	26	CN_IMP_MAPS store the information of mappings between user data file and importing modules.
`CN_IMP_MAP_FIELDS`	31	CN_IMP_MAP_FIELDS store the detailed information of mappings between user data file and importing modules.
`CN_INTERVAL_TYPES_ALL_B`	27	Accumulation Calendar Interval Types. Interval types are assigned to a plan element
`CN_INTERVAL_TYPES_ALL_TL`	12	Accumulation Calendar Interval Types. Interval types are assigned to a plan element
`CN_INVOICE_CHANGES_ALL`	31	Invoice changes
`CN_JOB_ROLES`	29	CN_JOB_ROLES contain the information about the job assigned to a sales role.
`CN_LEDGER_BAL_TYPES_ALL_B`	14	Lookup table for account names
`CN_LEDGER_BAL_TYPES_ALL_TL`	12	Lookup table for account names
`CN_LEDGER_JE_BATCHES_ALL`	16	Batches of journal entries.
`CN_LEDGER_JOURNAL_ENTRIES_ALL`	15	Individual lines of journal entries
`CN_LINE_ROLLUP_PATHS_ALL`	31	Contains information about rollup paths if there are multiple rollup paths found.
`CN_MODEL_RESOURCES_ALL`	28	Stores resources used to simulate an agreement version
`CN_MODULES_ALL_B`	20	Source modules generated by the Classification and Collection code generators.
`CN_MODULES_ALL_TL`	12	contain the multi-lingular name for source modules generated by the Classification and Collection code generators.
`CN_MOD_OBJ_DEPENDS_ALL`	12	Records dependencies between modules and objects.
`CN_NOTIFY_LOG_ALL`	33	Log for the notification records generated by the events in the event log.
`CN_NOT_TRX_ALL`	21	Determines which AR records will be used by the Collection process.
`CN_OBJECTS_ALL`	65	Collection of objects used by Sales Compensation. Tables, columns, sequences, packages, etc.
`CN_PAYMENT_API_ALL`	18	Holds the output of the payment process.
`CN_PAYMENT_TRANSACTIONS_ALL`	58	This table is used by the payment module to store the details for each payment worksheet. The records that are created in this table are dep
`CN_PAYMENT_WORKSHEETS_ALL`	66	CN_PAYMENT_WORKSHEETS contains information about
`CN_PAYRUNS_ALL`	20	Corresponds to runs of checks.
`CN_PAY_APPROVAL_FLOW_ALL`	35	CN_PAY_APPROVAL_FLOW contains informatiom of an analyst submits the payment worksheet to his/her reporting managers to approve.
`CN_PAY_ELEMENT_INPUTS_ALL`	33	This table stores the mapping information about the Pay Element Input and and OIC Table Columns.
`CN_PAY_GROUPS_ALL`	33	CN_PAY_GROUPS_ALL is used to store pay groups. Pay groups are defined as a set of pay periods in a pay calendar. Pay groups are used to dete
`CN_PERF_MEASURES_ALL`	34	Contains information about performance measure. You need one row for each performance measure defined.
`CN_PERIOD_QUOTAS_ALL`	35	This table stores period target and payment amounts associated with a plan element
`CN_PERIOD_SETS_ALL`	25	This table is used by OSC to store the period_set_id which is system generated by OSC.
`CN_PERIOD_STATUSES_ALL`	27	Status of the Sales Compensation accounting periods. In addition to the GL status.
`CN_PERIOD_TYPES_ALL`	26	Period Type is defined in GL. This table is used to store period_type_id generated in OSC which is not in GL.
`CN_PLAN_TEXTS`	31	CN_PLAN_TEXTS contains the custimized information on compensation contract for each sales role. User can customize contract title, club qual
`CN_PMT_PLANS_ALL`	39	This table stores information regarding the payment plans used to affect the compensation paid to sales people
`CN_POSTING_BATCHES_ALL`	28	Batch for posting processing
`CN_POSTING_DETAILS_ALL`	61	This table contains detail posting information, including payee salesrep, posting type, processing date.
`CN_POSTING_DETAILS_SUM_ALL`	41	This table contains the summarized information from cn_posting_details
`CN_PROCESS_AUDITS_ALL`	20	Process execution log details
`CN_PROCESS_AUDIT_LINES_ALL`	11	Process execution log messages
`CN_PROCESS_BATCHES_ALL`	29	Process Batches used in Calculation process.
`CN_QUARTER_BCK_ALL`	9	This table stores quarters used in organization paid homepage bin.
`CN_QUOTAS_ALL`	67	Plan Elements
`CN_QUOTA_ASSIGNS_ALL`	13	Elements assigned to a compensation plan
`CN_QUOTA_CATEGORIES`	31	CN_QUOTA_CATEGORIES contains informations about your quota components. You need one row for each component you create.
`CN_QUOTA_PAY_ELEMENTS_ALL`	30	This table contains the infomation about the quota pay element mapping.
`CN_QUOTA_RULES_ALL`	34	Revenue classes assigned to a plan element
`CN_QUOTA_RULE_UPLIFTS_ALL`	30	Contains information about the payment and target uplift percentage for revenue classes assigned to a plan element for specific date ranges.
`CN_RATE_DIMENSIONS_ALL`	29	Contains information about rate dimensions.
`CN_RATE_DIM_TIERS_ALL`	33	Contains information about tiers for each rate dimension.
`CN_RATE_SCHEDULES_ALL`	30	Compensation rate table
`CN_RATE_SCH_DIMS_ALL`	28	Contains information about rate dimensions assigned to each rate table
`CN_RATE_TIERS_ALL`	18	Compensation Rate Table
`CN_REASONS_ALL`	31	This table contains user entered and system generated descriptions regarding changes made to the payment worksheet
`CN_REASON_HISTORY_ALL`	33	This table is an audit table for CN_REASONS_ALL table. Whenever an update or a delete happens to the CN_REASONS_ALL table, this table record
`CN_REPORT_TEMPLATES_GTT`	3
`CN_REPOSITORIES_ALL`	68	System parameters table
`CN_REVENUE_CLASSES_ALL`	14	Revenue classes.
`CN_ROLE_DETAILS`	34	CN_ROLE_DETAILS contain detail information of a sales role. These detail information are only used in salesforce planning.
`CN_ROLE_MODELS_ALL`	44	Stores the different agreement versions (models) for an agreement (corresponding to a role)
`CN_ROLE_PAY_GROUPS_ALL`	28	CN_ROLE_PAY_GROUPS_ALL contains information of pay groups assigned to sales role. You need one row for each pay group assignment to a sales
`CN_ROLE_PLANS_ALL`	30	Comp Plan Assignment to a Comp Role
`CN_ROLE_PLAN_MAPS`	29	CN_ROLE_PLAN_MAPS contains the mapping between a sales role and compensation plan.
`CN_ROLE_PMT_PLANS_ALL`	28	CN_ROLE_PMT_PLANS_ALL contains information of payment plans assigned to sales role. You need one row for each payment plan assignment to a s
`CN_ROLE_QUOTA_CATES`	39	CN_ROLE_QUOTA_CATES contains information of assigning quota components to sales role.
`CN_ROLE_QUOTA_FORMULAS`	27	CN_ROLE_QUOTA_FORMULAS contains the calculation formulas of each computed quota components.
`CN_ROLE_QUOTA_RATES`	30	CN_ROLE_QUOTA_RATES contains information of assigning rate table to a quota component of a sales role.
`CN_ROLLOVER_QUOTAS_ALL`	27	Table defining rollover quota mapping information at plan element level
`CN_RT_FORMULA_ASGNS_ALL`	29	Contains information about assignment of rate tables to a calculation formula for specific date ranges
`CN_RT_QUOTA_ASGNS_ALL`	30	Contains information about assignment of rate tables to a plan element for specific date ranges
`CN_RULESETS_ALL_B`	18	Rulesets for revenue classification rules.
`CN_RULESETS_ALL_TL`	12	Multi-Lingual Rulesets name for revenue classification rules.
`CN_RULES_ALL_B`	16	Rules for revenue classification. Input to the revenue classification generator.
`CN_RULES_ALL_TL`	13	Multi-Lingual rules name for revenue classification. Input to the revenue classification generator.
`CN_RULES_HIERARCHY_ALL`	11	Hierarchy showing parent/child relationships for rules in CN_RULES.
`CN_RULE_ATTR_EXPRESSION_ALL`	16	This table is used to store the expressions built using the rule attribute for a rule
`CN_SALESREPS_API_ALL`	38	Not currently used
`CN_SCA_ALLOCATIONS_ALL`	28	This table will keep the date ranges of each allocation percentages assigned to a credit rule.
`CN_SCA_ALLOC_DETAILS_ALL`	30	Table with revenue and non-revenue percentage information for each allocation role
`CN_SCA_COMBINATIONS_ALL`	27	This table holds unique Rule Attribute combinations used to build credit rules.
`CN_SCA_CONDITIONS_ALL`	27	This table keeps list of Credit Rule Attributes associated with each Credit Rule.
`CN_SCA_COND_DETAILS_ALL`	33	This table keeps condition operators and associated values
`CN_SCA_CREDIT_RULES_ALL`	33	This table holds the Sales Credit Rule definition.
`CN_SCA_DENORM_RULES_ALL`	36	This table holds the denormalized version of the Sales Credit Rules
`CN_SCA_HEADERS_INTERFACE_ALL`	118	This table holds the transactions those needs to be processed by Sales Credit Engine.
`CN_SCA_LINES_INTERFACE_ALL`	13	This table holds corresponding resources and their roles for each transaction of CN_SCA_HEADERS_INTERFACE_ALL
`CN_SCA_LINES_OUTPUT_ALL`	16	Table for storing allocation results
`CN_SCA_MATCHES_ALL`	29	This table to store the matching information between transactions and credit rules
`CN_SCA_PROCESS_BATCHES_ALL`	15	Table for batch submission information for sales credit allocation
`CN_SCA_RULE_ATTRIBUTES_ALL_B`	32	This base table keeps Credit Rule Attributes definition
`CN_SCA_RULE_ATTRIBUTES_ALL_TL`	12	This table keeps the translatable information of Credit Rule Attribute definition.
`CN_SCA_RULE_COND_VALS_MV`	19
`CN_SCA_WINNERS_ALL`	36	Tthis table to keep the winning rule information sales credit allocation
`CN_SCH_DIM_TIERS_ALL`	27	Contains information about the rate cube defined by the combination of rate tiers of each rate dimension assigned to the rate table
`CN_SEASONALITIES_ALL`	29	Table storing seasonalities associated with seasonality schedules by interval type
`CN_SEAS_SCHEDULES_ALL`	31	Table storing seasonality schedules
`CN_SECURITY_PROFILES_ALL`	25	Contains information of salesperson who can be associated with other salespersons to access their information but not for transaction rollup
`CN_SEC_PROF_ASSIGNS_ALL`	28	Contains information all the salespeople assigned to a salesperson who can access their information but not for transaction rollup during
`CN_SF_REPOSITORIES_ALL`	34	CN_SF_REPOSITORIES stores default contract title, terms and conditions information .
`CN_SOURCE_ALL`	11	Stores the dynamically generated code from the Classification and Collection code generators.
`CN_SRP_CNRT_HISTORY_ALL`	15	CN_SRP_CNRT_HISTORY contains the history information of salespeople's compensation contract .
`CN_SRP_COMP_ANCHORS_ALL`	33	Table storing anchor information at the salesperson (resource) level
`CN_SRP_DATA_SUMM_F`	12	CN_SRP_DATA_SUMM_F is a summary table on top of CN_SRP_PERIOD_QUOTAS_ALL table. This table keeps the total commission amount and quota amoun
`CN_SRP_DENORM_DATA_ALL`	17	The denormalized table to store the salesperson's data.
`CN_SRP_DENORM_DATA_BCK_ALL`	17	This is a backup table to CN_SRP_DENORM_DATA_ALL
`CN_SRP_INTEL_PERIODS_ALL`	30	Contains information on processing status and transaction processing flag for the salesperson in a particular period
`CN_SRP_PAYEE_ASSIGNS_ALL`	32	CN_SRP_PAYEE_ASSIGNS_ALL contains information of payees assigned to salesperson plan element. You need one row for each payee assignment to
`CN_SRP_PAYOUT_DTLS_ALL`	33	This table stores the models payout details for each quota component at different attainment tier levels
`CN_SRP_PAY_GROUPS_ALL`	31	CN_SRP_PAY_GROUPS contains information about the payment group each salesperson is assigned to. At any time a salesperson can have only one
`CN_SRP_PERIODS_ALL`	206	Salesperson compensation by period
`CN_SRP_PERIOD_PAYEES_ALL`	33	Internal process tables which maintains information for a payee as part of calculation
`CN_SRP_PERIOD_QUOTAS_ALL`	66	Salesperson Plan Elements by Period
`CN_SRP_PERIOD_QUOTAS_EXT_ALL`	11	An extension of CN_SRP_PERIOD_QUOTAS_ALL to handle accumulation of multiple inputs
`CN_SRP_PER_QUOTA_RC_ALL`	20	Salesperson Revenue Classes by Period
`CN_SRP_PLAN_ASSIGNS_ALL`	33	Salesperson Plan Assignments
`CN_SRP_PMT_PLANS_ALL`	37	CN_SRP_PMT_PLANS contains information of payment plans assigned to salespeople. You need one row for each payment plan assignment to a salep
`CN_SRP_QUOTA_ASSIGNS_ALL`	39	Salesperson Plan Element Assignments
`CN_SRP_QUOTA_CATES_ALL`	48	CN_SRP_QUOTA_CATES contains information of quota components assigned to salesperson.
`CN_SRP_QUOTA_RATES_ALL`	33	CN_SRP_QUOTA_RATES contains information of quota component's rate table assigned to salesperson.
`CN_SRP_QUOTA_RULES_ALL`	32	Salesperson Revenue Classes
`CN_SRP_RATE_ASSIGNS_ALL`	18	Salesperson Rate Tiers
`CN_SRP_ROLE_DTLS_ALL`	41	CN_SRP_ROLE_DTLS contains the detail information of sales role assigned to salesperson.
`CN_SRP_ROLE_HISTORY_ALL`	31	CN_SRP_ROLE_HISTORY contains the history information of each sales role and salesperson assignments.
`CN_SRP_ROLLOVER_QUOTAS_ALL`	29	Table defining rollover quota mapping information at salesperson level
`CN_SRP_RULE_UPLIFTS_ALL`	29	CN_SRP_RULE_UPLIFTS_ALL contains information of revenue class uplift factors assigned to a salesperson's plan element. You need one row for
`CN_SRP_TOTAL_COMPS_ALL`	32	Total compensation for fixed and quota based components of a given model for a given attainment tier.
`CN_TABLE_MAPS_ALL`	23	Maps source tables to destination tables for AR column mappings.
`CN_TABLE_MAP_OBJECTS_ALL`	13	List of objects (in CN_OBJECTS) associated with Collections transaction sources.
`CN_TRX_ALL`	86	Contains CN transactions picked up in the AR data collection process.
`CN_TRX_BATCHES_ALL`	33	Group for cn_commission_lines
`CN_TRX_FACTORS_ALL`	15	Revenue class transaction factors
`CN_TRX_LINES_ALL`	58	Contains CN transactions picked up in the AR data collection process.
`CN_TRX_SALES_LINES_ALL`	62	Contains CN transactions picked up in the AR data collection process.
`CN_USER_ACCESSES_ALL`	29	CN_USER_ACCESS contains the information of which compensation groups a user has access to.
`CN_WORKSHEET_BONUSES_ALL`	15	Bonuses given in payment process.
`CN_WORKSHEET_QG_DTLS_ALL`	43	CN_WORKSHEET_QG_DTLS contains information for a payment worksheet at quota group level.
`CN_XREF_TBL`	10