Results for “transaction_currency_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CN_COMM_LINES_API_ALL is the interface (staging) table used by Oracle Incentive Compensation to import transaction-level commission data into the CN_COMMISSION_LINES table. It resides in the CN schema and serves as the landing area for external sources—order management, receivables, and third-party feeds—before the Incentive Compensation engine processes the records into commission earnings. The table is the authoritative staging structure through which every creditable transaction, and its associated adjustments and splits, must pass.

In Data Vault modeling terms, the FK structure suggests this object behaves as a link, bridging sales representatives, transactions, transaction lines, revenue classes, quotas, and territory assignments. The dense assembly of foreign keys around COMM_LINES_API_ID indicates a relationship or associative entity rather than a pure hub, and it is best modeled as the connecting spine between source transaction facts and the representative and plan dimensions.

Key Information Stored

The surrogate primary key is COMM_LINES_API_ID, enforced by CN_COMM_LINES_API_PK. The unique index CN_COMM_LINES_API_U1 (COMM_LINES_API_ID, ORG_ID) documents the business-key candidate and confirms that the identifier is qualified by operating unit.

• SALESREP_ID / SALESREP_NUMBER — identifies the sales representative credited with the commission line.
• TRX_ID, TRX_LINE_ID, TRX_SALES_LINE_ID — the source transaction references to CN_TRX_ALL, CN_TRX_LINES_ALL, and CN_TRX_SALES_LINES_ALL.
• TRANSACTION_AMOUNT, ACCTD_TRANSACTION_AMOUNT, QUANTITY, UOM_CODE — the creditable value and quantity being imported.
• TRANSACTION_CURRENCY_CODE, EXCHANGE_RATE — currency context for the transaction amount.
• PROCESSED_DATE, PROCESSED_PERIOD_ID, LOAD_STATUS, PRE_PROCESSED_CODE — processing state and the period against which the line is evaluated.
• REVENUE_CLASS_ID, REVENUE_TYPE, TYPE — classification driving how commissions are applied.
• SOURCE_DOC_ID, SOURCE_DOC_TYPE, SOURCE_TRX_NUMBER — origin document traceability.
• COMMISSION_AMOUNT — the calculated commission earned on the line.
• REVERSAL_FLAG, NEGATED_FLAG — indicators for cancellations and negative adjustments.
• SPLIT_STATUS, SPLIT_PCT, ROLLUP_FLAG — split credit and rollup handling.
• ADJ_COMM_LINES_API_ID, ADJUST_DATE, ADJUST_STATUS — linkage for adjustment lines back to the originating line.
• ORG_ID and the ATTRIBUTE1–ATTRIBUTE100 series — multi-org partitioning and a broad extension surface for source-specific values.

Common Use Cases and Queries

The dominant use case is importing external creditable transactions. Standard patterns include:

• Confirming what has landed but not yet been processed: SELECT COMM_LINES_API_ID, SALESREP_ID, TRANSACTION_AMOUNT FROM CN_COMM_LINES_API_ALL WHERE LOAD_STATUS = 'NEW' AND ORG_ID = :org_id;
• Reconciling staging to final commission lines by joining CN_COMMISSION_LINES_ALL on COMM_LINES_API_ID.
• Auditing reversal and adjustment activity using REVERSAL_FLAG, NEGATED_FLAG, and ADJ_COMM_LINES_API_ID.
• Reporting creditable revenue by representative, revenue class, or source document for a given processed period.
• Tracing a transaction lineage from CN_TRX_ALL through this table into CN_COMMISSION_HEADERS_ALL.

Related Objects

• CN_COMMISSION_LINES_ALL — the destination table; joined on COMM_LINES_API_ID.
• CN_COMMISSION_HEADERS_ALL — commission header to which staged lines relate.
• CN_INVOICE_CHANGES_ALL — invoice adjustment records referencing staged lines.
• CN_TRX_ALL / CN_TRX_LINES_ALL / CN_TRX_SALES_LINES_ALL — source transaction hierarchy via TRX_ID, TRX_LINE_ID, TRX_SALES_LINE_ID.
• CN_SALESREPS_API_ALL — representative master via SALESREP_ID.
• CN_PERIOD_STATUSES_ALL — period control via PROCESSED_PERIOD_ID.
• CN_REVENUE_CLASSES_ALL, CN_QUOTAS_ALL, CN_SRP_PLAN_ASSIGNS_ALL — classification, quota, and plan assignment references.
• JTF_TERR_ALL — territory linkage via TERR_ID, supporting territory-based credit assignment.