# CyberSource Toolkit for i Documentation --- # System Requirements > Lists supported IBM i OS versions (7.3-7.6), the OpenSSL requirement via IBM Portable Utilities for i, and specific PTFs needed for TLS 1.2 support. ## Installed Feature and PTF Requirements - To perform the authentication required by CyberSource, CyberSource Toolkit for i relies on OpenSSL, part of the **IBM Portable Utilities for i** licensed program offering (LPO) 5733-SC1. - **IBM i 7.5**: You should have PTF **[SI84261](https://www.ibm.com/mysupport/s/fix-information/aDr3p000000gJIuCAM/fi0070689?language=en_US)** or a superseding PTF installed to ensure a modern version of OpenSSL is installed. - **IBM i 7.3/7.4**: You should have PTF **[SI84245](https://www.ibm.com/mysupport/s/fix-information/aDr3p000000gJVGCA2/fi0071003?language=en_US)** or a superseding PTF installed to ensure a modern version of OpenSSL is installed. ## Operating System Level Support CyberSource Toolkit for i can be installed on the following operating system versions: - IBM i OS 7.6 - IBM i OS 7.5 - IBM i OS 7.4 - IBM i OS 7.3 --- # Installing CyberSource Toolkit for i > Step-by-step installation guide covering save file creation, FTP transfer, library restoration, SSL certificate import, P12 certificate setup, and license activation. Before installing CyberSource Toolkit for i, you should confirm that your IBM i is able to support TLS 1.2 and CyberSource's required secure cipher suites. Please see the [security requirements page](https://isupport.katointegrations.com/cti/cs_security_requirements.md) for more information. 1. Unzip the downloaded file to `C:\temp` (or the directory of your choice). 2. Create the \*SAVF to upload to on your IBM i: `CRTSAVF FILE(QGPL/CTI) AUT(*ALL)` 3. FTP the file CTI.SAVF from your PC to the IBM i. Open a command prompt (Start -> Run -> enter 'cmd' and hit enter). Type the following into the command prompt, replacing the IP address with that of your IBM i. When prompted, enter your IBM i username and password. 1. `ftp 123.456.789.123` 2. `binary` 3. `lcd c:\temp` 4. `quote site namefmt 0` 5. `cd QGPL` 6. `put CTI.savf CTI.savf` 7. `quit` 4. Restore the library from the \*SAVF: `RSTLIB SAVLIB(CTI) DEV(*SAVF) RSTLIB(CTI) SAVF(QGPL/CTI)` 5. Add the library to your library list: `ADDLIBLE CTI` 6. Restore the IFS \*SAVF: `RST DEV('/qsys.lib/cti.lib/ifs.file') OBJ(('/ktprod/cti' *INCLUDE '/ktprod/cti')) CRTPRNDIR(*YES) PRNDIROWN(QSYS) ALWOBJDIF(*ALL)` 7. Apply your license key: `APYLIC LICKEY(<>) PRODUCT(CTI)` 8. Follow the below guide to import the required SSL certificates to your system: [Import SSL Certificates](https://isupport.katointegrations.com/cti/import_ssl_certificates.md) 9. Follow the below guide to create a Cybersource P12 certificate: [Create Cybersource P12 Certificate](https://isupport.katointegrations.com/cti/create_cs_p12_certificate.md) 10. Once you have created the P12 certificate and uploaded it to your IBM i's IFS, use the WRKCTICERT command to import it: [Work with Cybersource Certificates](https://isupport.katointegrations.com/cti/wrkcticert.md) --- # Upgrading CyberSource Toolkit for i > Procedures for upgrading to a new CyberSource Toolkit for i version, backing up configuration files and selectively restoring updated objects. **Note:** - `###` is the simple version number of the target/new version level (example: 390 for v3.9.0) For clarity, you may wish to copy these instructions to a text editor and then perform a scan and replace for the above values before beginning the upgrade. 1. Unzip the downloaded file to `C:\temp` (or the directory of your choice). 2. Create the \*SAVF to upload to on your IBM i: `CRTSAVF FILE(QGPL/CTI###) AUT(*ALL)` 3. FTP the file CTI.SAVF from your PC to the IBM i. Open a DOS prompt (Start -> Run -> enter 'cmd' and hit enter). Type the following into the DOS prompt, replacing the IP address with that of your IBM i. When prompted, enter your IBM i username and password. 1. `ftp 123.456.789.123` 2. `binary` 3. `lcd c:\temp` 4. `quote site namefmt 0` 5. `cd QGPL` 6. `put CTI.savf CTI###.savf` 7. `quit` 4. Perform a full backup of your CTI library. 5. Execute the following steps to rename your existing CTI configuration files: 1. **Rename** your current CTICFGMCH file (if you have one): `RNMOBJ OBJ(CTI/CTICFGMCH) OBJTYPE(*FILE) NEWOBJ(OLDCFGMCH)` 2. **Rename** your current CTICFGCER file (if you have one): `RNMOBJ OBJ(CTI/CTICFGCER) OBJTYPE(*FILE) NEWOBJ(OLDCFGCER)` 3. **Rename** your current CTICFGENV file: `RNMOBJ OBJ(CTI/CTICFGENV) OBJTYPE(*FILE) NEWOBJ(OLDCFGENV)` 4. **Rename** your current CTICFGRPT file: `RNMOBJ OBJ(CTI/CTICFGRPT) OBJTYPE(*FILE) NEWOBJ(OLDCFGRPT)` 6. Execute the following IBM i command to upgrade the CTI library (this is all one command): `RSTOBJ OBJ(*ALL) SAVLIB(CTI) MBROPT(*ALL) ALWOBJDIF(*FILELVL *OWNER) OMITOBJ((LICP) (CTIUNQ)) RSTLIB(CTI) DEV(*SAVF) SAVF(QGPL/CTI###)` After running the `RSTOBJ` command, use `DSPJOBLOG` and press F10 to view the results of the `RSTOBJ`. Make a note of any objects that failed to restore, and either delete or rename the corresponding objects from the CTI library. Once you have renamed or deleted any conflicting objects, run the `RSTOBJ` command again and confirm that there are no further errors. 7. Execute the following steps to copy the data from your existing CTI configuration files into the new version of the files: 1. Copy data from OLDCFGMCH to your new CTICFGMCH file (if you have both an OLDCFGMCH and new CTICFGMCH): `CPYF FROMFILE(CTI/OLDCFGMCH) TOFILE(CTI/CTICFGMCH) MBROPT(*UPDADD) FMTOPT(*MAP *DROP)` 2. Copy data from OLDCFGCER to your new CTICFGCER file (if you have both an OLDCFGCER and new CTICFGCER): `CPYF FROMFILE(CTI/OLDCFGCER) TOFILE(CTI/CTICFGCER) MBROPT(*UPDADD) FMTOPT(*MAP *DROP)` 3. Copy data from OLDCFGENV to your new CTICFGENV file: `CPYF FROMFILE(CTI/OLDCFGENV) TOFILE(CTI/CTICFGENV) MBROPT(*UPDADD) FMTOPT(*MAP *DROP)` 4. Copy data from OLDCFGRPT to your new CTICFGRPT file: `CPYF FROMFILE(CTI/OLDCFGRPT) TOFILE(CTI/CTICFGRPT) MBROPT(*UPDADD) FMTOPT(*MAP *DROP)` 8. Execute the following IBM i command to restore updates to necessary files in the IFS (this is all one command): `RST DEV('/QSYS.LIB/CTI.LIB/IFS.FILE') OBJ(('/ktprod/cti' *INCLUDE '/ktprod/cti')) CRTPRNDIR(*YES) PRNDIROWN(QSYS) ALWOBJDIF(*ALL)` 9. Once you have validated the upgrade and confirmed that you are not experiencing any issues, you should remove the old versions of the CTI configuration files: 1. **Delete** the old CTICFGMCH which was renamed to OLDCFGMCH (if you have one): `DLTF FILE(CTI/OLDCFGMCH)` 2. **Delete** the old CTICFGMCH which was renamed to OLDCFGCER (if you have one): `DLTF FILE(CTI/OLDCFGCER)` 3. **Delete** the old CTICFGENV which was renamed to OLDCFGENV: `DLTF FILE(CTI/OLDCFGENV)` 4. **Delete** the old CTICFGRPT which was renamed to OLDCFGRPT: `DLTF FILE(CTI/OLDCFGRPT)` --- # Uninstalling CyberSource Toolkit for i > Covers removing CyberSource Toolkit for i by deleting the CTI library and recursively removing the IFS directory. CyberSource Toolkit for i licenses may be transferred to a different IBM i, or a different partition. Part of this process will involve uninstalling the product from the original machine/partition. 1. Delete the CyberSource Toolkit for i install library: `DLTLIB CTI` 2. Run QShell command to recursively remove the CyberSource Toolkit for i IFS directory and everything in it: `QSH CMD('rm -Rf /ktprod/cti')` --- # License Transfer > Explains how to transfer a CyberSource Toolkit for i license from one IBM i system or partition to another. CyberSource Toolkit for i licenses may be transferred to a different IBM i, or a different partition. To do this, you will need to provide us with screenshots of the following information with the CTI library in your library list: - The currently installed version of CyberSource Toolkit for i: `DSPVER` - Machine info for each LPAR a license is being moved from: `DSPMCHINF` - Machine info for each LPAR a license is being moved to: `DSPMCHINF` If you don't currently have access to the system you're migrating to, please let us know and we can provide a temporary license until you can provide information for us to generate a permanent license key. Please email this information to isupport@katointegrations.com. --- # Importing SSL Certificates > Resolves SSL handshake errors by importing DigiCert root and intermediate CA certificates into the IBM i Digital Certificate Manager. When using CyberSource Toolkit for i, you might receive one of the following error messages depending on which version of CyberSource Toolkit for i you're using: - "Error performing SSL handshake. There is no error. RC(23) errno()." - "SSL peer certificate or SSH remote key was not OK" These error messages mean that you do not have the required certificate authorities installed on your IBM i to secure communication between your IBM i and CyberSource. This may occur during initial setup, or when CyberSource updates certificates on their server. Fortunately, this is easy to fix. **The necessary certificates can be downloaded as a zip file here: [CyberSource SSL Certificates](https://files.rpg-xml.com/cti/certs/2025-07-24.zip)** Unzip the certificates - you should have the following certificates: - 1_DigiCertGlobalRootG2.crt - 2_DigiCertEVRSACAG2.crt We have labeled each certificate file with a number indicating its installation order, with 1 being the root and further intermediate certificates being numbered sequentially. This process helps avoid confusion during installation. ## Accessing DCM To begin, verify that the *ADMIN HTTP server job is running with the following command: `WRKSBSJOB SBS(QHTTPSVR)` If you don't see *ADMIN in the list, please run the following command to start it: `STRTCPSVR SERVER(*HTTP) HTTPSVR(*ADMIN)` After you've ensured that the *ADMIN server is running, open a web browser, and go to http://_YourIBMIPAddress_:2006/dcm/ - you should see a login page as seen below: ![DCM Login](https://isupport.katointegrations.com/media/accessing_dcm_1.png "DCM Login") You will want to log in to DCM using a profile with elevated permissions. Open the \*SYSTEM certificate store by first clicking on the "Open Certificate Store" link under the Actions header, then select \*SYSTEM: ![\*SYSTEM Store](https://isupport.katointegrations.com/media/accessing_dcm_2.png "*SYSTEM Store") Enter your \*SYSTEM store password when prompted and click "open". ## Uploading the Certificates From the \*SYSTEM certificate store, click "Upload Certificate" in the left-hand navigation menu: ![Upload Certificate](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_1.png "Upload Certificate") Click the "Choose File" button to open a file browser: ![Choose File](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_2.png "Choose File") Use the file browser to navigate to the location where you saved the previously downloaded certificate files. Select **1_DigiCertGlobalRootG2.crt**: ![Certificate File Selected](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_3.png "Certificate File Selected") Press "Upload". Repeat for **2_DigiCertEVRSACAG2.crt**. Once you have uploaded the certificates, you should see them listed under the "Certificates" heading on this same page: ![Uploaded Certificates](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_4.png "Uploaded Certificates") ## Installing the Certificates In the left-hand navigation menu, select the \*SYSTEM store to return to the main page. Click the "Import" link at the top: ![Import Certificate](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_5.png "Import Certificate") Select the type "Certificate Authority" and then click "Browse Uploads": ![Browse Uploaded Certificates](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_6.png "Browse Uploaded Certificates") This will bring up a list of the certificates that were previously uploaded to the system. You should see all of the certificates that we just uploaded in the list: ![Uploaded Certificate List](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_7.png "Uploaded Certificate List") Select the **1_DigiCertGlobalRootG2.crt** certificate. Click the "Select" link above (or below) the certificate list. This will return you to the previous page and populate the Path field. ![Selecting the Root Certificate](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_8.png "Selecting the Root Certificate") Click "Continue" to install the selected certificate: ![Installing the Selected Certificate](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_9.png "Installing the Selected Certificate") On the next page, provide DCM with a recognizable label for the certificate. In our example, we have labeled the certificate "Cybersource Root". ![Labeling and Importing the Certificate](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/installing_ca_10.png "Labeling and Importing the Certificate") Click "Import". You will either get a message that the import was successful, or a message that a certificate with the same label or public key already exists in the certificate store. The latter message is not necessarily an error - it just means that this certificate authority was already installed in your DCM and does not need to be installed again. If you get a different error message, please reach out to our team at isupport@katointegrations.com. Repeat the import process for the **2_DigiCertEVRSACAG2.crt** certificate. It is important that the certificates are imported in order, as each subsequent certificate authority relies on the previously imported certificates for validation and verification. --- # CyberSource Security Requirements > Documents CyberSource mandatory TLS 1.2 and RC4 deprecation requirements, with IBM i system value configurations for OS versions 7.1 and 7.2+. CyberSource has announced dates for new mandatory security requirements: - End of **June 2017** - TLS 1.2 required for all connections - Middle of **May 2017** - disabling RC4 ciphers These are important changes to help align their platform with the current PCI requirements, as well as to disallow TLS ciphers which are considered very insecure. **Note:** so long as you are running a minimum of CyberSource Toolkit for i version **3.10** or higher, further product upgrades are not required to address these issues. ## TLS 1.2 TLS 1.2 is required for all connections to CyberSource's production environment as of the end of June 2017. ### IBM i 7.2+ TLS 1.2 is already available on these operating systems. You will need to ensure that the following system values are set appropriately: | System Value Name | Expected Value(s) | | ----------------- | ----------------- | | `QSSLCSLCTL` | `*OPSYS` | | `QSSLPCL` | `*TLSV1.2` | **Note:** if QSSLCSLCTL is set to `*USRDFN`, please email our support team at isupport@katointegrations.com. ### IBM i 7.1 TLS 1.2 is available with PTF [SI48659](https://www-01.ibm.com/support/docview.wss?uid=nas3SI48659). Once this PTF is installed, you will need to ensure that the following system values are set appropriately: | System Value Name | Expected Value(s) | | ----------------- | ----------------- | | `QSSLCSLCTL` | `*OPSYS` | | `QSSLPCL` | `*TLSV1.2` | **Note:** if QSSLCSLCTL is set to `*USRDFN`, please email our support team at isupport@katointegrations.com. ## RC4 Cipher End-of-Life CyberSource is deprecating the usage of the RC4 cipher suite as of mid-May 2017. ### IBM i 7.1+ You can view the TLS ciphers that are currently enabled on your system with the following command: `DSPSYSVAL SYSVAL(QSSLCSL)` Review the ciphers and see that these entries are listed: - `RSA_AES_128_CBC_SHA256` - `RSA_AES_256_CBC_SHA256` If these entries are in the list, your system should handle the disabling of RC4 in CyberSource's production environment. If you do not see these entries, please email our support team at isupport@katointegrations.com with screenshots of the list entries. --- # CyberSource Toolkit for i Changelog > Version history for CyberSource Toolkit for i, detailing changes per release including new transaction service support, authentication updates, and API enhancements. The current version of CyberSource Toolkit for i is **3.10.0**, and was released **July 24, 2025**. ## 3.10.0 - [New] Added support for Cybersource Tax Calculation service - new CTI_Run() API fields and files added: - CTIWSHDR - TAXRUN - taxService_run - TAXNEXUS - taxService_nexus - TAXNONEXUS - taxService_noNexus - TAXSLREG - taxService_sellerRegistration - MCHVATREG - invoiceHeader_merchantVATRegistrationNumber - TAXCMTIND - taxService_commitIndicator - TAXRFNIND - taxService_refundIndicator - CTIWSRSP - TRTOTCRTX - taxReply_totalCountryTaxAmount - TRRSNCD - taxReply_reasonCode - TRTOTSPCTX - taxReply_totalSpecialTaxAmount - TRTOTTBAMT - taxReply_totalTaxableAmount - TRTOTSTTX - taxReply_totalStateTaxAmount - TRTOTEXAMT - taxReply_totalExemptAmount - TRGTOTAMT - taxReply_grandTotalAmount - TRTOTCTYTX - taxReply_totalCityTaxAmount - TRTOTCNTYX - taxReply_totalCountyTaxAmount - TRTOTTXAMT - taxReply_totalTaxAmount - **New table:** CTIWSTRIT - contains item-level response data for Tax Calculation service - **New table:** CTIWSTRJD - contains jurisdiction-level response data for Tax Calculation service - [New] Added new T_TAXCALC example program demonstrating Tax Calculation service functionality ## 3.9.1 - Enhanced the WRKCTICERT command to fully support both 24x80 and 27x132 screen sizes. When using 27x132, more fields will be shown on the main screen - Enhanced the WRKCTICERT command to require a password before attempting to import a P12 certificate - Enhanced the WRKCTICERT command to no longer prompt for confirmation when editting a record when values have not been changed - Corrected issue where the WRKCTICERT command would always create new records with LOGALL set to *YES - Corrected issue where the WRKCTICERT command would become unable to modify records - Corrected issue where the WRKCTICERT command would fail to import a P12 certificate when the QCCSID system value is set to 65535 - Corrected issue where the WRKCTICERT command would fail to import a P12 certificate when the password contained certain characters ## 3.9.0 This release implements the P12 certificate authentication mechanism required by Cybersource when performing any payment operations starting August 13, 2025. You will need to [create a Cybersource P12 certificate](https://isupport.katointegrations.com/cti/create_cs_p12_certificate.md) and import it to continue authenticating with Cybersource after upgrading to this version. - To accomodate the new P12 authentication mechanism, the existing CTICFGMCH database file has been deprecated and a new file CTICFGCER has been added - The [WRKCTICERT Command](https://isupport.katointegrations.com/cti/wrkcticert.md) has been added to allow for P12 certificate configuration and management - [New] Added new field TMPDIR to configuration database file CTICFGENV. This field is used to identify a directory that CTI can use to store temporary files. The default value for this field is `/ktprod/cti/tmp`. Currently it is only used as part of using the WRKCTICERT command - Updated IFS.SAVF save file included in installation to create new temporary directory `/ktprod/cti/tmp` ## 3.8.1 - Incrementing internal CyberSource API version to 1.221 ## 3.8.0 - [New] Added support for Klarna AltPay - new CTI_Run() API fields added: - CTIWSHDR - BTDIST - billTo_district - BTLANG - billTo_language - STDIST - shipTo_district - STEML - shipTo_email - CTIWSAHDR - SSNRQID - apSessionsService_sessionsRequestID - SSNPFMODE - apSessionsService_paymentFlowMode - SSNFAILURL - apSessionsService_failureURL - SSNPMTMD - apSessionsService_paymentMethod_name - SSNTYPE - apSessionsService_sessionsType - ATHCNLURL - apAuthService_cancelURL - ATHFAILURL - apAuthService_failureURL - ATHSCSURL - apAuthService_successURL - ATHPAPRTK - apAuthService_preapprovalToken - CTIWSARSP - SSNPRCTK - apSessionsReply_processorToken - STSTRNID - apCheckStatusReply_transactionID - STSSTS - apCheckStatusReply_status - ATHMCHURL - apAuthReply_merchantURL - ATHSTS - apAuthReply_status - REVPRCRSP - apAuthReversalReply_processorResponse - REVSTS - apAuthReversalReply_status - CAPRSPCD - apCaptureReply_responseCode - CAPAMT - apCaptureReply_amount - CAPSTS - apCaptureReply_status - REFRSPCD - apRefundReply_responseCode - REFAMT - apRefundReply_amount - REFTRNID - apRefundReply_transactionID - REFSTS - apRefundReply_status - [New] Added new constants to CTICBB and CTICBFIXED make PayPal and Klarna AltPay operations easier to implement - Fixed issue preventing capturing apCaptureReply_reconciliationID from CyberSource response to store in field APCAPRECID - Changed line item numbering to begin at 0 instead of 1 to more closely align with CyberSource recommendations ## 3.7.0 - **The minimum supported operating system version is now IBM i 7.3** ### Card Processing - New CTI_Run() API fields added: - CTIWSRSP - PSPMTMD - paySubscriptionRetrieveReply_paymentMethod - CCPIIRICAT - ccAuthReply_paymentInsightsInformation_responseInsightsCategory - CCPIIRICCD - ccAuthReply_paymentInsightsInformation_responseInsightsCategoryCode ### Reporting - Corrected issue with CTI_DownloadReport() which could result in invalid authentication attempts ### Other Changes - [New] Added CTI_IsLicenseValid() subproc to assist with customer license management automation - Adjusted example programs that demonstrate using credit cards to include a dynamic expiration year for test purposes - Enhanced the DSPMCHINF command to now show the partition UUID in preparation for future licensing enhancements - Enhanced the APYLIC command to no longer interactively prompt for license key replacement when the APYLIC command is run as part of a batch job - Enhanced internal licensing code to reduce unnecessary LICP database file access and reduce necessity of using UPDPROD(*YES) in some situations ## 3.6.1 **Upgrading to this release will require recompilation of all programs that use CTI subprocedures.** - Increased lengths of all request and subscription ID fields to 48 to accomodate longer tokens used in some circumstances. - Enhanced performance for internal licensing code ## 3.6.0 - [New] Added support for CyberSource PayPal AltPay operations. This includes adding new database files CTIWSAHDR and CTIWSARSP. - [New] Added new example programs to demonstrate CyberSource PayPal AltPay Operations: - T_APATH - T_APBAG - T_APCAP - T_APCNL - T_APORD - T_APREF - T_APREV - T_APSAL - T_APSSN - T_APSTS - [New] Added new TIMEOUT field to CTICFGENV - this allows setting a configurable SSL Socket timeout value which has improved communication reliability in specific circumstances for some customers. Valid values are `*DEFAULT`, or a numeric value indicating the number of seconds a timeout should last. **When upgrading, you should first rename your existing CTICFGENV file, and then copy data into the new CTICFGENV file restored as part of the upgrade using CPYF with the FMTOPT(*MAP *DROP) option specified.** - [New] Added support for Credential-On-File (COF) transactions as well as Merchant-Initiated Transactions (MIT) to accomodate new mandates from Mastercard and Discover. Fields added: - CTIWSHDR - SSAUTH - SSAFST - SSAORGAMT - SSARSN - SSASTRCRD - SSATRNID - CTIWSRSP - PAYNETTNID - [New] Added support for the Purchase Authorization Return (PRA) mandate from Visa, Mastercard, and Discover. Fields added: - CTIWSRSP - CRDATHCD - CRDNTTNID - CRDPRCRSP - VDATHRVRSP - Modifed all existing example programs to better demonstrate unique ID usage and add output to job log. - Corrected issue where logging output would occasionally be written to the download directory. ## 3.5.2 - Corrected issue which prevented CTI_Run() from writing a record to CTIWSRSP when missingField or invalidField errors were returned. - Corrected issue where logfiles could contain data from multiple transactions with LOGALL set to `*NO`. ## 3.5.1 - Updated the pDownloadReportDS and pQueryTransactionDS data structure parameters used with CTI_DownloadReport() and CTI_QueryTransaction() to no longer be Const. - CTI_DownloadReport() and CTI_QueryTransaction() now update the Filepath data structure subfield to reflect the full IFS filepath the report was written to. - Updated the included CTICBFIXED copybook to reflect the reporting API changes that were made in 3.5.0 - Corrected issue which prevented the reporting APIs from generating error logs in some situations even with CTICFGMCH LOGALL set to `*YES`. - Corrected issue where some multi-byte characters were not being properly preserved in report files downloaded by CTI_DownloadReport(). - Updated report parsing behavior so that child record unique IDs are reset per request instead of per report based on customer feedback. ## 3.5.0 - This major release adds support for the new REST reporting APIs, which are replacing the legacy reporting servlets that were previously implemented in CTI. **Any programs that were using the reporting subprocedures will need to be rewritten to use the new APIs outlined below.** - **Removed** deprecated reporting servlet subprocedures: - CTI_RunPayBatchDetailReport() - CTI_RunPaySubmissionDetailReport() - CTI_RunSingleTransQuery() - CTI_RunTransExpDetailReport() - New report download subprocedures: - CTI_DownloadReport() - CTI_QueryTransaction() - New reporting parsing subprocedures: - CTI_ParseBatchDetailReport() - CTI_ParseExceptionDetailReport() - CTI_ParseTransactionQuery() - New command: - ADDRPTKEY - New reporting configuration file - CTICFGRPT - The following fields have been **removed** from CTICFGMCH: - RPTENV - RPTUSER - RPTPASS - The following fields **must be updated** in CTICFGENV: - TESTAPIURL: [https://apitest.cybersource.com/](https://apitest.cybersource.com/) - PRODAPIURL: [https://api.cybersource.com/](https://api.cybersource.com/) - The following legacy reporting physical files are no longer needed. **These files will not be automatically cleared or removed.** - CTIRPTREQ - CTIRPTAPR - CTIRPTCBD - CTIRPTFEI - CTIRPTICD - CTIRPTLIN - CTIRPTPAY - CTIRPTPRF - CTIRPTRUL ## 3.4.3 - [New] Added support for expanded merchant-defined data fields - **New table:** CTIWSMDD ## 3.4.2 - Increased size of Apple Pay encrypted data field, CTIWSHDR.EPDTA, to 8192 - Updated some example programs to better demonstrate using request IDs from prior transactions - Corrected issue preventing reporting APIs from correctly generating log files ## 3.4.1 - [New] Added support for Apple Pay transactions ## 3.4.0 - [New] Added support for PayPal operations: - payPalEcOrderSetupService - payPalAuthorizationService - payPalDoRefTransactionService - payPalRefundService - payPalCreateAgreementService - payPalAuthReversalService - payPalDoCaptureService - payPalUpdateAgreementService - [New] Added support for Visa Checkout authorization operations - Two fields were added to CTIWSHDR: - VCORDERID - PMTSOLN ## 3.30 - [New] Added support for e-check operations: - ecAuthenticateService - ecCreditService - ecDebitService - Starting with this release, example code and copybook are provided in free format. ## 3.22 - Incrementing internal CyberSource API version to 1.140 ## 3.21 - Fixed issue with duplicate fields being written in some requests. - Fixed parsing of new response fields. ## 3.20 - Fields added to CTIWSHDR to allow processing for multiple captures against a single authorization. - Additional paySubscriptionRetrieveReply fields added to CTIWSRSP. - [New] Added field to CTIWSRSP for level 3 eligibility. ## 3.10 - **Upgrading to this version will require recompiling.** - Additional fields added to CTIWSHDR to accomodate upcoming MasterCard capability to specify preauthorization types. - CTI_RunPayBatchDetailReport(), CTI_RunPaySubmissionDetailReport(), CTI_RunSingleTransQuery(), and CTI_RunTransExpDetailReport() have been added to reimplement the ability to pull reports from the legacy CyberSource system. These APIs may stop working at a future date due to CyberSource changes. ## 3.00 - **Upgrading to this version will require recompiling.** - CYBCFG configuration file has been replaced by CTICFGMCH for merchant-level configuration and CTICFGENV for environment-level configuration. - The reporting APIs have been deprecated and replaced with CTI_DownloadReport() and CTI_ProcessReport() to handle the CyberSource transition to the new reporting infrastructure. - Cyb_run() has been replaced with CTI_Run(). - CYBHDR, CYBITM, and CYBRSP have been replaced with CTIWSHDR, CTIWSITM, and CTIWSRSP respectively. - Cyb_nxtUnqId() has been replaced with CTI_NextUniqueID() - Log files will now always be generated when errors occur. - It is no longer possible to disable the obfuscation of credit card numbers and other sensitive information in log files. ## 2.10 - Resolved issues with log files not being properly generated in some scenarios. ## 2.00 - **Upgrading to this version will require recompiling.** - This name of this product is now CyberSource Toolkit for i. As a result of this name change, the default install library name is now **CTI**. - The service program KCYBSV is now CTISV. The message file KCYBMSGF is now CTIMSGF. - Other objects including the physical files, data area, and binding directory have **not** been renamed to minimize the impact of upgrading. - The default value for the CYBCFG configuration option LOG_DIR is now /ktprod/cti/logs. - The default value for the CYBCFG configuration option TRANS_DIR is now /ktprod/cti/trans. - The CYBCFG configuration option FULL_LOG is no longer present by default. To remove sensitive data obfuscation, the configuration option must be manually added to CYBCFG with a value of Y. **This is not recommended for production use as the unobfuscated data will include credit card numbers.** - A new copybook member named CTICP can be found in source physical file QRPGLECPY. This is interchangeable with KCYBCP to preserve backwards compatibility. For any new development, we recommend using the CTICP copybook as we cannot guarantee the old KCYBCP copybook will not be removed in a future release. ## 1.90 - **Upgrading to this version will require recompiling.** - Cyb_Error error data structure was changed to add new subfield `source`. This subfield attempts to provide information regarding where the source of a specific error is - whether it's internal to the product, an error returned from CyberSource, or a problem with your network. - To go along with the change to Cyb_Error to add subfield `source`, the following constants were added: - Cyb_ERROR_INTERNAL - Cyb_ERROR_TRANSMIT - Cyb_ERROR_REMOTE - Many new fields were added to CYBHDR and CYBITM to allow data to be passed for Level II and Level III processing. - Previously, a template file resided in the path outlined by CYBCFG configuration value TPL_PATH and was used internally to generate XML. This template file is no longer required - it can be safely removed, and the configuration value TPL_PATH can be deleted from CYBCFG. ## 1.83 - Fixed defect reported in 1.82 with Cyb_run() not transmitting data in all circumstances. - Updated example programs to properly remove CYBERR and bring them in line with current best practices for error handling. - Fixed defect reported in 1.82 with Cyb_run() not transmitting data in all circumstances. - Fixed defect with error codes not being properly reported in Cyb_Error data structure in all circumstances. ## 1.82 - Removed reliance on IFS template. ## 1.81 - Fixed issue with XML generation for businessRules elements. ## 1.80 - Fixes to logging: - FULL_LOG CYBCFG value implemented. If N (or by default), sensitive data is masked in log files. If Y, it will be visible. Note that leaving this option set to Y is not recommended on PRODUCTION as it is a PCI risk. - Misc issues resolved with file permissions being created. - Changes to CYBHDR and CYBRSP per customer requests to better accomodate PayPal processing and level 2 data. ## 1.71 - Fixed issue with CYBRSP not being populated in all circumstances. ## 1.70 - Minimum operating system supported is now v6.1 - Logging overhaul: - To enable logging, set `DEBUG` to **Y** in CYBCFG. - All log files are now stored in the IFS in the directory specified in CYBCFG's `LOG_DIR`. - Log files are uniquely identified by the transaction ID/PID passed into Cyb_run() or the reporting APIs. - If logging is left on while running Production/Live transactions, sensitive data will be hidden in the resulting log files. - DB2 files CYBERR and CYBLOG have been removed. - All APIs now return an indicator value which can be checked to determine if an error occurred during the transaction. *ON means that the API completed successfull, *OFF means it failed. - The error which caused an API to fail will be returned in the error data structure passed in as a parameter. - The `TRANS_DIR` value is only used for reporting APIs. - Cyb_log() is still included in the copybook for backwards-compatibility purposes, but it is not intended to be used and may be removed in a future release. - Many fields in the APIs were changed to `Const` from `Value` to reduce memory usage. - Additional examples added to EXAMPLE source physical file - T_ATHSWIPE and T_ATHKEYED. - DSPMCHINFD renamed to DSPLICD. ## 1.60 - Point-of-sale (POS) added - Fields have been added to CYBHDR and CYBRSP to support point-of-sale transactions. - A new data structure has been added, **Cyb_PosDS_t** to store POS data in memory. - An additional optional parameter has been added to Cyb_run() to accept a **Cyb_PosDS_t** - QRPGLESRC renamed to EXAMPLE - Licensing updated - Additional licensing library KTLIC eliminated. - Objects stored in KTLIC have been moved into main KCYB library. - APYKTILIC renamed APYLIC. - DSPKTILIC renamed DSPLIC. ## 1.50 - Subscriptions/tokenization added - Fields have been added to CYBHDR and CYBRSP to support subscriptions and tokenization. - Additional examples added to QRPGLESRC - T_SUBCRT, T_SUBUPD, T_SUBRTV, T_SUBDLT ## 1.00 - Initial RPG-only release --- # Replication Instructions > High-availability and DR guidance, specifying that the LICP file must be excluded from replication. When setting up replication for high-availability or disaster recovery systems, please exclude the following objects: - CTI/LICP *FILE --- # CTI_Run() > Executes CyberSource Simple Order API transactions (authorize, capture, void, credit, reversal) using CTIWSHDR and CTIWSITM input tables and returning results in CTIWSRSP. This subprocedure can be used to run many of the CyberSource Simple Order API transactions, including: - Authorization (ccAuthService) - Authorization Reversal (ccAuthReversalService) - Capture (ccCaptureService) - Credit (ccCreditService) - Void (voidService) Request fields are populated from data in the CTIWSHDR and CTIWSITM (line items) tables, and response data is stored in CTIWSRSP. Additionally, if providing data from a point-of-sale system, the optional data structure CTI_PosDS_t may be provided. If CyberSource PayPal AltPay operations are being performed, the CTIWSAHDR table can be used to populate the additional required information. AltPay response data will be stored in CTIWSARSP. If Tax Calculation is requested, the CTIWSTRIT table will be used to store response item-level data, and the CTIWSTRJD table will be used to store response jurisdiction-level data. 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 ```rpgle // Returns *OFF if an error occurs during processing, *ON otherwise. D CTI_Run PR N Extproc('CTI_Run') // Unique ID generated with CTI_NextUniqueID() // Required D pUniqueId Const Like(CTI_UniqueId_t) // Error data structure used to capture subprocedure and CyberSource errors // Required D pErrorDS LikeDS(CTI_ErrorDS_t) // Credit card number D pCardNumber 20A Const Options(*Trim:*Omit) D Varying // Credit card verification number/security code D pCardCvNumber 4A Const Options(*Trim:*Omit) D Varying // Merchant ID used to process the transaction // Required D pMerchantId Const Like(CTI_MerchantId_t) D Options(*Trim) // Optional additional data used when transaction occurs using point of // sale D pPointOfSaleDS... D Const LikeDS(CTI_PosDS_t) D Options(*Omit:*Nopass) ``` ## Data Structures ### CTI_PosDS_t ```rpgle D CTI_PosDS_t DS Qualified Template Inz // Indicates if this is a card-present or card-not-present transaction. D CardPresent 1A // The type of cardholder-activated terminal. See the CyberSource SO API // documentation for valid values. D CatLevel 1A D DeviceReaderData... D 512A D EncodingMethod... D 6A D EncryptionAlgorithm... D 4A // The method through which card data is retrieved. // Valid values: contact, contactless, msd D EntryMode 11A D PaymentData 2048A // MasterCard service code, included in track data. D ServiceCode 3A // Indicates the ability of the terminal to process different card entry // modes. See the CyberSource SO API documentation for valid values. D TerminalCapability... D 1A // Identifies the terminal at your retail location. D TerminalID 8A // Identifies an alternate terminal at your retail location. D TerminalIDAlternative... D 8A // Track 1 and track 2 card data from the card reader. D TrackData 119A ``` ### CTI_ErrorDS_t ```rpgle D CTI_ErrorDS_t DS Qualified Template Inz // Name of subprocedure returning error D Subproc 132A Varying // Message ID of error message D MessageId 7A // Error message text D Message 1024A Varying // Error message source D Source 10A // IFS filepath of generated log file D LogFile Like(CTI_FilePath_t) ``` ## Input Table Files ### CTIWSHDR | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `UID` | `UNIQUEID` | `DECIMAL(15:0)` | Request Unique ID | | | `CRTDT` | `TIMESTAMP` | `TIMESTAMP` | Request Timestamp | | | `MCHID` | `MERCHANTID` | `CHAR(30)` | Merchant ID | | | `MCHREFCD` | `MERCHANTREFERENCECODE` | `CHAR(50)` | merchantReferenceCode | | | `AVSCD` | `AVSCD` | `CHAR(3)` | afsService_avsCode | | | `CVCD` | `CVCD` | `CHAR(1)` | afsService_cvCode | | | `AFSRUN` | `AFSSERVICERUN` | `CHAR(5)` | afsServiceRun | | | `BTCMPNY` | `BILLTOCOMPANY` | `CHAR(60)` | billTo_company | | | `BTFNAM` | `BILLTOFIRSTNAME` | `CHAR(60)` | billTo_firstName | | | `BTLNAM` | `BILLTOLASTNAME` | `CHAR(60)` | billTo_lastName | | | `BTST1` | `BILLTOSTREET1` | `CHAR(60)` | billTo_street1 | | | `BTST2` | `BILLTOSTREET2` | `CHAR(60)` | billTo_street2 | | | `BTCTY` | `BILLTOCITY` | `CHAR(50)` | billTo_city | | | `BTSTT` | `BILLTOSTATE` | `CHAR(2)` | billTo_state | | | `BTPSTCD` | `BILLTOPOSTALCODE` | `CHAR(10)` | billTo_postalCode | | | `BTCNTRY` | `BILLTOCOUNTRY` | `CHAR(2)` | billTo_country | | | `BTEML` | `BILLTOEMAIL` | `CHAR(255)` | billTo_email | | | `BTBRWSCA` | `BILLTOBROWSERCOOKIESACCEPTED` | `CHAR(5)` | billTo_CookiesAccept | | | `BTBRWSTYP` | `BILLTOBROWSERTYPE` | `CHAR(40)` | billTo_BrowserType | | | `BTIPADR` | `BILLTOIPADDRESS` | `CHAR(15)` | billTo_ipAddress | | | `BTPHNNO` | `BILLTOPHONENUMBER` | `CHAR(15)` | billTo_phoneNumber | | | `STCMPNY` | `SHIPTOCOMPANY` | `CHAR(60)` | shipTo_company | | | `STFNAM` | `SHIPTOFIRSTNAME` | `CHAR(60)` | shipTo_firstName | | | `STLNAM` | `SHIPTOLASTNAME` | `CHAR(60)` | shipTo_lastName | | | `STST1` | `SHIPTOSTREET1` | `CHAR(60)` | shipTo_street1 | | | `STST2` | `SHIPTOSTREET2` | `CHAR(60)` | shipTo_street2 | | | `STCTY` | `SHIPTOCITY` | `CHAR(50)` | shipTo_city | | | `STSTT` | `SHIPTOSTATE` | `CHAR(20)` | shipTo_state | | | `STPSTCD` | `SHIPTOPOSTALCODE` | `CHAR(10)` | shipTo_postalCode | | | `STCNTRY` | `SHIPTOCOUNTRY` | `CHAR(60)` | shipTo_postalCode | | | `STPHNNO` | `SHIPTOPHONENUMBER` | `CHAR(15)` | shipTo_postalCode | | | `STSHPMTH` | `SHIPTOSHIPPINGMETHOD` | `CHAR(10)` | shipTo_shippingMethod | | | `CCEXPMM` | `CARDEXPIRATIONMONTH` | `CHAR(2)` | card_expirationMonth | | | `CCEXPYY` | `CARDEXPIRATIONYEAR` | `CHAR(4)` | card_expirationYear | | | `CCCRDTYP` | `CARDTYPE` | `CHAR(3)` | card_cardType | | | `CCCMCIND` | `AUTHSERVICECOMMERCEINDICATOR` | `CHAR(13)` | ccAuthService_commerceIndicator | | | `ATHRUN` | `AUTHSERVICECRUN` | `CHAR(5)` | ccAuthService_run | | | `ATHREVRUN` | `AUTHREVERSALSERVICERUN` | `CHAR(5)` | ccAuthReversalService_run | | | `DAVRUN` | `DAVSERVICERUN` | `CHAR(5)` | davService_run | | | `DCNMGREBL` | `DECISIONMANAGERENABLE` | `CHAR(5)` | decisionManager_enabled | | | `ISGFT` | `INVOICEHDRISGIFT` | `CHAR(5)` | invoiceHeader_isGift | | | `RTNACT` | `INVOICEHDRRETURNSACCEPTED` | `CHAR(5)` | invoiceHeader_returnsAccepted | | | `ATHREQID` | `CAPTURESERVICEAUTHREQUESTID` | `CHAR(48)` | ccCaptureService_authRequestID | | | `ATHTYP` | `CAPTURESERVICEAUTHTYPE` | `CHAR(6)` | ccCaptureService_authType | | | `CAPPCHLVL` | `CAPTURESERVICEPURCHASINGLEVEL` | `CHAR(1)` | ccCaptureService_purchasingLevel | | | `CRDPCHLVL` | `CREDITSERVICEPURCHASINGLEVEL` | `CHAR(1)` | ccCreditService_purchasingLevel | | | `CAPRUN` | `CAPTURESERVICERUN` | `CHAR(5)` | ccCaptureService_run | | | `ORDREQTK` | `ORDERREQUESTTOKEN` | `CHAR(256)` | orderRequestToken | | | `VBLATHCD` | `CAPTURESERVICEVERBALAUTHCODE` | `CHAR(6)` | ccCaptureService_verbalAuthCode | | | `MCHDSCR` | `INVOICEHDRMERCHANTDESC` | `CHAR(22)` | invoiceHeader_merchantDescriptor | | | `MCHDCNT` | `INVOICEHDRMERCHANTDESCCONTACT` | `CHAR(13)` | invoiceHeader_merchant-DescriptorContact | | | `USRPO` | `INVOICEHDRUSERPO` | `CHAR(25)` | invoiceHeader_userPO | | | `PTFGTAMT` | `PURCHASETOTALSFREIGHTAMT` | `CHAR(13)` | purchaseTotals_freightAmount | | | `PTCUR` | `PURCHASETOTALSCURRENCY` | `CHAR(5)` | purchaseTotals_currency | | | `PTGNDAMT` | `PURCHASETOTALSGRANDTOTALAMT` | `CHAR(15)` | purchaseTotals_grandTotalAmount | | | `PTTAXAMT` | `PURCHASETOTALSTAXAMT` | `CHAR(15)` | purchaseTotals_taxAmount | | | `SFPSTCD` | `SHIPFROMPOSTALCODE` | `CHAR(10)` | shipFrom_postalCode | | | `CRDREQID` | `CREDITSERVICECAPTUREREQUESTID` | `CHAR(48)` | ccCreditService_captureRequestID | | | `CRDCMCIND` | `CREDITSERVICECOMMERCEINDICATOR` | `CHAR(13)` | ccCreditService_commerceIndicator | | | `CRDRUN` | `CREDITSERVICERUN` | `CHAR(5)` | ccCreditService_run | | | `VDRUN` | `VOIDSERVICERUN` | `CHAR(5)` | ccVoidService_run | | | `VDREQID` | `VDREQID` | `CHAR(48)` | ccVoidService_voidRequestID | | | `AMEXTAA1` | `AMEXTAA1` | `CHAR(40)` | invoiceHeader_amexDataTAA1 | | | `AMEXTAA2` | `AMEXTAA2` | `CHAR(40)` | invoiceHeader_amexDataTAA2 | | | `PSCRTRUN` | `PAYSUBSCRIPTIONCREATESERVICERUN` | `CHAR(5)` | paySubscriptionCreateService_run | | | `PSCRTDAA` | `PSCRTDAA` | `CHAR(5)` | paySubscriptionCreateService_disableAutoAuth | | | `PSCRTRID` | `PSCRTRID` | `CHAR(48)` | paySubscriptionCreateService_paymentRequestID | | | `PSCRTRTKN` | `PSCRTRTKN` | `CHAR(256)` | paySubscriptionCreateService_paymentRequestToken | | | `PSDLTRUN` | `PAYSUBSCRIPTIONDELTESERVICERUN` | `CHAR(5)` | paySubscriptionDeleteService_run | | | `PSRTVRUN` | `PAYSUBSCRIPTIONRETRIEVESERVICERUN` | `CHAR(5)` | paySubscriptionRetrieveService_run | | | `PSUPDRUN` | `PAYSUBSCRIPTIONUPDATESERVICERUN` | `CHAR(5)` | paySubscriptionUpdateService_run | | | `RSIFREQ` | `RSIFREQ` | `CHAR(20)` | recurringSubscriptionInfo_frequency | | | `RSIAMT` | `RSIAMT` | `CHAR(15)` | recurringSubscriptionInfo_amount | | | `RSISUBID` | `RSISUBID` | `CHAR(48)` | recurringSubscriptionInfo_subscriptionID | | | `SUBTITLE` | `SUBTITLE` | `CHAR(60)` | subscription_title | | | `MSDFIELD1` | `MSDFIELD1` | `CHAR(100)` | merchantSecureData_field1 | | | `MSDFIELD2` | `MSDFIELD2` | `CHAR(100)` | merchantSecureData_field2 | | | `MSDFIELD3` | `MSDFIELD3` | `CHAR(100)` | merchantSecureData_field3 | | | `MSDFIELD4` | `MSDFIELD4` | `CHAR(183)` | merchantSecureData_field4 | | | `BRIGNAVS` | `BRIGNAVS` | `CHAR(5)` | businessRules_ignoreAVSResult | | | `BRIGNCV` | `BRIGNCV` | `CHAR(5)` | businessRules_ignoreCVResult | | | `INVHDRTAX` | `INVHDRTAX` | `CHAR(5)` | invoiceHeader_taxable | | | `SFCMPNY` | `SFCMPNY` | `CHAR(60)` | shipFrom_company | | | `SFFNAM` | `SFFNAM` | `CHAR(60)` | shipFrom_firstName | | | `SFLNAM` | `SFLNAM` | `CHAR(60)` | shipFrom_lastName | | | `SFST1` | `SFST1` | `CHAR(60)` | shipFrom_street1 | | | `SFST2` | `SFST2` | `CHAR(60)` | shipFrom_street2 | | | `SFCTY` | `SFCTY` | `CHAR(50)` | shipFrom_city | | | `SFSTT` | `SFSTT` | `CHAR(20)` | shipFrom_state | | | `SFCNTRY` | `SFCNTRY` | `CHAR(60)` | shipFrom_country | | | `SFPHNNO` | `SFPHNNO` | `CHAR(15)` | shipFrom_phoneNumber | | | `CRDAUTTKN` | `CRDAUTTKN` | `CHAR(256)` | ccCaptureService_authRequestToken | | | `PCAPSRVRUN` | `PCAPSRVRUN` | `CHAR(5)` | payPalDoCaptureService_run | | | `PPATHID` | `PPATHID` | `CHAR(19)` | paypalAuthorizationId | | | `PPCPLTYP` | `PPCPLTYP` | `CHAR(12)` | completeType | | | `PPEDPREQID` | `PPEDPREQID` | `CHAR(22)` | paypalEcDoPaymentRequestID | | | `PPEDPREQTK` | `PPEDPREQTK` | `CHAR(256)` | paypalEcDoPaymentRequestToken | | | `PPATHREQID` | `PPATHREQID` | `CHAR(22)` | paypalAuthorizationRequestID | | | `PPATHREQTK` | `PPATHREQTK` | `CHAR(256)` | paypalAuthorizationRequestToken | | | `PPINVNBR` | `PPINVNBR` | `CHAR(127)` | invoiceNumber | | | `PREFSRVRUN` | `PREFSRVRUN` | `CHAR(5)` | payPalRefundService_run | | | `EXPRUN` | `EXPORTSERVICERUN` | `CHAR(5)` | exportService_run | | | `EXPADROPR` | `EXPADROPR` | `CHAR(3)` | exportService_addressOperator | | | `EXPADRWGT` | `EXPADRWGT` | `CHAR(6)` | exportService_addressWeight | | | `EXPCMPWGT` | `EXPCMPWGT` | `CHAR(6)` | exportService_companyWeight | | | `EXPNAMWGT` | `EXPNAMWGT` | `CHAR(6)` | exportService_nameWeight | | | `AMEXTAA3` | `AMEXTAA3` | `CHAR(40)` | invoiceHeader_amexDataTAA3 | | | `AMEXTAA4` | `AMEXTAA4` | `CHAR(40)` | invoiceHeader_amexDataTAA4 | | | `VATTAXAMT` | `VATTAXAMT` | `CHAR(13)` | otherTax_vatTaxAmount | | | `VATTAXRTE` | `VATTAXRTE` | `CHAR(4)` | otherTax_vatTaxRate | | | `ALTTAXAMT` | `ALTTAXAMT` | `CHAR(10)` | otherTax_alternateTaxAmount | | | `ALTTAXID` | `ALTTAXID` | `CHAR(15)` | otherTax_alternateTaxID | | | `PTDSCAMT` | `PTDSCAMT` | `CHAR(13)` | purchaseTotals_discountAmount | | | `PTDTYAMT` | `PTDTYAMT` | `CHAR(13)` | purchaseTotals_dutyAmount | | | `MCATHIND` | `MCATHIND` | `CHAR(1)` | authIndicator | | | `PPCAPSQNCE` | `PPCAPSQNCE` | `CHAR(2)` | ccCaptureService_sequence | | | `PPCAPTOTCT` | `PPCAPTOTCT` | `CHAR(2)` | ccCaptureService_totalCount | | | `BTCMPTXID` | `BTCMPTXID` | `CHAR(9)` | billTo_companyTaxID | | | `BTDOB` | `BTDOB` | `CHAR(10)` | billTo_dateOfBirth | | | `BTDLNBR` | `BTDLNBR` | `CHAR(30)` | billTo_driversLicenseNumber | | | `BTDLSTT` | `BTDLSTT` | `CHAR(2)` | billTo_driversLicenseState | | | `BRDECAVS` | `BRDECAVS` | `CHAR(255)` | businessRules_declineAVSFlags | | | `CKACTENCID` | `CKACTENCID` | `CHAR(3)` | check_accountEncoderID | | | `CKACTNBR` | `CKACTNBR` | `CHAR(17)` | check_accountNumber | | | `CKACTTYP` | `CKACTTYP` | `CHAR(1)` | check_accountType | | | `CKATHID` | `CKATHID` | `CHAR(32)` | check_authenticateID | | | `CKBKTRNNBR` | `CKBKTRNNBR` | `CHAR(9)` | check_bankTransitNumber | | | `CKNBR` | `CKNBR` | `CHAR(8)` | check_checkNumber | | | `CKIMGRFNBR` | `CKIMGRFNBR` | `CHAR(32)` | check_imageReferenceNumber | | | `CKPMTINF` | `CKPMTINF` | `CHAR(80)` | check_paymentInfo | | | `CKSECCDE` | `CKSECCDE` | `CHAR(3)` | check_secCode | | | `CKTRMCTY` | `CKTRMCTY` | `CHAR(4)` | check_terminalCity | | | `CKTRMSTT` | `CKTRMSTT` | `CHAR(2)` | check_terminalState | | | `ECATHRUN` | `ECAUTHENTICATESERVICERUN` | `CHAR(5)` | ecAuthenticateService_run | | | `ECATHRFNBR` | `ECATHRFNBR` | `CHAR(100)` | ecAuthenticateService_referenceNumber | | | `ECCRCMCIND` | `ECCRCMCIND` | `CHAR(13)` | ecCreditService_commerceIndicator | | | `ECCRDBRQID` | `ECCRDBRQID` | `CHAR(48)` | ecCreditService_debitRequestID | | | `ECCREFFDT` | `ECCREFFDT` | `CHAR(8)` | ecCreditService_effectiveDate | | | `ECCRPPMTID` | `ECCRPPMTID` | `CHAR(25)` | ecCreditService_partialPaymentID | | | `ECCRRFNBR` | `ECCRRFNBR` | `CHAR(60)` | ecCreditService_referenceNumber | | | `ECCRRUN` | `ECCREDITSERVICERUN` | `CHAR(5)` | ecCreditService_run | | | `ECCRSTLMD` | `ECCRSTLMD` | `CHAR(1)` | ecCreditService_settlementMethod | | | `ECDBCMCIND` | `ECDBCMCIND` | `CHAR(13)` | ecDebitService_commerceIndicator | | | `ECDBRQID` | `ECDBRQID` | `CHAR(48)` | ecDebitService_debitRequestID | | | `ECDBEFFDT` | `ECDBEFFDT` | `CHAR(8)` | ecDebitService_effectiveDate | | | `ECDBPPMTID` | `ECDBPPMTID` | `CHAR(25)` | ecDebitService_partialPaymentID | | | `ECDBPMTINF` | `ECDBPMTINF` | `CHAR(80)` | ecDebitService_paymentInfo | | | `ECDBPMTMD` | `ECDBPMTMD` | `CHAR(1)` | ecDebitService_paymentMode | | | `ECDBRFNBR` | `ECDBRFNBR` | `CHAR(60)` | ecDebitService_refernceNumber | | | `ECDBRUN` | `ECDEBITSERVICERUN` | `CHAR(5)` | ecDebitService_run | | | `ECDBSTLMD` | `ECDBSTLMD` | `CHAR(1)` | ecDebitService_settlementMethod | | | `ECDBVRFLVL` | `ECDBVRFLVL` | `CHAR(1)` | ecDebitService_verificationLevel | | | `MCHDSCRALT` | `MCHDSCRALT` | `CHAR(10)` | invoiceHeader_merchantDescriptorAlternat | | | `LNKTOREQ` | `LNKTOREQ` | `CHAR(48)` | linkToRequest | | | `ECSRUN` | `PAYPALECORDERSETUPSERVICERUN` | `CHAR(5)` | payPalEcOrderSetupService_run | | | `ECSINVNBR` | `ECSINVNBR` | `CHAR(127)` | payPalEcOrderSetupService_invoiceNumber | | | `ECSPCSTEML` | `ECSPCSTEML` | `CHAR(127)` | payPalEcOrderSetupService_paypalCustomerEmail | | | `ECSPDESC` | `ECSPDESC` | `CHAR(127)` | payPalEcOrderSetupService_paypalDesc | | | `ECSPSREQID` | `ECSPSREQID` | `CHAR(48)` | payPalEcOrderSetupService_paypalEcSetRequestID | | | `ECSPSREQTK` | `ECSPSREQTK` | `CHAR(256)` | payPalEcOrderSetupService_paypalEcSetRequestToke | | | `ECSPPAYID` | `ECSPPAYID` | `CHAR(13)` | payPalEcOrderSetupService_paypalPayerId | | | `ECSPTKN` | `ECSPTKN` | `CHAR(20)` | payPalEcOrderSetupService_paypalToken | | | `ECSPRMCD0` | `ECSPRMCD0` | `CHAR(20)` | payPalEcOrderSetupService_promoCode0 | | | `PATRUN` | `PAYPALAUTHORIZATIONSERVICERUN` | `CHAR(5)` | payPalAuthorizationService_run | | | `PATPCSTEML` | `PATPCSTEML` | `CHAR(127)` | payPalAuthorizationService_paypalCustomerEmail | | | `PATPDREQID` | `PATPDREQID` | `CHAR(48)` | payPalAuthorizationService_paypalDoRefTransactio | | | `PATPDREQTK` | `PATPDREQTK` | `CHAR(256)` | payPalAuthorizationService_paypalDoRefTransactio | | | `PATPSREQID` | `PATPSREQID` | `CHAR(48)` | payPalAuthorizationService_paypalEcSetRequestID | | | `PATPSREQTK` | `PATPSREQTK` | `CHAR(256)` | payPalAuthorizationService_paypalEcSetRequestTok | | | `PATPORDID` | `PATPORDID` | `CHAR(255)` | payPalAuthorizationService_paypalOrderId | | | `PDRRUN` | `PAYPALDOREFTRANSACTIONSERVICERUN` | `CHAR(5)` | payPalDoRefTransactionService_run | | | `PDRINVNBR` | `PDRINVNBR` | `CHAR(127)` | payPalDoRefTransactionService_invoiceNumber | | | `PDRPBLAGID` | `PDRPBLAGID` | `CHAR(256)` | payPalDoRefTransactionService_paypalBillingAgree | | | `PDRPDESC` | `PDRPDESC` | `CHAR(127)` | payPalDoRefTransactionService_paypalDesc | | | `PDRPENTURL` | `PDRPENTURL` | `CHAR(2048)` | payPalAuthorizationService_paypalEcNotifyUrl | | | `PDRPPMTTYP` | `PDRPPMTTYP` | `CHAR(7)` | payPalDoRefTransactionService_paypalPaymentType | | | `PDRPREQCNS` | `PDRPREQCNS` | `CHAR(1)` | payPalDoRefTransactionService_paypalReqconfirmsh | | | `PDRPRTFMDT` | `PDRPRTFMDT` | `CHAR(1)` | payPalDoRefTransactionService_paypalReturnFmfDet | | | `PDRPSHPDSC` | `PDRPSHPDSC` | `CHAR(9)` | payPalDoRefTransactionService_paypalShippingDisc | | | `PDRPSFDESC` | `PDRPSFDESC` | `CHAR(256)` | payPalDoRefTransactionService_paypalSoftDescript | | | `PRSRUN` | `PAYPALREFUNDSERVICERUN` | `CHAR(5)` | payPalRefundService_run | | | `PRSPCAPID` | `PRSPCAPID` | `CHAR(17)` | payPalRefundService_paypalCaptureId | | | `PRSPDREQID` | `PRSPDREQID` | `CHAR(48)` | payPalRefundService_paypalDoCaptureRequestID | | | `PRSPDREQTK` | `PRSPDREQTK` | `CHAR(256)` | payPalRefundService_paypalDoCaptureRequestToken | | | `PRSPNOTE` | `PRSPNOTE` | `CHAR(255)` | payPalRefundService_ paypalNote | | | `PCARUN` | `PAYPALCREATEAGREEMENTSERVICERUN` | `CHAR(5)` | payPalCreateAgreementService_run | | | `PCAPSREQID` | `PCAPSREQID` | `CHAR(48)` | payPalCreateAgreementService_paypalEcSetRequestI | | | `PCAPSREQTK` | `PCAPSREQTK` | `CHAR(256)` | payPalCreateAgreementService_paypalEcSetRequestT | | | `PCAPTKN` | `PCAPTKN` | `CHAR(20)` | payPalCreateAgreementService_paypalToken | | | `PARRUN` | `PAYPALAUTHREVERSALSERVICERUN` | `CHAR(5)` | payPalAuthReversalService_run | | | `PARPATHID` | `PARPATHID` | `CHAR(19)` | payPalAuthReversalService_paypalAuthorizationId | | | `PARPAREQID` | `PARPAREQID` | `CHAR(48)` | payPalAuthReversalService_paypalAuthorizationReq | | | `PARPAREQTK` | `PARPAREQTK` | `CHAR(256)` | payPalAuthReversalService_paypalAuthorizationReq | | | `PARPDREQID` | `PARPDREQID` | `CHAR(48)` | payPalAuthReversalService_paypalEcDoPaymentReque | | | `PARPDREQTK` | `PARPDREQTK` | `CHAR(256)` | payPalAuthReversalService_paypalEcDoPaymentReque | | | `PARPSREQID` | `PARPSREQID` | `CHAR(48)` | payPalAuthReversalService_paypalEcOrderSetupRequ | | | `PARPSREQTK` | `PARPSREQTK` | `CHAR(256)` | payPalAuthReversalService_paypalEcOrderSetupRequ | | | `PDCRUN` | `PAYPALDOCAPTURESERVICERUN` | `CHAR(5)` | payPalDoCaptureService_run | | | `PDCINVNBR` | `PDCINVNBR` | `CHAR(127)` | payPalDoCaptureService_invoiceNumber | | | `PDCPATHID` | `PDCPATHID` | `CHAR(19)` | payPalDoCaptureService_paypalAuthorizationId | | | `PDCPAREQID` | `PDCPAREQID` | `CHAR(48)` | payPalDoCaptureService_paypalAuthorizationReques | | | `PDCPAREQTK` | `PDCPAREQTK` | `CHAR(256)` | payPalDoCaptureService_paypalAuthorizationReques | | | `PDCPDREQID` | `PDCPDREQID` | `CHAR(48)` | payPalDoCaptureService_paypalEcDoPaymentRequestI | | | `PDCPDREQTK` | `PDCPDREQTK` | `CHAR(256)` | payPalDoCaptureService_paypalEcDoPaymentRequestT | | | `PDCCPLTYP` | `PDCCPLTYP` | `CHAR(12)` | payPalDoCaptureService_completeType | | | `PUARUN` | `PAYPALUPDATEAGREEMENTSERVICERUN` | `CHAR(5)` | payPalUpdateAgreement_run | | | `PUAPBLAGCS` | `PUAPBLAGCS` | `CHAR(256)` | payPalUpdateAgreement_paypalBillingAgreementCust | | | `PUAPBLAGDS` | `PUAPBLAGDS` | `CHAR(127)` | payPalUpdateAgreement_paypalBillingAgreementDesc | | | `PUAPBLAGID` | `PUAPBLAGID` | `CHAR(256)` | payPalUpdateAgreement_paypalBillingAgreementId | | | `PUAPBLAGST` | `PUAPBLAGST` | `CHAR(8)` | payPalUpdateAgreement_paypalBillingAgreementStat | | | `VCORDERID` | `VCORDERID` | `CHAR(48)` | vc_orderID | | | `PMTSOLN` | `PMTSOLN` | `CHAR(12)` | paymentSolution | | | `BTCUSTID` | `BTCUSTID` | `CHAR(100)` | billTo_customerID | | | `EPDESCR` | `EPDESCR` | `CHAR(128)` | encryptedPayment_descriptor | | | `EPENC` | `EPENC` | `CHAR(6)` | encryptedPayment_encoding | | | `EPDTA` | `EPDTA` | `CHAR(8192)` | encryptedPayment_data | | | `SSAUTH` | `SSAUTH` | `CHAR(5)` | subsequentAuth | | | `SSAFST` | `SSAFST` | `CHAR(5)` | subsequentAuthFirst | | | `SSAORGAMT` | `SSAORGAMT` | `CHAR(60)` | subsequentAuthOriginalAmount | | | `SSARSN` | `SSARSN` | `CHAR(1)` | subsequentAuthReason | | | `SSASTRCRD` | `SSASTRCRD` | `CHAR(5)` | subsequentAuthStoredCredential | | | `SSATRNID` | `SSATRNID` | `CHAR(15)` | subsequentAuthTransactionID | | | `BTDIST` | `BILLTODISTRICT` | `CHAR(50)` | billTo_district | | | `BTLANG` | `BILLTOLANGUAGE` | `CHAR(6)` | billTo_language | | | `STDIST` | `SHIPTODISTRICT` | `CHAR(50)` | shipTo_district | | | `STEML` | `SHIPTOEMAIL` | `CHAR(255)` | shipTo_email | | | `TAXRUN` | `TAXRUN` | `CHAR(5)` | taxService_run | | | `TAXNEXUS` | `TAXNEXUS` | `CHAR(220)` | taxService_nexus | | | `TAXNONEXUS` | `TAXNONEXUS` | `CHAR(220)` | taxService_noNexus | | | `TAXSLREG` | `TAXSELLERREG` | `CHAR(21)` | taxService_sellerRegistration | | | `MCHVATREG` | `MERCHANTVATREGNBR` | `CHAR(21)` | invoiceHeader_merchantVATRegistrationNumber | | | `TAXCMTIND` | `TAXCOMMITIND` | `CHAR(5)` | taxService_commitIndicator | | | `TAXRFNIND` | `TAXREFUNDIND` | `CHAR(5)` | taxService_refundIndicator | | ### CTIWSAHDR | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `UID` | `UNIQUEID` | `DECIMAL(15:0)` | Request Unique ID | | | `BILLAGID` | `AP_BILLINGAGREEMENTID` | `CHAR(50)` | ap_billingAgreementID | | | `BILLAGDESC` | `AP_BILLINGAGREEMENTDESCRIPTION` | `CHAR(127)` | ap_billingAgreementDescription | | | `BILLAGIND` | `AP_BILLINGAGREEMENTINDICATOR` | `CHAR(5)` | ap_billingAgreementIndicator | | | `FUNDINGSRC` | `AP_FUNDINGSOURCE` | `CHAR(30)` | ap_fundingSouce | | | `APPAYERID` | `AP_PAYERID` | `CHAR(30)` | ap_payerID | | | `APPMTTYP` | `APPAYMENTTYPE` | `CHAR(3)` | apPaymentType | | | `PAYEENOTE` | `NOTE_TOPAYEE` | `CHAR(255)` | note_toPayee | | | `PAYERNOTE` | `NOTE_TOPAYER` | `CHAR(165)` | note_toPayer | | | `PCHTOTHNDL` | `PURCHASETOTALS_HANDLINGAMOUNT` | `CHAR(15)` | purchaseTotals_handlingAmount | | | `PCHTOTSHP` | `PURCHASETOTALS_SHIPPINGAMOUNT` | `CHAR(15)` | purchaseTotals_shippingAmount | | | `PCHTOTDISC` | `PURCHASETOTALS_SHIPPINGDISCOUNTAMOUNT` | `CHAR(15)` | purchaseTotals_shippingDiscountAmount | | | `PCHTOTSUB` | `PURCHASETOTALS_SUBTOTALAMOUNT` | `CHAR(15)` | purchaseTotals_subtotalAmount | | | `STCITY` | `SHIPTO_CITY` | `CHAR(40)` | shipTo_city | | | `STCNTRY` | `SHIPTO_COUNTRY` | `CHAR(2)` | shipTo_country | | | `STFNAME` | `SHIPTO_FIRSTNAME` | `CHAR(60)` | shipTo_firstName | | | `STIMMUTBL` | `SHIPTO_IMMUTABLE` | `CHAR(5)` | shipTo_immutable | | | `STLNAME` | `SHIPTO_LASTNAME` | `CHAR(60)` | shipTo_lastName | | | `STNOTAPBL` | `SHIPTO_NOTAPPLICABLE` | `CHAR(5)` | shipTo_notApplicable | | | `STPHONE` | `SHIPTO_PHONENUMBER` | `CHAR(20)` | shipTo_phoneNumber | | | `STPOSTCD` | `SHIPTO_POSTALCODE` | `CHAR(20)` | shipTo_postalCode | | | `STSTATE` | `SHIPTO_STATE` | `CHAR(40)` | shipTo_state | | | `STSTREET1` | `SHIPTO_STREET1` | `CHAR(100)` | shipTo_street1 | | | `STSTREET2` | `SHIPTO_STREET2` | `CHAR(100)` | shipTo_street2 | | | `SSNRUN` | `APSESSIONSSERVICE_RUN` | `CHAR(5)` | apSessionsService_run | | | `SSNCNLURL` | `APSESSIONSSERVICE_CANCELURL` | `CHAR(255)` | apSessionsService_cancelURL | | | `SSNPMTOPID` | `APSESSIONSSERVICE_PAYMENTOPTIONID` | `CHAR(255)` | apSessionsService_paymentOptionID | | | `SSNSCSURL` | `APSESSIONSSERVICE_SUCCESSURL` | `CHAR(255)` | apSessionsService_successURL | | | `STSRUN` | `APCHECKSTATUSSERVICE_RUN` | `CHAR(5)` | apCheckStatusService_run | | | `STSSSNRQID` | `APCHECKSTATUSSERVICE_SESSIONSREQUESTID` | `CHAR(26)` | apCheckStatusService_sessionsRequestID | | | `STSREQID` | `APCHECKSTATUSSERVICE_CHECKSTATUSREQUESTID` | `CHAR(26)` | apCheckStatusService_checkStatusRequestID | | | `ORDRUN` | `APORDERSERVICE_RUN` | `CHAR(5)` | apOrderService_run | | | `ORDSSNRQID` | `APORDERSERVICE_SESSIONSREQUESTID` | `CHAR(26)` | apOrderService_sessionsRequestID | | | `ORDREQID` | `ORDREQID` | `CHAR(26)` | apAuthService_orderRequestID | | | `ATHRUN` | `APAUTHSERVICE_RUN` | `CHAR(5)` | apAuthService_run | | | `ATHORDRQID` | `APAUTHSERVICE_ORDERREQUESTID` | `CHAR(26)` | apAuthService_orderRequestID | | | `REVRUN` | `APAUTHREVERSALSERVICE_RUN` | `CHAR(5)` | apAuthReversalService_run | | | `REVATHRQID` | `APAUTHREVERSALSERVICE_AUTHREQUESTID` | `CHAR(26)` | apAuthReversalService_authRequestID | | | `CAPRUN` | `APCAPTURESERVICE_RUN` | `CHAR(5)` | apCaptureService_run | | | `CAPISFINAL` | `APCAPTURESERVICE_ISFINAL` | `CHAR(5)` | apCaptureService_isFinal | | | `CAPATHRQID` | `APCAPTURESERVICE_AUTHREQUESTID` | `CHAR(26)` | apCaptureService_authRequestID | | | `SALRUN` | `APSALESERVICE_RUN` | `CHAR(5)` | apSaleService_run | | | `SALORDRQID` | `APSALESERVICE_ORDERREQUESTID` | `CHAR(26)` | apSaleService_orderRequestId | | | `REFRUN` | `APREFUNDSERVICE_RUN` | `CHAR(5)` | apRefundService_run | | | `REFREASON` | `APREFUNDSERVICE_REASON` | `CHAR(30)` | apRefundService_reason | | | `REFREQID` | `APREFUNDSERVICE_REFUNDREQUESTID` | `CHAR(26)` | apRefundService_refundRequestID | | | `CNLRUN` | `APCANCELSERVICE_RUN` | `CHAR(5)` | apCancelService_run | | | `CNLORDRQID` | `APCANCELSERVICE_ORDERREQUESTID` | `CHAR(26)` | apCancelService_orderRequestID | | | `BAGRUN` | `APBILLINGAGREEMENTSERVICE_RUN` | `CHAR(5)` | apBillingAgreementService_run | | | `BAGSSNRQID` | `APBILLINGAGREEMENTSERVICE_SESSIONSREQUESTID` | `CHAR(26)` | apBillingAgreementService_sessionsRequestID | | | `SSNRQID` | `APSESSIONSSERVICE_SESSIONSREQUESTID` | `CHAR(26)` | apSessionsService_sessionsRequestID | | | `SSNPFMODE` | `APSESSIONSSERVICE_PAYMENTFLOWMODE` | `CHAR(50)` | apSessionsService_paymentFlowMode | | | `SSNFAILURL` | `APSESSIONSSERVICE_FAILUREURL` | `CHAR(255)` | apSessionsService_failureURL | | | `SSNPMTMD` | `APSESSIONSSERVICE_PAYMENTMETHOD_NAME` | `CHAR(50)` | apSessionsService_paymentMethod_name | | | `SSNTYPE` | `APSESSIONSSERVICE_SESSIONSTYPE` | `CHAR(5)` | apSessionsService_sessionsType | | | `ATHCNLURL` | `APAUTHSERVICE_CANCELURL` | `CHAR(255)` | apAuthService_cancelURL | | | `ATHFAILURL` | `APAUTHSERVICE_FAILUREURL` | `CHAR(255)` | apAuthService_failureURL | | | `ATHSCSURL` | `APAUTHSERVICE_SUCCESSURL` | `CHAR(255)` | apAuthService_successURL | | | `ATHPAPRTK` | `APAUTHSERVICE_PREAPPROVALTOKEN` | `CHAR(60)` | apAuthService_preapprovalToken | | ### CTIWSITM | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PARENT_UNIQUEID` | `DECIMAL(15:0)` | Request Unique ID | | | `UID` | `ITEM_UNIQUEID` | `DECIMAL(15:0)` | Line Item Unique ID | | | `CRTDT` | `TIMESTAMP` | `TIMESTAMP` | Request Timestamp | | | `PRDCD` | `PRDCD` | `CHAR(30)` | item_#_productCode | | | `PRDNAM` | `PRDNAM` | `CHAR(30)` | item_#_productName | | | `PRDSKU` | `PRDSKU` | `CHAR(15)` | item_#_productSKU | | | `COMMCD` | `COMMCD` | `CHAR(25)` | item_#_commodityCode | | | `QTY` | `QTY` | `DECIMAL(10:0)` | item_#_quantity | | | `UNTPRC` | `UNTPRC` | `CHAR(15)` | item_#_unitPrice | | | `TAXAMT` | `TAXAMT` | `CHAR(15)` | item_#_taxAmount | | | `GRSNETIND` | `GRSNETIND` | `CHAR(1)` | item_#_grossNetIndicator | | | `TAXRAT` | `TAXRAT` | `CHAR(7)` | item_#_taxRate | | | `TOTAMT` | `TOTAMT` | `CHAR(15)` | item_#_totalAmount | | | `UOM` | `UOM` | `CHAR(12)` | item_#_unitOfMeasure | | | `SEQ#` | `SEQ#` | `NUMERIC` | sequence # | | | `DSCAMT` | `DSCAMT` | `CHAR(13)` | item_#_discountAmount | | | `DSCIND` | `DSCIND` | `CHAR(1)` | item_#_discountIndicator | | | `INVNBR` | `INVNBR` | `CHAR(23)` | item_#_invoiceNumber | | | `TAXTYPAPL` | `TAXTYPAPL` | `CHAR(4)` | item_#_taxTypeApplied | | | `PRDDESC` | `PRDDESC` | `CHAR(127)` | item_#_productDescription | | | `UNITTAXAM` | `UNITTAXAM` | `CHAR(15)` | item_#_unitTaxAmount | | ### CTIWSMDD | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `UID` | `PARENT_UNIQUEID` | `DECIMAL(15:0)` | Request Unique ID | | | `MCHDDTA1` | `MCHDDTA1` | `VARCHAR(255)` | Merchant-Defined Data 1 | | | `MCHDDTA2` | `MCHDDTA2` | `VARCHAR(255)` | Merchant-Defined Data 2 | | | `MCHDDTA3` | `MCHDDTA3` | `VARCHAR(255)` | Merchant-Defined Data 3 | | | `MCHDDTA4` | `MCHDDTA4` | `VARCHAR(255)` | Merchant-Defined Data 4 | | | `MCHDDTA5` | `MCHDDTA5` | `VARCHAR(255)` | Merchant-Defined Data 5 | | | `MCHDDTA6` | `MCHDDTA6` | `VARCHAR(255)` | Merchant-Defined Data 6 | | | `MCHDDTA7` | `MCHDDTA7` | `VARCHAR(255)` | Merchant-Defined Data 7 | | | `MCHDDTA8` | `MCHDDTA8` | `VARCHAR(255)` | Merchant-Defined Data 8 | | | `MCHDDTA9` | `MCHDDTA9` | `VARCHAR(255)` | Merchant-Defined Data 9 | | | `MCHDDTA10` | `MCHDDTA10` | `VARCHAR(255)` | Merchant-Defined Data 10 | | | `MCHDDTA11` | `MCHDDTA11` | `VARCHAR(255)` | Merchant-Defined Data 11 | | | `MCHDDTA12` | `MCHDDTA12` | `VARCHAR(255)` | Merchant-Defined Data 12 | | | `MCHDDTA13` | `MCHDDTA13` | `VARCHAR(255)` | Merchant-Defined Data 13 | | | `MCHDDTA14` | `MCHDDTA14` | `VARCHAR(255)` | Merchant-Defined Data 14 | | | `MCHDDTA15` | `MCHDDTA15` | `VARCHAR(255)` | Merchant-Defined Data 15 | | | `MCHDDTA16` | `MCHDDTA16` | `VARCHAR(255)` | Merchant-Defined Data 16 | | | `MCHDDTA17` | `MCHDDTA17` | `VARCHAR(255)` | Merchant-Defined Data 17 | | | `MCHDDTA18` | `MCHDDTA18` | `VARCHAR(255)` | Merchant-Defined Data 18 | | | `MCHDDTA19` | `MCHDDTA19` | `VARCHAR(255)` | Merchant-Defined Data 19 | | | `MCHDDTA20` | `MCHDDTA20` | `VARCHAR(255)` | Merchant-Defined Data 20 | | | `MCHDDTA21` | `MCHDDTA21` | `VARCHAR(255)` | Merchant-Defined Data 21 | | | `MCHDDTA22` | `MCHDDTA22` | `VARCHAR(255)` | Merchant-Defined Data 22 | | | `MCHDDTA23` | `MCHDDTA23` | `VARCHAR(255)` | Merchant-Defined Data 23 | | | `MCHDDTA24` | `MCHDDTA24` | `VARCHAR(255)` | Merchant-Defined Data 24 | | | `MCHDDTA25` | `MCHDDTA25` | `VARCHAR(255)` | Merchant-Defined Data 25 | | | `MCHDDTA26` | `MCHDDTA26` | `VARCHAR(255)` | Merchant-Defined Data 26 | | | `MCHDDTA27` | `MCHDDTA27` | `VARCHAR(255)` | Merchant-Defined Data 27 | | | `MCHDDTA28` | `MCHDDTA28` | `VARCHAR(255)` | Merchant-Defined Data 28 | | | `MCHDDTA29` | `MCHDDTA29` | `VARCHAR(255)` | Merchant-Defined Data 29 | | | `MCHDDTA30` | `MCHDDTA30` | `VARCHAR(255)` | Merchant-Defined Data 30 | | | `MCHDDTA31` | `MCHDDTA31` | `VARCHAR(255)` | Merchant-Defined Data 31 | | | `MCHDDTA32` | `MCHDDTA32` | `VARCHAR(255)` | Merchant-Defined Data 32 | | | `MCHDDTA33` | `MCHDDTA33` | `VARCHAR(255)` | Merchant-Defined Data 33 | | | `MCHDDTA34` | `MCHDDTA34` | `VARCHAR(255)` | Merchant-Defined Data 34 | | | `MCHDDTA35` | `MCHDDTA35` | `VARCHAR(255)` | Merchant-Defined Data 35 | | | `MCHDDTA36` | `MCHDDTA36` | `VARCHAR(255)` | Merchant-Defined Data 36 | | | `MCHDDTA37` | `MCHDDTA37` | `VARCHAR(255)` | Merchant-Defined Data 37 | | | `MCHDDTA38` | `MCHDDTA38` | `VARCHAR(255)` | Merchant-Defined Data 38 | | | `MCHDDTA39` | `MCHDDTA39` | `VARCHAR(255)` | Merchant-Defined Data 39 | | | `MCHDDTA40` | `MCHDDTA40` | `VARCHAR(255)` | Merchant-Defined Data 40 | | | `MCHDDTA41` | `MCHDDTA41` | `VARCHAR(255)` | Merchant-Defined Data 41 | | | `MCHDDTA42` | `MCHDDTA42` | `VARCHAR(255)` | Merchant-Defined Data 42 | | | `MCHDDTA43` | `MCHDDTA43` | `VARCHAR(255)` | Merchant-Defined Data 43 | | | `MCHDDTA44` | `MCHDDTA44` | `VARCHAR(255)` | Merchant-Defined Data 44 | | | `MCHDDTA45` | `MCHDDTA45` | `VARCHAR(255)` | Merchant-Defined Data 45 | | | `MCHDDTA46` | `MCHDDTA46` | `VARCHAR(255)` | Merchant-Defined Data 46 | | | `MCHDDTA47` | `MCHDDTA47` | `VARCHAR(255)` | Merchant-Defined Data 47 | | | `MCHDDTA48` | `MCHDDTA48` | `VARCHAR(255)` | Merchant-Defined Data 48 | | | `MCHDDTA49` | `MCHDDTA49` | `VARCHAR(255)` | Merchant-Defined Data 49 | | | `MCHDDTA50` | `MCHDDTA50` | `VARCHAR(255)` | Merchant-Defined Data 50 | | | `MCHDDTA51` | `MCHDDTA51` | `VARCHAR(255)` | Merchant-Defined Data 51 | | | `MCHDDTA52` | `MCHDDTA52` | `VARCHAR(255)` | Merchant-Defined Data 52 | | | `MCHDDTA53` | `MCHDDTA53` | `VARCHAR(255)` | Merchant-Defined Data 53 | | | `MCHDDTA54` | `MCHDDTA54` | `VARCHAR(255)` | Merchant-Defined Data 54 | | | `MCHDDTA55` | `MCHDDTA55` | `VARCHAR(255)` | Merchant-Defined Data 55 | | | `MCHDDTA56` | `MCHDDTA56` | `VARCHAR(255)` | Merchant-Defined Data 56 | | | `MCHDDTA57` | `MCHDDTA57` | `VARCHAR(255)` | Merchant-Defined Data 57 | | | `MCHDDTA58` | `MCHDDTA58` | `VARCHAR(255)` | Merchant-Defined Data 58 | | | `MCHDDTA59` | `MCHDDTA59` | `VARCHAR(255)` | Merchant-Defined Data 59 | | | `MCHDDTA60` | `MCHDDTA60` | `VARCHAR(255)` | Merchant-Defined Data 60 | | | `MCHDDTA61` | `MCHDDTA61` | `VARCHAR(255)` | Merchant-Defined Data 61 | | | `MCHDDTA62` | `MCHDDTA62` | `VARCHAR(255)` | Merchant-Defined Data 62 | | | `MCHDDTA63` | `MCHDDTA63` | `VARCHAR(255)` | Merchant-Defined Data 63 | | | `MCHDDTA64` | `MCHDDTA64` | `VARCHAR(255)` | Merchant-Defined Data 64 | | | `MCHDDTA65` | `MCHDDTA65` | `VARCHAR(255)` | Merchant-Defined Data 65 | | | `MCHDDTA66` | `MCHDDTA66` | `VARCHAR(255)` | Merchant-Defined Data 66 | | | `MCHDDTA67` | `MCHDDTA67` | `VARCHAR(255)` | Merchant-Defined Data 67 | | | `MCHDDTA68` | `MCHDDTA68` | `VARCHAR(255)` | Merchant-Defined Data 68 | | | `MCHDDTA69` | `MCHDDTA69` | `VARCHAR(255)` | Merchant-Defined Data 69 | | | `MCHDDTA70` | `MCHDDTA70` | `VARCHAR(255)` | Merchant-Defined Data 70 | | | `MCHDDTA71` | `MCHDDTA71` | `VARCHAR(255)` | Merchant-Defined Data 71 | | | `MCHDDTA72` | `MCHDDTA72` | `VARCHAR(255)` | Merchant-Defined Data 72 | | | `MCHDDTA73` | `MCHDDTA73` | `VARCHAR(255)` | Merchant-Defined Data 73 | | | `MCHDDTA74` | `MCHDDTA74` | `VARCHAR(255)` | Merchant-Defined Data 74 | | | `MCHDDTA75` | `MCHDDTA75` | `VARCHAR(255)` | Merchant-Defined Data 75 | | | `MCHDDTA76` | `MCHDDTA76` | `VARCHAR(255)` | Merchant-Defined Data 76 | | | `MCHDDTA77` | `MCHDDTA77` | `VARCHAR(255)` | Merchant-Defined Data 77 | | | `MCHDDTA78` | `MCHDDTA78` | `VARCHAR(255)` | Merchant-Defined Data 78 | | | `MCHDDTA79` | `MCHDDTA79` | `VARCHAR(255)` | Merchant-Defined Data 79 | | | `MCHDDTA80` | `MCHDDTA80` | `VARCHAR(255)` | Merchant-Defined Data 80 | | | `MCHDDTA81` | `MCHDDTA81` | `VARCHAR(255)` | Merchant-Defined Data 81 | | | `MCHDDTA82` | `MCHDDTA82` | `VARCHAR(255)` | Merchant-Defined Data 82 | | | `MCHDDTA83` | `MCHDDTA83` | `VARCHAR(255)` | Merchant-Defined Data 83 | | | `MCHDDTA84` | `MCHDDTA84` | `VARCHAR(255)` | Merchant-Defined Data 84 | | | `MCHDDTA85` | `MCHDDTA85` | `VARCHAR(255)` | Merchant-Defined Data 85 | | | `MCHDDTA86` | `MCHDDTA86` | `VARCHAR(255)` | Merchant-Defined Data 86 | | | `MCHDDTA87` | `MCHDDTA87` | `VARCHAR(255)` | Merchant-Defined Data 87 | | | `MCHDDTA88` | `MCHDDTA88` | `VARCHAR(255)` | Merchant-Defined Data 88 | | | `MCHDDTA89` | `MCHDDTA89` | `VARCHAR(255)` | Merchant-Defined Data 89 | | | `MCHDDTA90` | `MCHDDTA90` | `VARCHAR(255)` | Merchant-Defined Data 90 | | | `MCHDDTA91` | `MCHDDTA91` | `VARCHAR(255)` | Merchant-Defined Data 91 | | | `MCHDDTA92` | `MCHDDTA92` | `VARCHAR(255)` | Merchant-Defined Data 92 | | | `MCHDDTA93` | `MCHDDTA93` | `VARCHAR(255)` | Merchant-Defined Data 93 | | | `MCHDDTA94` | `MCHDDTA94` | `VARCHAR(255)` | Merchant-Defined Data 94 | | | `MCHDDTA95` | `MCHDDTA95` | `VARCHAR(255)` | Merchant-Defined Data 95 | | | `MCHDDTA96` | `MCHDDTA96` | `VARCHAR(255)` | Merchant-Defined Data 96 | | | `MCHDDTA97` | `MCHDDTA97` | `VARCHAR(255)` | Merchant-Defined Data 97 | | | `MCHDDTA98` | `MCHDDTA98` | `VARCHAR(255)` | Merchant-Defined Data 98 | | | `MCHDDTA99` | `MCHDDTA99` | `VARCHAR(255)` | Merchant-Defined Data 99 | | | `MCHDDTA100` | `MCHDDTA100` | `VARCHAR(255)` | Merchant-Defined Data 100 | | ## Output Table Files ### CTIWSRSP | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `UID` | `PARENT_UNIQUEID` | `DECIMAL(15:0)` | Response Unique ID | | | `CRTDT` | `TIMESTAMP` | `TIMESTAMP` | Response Timestamp | | | `DCN` | `DCN` | `CHAR(6)` | decision | | | `RSNCD` | `RSNCD` | `DECIMAL(5:0)` | reasonCode | | | `REQID` | `REQID` | `CHAR(48)` | requestID | | | `REQTK` | `REQTK` | `CHAR(256)` | request_Token | | | `MCHREFCD` | `MCHREFCD` | `CHAR(50)` | merchantReferenceCode | | | `FCTRCD` | `FCTRCD` | `CHAR(100)` | afsReply_afsFactorCode | | | `AFSRSLT` | `AFSRSLT` | `DECIMAL(2:0)` | afsReply_afsResult | | | `AFSRSNCD` | `AFSRSNCD` | `CHAR(5)` | afsReply_reasonCode | | | `CCAMT` | `CCAMT` | `CHAR(15)` | ccAuthReply_amount | | | `CCATHCD` | `CCATHCD` | `CHAR(7)` | ccAuthReply_authorizationCode | | | `CCATHDT` | `CCATHDT` | `CHAR(20)` | ccAuthReply_authorizedDateTime | | | `CCAVSCD` | `CCAVSCD` | `CHAR(1)` | ccAuthReply_avsCode | | | `CCAVSCDR` | `CCAVSCDR` | `CHAR(10)` | ccAuthReply_avsCodeRaw | | | `CCCVCD` | `CCCVCD` | `CHAR(1)` | ccAuthReply_cvCode | | | `CCRSNCD` | `CCRSNCD` | `CHAR(5)` | ccAuthReply_reasonCode | | | `CCRECID` | `CCRECID` | `CHAR(60)` | ccAuthReply_reconciliationID | | | `CCPRCRSP` | `CCPRCRSP` | `CHAR(60)` | ccAuthReply_processorResponse | | | `ADRTYP` | `ADRTYP` | `CHAR(5)` | davReply_addressType | | | `CAERRINF` | `CAERRINF` | `CHAR(4)` | davReply_caErrorInfo | | | `CAIN` | `CAIN` | `CHAR(10)` | davReply_caInfo | | | `MCHSCR` | `MCHSCR` | `DECIMAL(1:0)` | davReply_matchScore | | | `DRRSNCD` | `DRRSNCD` | `DECIMAL(5:0)` | davReply_reasonCode | | | `STDADR1` | `STDADR1` | `CHAR(60)` | davReply_standardizedAddress1 | | | `STDADR2` | `STDADR2` | `CHAR(60)` | davReply_standardizedAddress2 | | | `STDCTY` | `STDCTY` | `CHAR(50)` | davReply_standardizedCity | | | `STDCNTRY` | `STDCNTRY` | `CHAR(2)` | davReply_standardizedISOCountry | | | `STDPSTCD` | `STDPSTCD` | `CHAR(10)` | davReply_standardizedPostalCode | | | `STDSTT` | `STDSTT` | `CHAR(2)` | davReply_standardizedState | | | `USERRINF` | `USERRINF` | `CHAR(4)` | davReply_usErrorInfo | | | `USINF` | `USINF` | `CHAR(10)` | davReply_usInfo | | | `CAPAMT` | `CAPAMT` | `CHAR(15)` | ccCaptureReply_amount | | | `CAPRSNCD` | `CAPRSNCD` | `DECIMAL(5:0)` | ccCaptureReply_reasonCode | | | `CAPRECID` | `CAPRECID` | `CHAR(60)` | ccCaptureReply_reconciliationID | | | `CAPREQDT` | `CAPREQDT` | `CHAR(26)` | ccCaptureReply_requestDateTime | | | `CAPPCHLVL3` | `CAPPCHLVL3` | `CHAR(1)` | ccCaptureReply_purchasingLevel3Enabled | | | `CRDAMT` | `CRDAMT` | `CHAR(15)` | ccCreditReply_amount | | | `CRDRSNCD` | `CRDRSNCD` | `DECIMAL(5:0)` | ccCreditReply_reasonCode | | | `CRDRECID` | `CRDRECID` | `CHAR(60)` | ccCreditReply_reconciliationID | | | `VDAMT` | `VDAMT` | `CHAR(15)` | ccVoidReply_amount | | | `VDRSNCD` | `VDRSNCD` | `DECIMAL(5:0)` | ccVoidReply_reasonCode | | | `ALLHOLD` | `ALLHOLD` | `CHAR(2)` | Alliance_hold_code | | | `REVRSNCD` | `REVRSNCD` | `CHAR(5)` | ccAuthReversalReply_reasonCode | | | `REVAMT` | `REVAMT` | `CHAR(15)` | ccAuthReversalReply_amount | | | `REVATHCD` | `REVATHCD` | `CHAR(7)` | ccAuthReversalReply_authorizationCode | | | `REVREQDT` | `REVREQDT` | `CHAR(26)` | ccAuthReversalReply_authorizedDateTime | | | `REVPRCRSP` | `REVPRCRSP` | `CHAR(60)` | ccAuthReversalReply_processorResponse | | | `REVFWDCD` | `REVFWDCD` | `CHAR(32)` | ccAuthReversalReply_forwardCode | | | `PRSNCD` | `PRSNCD` | `DECIMAL(5:0)` | paySubXXXXXXReply_reasonCode | | | `PSUBID` | `PSUBID` | `CHAR(48)` | paySubXXXXXXReply_subscriptionID | | | `PCITY` | `PCITY` | `CHAR(50)` | paySubRetrieveReply_city | | | `PCMNTS` | `PCMNTS` | `CHAR(255)` | paySubRetrieveReply_comments | | | `PCNTRY` | `PCNTRY` | `CHAR(255)` | paySubRetrieveReply_country | | | `PCUR` | `PCUR` | `CHAR(5)` | paySubRetrieveReply_currency | | | `PCACTID` | `PCACTID` | `CHAR(5)` | paySubRetrieveReply_customerAccountID | | | `PEMAIL` | `PEMAIL` | `CHAR(255)` | paySubRetrieveReply_email | | | `PFNAME` | `PFNAME` | `CHAR(60)` | paySubRetrieveReply_firstName | | | `PFREQ` | `PFREQ` | `CHAR(20)` | paySubRetrieveReply_frequency | | | `PLNAME` | `PLNAME` | `CHAR(60)` | paySubRetrieveReply_lastName | | | `PDFLD1` | `PDFLD1` | `CHAR(64)` | paySubRetrieveReply_merchantDefinedDataField1 | | | `PDFLD2` | `PDFLD2` | `CHAR(64)` | paySubRetrieveReply_merchantDefinedDataField2 | | | `PDFLD3` | `PDFLD3` | `CHAR(64)` | paySubRetrieveReply_merchantDefinedDataField3 | | | `PDFLD4` | `PDFLD4` | `CHAR(64)` | paySubRetrieveReply_merchantDefinedDataField4 | | | `PMREFCD` | `PMREFCD` | `CHAR(50)` | paySubRetrieveReply_merchantReferenceCode | | | `PSFLD1` | `PSFLD1` | `CHAR(64)` | paySubRetrieveReply_merchantSecureDataField1 | | | `PSFLD2` | `PSFLD2` | `CHAR(64)` | paySubRetrieveReply_merchantSecureDataField2 | | | `PSFLD3` | `PSFLD3` | `CHAR(64)` | paySubRetrieveReply_merchantSecureDataField3 | | | `PSFLD4` | `PSFLD4` | `CHAR(2000)` | paySubRetrieveReply_merchantSecureDataField4 | | | `PPHNNBR` | `PPHNNBR` | `CHAR(20)` | paySubRetrieveReply_phoneNumber | | | `PPOSTCD` | `PPOSTCD` | `CHAR(10)` | paySubRetrieveReply_postalCode | | | `PRECURAMT` | `PRECURAMT` | `CHAR(15)` | paySubRetrieveReply_recurringAmount | | | `PSETUPAMT` | `PSETUPAMT` | `CHAR(15)` | paySubRetrieveReply_setupAmount | | | `PSTCITY` | `PSTCITY` | `CHAR(50)` | paySubRetrieveReply_shipToCity | | | `PSTCMPNY` | `PSTCMPNY` | `CHAR(60)` | paySubRetrieveReply_shipToCompany | | | `PSTCNTRY` | `PSTCNTRY` | `CHAR(2)` | paySubRetrieveReply_shipToCountry | | | `PSTFNAME` | `PSTFNAME` | `CHAR(60)` | paySubRetrieveReply_shipToFirstName | | | `PSTLNAME` | `PSTLNAME` | `CHAR(60)` | paySubRetrieveReply_shipToLastName | | | `PSTPOSTCD` | `PSTPOSTCD` | `CHAR(10)` | paySubRetrieveReply_shipToPostalCode | | | `PSTSTATE` | `PSTSTATE` | `CHAR(2)` | paySubRetrieveReply_shipToState | | | `PSTSTR1` | `PSTSTR1` | `CHAR(60)` | paySubRetrieveReply_shipToStreet1 | | | `PSTSTR2` | `PSTSTR2` | `CHAR(60)` | paySubRetrieveReply_shipToStreet2 | | | `PSTATE` | `PSTATE` | `CHAR(2)` | paySubRetrieveReply_state | | | `PSTATUS` | `PSTATUS` | `CHAR(9)` | paySubRetrieveReply_status | | | `PSTREET1` | `PSTREET1` | `CHAR(60)` | paySubRetrieveReply_street1 | | | `PSTREET2` | `PSTREET2` | `CHAR(60)` | paySubRetrieveReply_street2 | | | `PTITLE` | `PTITLE` | `CHAR(60)` | paySubRetrieveReply_title | | | `PCDACTNBR` | `PCDACTNBR` | `CHAR(20)` | paySubRetrieveReply_cardAccountNumber | | | `PCDEXPMON` | `PCDEXPMON` | `CHAR(2)` | paySubRetrieveReply_cardExpirationMonth | | | `PCDEXPYR` | `PCDEXPYR` | `CHAR(4)` | paySubRetrieveReply_cardExpirationYear | | | `PCDTYPE` | `PCDTYPE` | `CHAR(3)` | paySubRetrieveReply_cardType | | | `PPRSNCD` | `PPRSNCD` | `CHAR(5)` | paypal_reasonCode | | | `PPATHID` | `PPATHID` | `CHAR(19)` | paypal_authorizationId | | | `PPTRNID` | `PPTRNID` | `CHAR(19)` | paypal_transactionId | | | `PPPTID` | `PPPTID` | `CHAR(19)` | paypal_parentTransactionId | | | `PPTRNTYP` | `PPTRNTYP` | `CHAR(15)` | paypalTransactiontype | | | `PPPMTTYP` | `PPPMTTYP` | `CHAR(7)` | paypalPaymentType | | | `PPORDTM` | `PPORDTM` | `CHAR(20)` | paypalOrderTime | | | `PPGRSAMT` | `PPGRSAMT` | `CHAR(15)` | paypalPaymentGrossAmount | | | `PPFEEAMT` | `PPFEEAMT` | `CHAR(9)` | paypalFeeAmount | | | `PPTAXAMT` | `PPTAXAMT` | `CHAR(15)` | paypalTaxAmount | | | `PPPMTSTS` | `PPPMTSTS` | `CHAR(20)` | paypalPaymentStatus | | | `PPAMT` | `PPAMT` | `CHAR(15)` | paypal_amount | | | `PPCCY` | `PPCCY` | `CHAR(3)` | paypal_currency | | | `PROFILE` | `PROFILE` | `CHAR(30)` | active_profile | | | `EXPRSNCD` | `EXPRSNCD` | `CHAR(5)` | expcompl_reasonCode | | | `LVL3ELG` | `LVL3ELG` | `CHAR(1)` | ccAuthReply_cardLevel3Eligible | | | `PAPRREC` | `PAPRREC` | `CHAR(5)` | paySubRetrieveReply_approvalRequired | | | `PTOTPMTS` | `PTOTPMTS` | `DECIMAL(3:0)` | paySubRetrieveReply_totalPayments | | | `PAUTORNW` | `PAUTORNW` | `CHAR(5)` | paySubRetrieveReply_automaticRenew | | | `PBILLPAY` | `PBILLPAY` | `CHAR(1)` | paySubRetrieveReply_billPayment | | | `PCDISSNBR` | `PCDISSNBR` | `CHAR(5)` | paySubRetrieveReply_cardIssueNumber | | | `PCDSTMON` | `PCDSTMON` | `CHAR(2)` | paySubRetrieveReply_cardStartMonth | | | `PCDSTYR` | `PCDSTYR` | `CHAR(4)` | paySubRetrieveReply_cardStartYear | | | `PCKACTNBR` | `PCKACTNBR` | `CHAR(17)` | paySubRetrieveReply_checkAccountNumber | | | `PCKACTTYP` | `PCKACTTYP` | `CHAR(1)` | paySubRetrieveReply_checkAccountType | | | `PCKAUTID` | `PCKAUTID` | `CHAR(32)` | paySubRetrieveReply_checkAuthenticateID | | | `PCKRTNBR` | `PCKRTNBR` | `CHAR(9)` | paySubRetrieveReply_checkBankTransitNum | | | `PCKSECCD` | `PCKSECCD` | `CHAR(3)` | paySubRetrieveReply_checkSecCode | | | `PCMPNAM` | `PCMPNAM` | `CHAR(40)` | paySubRetrieveReply_companyName | | | `PCMPTXID` | `PCMPTXID` | `CHAR(9)` | paySubRetrieveReply_companyTaxID | | | `PDOB` | `PDOB` | `CHAR(10)` | paySubRetrieveReply_dateOfBirth | | | `PDLNBR` | `PDLNBR` | `CHAR(30)` | paySubRetrieveReply_driversLicenseNumbe | | | `PDLSTT` | `PDLSTT` | `CHAR(2)` | paySubRetrieveReply_driversLicenseState | | | `PENDDT` | `PENDDT` | `CHAR(8)` | paySubRetrieveReply_endDate | | | `PMCHREFCD` | `PMCHREFCD` | `CHAR(50)` | paySubRetrieveReply_merchantReferenceCode | | | `POMCHID` | `POMCHID` | `CHAR(30)` | paySubRetrieveReply_ownerMerchantID | | | `PSTRDT` | `PSTRDT` | `CHAR(8)` | paySubRetrieveReply_startDate | | | `PSUBIDNEW` | `PSUBIDNEW` | `CHAR(16)` | paySubRetrieveReply_subscriptionIDNew | | | `PTCURR` | `PTCURR` | `CHAR(5)` | purchaseTotals_currency | | | `VDCURR` | `VDCURR` | `CHAR(5)` | voidReply_currency | | | `VDREQDTTM` | `VDREQDTTM` | `CHAR(20)` | voidReply_requestDateTime | | | `ECATHCKSUM` | `ECATHCKSUM` | `CHAR(600)` | ecAuthenticateReply_checkpointSummary | | | `ECATHFDSHD` | `ECATHFDSHD` | `CHAR(300)` | ecAuthenticateReply_fraudShieldIndicators | | | `ECATHPRRSP` | `ECATHPRRSP` | `CHAR(6)` | ecAuthenticateReply_processorResponse | | | `ECATHRSNCD` | `ECATHRSNCD` | `CHAR(5)` | ecAuthenticateReply_reasonCode | | | `ECATHRECID` | `ECATHRECID` | `CHAR(60)` | ecAuthenticateReply_reconciliationID | | | `ECATHDTTM` | `ECATHDTTM` | `CHAR(20)` | ecAuthenticateReply_requestDateTime | | | `ECCRAMT` | `ECCRAMT` | `CHAR(15)` | ecCreditReply_amount | | | `ECCRCACNBR` | `ECCRCACNBR` | `CHAR(17)` | ecCreditReply_correctedAccountNumber | | | `ECCRCRTNBR` | `ECCRCRTNBR` | `CHAR(9)` | ecCreditReply_correctedRoutingNumber | | | `ECCROMCHID` | `ECCROMCHID` | `CHAR(30)` | ecCreditReply_ownerMerchantID | | | `ECCRPRRSP` | `ECCRPRRSP` | `CHAR(6)` | ecCreditReply_processorResponse | | | `ECCRPRTRID` | `ECCRPRTRID` | `CHAR(87)` | ecCreditReply_processorTransactionID | | | `ECCRRSNCD` | `ECCRRSNCD` | `CHAR(5)` | ecCreditReply_reasonCode | | | `ECCRRECID` | `ECCRRECID` | `CHAR(60)` | ecCreditReply_reconciliationID | | | `ECCRDTTM` | `ECCRDTTM` | `CHAR(20)` | ecCreditReply_requestDateTime | | | `ECCRSTLMD` | `ECCRSTLMD` | `CHAR(1)` | ecCreditReply_settlementMethod | | | `ECCRVERCD` | `ECCRVERCD` | `CHAR(2)` | ecCreditReply_verificationCode | | | `ECCRVERCDR` | `ECCRVERCDR` | `CHAR(2)` | ecCreditReply_verificationCodeRaw | | | `ECDBAMT` | `ECDBAMT` | `CHAR(15)` | ecDebitReply_amount | | | `ECDBCACNBR` | `ECDBCACNBR` | `CHAR(17)` | ecDebitReply_correctedAccountNumber | | | `ECDBCRTNBR` | `ECDBCRTNBR` | `CHAR(9)` | ecDebitReply_correctedRoutingNumber | | | `ECDBOMCHID` | `ECDBOMCHID` | `CHAR(30)` | ecDebitReply_ownerMerchantID | | | `ECDBPRRSP` | `ECDBPRRSP` | `CHAR(6)` | ecDebitReply_processorResponse | | | `ECDBPRTRID` | `ECDBPRTRID` | `CHAR(87)` | ecDebitReply_processorTransactionID | | | `ECDBRSNCD` | `ECDBRSNCD` | `CHAR(5)` | ecDebitReply_reasonCode | | | `ECDBRECID` | `ECDBRECID` | `CHAR(60)` | ecDebitReply_reconciliationID | | | `ECDBDTTM` | `ECDBDTTM` | `CHAR(20)` | ecDebitReply_requestDateTime | | | `ECDBSTLMD` | `ECDBSTLMD` | `CHAR(1)` | ecDebitReply_settlementMethod | | | `ECDBVERID` | `ECDBVERID` | `CHAR(2)` | ecDebitReply_verificationCode | | | `ECDBVERIDR` | `ECDBVERIDR` | `CHAR(2)` | ecDebitReply_verificationCodeRaw | | | `ECDBDBRQID` | `ECDBDBRQID` | `CHAR(48)` | ecDebitService_debitRequestID | | | `ECSAMT` | `ECSAMT` | `CHAR(15)` | payPalEcOrderSetupReply_amount | | | `ECSCUR` | `ECSCUR` | `CHAR(3)` | payPalEcOrderSetupReply_currency | | | `ECSPMTTYP` | `ECSPMTTYP` | `CHAR(7)` | payPalEcOrderSetupReply_paymentType | | | `ECSPAMT` | `ECSPAMT` | `CHAR(15)` | payPalEcOrderSetupReply_paypalAmount | | | `ECSPEXRT` | `ECSPEXRT` | `CHAR(17)` | payPalEcOrderSetupReply_paypalExchangeRate | | | `ECSPFAMT` | `ECSPFAMT` | `CHAR(9)` | payPalEcOrderSetupReply_paypalFeeAmount | | | `ECSPORDTM` | `ECSPORDTM` | `CHAR(20)` | payPalEcOrderSetupReply_paypalOrderTime | | | `ECSPPMTSTS` | `ECSPPMTSTS` | `CHAR(20)` | payPalEcOrderSetupReply_paypalPaymentStatus | | | `ECSPPNDRSN` | `ECSPPNDRSN` | `CHAR(14)` | payPalEcOrderSetupReply_paypalPendingReason | | | `ECSPRSNCD` | `ECSPRSNCD` | `CHAR(15)` | payPalEcOrderSetupReply_paypalReasonCode | | | `ECSPTAXAMT` | `ECSPTAXAMT` | `CHAR(9)` | payPalEcOrderSetupReply_paypalTaxAmount | | | `ECSPTKN` | `ECSPTKN` | `CHAR(20)` | payPalEcOrderSetupReply_paypalToken | | | `ECSPTRNTYP` | `ECSPTRNTYP` | `CHAR(16)` | payPalEcOrderSetupReply_paypalTransactionType | | | `ECSTRNID` | `ECSTRNID` | `CHAR(17)` | payPalEcOrderSetupReply_transactionId | | | `PATAMT` | `PATAMT` | `CHAR(15)` | payPalAuthorizationReply_amount | | | `PATCUR` | `PATCUR` | `CHAR(3)` | payPalAuthorizationReply_currency | | | `PATPAMT` | `PATPAMT` | `CHAR(15)` | payPalAuthorizationReply_paypalAmount | | | `PATPRTELG` | `PATPRTELG` | `CHAR(17)` | payPalAuthorizationReply_protectionEligibility | | | `PATPRTTYP` | `PATPRTTYP` | `CHAR(32)` | payPalAuthorizationReply_protectionEligibilityType | | | `PATTRNID` | `PATTRNID` | `CHAR(17)` | payPalAuthorizationReply_transactionId | | | `PDRCUR` | `PDRCUR` | `CHAR(3)` | payPalDoRefTransactionReply_currency | | | `PDRPAMT` | `PDRPAMT` | `CHAR(15)` | payPalDoRefTransactionReply_paypalAmount | | | `PDRPBLAGID` | `PDRPBLAGID` | `CHAR(256)` | payPalDoRefTransactionReply_paypalBillingAgreement | | | `PDRPEXRT` | `PDRPEXRT` | `CHAR(17)` | payPalDoRefTransactionReply_paypalExchangeRate | | | `PDRPORDTM` | `PDRPORDTM` | `CHAR(20)` | payPalDoRefTransactionReply_paypalOrderTime | | | `PDRPPMTSTS` | `PDRPPMTSTS` | `CHAR(20)` | payPalDoRefTransactionReply_paypalPaymentStatus | | | `PDRPPMTTYP` | `PDRPPMTTYP` | `CHAR(7)` | payPalDoRefTransactionReply_paypalPaymentType | | | `PDRPPNDRSN` | `PDRPPNDRSN` | `CHAR(14)` | payPalDoRefTransactionReply_paypalPendingReason | | | `PDRPRSNCD` | `PDRPRSNCD` | `CHAR(15)` | payPalDoRefTransactionReply_paypalReasonCode | | | `PDRPTAXAMT` | `PDRPTAXAMT` | `CHAR(9)` | payPalDoRefTransactionReply_paypalTaxAmount | | | `PDRPTRNTYP` | `PDRPTRNTYP` | `CHAR(16)` | payPalDoRefTransactionReply_paypalTransactionType | | | `PDRTRNID` | `PDRTRNID` | `CHAR(17)` | payPalDoRefTransactionReply_transactionId | | | `PRSPFRAMT` | `PRSPFRAMT` | `CHAR(9)` | payPalRefundReply_paypalFeeRefundAmount | | | `PRSPGRAMT` | `PRSPGRAMT` | `CHAR(20)` | payPalRefundReply_paypalGrossRefundAmount | | | `PRSPNRAMT` | `PRSPNRAMT` | `CHAR(20)` | payPalRefundReply_paypalNetRefundAmount | | | `PRSTRNID` | `PRSTRNID` | `CHAR(17)` | payPalRefundReply_transactionId | | | `PCAPBLAGID` | `PCAPBLAGID` | `CHAR(256)` | payPalCreateAgreementReply_paypalBillingAgreement | | | `PARATHID` | `PARATHID` | `CHAR(19)` | payPalAuthReversalReply_authorizationId | | | `PDCAMT` | `PDCAMT` | `CHAR(15)` | payPalDoCaptureReply_amount | | | `PDCATHID` | `PDCATHID` | `CHAR(19)` | payPalDoCaptureReply_authorizationId | | | `PDCCUR` | `PDCCUR` | `CHAR(3)` | payPalDoCaptureReply_currency | | | `PDCPTRNID` | `PDCPTRNID` | `CHAR(17)` | payPalDoCaptureReply_parentTransactionId | | | `PDCPEXRT` | `PDCPEXRT` | `CHAR(17)` | payPalDoCaptureReply_paypalExchangeRate | | | `PDCPFAMT` | `PDCPFAMT` | `CHAR(9)` | payPalDoCaptureReply_paypalFeeAmount | | | `PDCPORDTM` | `PDCPORDTM` | `CHAR(20)` | payPalDoCaptureReply_paypalOrderTime | | | `PDCPPMTGRS` | `PDCPPMTGRS` | `CHAR(20)` | payPalDoCaptureReply_paypalPaymentGrossAmount | | | `PDCPPMTSTS` | `PDCPPMTSTS` | `CHAR(20)` | payPalDoCaptureReply_paypalPaymentStatus | | | `PDCPPMTTYP` | `PDCPPMTTYP` | `CHAR(7)` | payPalDoCaptureReply_paypalPaymentType | | | `PDCPPNDRSN` | `PDCPPNDRSN` | `CHAR(14)` | payPalDoCaptureReply_paypalPendingReason | | | `PDCPRECID` | `PDCPRECID` | `CHAR(16)` | payPalDoCaptureReply_paypalReceiptId | | | `PDCPTAXAMT` | `PDCPTAXAMT` | `CHAR(9)` | payPalDoCaptureReply_paypalTaxAmount | | | `PDCPTRNTYP` | `PDCPTRNTYP` | `CHAR(16)` | payPalDoCaptureReply_paypalTransactionType | | | `PDCTRNID` | `PDCTRNID` | `CHAR(17)` | payPalDoCaptureReply_transactionId | | | `PDCPRSNCD` | `PDCPRSNCD` | `CHAR(17)` | payPalDoCaptureReply_paypalReasonCode | | | `PUAADRSTS` | `PUAADRSTS` | `CHAR(12)` | payPalUpdateAgreementReply_addressStatus | | | `PUAPAY` | `PUAPAY` | `CHAR(127)` | payPalUpdateAgreementReply_payer | | | `PUAPAYBUS` | `PUAPAYBUS` | `CHAR(127)` | payPalUpdateAgreementReply_payerBusiness | | | `PUAPAYCTY` | `PUAPAYCTY` | `CHAR(2)` | payPalUpdateAgreementReply_payerCountry | | | `PUAPAYFNM` | `PUAPAYFNM` | `CHAR(25)` | payPalUpdateAgreementReply_payerFirstname | | | `PUAPAYID` | `PUAPAYID` | `CHAR(13)` | payPalUpdateAgreementReply_payerId | | | `PUAPAYLNM` | `PUAPAYLNM` | `CHAR(25)` | payPalUpdateAgreementReply_payerLastname | | | `PUAPAYMNM` | `PUAPAYMNM` | `CHAR(25)` | payPalUpdateAgreementReply_payerMiddlename | | | `PUAPAYSAL` | `PUAPAYSAL` | `CHAR(20)` | payPalUpdateAgreementReply_payerSalutation | | | `PUAPAYSTS` | `PUAPAYSTS` | `CHAR(10)` | payPalUpdateAgreementReply_payerStatus | | | `PUAPAYSFX` | `PUAPAYSFX` | `CHAR(12)` | payPalUpdateAgreementReply_payerSuffix | | | `PUAPBLAGCS` | `PUAPBLAGCS` | `CHAR(256)` | payPalUpdateAgreementReply_paypalBillAgreemntCst | | | `PUAPBLAGDS` | `PUAPBLAGDS` | `CHAR(127)` | payPalUpdateAgreementReply_paypalBillAgreemntDesc | | | `PUAPBLAGID` | `PUAPBLAGID` | `CHAR(256)` | payPalUpdateAgreementReply_paypalBillAgreemntId | | | `PUAPBLAGST` | `PUAPBLAGST` | `CHAR(8)` | payPalUpdateAgreementReply_paypalBillAgreemntSts | | | `CAVVCD` | `CAVVCD` | `CHAR(3)` | ccAuthReply_cavvResponseCode | | | `CAVVCDR` | `CAVVCDR` | `CHAR(3)` | ccAuthReply_cavvResponseCodeRaw | | | `EPTEXPMM` | `EPTEXPMM` | `CHAR(2)` | token_expirationMonth | | | `EPTEXPYY` | `EPTEXPYY` | `CHAR(4)` | token_expirationYear | | | `EPTPREF` | `EPTPREF` | `CHAR(6)` | token_prefix | | | `EPTSUFF` | `EPTSUFF` | `CHAR(4)` | token_suffix | | | `CRDTYP` | `CRDTYP` | `CHAR(3)` | card_cardType | | | `PAYNETTNID` | `PAYNETTNID` | `CHAR(15)` | ccAuthReply_paymentNetworkTransactionID | | | `CRDATHCD` | `CRDATHCD` | `CHAR(6)` | ccCreditReply_authorizationCode | | | `CRDNTTNID` | `CRDNTTNID` | `CHAR(15)` | ccCreditReply_paymentNetworkTransactionID | | | `CRDPRCRSP` | `CRDPRCRSP` | `CHAR(10)` | ccCreditReply_processorResponse | | | `VDATHRVRSP` | `VDATHRVRSP` | `CHAR(3)` | voidReply_creditAuthReversalResponse | | | `PSPMTMD` | `PSPMTMD` | `CHAR(20)` | paySubRetrieveReply_paymentMethod | | | `CCPIIRICAT` | `CCPIIRICAT` | `CHAR(60)` | ccAuthReply_paymentInsightsInfo_respInsightsCat | | | `CCPIIRICCD` | `CCPIIRICCD` | `CHAR(2)` | ccAuthReply_paymentInsightsInfo_respInsightsCatCd | | | `TRTOTCRTX` | `TRTOTCRTX` | `CHAR(15)` | taxReply_totalCountryTaxAmount | | | `TRRSNCD` | `TRRSNCD` | `DECIMAL(5:0)` | taxReply_reasonCode | | | `TRTOTSPCTX` | `TRTOTSPCTX` | `CHAR(15)` | taxReply_totalSpecialTaxAmount | | | `TRTOTTBAMT` | `TRTOTTBAMT` | `CHAR(15)` | taxReply_totalTaxableAmount | | | `TRTOTSTTX` | `TRTOTSTTX` | `CHAR(15)` | taxReply_totalStateTaxAmount | | | `TRTOTEXAMT` | `TRTOTEXAMT` | `CHAR(15)` | taxReply_totalExemptAmount | | | `TRGRTOTAMT` | `TRGRTOTAMT` | `CHAR(15)` | taxReply_grandTotalAmount | | | `TRTOTCTYTX` | `TRTOTCTYTX` | `CHAR(15)` | taxReply_totalCityTaxAmount | | | `TRTOTCNYTX` | `TRTOTCNYTX` | `CHAR(15)` | taxReply_totalCountyTaxAmount | | | `TRTOTTXAMT` | `TRTOTTXAMT` | `CHAR(15)` | taxReply_totalTaxAmount | | ### CTIWSARSP | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `UID` | `UNIQUEID` | `DECIMAL(15:0)` | Response Unique ID | | | `BILLAGID` | `APREPLY_BILLINGAGREEMENTID` | `CHAR(50)` | apReply_billingAgreementID | | | `FUNDINGSRC` | `APREPLY_FUNDINGSOURCE` | `CHAR(30)` | apReply_fundingSource | | | `ORDERID` | `APREPLY_ORDERID` | `CHAR(20)` | apReply_orderID | | | `PAYERID` | `APREPLY_PAYERID` | `CHAR(30)` | apReply_payerID | | | `PRCFRDDCN` | `APREPLY_PROCESSORFRAUDDECISION` | `CHAR(60)` | apReply_processorFraudDecision | | | `FRDDCNRSN` | `APREPLY_PROCESSORFRAUDDECISIONREASON` | `CHAR(60)` | apReply_processorFraudDecisionReason | | | `SLRPROTELG` | `APREPLY_SELLERPROTECTION_ELIGIBILITY` | `CHAR(60)` | apReply_sellerProtection_eligibilty | | | `SLRPROTTYP` | `APREPLY_SELLERPROTECTION_TYPE` | `CHAR(60)` | apReply_sellerProtection_type | | | `BTCITY` | `BILLTO_CITY` | `CHAR(50)` | billTo_city | | | `BTCNTRY` | `BILLTO_COUNTRY` | `CHAR(2)` | billTo_country | | | `BTEMAIL` | `BILLTO_EMAIL` | `CHAR(256)` | billTo_email | | | `BTFNAME` | `BILLTO_FIRSTNAME` | `CHAR(60)` | billTo_firstName | | | `BTLNAME` | `BILLTO_LASTNAME` | `CHAR(60)` | billTo_lastName | | | `BTPOSTCD` | `BILLTO_POSTALCODE` | `CHAR(10)` | billTo_postalCode | | | `BTSTATE` | `BILLTO_STATE` | `CHAR(2)` | billTo_state | | | `BTSTREET1` | `BILLTO_STREET1` | `CHAR(60)` | billTo_street1 | | | `BTSTREET2` | `BILLTO_STREET2` | `CHAR(60)` | billTo_street2 | | | `CSTVRFSTS` | `CUSTOMERVERIFICATIONSTATUS` | `CHAR(60)` | customerVerificationStatus | | | `STCITY` | `SHIPTO_CITY` | `CHAR(40)` | shipTo_city | | | `STCNTRY` | `SHIPTO_COUNTRY` | `CHAR(2)` | shipTo_country | | | `STFNAME` | `SHIPTO_FIRSTNAME` | `CHAR(60)` | shipTo_firstName | | | `STLNAME` | `SHIPTO_LASTNAME` | `CHAR(60)` | shipTo_lastName | | | `STPHONE` | `SHIPTO_PHONENUMBER` | `CHAR(20)` | shipTo_phoneNumber | | | `STPOSTCD` | `SHIPTO_POSTALCODE` | `CHAR(20)` | shipTo_postalCode | | | `STSTATE` | `SHIPTO_STATE` | `CHAR(40)` | shipTo_state | | | `STSTREET1` | `SHIPTO_STREET1` | `CHAR(100)` | shipTo_street1 | | | `STSTREET2` | `SHIPTO_STREET2` | `CHAR(100)` | shipTo_street2 | | | `SSNAMT` | `APSESSIONSREPLY_AMOUNT` | `CHAR(15)` | apSessionsReply_amount | | | `SSNDATTM` | `APSESSIONSREPLY_DATETIME` | `TIMESTAMP` | apSessionsReply_dateTime | | | `SSNMCHURL` | `APSESSIONSREPLY_MERCHANTURL` | `CHAR(255)` | apSessionsReply_merchantURL | | | `SSNPRCTID` | `APSESSIONSREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apSessionsReply_processorTransactionID | | | `SSNRSNCD` | `APSESSIONSREPLY_REASONCODE` | `DECIMAL(5:0)` | apSessionsReply_reasonCode | | | `SSNRECID` | `APSESSIONSREPLY_RECONCILIATIONID` | `CHAR(60)` | apSessionsReply_reconciliationID | | | `SSNRSPCD` | `APSESSIONSREPLY_RESPONSECODE` | `DECIMAL(5:0)` | apSessionsReply_responseCode | | | `SSNSTS` | `APSESSIONSREPLY_STATUS` | `CHAR(15)` | apSessionsReply_status | | | `STSRSNCD` | `APCHECKSTATUSREPLY_REASONCODE` | `DECIMAL(5:0)` | apCheckStatusReply_reasonCode | | | `STSDATTM` | `APCHECKSTATUSREPLY_DATETIME` | `TIMESTAMP` | apCheckStatusReply_dateTime | | | `STSPMTSTS` | `APCHECKSTATUSREPLY_PAYMENTSTATUS` | `CHAR(15)` | apCheckStatusReply_paymentStatus | | | `STSPRCRSP` | `APCHECKSTATUSREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apCheckStatusReply_processorResponse | | | `STSPRCTID` | `APCHECKSTATUSREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apCheckStatusReply_processorTransactionID | | | `STSRECID` | `APCHECKSTATUSREPLY_RECONCILIATIONID` | `CHAR(60)` | apCheckStatus Reply_reconciliationID | | | `ORDAMT` | `APORDERREPLY_AMOUNT` | `CHAR(15)` | apOrderReply_amount | | | `ORDDATTM` | `APORDERREPLY_DATETIME` | `TIMESTAMP` | apOrderReply_dateTime | | | `ORDPRCRSP` | `APORDERREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apOrderReply_processorResponse | | | `ORDRSNCD` | `APORDERREPLY_REASONCODE` | `DECIMAL(5:0)` | apOrderReply_reasonCode | | | `ORDRECID` | `APORDERREPLY_RECONCILIATIONID` | `CHAR(60)` | apOrderReply_reconciliationID | | | `ORDSTS` | `APORDERREPLY_STATUS` | `CHAR(60)` | apOrderReply_status | | | `ATHAMT` | `APAUTHREPLY_AMOUNT` | `CHAR(15)` | apAuthReply_amount | | | `ATHDATTM` | `APAUTHREPLY_DATETIME` | `TIMESTAMP` | apAuthReply_dateTime | | | `ATHPMTSTS` | `APAUTHREPLY_PAYMENTSTATUS` | `CHAR(15)` | apAuthReply_paymentStatus | | | `ATHPRCRSP` | `APAUTHREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apAuthReply_processorResponse | | | `ATHPRCTID` | `APAUTHREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apAuthReply_processorTransactionID | | | `ATHRSNCD` | `APAUTHREPLY_REASONCODE` | `DECIMAL(5:0)` | apAuthReply_reasonCode | | | `ATHRECID` | `APAUTHREPLY_RECONCILIATIONID` | `CHAR(60)` | apAuthReply_reconciliationID | | | `ATHRSPCD` | `APAUTHREPLY_RESPONSECODE` | `DECIMAL(5:0)` | apAuthReply_responseCode | | | `REVAMT` | `APAUTHREVERSALREPLY_AMOUNT` | `CHAR(15)` | apAuthReversalReply_amount | | | `REVDATTM` | `APAUTHREVERSALREPLY_DATETIME` | `TIMESTAMP` | apAuthReversalReply_dateTime | | | `REVPMTSTS` | `APAUTHREVERSALREPLY_PAYMENTSTATUS` | `CHAR(15)` | apAuthReversalReply_paymentStatus | | | `REVPRCTID` | `APAUTHREVERSALREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apAuthReversalReply_processorTransactionID | | | `REVRSNCD` | `APAUTHREVERSALREPLY_REASONCODE` | `DECIMAL(5:0)` | apAuthReversalReply_reasonCode | | | `REVRECID` | `APAUTHREVERSALREPLY_RECONCILIATIONID` | `CHAR(60)` | apAuthReversalReply_reconciliationID | | | `REVRSPCD` | `APAUTHREVERSALREPLY_RESPONSECODE` | `DECIMAL(5:0)` | apAuthReversalReply_responseCode | | | `CAPRSNCD` | `APCAPTUREREPLY_REASONCODE` | `DECIMAL(5:0)` | apCaptureReply_reasonCode | | | `CAPDATTM` | `APCAPTUREREPLY_DATETIME` | `TIMESTAMP` | apCaptureReply_dateTime | | | `CAPPMTSTS` | `APCAPTUREREPLY_PAYMENTSTATUS` | `CHAR(15)` | apCaptureReply_paymentStatus | | | `CAPPRCRSP` | `APCAPTUREREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apCaptureReply_processorResponse | | | `CAPPRCTFEE` | `APCAPTUREREPLY_PROCESSORTRANSACTIONFEE` | `CHAR(15)` | apCaptureReply_processorTransactionFee | | | `CAPPRCTID` | `APCAPTUREREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apCaptureReply_processorTransactionID | | | `CAPRECID` | `APCAPTUREREPLY_RECONCILIATIONID` | `CHAR(60)` | apCaptureReply_reconciliationID | | | `SALAMT` | `APSALEREPLY_AMOUNT` | `CHAR(15)` | apSaleReply_amount | | | `SALDATTM` | `APSALEREPLY_DATETIME` | `TIMESTAMP` | apSaleReply_dateTime | | | `SALPMTSTS` | `APSALEREPLY_PAYMENTSTATUS` | `CHAR(15)` | apSaleReply_paymentStatus | | | `SALPRCRSP` | `APSALEREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apSaleReply_processor Response | | | `SALPRCTFEE` | `APSALEREPLY_PROCESSORTRANSACTIONFEE` | `CHAR(15)` | apSaleReply_processorTransactionFee | | | `SALPRCTID` | `APSALEREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apSaleReply_processorTransactionID | | | `SALRSNCD` | `APSALEREPLY_REASONCODE` | `DECIMAL(5:0)` | apSaleReply_reasonCode | | | `SALRECID` | `APSALEREPLY_RECONCILIATIONID` | `CHAR(60)` | apSaleReply_reconciliationID | | | `REFDATTM` | `APREFUNDREPLY_DATETIME` | `TIMESTAMP` | apRefundReply_dateTime | | | `REFPMTSTS` | `APREFUNDREPLY_PAYMENTSTATUS` | `CHAR(15)` | apRefundReply_paymentStatus | | | `REFPRCRSP` | `APREFUNDREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apRefundReply_processorResponse | | | `REFPRCTID` | `APREFUNDREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apRefundReply_processorTransactionID | | | `REFRSNCD` | `APREFUNDREPLY_REASONCODE` | `DECIMAL(5:0)` | apRefundReply_reasonCode | | | `REFRECID` | `APREFUNDREPLY_RECONCILIATIONID` | `CHAR(60)` | apRefundReply_reconciliationID | | | `CNLDATTM` | `APCANCELREPLY_DATETIME` | `TIMESTAMP` | apCancelReply_dateTime | | | `CNLPRCRSP` | `APCANCELREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apCancelReply_processorResponse | | | `CNLPRCTID` | `APCANCELREPLY_PROCESSORTRANSACTIONID` | `CHAR(50)` | apCancelReply_processorTransactionID | | | `CNLRSNCD` | `APCANCELREPLY_REASONCODE` | `DECIMAL(5:0)` | apCancelReply_reasonCode | | | `CNLRECID` | `APCANCELREPLY_RECONCILIATIONID` | `CHAR(60)` | apCancelReply_reconciliationID | | | `CNLSTS` | `APCANCELREPLY_STATUS` | `CHAR(60)` | apCancelReply_status | | | `BAGPRCRSP` | `APBILLINGAGREEMENTREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apBillingAgreementReply_processorResponse | | | `BAGRSNCD` | `APBILLINGAGREEMENTREPLY_REASONCODE` | `DECIMAL(5:0)` | apBillingAgreementReply_reasonCode | | | `BAGSTS` | `APBILLINGAGREEMENTREPLY_STATUS` | `CHAR(60)` | apBillingAgreementReply_status | | | `SSNPRCTK` | `APSESSIONSREPLY_PROCESSORTOKEN` | `CHAR(60)` | apSessionsReply_processorToken | | | `STSTRNID` | `APCHECKSTATUSREPLY_TRANSACTIONID` | `CHAR(16)` | apCheckStatusReply_transactionID | | | `STSSTS` | `APCHECKSTATUSREPLY_STATUS` | `CHAR(60)` | apCheckStatusReply_status | | | `ATHMCHURL` | `APAUTHREPLY_MERCHANTURL` | `CHAR(2048)` | apAuthReply_merchantURL | | | `ATHSTS` | `APAUTHREPLY_STATUS` | `CHAR(60)` | apAuthReply_status | | | `REVPRCRSP` | `APAUTHREVERSALREPLY_PROCESSORRESPONSE` | `CHAR(60)` | apAuthReversalReply_processorResponse | | | `REVSTS` | `APAUTHREVERSALREPLY_STATUS` | `CHAR(60)` | apAuthReversalReply_status | | | `CAPRSPCD` | `APCAPTUREREPLY_RESPONSECODE` | `DECIMAL(5:0)` | apCaptureReply_responseCode | | | `CAPAMT` | `APCAPTUREREPLY_AMOUNT` | `CHAR(15)` | apCaptureReply_amount | | | `CAPSTS` | `APCAPTUREREPLY_STATUS` | `CHAR(60)` | apCaptureReply_status | | | `REFRSPCD` | `APREFUNDREPLY_RESPONSECODE` | `DECIMAL(5:0)` | apRefundReply_responseCode | | | `REFAMT` | `APREFUNDREPLY_AMOUNT` | `CHAR(15)` | apRefundReply_amount | | | `REFTRNID` | `APREFUNDREPLY_TRANSACTIONID` | `CHAR(16)` | apRefundReply_transactionID | | | `REFSTS` | `APREFUNDREPLY_STATUS` | `CHAR(60)` | apRefundReply_status | | ### CTIWSTRIT | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PARENT_UNIQUEID` | `DECIMAL(15:0)` | Request Unique ID | | | `ITEMID` | `ITEMID` | `DECIMAL(15:0)` | Item Unique ID | | | `CRTDT` | `TIMESTAMP` | `TIMESTAMP` | Response Timestamp | | | `TXBAMT` | `TAXABLEAMOUNT` | `CHAR(15)` | taxReply_item_#_taxableAmount | | | `EXMPAMT` | `EXEMPTAMOUNT` | `CHAR(15)` | taxReply_item_#_exemptAmount | | | `SPCTXAMT` | `SPECIALTAXAMOUNT` | `CHAR(15)` | taxReply_item_#_specialtaxAmount | | | `CTYTXAMT` | `CITYTAXAMOUNT` | `CHAR(15)` | taxReply_item_#_cityTaxAmount | | | `DSTTXAMT` | `DISTRICTTAXAMOUNT` | `CHAR(15)` | taxReply_item_#_districtTaxAmount | | | `CNYTXAMT` | `COUNTYTAXAMOUNT` | `CHAR(15)` | taxReply_item_#_countyTaxAmount | | | `STTTXAMT` | `STATETAXAMOUNT` | `CHAR(15)` | taxReply_item_#_stateTaxAmount | | | `CTRYTXAMT` | `COUNTRYTAXAMOUNT` | `CHAR(15)` | taxReply_item_#_countryTaxAmount | | | `TOTTXAMT` | `TOTALTAXAMOUNT` | `CHAR(15)` | taxReply_item_#_totalTaxAmount | | ### CTIWSTRJD | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PARENT_UNIQUEID` | `DECIMAL(15:0)` | Request Unique ID | | | `ITEMID` | `ITEMID` | `DECIMAL(15:0)` | Item Unique ID | | | `JDID` | `JURISDICTIONID` | `DECIMAL(15:0)` | Jurisdiction Unique ID | | | `CRTDT` | `TIMESTAMP` | `TIMESTAMP` | Response Timestamp | | | `COUNTRY` | `COUNTRY` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_country | | | `REGION` | `REGION` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_region | | | `TYPE` | `TYPE` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_type | | | `CODE` | `CODE` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_code | | | `TAXABLE` | `TAXABLE` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_taxable | | | `RATE` | `RATE` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_rate | | | `TAXAMT` | `TAXAMT` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_taxAmount | | | `NAME` | `NAME` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_name | | | `TAXNAME` | `TAXNAME` | `CHAR(15)` | taxReply_item_#_jurisdiction_#_taxName | | --- # CTI_NextUniqueId() > Generates a unique identifier required as a primary key for CTI API requests and DB2 physical file records. This subprocedure is used to generate a unique identifier for your request to CyberSource web services. The generated unique ID is also used as a primary key in several DB2 physical files. ## Subprocedure Prototype ```rpgle // Returns a unique numeric value. D CTI_NextUniqueId... D PR Extproc('CTI_NextUniqueId') D Like(CTI_UniqueId_t) ``` --- # CTI_DownloadReport() > Downloads CyberSource batch detail or exception detail reports from the REST reporting API to the IFS, using credentials stored in CTICFGRPT. This subprocedure is used to download a report from the CyberSource REST reporting APIs. This subprocedure requires a record for your merchant ID in CTICFGRPT, and you must populate the record with a shared and secret key pair for use with CyberSource's HTTP Signature Authentication. For more information on generating these keys, please see this guide from CyberSource: [Create a Shared Secret Key for HTTP Signature Authentication](https://developer.cybersource.com/api/developer-guides/dita-gettingstarted/authentication/createSharedKey.html) The [ADDRPTKEY](https://isupport.katointegrations.com/cti/addrptkey.md) command can be used to easily create a record for your merchant ID and generated security keys in CTICFGRPT. The report will be downloaded to an IFS file in the download directory specified in your CTICFGMCH record. For the CTI_REPORT_BATCHDETAIL and CTI_REPORT_EXCEPTIONDETAIL reports, this file can be parsed with the corresponding parsing subprocedure. If you are downloading a custom report, please reach out to our support team at isupport@katointegrations.com for guidance on parsing the downloaded report. 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 ```rpgle // Returns *OFF if an error occurs during processing, *ON otherwise. D CTI_DownloadReport... D PR N Extproc('CTI_DownloadReport') // Unique ID generated with CTI_NextUniqueID() // Required D pUniqueId Const Like(CTI_UniqueId_t) // A data structure containing configuration information for the report to // be downloaded // Required D pDownloadReportDS... D LikeDS(CTI_DownloadReportDS_t) // Error data structure used to capture subprocedure and CyberSource errors // Required D pErrorDS LikeDS(CTI_ErrorDS_t) ``` ## Data Structures ### CTI_DownloadReportDS_t ```rpgle D CTI_DownloadReportDS_t... D DS Qualified Template Inz // Merchant ID used to process the transaction // Required D MerchantId Like(CTI_MerchantId_t) // CyberSource environment where the report will be retrieved from // Required // Valid values: CTI_ENV_PROD, CTI_ENV_TEST D Environment 5A // Unique label to identify the security key in CTICFGRPT to be used // Default: CTI_DEFAULT D KeyLabel 50A Varying Inz(CTI_DEFAULT) // Organization under which the report was generated in the CyberSource // business center D OrganizationId... D Like(CTI_MerchantId_t) // Name of the report to be downloaded. This can be one of the pre-defined // constants, or any custom report name // Valid values: CTI_REPORT_BATCHDETAIL, CTI_REPORT_EXCEPTIONDETAIL, text D ReportName Like(CTI_ReportName_t) // End date for the report D ReportDate D // Name of the file where the report will be downloaded. This file will be // saved in the default download directory set for the specified merchant // ID in CTICFGMCH D Filepath Like(CTI_FilePath_t) ``` ### CTI_ErrorDS_t ```rpgle D CTI_ErrorDS_t DS Qualified Template Inz // Name of subprocedure returning error D Subproc 132A Varying // Message ID of error message D MessageId 7A // Error message text D Message 1024A Varying // Error message source D Source 10A // IFS filepath of generated log file D LogFile Like(CTI_FilePath_t) ``` ## Input Table Files ### CTICFGRPT | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID | | | `ENV` | `ENVIRONMENT` | `VARCHAR(5)` | CyberSource Environment | | | `KEYLABEL` | `KEYLABEL` | `VARCHAR(50)` | Key Label | | | `SHAREDKEY` | `SHAREDKEY` | `VARCHAR(36)` | Shared Key | | | `SECRETKEY` | `SECRETKEY` | `VARCHAR(50)` | Secret Key | | --- # CTI_QueryTransaction() > Queries CyberSource transactions via the REST Transaction Query API using HTTP Signature Authentication, downloading the response for parsing. This subprocedure is used to query a transaction using the CyberSource REST Transaction Query API. This subprocedure requires a record for your merchant ID in CTICFGRPT, and you must populate the record with a shared and secret key pair for use with CyberSource's HTTP Signature Authentication. For more information on generating these keys, please see this guide from CyberSource: [Create a Shared Secret Key for HTTP Signature Authentication](https://developer.cybersource.com/api/developer-guides/dita-gettingstarted/authentication/createSharedKey.html) The [ADDRPTKEY](https://isupport.katointegrations.com/cti/addrptkey.md) command can be used to easily create a record for your merchant ID and generated security keys in CTICFGRPT. The query response will be downloaded to an IFS file in the download directory specified in your CTICFGMCH record. This file can be parsed with the [CTI_ParseTransactionQuery()](https://isupport.katointegrations.com/cti/cti_parsetransactionquery.md) subprocedure. 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 ```rpgle // Returns *OFF if an error occurs during processing, *ON otherwise. D CTI_QueryTransaction... D PR N Extproc('CTI_QueryTransaction') // Unique ID generated with CTI_NextUniqueID() // Required D pUniqueId Const Like(CTI_UniqueId_t) // A data structure containing configuration information for the query to // be performed // Required D pQueryTransactionDS... D LikeDS(CTI_QueryTransactionDS_t) // Error data structure used to capture subprocedure and CyberSource errors // Required D pErrorDS LikeDS(CTI_ErrorDS_t) ``` ## Data Structures ### CTI_QueryTransactionDS_t ```rpgle D CTI_QueryTransactionDS_t... D DS Qualified Template Inz // Merchant ID used to process the transaction // Required D MerchantId Like(CTI_MerchantId_t) // CyberSource environment where the report will be retrieved from // Required // Valid values: CTI_ENV_PROD, CTI_ENV_TEST D Environment 5A // Unique label to identify the security key in CTICFGRPT to be used // Default: CTI_DEFAULT D KeyLabel 50A Varying // CyberSource unique identifier for the transaction to be queried D TransactionId 50A Varying // Name of the file where the report will be downloaded. This file will be // saved in the default download directory set for the specified merchant // ID in CTICFGMCH D Filepath Like(CTI_FilePath_t) ``` ### CTI_ErrorDS_t ```rpgle D CTI_ErrorDS_t DS Qualified Template Inz // Name of subprocedure returning error D Subproc 132A Varying // Message ID of error message D MessageId 7A // Error message text D Message 1024A Varying // Error message source D Source 10A // IFS filepath of generated log file D LogFile Like(CTI_FilePath_t) ``` ## Input Table Files ### CTICFGRPT | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID | | | `ENV` | `ENVIRONMENT` | `VARCHAR(5)` | CyberSource Environment | | | `KEYLABEL` | `KEYLABEL` | `VARCHAR(50)` | Key Label | | | `SHAREDKEY` | `SHAREDKEY` | `VARCHAR(36)` | Shared Key | | | `SECRETKEY` | `SECRETKEY` | `VARCHAR(50)` | Secret Key | | --- # CTI_ParseBatchDetailReport() > Parses a downloaded CyberSource batch detail report into the CTIBDR output table for temporary in-program access to transaction data. 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()](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 ```rpgle // Returns *OFF if an error occurs during processing, *ON otherwise. D CTI_ParseBatchDetailReport... D PR N Extproc('CTI_ParseBatchDetailReport') // Unique ID, generated with CTI_NextUniqueID(), that will be used to // identify the parsed records from this file // Required D pUniqueId Const Like(CTI_UniqueId_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 pReportFile Const Like(CTI_FilePath_t) // Error data structure used to capture subprocedure and CyberSource errors // Required D pErrorDS LikeDS(CTI_ErrorDS_t) ``` ## Data Structures ### CTI_ErrorDS_t ```rpgle D CTI_ErrorDS_t DS Qualified Template Inz // Name of subprocedure returning error D Subproc 132A Varying // Message ID of error message D MessageId 7A // Error message text D Message 1024A Varying // Error message source D Source 10A // IFS filepath of generated log file D LogFile Like(CTI_FilePath_t) ``` ## Output Table Files ### CTIBDR | 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 | | ### CTIBDRAPR | 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 | | ### CTIBDRINF | 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 | | ### CTIBDRLIN | 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 | | ### CTIBDRMDD | 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)` | | | ### CTIBDRPMT | 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 | | ### CTIBDRPRF | 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 | | --- # CTI_ParseExceptionDetailReport() > Parses a downloaded CyberSource exception detail report into the CTIEDR output table for temporary in-program access to exception data. 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 ```rpgle // Returns *OFF if an error occurs during processing, *ON otherwise. D CTI_ParseExceptionDetailReport... D PR N Extproc('CTI_ParseExceptionDetailRep- D ort') // Unique ID, generated with CTI_NextUniqueID(), that will be used to // identify the parsed records from this file // Required D pUniqueId Const Like(CTI_UniqueId_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 pReportFile Const Like(CTI_FilePath_t) // Error data structure used to capture subprocedure and CyberSource errors // Required D pErrorDS LikeDS(CTI_ErrorDS_t) ``` ## Data Structures ### CTI_ErrorDS_t ```rpgle D CTI_ErrorDS_t DS Qualified Template Inz // Name of subprocedure returning error D Subproc 132A Varying // Message ID of error message D MessageId 7A // Error message text D Message 1024A Varying // Error message source D Source 10A // IFS filepath of generated log file D LogFile Like(CTI_FilePath_t) ``` ## 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 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 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 | | --- # CTI_ParseTransactionQuery() > Parses a downloaded CyberSource transaction query response into the CTIQTD output table for temporary in-program access to transaction detail. This subprocedure is used to parse a previously downloaded transaction query response. This subprocedure requires that you provide the fully-qualified filepath of the downloaded query response file in the IFS. If this query was performed using [CTI_QueryTransaction()](https://isupport.katointegrations.com/cti/cti_querytransaction.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 ```rpgle // Returns *OFF if an error occurs during processing, *ON otherwise. D CTI_ParseTransactionQuery... D PR N Extproc('CTI_ParseTransactionQuery') // Unique ID, generated with CTI_NextUniqueID(), that will be used to // identify the parsed records from this file // Required D pUniqueId Const Like(CTI_UniqueId_t) // The fully-qualified filepath of the file in the IFS that will be parsed. // If this query was performed using CTI_QueryTransaction(), the file will // be in the default download directory specified in your CTICFGMCH record D pQueryFile Const Like(CTI_FilePath_t) // Error data structure used to capture subprocedure and CyberSource errors // Required D pErrorDS LikeDS(CTI_ErrorDS_t) ``` ## Data Structures ### CTI_ErrorDS_t ```rpgle D CTI_ErrorDS_t DS Qualified Template Inz // Name of subprocedure returning error D Subproc 132A Varying // Message ID of error message D MessageId 7A // Error message text D Message 1024A Varying // Error message source D Source 10A // IFS filepath of generated log file D LogFile Like(CTI_FilePath_t) ``` ## Output Table Files ### CTIQTD | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `UID` | `UID` | `DECIMAL(15:0)` | Query Unique ID | | | `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID | | | `REQUESTID` | `REQUESTID` | `VARCHAR(26)` | Payment Request ID | | | `RECONID` | `RECONCILIATIONID` | `VARCHAR(60)` | Transaction Reconciliation ID | | | `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID | | | `TRANSTS` | `TRANSACTIONSTATUS` | `VARCHAR(30)` | Transaction Status | | | `SUBMITTS` | `SUBMITTIMESTAMP` | `TIMESTAMP` | Submission Timestamp | | | `APPINFSTS` | `APPSSTATUS` | `VARCHAR(30)` | Application Status | | | `APPINFRNCD` | `APPSREASONCODE` | `VARCHAR(5)` | Application Reason Code | | | `APPINFRCD` | `APPSRCODE` | `VARCHAR(15)` | Application RCode | | | `APPINFRFLG` | `APPSRFLAG` | `VARCHAR(50)` | Application RFlag | | | `MCHCSTID` | `MERCHANTCUSTOMERID` | `VARCHAR(100)` | Merchant Customer ID | | | `HASHPASSWD` | `HASHEDPASSWORD` | `VARCHAR(100)` | Buyer Hashed Password | | | `CLTCD` | `CLIENTREFERENCECODE` | `VARCHAR(50)` | Client Reference Code | | | `CLTAPPVER` | `CLIENTAPPVERSION` | `VARCHAR(50)` | Application Version | | | `CLTAPPNAME` | `CLIENTAPPNAME` | `VARCHAR(50)` | Application Name | | | `CLTAPPUSR` | `CLIENTAPPUSER` | `VARCHAR(30)` | Application User | | | `CLTAPPCOMM` | `CLIENTAPPCOMMENTS` | `VARCHAR(255)` | Comments | | | `CATHECIRAW` | `CONSUMERAUTHECIRAW` | `VARCHAR(2)` | Consumer ECI Raw | | | `CATHCAVV` | `CONSUMERAUTHCVV` | `VARCHAR(40)` | Consumer CVV | | | `CATHXID` | `CONSUMERXID` | `VARCHAR(40)` | Consumer XID | | | `CATHTRNSID` | `CONSUMERTRANSID` | `VARCHAR(60)` | Consumer Transaction ID | | | `DVCIPADDR` | `DEVICEIPADDRESS` | `VARCHAR(15)` | Customer Device IP Address | | | `DVCHSTNAME` | `DEVICEHOSTNAME` | `VARCHAR(60)` | Customer Device Host Name | | | `DVCCKSACP` | `DEVICECOOKIESACCEPTED` | `VARCHAR(5)` | Consumer Device Cookies Accepted | | | `ERRINFRSN` | `ERRORINFOREASON` | `VARCHAR(50)` | Error Information Reason | | | `ERRINFMSG` | `ERRORINFOMESSAGE` | `VARCHAR(255)` | Error Information Message | | | `NBRINSTLMT` | `NUMBEROFINSTALLMENTS` | `VARCHAR(3)` | Number of Installments | | | `FRDMRKRSN` | `FRAUDMARKREASON` | `VARCHAR(100)` | Fraud Marking Reason | | | `MCHDESCNAM` | `MERCHANTDESCRIPTORNAME` | `VARCHAR(23)` | Merchant Descriptor Name | | | `BTFNAME` | `BILLTOFIRSTNAME` | `VARCHAR(60)` | Bill To Customer First Name | | | `BTLNAME` | `BILLTOLASTNAME` | `VARCHAR(60)` | Bill To Customer Last Name | | | `BTMNAME` | `BILLTOMIDDLENAME` | `VARCHAR(60)` | Bill To Customer Middle Name | | | `BTSUFFIX` | `BILLTONAMESUFFIX` | `VARCHAR(60)` | Bill To Customer Name Suffix | | | `BTADDR1` | `BILLTOADDRESS1` | `VARCHAR(60)` | Bill To Address Line 1 | | | `BTADDR2` | `BILLTOADDRESS2` | `VARCHAR(60)` | Bill To Address Line 2 | | | `BTCITY` | `BILLTOCITY` | `VARCHAR(50)` | Bill To City | | | `BTSTATE` | `BILLTOSTATE` | `VARCHAR(2)` | Bill To State | | | `BTZIP` | `BILLTOZIP` | `VARCHAR(10)` | Bill To Zip | | | `BTCMPNAME` | `BILLTOCOMPANYNAME` | `VARCHAR(60)` | Bill To Company Name | | | `BTCMPADDR1` | `BILLTOCOMPANYADDR1` | `VARCHAR(40)` | Bill To Company Address Line 1 | | | `BTCMPADDR2` | `BILLTOCOMPANYADDR2` | `VARCHAR(40)` | Bill To Company Address Line 2 | | | `BTCMPCITY` | `BILLTOCOMPANYCITY` | `VARCHAR(30)` | Bill To Company City | | | `BTCMPSTATE` | `BILLTOCOMPANYSTATE` | `VARCHAR(2)` | Bill To Company State | | | `BTCMPZIP` | `BILLTOCOMPANYZIP` | `VARCHAR(10)` | Bill To Company Zip | | | `BTCMPCNTRY` | `BILLTOCOMPANYCOUNTRY` | `VARCHAR(2)` | Bill To Company Country | | | `BTEMAIL` | `BILLTOEMAIL` | `VARCHAR(255)` | Bill To Email Address | | | `BTCNTRY` | `BILLTOCOUNTRY` | `VARCHAR(2)` | Bill To Country | | | `BTCSTITLE` | `BILLTOTITLE` | `VARCHAR(60)` | Bill To Customer Title | | | `BTPHONE` | `BILLTOPHONE` | `VARCHAR(15)` | Bill To Phone Number | | | `STFNAME` | `SHIPTOFIRSTNAME` | `VARCHAR(60)` | Ship To Customer First Name | | | `STLNAME` | `SHIPTOLASTNAME` | `VARCHAR(60)` | Ship To Customer Last Name | | | `STADDR1` | `SHIPTOADDRESS1` | `VARCHAR(60)` | Ship To Address Line 1 | | | `STADDR2` | `SHIPTOADDRESS2` | `VARCHAR(60)` | Ship To Address Line 2 | | | `STCITY` | `SHIPTOCITY` | `VARCHAR(50)` | Ship To City | | | `STSTATE` | `SHIPTOSTATE` | `VARCHAR(2)` | Ship To State | | | `STZIP` | `SHIPTOZIP` | `VARCHAR(10)` | Ship To Zip | | | `STCMPNAME` | `SHIPTOCOMPANYNAME` | `VARCHAR(60)` | Ship To Company Name | | | `STCNTRY` | `SHIPTOCOUNTRY` | `VARCHAR(2)` | Ship To Country | | | `STPHONE` | `SHIPTOPHONE` | `VARCHAR(15)` | Ship To Phone Number | | | `AMTTOT` | `TOTALAMOUNT` | `VARCHAR(19)` | Total Amount | | | `AMTCUR` | `AMOUNTCURRENCY` | `VARCHAR(3)` | Amount Currency | | | `AMTTAX` | `TAXAMOUNT` | `VARCHAR(12)` | Tax Amount | | | `AMTATH` | `AUTHORIZEDAMOUNT` | `VARCHAR(15)` | Authorized Amount | | | `AMTSETTLE` | `SETTLEMENTAMOUNT` | `VARCHAR(12)` | Settlement Amount | | | `AMTSETLCUR` | `SETTLEMENTAMOUNTCURRENCY` | `VARCHAR(3)` | Settlement Amount Currency | | | `GIFTWRAP` | `GIFTWRAP` | `VARCHAR(1)` | Gift Wrapping | | | `SHIPMTH` | `SHIPPINGMETHOD` | `VARCHAR(10)` | Shipping Method | | | `PAYTYPNAME` | `PAYMENTTYPENAME` | `VARCHAR(50)` | Payment Type Name | | | `PAYTYP` | `PAYMENTTYPE` | `VARCHAR(20)` | Payment Type | | | `PAYTYPMTH` | `PAYMENTTYPEMETHOD` | `VARCHAR(50)` | Payment Type Method | | | `FUNDSRC` | `PAYMENTTYPEFUNDSOURCE` | `VARCHAR(50)` | Payment Type Funding Source | | | `FUNDSRCAFL` | `PAYMENTTYPEFUNDAFFILIATION` | `VARCHAR(50)` | Payment Type Funding Source Affiliation | | | `PAYTYPCRED` | `PAYMENTTYPECREDENTIAL` | `VARCHAR(50)` | Payment Type Credential | | | `PAYCSTID` | `PAYMENTCUSTOMERID` | `VARCHAR(26)` | Payment Customer ID | | | `CRDSUFFIX` | `CARDSUFFIX` | `VARCHAR(4)` | Card Suffix | | | `CRDPREFIX` | `CARDPREFIX` | `VARCHAR(6)` | Card Prefix | | | `CRDEXPMON` | `CARDEXPIRATIONMONTH` | `VARCHAR(2)` | Card Expiration Month | | | `CRDEXPYR` | `CARDEXPIRATIONYEAR` | `VARCHAR(4)` | Card Expiration Year | | | `CRDSTRMON` | `CARDSTARTMONTH` | `VARCHAR(2)` | Card Start Month | | | `CRDSTRYR` | `CARDSTARTYEAR` | `VARCHAR(4)` | Card Start Year | | | `CRDISSNBR` | `CARDISSUENUMBER` | `VARCHAR(5)` | Card Issue Number | | | `CRDTYP` | `CARDTYPE` | `VARCHAR(3)` | Card Type | | | `CRDENCID` | `CARDACCOUNTENCODERID` | `VARCHAR(3)` | Card Account Encoder ID | | | `CRDUSEAS` | `CRDUSEAS` | `VARCHAR(20)` | Card Use-As | | | `INVNBR` | `INVOICENUMBER` | `VARCHAR(50)` | Invoice Number | | | `INVBARCD` | `INVOICEBARCODENUMBER` | `VARCHAR(50)` | Invoice Barcode Number | | | `INVEXPDT` | `INVOICEEXPIRATIONDATE` | `VARCHAR(50)` | Invoice Expiration Date | | | `BKRTNBR` | `BANKROUTINGNUMBER` | `VARCHAR(9)` | Bank Routing Number | | | `BKBRANCHCD` | `BANKBRANCHCODE` | `VARCHAR(50)` | Branch Code | | | `BKSWIFTCD` | `BANKSWIFTCODE` | `VARCHAR(50)` | Bank Swift Code | | | `BKBANKCD` | `BANKCODE` | `VARCHAR(50)` | Bank Code | | | `BKIBAN` | `BANKIBAN` | `VARCHAR(50)` | Bank IBAN | | | `BKACTSFFIX` | `BANKACCOUNTSUFFIX` | `VARCHAR(50)` | Bank Account Suffix | | | `BKACTPRFIX` | `BANKACCOUNTPREFIX` | `VARCHAR(50)` | Bank Account Prefix | | | `BKCHKNBR` | `BANKCHECKNUMBER` | `VARCHAR(8)` | Bank Check Number | | | `BKACTTYP` | `BANKACCOUNTTYPE` | `VARCHAR(1)` | Bank Account Type | | | `BKACTNAME` | `BANKACCOUNTNAME` | `VARCHAR(60)` | Bank Account Name | | | `BKACTCHKDG` | `BANKACCOUNTCHECKDIGIT` | `VARCHAR(50)` | Bank Account Check Digit | | | `BKACTENCID` | `BANKACCOUNTENCODERID` | `VARCHAR(3)` | Bank Account Encoder ID | | | `BKMDREFNBR` | `BANKMANDATEREFERENCENUMBER` | `VARCHAR(50)` | Bank Mandate Reference Number | | | `BKMDRCRTYP` | `BANKMANDATERECURRINGTYPE` | `VARCHAR(50)` | Bank Mandate Recurring Type | | | `BKMDID` | `BANKMANDATEID` | `VARCHAR(50)` | Bank Mandate ID | | | `ACTBALAMT` | `ACCOUNTBALANCEAMOUNT` | `VARCHAR(12)` | Account Balance | | | `ACTPRVBAL` | `ACCOUNTPREVIOUSBALANCE` | `VARCHAR(12)` | Account Previous Balance | | | `ACTCUR` | `ACCOUNTCURRENCY` | `VARCHAR(5)` | Account Currency | | | `PMTSOLN` | `PAYMENTSOLUTION` | `VARCHAR(12)` | Payment Solution | | | `PMTCMCIND` | `PROCESSINGCOMMERCEINDICATOR` | `VARCHAR(20)` | Processing Commerce Indicator | | | `PMTBSAPPID` | `PROCESSINGAPPLICATIONID` | `VARCHAR(50)` | Processing Application ID | | | `ATHTYP` | `AUTHORIZATIONTYPE` | `VARCHAR(15)` | Authorization Type | | | `BKTRNSECCD` | `BANKTRANSFERSECCODE` | `VARCHAR(50)` | Bank Transfer Sec Code | | | `PRCNAME` | `PROCESSORNAME` | `VARCHAR(30)` | Processor Name | | | `PRCTRANID` | `PROCESSORTRANSACTIONID` | `VARCHAR(50)` | Processor Transaction ID | | | `PRCNTTRNID` | `PROCESSORNETWORKTRANSACTIONID` | `VARCHAR(50)` | Processor Network Transaction ID | | | `PRCRSPID` | `PROCESSORRESPONSEID` | `VARCHAR(50)` | Processor Response ID | | | `PRCPVTRNID` | `PROVIDERTRANSACTIONID` | `VARCHAR(50)` | Processor Provider Transaction ID | | | `PRCAPRCD` | `PROCESSORAPPROVALCODE` | `VARCHAR(50)` | Processor Approval Code | | | `PRCRSPCD` | `PROCESSORRESPONSECODE` | `VARCHAR(10)` | Processor Response Code | | | `PRCAVSCD` | `AVSCODE` | `VARCHAR(1)` | AVS Code | | | `PRCAVSCDRW` | `AVSCODERAW` | `VARCHAR(10)` | AVS Code Raw | | | `PRCCVRSTCD` | `CARDVERIFICATIONRESULTCODE` | `VARCHAR(1)` | CVN Result Code | | | `PRCACHRSCD` | `ACHVERIFICATIONRESULTCODE` | `VARCHAR(2)` | ACH Verification Result Code | | | `PRCACHCDRW` | `ACHVERIFICATIONCODERAW` | `VARCHAR(10)` | ACH Verification Result Code Raw | | | `EVEMAIL` | `EVEMAILRESULT` | `VARCHAR(1)` | EV Email Result | | | `EVEMAILRAW` | `EVEMAILRESULTRAW` | `VARCHAR(1)` | EV Email Result Raw | | | `EVNAME` | `EVNAMERESULT` | `VARCHAR(30)` | EV Name Result | | | `EVNAMERAW` | `EVNAMERESULTRAW` | `VARCHAR(30)` | EV Name Result Raw | | | `EVPHONE` | `EVPHONERESULT` | `VARCHAR(1)` | EV Phone Result | | | `EVPHONERAW` | `EVPHONERESULTRAW` | `VARCHAR(1)` | EV Phone Result Raw | | | `EVSTREET` | `EVSTREETRESULT` | `VARCHAR(1)` | EV Street Result | | | `EVSTREETRW` | `EVSTREETRESULTRAW` | `VARCHAR(1)` | EV Street Result Raw | | | `EVZIP` | `EVZIPRESULT` | `VARCHAR(1)` | EV Zip Result | | | `EVZIPRAW` | `EVZIPRESULTRAW` | `VARCHAR(1)` | EV Zip Result Raw | | | `SYSTRADNBR` | `SYSTEMTRACEAUDITNUMBER` | `VARCHAR(6)` | System Trace Audit Number | | | `RSPCDSRC` | `RESPONSECODESOURCE` | `VARCHAR(1)` | Response Code Source | | | `POSENTRYMD` | `POSENTRYMODE` | `VARCHAR(11)` | POS Entry Mode | | | `POSTERMCAP` | `POSTERMINALCAPABILITY` | `VARCHAR(1)` | POS Termianl Capability | | | `PRFNAME` | `PROFILENAME` | `VARCHAR(50)` | Profile Name | | | `PRFDCSN` | `PROFILEDECISION` | `VARCHAR(255)` | Decision Returned by the Profile | | | `PASPRFNAME` | `PASSIVEPROFILENAME` | `VARCHAR(50)` | Passive Profile Name | | | `PASPRFDSCN` | `PASSIVEPROFILEDECISION` | `VARCHAR(255)` | Passive Profile Decision | | | `FACTORCDS` | `SCOREFACTORCODES` | `VARCHAR(100)` | Score Factor Codes | | | `SCORERSLT` | `SCORERESULT` | `VARCHAR(50)` | Score Result | | | `RISKLOCTS` | `RISKLOCALTIME` | `CHAR(30)` | Risk Information Local Time | | | `SNDREFNBR` | `SENDERREFERENCENUMBER` | `VARCHAR(19)` | Sender Reference Number | | ### CTIQTDAPP | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id | | | `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID | | | `UID` | `UID` | `DECIMAL(15:0)` | Application Unique ID | | | `APPNAME` | `APPLICATIONNAME` | `VARCHAR(30)` | Application Name | | | `APPSTS` | `APPLICATIONSTATUS` | `VARCHAR(30)` | Application Status | | | `APPRSNCD` | `APPLICATIONREASONCODE` | `VARCHAR(5)` | Application Reason Code | | | `APPRCD` | `APPLICATIONRCODE` | `VARCHAR(15)` | Application RCode | | | `APPRFLAG` | `APPLICATIONRFLAG` | `VARCHAR(50)` | Application RFlag | | | `APPRECONID` | `APPLICATIONRECONCILIATIONID` | `VARCHAR(60)` | Application Reconciliation ID | | | `APPRMSG` | `APPLICATIONRMESSAGE` | `VARCHAR(255)` | Application rMessage | | | `APPRTNCD` | `APPLICATIONRETURNCODE` | `VARCHAR(50)` | Application Return Code | | ### CTIQTDERR | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id | | | `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID | | | `UID` | `UID` | `DECIMAL(15:0)` | Error Unique ID | | | `ERRFIELD` | `ERRORFIELD` | `VARCHAR(1024)` | JSON Field in Error | | | `ERRREASON` | `ERRORREASON` | `VARCHAR(15)` | Error Reason | | ### CTIQTDLIN | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id | | | `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID | | | `UID` | `UID` | `DECIMAL(15:0)` | Line Item Unique ID | | | `PRODUCTCD` | `PRODUCTCODE` | `VARCHAR(255)` | Product Code | | | `PRODUCTNAM` | `PRODUCTNAME` | `VARCHAR(255)` | Product Name | | | `PRODUCTSKU` | `PRODUCTSKU` | `VARCHAR(255)` | Product SKU | | | `TAXAMT` | `TAXAMOUNT` | `VARCHAR(15)` | Tax Amount | | | `QUANTITY` | `QUANTITY` | `VARCHAR(15)` | Quantity of Product | | | `UNITPRICE` | `UNITPRICE` | `VARCHAR(15)` | Unit Price | | | `FULFILTYP` | `FULFILLMENTTYPE` | `VARCHAR(2)` | Fulfillment Type | | ### CTIQTDMDI | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id | | | `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID | | | `UID` | `UID` | `DECIMAL(15:0)` | Merchant-Defined Unique ID | | | `MDIKEY` | `MERCHDEFINEDINFOKEY` | `VARCHAR(50)` | Merchant-Defined Information Key | | | `MDIVALUE` | `MERCHDEFINEDINFOVALUE` | `VARCHAR(255)` | Merchant-Defined Information Value | | ### CTIQTDPAS | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id | | | `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID | | | `UID` | `UID` | `DECIMAL(15:0)` | Passive Rule Unique ID | | | `PASRULNAME` | `PASSIVERULENAME` | `VARCHAR(50)` | Passive Rule Name | | | `PASRULDSCN` | `PASSIVERULEDECISION` | `VARCHAR(255)` | Passive Rule Decision | | ### CTIQTDRUL | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `PID` | `PID` | `DECIMAL(15:0)` | Parent Report Unique Id | | | `QUERYID` | `QUERYID` | `VARCHAR(26)` | CyberSource Query ID | | | `UID` | `UID` | `DECIMAL(15:0)` | Rule Unique ID | | | `RULNAME` | `RULENAME` | `VARCHAR(50)` | Rule Name | | | `RULDSCN` | `RULEDECISION` | `VARCHAR(255)` | Rule Decision | | --- # CTI_IsLicenseValid() > Returns whether a valid CTI license is currently applied, for use in automated license management workflows. This subprocedure can be used to confirm that a valid license for CTI is currently applied for license management automation. When called, CTI_IsLicenseValid will return \*ON if a valid CTI license is currently applied, or \*OFF otherwise. ## Subprocedure Prototype ```rpgle // Returns *ON if valid CTI license is applied, *OFF otherwise D CTI_IsLicenseValid... D PR N Extproc('CTI_IsLicenseValid') ``` --- # ADDRPTKEY - Add CyberSource Reporting Key Record > Adds or updates a CTICFGRPT record with a merchant ID and shared/secret key pair for CyberSource HTTP Signature Authentication used by reporting and query APIs. This command allows you to easily update the CTICFGRPT table with a record for your merchant ID, with your generated private and public shared keys for [CyberSource's HTTP Authentication](https://developer.cybersource.com/api/developer-guides/dita-gettingstarted/authentication/createSharedKey.html). This command can be used to create a new record, or to update an existing record. Prompt the command to bring up the data entry screen: ![Add Report Key (ADDRPTKEY)](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/addrptkey1.png "Add Report Key (ADDRPTKEY)") All four of these fields are required. Note that the **CyberSource Environment** parameter is a key field that indicates for which environment the security was generated. You can press F10 to bring up the additional parameter, **Key Label**, which can be used to specify a unique identifier for this security key pair. This can be used to specify multiple key pairs for a single merchant ID. ![Key Label Parameter (ADDRPTKEY)](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/addrptkey2.png "Key Label Parameter (ADDRPTKEY)") When calling [CTI_DownloadReport()](https://isupport.katointegrations.com/cti/cti_downloadreport.md) or [CTI_QueryTransaction()](https://isupport.katointegrations.com/cti/cti_querytransaction.md), you will specify the merchant ID and environment, and optionally the key label, for the key pair to be used. --- # APYLIC - Apply Product License > Applies a permanent or temporary license key to the CyberSource Toolkit for i installation. To apply a permanent or temporary license key for CyberSource Toolkit for i, you will use the included command APYLIC. Your license key will typically be supplied via email in a command string: `APYLIC LICKEY(6E2222898982C8F1380F4DF08A23922C) PRODUCT(CTI)` Or, you can copy and paste the received key into the command: ![Apply License (APYLIC)](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/apylic.png "Apply License (APYLIC)") In either case after running the APYLIC command, you should receive a message that says **License applied successfully**. If you don't receive that message or receive an error message, please contact us at isupport@katointegrations.com. --- # DSPMCHINF - Display Machine Info > Displays system machine information and license key status required by support to generate activation keys. To generate a license key for your CyberSource Toolkit for i installation, a support representative will need your system information. The easiest and preferred way to get this information is to run the DSPMCHINF command, take a screenshot, and email it to us at isupport@katointegrations.com. The command does not have any parameters: `DSPMCHINF` The command should display a screen similar to the one below. This screen indicates all the information necessary to generate your license key, as well as the current status of any applied license keys. ![Display Machine Info (DSPMCHINF)](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/dspmchinf.png "Display Machine Info (DSPMCHINF)") If you don't see this screen or receive an error message, please contact us at isupport@katointegrations.com. --- # DSPLIC - Display License Info > Legacy alias for DSPMCHINF; displays machine and license information needed for activation key generation. DSPLIC is an alias for the [DSPMCHINF](https://isupport.katointegrations.com/cti/dspmchinf.md) command included in CyberSource Toolkit for i for legacy reasons. The command does not have any parameters: `DSPLIC` The command should display a screen similar to the one below. This screen indicates all the information necessary to generate your license key, as well as the current status of any applied license keys. ![Display License Info (DSPLIC)](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/dsplic.png "Display License Info (DSPLIC)") If you don't see this screen or receive an error message, please contact us at isupport@katointegrations.com. --- # DSPVER - Display Product Version > Displays the currently installed version of CyberSource Toolkit for i. DSPVER can be used to retrieve the version of CyberSource Toolkit for i that is currently installed. The command does not have any parameters: `DSPVER` You should recieve a message indicating the currently installed version: ![Display Product Version (DSPVER)](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/dspver.png "Display Product Version (DSPVER)") If you don't receive that message or receive an error message, please contact us at isupport@katointegrations.com. --- # WRKCTICERT - Work with Cybersource Certificates > Adds and manages CyberSource P12 certificates on IBM i, associating them with a merchant ID and environment for use by CTI_Run(). WRKCTICERT can be used to add and manage P12 certificates provided by Cybersource and allow CTI to use them. The command has one optional parameter `LIB` where you can specify a library to load CTICFGCERT data from, but most users will not need to use `LIB`. `WRKCTICERT` You should see a screen showing a list of all P12 certificates you currently have imported (if any) and have a variety of options and F-keys to manage your P12 certificates. ![Work with Cybersource Certificates (WRKCTICERT)](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/wrkcticert1.png "Work with Cybersource Certificates (WRKCTICERT)") If this is your first time using `WRKCTICERT`, you will want to press F6 to add a P12 certificate. ![WRKCTICERT, Add Certificate](https://isupport.katointegrations.com/llms/cybersource-toolkit-for-i/wrkcticert2.png "WRKCTICERT, Add Certificate") Enter the merchant ID and environment the P12 was generated for, as well as whether or not you wish to log all requests (typically *NO in Production). You will also need to provide an IFS filepath to your P12 certificate which was [created using the Cybersource Business Center](https://isupport.katointegrations.com/cti/create_cs_p12_certificate.md) and the password that you set for the P12. --- # CTI Configuration > Documents the three DB2 configuration files: CTICFGENV (environment and endpoint settings), CTICFGCER (P12 certificates), and CTICFGRPT (reporting API credentials). The following DB2 physical files are used to configure your CTI installation. ### CTICFGENV This file stores environment-level configuration for CTI. This includes which webservice endpoints are available, whether or not a proxy is used for communication, and logging and report downloading directories. | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID | | | `LOGDIR` | `LOGDIR` | `VARCHAR(512)` | Logging Directory | | | `DOWNLDDIR` | `DOWNLDDIR` | `VARCHAR(512)` | Download Directory | | | `PLUGINDIR` | `PLUGINDIR` | `VARCHAR(512)` | Plugin Directory | | | `TMPDIR` | `TMPDIR` | `VARCHAR(512)` | Temporary Directory | | | `TESTWSURL` | `TESTWSURL` | `VARCHAR(1024)` | CyberSource Test WebService URL | | | `PRODWSURL` | `PRODWSURL` | `VARCHAR(1024)` | CyberSource Prod WebService URL | | | `TESTRPTURL` | `TESTRPTURL` | `VARCHAR(1024)` | CyberSource Test Reporting URL | | | `PRODRPTURL` | `PRODRPTURL` | `VARCHAR(1024)` | CyberSource Prod Reporting URL | | | `PROXYURL` | `PROXYURL` | `VARCHAR(1024)` | Proxy URL | | | `PROXYUSER` | `PROXYUSER` | `VARCHAR(60)` | Proxy Username | | | `PROXYPASS` | `PROXYPASS` | `VARCHAR(60)` | Proxy Password | | | `TESTAPIURL` | `TESTAPIURL` | `VARCHAR(1024)` | CyberSource Test Reporting API URL | | | `PRODAPIURL` | `PRODAPIURL` | `VARCHAR(1024)` | CyberSource Prod Reporting API URL | | | `TIMEOUT` | `TIMEOUT` | `VARCHAR(8)` | SSL/Socket Timeout Seconds | | ### CTICFGCER This file stores P12 authentication certificate information for CTI. This also includes merchant ID, target environment (*TEST or *PROD), and whether logging is enabled for requests. This file can be managed using the [WRKCTICERT](https://isupport.katointegrations.com/cti/wrkcticert.md) command. To generate this security key, follow the instructions here: [Generate CyberSource Security Keys](https://isupport.katointegrations.com/cti/cs_keys.md) | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID | | | `LOGALL` | `LOGALL` | `CHAR(4)` | Log All Requests? | | | `WSENV` | `WSENV` | `CHAR(5)` | Environment | | | `SERIAL` | `CERTIFICATESERIALNUMBER` | `VARCHAR(32)` | Certificate Serial Number | | | `STRDT` | `CERTIFICATESTARTDATE` | `DATE` | Certificate Start Date | | | `ENDDT` | `CERTIFICATEENDDATE` | `DATE` | Certificate End Date | | | `CERT` | `CERTIFICATE` | `VARCHAR(4096)` | Certificate | Managed by the WRKCTICERT command | | `PRIVKEY` | `PRIVATEKEY` | `VARCHAR(8192)` | Private Key | Managed by the WRKCTICERT command | | `AUDTYPE` | `AUDITTYPE` | `CHAR(1)` | Audit Type | Automatically updated field showing type of most recent record change operation | | `AUDUSER` | `AUDITUSER` | `VARCHAR(18)` | Audit User | Automatically updated field showing username of most recent record change operation | | `AUDJOBNM` | `AUDITJOBNAME` | `VARCHAR(28)` | Audit Job Name | Automatically updated field showing job name of most recent record change operation | | `AUDTS` | `AUDITTIME` | `TIMESTAMP` | Audit Timestamp | Automatically updated field showing timestamp of most recent record change operation | ### CTICFGRPT This file stores reporting credentials added using the [ADDRPTKEY](https://isupport.katointegrations.com/cti/addrptkey.md) command. | Field Name | Long Field Name | Data Type | Field Title | Comments | |---|---|---|---|---| | `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID | | | `ENV` | `ENVIRONMENT` | `VARCHAR(5)` | CyberSource Environment | | | `KEYLABEL` | `KEYLABEL` | `VARCHAR(50)` | Key Label | | | `SHAREDKEY` | `SHAREDKEY` | `VARCHAR(36)` | Shared Key | | | `SECRETKEY` | `SECRETKEY` | `VARCHAR(50)` | Secret Key | |