CTI_ParseBatchDetailReport()

This subprocedure is used to parse a previously downloaded batch detail report. This subprocedure requires that you provide the fully-qualified filepath of the downloaded report file in the IFS. If this report was downloaded with CTI_DownloadReport(), 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_ParseBatchDetailReport...
D                 PR              N   Extproc('CTI_ParseBatchDetailReport')

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  pReportFile                        Const Like(CTI_FilePath_t)

The fully-qualified filepath of the report file in the IFS that will be parsed. If this report was downloaded using CTI_DownloadReport(), 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)
 Report Unique ID 
REQUESTID
 
REQUESTID
 
VARCHAR(30)
 Request ID 
MERCHANTID
 
MERCHANTID
 
VARCHAR(30)
 Merchant ID 
FILEPATH
 
FILEPATH
 
VARCHAR(1024)
 Report Filepath 
RPTNAME
 
REPORTNAME
 
VARCHAR(250)
 Report Name 
RPTTYP
 
REPORTTYPE
 
VARCHAR(250)
 Report Type 
RPTVER
 
REPORTVERSION
 
VARCHAR(10)
 Report Version 
RPTORGID
 
REPORTORGANIZATIONID
 
VARCHAR(30)
 Report Organization ID 
RPTSTARTDT
 
REPORTSTARTDATE
 
TIMESTAMP
 Report Start Date 
RPTENDDT
 
REPORTENDDATE
 
TIMESTAMP
 Report End Date 
RQCMTS
 
REQUESTCOMMENTS
 
VARCHAR(255)
 Request Comments 
RQLOCALDT
 
REQUESTLOCALDATE
 
DATE
 Request Localized Date 
RQMCHID
 
REQUESTMERCHANTID
 
VARCHAR(30)
 Request Merchant ID 
RQMCHREF
 
REQUESTMERCHANTREFNBR
 
VARCHAR(40)
 Request Merchant Reference Number 
RQORGTRNID
 
REQUESTPARTNERORGTRANSID
 
VARCHAR(32)
 Request Partner Original Transaction ID 
RQSDKVER
 
REQUESTPARTNERSDKVERSION
 
VARCHAR(32)
 Request Partner SDK Version 
RQSOURCE
 
REQUESTSOURCE
 
VARCHAR(50)
 Request Source 
RQSUBID
 
REQUESTSUBSCRIPTIONID
 
VARCHAR(26)
 Request Subscription ID 
RQTRMSRL
 
REQUESTTERMINALSERIALNBR
 
VARCHAR(32)
 Request Terminal Serial Number 
RQDT
 
REQUESTDATE
 
TIMESTAMP
 Request Date 
RQUSER
 
REQUESTUSER
 
VARCHAR(30)
 Request User 
BTADDR1
 
BILLTOADDRESS1
 
VARCHAR(100)
 Bill To Address Line 1 
BTADDR2
 
BILLTOADDRESS2
 
VARCHAR(100)
 Bill To Address Line 2 
BTCITY
 
BILLTOCITY
 
VARCHAR(50)
 Bill To City 
BTCMPNAME
 
BILLTOCOMPANYNAME
 
VARCHAR(60)
 Bill To Company Name 
BTCMPTAXID
 
BILLTOCOMPANYTAXID
 
VARCHAR(9)
 Bill To Company Tax ID 
BTCNTRY
 
BILLTOCOUNTRY
 
VARCHAR(2)
 Bill To Country 
BTCSTID
 
BILLTOCUSTOMERID
 
VARCHAR(30)
 Bill To Customer ID 
BTEMAIL
 
BILLTOEMAIL
 
VARCHAR(255)
 Bill To Email Address 
BTFNAME
 
BILLTOFIRSTNAME
 
VARCHAR(60)
 Bill To Customer First Name 
BTHOSTNAME
 
BILLTOHOSTNAME
 
VARCHAR(255)
 Bill To Hostname 
BTIPADDR
 
BILLTOIPADDRESS
 
VARCHAR(15)
 Bill To IP Address 
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 
BTPRSNLID
 
BILLTOPERSONALID
 
VARCHAR(40)
 Bill To Personal ID 
BTPHONE
 
BILLTOPHONE
 
VARCHAR(20)
 Bill To Phone Number 
BTSTATE
 
BILLTOSTATE
 
VARCHAR(64)
 Bill To State 
BTCSTITLE
 
BILLTOTITLE
 
VARCHAR(30)
 Bill To Customer Title 
BTUSRNAME
 
BILLTOUSERNAME
 
