[Home] [Help] [Dependency Information]
Object Name: | IBY_TRXN_FI |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_TRXN_FI |
Subobject Name: | |
Status: | VALID |
IBY_TRXN_FI contains the details of a payment request that are specific for systems that support both bank account transfers and credit cards such as Financial Institutions.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_TRXN_FI_TRXNMID_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRXNMID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRXNMID | NUMBER | Yes | Transaction Identifier | |
SPLITID | NUMBER | Yes | counter that indicates the sequence in the split shipment | |
PSREQID | VARCHAR2 | (80) | system generated ID that will be sent to FI Back End Payment Systems during schedule of payments with them | |
REFERENCECODE | VARCHAR2 | (80) | referencecode from Back End Payment System | |
AUXMSG | VARCHAR2 | (255) | any auxillary message that may be returned by the payment system or processing system | |
SRVID | VARCHAR2 | (80) | ID returned by Back End Payment System when the payment is scheduled | |
PROCESSFEE | NUMBER | The fee charged for processing a transaction | ||
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | This column is 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. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created 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). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT TRXNMID
, SPLITID
, PSREQID
, REFERENCECODE
, AUXMSG
, SRVID
, PROCESSFEE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM IBY.IBY_TRXN_FI;
IBY.IBY_TRXN_FI does not reference any database object
IBY.IBY_TRXN_FI is referenced by following:
|
|
|