CTI_ParseExceptionDetailReport()

This subprocedure is used to parse a previously downloaded exception 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_ParseExceptionDetailReport...
D                 PR              N   Extproc('CTI_ParseExceptionDetailRep-
D                                     ort')

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

AR CTIEDRR

Record

CyberSource Exception Detail Report Record

A UID           15P 0

Key

Report Unique ID

A REQUESTID     30A         VARLEN

Key

CyberSource request unique ID

A MERCHANTID    30A         VARLEN

Merchant ID for the reporting account

A FILEPATH    1024A         VARLEN

Filepath of the parsed report

A RPTNAME      250A         VARLEN
A                           ALIAS(REPORTNAME)

Report name

A RPTTYP       250A         VARLEN
A                           ALIAS(REPORTTYPE)

Report type

A RPTVER        10A         VARLEN
A                           ALIAS(REPORTVERSION)

Report version

A RPTORGID      30A         VARLEN
A                           ALIAS(REPORTORGANIZATIONID)

Report organization ID

A RPTSTARTDT      Z         ALIAS(REPORTSTARTDATE)

Report start date

A RPTENDDT        Z         ALIAS(REPORTENDDATE)

Report end date

A RQCMTS       255A         VARLEN
A                           ALIAS(REQUESTCOMMENTS)

Request comments

A RQLOCALDT       L         ALIAS(REQUESTLOCALDATE)

Request localized date

A RQMCHID       30A         VARLEN
A                           ALIAS(REQUESTMERCHANTID)

Request merchant ID

A RQMCHREF      40A         VARLEN
A                           ALIAS(REQUESTMERCHANTREFNBR)

Request merchant reference number

A RQORGTRNID    32A         VARLEN
A                           ALIAS(REQUESTPARTNERORGTRANSID)

Request partner original transaction ID

A RQSDKVER      32A         VARLEN
A                           ALIAS(REQUESTPARTNERSDKVERSION)

Request partner SDK version

A RQSOURCE      50A         VARLEN
A                           ALIAS(REQUESTSOURCE)

Request source

A RQSUBID       26A         VARLEN
A                           ALIAS(REQUESTSUBSCRIPTIONID)

Request subscription ID

A RQTRMSRL      32A         VARLEN
A                           ALIAS(REQUESTTERMINALSERIALNBR)

Request terminal serial number

A RQDT            Z         ALIAS(REQUESTDATE)

Request date

A RQUSER        30A         VARLEN
A                           ALIAS(REQUESTUSER)

Request user

A ACTION        20A         VARLEN

Action description

A CYBEXID       20A         VARLEN
A                           ALIAS(CYBERSOURCEEXCEPTIONID)

CyberSource exception ID

A CLIENTID      60A         VARLEN

Client ID

A PRCRSPCD      12A         VARLEN
A                           ALIAS(PROCESSORRESPONSECODE)

Processor response code

A DCCEXCHGRT    27A         VARLEN
A                           ALIAS(DCCEXCHANGERATE)

DCC exchange rate

A DCCLKUPSTS   255A         VARLEN
A                           ALIAS(DCCLOOKUPSTATUS)

DCC lookup status

A DCCMRGNRT     27A         VARLEN
A                           ALIAS(DCCMARGINRATE)

DCC margin rate

A EXAMT         20A         VARLEN
A                           ALIAS(EXCEPTIONAMOUNT)

Exception amount

A EXAMTCUR     255A         VARLEN
A                           ALIAS(EXCEPTIONAMTCURRENCY)

Exception amount currency

A EXCAT         20A         VARLEN
A                           ALIAS(EXCEPTIONCATEGORY)

Exception category

A EXPDT         20A         ALIAS(EXCEPTIONDATE)

Exception date

A EXDESC       255A         VARLEN
A                           ALIAS(EXCEPTIONDESCRIPTION)

Exception description

A EXDEVHW       60A         VARLEN
A                           ALIAS(EXCEPTIONDEVICEHARDWARE)

Exception device hardware revision

A EXDEVID     1024A         VARLEN
A                           ALIAS(EXCEPTIONDEVICEID)

Exception device ID

A EXDEVOS       60A         VARLEN
A                           ALIAS(EXCEPTIONDEVICEOS)

Exception device OS

A EXDEVOSVER    30A         VARLEN
A                           ALIAS(EXCEPTIONDEVICEOSVER)

Exception device OS version

A EXDEVTRID     60A         VARLEN
A                           ALIAS(EXCEPTIONDEVICETERMID)

Exception device terminal ID

A EXMSG        255A         VARLEN
A                           ALIAS(EXCEPTIONMESSAGE)

Exception message

A EXRSNCD       60A         VARLEN
A                           ALIAS(EXCEPTIONREASONCODE)

Exception reason code

A EXRSNDSC     255A         VARLEN
A                           ALIAS(EXCEPTIONREASONDESC)

Exception reason description

A EXSTS         30A         VARLEN
A                           ALIAS(EXCEPTIONSTATUS)

Exception status

A EXSTSCD       50A         VARLEN
A                           ALIAS(EXCEPTIONSTATUSCODE)

Exception status code

A EXTYP         30A         VARLEN
A                           ALIAS(EXCEPTIONTYPE)

Exception type

A FINSTS        10A         VARLEN
A                           ALIAS(FINANCIALSTATUS)

Financial status

A LASTACTDT       L         ALIAS(LASTACTIONDATE)

Last action date

A LOCALCURCD     3A         VARLEN
A                           ALIAS(LOCALCURRENCYCODE)

Local currency code

A NEXTACTDT       L         ALIAS(NEXTACTIONDATE)

Next action date

A ORGTRSUBDT      L         ALIAS(ORIGINALTRANSUBDATE)

Original transaction submission date

A PTRMCHID       3A         VARLEN
A                           ALIAS(PARTNERMERCHANTID)

Partner merchant ID

A PTRMCHNAME   100A         VARLEN
A                           ALIAS(PARTNERMERCHANTNAME)

Partner merchant name

A PAYMENTNBR    50A         VARLEN
A                           ALIAS(PAYMENTNUMBER)

Payment number

A PRCCASEID     30A         VARLEN
A                           ALIAS(PROCESSORCASEID)

Processor-assigned case ID

A RETRIES       20A         VARLEN

Retries

A SDKVER        30A         VARLEN

SDK version

A SCHEMEOPER    60A         VARLEN
A                           ALIAS(SCHEMEOPERATOR)

Scheme operator

A STGMECH       60A         VARLEN
A                           ALIAS(STORAGEMECHANISM)

Storage mechanism

A BTADDR1      100A         VARLEN
A                           ALIAS(BILLTOADDRESS1)

Bill to address line 1

A BTADDR2      100A         VARLEN
A                           ALIAS(BILLTOADDRESS2)

Bill to address line 2

A BTCITY        50A         VARLEN
A                           ALIAS(BILLTOCITY)

Bill to city

A BTCMPNAME     60A         VARLEN
A                           ALIAS(BILLTOCOMPANYNAME)

Bill to company name

A BTCMPTAXID     9A         VARLEN
A                           ALIAS(BILLTOCOMPANYTAXID)

Bill to company tax ID

A BTCNTRY        2A         VARLEN
A                           ALIAS(BILLTOCOUNTRY)

Bill to country

A BTCSTID       30A         VARLEN
A                           ALIAS(BILLTOCUSTOMERID)

Bill to customer ID

A BTEMAIL      255A         VARLEN
A                           ALIAS(BILLTOEMAIL)

Bill to email

A BTFNAME       60A         VARLEN
A                           ALIAS(BILLTOFIRSTNAME)

Bill to customer first name

A BTHOSTNAME   255A         VARLEN
A                           ALIAS(BILLTOHOSTNAME)

Bill to hostname

A BTIPADDR      15A         VARLEN
A                           ALIAS(BILLTOIPADDRESS)

Bill to IP address

A BTLNAME       60A         VARLEN
A                           ALIAS(BILLTOLASTNAME)

Bill to customer last name

A BTMNAME       60A         VARLEN
A                           ALIAS(BILLTOMIDDLENAME)

Bill to customer middle name

A BTSUFFIX      60A         VARLEN
A                           ALIAS(BILLTONAMESUFFIX)

Bill to customer name suffix

A BTPRSNLID     40A         VARLEN
A                           ALIAS(BILLTOPERSONALID)

Bill to personal ID

A BTPHONE       20A         VARLEN
A                           ALIAS(BILLTOPHONE)

Bill to phone number

A BTSTATE       64A         VARLEN
A                           ALIAS(BILLTOSTATE)

Bill to state

A BTCSTITLE     30A         VARLEN
A                           ALIAS(BILLTOTITLE)

Bill to customer title

A BTUSRNAME     30A         VARLEN
A                           ALIAS(BILLTOUSERNAME)

Bill to customer user name

A BTZIP         10A         VARLEN
A                           ALIAS(BILLTOZIP)

Bill to ZIP

A STADDR1      100A         VARLEN
A                           ALIAS(SHIPTOADDRESS1)

Ship to address line 1

A STADDR2      100A         VARLEN
A                           ALIAS(SHIPTOADDRESS2)

Ship to address line 2

A STCITY        50A         VARLEN
A                           ALIAS(SHIPTOCITY)

Ship to city

A STCMPNAME     60A         VARLEN
A                           ALIAS(SHIPTOCOMPANYNAME)

Ship to company name

A STCNTRY       60A         VARLEN
A                           ALIAS(SHIPTOCOUNTRY)

Ship to country

A STFNAME       60A         VARLEN
A                           ALIAS(SHIPTOFIRSTNAME)

Ship to customer first name

A STLNAME       60A         VARLEN
A                           ALIAS(SHIPTOLASTNAME)

Ship to customer last name

A STPHONE       20A         VARLEN
A                           ALIAS(SHIPTOLASTNAME)

Ship to phone number

A STSTATE       25A         VARLEN
A                           ALIAS(SHIPTOSTATE)

Ship to state

A STZIP         10A         VARLEN
A                           ALIAS(SHIPTOZIP)

Ship to ZIP

A SHPCARRIER    12A         VARLEN
A                           ALIAS(SHIPPINGCARRIER)

Shipping carrier

A SHPMTH        10A         VARLEN
A                           ALIAS(SHIPPINGMETHOD)

Shipping method

A PMTYPDESC     50A         VARLEN
A                           ALIAS(PMTYPEDESCRIPTION)

Payment method type description

A PMOVRDMTH      4A         VARLEN
A                           ALIAS(PMOVERRIDEPAYMENTMETHOD)

Override payment method

A PMKACTSFX      4A         VARLEN
A                           ALIAS(CHECKACCOUNTSUFFIX)

Last 4 digits of check payment account number

A PMKCHKNBR     10A         VARLEN
A                           ALIAS(CHECKCHECKNUMBER)

Check number

A PMKMDTID      35A         VARLEN
A                           ALIAS(CHECKMANDATEID)

ID reference for direct debit mandate

A PMKMDTTYP     20A         VARLEN
A                           ALIAS(CHECKMANDATETYPE)

Mandate type

A PMKSIGDT        L         ALIAS(CHECKSIGNATUREDATE)

Date of signature

A PMKACTTYP      4A         VARLEN
A                           ALIAS(CHECKACCOUNTTYPE)

Check account type

A PMKACTENID     3A         VARLEN
A                           ALIAS(CHECKACCOUNTENCODERID)

Check account encoder ID

A PMKBNKTNBR     9A         VARLEN
A                           ALIAS(CHECKBANKTRANSITNUMBER)

Check bank transit number

A PMKEFFCDT       L         ALIAS(CHECKEFFECTIVEDATE)

Check effective date

A PMWALTTYP     20A         VARLEN
A                           ALIAS(WALLETTYPE)

Type of wallet

A PMCCRDTYP      5A         VARLEN
A                           ALIAS(CARDTYPE)

Type of card

A PMCEXPMOS      4A         VARLEN
A                           ALIAS(CARDEXPIRATIONMONTH)

Card expiration month

A PMCEXPYR       4A         VARLEN
A                           ALIAS(CARDEXPIRATIONYEAR)

Card expiration year

A PMCSTMOS       4A         VARLEN
A                           ALIAS(CARDSTARTMONTH)

Card start month

A PMCSTYR        4A         VARLEN
A                           ALIAS(CARDSTARTYEAR)

Card start year

A PMCISSNBR      5A         VARLEN
A                           ALIAS(CARDISSUENUMBER)

Maestro card issue number

A PMCACTSFX      4A         VARLEN
A                           ALIAS(CARDACCOUNTSUFFIX)

Payment account number last 4 digits

A PMCACRDTYP     5A         VARLEN
A                           ALIAS(CARDADDITIONALCARDTYPE)

Additional card type

A PMCPPDRLD      7A         VARLEN
A                           ALIAS(CARDPREPAIDRELOADABLE)

Card prepaid reloadable

A PMCPPDTYP     50A         VARLEN
A                           ALIAS(CARDPREPAIDTYPE)

Card prepaid type

A PMCVIRTUAL     5A         VARLEN
A                           ALIAS(CARDVIRTUAL)

Card virtual

A PMFCHKDGT      2A         VARLEN
A                           ALIAS(BANKCHECKDIGIT)

Bank check digit

A PMFIBANIND     1A         VARLEN
A                           ALIAS(IBANINDICATOR)

IBAN

A PMBADDR       50A         VARLEN
A                           ALIAS(BANKADDRESS)

Bank address

A PMBBCHCD      50A         VARLEN
A                           ALIAS(BANKBRANCHCODE)

Bank branch code

A PMBCITY       50A         VARLEN
A                           ALIAS(BANKCITY)

Bank city

A PMBCNTRY      50A         VARLEN
A                           ALIAS(BANKCOUNTRY)

Bank country

A PMBNAME       50A         VARLEN
A                           ALIAS(BANKNAME)

Bank name

A PMBSWIFTCD    50A         VARLEN
A                           ALIAS(BANKSWIFTCODE)

Bank SWIFT/BIC code

A PMTTKCD      255A         VARLEN
A                           ALIAS(TOKENCODE)

Transaction token code

A PMTNETTK       1A         VARLEN
A                           ALIAS(NETWORKTOKENTRANSTYPE)

Network token transaction type

A PMBBANKCD     15A         VARLEN
A                           ALIAS(BANKCODE)

Bank/sort code

A PMBACTNAME    90A         VARLEN
A                           ALIAS(BANKACCOUNTNAME)

Bank account name

A PMBBOLEBAR    50A         VARLEN
A                           ALIAS(BOLETOBARCODENUMBER)

Boleto barcode number

A PMBPMTTYP     50A         VARLEN
A                           ALIAS(PAYMENTMETHODTYPE)

Payment method type

A PMBBOLENBR    50A         VARLEN
A                           ALIAS(BOLETONUMBER)

Boleto Bancario payment number

A RDAPDAVS      50A         VARLEN
A                           ALIAS(APPLIEDAVS)

Applied AVS

A RDAPDCV        1A         VARLEN
A                           ALIAS(APPLIEDCV)

Appled CV

A RDAPDCATGF     1A         VARLEN
A                           ALIAS(APPLIEDCATEGORYGIFT)

Applied category gift

A RDAPDCATTM     6A         VARLEN
A                           ALIAS(APPLIEDCATEGORYTIME)

Applied category time

A RDAPDHSTH      6A         VARLEN
A                           ALIAS(APPLIEDHOSTHEDGE)

Applied host hedge

A RDAPDTHLD     10A         VARLEN
A                           ALIAS(APPLIEDTHRESHOLD)

Applied threshold

A RDAPDTMH       6A         VARLEN
A                           ALIAS(APPLIEDTIMEHEDGE)

Applied time hedge

A RDAPDVELH      6A         VARLEN
A                           ALIAS(APPLIEDVELOCITYHEDGE)

Applied velocity hedge

A RDBNACTTYP     2A         VARLEN
A                           ALIAS(BINACCOUNTTYPE)

BIN account type

A RDBNCNTRY      2A         VARLEN
A                           ALIAS(BINCOUNTRY)

BIN country

A RDBNISSUER   128A         VARLEN
A                           ALIAS(BINISSUER)

BIN issuer

A RDBNSCHEME    64A         VARLEN
A                           ALIAS(BINSCHEME)

BIN scheme

A RDCNSLTY       1A         VARLEN
A                           ALIAS(CONSUMERLOYALTY)

Consumer loyalty

A RDCNSPASS      1A         VARLEN
A                           ALIAS(CONSUMERPASSWORDPROVIDED)

Consumer password provided

A RDCNSPROMO     1A         VARLEN
A                           ALIAS(CONSUMERPROMOTIONS)

Consumer promotions

A RDCKSACP       1A         VARLEN
A                           ALIAS(COOKIESACCEPTED)

Cookies accepted

A RDCKSEN        1A         VARLEN
A                           ALIAS(COOKIESENABLED)

Cookies enabled

A RDDVCFPRT     80A         VARLEN
A                           ALIAS(DEVICEFINGERPRINT)

Device fingerprint

A RDFACTORS    100A         VARLEN
A                           ALIAS(FACTORS)

Factors

A RDFLASHEN      1A         VARLEN
A                           ALIAS(FLASHENABLED)

Flash enabled

A RDGFWRAP       1A         VARLEN
A                           ALIAS(GIFTWRAP)

Giftwrap

A RDHOSTSEV     10A         VARLEN
A                           ALIAS(HOSTSEVERITY)

Host severity

A RDIPCITY      50A         VARLEN
A                           ALIAS(IPCITY)

IP city

A RDIPCNTRY     60A         VARLEN
A                           ALIAS(IPCOUNTRY)

IP country

A RDIPRTMTH     30A         VARLEN
A                           ALIAS(IPROUTINGMETHOD)

IP routing method

A RDIPSTATE     20A         VARLEN
A                           ALIAS(IPSTATE)

IP state

A RDIMGEN        1A         VARLEN
A                           ALIAS(IMAGESENABLED)

Images enabled

A RDJSEN         1A         VARLEN
A                           ALIAS(JAVASCRIPTENABLED)

JavaScript enabled

A RDLOSTPASS     1A         VARLEN
A                           ALIAS(LOSTPASSWORD)

Lost password

A RDPRDRISK      6A         VARLEN
A                           ALIAS(PRODUCTRISK)

Product risk

A RDPADDR       64A         VARLEN
A                           ALIAS(PROXYIPADDRESS)

Proxy IP address

A RDPADDRACT   255A         VARLEN
A                           ALIAS(PROXYIPADDRESSACTIVITIES)

Proxy IP address activities

A RDPADDRATT   255A         VARLEN
A                           ALIAS(PROXYIPADDRESSATTRIBUTES)

Proxy IP address attributes

A RDPSRVTYP     12A         VARLEN
A                           ALIAS(PROXYSERVERTYPE)

Proxy server type

A RDRPTCST       1A         VARLEN
A                           ALIAS(REPEATCUSTOMER)

Repeat customer

A RDRTNACPT      5A         VARLEN
A                           ALIAS(RETURNSACCEPTED)

Returns accepted

A RDSCORE       50A         VARLEN
A                           ALIAS(RISKSCORE)

Risk score

A RDLOCALTM       Z         ALIAS(RISKTIMELOCAL)

Risk time local

A RDTIPADDR     64A         VARLEN
A                           ALIAS(TRUEIPADDRESS)

True IP address

A RDTIPATTR    255A         VARLEN
A                           ALIAS(TRUEIPADDRESSATTRIBUTES)

True IP address attributes

A RDTIPCITY     50A         VARLEN
A                           ALIAS(TRUEIPADDRESSCITY)

True IP address city

A RDTIPCNTRY     2A         VARLEN
A                           ALIAS(TRUEIPADDRESSCOUNTRY)

True IP address country

A RDTIPACT     255A         VARLEN
A                           ALIAS(TRUEIPADDRESSACTIVITIES)

True IP address activities

A DEVICEID      32A         VARLEN

Device ID

A GIFTCURBAL    12A         VARLEN
A                           ALIAS(GIFTCARDCURRENTBALANCE)

Gift card current balance

A GIFTPRVBAL    12A         VARLEN
A                           ALIAS(GITFCARDPREVIOUSBALANCE)

Gift card previous balance

A IHICUSTDTA    32A         VARLEN
A                           ALIAS(CUSTOMDATA_1)

Custom data 1

AR CTIEDRAPRR

Record

CyberSource Exception Detail Report Application Reply Record

A PID           15P 0

Key

Parent Report Unique ID

A REQUESTID     30A         VARLEN

Key

CyberSource request unique ID

A UID           15P 0

Key

Application reply unique ID

A APRNAME       30A         VARLEN
A                           ALIAS(APPLICATIONREPLYNAME)

Application name

A APRCD         15A         VARLEN
A                           ALIAS(RCODE)

Application reply RCODE

A APRSNCD        5A         VARLEN
A                           ALIAS(REASONCODE)

Application reply reason code

A APRFLAG       50A         VARLEN
A                           ALIAS(RFLAG)

Application reply RFLAG

A APRMSG       255A         VARLEN
A                           ALIAS(RMSG)

Application reply message

AR CTIEDRINFR

Record

CyberSource Exception Detail Report Info Code Record

A PID           15P 0

Key

Parent Report Unique ID

A REQUESTID     30A         VARLEN

Key

CyberSource request unique ID

A UID           15P 0

Key

Info code unique ID

A INFOCDTYP     20A         VARLEN
A                           ALIAS(INFOCODETYPE)

Info code type

A INFOCDVAL    255A         VARLEN
A                           ALIAS(INFOCODEVALUE)

Info code value

AR CTIEDRLINR

Record

CyberSource Exception Detail Report Line Item Record

A PID           15P 0

Key

Parent Report Unique ID

A REQUESTID     30A         VARLEN

Key

CyberSource request unique ID

A UID           15P 0

Key

Line item unique ID

A LINBR         40A         VARLEN
A                           ALIAS(LINEITEMNUMBER)

Line item number

A LIFFLTYP       2A         VARLEN
A                           ALIAS(FULLFILLMENTTYPE)

Line item fullfillment type

A LIINVNBR      30A         VARLEN
A                           ALIAS(INVOICENUMBER)

Line item invoice number

A LIPRODSKU    255A         VARLEN
A                           ALIAS(MERCHANTPRODUCTSKU)

Line item merchant product SKU

A LIPRODCD     255A         VARLEN
A                           ALIAS(PRODUCTCODE)

Line item product code

A LIPRODNAME   255A         VARLEN
A                           ALIAS(PRODUCTNAME)

Line item product name

A LIITMQTY      15A         VARLEN
A                           ALIAS(QUANTITY)

Line item quantity

A LITAXAMT      20A         VARLEN
A                           ALIAS(TAXAMOUNT)

Line item tax amount

A LIUNITPRC     20A         VARLEN
A                           ALIAS(UNITPRICE)

Line item unit price

AR CTIEDRMDDR

Record

CyberSource Exception Detail Report Merchant-Defined Data Record

A PID           15P 0

Key

Parent Report Unique ID

A REQUESTID     30A         VARLEN

Key

CyberSource request unique ID

A MDDFLD1     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD1)