VARCHAR(30)
 Bill To Customer User Name 
BTZIP
 
BILLTOZIP
 
VARCHAR(10)
 Bill To Zip 
STADDR1
 
SHIPTOADDRESS1
 
VARCHAR(100)
 Ship To Address Line 1 
STADDR2
 
SHIPTOADDRESS2
 
VARCHAR(100)
 Ship To Address Line 2 
STCITY
 
SHIPTOCITY
 
VARCHAR(50)
 Ship To City 
STCMPNAME
 
SHIPTOCOMPANYNAME
 
VARCHAR(60)
 Ship To Company Name 
STCNTRY
 
SHIPTOCOUNTRY
 
VARCHAR(60)
 Ship To Country 
STFNAME
 
SHIPTOFIRSTNAME
 
VARCHAR(60)
 Ship To Customer First Name 
STLNAME
 
SHIPTOLASTNAME
 
VARCHAR(60)
 Ship To Customer Last Name 
STPHONE
 
SHIPTOPHONE
 
VARCHAR(20)
 Ship To Phone Number 
STSTATE
 
SHIPTOSTATE
 
VARCHAR(25)
 Ship To State 
STZIP
 
SHIPTOZIP
 
VARCHAR(10)
 Ship To Zip 
SHPCARRIER
 
SHIPPINGCARRIER
 
VARCHAR(12)
 Carrier Used to Ship Product 
SHPMTH
 
SHIPPINGMETHOD
 
VARCHAR(10)
 Shipping Method for Product 
PMTYPDESC
 
PMTYPEDESCRIPTION
 
VARCHAR(50)
 Payment Method Type Description 
PMOVRDMTH
 
PMOVERRIDEPAYMENTMETHOD
 
VARCHAR(4)
 Override Payment Method 
PMKACTSFX
 
CHECKACCOUNTSUFFIX
 
VARCHAR(4)
 Last 4 Digits of Payment Account Number 
PMKCHKNBR
 
CHECKCHECKNUMBER
 
VARCHAR(10)
 Check Number 
PMKMDTID
 
CHECKMANDATEID
 
VARCHAR(35)
 ID Reference for Direct Debit Mandate 
PMKMDTTYP
 
CHECKMANDATETYPE
 
VARCHAR(20)
 Mandate Type 
PMKSIGDT
 
CHECKSIGNATUREDATE
 
DATE
 Date of Signature 
PMKACTTYP
 
CHECKACCOUNTTYPE
 
VARCHAR(4)
 Account Type 
PMKACTENID
 
CHECKACCOUNTENCODERID
 
VARCHAR(3)
 Account Encoder ID 
PMKBNKTNBR
 
CHECKBANKTRANSITNUMBER
 
VARCHAR(9)
 Bank Transit Number 
PMKEFFCDT
 
CHECKEFFECTIVEDATE
 
DATE
 Effective Date 
PMWALTTYP
 
WALLETTYPE
 
VARCHAR(20)
 Type of Wallet 
PMCCRDTYP
 
CARDTYPE
 
VARCHAR(5)
 Type of Card 
PMCEXPMOS
 
CARDEXPIRATIONMONTH
 
VARCHAR(4)
 Card Expiration Month 
PMCEXPYR
 
CARDEXPIRATIONYEAR
 
VARCHAR(4)
 Card Expiration Year 
PMCSTMOS
 
CARDSTARTMONTH
 
VARCHAR(4)
 Card Start Month 
PMCSTYR
 
CARDSTARTYEAR
 
VARCHAR(4)
 Card Start Year 
PMCISSNBR
 
CARDISSUENUMBER
 
VARCHAR(5)
 Number of Times UK Maestro Card Issued 
PMCACTSFX
 
CARDACCOUNTSUFFIX
 
VARCHAR(4)
 Last 4 Digits of Customers Payment Account Number 
PMCACRDTYP
 
CARDADDITIONALCARDTYPE
 
VARCHAR(5)
 Additional Card Type 
PMCPPDRLD
 
CARDPREPAIDRELOADABLE
 
VARCHAR(7)
 Card Prepaid Reloadable 
PMCPPDTYP
 
CARDPREPAIDTYPE
 
VARCHAR(50)
 Card Prepaid Type 
PMCVIRTUAL
 
CARDVIRTUAL
 
VARCHAR(5)
 Card Virtual 
PMFCHKDGT
 
BANKCHECKDIGIT
 
VARCHAR(2)
 Code Used to Validate Customer Account Number 
PMFIBANIND
 
IBANINDICATOR
 
VARCHAR(1)
 International Bank Account Number (IBAN) 
