CTI_ParseTransactionQuery()

This subprocedure is used to parse a previously downloaded transaction query response. This subprocedure requires that you provide the fully-qualified filepath of the downloaded query response file in the IFS. If this query was performed using CTI_QueryTransaction(), the report file will be found in the default download directory specified in your CTICFGMCH record.

Parsed data will be written to the output tables described below. This data can then be retrieved from the tables and stored in a more permanent manner; the output tables should be treated as temporary, transactional tables and not used for long-term storage.

If an error occurs, this subprocedure will return *OFF, and information about the error will be present in the pErrorDS parameter which contains a CTI_ErrorDS_t data structure.

Subprocedure Prototype

D CTI_ParseTransactionQuery...
D                 PR              N   Extproc('CTI_ParseTransactionQuery')

Returns *OFF if an error occurs during processing, *ON otherwise.

 
D  pUniqueId                          Const Like(CTI_UniqueId_t)

Unique ID, generated with CTI_NextUniqueID(), that will be used to identify the parsed records from this file

Required

 
D  pQueryFile                         Const Like(CTI_FilePath_t)

The fully-qualified filepath of the file in the IFS that will be parsed. If this query was performed using CTI_QueryTransaction(), the file will be in the default download directory specified in your CTICFGMCH record

 
D  pErrorDS                           LikeDS(CTI_ErrorDS_t)

Error data structure used to capture subprocedure and CyberSource errors

Required

Data Structures

D CTI_ErrorDS_t   DS                  Qualified Template Inz
  
D  Subproc                     132A   Varying

Name of subprocedure returning error

 
D  MessageId                     7A

Message ID of error message

 
D  Message                    1024A   Varying

Error message text

 
D  Source                       10A

Error message source

 
D  LogFile                            Like(CTI_FilePath_t)

IFS filepath of generated log file

Output Table Files

Field Name Long Field Name Data Type Field Title Comments 
UID
 
UID
 
DECIMAL(15:0)
 Query Unique ID 
QUERYID
 
QUERYID
 
VARCHAR(26)
 CyberSource Query ID 
REQUESTID
 
REQUESTID
 
VARCHAR(26)
 Payment Request ID 
RECONID
 
RECONCILIATIONID
 
VARCHAR(60)
 Transaction Reconciliation ID 
MERCHANTID
 
MERCHANTID
 
VARCHAR(30)
 Merchant ID 
TRANSTS
 
TRANSACTIONSTATUS
 
VARCHAR(30)
 Transaction Status 
SUBMITTS
 
SUBMITTIMESTAMP
 
TIMESTAMP
 Submission Timestamp 
APPINFSTS
 
APPSSTATUS
 
VARCHAR(30)
 Application Status 
APPINFRNCD
 
APPSREASONCODE
 
VARCHAR(5)
 Application Reason Code 
APPINFRCD
 
APPSRCODE
 
VARCHAR(15)
 Application RCode 
APPINFRFLG
 
APPSRFLAG
 
VARCHAR(50)
 Application RFlag 
MCHCSTID
 
MERCHANTCUSTOMERID
 
VARCHAR(100)
 Merchant Customer ID 
HASHPASSWD
 
HASHEDPASSWORD
 
VARCHAR(100)
 Buyer Hashed Password 
CLTCD
 
CLIENTREFERENCECODE
 
VARCHAR(50)
 Client Reference Code 
CLTAPPVER
 
CLIENTAPPVERSION
 
VARCHAR(50)
 Application Version 
CLTAPPNAME
 
CLIENTAPPNAME
 
VARCHAR(50)
 Application Name 
CLTAPPUSR
 
CLIENTAPPUSER
 
VARCHAR(30)
 Application User 
CLTAPPCOMM
 
CLIENTAPPCOMMENTS
 
VARCHAR(255)
 Comments 
CATHECIRAW
 
CONSUMERAUTHECIRAW
 
VARCHAR(2)
 Consumer ECI Raw 
CATHCAVV
 
CONSUMERAUTHCVV
 
VARCHAR(40)
 Consumer CVV 
CATHXID
 
CONSUMERXID
 
VARCHAR(40)
 Consumer XID 
CATHTRNSID
 
CONSUMERTRANSID
 
VARCHAR(60)
 Consumer Transaction ID 
DVCIPADDR
 
DEVICEIPADDRESS
 
VARCHAR(15)
 Customer Device IP Address 
DVCHSTNAME
 
DEVICEHOSTNAME
 
VARCHAR(60)
 Customer Device Host Name 