Merchant-defined data 1

A MDDFLD2     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD2)

Merchant-defined data 2

A MDDFLD3     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD3)

Merchant-defined data 3

A MDDFLD4     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD4)

Merchant-defined data 4

A MDDFLD5     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD5)

Merchant-defined data 5

A MDDFLD6     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD6)

Merchant-defined data 6

A MDDFLD7     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD7)

Merchant-defined data 7

A MDDFLD8     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD8)

Merchant-defined data 8

A MDDFLD9     1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD9)

Merchant-defined data 9

A MDDFLD10    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD10)

Merchant-defined data 10

A MDDFLD11    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD11)

Merchant-defined data 11

A MDDFLD12    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD12)

Merchant-defined data 12

A MDDFLD13    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD13)

Merchant-defined data 13

A MDDFLD14    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD14)

Merchant-defined data 14

A MDDFLD15    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD15)

Merchant-defined data 15

A MDDFLD16    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD16)

Merchant-defined data 16

A MDDFLD17    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD17)

Merchant-defined data 17

A MDDFLD18    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD18)

Merchant-defined data 18

A MDDFLD19    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD19)

Merchant-defined data 19

A MDDFLD20    1175A         VARLEN
A                           ALIAS(MERCHANTDEFINEDDATAFIELD20)