PMBADDR
 
BANKADDRESS
 
VARCHAR(50)
 Bank Address 
PMBBCHCD
 
BANKBRANCHCODE
 
VARCHAR(50)
 Code Identifies Branch of Customers Bank w/o IBAN 
PMBCITY
 
BANKCITY
 
VARCHAR(50)
 Bank City 
PMBCNTRY
 
BANKCOUNTRY
 
VARCHAR(50)
 Bank Country 
PMBNAME
 
BANKNAME
 
VARCHAR(50)
 Bank Name 
PMBSWIFTCD
 
BANKSWIFTCODE
 
VARCHAR(50)
 Banks SWIFT/BIC Code. Unique Address of Bank 
PMTTKCD
 
TOKENCODE
 
VARCHAR(255)
 Transaction Token Code 
PMTNETTK
 
NETWORKTOKENTRANSTYPE
 
VARCHAR(1)
 Network Token Transaction Type 
PMBBANKCD
 
BANKCODE
 
VARCHAR(15)
 Bank/Sort Code if Account Used for Transaction 
PMBACTNAME
 
BANKACCOUNTNAME
 
VARCHAR(90)
 Bank Account Holder Name 
PMBBOLEBAR
 
BOLETOBARCODENUMBER
 
VARCHAR(50)
 Boleto Barcode as Number 
PMBPMTTYP
 
PAYMENTMETHODTYPE
 
VARCHAR(50)
 Payment Method Type 
PMBBOLENBR
 
BOLETONUMBER
 
VARCHAR(50)
 Boleto Bancario Payment Number 
RDAPDAVS
 
APPLIEDAVS
 
VARCHAR(50)
 Indicates if Address Verification Rules Applied 
RDAPDCV
 
APPLIEDCV
 
VARCHAR(1)
 Indicates if Card Verification Applied 
RDAPDCATGF
 
APPLIEDCATEGORYGIFT
 
VARCHAR(1)
 Importance of Bill/Ship Addresses in the Order 
RDAPDCATTM
 
APPLIEDCATEGORYTIME
 
VARCHAR(6)
 Importance of Time of Day in Assessing the Order 
RDAPDHSTH
 
APPLIEDHOSTHEDGE
 
VARCHAR(6)
 Importance of Email/IP Address in the Order 
RDAPDTHLD
 
APPLIEDTHRESHOLD
 
VARCHAR(10)
 Score Threshold Applied to Order 
RDAPDTMH
 
APPLIEDTIMEHEDGE
 
VARCHAR(6)
 Importance of Time of Day in Assesing the Order 
RDAPDVELH
 
APPLIEDVELOCITYHEDGE
 
VARCHAR(6)
 Importance of Customer Orders Over Time 
RDBNACTTYP
 
BINACCOUNTTYPE
 
VARCHAR(2)
 Type of Customer 
RDBNCNTRY
 
BINCOUNTRY
 
VARCHAR(2)
 2-Digit Country Code w/ BIN 
RDBNISSUER
 
BINISSUER
 
VARCHAR(128)
 Card Account Issuer 
RDBNSCHEME
 
BINSCHEME
 
VARCHAR(64)
 Subtype of Card Account 
RDCNSLTY
 
CONSUMERLOYALTY
 
VARCHAR(1)
 Indicates Account Number, or if Loyalty Acct Used 
RDCNSPASS
 
CONSUMERPASSWORDPROVIDED
 
VARCHAR(1)
 Reserved for Future Use 
RDCNSPROMO
 
CONSUMERPROMOTIONS
 
VARCHAR(1)
 Reserved for Future Use 
RDCKSACP
 
COOKIESACCEPTED
 
VARCHAR(1)
 Indicates Web Cookies Accepted: True or False 
RDCKSEN
 
COOKIESENABLED
 
VARCHAR(1)
 Indicates if Web Cookies Enabled in Browser 
RDDVCFPRT
 
DEVICEFINGERPRINT
 
VARCHAR(80)
 Indicates if Device Fingerprints Used 
RDFACTORS
 
FACTORS
 
VARCHAR(100)
 Information that Affected Score of the Order 
RDFLASHEN
 
FLASHENABLED
 
VARCHAR(1)
 Indicates if Flash Enabled in Customers Browser 
RDGFWRAP
 
GIFTWRAP
 
VARCHAR(1)
 Reserved for Future Use 
RDHOSTSEV
 
HOSTSEVERITY
 
VARCHAR(10)
 Risk Associated with Customers Email Domain 
RDIPCITY
 
