[Home] [Help] [Dependency Information]
Object Name: | IBY_TRXN_TYPES_TL |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_TRXN_TYPES_TL |
Subobject Name: | |
Status: | VALID |
IBY_TRXN_TYPES stores the payment processing transaction types required by the dependent products for submitting payment transactions to Oracle Payments. This is used for both funds disbursement and funds capture transactions.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_TRXN_TYPES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
PAY_PROC_TRXN_TYPE_CODE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application Identifier of the calling product |
PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 | (30) | Yes | System code for the transaction type. Must be unique per calling application |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the record's current language |
NAME | VARCHAR2 | (80) | Yes | User friendly name |
DESCRIPTION | VARCHAR2 | (240) | Free text description of the payment processing transaction type | |
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 | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, PAY_PROC_TRXN_TYPE_CODE
, LANGUAGE
, SOURCE_LANG
, NAME
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_TRXN_TYPES_TL;
IBY.IBY_TRXN_TYPES_TL does not reference any database object
IBY.IBY_TRXN_TYPES_TL is referenced by following:
|
|
|