Merchant-defined data 20

AR CTIEDRPMTR

Record

CyberSource Exception Detail Report Payment Info Record

A PID           15P 0

Key

Parent Report Unique ID

A REQUESTID     30A         VARLEN

Key

CyberSource request unique ID

A UID           15P 0

Key

Payment info unique ID

A AVSRESULT     10A         VARLEN

AVS result

A AVSRSLTMAP     5A         VARLEN
A                           ALIAS(AVSRESULTMAPPED)

AVS result mapped

A AQRMCHNBR     15A         VARLEN
A                           ALIAS(ACQUIRERMERCHANTNUMBER)

Acquirer merchant number

A AMT           20A         VARLEN

Grand total amount

A ATHFCTCD     100A         VARLEN
A                           ALIAS(AUTHFACTORCODE)

Auth factor code

A ATHIND         1A         VARLEN
A                           ALIAS(AUTHINDICATOR)

Auth indicator

A ATHREVAMT     15A         VARLEN
A                           ALIAS(AUTHREVERSALAMOUNT)

Auth reversal amount

A ATHREVRSLT    50A         VARLEN
A                           ALIAS(AUTHREVERSALRESULT)

Auth reversal result

A ATHCD         15A         VARLEN
A                           ALIAS(AUTHORIZATIONCODE)