IPCITY
 
VARCHAR(50)
 Name of City Decoded from Customers IP Address 
RDIPCNTRY
 
IPCOUNTRY
 
VARCHAR(60)
 Name of Country Decoded from Customers IP Address 
RDIPRTMTH
 
IPROUTINGMETHOD
 
VARCHAR(30)
 Name of Routing Method Decoded from IP Address 
RDIPSTATE
 
IPSTATE
 
VARCHAR(20)
 Name of State Decoded from Customers IP Address 
RDIMGEN
 
IMAGESENABLED
 
VARCHAR(1)
 Indicates if Images are Enabled in Browser 
RDJSEN
 
JAVASCRIPTENABLED
 
VARCHAR(1)
 Indicates if JavaScript Active in Browser 
RDLOSTPASS
 
LOSTPASSWORD
 
VARCHAR(1)
 Reserved for Future Use 
RDPRDRISK
 
PRODUCTRISK
 
VARCHAR(6)
 Indicates Level of Product Risk: low, normal, high 
RDPADDR
 
PROXYIPADDRESS
 
VARCHAR(64)
 Proxys IP Address if Available 
RDPADDRACT
 
PROXYIPADDRESSACTIVITIES
 
VARCHAR(255)
 Actions Associated w/ Proxys IP Address 
RDPADDRATT
 
PROXYIPADDRESSATTRIBUTES
 
VARCHAR(255)
 Characteristics Associated w/ Proxys IP Address 
RDPSRVTYP
 
PROXYSERVERTYPE
 
VARCHAR(12)
 Type of Proxy Server Based on the HTTP Header 
RDRPTCST
 
REPEATCUSTOMER
 
VARCHAR(1)
 Reserved for Future use 
RDRTNACPT
 
RETURNSACCEPTED
 
VARCHAR(5)
 Indicates if Returns Accepted: True or False 
RDSCORE
 
RISKSCORE
 
VARCHAR(50)
 Total Score Calculated for the Order 
RDLOCALTM
 
RISKTIMELOCAL
 
TIMESTAMP
 Local Time of Order 
RDTIPADDR
 
TRUEIPADDRESS
 
VARCHAR(64)
 Customers True IP Address Detected by Application 
RDTIPATTR
 
TRUEIPADDRESSATTRIBUTES
 
VARCHAR(255)
 Characteristics Associated w/ True IP Address 
RDTIPCITY
 
TRUEIPADDRESSCITY
 
VARCHAR(50)
 City Associated w/ True IP Address 
RDTIPCNTRY
 
TRUEIPADDRESSCOUNTRY
 
VARCHAR(2)
 Country Associated w/ True IP Address 
RDTIPACT
 
TRUEIPADDRESSACTIVITIES
 
VARCHAR(255)
 Actions Associated w/ True IP Address 
BATCHID
 
BATCHID
 
VARCHAR(8)
 CyberSource Batch in Which Transaction was Sent 
BATCHDT
 
BATCHDATE
 
TIMESTAMP
 Date when Batch was Sent to the Processor 
BATCHSTS
 
BATCHSTATUS
 
VARCHAR(10)
 Status of Batch File 
BATCHSFLAG
 
BATCHSUCCESSFLAG
 
VARCHAR(50)
 Indicates Whether Batch Processing was Succesful 
DEVICEID
 
DEVICEID
 
VARCHAR(32)
 ID of Device Used for Transaction 
GIFTCURBAL
 
GIFTCARDCURRENTBALANCE
 
VARCHAR(12)
 Gift Card Current Balance 
GIFTPRVBAL
 
GITFCARDPREVIOUSBALANCE
 
VARCHAR(12)
 Gift Card Previous Balance 
IHICUSTDTA
 
CUSTOMDATA_1
 
VARCHAR(32)
 Custom Data 1
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
REQUESTID
 
REQUESTID
 
VARCHAR(30)
 CyberSource Request ID 
UID
 
UID
 
DECIMAL(15:0)
 Application Reply Unique Id 
APRNAME
 
APPLICATIONREPLYNAME
 
VARCHAR(30)
 Name of Application Used 
APRCD
 
RCODE
 
VARCHAR(15)
 Indicates Successful Request 
APRSNCD
 
REASONCODE
 
VARCHAR(5)
 Reason Code 
APRFLAG
 
RFLAG
 
VARCHAR(50)
 Description of Result of Request 
APRMSG
 
RMSG
 
VARCHAR(255)
 Message Explaining Value
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
REQUESTID
 
REQUESTID
 
VARCHAR(30)
 CyberSource Request ID 
