# 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()](https://isupport.katointegrations.com/cti/cti_downloadreport.md), the report file will be found in the default download directory specified in your [CTICFGMCH](https://isupport.katointegrations.com/cti/configuration.md) 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

| Field | Description |
|---|---|
| `     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

### CTI_ErrorDS_t

| Field | Description |
|---|---|
| `     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

### CTIEDR

| 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 |  |
| `ACTION` | `ACTION` | `VARCHAR(20)` | Brief Description of Action |  |
| `CYBEXID` | `CYBERSOURCEEXCEPTIONID` | `VARCHAR(20)` | CyberSource Exception ID |  |
| `CLIENTID` | `CLIENTID` | `VARCHAR(60)` | Client ID |  |
| `PRCRSPCD` | `PROCESSORRESPONSECODE` | `VARCHAR(12)` | Processor Response Code |  |
| `DCCEXCHGRT` | `DCCEXCHANGERATE` | `VARCHAR(27)` | DCC Exchange Rate |  |
| `DCCLKUPSTS` | `DCCLOOKUPSTATUS` | `VARCHAR(255)` | DCC Lookup Status |  |
| `DCCMRGNRT` | `DCCMARGINRATE` | `VARCHAR(27)` | DCC Margin Rate |  |
| `EXAMT` | `EXCEPTIONAMOUNT` | `VARCHAR(20)` | Exception Amount |  |
| `EXAMTCUR` | `EXCEPTIONAMTCURRENCY` | `VARCHAR(255)` | Exception Amount Currency |  |
| `EXCAT` | `EXCEPTIONCATEGORY` | `VARCHAR(20)` | Exception Category |  |
| `EXPDT` | `EXCEPTIONDATE` | `CHAR(20)` | Exception Date |  |
| `EXDESC` | `EXCEPTIONDESCRIPTION` | `VARCHAR(255)` | Exception Description |  |
| `EXDEVHW` | `EXCEPTIONDEVICEHARDWARE` | `VARCHAR(60)` | Exception Device Hardware Revision |  |
| `EXDEVID` | `EXCEPTIONDEVICEID` | `VARCHAR(1024)` | Exception Device ID |  |
| `EXDEVOS` | `EXCEPTIONDEVICEOS` | `VARCHAR(60)` | Exception Device OS |  |
| `EXDEVOSVER` | `EXCEPTIONDEVICEOSVER` | `VARCHAR(30)` | Exception Device OS Version |  |
| `EXDEVTRID` | `EXCEPTIONDEVICETERMID` | `VARCHAR(60)` | Exception Device Terminal ID |  |
| `EXMSG` | `EXCEPTIONMESSAGE` | `VARCHAR(255)` | Exception Message |  |
| `EXRSNCD` | `EXCEPTIONREASONCODE` | `VARCHAR(60)` | Exception Reason Code |  |
| `EXRSNDSC` | `EXCEPTIONREASONDESC` | `VARCHAR(255)` | Exception Reason Description |  |
| `EXSTS` | `EXCEPTIONSTATUS` | `VARCHAR(30)` | Exception Status |  |
| `EXSTSCD` | `EXCEPTIONSTATUSCODE` | `VARCHAR(50)` | Exception Status Code |  |
| `EXTYP` | `EXCEPTIONTYPE` | `VARCHAR(30)` | Exception Type |  |
| `FINSTS` | `FINANCIALSTATUS` | `VARCHAR(10)` | Financial Status |  |
| `LASTACTDT` | `LASTACTIONDATE` | `DATE` | Last Action Date |  |
| `LOCALCURCD` | `LOCALCURRENCYCODE` | `VARCHAR(3)` | Local Currency Code |  |
| `NEXTACTDT` | `NEXTACTIONDATE` | `DATE` | Next Action Date |  |
| `ORGTRSUBDT` | `ORIGINALTRANSUBDATE` | `DATE` | Original Transaction Submission Date |  |
| `PTRMCHID` | `PARTNERMERCHANTID` | `VARCHAR(3)` | Partner Merchant ID |  |
| `PTRMCHNAME` | `PARTNERMERCHANTNAME` | `VARCHAR(100)` | Partner Merchant Name |  |
| `PAYMENTNBR` | `PAYMENTNUMBER` | `VARCHAR(50)` | Payment Number |  |
| `PRCCASEID` | `PROCESSORCASEID` | `VARCHAR(30)` | Processor-Assigned Case ID |  |
| `RETRIES` | `RETRIES` | `VARCHAR(20)` | Retries |  |
| `SDKVER` | `SDKVER` | `VARCHAR(30)` | SDK Version |  |
| `SCHEMEOPER` | `SCHEMEOPERATOR` | `VARCHAR(60)` | Scheme Operator |  |
| `STGMECH` | `STORAGEMECHANISM` | `VARCHAR(60)` | Storage Mechanism |  |
| `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 Customer's 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 Customer's 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)` | Bank's 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 Customer's Browser |  |
| `RDGFWRAP` | `GIFTWRAP` | `VARCHAR(1)` | Reserved for Future Use |  |
| `RDHOSTSEV` | `HOSTSEVERITY` | `VARCHAR(10)` | Risk Associated with Customer's Email Domain |  |
| `RDIPCITY` | `IPCITY` | `VARCHAR(50)` | Name of City Decoded from Customer's IP Address |  |
| `RDIPCNTRY` | `IPCOUNTRY` | `VARCHAR(60)` | Name of Country Decoded from Customer's IP Address |  |
| `RDIPRTMTH` | `IPROUTINGMETHOD` | `VARCHAR(30)` | Name of Routing Method Decoded from IP Address |  |
| `RDIPSTATE` | `IPSTATE` | `VARCHAR(20)` | Name of State Decoded from Customer's 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)` | Proxy's IP Address if Available |  |
| `RDPADDRACT` | `PROXYIPADDRESSACTIVITIES` | `VARCHAR(255)` | Actions Associated w/ Proxy's IP Address |  |
| `RDPADDRATT` | `PROXYIPADDRESSATTRIBUTES` | `VARCHAR(255)` | Characteristics Associated w/ Proxy's 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)` | Customer's 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 |  |
| `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 |  |


### CTIEDRAPR

| 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 <ics_flag> Value |  |


### CTIEDRINF

| 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 <CodeType> Element |  |


### CTIEDRLIN

| 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 |  |


### CTIEDRMDD

| 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)` |  |  |


### CTIEDRPMT

| 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 |  |


### CTIEDRPRF

| 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 |  |