Authorization code

A ATHTYP         1A         VARLEN
A                           ALIAS(AUTHORIZATIONTYPE)

Authorization type

A BATCHFLID     50A         VARLEN
A                           ALIAS(BATCHFILESID)

Batch files ID

A CVRESULT       1A         VARLEN

VCN result code

A CARDCAT       10A         VARLEN
A                           ALIAS(CARDCATEGORY)

Card category

A CARDCATCD     10A         VARLEN
A                           ALIAS(CARDCATEGORYCODE)

Card category code

A CARDPRSNT      1A         VARLEN
A                           ALIAS(CARDPRESENT)

Card present

A CARDVRFMTH    50A         VARLEN
A                           ALIAS(CARDVERIFICATIONMETHOD)

Card verification method

A CUSTOMERID    30A         VARLEN

Customer ID

A DCCIND         1A         VARLEN
A                           ALIAS(DCCINDICATOR)

DCC indicator

A EMVREQFLBK     5A         VARLEN
A                           ALIAS(EMVREQUESTFALLBACK)

EMV request fallback

A EXCHGRT       27A         VARLEN
A                           ALIAS(EXCHANGERATE)

Exchange rate

A EXCHGRTDT       Z         ALIAS(EXCHANGERATEDATE)

Exchange rate date

A ISSRSPCD      15A         VARLEN
A                           ALIAS(ISSUERRESPONSECODE)

