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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CN.CN_COMMISSION_HEADERS_ALL

Object Details

Object Name:	CN_COMMISSION_HEADERS_ALL
Object Type:	TABLE
Owner:	CN
FND Design Data:	CN.CN_COMMISSION_HEADERS_ALL
Subobject Name:
Status:	VALID

CN_COMMISSION_HEADERS contains information about direct credit salesperson transactions. It always has one to one correspondence to a record in CN_COMM_LINES_API table after transactions are loaded using Transaction Interface Loader and LOAD_STATUS is set to 'LOADED'. It has 100 descriptive flexfields which can either be used for defining classification rules or defining performance measures and calculation formulas.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_COMMISSION_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMMISSION_HEADER_ID ORG_ID
CN_COMMISSION_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIRECT_SALESREP_ID PROCESSED_DATE COMP_GROUP_ID
CN_COMMISSION_HEADERS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_TO_ADDRESS_ID
CN_COMMISSION_HEADERS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_ADDRESS_ID
CN_COMMISSION_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMM_LINES_API_ID
CN_COMMISSION_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_NUMBER
CN_COMMISSION_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_NUMBER
CN_COMMISSION_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJ_COMM_LINES_API_ID
CN_COMMISSION_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIRECT_SALESREP_ID COMMISSION_HEADER_ID
CN_COMMISSION_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
CN_COMMISSION_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_HEADER_ID
CN_COMMISSION_HEADERS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
COMMISSION_HEADER_ID	NUMBER	(15)	Yes	Primary Key.
DIRECT_SALESREP_ID	NUMBER	(15)	Yes	Direct Saleperson ID.
PROCESSED_DATE	DATE		Yes	Revenue Recognition Date.
PROCESSED_PERIOD_ID	NUMBER	(15)		Revenue Recognition Period ID
ROLLUP_DATE	DATE			Date that the transaction was rolled up.
TRANSACTION_AMOUNT	NUMBER			Functional transaction amount.
QUANTITY	NUMBER			Quantity amount.
DISCOUNT_PERCENTAGE	NUMBER			Discount percentage for discount based commission.
MARGIN_PERCENTAGE	NUMBER			Margin percentage for margin based commission.
ORIG_CURRENCY_CODE	VARCHAR2	(15)		Original Currency Code.
TRANSACTION_AMOUNT_ORIG	NUMBER			Original transaction amount.
TRX_TYPE	VARCHAR2	(30)		Transaction type.
STATUS	VARCHAR2	(30)		Calculation status.
PRE_PROCESSED_CODE	VARCHAR2	(30)		Pre processed code.
COMM_LINES_API_ID	NUMBER	(15)		Foreign key to CN_COMM_LINES_API.
SOURCE_DOC_TYPE	VARCHAR2	(80)		Source doc type.
SOURCE_TRX_NUMBER	VARCHAR2	(80)		Source transaction number.
QUOTA_ID	NUMBER	(15)		Quota that this transaction fells under.
SRP_PLAN_ASSIGN_ID	NUMBER	(15)		Foreign key to CN_SRP_PLAN_ASSIGNS
REVENUE_CLASS_ID	NUMBER	(15)		Revenue class that this transaction matches.
ROLE_ID	NUMBER	(15)		Foreign key to CN_ROLES.
COMP_GROUP_ID	NUMBER	(15)		Foreign key to CN_COMP_GROUPS
COMMISSION_AMOUNT	NUMBER			Amount of commission payed on this transaction.
TRX_BATCH_ID	NUMBER	(15)		Transaction batch ID.
REVERSAL_FLAG	VARCHAR2	(1)		Reversal flag.
REVERSAL_HEADER_ID	NUMBER	(15)		Reversal header ID.
REASON_CODE	VARCHAR2	(30)		Reason code.
COMMENTS	VARCHAR2	(1800)		Comments.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE31	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE32	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE33	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE34	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE35	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE36	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE37	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE38	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE39	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE40	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE41	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE42	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE43	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE44	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE45	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE46	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE47	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE48	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE49	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE50	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE51	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE52	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE53	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE54	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE55	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE56	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE57	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE58	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE59	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE60	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE61	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE62	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE63	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE64	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE65	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE66	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE67	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE68	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE69	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE70	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE71	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE72	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE73	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE74	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE75	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE76	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE77	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE78	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE79	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE80	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE81	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE82	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE83	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE84	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE85	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE86	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE87	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE88	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE89	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE90	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE91	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE92	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE93	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE94	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE95	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE96	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE97	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE98	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE99	VARCHAR2	(240)		Descriptive flexfield segment.
ATTRIBUTE100	VARCHAR2	(240)		Descriptive flexfield segment.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
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).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORG_ID	NUMBER	(15)		Organization identifier
EXCHANGE_RATE	NUMBER			Exchange rate used to convert the line
FORECAST_ID	NUMBER	(15)		Forecast ID
UPSIDE_QUANTITY	NUMBER			Upside quantity
UPSIDE_AMOUNT	NUMBER			Upside Amount
UOM_CODE	VARCHAR2	(3)		Unit of measurement code
SOURCE_TRX_ID	NUMBER			Header ID of the source trx
SOURCE_TRX_LINE_ID	NUMBER			Line ID of the source trx
SOURCE_TRX_SALES_LINE_ID	NUMBER			Sales credit id of the source trx
NEGATED_FLAG	VARCHAR2	(1)		Flag indicating whether the line has already been negated or not. Used for OE adjustment.
CUSTOMER_ID	NUMBER	(15)		Customer ID
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory Item ID
ORDER_NUMBER	NUMBER			Order number
BOOKED_DATE	DATE			Date order gets booked
INVOICE_NUMBER	VARCHAR2	(20)		Invoice number
INVOICE_DATE	DATE			Date order gets invoiced
BILL_TO_ADDRESS_ID	NUMBER			Bill To Address Id
SHIP_TO_ADDRESS_ID	NUMBER			Ship To Address Id
BILL_TO_CONTACT_ID	NUMBER			Bill To Contact Id
SHIP_TO_CONTACT_ID	NUMBER			Ship To Contact Id
ADJ_COMM_LINES_API_ID	NUMBER	(15)		Comm lines API ID which points to the parent transaction.
ADJUST_DATE	DATE			Date transaction was adjusted.
ADJUSTED_BY	VARCHAR2	(100)		User ID that transaction was adjusted by.
REVENUE_TYPE	VARCHAR2	(15)		Revenue type code.
ADJUST_ROLLUP_FLAG	VARCHAR2	(1)		Adjust rollup flag.
ADJUST_COMMENTS	VARCHAR2	(2000)		Adjust comments for the transaction.
ADJUST_STATUS	VARCHAR2	(20)		Adjust status code of the transaction.
LINE_NUMBER	NUMBER			Line number.
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).
TYPE	VARCHAR2	(80)		Salesrep Type.
SALES_CHANNEL	VARCHAR2	(30)		Sales Channel.
OBJECT_VERSION_NUMBER	NUMBER		Yes	This column is used for locking purposes
SPLIT_PCT	NUMBER			Sales Credit Split Percentage
SPLIT_STATUS	VARCHAR2	(30)		Sales Credit Split Status
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
PARENT_HEADER_ID	NUMBER	(15)		Parent Header Identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COMMISSION_HEADER_ID
,      DIRECT_SALESREP_ID
,      PROCESSED_DATE
,      PROCESSED_PERIOD_ID
,      ROLLUP_DATE
,      TRANSACTION_AMOUNT
,      QUANTITY
,      DISCOUNT_PERCENTAGE
,      MARGIN_PERCENTAGE
,      ORIG_CURRENCY_CODE
,      TRANSACTION_AMOUNT_ORIG
,      TRX_TYPE
,      STATUS
,      PRE_PROCESSED_CODE
,      COMM_LINES_API_ID
,      SOURCE_DOC_TYPE
,      SOURCE_TRX_NUMBER
,      QUOTA_ID
,      SRP_PLAN_ASSIGN_ID
,      REVENUE_CLASS_ID
,      ROLE_ID
,      COMP_GROUP_ID
,      COMMISSION_AMOUNT
,      TRX_BATCH_ID
,      REVERSAL_FLAG
,      REVERSAL_HEADER_ID
,      REASON_CODE
,      COMMENTS
,      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
,      ATTRIBUTE46
,      ATTRIBUTE47
,      ATTRIBUTE48
,      ATTRIBUTE49
,      ATTRIBUTE50
,      ATTRIBUTE51
,      ATTRIBUTE52
,      ATTRIBUTE53
,      ATTRIBUTE54
,      ATTRIBUTE55
,      ATTRIBUTE56
,      ATTRIBUTE57
,      ATTRIBUTE58
,      ATTRIBUTE59
,      ATTRIBUTE60
,      ATTRIBUTE61
,      ATTRIBUTE62
,      ATTRIBUTE63
,      ATTRIBUTE64
,      ATTRIBUTE65
,      ATTRIBUTE66
,      ATTRIBUTE67
,      ATTRIBUTE68
,      ATTRIBUTE69
,      ATTRIBUTE70
,      ATTRIBUTE71
,      ATTRIBUTE72
,      ATTRIBUTE73
,      ATTRIBUTE74
,      ATTRIBUTE75
,      ATTRIBUTE76
,      ATTRIBUTE77
,      ATTRIBUTE78
,      ATTRIBUTE79
,      ATTRIBUTE80
,      ATTRIBUTE81
,      ATTRIBUTE82
,      ATTRIBUTE83
,      ATTRIBUTE84
,      ATTRIBUTE85
,      ATTRIBUTE86
,      ATTRIBUTE87
,      ATTRIBUTE88
,      ATTRIBUTE89
,      ATTRIBUTE90
,      ATTRIBUTE91
,      ATTRIBUTE92
,      ATTRIBUTE93
,      ATTRIBUTE94
,      ATTRIBUTE95
,      ATTRIBUTE96
,      ATTRIBUTE97
,      ATTRIBUTE98
,      ATTRIBUTE99
,      ATTRIBUTE100
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
,      EXCHANGE_RATE
,      FORECAST_ID
,      UPSIDE_QUANTITY
,      UPSIDE_AMOUNT
,      UOM_CODE
,      SOURCE_TRX_ID
,      SOURCE_TRX_LINE_ID
,      SOURCE_TRX_SALES_LINE_ID
,      NEGATED_FLAG
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      ORDER_NUMBER
,      BOOKED_DATE
,      INVOICE_NUMBER
,      INVOICE_DATE
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      ADJ_COMM_LINES_API_ID
,      ADJUST_DATE
,      ADJUSTED_BY
,      REVENUE_TYPE
,      ADJUST_ROLLUP_FLAG
,      ADJUST_COMMENTS
,      ADJUST_STATUS
,      LINE_NUMBER
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      TYPE
,      SALES_CHANNEL
,      OBJECT_VERSION_NUMBER
,      SPLIT_PCT
,      SPLIT_STATUS
,      SECURITY_GROUP_ID
,      PARENT_HEADER_ID
FROM CN.CN_COMMISSION_HEADERS_ALL;

Dependencies

[top of page]

CN.CN_COMMISSION_HEADERS_ALL does not reference any database object

CN.CN_COMMISSION_HEADERS_ALL is referenced by following:

APPS: CN_COMMISSION_HEADERS; CN_COMMISSION_HEADERS_ALL