[Home] [Help] [Dependency Information]
Object Name: | CN_NOT_TRX_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_NOT_TRX_ALL |
Subobject Name: | |
Status: | VALID |
CN_NOT_TRX contains notification information for the AR transactions
that will be picked up by the AR Collection process. The transaction
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_NOT_TRX_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NOT_TRX_ID
ORG_ID |
CN_NOT_TRX_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
EVENT_ID |
CN_NOT_TRX_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_TRX_ID |
CN_NOT_TRX_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_TRX_LINE_ID |
CN_NOT_TRX_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ADJUSTED_FLAG
COLLECTED_FLAG NEGATED_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOT_TRX_ID | NUMBER | (15) | Yes | Primary key. |
ROW_ID | ROWID | (10) | Row id of the transaction from the source system. | |
PROCESSED_DATE | DATE | Date transaction was processed. | ||
NOTIFIED_DATE | DATE | Date that notify record was created. | ||
NOTIFICATION_RUN_ID | NUMBER | (15) | Process audit id from notification run. | |
BATCH_ID | NUMBER | (15) | Yes | Batch ID. |
COLLECTED_FLAG | VARCHAR2 | (1) | Yes | Collected flag. Y= collected. N= not collected. |
SOURCE_TRX_ID | NUMBER | Transaction ID in the source system. | ||
EVENT_ID | NUMBER | (15) | Yes | Event ID in which this notify record was processed. |
SOURCE_TRX_LINE_ID | NUMBER | line id of the source trx | ||
ADJUSTED_FLAG | VARCHAR2 | (1) | Flag indicating whether the line is from adjustment process or not | |
NEGATED_FLAG | VARCHAR2 | (1) | Flag indicating whether the line has beed negated in the API table | |
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 | |
SOURCE_DOC_TYPE | VARCHAR2 | (30) | Source doc type | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
LAST_COLLECTED_DATE | DATE | The date of the last run of collection |
Cut, paste (and edit) the following text to query this object:
SELECT NOT_TRX_ID
, ROW_ID
, PROCESSED_DATE
, NOTIFIED_DATE
, NOTIFICATION_RUN_ID
, BATCH_ID
, COLLECTED_FLAG
, SOURCE_TRX_ID
, EVENT_ID
, SOURCE_TRX_LINE_ID
, ADJUSTED_FLAG
, NEGATED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ORG_ID
, SOURCE_DOC_TYPE
, SECURITY_GROUP_ID
, LAST_COLLECTED_DATE
FROM CN.CN_NOT_TRX_ALL;
CN.CN_NOT_TRX_ALL does not reference any database object
CN.CN_NOT_TRX_ALL is referenced by following:
|
|
|