Issuer response code

A MDREFNBR      35A         VARLEN
A                           ALIAS(MANDATEREFERENCENUMBER)

Mandated reference number

A NETCD          4A         VARLEN
A                           ALIAS(NETWORKCODE)

Network code

A NETTRANSID    20A         VARLEN
A                           ALIAS(NETWORKTRANSACTIONID)

Network transaction ID

A ORIGAMT       15A         VARLEN
A                           ALIAS(ORIGINALAMOUNT)

Original amount

A ORIGCURR       5A         VARLEN
A                           ALIAS(ORIGINALCURRENCY)

Original currency

A POSCATLVL      1A         ALIAS(POSCATLEVEL)

POS CAT level

A POSENTMODE    11A         VARLEN
A                           ALIAS(POSENTRYMODE)

POST entry mode

A POSENV         1A         VARLEN
A                           ALIAS(POSENVIRONMENT)

POS environment

A PAYPROC       40A         VARLEN
A                           ALIAS(PAYMENTPROCESSOR)

Payment processor

A PAYREQID      30A         ALIAS(PAYMENTREQUESTID)

Payment request ID

A PINTYP         1A         ALIAS(PINTYPE)

PIN type

A PROCMID       20A         VARLEN
A                           ALIAS(PROCESSORMID)

Processor MID