UID
 
UID
 
DECIMAL(15:0)
 Info Code Unique Id 
INFOCDTYP
 
INFOCODETYPE
 
VARCHAR(20)
 Category of Info Returned for an Order 
INFOCDVAL
 
INFOCODEVALUE
 
VARCHAR(255)
 Info Code Returned in Element
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
REQUESTID
 
REQUESTID
 
VARCHAR(30)
 CyberSource Request ID 
UID
 
UID
 
DECIMAL(15:0)
 Line Item Unique Id 
LINBR
 
LINEITEMNUMBER
 
VARCHAR(40)
 Line Item Number 
LIFFLTYP
 
FULLFILLMENTTYPE
 
VARCHAR(2)
 Info on Line Item Prod Code 
LIINVNBR
 
INVOICENUMBER
 
VARCHAR(30)
 Invoice Number for Order 
LIPRODSKU
 
MERCHANTPRODUCTSKU
 
VARCHAR(255)
 Merchant Product ID Code 
LIPRODCD
 
PRODUCTCODE
 
VARCHAR(255)
 Determines Product Category 
LIPRODNAME
 
PRODUCTNAME
 
VARCHAR(255)
 Name of Product 
LIITMQTY
 
QUANTITY
 
VARCHAR(15)
 Quantity of Product 
LITAXAMT
 
TAXAMOUNT
 
VARCHAR(20)
 Tax to be Applied to Product 
LIUNITPRC
 
UNITPRICE
 
VARCHAR(20)
 Per-item Price of Product
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 
REQUESTID
 
REQUESTID
 
VARCHAR(30)
 
MDDFLD1
 
MERCHANTDEFINEDDATAFIELD1
 
VARCHAR(1175)
 
MDDFLD2
 
MERCHANTDEFINEDDATAFIELD2
 
VARCHAR(1175)
 
MDDFLD3
 
MERCHANTDEFINEDDATAFIELD3
 
VARCHAR(1175)
 
MDDFLD4
 
MERCHANTDEFINEDDATAFIELD4
 
VARCHAR(1175)
 
MDDFLD5
 
MERCHANTDEFINEDDATAFIELD5
 
VARCHAR(1175)
 
MDDFLD6
 
MERCHANTDEFINEDDATAFIELD6
 
VARCHAR(1175)
 
MDDFLD7
 
MERCHANTDEFINEDDATAFIELD7
 
VARCHAR(1175)
 
MDDFLD8
 
MERCHANTDEFINEDDATAFIELD8
 
VARCHAR(1175)
 
MDDFLD9
 
MERCHANTDEFINEDDATAFIELD9
 
VARCHAR(1175)
 
MDDFLD10
 
MERCHANTDEFINEDDATAFIELD10
 
VARCHAR(1175)
 
MDDFLD11
 
MERCHANTDEFINEDDATAFIELD11
 
VARCHAR(1175)
 
MDDFLD12
 
MERCHANTDEFINEDDATAFIELD12
 
VARCHAR(1175)
 
MDDFLD13
 
MERCHANTDEFINEDDATAFIELD13
 
VARCHAR(1175)
 
MDDFLD14
 
MERCHANTDEFINEDDATAFIELD14
 
VARCHAR(1175)
 
MDDFLD15
 
MERCHANTDEFINEDDATAFIELD15
 
VARCHAR(1175)
 
MDDFLD16
 
MERCHANTDEFINEDDATAFIELD16
 
VARCHAR(1175)
 
MDDFLD17
 
MERCHANTDEFINEDDATAFIELD17
 
VARCHAR(1175)
 
MDDFLD18
 
MERCHANTDEFINEDDATAFIELD18
 
VARCHAR(1175)
 
MDDFLD19
 
MERCHANTDEFINEDDATAFIELD19
 
VARCHAR(1175)
 
MDDFLD20
 
MERCHANTDEFINEDDATAFIELD20
 
VARCHAR(1175)
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
REQUESTID
 
REQUESTID
 
VARCHAR(30)
 CyberSource Request ID 
UID
 
UID
 
DECIMAL(15:0)
 Payment Info Unique Id 
AVSRESULT
 
AVSRESULT
 
VARCHAR(10)
 Code for Addrs Verification Services for Payment 
AVSRSLTMAP
 
AVSRESULTMAPPED
 
VARCHAR(5)
 Address Verification Service Result for Payment 
AQRMCHNBR
 
ACQUIRERMERCHANTNUMBER
 
VARCHAR(15)
 ID that was Assigned by Acq. Printed on Receipt 
