DBA Data[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_TRXN_EXTENDED

Object Details
Object Name: IBY_TRXN_EXTENDED
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_TRXN_EXTENDED_TRXNMID_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRXNMID
Columns
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
Query Text

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;

Dependencies

[top of page]

IBY.IBY_TRXN_EXTENDED does not reference any database object

IBY.IBY_TRXN_EXTENDED is referenced by following:

SchemaIBY
ViewIBY_TRXN_EXTENDED#