A PROCRSPCD     60A         VARLEN
A                           ALIAS(PROCESSORRESPONSECODE)

Processor response code

A PROCRSPID     50A         VARLEN
A                           ALIAS(PROCESSORRESPONSEID)

Processor response ID

A PROCTID       60A         VARLEN
A                           ALIAS(PROCESSORTID)

Processor TID

A PROCTRANID    50A         VARLEN
A                           ALIAS(PROCESSORTRANSACTIONID)

Processor transaction ID

A RTNETWKTYP     1A         VARLEN

Token network type

A SOLNTYP       12A         VARLEN
A                           ALIAS(SOLUTIONTYPE)

Solution type

A STORFWDIND     5A         VARLEN
A                           ALIAS(STOREANDFORWARDINDICATOR)

Store and forward indicator

A SMCHCITY      50A         VARLEN
A                           ALIAS(SUBMERCHANTCITY)

Sub-merchant city

A SMCHCNTRY      2A         VARLEN
A                           ALIAS(SUBMERCHANTSCOUNTRY)

Sub-merchant country

A SMCHEMAIL    255A         VARLEN
A                           ALIAS(SUBMERCHANTEMAIL)

Sub-merchant email

A SMCHID        30A         VARLEN
A                           ALIAS(SUBMERCHANTID)