DVCCKSACP
 
DEVICECOOKIESACCEPTED
 
VARCHAR(5)
 Consumer Device Cookies Accepted 
ERRINFRSN
 
ERRORINFOREASON
 
VARCHAR(50)
 Error Information Reason 
ERRINFMSG
 
ERRORINFOMESSAGE
 
VARCHAR(255)
 Error Information Message 
NBRINSTLMT
 
NUMBEROFINSTALLMENTS
 
VARCHAR(3)
 Number of Installments 
FRDMRKRSN
 
FRAUDMARKREASON
 
VARCHAR(100)
 Fraud Marking Reason 
MCHDESCNAM
 
MERCHANTDESCRIPTORNAME
 
VARCHAR(23)
 Merchant Descriptor Name 
BTFNAME
 
BILLTOFIRSTNAME
 
VARCHAR(60)
 Bill To Customer First Name 
BTLNAME
 
BILLTOLASTNAME
 
VARCHAR(60)
 Bill To Customer Last Name 
BTMNAME
 
BILLTOMIDDLENAME
 
VARCHAR(60)
 Bill To Customer Middle Name 
BTSUFFIX
 
BILLTONAMESUFFIX
 
VARCHAR(60)
 Bill To Customer Name Suffix 
BTADDR1
 
BILLTOADDRESS1
 
VARCHAR(60)
 Bill To Address Line 1 
BTADDR2
 
BILLTOADDRESS2
 
VARCHAR(60)
 Bill To Address Line 2 
BTCITY
 
BILLTOCITY
 
VARCHAR(50)
 Bill To City 
BTSTATE
 
BILLTOSTATE
 
VARCHAR(2)
 Bill To State 
BTZIP
 
BILLTOZIP
 
VARCHAR(10)
 Bill To Zip 
BTCMPNAME
 
BILLTOCOMPANYNAME
 
VARCHAR(60)
 Bill To Company Name 
BTCMPADDR1
 
BILLTOCOMPANYADDR1
 
VARCHAR(40)
 Bill To Company Address Line 1 
BTCMPADDR2
 
BILLTOCOMPANYADDR2
 
VARCHAR(40)
 Bill To Company Address Line 2 
BTCMPCITY
 
BILLTOCOMPANYCITY
 
VARCHAR(30)
 Bill To Company City 
BTCMPSTATE
 
BILLTOCOMPANYSTATE
 
VARCHAR(2)
 Bill To Company State 
BTCMPZIP
 
BILLTOCOMPANYZIP
 
VARCHAR(10)
 Bill To Company Zip 
BTCMPCNTRY
 
BILLTOCOMPANYCOUNTRY
 
VARCHAR(2)
 Bill To Company Country 
BTEMAIL
 
BILLTOEMAIL
 
VARCHAR(255)
 Bill To Email Address 
BTCNTRY
 
BILLTOCOUNTRY
 
VARCHAR(2)
 Bill To Country 
BTCSTITLE
 
BILLTOTITLE
 
VARCHAR(60)
 Bill To Customer Title 
BTPHONE
 
BILLTOPHONE
 
VARCHAR(15)
 Bill To Phone Number 
STFNAME
 
SHIPTOFIRSTNAME
 
VARCHAR(60)
 Ship To Customer First Name 
STLNAME
 
SHIPTOLASTNAME
 
VARCHAR(60)
 Ship To Customer Last Name 
STADDR1
 
SHIPTOADDRESS1
 
VARCHAR(60)
 Ship To Address Line 1 
STADDR2
 
SHIPTOADDRESS2
 
VARCHAR(60)
 Ship To Address Line 2 
STCITY
 
SHIPTOCITY
 
VARCHAR(50)
 Ship To City 
STSTATE
 
SHIPTOSTATE
 
VARCHAR(2)
 Ship To State 
STZIP
 
SHIPTOZIP
 
VARCHAR(10)
 Ship To Zip 
STCMPNAME
 
SHIPTOCOMPANYNAME
 
VARCHAR(60)
 Ship To Company Name 
STCNTRY
 
SHIPTOCOUNTRY
 
VARCHAR(2)
 Ship To Country 
STPHONE
 
SHIPTOPHONE
 
VARCHAR(15)
 Ship To Phone Number 
AMTTOT
 
TOTALAMOUNT
 
VARCHAR(19)
 Total Amount 
AMTCUR
 
AMOUNTCURRENCY
 
VARCHAR(3)
 Amount Currency 
AMTTAX
 
