[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 | (30) | Original transaction number in the source system. | |
SOURCE_ORIG_TRX_TYPE | VARCHAR2 | (30) | Original transaction type 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. | |
SALES_ORDER | VARCHAR2 | (50) | Not currently used. | |
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 |
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_ORIG_TRX_TYPE
, 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
, SALES_ORDER
, 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
FROM CN.CN_TRX_ALL;
CN.CN_TRX_ALL does not reference any database object
CN.CN_TRX_ALL is referenced by following:
|
|
|