AMT
 
AMT
 
VARCHAR(20)
 Grand Total for the Order 
ATHFCTCD
 
AUTHFACTORCODE
 
VARCHAR(100)
 
ATHIND
 
AUTHINDICATOR
 
VARCHAR(1)
 
ATHREVAMT
 
AUTHREVERSALAMOUNT
 
VARCHAR(15)
 
ATHREVRSLT
 
AUTHREVERSALRESULT
 
VARCHAR(50)
 
ATHCD
 
AUTHORIZATIONCODE
 
VARCHAR(15)
 Authorization Code for the Payment 
ATHTYP
 
AUTHORIZATIONTYPE
 
VARCHAR(1)
 Authorization Type for the Payment 
BATCHFLID
 
BATCHFILESID
 
VARCHAR(50)
 
CVRESULT
 
CVRESULT
 
VARCHAR(1)
 VCN Result Code 
CARDCAT
 
CARDCATEGORY
 
VARCHAR(10)
 Type of Card Used in the Transaction 
CARDCATCD
 
CARDCATEGORYCODE
 
VARCHAR(10)
 Category Code of Card Used in the Transaction 
CARDPRSNT
 
CARDPRESENT
 
VARCHAR(1)
 Shows Whether Card is Present at Time of Transacti 
CARDVRFMTH
 
CARDVERIFICATIONMETHOD
 
VARCHAR(50)
 
CUSTOMERID
 
CUSTOMERID
 
VARCHAR(30)
 Your Identifier for the Customer 
DCCIND
 
DCCINDICATOR
 
VARCHAR(1)
 Flag indicates wthr DCC is being used for trnsactn 
EMVREQFLBK
 
EMVREQUESTFALLBACK
 
VARCHAR(5)
 Indicates a Fallback Method used to Enter CC Info 
EXCHGRT
 
EXCHANGERATE
 
VARCHAR(27)
 Exchange Rate 
EXCHGRTDT
 
EXCHANGERATEDATE
 
TIMESTAMP
 Timestamp for the Exchange Date 
ISSRSPCD
 
ISSUERRESPONSECODE
 
VARCHAR(15)
 Auth Code Printed on Receipt when Returned 
MDREFNBR
 
MANDATEREFERENCENUMBER
 
VARCHAR(35)
 
NETCD
 
NETWORKCODE
 
VARCHAR(4)
 
NETTRANSID
 
NETWORKTRANSACTIONID
 
VARCHAR(20)
 
ORIGAMT
 
ORIGINALAMOUNT
 
VARCHAR(15)
 
ORIGCURR
 
ORIGINALCURRENCY
 
VARCHAR(5)
 
POSCATLVL
 
POSCATLEVEL
 
CHAR(1)
 Type of Cardholder-activated Terminal 
POSENTMODE
 
POSENTRYMODE
 
VARCHAR(11)
 Method of Entering CC Info into POS terminal 
POSENV
 
POSENVIRONMENT
 
VARCHAR(1)
 Operating Environment 
PAYPROC
 
PAYMENTPROCESSOR
 
VARCHAR(40)
 Name of Payment Processor 
PAYREQID
 
PAYMENTREQUESTID
 
CHAR(30)
 Original Request ID for the Purchase 
PINTYP
 
PINTYPE
 
CHAR(1)
 Method Used to Verify the Cardholders Identity 
PROCMID
 
PROCESSORMID
 
VARCHAR(20)
 
PROCRSPCD
 
PROCESSORRESPONSECODE
 
VARCHAR(60)
 Error Message Sent Directly from the Bank 
PROCRSPID
 
PROCESSORRESPONSEID
 
VARCHAR(50)
 Response ID Sent from the Processor 
PROCTID
 
PROCESSORTID
 
VARCHAR(60)
 Transaction ID used to Identify/Track Transaction 
PROCTRANID
 
PROCESSORTRANSACTIONID
 
VARCHAR(50)
 
RTNETWKTYP
 
RTNETWKTYP
 
VARCHAR(1)
 Processor Scheme Used for Routing the Transaction 
SOLNTYP
 
SOLUTIONTYPE
 
VARCHAR(12)
 
STORFWDIND
 
STOREANDFORWARDINDICATOR
 
VARCHAR(5)
 Store Trans Memory to Send Auth When cnct is rstrd 
SMCHCITY
 
SUBMERCHANTCITY
 
VARCHAR(50)
 Submerchant City 
SMCHCNTRY
 
SUBMERCHANTSCOUNTRY
 
VARCHAR(2)
 Submerchant Country 
