[Home] [Help] [Dependency Information]
Object Name: | IBY_TRXN_EXTENSIBILITY |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_TRXN_EXTENSIBILITY |
Subobject Name: | |
Status: | VALID |
IBY_TRXN_EXTENSIBILITY stores payment system transactional data, which cannot be accommodated in the Oracle Payments data model. Each datum is stored as a name-value pair and associated with a single transaction from IBY_TRXN_SUMMARIES_ALL .
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_TRXN_EXTENSIBILITY_TXID_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRXN_EXTEND_ID |
IBY_TRXN_EXTENSIBILITY_TMID_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRXNMID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRXN_EXTEND_ID | NUMBER | (15) | Yes | Primary key for this table |
TRXNMID | NUMBER | (15) | Yes | Foreign key to the transaction summaries table |
EXTEND_NAME | VARCHAR2 | (100) | Yes | Extensibility parameter name |
EXTEND_VALUE | VARCHAR2 | (200) | Yes | Extensibility parameter value |
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 | (15) | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT TRXN_EXTEND_ID
, TRXNMID
, EXTEND_NAME
, EXTEND_VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_TRXN_EXTENSIBILITY;
IBY.IBY_TRXN_EXTENSIBILITY does not reference any database object
IBY.IBY_TRXN_EXTENSIBILITY is referenced by following:
|
|
|