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

VIEW: IBY.IBY_TRXN_EXTENDED#

Object Details
Object Name: IBY_TRXN_EXTENDED#
Object Type: VIEW
Owner: IBY
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRXNMID NUMBER
Yes
SETTRXNID VARCHAR2 (80)
APPROVALCODE VARCHAR2 (80)
COMPLETIONCODE VARCHAR2 (80)
SPLITID NUMBER

TERMINALID VARCHAR2 (80)
SUBAUTHIND NUMBER

CARDBIN VARCHAR2 (10)
BATCHSEQNUM NUMBER

BATCHTRXNSTATUS NUMBER

SETREQTYPE NUMBER

PREVSPLITID NUMBER

SUBSAUTHTYPE VARCHAR2 (20)
SPLITSHIPMENT NUMBER

AUTHCURRENCY VARCHAR2 (10)
AUTHPRICE NUMBER

INSTALLTOTALTRXNS NUMBER

RECURRINGFREQ NUMBER

RECURRINGEXPDATE DATE

CUSTREFNUM VARCHAR2 (80)
DESTPOSTALCODE VARCHAR2 (10)
LOCALTAXPRICE NUMBER

LOCALTAXCURRENCY VARCHAR2 (10)
CREDITCOUNTER NUMBER

OBJECT_VERSION_NUMBER NUMBER (5) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

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# references the following:

SchemaIBY
TableIBY_TRXN_EXTENDED
IBY.IBY_TRXN_EXTENDED# is referenced by following:

SchemaAPPS
SynonymIBY_TRXN_EXTENDED