[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_TX_OPERATIONS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_TX_OPERATIONS |
Subobject Name: | |
Status: | VALID |
IBY_FNDCPT_TX_OPERATIONS stores associations between transaction extension entities and authorization or settlement transactions.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_FNDCPT_TX_OPERATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRXN_EXTENSION_ID |
IBY_FNDCPT_TX_OPERATIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTIONID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRXN_EXTENSION_ID | NUMBER | (15) | Yes | Transaction extension primary key |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
TRANSACTIONID | NUMBER | (15) | Yes | Transaction identifier for the series of Payments transaction operations performed |
Cut, paste (and edit) the following text to query this object:
SELECT TRXN_EXTENSION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, TRANSACTIONID
FROM IBY.IBY_FNDCPT_TX_OPERATIONS;
IBY.IBY_FNDCPT_TX_OPERATIONS does not reference any database object
IBY.IBY_FNDCPT_TX_OPERATIONS is referenced by following:
|
|
|