VIEW: IBY.IBY_TRXN_CORE#

Source

View Text - Preformatted

select TRXNMID TRXNMID, TERMINALID TERMINALID, TRACENUMBER TRACENUMBER, AUTHCODE AUTHCODE, REFERENCECODE REFERENCECODE, OPERATIONCODE OPERATIONCODE, INSTRNAME INSTRNAME, AUTHTYPE AUTHTYPE, AVSCODE AVSCODE, ACQUIRER ACQUIRER, AUXMSG AUXMSG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PONUMBER PONUMBER, TAXAMOUNT TAXAMOUNT, SHIPFROMZIP SHIPFROMZIP, SHIPTOZIP SHIPTOZIP, SECURITY_GROUP_ID SECURITY_GROUP_ID, VOICEAUTHFLAG VOICEAUTHFLAG, CVV2RESULT CVV2RESULT, PROC_TRACENUMBER PROC_TRACENUMBER, DATE_OF_VOICE_AUTHORIZATION DATE_OF_VOICE_AUTHORIZATION, POS_READER_CAPABILITY_CODE POS_READER_CAPABILITY_CODE, POS_ENTRY_METHOD_CODE POS_ENTRY_METHOD_CODE, POS_ID_METHOD_CODE POS_ID_METHOD_CODE, POS_AUTH_SOURCE_CODE POS_AUTH_SOURCE_CODE, READER_DATA READER_DATA, POS_TRXN_FLAG POS_TRXN_FLAG, INSTR_EXPIRYDATE INSTR_EXPIRYDATE, CARD_SUBTYPE_CODE CARD_SUBTYPE_CODE, CARD_DATA_LEVEL CARD_DATA_LEVEL, INSTR_OWNER_NAME INSTR_OWNER_NAME, INSTR_OWNER_ADDRESS_LINE1 INSTR_OWNER_ADDRESS_LINE1, INSTR_OWNER_ADDRESS_LINE2 INSTR_OWNER_ADDRESS_LINE2, INSTR_OWNER_ADDRESS_LINE3 INSTR_OWNER_ADDRESS_LINE3, INSTR_OWNER_CITY INSTR_OWNER_CITY, INSTR_OWNER_STATE_PROVINCE INSTR_OWNER_STATE_PROVINCE, INSTR_OWNER_COUNTRY INSTR_OWNER_COUNTRY, INSTR_OWNER_POSTALCODE INSTR_OWNER_POSTALCODE, INSTR_OWNER_PHONE INSTR_OWNER_PHONE, INSTR_OWNER_EMAIL INSTR_OWNER_EMAIL, DEBIT_NETWORK_CODE DEBIT_NETWORK_CODE, SURCHARGE_AMOUNT SURCHARGE_AMOUNT, ENCRYPTED ENCRYPTED, EXPIRY_SEC_SEGMENT_ID EXPIRY_SEC_SEGMENT_ID, CHNAME_SEC_SEGMENT_ID CHNAME_SEC_SEGMENT_ID from "IBY"."IBY_TRXN_CORE"

View Text - HTML Formatted

SELECT TRXNMID TRXNMID
, TERMINALID TERMINALID
, TRACENUMBER TRACENUMBER
, AUTHCODE AUTHCODE
, REFERENCECODE REFERENCECODE
, OPERATIONCODE OPERATIONCODE
, INSTRNAME INSTRNAME
, AUTHTYPE AUTHTYPE
, AVSCODE AVSCODE
, ACQUIRER ACQUIRER
, AUXMSG AUXMSG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PONUMBER PONUMBER
, TAXAMOUNT TAXAMOUNT
, SHIPFROMZIP SHIPFROMZIP
, SHIPTOZIP SHIPTOZIP
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, VOICEAUTHFLAG VOICEAUTHFLAG
, CVV2RESULT CVV2RESULT
, PROC_TRACENUMBER PROC_TRACENUMBER
, DATE_OF_VOICE_AUTHORIZATION DATE_OF_VOICE_AUTHORIZATION
, POS_READER_CAPABILITY_CODE POS_READER_CAPABILITY_CODE
, POS_ENTRY_METHOD_CODE POS_ENTRY_METHOD_CODE
, POS_ID_METHOD_CODE POS_ID_METHOD_CODE
, POS_AUTH_SOURCE_CODE POS_AUTH_SOURCE_CODE
, READER_DATA READER_DATA
, POS_TRXN_FLAG POS_TRXN_FLAG
, INSTR_EXPIRYDATE INSTR_EXPIRYDATE
, CARD_SUBTYPE_CODE CARD_SUBTYPE_CODE
, CARD_DATA_LEVEL CARD_DATA_LEVEL
, INSTR_OWNER_NAME INSTR_OWNER_NAME
, INSTR_OWNER_ADDRESS_LINE1 INSTR_OWNER_ADDRESS_LINE1
, INSTR_OWNER_ADDRESS_LINE2 INSTR_OWNER_ADDRESS_LINE2
, INSTR_OWNER_ADDRESS_LINE3 INSTR_OWNER_ADDRESS_LINE3
, INSTR_OWNER_CITY INSTR_OWNER_CITY
, INSTR_OWNER_STATE_PROVINCE INSTR_OWNER_STATE_PROVINCE
, INSTR_OWNER_COUNTRY INSTR_OWNER_COUNTRY
, INSTR_OWNER_POSTALCODE INSTR_OWNER_POSTALCODE
, INSTR_OWNER_PHONE INSTR_OWNER_PHONE
, INSTR_OWNER_EMAIL INSTR_OWNER_EMAIL
, DEBIT_NETWORK_CODE DEBIT_NETWORK_CODE
, SURCHARGE_AMOUNT SURCHARGE_AMOUNT
, ENCRYPTED ENCRYPTED
, EXPIRY_SEC_SEGMENT_ID EXPIRY_SEC_SEGMENT_ID
, CHNAME_SEC_SEGMENT_ID CHNAME_SEC_SEGMENT_ID
FROM "IBY"."IBY_TRXN_CORE"