TAXAMOUNT
 
VARCHAR(12)
 Tax Amount 
AMTATH
 
AUTHORIZEDAMOUNT
 
VARCHAR(15)
 Authorized Amount 
AMTSETTLE
 
SETTLEMENTAMOUNT
 
VARCHAR(12)
 Settlement Amount 
AMTSETLCUR
 
SETTLEMENTAMOUNTCURRENCY
 
VARCHAR(3)
 Settlement Amount Currency 
GIFTWRAP
 
GIFTWRAP
 
VARCHAR(1)
 Gift Wrapping 
SHIPMTH
 
SHIPPINGMETHOD
 
VARCHAR(10)
 Shipping Method 
PAYTYPNAME
 
PAYMENTTYPENAME
 
VARCHAR(50)
 Payment Type Name 
PAYTYP
 
PAYMENTTYPE
 
VARCHAR(20)
 Payment Type 
PAYTYPMTH
 
PAYMENTTYPEMETHOD
 
VARCHAR(50)
 Payment Type Method 
FUNDSRC
 
PAYMENTTYPEFUNDSOURCE
 
VARCHAR(50)
 Payment Type Funding Source 
FUNDSRCAFL
 
PAYMENTTYPEFUNDAFFILIATION
 
VARCHAR(50)
 Payment Type Funding Source Affiliation 
PAYTYPCRED
 
PAYMENTTYPECREDENTIAL
 
VARCHAR(50)
 Payment Type Credential 
PAYCSTID
 
PAYMENTCUSTOMERID
 
VARCHAR(26)
 Payment Customer ID 
CRDSUFFIX
 
CARDSUFFIX
 
VARCHAR(4)
 Card Suffix 
CRDPREFIX
 
CARDPREFIX
 
VARCHAR(6)
 Card Prefix 
CRDEXPMON
 
CARDEXPIRATIONMONTH
 
VARCHAR(2)
 Card Expiration Month 
CRDEXPYR
 
CARDEXPIRATIONYEAR
 
VARCHAR(4)
 Card Expiration Year 
CRDSTRMON
 
CARDSTARTMONTH
 
VARCHAR(2)
 Card Start Month 
CRDSTRYR
 
CARDSTARTYEAR
 
VARCHAR(4)
 Card Start Year 
CRDISSNBR
 
CARDISSUENUMBER
 
VARCHAR(5)
 Card Issue Number 
CRDTYP
 
CARDTYPE
 
VARCHAR(3)
 Card Type 
CRDENCID
 
CARDACCOUNTENCODERID
 
VARCHAR(3)
 Card Account Encoder ID 
CRDUSEAS
 
CRDUSEAS
 
VARCHAR(20)
 Card Use-As 
INVNBR
 
INVOICENUMBER
 
VARCHAR(50)
 Invoice Number 
INVBARCD
 
INVOICEBARCODENUMBER
 
VARCHAR(50)
 Invoice Barcode Number 
INVEXPDT
 
INVOICEEXPIRATIONDATE
 
VARCHAR(50)
 Invoice Expiration Date 
BKRTNBR
 
BANKROUTINGNUMBER
 
VARCHAR(9)
 Bank Routing Number 
BKBRANCHCD
 
BANKBRANCHCODE
 
VARCHAR(50)
 Branch Code 
BKSWIFTCD
 
BANKSWIFTCODE
 
VARCHAR(50)
 Bank Swift Code 
BKBANKCD
 
BANKCODE
 
VARCHAR(50)
 Bank Code 
BKIBAN
 
BANKIBAN
 
VARCHAR(50)
 Bank IBAN 
BKACTSFFIX
 
BANKACCOUNTSUFFIX
 
VARCHAR(50)
 Bank Account Suffix 
BKACTPRFIX
 
BANKACCOUNTPREFIX
 
VARCHAR(50)
 Bank Account Prefix 
BKCHKNBR
 
BANKCHECKNUMBER
 
VARCHAR(8)
 Bank Check Number 
BKACTTYP
 
BANKACCOUNTTYPE
 
VARCHAR(1)
 Bank Account Type 
BKACTNAME
 
BANKACCOUNTNAME
 
VARCHAR(60)
 Bank Account Name 
BKACTCHKDG
 
BANKACCOUNTCHECKDIGIT
 
VARCHAR(50)
 Bank Account Check Digit 
BKACTENCID
 
BANKACCOUNTENCODERID
 
VARCHAR(3)
 Bank Account Encoder ID 
BKMDREFNBR
 