SMCHEMAIL
 
SUBMERCHANTEMAIL
 
VARCHAR(255)
 Submerchant Email Address 
SMCHID
 
SUBMERCHANTID
 
VARCHAR(30)
 ID assigned to submerchant 
SMCHNAME
 
SUBMERCHANTNAME
 
VARCHAR(40)
 Submerchant Name 
SMCHPHONE
 
SUBMERCHANTPHONE
 
VARCHAR(20)
 Submerchant Phone Number 
SMCHPOSTCD
 
SUBMERCHANTPOSTALCODE
 
VARCHAR(10)
 Submerchant Postal/Zip Code 
SMCHSTATE
 
SUBMERCHANTSTATE
 
VARCHAR(64)
 Submerchants State 
SMCHSTREET
 
SUBMERCHANTSTREET
 
VARCHAR(100)
 First Line of Street Address 
TGTAMT
 
TARGETAMOUNT
 
CHAR(20)
 Converted Amount 
TGTCURR
 
TARGETCURRENCY
 
VARCHAR(3)
 Billing Currency 
TERMALTID
 
TERMINALIDALTERNATE
 
VARCHAR(8)
 ID for an alternate terminal at retail location 
TOTTAXAMT
 
TOTALTAXAMOUNT
 
CHAR(20)
 Total tax amt for all the line items in transactio 
TRNREFNBR
 
TRANSACTIONREFERENCENUMBER
 
VARCHAR(60)
 Ref Number for the Transaction 
ECOMIND
 
ECOMMERCEINDICATOR
 
VARCHAR(1)
 Type of eCommerce Transaction 
RECPADDR
 
RECIPIENTADDRESS
 
VARCHAR(100)
 Recipient Street Address 
RECPCITY
 
RECIPIENTCITY
 
VARCHAR(50)
 Recipient City 
RECPCNTRY
 
RECIPIENTCOUNTRY
 
VARCHAR(2)
 Recipient Country 
RECPDOB
 
RECIPIENTDOB
 
VARCHAR(8)
 Recipient Date of Birth 
RECPFNAME
 
RECIPIENTFIRSTNAME
 
VARCHAR(60)
 Recipient First Name 
RECPLNAME
 
RECIPIENTLASTNAME
 
VARCHAR(60)
 Recipient Last Name 
RECPMINIT
 
RECIPIENTMIDDLEINITIAL
 
VARCHAR(60)
 Recipient Middle Initial 
RECPPHONE
 
RECIPIENTPHONENUMBER
 
VARCHAR(20)
 Recipient Phone Number 
RECPPOSTCD
 
RECIPIENTPOSTALCODE
 
VARCHAR(10)
 Recipient Postal Code 
RECPBAMT
 
RECIPIENTBILLINGAMOUNT
 
CHAR(20)
 Recipient Billing Amount 
RECPBCURR
 
RECIPIENTBILLINGCURRENCY
 
VARCHAR(3)
 Recipient Billing Currency 
RECPSTATE
 
RECIPIENTSTATE
 
VARCHAR(25)
 Recipient State 
SENDADDR
 
SENDERADDRESS
 
VARCHAR(100)
 Sender Address 
SENDCITY
 
SENDERCITY
 
VARCHAR(50)
 Sender City 
SENDCNTRY
 
SENDERCOUNTRY
 
VARCHAR(2)
 Sender Country 
SENDDOB
 
SENDERDOB
 
VARCHAR(8)
 Sender Date of Birth 
SENDFNAME
 
SENDERFIRSTNAME
 
VARCHAR(60)
 Sender First Name 
SENDLNAME
 
SENDERLASTNAME
 
VARCHAR(60)
 Sender Last Name 
SENDMINIT
 
SENDERMIDDLEINITIAL
 
VARCHAR(60)
 Sender Middle Initial 
SENDPHONE
 
SENDERPHONENUMBER
 
VARCHAR(20)
 Sender Phone Number 
SENDPOSTCD
 
SENDERPOSTALCODE
 
VARCHAR(10)
 Sender Postal/Zip Code 
SENDREFNBR
 
SENDERREFERENCENUMBER
 
VARCHAR(16)
 Sender Reference Number 
SENDSRCFND
 
SENDERSOURCEOFFUNDS
 
VARCHAR(2)
 Source of Funds 
SENDSTATE
 
SENDERSTATE
 
VARCHAR(25)
 Sender State 
ATHAAVCAVV
 
AAV_CAVV
 
VARCHAR(3)
 Opt Auth Data you can receive after Cust Auth 
