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_TRX_ALL

Object Details

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

CN_TRX contains information on AR transactions at the header level
picked up in the AR data collection process. The tranactions types are
invoices, credit memos, payments, givebacks, clawbacks, and writeoffs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_TRX_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRX_ID ORG_ID
CN_TRX_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECTION_RUN_ID SOURCE_TRX_ID
CN_TRX_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TRX_ID EVENT_ID
CN_TRX_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_PAYMENT_SCHEDULE_ID TRX_TYPE
CN_TRX_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECTION_RUN_ID TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)		Organization identifier
STATUS	VARCHAR2	(4)	Yes	Transaction status, eg: notified, collected ...
COLLECTION_RUN_ID	NUMBER	(15)		collection run process audit id.
LINK_RUN_ID	NUMBER	(15)		Not currently used.
SOURCE_TRX_ID	NUMBER			Source transaction id.
SOURCE_PARENT_TRX_ID	NUMBER			Parent invoice id in the source system.
SOURCE_PAYMENT_SCHEDULE_ID	NUMBER	(15)		Parent invoice id
ROOT_TRX_ID	NUMBER	(15)		Root transaction id. Not currently used.
PARENT_TRX_ID	NUMBER	(15)		Parent invoice id.
TRX_ID	NUMBER	(15)	Yes	Transaction id (primary key).
GL_DATE	DATE			General ledger date of this transaction.
GL_POSTED_DATE	DATE			General ledger post date.
COLLECTED_DATE	DATE			Transaction collection date.
NOTIFIED_DATE	DATE			Transaction notification date.
PROCESSED_DATE	DATE			Transaction processed date.
COMP_PLAN_PERIOD	NUMBER	(15)		Compensation plan period.
ROLLUP_PERIOD	NUMBER	(15)		Rollup period for the transaction.
PROCESSED_PERIOD	NUMBER	(15)		Period in which the transaction was processed.
LINE_AMOUNT_APPLIED	NUMBER			Line amount applied.
PRORATED_AMOUNT	NUMBER			Prorated amount.
INVOICE_TOTAL	NUMBER			Total invoice amount.
BATCH_SOURCE_TYPE	VARCHAR2	(30)		Batch source type.
TRX_TYPE_ID	NUMBER	(15)		Transaction type ID.
TRX_TYPE	VARCHAR2	(20)		Transaction type, eg. INV, PMT, CBK, GBK, WO, CM.
PURCHASE_ORDER	VARCHAR2	(50)		Purchase order.
SALE_DATE	DATE			Inovice date of sale.
BILL_TO_CUSTOMER_NAME	VARCHAR2	(360)		Name of customer to bill.
BILL_TO_CUSTOMER_ID	NUMBER	(15)		ID of customer to bill.
SOLD_TO_CUSTOMER_NAME	VARCHAR2	(360)		Name of customer that product was sold to.
SOLD_TO_CUSTOMER_ID	NUMBER	(15)		ID of customer that product was sold to.
SOURCE_ORIG_TRX_NUMBER	VARCHAR2	(150)		Original transaction number in the source system.
SOURCE_TRX_NUMBER	VARCHAR2	(20)		Source transaction number.
DATE_ORDERED	DATE			Date of order. For ORDER transactions only.
AGREEMENT_TYPE_ID	NUMBER	(15)		Not currently used.
ARREARS_OR_ADVANCE_INV	NUMBER	(15)		Not currently used.
ORIG_COMMITMENT_TRX_ID	NUMBER	(15)		Original commitment transaction.
SPARE_COLUMN1	NUMBER	(15)		Spare column.
SPARE_COLUMN2	VARCHAR2	(30)		Spare column.
ORIG_COMMITMENT_TRX_NUMBER	VARCHAR2	(20)		Original commitment transaction number.
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(30)		Not currently used.
BATCH_SOURCE_ID	NUMBER	(15)		Batch source ID.
INVOICE_SOURCE	VARCHAR2	(30)		Source of invoice, eg. AR, OE, etc.
TRANSFERRED_FLAG	VARCHAR2	(1)		Flag to indicate that a transaction has been transferred.
EXCEPTION_FLAG	VARCHAR2	(1)		Flag for a transaction that cannot be classified.
EVENT_ID	NUMBER	(15)		ID of the event on which this transaction was collected.
BATCH_ID	NUMBER	(15)		Batch id.
COL_SYSTEM_ID	NUMBER	(15)		Collection system ID.
COL_SYSTEM_TRX_ID	NUMBER	(15)		Collection system transaction ID.
TRX_DATE	DATE			Transaction date.
NOT_TRX_ID	NUMBER	(15)		Notification ID. Record ID from CN_NOT_TRX.
TRANSFER_BATCH_ID	NUMBER	(15)		Transfer batch id (Collector to calculator).
DUE_DATE	DATE			The invoice due date.
BOTH_NON_ZERO_REV_ACCTS	VARCHAR2	(1)		Not currently used.
NOT_100_PERCENT_EXCEPTION	VARCHAR2	(1)		Not currently used.
NO_REV_ACCT_EXCEPTION	VARCHAR2	(1)		Not currently used.
ROLLUP_DATE	DATE			Rollup date.
TRANSFER_RUN_ID	NUMBER	(15)		Not currently used.
ADJUSTMENT_FLAG	VARCHAR2	(1)		Not currently used.
ADJUSTMENT_HEADER_ID	NUMBER	(15)		Not currently used.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)		Currency in which the transaction originally took place
EXCHANGE_RATE	NUMBER			Exchange rate used for transaction
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).
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ADJ_COLLECTION_RUN_ID	NUMBER	(15)		collection run identifier for revenue adjustment collection
SALES_ORDER#1	VARCHAR2	(150)		Sales Order
SOURCE_ORIG_TRX_TYPE#1	VARCHAR2	(150)		Orginal Transaction Type in the Source System