BANKMANDATEREFERENCENUMBER
 
VARCHAR(50)
 Bank Mandate Reference Number 
BKMDRCRTYP
 
BANKMANDATERECURRINGTYPE
 
VARCHAR(50)
 Bank Mandate Recurring Type 
BKMDID
 
BANKMANDATEID
 
VARCHAR(50)
 Bank Mandate ID 
ACTBALAMT
 
ACCOUNTBALANCEAMOUNT
 
VARCHAR(12)
 Account Balance 
ACTPRVBAL
 
ACCOUNTPREVIOUSBALANCE
 
VARCHAR(12)
 Account Previous Balance 
ACTCUR
 
ACCOUNTCURRENCY
 
VARCHAR(5)
 Account Currency 
PMTSOLN
 
PAYMENTSOLUTION
 
VARCHAR(12)
 Payment Solution 
PMTCMCIND
 
PROCESSINGCOMMERCEINDICATOR
 
VARCHAR(20)
 Processing Commerce Indicator 
PMTBSAPPID
 
PROCESSINGAPPLICATIONID
 
VARCHAR(50)
 Processing Application ID 
ATHTYP
 
AUTHORIZATIONTYPE
 
VARCHAR(15)
 Authorization Type 
BKTRNSECCD
 
BANKTRANSFERSECCODE
 
VARCHAR(50)
 Bank Transfer Sec Code 
PRCNAME
 
PROCESSORNAME
 
VARCHAR(30)
 Processor Name 
PRCTRANID
 
PROCESSORTRANSACTIONID
 
VARCHAR(50)
 Processor Transaction ID 
PRCNTTRNID
 
PROCESSORNETWORKTRANSACTIONID
 
VARCHAR(50)
 Processor Network Transaction ID 
PRCRSPID
 
PROCESSORRESPONSEID
 
VARCHAR(50)
 Processor Response ID 
PRCPVTRNID
 
PROVIDERTRANSACTIONID
 
VARCHAR(50)
 Processor Provider Transaction ID 
PRCAPRCD
 
PROCESSORAPPROVALCODE
 
VARCHAR(50)
 Processor Approval Code 
PRCRSPCD
 
PROCESSORRESPONSECODE
 
VARCHAR(10)
 Processor Response Code 
PRCAVSCD
 
AVSCODE
 
VARCHAR(1)
 AVS Code 
PRCAVSCDRW
 
AVSCODERAW
 
VARCHAR(10)
 AVS Code Raw 
PRCCVRSTCD
 
CARDVERIFICATIONRESULTCODE
 
VARCHAR(1)
 CVN Result Code 
PRCACHRSCD
 
ACHVERIFICATIONRESULTCODE
 
VARCHAR(2)
 ACH Verification Result Code 
PRCACHCDRW
 
ACHVERIFICATIONCODERAW
 
VARCHAR(10)
 ACH Verification Result Code Raw 
EVEMAIL
 
EVEMAILRESULT
 
VARCHAR(1)
 EV Email Result 
EVEMAILRAW
 
EVEMAILRESULTRAW
 
VARCHAR(1)
 EV Email Result Raw 
EVNAME
 
EVNAMERESULT
 
VARCHAR(30)
 EV Name Result 
EVNAMERAW
 
EVNAMERESULTRAW
 
VARCHAR(30)
 EV Name Result Raw 
EVPHONE
 
EVPHONERESULT
 
VARCHAR(1)
 EV Phone Result 
EVPHONERAW
 
EVPHONERESULTRAW
 
VARCHAR(1)
 EV Phone Result Raw 
EVSTREET
 
EVSTREETRESULT
 
VARCHAR(1)
 EV Street Result 
EVSTREETRW
 
EVSTREETRESULTRAW
 
VARCHAR(1)
 EV Street Result Raw 
EVZIP
 
EVZIPRESULT
 
VARCHAR(1)
 EV Zip Result 
EVZIPRAW
 
EVZIPRESULTRAW
 
VARCHAR(1)
 EV Zip Result Raw 
SYSTRADNBR
 
SYSTEMTRACEAUDITNUMBER
 
VARCHAR(6)
 System Trace Audit Number 
RSPCDSRC
 
RESPONSECODESOURCE
 
VARCHAR(1)
 Response Code Source 
POSENTRYMD
 
POSENTRYMODE
 
VARCHAR(11)
 POS Entry Mode 
POSTERMCAP
 
POSTERMINALCAPABILITY
 
VARCHAR(1)
 POS Termianl Capability 
