[Home] [Help] [Dependency Information]
Object Name: | IBY_TRXN_EXTENDED |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_TRXN_EXTENDED |
Subobject Name: | |
Status: | VALID |
IBY_TRXN_EXTENDED stores the details of a payment request that are specific for extended set functionality for credit cards.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_TRXN_EXTENDED_TRXNMID_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRXNMID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRXNMID | NUMBER | Yes | Transaction Identifier | |
SETTRXNID | VARCHAR2 | (80) | Transaction Identifier from payment system | |
APPROVALCODE | VARCHAR2 | (80) | SET approval code for an operation. For example, for authorization transaction, it contains the authorization code. | |
COMPLETIONCODE | VARCHAR2 | (80) | Additional SET status code for completion of transaction | |
SPLITID | NUMBER | Counter that indicates the sequence in the split shipment | ||
TERMINALID | VARCHAR2 | (80) | Used for credit card processing. A merchant can get multiple terminal identifiers and there is a batch open for each Terminal Identifier. The merchant can perform operations on those batches independantly. | |
SUBAUTHIND | NUMBER | Subsequent authorization indicator | ||
CARDBIN | VARCHAR2 | (10) | First five or six digits that identifies the card | |
BATCHSEQNUM | NUMBER | Sequence of the transaction in a batch | ||
BATCHTRXNSTATUS | NUMBER | Indicates the status of the row if it is included in batch operation | ||
SETREQTYPE | NUMBER | Denotes whether pinit or preq SET request type | ||
PREVSPLITID | NUMBER | Used during subsequent authorization | ||
SUBSAUTHTYPE | VARCHAR2 | (20) | Authorization type for subsequent authorization | |
SPLITSHIPMENT | NUMBER | Y or N flag indicating if the shipment has been split | ||
AUTHCURRENCY | VARCHAR2 | (10) | Authorized currency | |
AUTHPRICE | NUMBER | Authorized price | ||
INSTALLTOTALTRXNS | NUMBER | Number of installments | ||
RECURRINGFREQ | NUMBER | Frequency in number of days of recurring authorization | ||
RECURRINGEXPDATE | DATE | Date for final installment | ||
CUSTREFNUM | VARCHAR2 | (80) | Customer reference number | |
DESTPOSTALCODE | VARCHAR2 | (10) | Destination postal code | |
LOCALTAXPRICE | NUMBER | Local tax price | ||
LOCALTAXCURRENCY | VARCHAR2 | (10) | Local tax currency | |
CREDITCOUNTER | NUMBER | Indicates the nth return for multiple returns | ||
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Used for locking purposes that subsequently allows for checking if there is 'old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application. |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT TRXNMID
, SETTRXNID
, APPROVALCODE
, COMPLETIONCODE
, SPLITID
, TERMINALID
, SUBAUTHIND
, CARDBIN
, BATCHSEQNUM
, BATCHTRXNSTATUS
, SETREQTYPE
, PREVSPLITID
, SUBSAUTHTYPE
, SPLITSHIPMENT
, AUTHCURRENCY
, AUTHPRICE
, INSTALLTOTALTRXNS
, RECURRINGFREQ
, RECURRINGEXPDATE
, CUSTREFNUM
, DESTPOSTALCODE
, LOCALTAXPRICE
, LOCALTAXCURRENCY
, CREDITCOUNTER
, OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM IBY.IBY_TRXN_EXTENDED;
IBY.IBY_TRXN_EXTENDED does not reference any database object
IBY.IBY_TRXN_EXTENDED is referenced by following:
|
|
|