ATHECI
 
ATHECI
 
CHAR(5)
 Opt Info you can receive if use Payer Auth Service 
ATHXID
 
ATHXID
 
VARCHAR(40)
 Opt Trans ID generated by Payer Auth 
ACHVFRSLT
 
ACHVERIFICATIONRAW
 
VARCHAR(2)
 Raw ACH Verification Result 
ACHVFRSLTM
 
ACHVERIFICATIONMAPPED
 
VARCHAR(2)
 Mapped ACH Verification Result 
CURRCD
 
CURRENCYCODE
 
VARCHAR(3)
 Currency Code 
NBRINSTLMT
 
NBRINSTALLMENTS
 
VARCHAR(3)
 Number of Installments 
PRODCD
 
PRODUCTCODE
 
VARCHAR(255)
 Product Code 
GRANDTOT
 
GRANDTOT
 
VARCHAR(20)
 Grand Total 
BALAMT
 
BALANCEAMOUNT
 
VARCHAR(20)
 Remaining Balance Amount 
BALCURRCD
 
BALANCECURRCODE
 
VARCHAR(3)
 Balance Currency Code 
REQAMT
 
REQUESTEDAMOUNT
 
VARCHAR(20)
 Requested Amount for Authorization 
REQAMTCURR
 
REQUESTEDAMTCURRENCY
 
VARCHAR(3)
 Requested Amount Currency 
BINNBR
 
BINNBR
 
VARCHAR(6)
 Bin Number 
EVFEMAIL
 
EVERIFICATIONEMAIL
 
VARCHAR(5)
 Electronic Verification Email Result 
EVFEMAILR
 
EVERIFICATIONEMAILRAW
 
VARCHAR(10)
 Raw Electronic Verification Email Result 
EVFNAME
 
EVERIFICATIONNAME
 
VARCHAR(5)
 Electronic Verification Name Result 
EVFNAMER
 
EVERIFICATIONNAMERAW
 
VARCHAR(10)
 Raw Electronic Verification Name Result 
EVFPHONE
 
EVERIFICATIONPHONE
 
VARCHAR(5)
 Electronic Verification Phone Result 
EVFPHONER
 
EVERIFICATIONPHONERAW
 
VARCHAR(10)
 Raw Electronic Verification Phone Result 
EVFPOSTCD
 
EVERIFICATIONPOSTCODE
 
VARCHAR(5)
 Electronic Verification Post Code Result 
EVFPOSTCDR
 
EVERIFICATIONPOSTCODERAW
 
VARCHAR(10)
 Raw Electronic Verification Post Code Result 
EVFSTREET
 
EVERIFICATIONSTREET
 
VARCHAR(5)
 Electronic Verification Street Result 
EVFSTREETR
 
EVERIFICATIONSTREETRAW
 
VARCHAR(10)
 Raw Electronic Verification Street Result 
DEBITIND
 
DEBITINDICATOR
 
VARCHAR(50)
 Debit Indicator 
EMVSVCCD
 
EMVSERVICECODE
 
VARCHAR(50)
 EMV Service Code 
AFTIND
 
AFTINDICATOR
 
VARCHAR(50)
 AFT Indicator 
CATAFFLT
 
CATEGORYAFFILIATE
 
VARCHAR(25)
 Category Affiliate 
CATCAMPGN
 
CATEGORYCAMPAIGN
 
VARCHAR(25)
 Category Campaign 
CATGROUP
 
CATEGORYGROUP
 
VARCHAR(25)
 Category Group 
AVSRLTMODE
 
AVSRESULTMODE
 
VARCHAR(50)
 AVS Result Mode 
AVSRSP
 
AVSRESPONSE
 
VARCHAR(50)
 AVS Response
Field Name Long Field Name Data Type Field Title Comments 
PID
 
PID
 
DECIMAL(15:0)
 Parent Report Unique Id 
REQUESTID
 
REQUESTID
 
VARCHAR(30)
 CyberSource Request ID 
UID
 
UID
 
DECIMAL(15:0)
 Profile Unique Id 
PRFNAME
 
PROFILENAME
 
VARCHAR(30)
 Profile Name 
PRFMODE
 
PROFILEMODE
 
VARCHAR(1)
 Activity Mode of the Profile 
PRFDCSN
 
PROFILEDECISION
 
VARCHAR(255)
 Decision Returned by the Profile 
RULENAME
 
RULENAME
 
VARCHAR(30)
 Name of the Rule 
RULEDCSN
 
RULEDECISION
 
VARCHAR(255)
 Decision Returned by the Rule