Sub-merchant ID

A SMCHNAME      40A         VARLEN
A                           ALIAS(SUBMERCHANTNAME)

Sub-merchant name

A SMCHPHONE     20A         VARLEN
A                           ALIAS(SUBMERCHANTPHONE)

Sub-merchant phone

A SMCHPOSTCD    10A         VARLEN
A                           ALIAS(SUBMERCHANTPOSTALCODE)

Sub-merchant postal code

A SMCHSTATE     64A         VARLEN
A                           ALIAS(SUBMERCHANTSTATE)

Sub-merchant state

A SMCHSTREET   100A         VARLEN
A                           ALIAS(SUBMERCHANTSTREET)

Sub-merchant street

A TGTAMT        20A         ALIAS(TARGETAMOUNT)

Target amount

A TGTCURR        3A         VARLEN
A                           ALIAS(TARGETCURRENCY)

Target currency

A TERMALTID      8A         VARLEN
A                           ALIAS(TERMINALIDALTERNATE)

Terminal ID alternate

A TOTTAXAMT     20A         ALIAS(TOTALTAXAMOUNT)

Total tax amount

A TRNREFNBR     60A         VARLEN
A                           ALIAS(TRANSACTIONREFERENCENUMBER)

Transaction reference number

A ECOMIND        1A         VARLEN
A                           ALIAS(ECOMMERCEINDICATOR)

E-commerce indicator

A RECPADDR     100A         VARLEN
A                           ALIAS(RECIPIENTADDRESS)

Recipient address

A RECPCITY      50A         VARLEN
A                           ALIAS(RECIPIENTCITY)

Recipient city

A RECPCNTRY      2A         VARLEN
A                           ALIAS(RECIPIENTCOUNTRY)

Recipient country

A RECPDOB        8A         VARLEN
A                           ALIAS(RECIPIENTDOB)

Recipient date of birth

A RECPFNAME     60A         VARLEN
A                           ALIAS(RECIPIENTFIRSTNAME)

Recipient first name

A RECPLNAME     60A         VARLEN
A                           ALIAS(RECIPIENTLASTNAME)

Recipient last name

A RECPMINIT     60A         VARLEN
A                           ALIAS(RECIPIENTMIDDLEINITIAL)

Recipient middle initial

A RECPPHONE     20A         VARLEN
A                           ALIAS(RECIPIENTPHONENUMBER)

Recipient phone

A RECPPOSTCD    10A         VARLEN
A                           ALIAS(RECIPIENTPOSTALCODE)

Recipient postal code

A RECPBAMT      20A         ALIAS(RECIPIENTBILLINGAMOUNT)

Recipient billing amount

A RECPBCURR      3A         VARLEN
A                           ALIAS(RECIPIENTBILLINGCURRENCY)

Recipient billing curency

A RECPSTATE     25A         VARLEN
A                           ALIAS(RECIPIENTSTATE)

Recipient state

A SENDADDR     100A         VARLEN
A                           ALIAS(SENDERADDRESS)

Sender address

A SENDCITY      50A         VARLEN
A                           ALIAS(SENDERCITY)

Sender city

A SENDCNTRY      2A         VARLEN
A                           ALIAS(SENDERCOUNTRY)

Sender country

A SENDDOB        8A         VARLEN
A                           ALIAS(SENDERDOB)

Sender date of birth

A SENDFNAME     60A         VARLEN
A                           ALIAS(SENDERFIRSTNAME)

Sender first name

A SENDLNAME     60A         VARLEN
A                           ALIAS(SENDERLASTNAME)

Sender last name

A SENDMINIT     60A         VARLEN
A                           ALIAS(SENDERMIDDLEINITIAL)

Sender middle initial

A SENDPHONE     20A         VARLEN
A                           ALIAS(SENDERPHONENUMBER)

Sender phone

A SENDPOSTCD    10A         VARLEN
A                           ALIAS(SENDERPOSTALCODE)

Sender postal code