Query Text

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


SELECT ORG_ID
,      STATUS
,      COLLECTION_RUN_ID
,      LINK_RUN_ID
,      SOURCE_TRX_ID
,      SOURCE_PARENT_TRX_ID
,      SOURCE_PAYMENT_SCHEDULE_ID
,      ROOT_TRX_ID
,      PARENT_TRX_ID
,      TRX_ID
,      GL_DATE
,      GL_POSTED_DATE
,      COLLECTED_DATE
,      NOTIFIED_DATE
,      PROCESSED_DATE
,      COMP_PLAN_PERIOD
,      ROLLUP_PERIOD
,      PROCESSED_PERIOD
,      LINE_AMOUNT_APPLIED
,      PRORATED_AMOUNT
,      INVOICE_TOTAL
,      BATCH_SOURCE_TYPE
,      TRX_TYPE_ID
,      TRX_TYPE
,      PURCHASE_ORDER
,      SALE_DATE
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_CUSTOMER_ID
,      SOLD_TO_CUSTOMER_NAME
,      SOLD_TO_CUSTOMER_ID
,      SOURCE_ORIG_TRX_NUMBER
,      SOURCE_TRX_NUMBER
,      DATE_ORDERED
,      AGREEMENT_TYPE_ID
,      ARREARS_OR_ADVANCE_INV
,      ORIG_COMMITMENT_TRX_ID
,      SPARE_COLUMN1
,      SPARE_COLUMN2
,      ORIG_COMMITMENT_TRX_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      BATCH_SOURCE_ID
,      INVOICE_SOURCE
,      TRANSFERRED_FLAG
,      EXCEPTION_FLAG
,      EVENT_ID
,      BATCH_ID
,      COL_SYSTEM_ID
,      COL_SYSTEM_TRX_ID
,      TRX_DATE
,      NOT_TRX_ID
,      TRANSFER_BATCH_ID
,      DUE_DATE
,      BOTH_NON_ZERO_REV_ACCTS
,      NOT_100_PERCENT_EXCEPTION
,      NO_REV_ACCT_EXCEPTION
,      ROLLUP_DATE
,      TRANSFER_RUN_ID
,      ADJUSTMENT_FLAG
,      ADJUSTMENT_HEADER_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TRANSACTION_CURRENCY_CODE
,      EXCHANGE_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SECURITY_GROUP_ID
,      ADJ_COLLECTION_RUN_ID
,      SALES_ORDER#1
,      SOURCE_ORIG_TRX_TYPE#1
FROM CN.CN_TRX_ALL;

Dependencies

[top of page]

CN.CN_TRX_ALL does not reference any database object

CN.CN_TRX_ALL is referenced by following:

CN: CN_TRX_ALL#