[Home] [Help] [Dependency Information]
Object Name: | CN_COMMISSION_LINES_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_COMMISSION_LINES_ALL |
Subobject Name: | |
Status: | VALID |
CN_COMMISSION_LINES contains information about the
transactions and processing status through the
system. You need one row for each possible combination
of transaction, rate and salesperson which might cause a
payment to be issued. Under no circumstances should
this table be modified directly using SQL*Plus.
During the process of calculation the system will create the rollup
transactions and transactions if the revenue class overlaps between
more than one plan element. To identify the transactions which are
created by the system the payee_line_id and created_during are used.
Payee_line_id refers to the commission_line_id of the base
transaction. When a rollup transaction is created the Created_During
column will show 'ROLL', when a transaction is created because of the
revenue class overlap then the CREATED_DURING will show 'POP'.
Transactions are also created during the Calculation phase when the
commission is split across all the commission tiers. In which case the
CREATED_DURING will show 'CALC'. Also if the Direct_Salesrep_id and
the Created_salesrep_id are different it means the transaction is a
rollup transaction.
The 45 attribute columns which are used for classification purpose the
information will appear only in the base transaction.
The different values for Status are
COL -- Transactions have been collected.
XCLS -- Transactions could not be classified
CLS -- Transactions got
classified, updates the revenue_class_id of
the transaction.
ROLL - Transaction are in the rollup phase
XPOP -- Transactions failed in the populate phase, usually it means
the revenue class identified did not match to any of the plan elements
assigned to a salesrep.
POP -- Populate phase. Plan Element identified for the transaction.
XCALC -- Failed calculation. Usually because of 0 transaction
amount.
CALC -- Calculated status.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_COMMISSION_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COMMISSION_LINE_ID
ORG_ID |
CN_COMMISSION_LINES_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMMISSION_HEADER_ID |
CN_COMMISSION_LINES_N13 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SRP_PAYEE_ASSIGN_ID
ORG_ID |
CN_COMMISSION_LINES_N14 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
POSTING_STATUS
CREDITED_SALESREP_ID STATUS PROCESSED_PERIOD_ID QUOTA_ID |
CN_COMMISSION_LINES_N15 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREDITED_SALESREP_ID
QUOTA_ID PROCESSED_PERIOD_ID POSTING_STATUS STATUS CREDIT_TYPE_ID PROCESSED_DATE |
CN_COMMISSION_LINES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREDITED_SALESREP_ID
PROCESSED_PERIOD_ID STATUS |
CN_COMMISSION_LINES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROCESSED_PERIOD_ID |
CN_COMMISSION_LINES_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYEE_LINE_ID |
CN_COMMISSION_LINES_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREDITED_SALESREP_ID
PROCESSED_PERIOD_ID PROCESSED_DATE STATUS QUOTA_ID REVENUE_CLASS_ID ORG_ID |
CN_COMMISSION_LINES_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREDITED_SALESREP_ID
QUOTA_ID PAY_PERIOD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMMISSION_LINE_ID | NUMBER | (15) | Yes | Commission line primary key |
TRX_SALES_LINE_ID | NUMBER | (15) | ||
DIRECT_SALESREP_ID | NUMBER | (15) | Identifier of salesrep directly credited | |
CREDITED_SALESREP_ID | NUMBER | (15) | Which salesrep may be payed for this revenue | |
PROCESSED_PERIOD_ID | NUMBER | (15) | Period in which revenue is recognized | |
PROCESSED_DATE | DATE | Date on which revenue was recognized | ||
QUOTA_ID | NUMBER | (15) | Quota that matches this transaction for this salesrep. References CN_QUOTAS | |
QUOTA_RULE_ID | NUMBER | (15) | Rule in the quota that matched. References CN_QUOTA_RULES, and must be a detail of the quota specified by QUOTA_ID | |
REVENUE_CLASS_ID | NUMBER | (15) | Revenue class for transaction | |
TRANSACTION_AMOUNT | NUMBER | |||
EVENT_FACTOR | NUMBER | Factor derived from quota rule | ||
PAYMENT_FACTOR | NUMBER | Factor derived from quota rule | ||
PAYMENT_FLAG | VARCHAR2 | (1) | ||
QUOTA_FACTOR | NUMBER | Factor derived from quota rule | ||
COMMISSIONABLE_AMOUNT | NUMBER | |||
COMMISSION_AMOUNT | NUMBER | Amount of commission paid for this transaction | ||
COMMISSION_PAYED_PTD | NUMBER | |||
QUOTA_ACHIEVED_PTD | NUMBER | |||
RATE_TIER_ID | NUMBER | (15) | Rate tier that the transaction was paid on. References CN_RATE_TIERS | |
SALES_LINE_BATCH_ID | NUMBER | (15) | ||
QUOTA_AMOUNT | NUMBER | |||
COMMISSION_RATE | NUMBER | The rate at which the transaction was paid | ||
PAYEE_LINE_ID | NUMBER | (15) | A reference to CN_COMMISSION_LINES, pointing the "parent" transaction for this record, if it is the result of a split. | |
STATUS | VARCHAR2 | (30) | Yes | Status of the transaction vis a vis calculation. DOMAIN = 'TRX_STATUS' |
TRX_TYPE | VARCHAR2 | (30) | Yes | Type as defined by source transaction. DOMAIN = 'TRX_TYPES' |
TIER_SPLIT | NUMBER | If TIER_SPLIT is non-zero, then this transaction was broken into two (or more) transactions by a tier boundary. | ||
EXCEPTION_CODE | VARCHAR2 | (15) | ||
TRIAL_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
REVERSED_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
TRX_BATCH_ID | NUMBER | (15) | ||
ROLLUP_PERIOD_ID | NUMBER | (15) | ||
REASON_CODE | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (1900) | ||
CREATED_DURING | VARCHAR2 | (30) | Used to identify when transaction is created by OSC. For source transaction, this is NULL | |
PRE_DEFINED_RC_FLAG | VARCHAR2 | (1) | ||
ROLLUP_FLAG | VARCHAR2 | (1) | ||
ROLLUP_DATE | DATE | |||
FORECAST_ID | NUMBER | (15) | ||
UPSIDE_AMOUNT | NUMBER | |||
UPSIDE_QUANTITY | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (150) | ||
ATTRIBUTE17 | VARCHAR2 | (150) | ||
ATTRIBUTE18 | VARCHAR2 | (150) | ||
ATTRIBUTE19 | VARCHAR2 | (150) | ||
ATTRIBUTE20 | VARCHAR2 | (150) | ||
ATTRIBUTE21 | VARCHAR2 | (150) | ||
ATTRIBUTE22 | VARCHAR2 | (150) | ||
ATTRIBUTE23 | VARCHAR2 | (150) | ||
ATTRIBUTE24 | VARCHAR2 | (150) | ||
ATTRIBUTE25 | VARCHAR2 | (150) | ||
ATTRIBUTE26 | VARCHAR2 | (150) | ||
ATTRIBUTE27 | VARCHAR2 | (150) | ||
ATTRIBUTE28 | VARCHAR2 | (150) | ||
ATTRIBUTE29 | VARCHAR2 | (150) | ||
ATTRIBUTE30 | VARCHAR2 | (150) | ||
ATTRIBUTE31 | VARCHAR2 | (150) | ||
ATTRIBUTE32 | VARCHAR2 | (150) | ||
ATTRIBUTE33 | VARCHAR2 | (150) | ||
ATTRIBUTE34 | VARCHAR2 | (150) | ||
ATTRIBUTE35 | VARCHAR2 | (150) | ||
ATTRIBUTE36 | VARCHAR2 | (150) | ||
ATTRIBUTE37 | VARCHAR2 | (150) | ||
ATTRIBUTE38 | VARCHAR2 | (150) | ||
ATTRIBUTE39 | VARCHAR2 | (150) | ||
ATTRIBUTE40 | VARCHAR2 | (150) | ||
ATTRIBUTE41 | VARCHAR2 | (150) | ||
ATTRIBUTE42 | VARCHAR2 | (150) | ||
ATTRIBUTE43 | VARCHAR2 | (150) | ||
ATTRIBUTE44 | VARCHAR2 | (150) | ||
ATTRIBUTE45 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ORIG_CURRENCY_CODE | VARCHAR2 | (15) | ||
TRANSACTION_AMOUNT_ORIG | NUMBER | |||
EXCHANGE_RATE | NUMBER | |||
ORG_ID | NUMBER | (15) | Organization identifier | |
QUANTITY | NUMBER | |||
DISCOUNT_PERCENTAGE | NUMBER | |||
MARGIN_PERCENTAGE | NUMBER | |||
COMM_LINES_API_ID | NUMBER | (15) | ||
SOURCE_DOC_TYPE | VARCHAR2 | (30) | ||
SOURCE_TRX_NUMBER | VARCHAR2 | (20) | ||
ERROR_CODE | VARCHAR2 | (30) | ||
COMMISSION_HEADER_ID | NUMBER | (15) | Foreign key to CN_COMMISSION_HEADERS | |
SRP_PLAN_ASSIGN_ID | NUMBER | (15) | Foreign key to CN_SRP_PLAN_ASSIGNS | |
POSTING_STATUS | VARCHAR2 | (30) | Posting Status | |
INPUT_ACHIEVED | NUMBER | Input achieved amount | ||
OUTPUT_ACHIEVED | NUMBER | Output achieve amount. | ||
PERF_ACHIEVED | NUMBER | Performance achieved amount. | ||
REVERSAL_HEADER_ID | NUMBER | (15) | Reversal Header ID | |
ERROR_REASON | VARCHAR2 | (150) | Error reason for failed transaction | |
PAY_PERIOD_ID | NUMBER | (15) | Pay period ID. | |
PENDING_STATUS | VARCHAR2 | (30) | Pending status. | |
ROLE_ID | NUMBER | (15) | Foreign key to CN_ROLES | |
SRP_PAYEE_ASSIGN_ID | NUMBER | (15) | Foreign key to CN_SRP_PAYEE_ASSIGNS | |
PENDING_DATE | DATE | Pending Date | ||
THRESHOLD_CHECK_STATUS | VARCHAR2 | (30) | Threshold check status | |
CREDITED_COMP_GROUP_ID | NUMBER | (15) | Credit comp group ID | |
PRE_PROCESSED_CODE | VARCHAR2 | (30) | Pre processed code. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
CREDIT_TYPE_ID | NUMBER | (15) | Credit Type ID | |
ROLLUP_LEVEL | NUMBER | (15) | Rollup levels from direct salesrep to credited salesrep |
Cut, paste (and edit) the following text to query this object:
SELECT COMMISSION_LINE_ID
, TRX_SALES_LINE_ID
, DIRECT_SALESREP_ID
, CREDITED_SALESREP_ID
, PROCESSED_PERIOD_ID
, PROCESSED_DATE
, QUOTA_ID
, QUOTA_RULE_ID
, REVENUE_CLASS_ID
, TRANSACTION_AMOUNT
, EVENT_FACTOR
, PAYMENT_FACTOR
, PAYMENT_FLAG
, QUOTA_FACTOR
, COMMISSIONABLE_AMOUNT
, COMMISSION_AMOUNT
, COMMISSION_PAYED_PTD
, QUOTA_ACHIEVED_PTD
, RATE_TIER_ID
, SALES_LINE_BATCH_ID
, QUOTA_AMOUNT
, COMMISSION_RATE
, PAYEE_LINE_ID
, STATUS
, TRX_TYPE
, TIER_SPLIT
, EXCEPTION_CODE
, TRIAL_ADJUSTMENT_FLAG
, REVERSED_ADJUSTMENT_FLAG
, TRX_BATCH_ID
, ROLLUP_PERIOD_ID
, REASON_CODE
, COMMENTS
, CREATED_DURING
, PRE_DEFINED_RC_FLAG
, ROLLUP_FLAG
, ROLLUP_DATE
, FORECAST_ID
, UPSIDE_AMOUNT
, UPSIDE_QUANTITY
, UOM_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE31
, ATTRIBUTE32
, ATTRIBUTE33
, ATTRIBUTE34
, ATTRIBUTE35
, ATTRIBUTE36
, ATTRIBUTE37
, ATTRIBUTE38
, ATTRIBUTE39
, ATTRIBUTE40
, ATTRIBUTE41
, ATTRIBUTE42
, ATTRIBUTE43
, ATTRIBUTE44
, ATTRIBUTE45
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, ORIG_CURRENCY_CODE
, TRANSACTION_AMOUNT_ORIG
, EXCHANGE_RATE
, ORG_ID
, QUANTITY
, DISCOUNT_PERCENTAGE
, MARGIN_PERCENTAGE
, COMM_LINES_API_ID
, SOURCE_DOC_TYPE
, SOURCE_TRX_NUMBER
, ERROR_CODE
, COMMISSION_HEADER_ID
, SRP_PLAN_ASSIGN_ID
, POSTING_STATUS
, INPUT_ACHIEVED
, OUTPUT_ACHIEVED
, PERF_ACHIEVED
, REVERSAL_HEADER_ID
, ERROR_REASON
, PAY_PERIOD_ID
, PENDING_STATUS
, ROLE_ID
, SRP_PAYEE_ASSIGN_ID
, PENDING_DATE
, THRESHOLD_CHECK_STATUS
, CREDITED_COMP_GROUP_ID
, PRE_PROCESSED_CODE
, SECURITY_GROUP_ID
, CREDIT_TYPE_ID
, ROLLUP_LEVEL
FROM CN.CN_COMMISSION_LINES_ALL;
CN.CN_COMMISSION_LINES_ALL does not reference any database object
CN.CN_COMMISSION_LINES_ALL is referenced by following:
|
|
|