A SENDREFNBR    16A         VARLEN
A                           ALIAS(SENDERREFERENCENUMBER)

Sender reference number

A SENDSRCFND     2A         VARLEN
A                           ALIAS(SENDERSOURCEOFFUNDS)

Sender source of funds

A SENDSTATE     25A         VARLEN
A                           ALIAS(SENDERSTATE)

Sender state

A ATHAAVCAVV     3A         VARLEN
A                           ALIAS(AAV_CAVV)

AAV CAVV

A ATHECI         5A

Payer authentication e-commerce information

A ATHXID        40A         VARLEN

Payer authentication transaction ID

A ACHVFRSLT      2A         VARLEN
A                           ALIAS(ACHVERIFICATIONRAW)

Raw ACH verification result

A ACHVFRSLTM     2A         VARLEN
A                           ALIAS(ACHVERIFICATIONMAPPED)

Mapped ACH verification result

A CURRCD         3A         VARLEN
A                           ALIAS(CURRENCYCODE)

Currency code

A NBRINSTLMT     3A         VARLEN
A                           ALIAS(NBRINSTALLMENTS)

Number of installments

A PRODCD       255A         VARLEN
A                           ALIAS(PRODUCTCODE)

Product code

A GRANDTOT      20A         VARLEN

Grand total

A BALAMT        20A         VARLEN
A                           ALIAS(BALANCEAMOUNT)

Balance amount

A BALCURRCD      3A         VARLEN
A                           ALIAS(BALANCECURRCODE)

Balance currency code

A REQAMT        20A         VARLEN
A                           ALIAS(REQUESTEDAMOUNT)

Requested amount

A REQAMTCURR     3A         VARLEN
A                           ALIAS(REQUESTEDAMTCURRENCY)

Requested amount currency

A BINNBR         6A         VARLEN

BIN number

A EVFEMAIL       5A         VARLEN
A                           ALIAS(EVERIFICATIONEMAIL)

Electronic email verification result

A EVFEMAILR     10A         VARLEN
A                           ALIAS(EVERIFICATIONEMAILRAW)

Raw electronic email verification result

A EVFNAME        5A         VARLEN
A                           ALIAS(EVERIFICATIONNAME)

Electronic name verification result

A EVFNAMER      10A         VARLEN
A                           ALIAS(EVERIFICATIONNAMERAW)

Raw electronic name verification result

A EVFPHONE       5A         VARLEN
A                           ALIAS(EVERIFICATIONPHONE)

Electronic phone verification result

A EVFPHONER     10A         VARLEN
A                           ALIAS(EVERIFICATIONPHONERAW)

Raw electronic phone verification result

A EVFPOSTCD      5A         VARLEN
A                           ALIAS(EVERIFICATIONPOSTCODE)

Electronic post code verification result

A EVFPOSTCDR    10A         VARLEN
A                           ALIAS(EVERIFICATIONPOSTCODERAW)

Raw electronic post code verification result

A EVFSTREET      5A         VARLEN
A                           ALIAS(EVERIFICATIONSTREET)

Electronic street verification result

A EVFSTREETR    10A         VARLEN
A                           ALIAS(EVERIFICATIONSTREETRAW)

Raw electronic street verification result

A DEBITIND      50A         VARLEN
A                           ALIAS(DEBITINDICATOR)

Debit indicator

A EMVSVCCD      50A         VARLEN
A                           ALIAS(EMVSERVICECODE)

EMV service code

A AFTIND        50A         VARLEN
A                           ALIAS(AFTINDICATOR)

AFT indicator

A CATAFFLT      25A         VARLEN
A                           ALIAS(CATEGORYAFFILIATE)

Category affiliate

A CATCAMPGN     25A         VARLEN
A                           ALIAS(CATEGORYCAMPAIGN)

Category campaign

A CATGROUP      25A         VARLEN
A                           ALIAS(CATEGORYGROUP)

Category group

A AVSRLTMODE    50A         VARLEN
A                           ALIAS(AVSRESULTMODE)

AVS result mode

A AVSRSP        50A         VARLEN
A                           ALIAS(AVSRESPONSE)

AVS response

AR CTIEDRPRFR

Record

CyberSource Exception Detail Report Profile and Rules Record

A PID           15P 0

Key

Parent Report Unique ID

A REQUESTID     30A         VARLEN

Key

CyberSource request unique ID

A UID           15P 0

Key

Profile unique ID

A PRFNAME       30A         VARLEN
A                           ALIAS(PROFILENAME)

Profile name

A PRFMODE        1A         VARLEN
A                           ALIAS(PROFILEMODE)

Profile activity mode

A PRFDCSN      255A         VARLEN
A                           ALIAS(PROFILEDECISION)

Profile decision

A RULENAME      30A         VARLEN

Profile rule name

A RULEDCSN     255A         VARLEN
A                           ALIAS(RULEDECISION)

Profile rule decision