# CTI_Run()

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

| Field | Description |
|---|---|
| `     D CTI_Run         PR              N   Extproc('CTI_Run')` | Returns *OFF if an error occurs during processing, *ON otherwise. |
| `     D  pUniqueId                          Const Like(CTI_UniqueId_t)` | Unique ID generated with CTI_NextUniqueID() **Required** |
| `     D  pErrorDS                           LikeDS(CTI_ErrorDS_t)` | Error data structure used to capture subprocedure and CyberSource errors **Required** |
| `     D  pCardNumber                  20A   Const Options(*Trim:*Omit)      D                                     Varying` | Credit card number |
| `     D  pCardCvNumber                 4A   Const Options(*Trim:*Omit)      D                                     Varying` | Credit card verification number/security code |
| `     D  pMerchantId                        Const Like(CTI_MerchantId_t)      D                                     Options(*Trim)` | Merchant ID used to process the transaction **Required** |
| `     D  pPointOfSaleDS...      D                                     Const LikeDS(CTI_PosDS_t)      D                                     Options(*Omit:*Nopass)` | Optional additional data used when transaction occurs using point of sale |


## Data Structures

### CTI_PosDS_t

| Field | Description |
|---|---|
| `     D CTI_PosDS_t     DS                  Qualified Template Inz` |  |
| `     D  CardPresent                   1A` | Indicates if this is a card-present or card-not-present transaction. |
| `     D  CatLevel                      1A` | The type of cardholder-activated terminal. See the CyberSource SO API documentation for valid values. |
| `     D  DeviceReaderData...      D                              512A` |  |
| `     D  EncodingMethod...      D                                6A` |  |
| `     D  EncryptionAlgorithm...      D                                4A` |  |
| `     D  EntryMode                    11A` | The method through which card data is retrieved. **Valid Values:** `contact`, `contactless`, `msd` |
| `     D  PaymentData                2048A` |  |
| `     D  ServiceCode                   3A` | MasterCard service code, included in track data. |
| `     D  TerminalCapability...      D                                1A` | Indicates the ability of the terminal to process different card entry modes. See the CyberSource SO API documentation for valid values. |
| `     D  TerminalID                    8A` | Identifies the terminal at your retail location. |
| `     D  TerminalIDAlternative...      D                                8A` | Identifies an alternate terminal at your retail location. |
| `     D  TrackData                   119A` | Track 1 and track 2 card data from the card reader. |


### CTI_ErrorDS_t

| Field | Description |
|---|---|
| `     D CTI_ErrorDS_t   DS                  Qualified Template Inz` |  |
| `     D  Subproc                     132A   Varying` | Name of subprocedure returning error |
| `     D  MessageId                     7A` | Message ID of error message |
| `     D  Message                    1024A   Varying` | Error message text |
| `     D  Source                       10A` | Error message source |
| `     D  LogFile                            Like(CTI_FilePath_t)` | IFS filepath of generated log file |


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