VIEW: IBY.IBY_TRXN_EXTENDED#

Source

View Text - Preformatted

select TRXNMID TRXNMID, SETTRXNID SETTRXNID, APPROVALCODE APPROVALCODE, COMPLETIONCODE COMPLETIONCODE, SPLITID SPLITID, TERMINALID TERMINALID, SUBAUTHIND SUBAUTHIND, CARDBIN CARDBIN, BATCHSEQNUM BATCHSEQNUM, BATCHTRXNSTATUS BATCHTRXNSTATUS, SETREQTYPE SETREQTYPE, PREVSPLITID PREVSPLITID, SUBSAUTHTYPE SUBSAUTHTYPE, SPLITSHIPMENT SPLITSHIPMENT, AUTHCURRENCY AUTHCURRENCY, AUTHPRICE AUTHPRICE, INSTALLTOTALTRXNS INSTALLTOTALTRXNS, RECURRINGFREQ RECURRINGFREQ, RECURRINGEXPDATE RECURRINGEXPDATE, CUSTREFNUM CUSTREFNUM, DESTPOSTALCODE DESTPOSTALCODE, LOCALTAXPRICE LOCALTAXPRICE, LOCALTAXCURRENCY LOCALTAXCURRENCY, CREDITCOUNTER CREDITCOUNTER, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID from "IBY"."IBY_TRXN_EXTENDED"

View Text - HTML Formatted

SELECT TRXNMID TRXNMID
, SETTRXNID SETTRXNID
, APPROVALCODE APPROVALCODE
, COMPLETIONCODE COMPLETIONCODE
, SPLITID SPLITID
, TERMINALID TERMINALID
, SUBAUTHIND SUBAUTHIND
, CARDBIN CARDBIN
, BATCHSEQNUM BATCHSEQNUM
, BATCHTRXNSTATUS BATCHTRXNSTATUS
, SETREQTYPE SETREQTYPE
, PREVSPLITID PREVSPLITID
, SUBSAUTHTYPE SUBSAUTHTYPE
, SPLITSHIPMENT SPLITSHIPMENT
, AUTHCURRENCY AUTHCURRENCY
, AUTHPRICE AUTHPRICE
, INSTALLTOTALTRXNS INSTALLTOTALTRXNS
, RECURRINGFREQ RECURRINGFREQ
, RECURRINGEXPDATE RECURRINGEXPDATE
, CUSTREFNUM CUSTREFNUM
, DESTPOSTALCODE DESTPOSTALCODE
, LOCALTAXPRICE LOCALTAXPRICE
, LOCALTAXCURRENCY LOCALTAXCURRENCY
, CREDITCOUNTER CREDITCOUNTER
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "IBY"."IBY_TRXN_EXTENDED"