PRFNAME
 
PROFILENAME
 
VARCHAR(50)
 Profile Name 
PRFDCSN
 
PROFILEDECISION
 
VARCHAR(255)
 Decision Returned by the Profile 
PASPRFNAME
 
PASSIVEPROFILENAME
 
VARCHAR(50)
 Passive Profile Name 
PASPRFDSCN
 
PASSIVEPROFILEDECISION
 
VARCHAR(255)
 Passive Profile Decision 
FACTORCDS
 
SCOREFACTORCODES
 
VARCHAR(100)
 Score Factor Codes 
SCORERSLT
 
SCORERESULT
 
VARCHAR(50)
 Score Result 
RISKLOCTS
 
RISKLOCALTIME
 
CHAR(30)
 Risk Information Local Time 
SNDREFNBR
 
SENDERREFERENCENUMBER
 
VARCHAR(19)
 Sender Reference Number
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
QUERYID
 
QUERYID
 
VARCHAR(26)
 CyberSource Query ID 
UID
 
UID
 
DECIMAL(15:0)
 Application Unique ID 
APPNAME
 
APPLICATIONNAME
 
VARCHAR(30)
 Application Name 
APPSTS
 
APPLICATIONSTATUS
 
VARCHAR(30)
 Application Status 
APPRSNCD
 
APPLICATIONREASONCODE
 
VARCHAR(5)
 Application Reason Code 
APPRCD
 
APPLICATIONRCODE
 
VARCHAR(15)
 Application RCode 
APPRFLAG
 
APPLICATIONRFLAG
 
VARCHAR(50)
 Application RFlag 
APPRECONID
 
APPLICATIONRECONCILIATIONID
 
VARCHAR(60)
 Application Reconciliation ID 
APPRMSG
 
APPLICATIONRMESSAGE
 
VARCHAR(255)
 Application rMessage 
APPRTNCD
 
APPLICATIONRETURNCODE
 
VARCHAR(50)
 Application Return Code
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
QUERYID
 
QUERYID
 
VARCHAR(26)
 CyberSource Query ID 
UID
 
UID
 
DECIMAL(15:0)
 Error Unique ID 
ERRFIELD
 
ERRORFIELD
 
VARCHAR(1024)
 JSON Field in Error 
ERRREASON
 
ERRORREASON
 
VARCHAR(15)
 Error Reason
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
QUERYID
 
QUERYID
 
VARCHAR(26)
 CyberSource Query ID 
UID
 
UID
 
DECIMAL(15:0)
 Line Item Unique ID 
PRODUCTCD
 
PRODUCTCODE
 
VARCHAR(255)
 Product Code 
PRODUCTNAM
 
PRODUCTNAME
 
VARCHAR(255)
 Product Name 
PRODUCTSKU
 
PRODUCTSKU
 
VARCHAR(255)
 Product SKU 
TAXAMT
 
TAXAMOUNT
 
VARCHAR(15)
 Tax Amount 
QUANTITY
 
QUANTITY
 
VARCHAR(15)
 Quantity of Product 
UNITPRICE
 
UNITPRICE
 
VARCHAR(15)
 Unit Price 
FULFILTYP
 
FULFILLMENTTYPE
 
VARCHAR(2)
 Fulfillment Type
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
QUERYID
 
QUERYID
 
VARCHAR(26)
 CyberSource Query ID 
UID
 
UID
 
DECIMAL(15:0)
 Merchant-Defined Unique ID 
MDIKEY
 
MERCHDEFINEDINFOKEY
 
VARCHAR(50)
 Merchant-Defined Information Key 
MDIVALUE
 
MERCHDEFINEDINFOVALUE
 
VARCHAR(255)
 Merchant-Defined Information Value
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
QUERYID
 
QUERYID
 
VARCHAR(26)
 CyberSource Query ID 
UID
 
UID
 
DECIMAL(15:0)
 Passive Rule Unique ID 
PASRULNAME
 
PASSIVERULENAME
 
VARCHAR(50)
 Passive Rule Name 
PASRULDSCN
 
PASSIVERULEDECISION
 
VARCHAR(255)
 Passive Rule Decision
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
QUERYID
 
QUERYID
 
VARCHAR(26)
 CyberSource Query ID 
UID
 
UID
 
DECIMAL(15:0)
 Rule Unique ID 
RULNAME
 
RULENAME
 
VARCHAR(50)
 Rule Name 
RULDSCN
 
RULEDECISION
 
VARCHAR(255)
 Rule Decision