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 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
|
Returns *OFF if an error occurs during processing, *ON otherwise. |
|
Unique ID generated with CTI_NextUniqueID() Required |
|
Error data structure used to capture subprocedure and CyberSource errors Required |
|
Credit card number |
|
Credit card verification number/security code |
|
Merchant ID used to process the transaction Required |
|
Optional additional data used when transaction occurs using point of sale |
Data Structures
|
|
|
Indicates if this is a card-present or card-not-present transaction. |
|
The type of cardholder-activated terminal. See the CyberSource SO API documentation for valid values. |
|
|
|
|
|
|
|
The method through which card data is retrieved. Valid Values:
|
|
|
|
MasterCard service code, included in track data. |
|
Indicates the ability of the terminal to process different card entry modes. See the CyberSource SO API documentation for valid values. |
|
Identifies the terminal at your retail location. |
|
Identifies an alternate terminal at your retail location. |
|
Track 1 and track 2 card data from the card reader. |
|
|
|
Name of subprocedure returning error |
|
Message ID of error message |
|
Error message text |
|
Error message source |
|
IFS filepath of generated log file |
Input Table Files
| 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 |
| 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 |
| 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 |
| 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
| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
UID |
PARENT_UNIQUEID |
DECIMAL(15:0) |
Response Unique ID | |
CRTDT |
TIMESTAMP |
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 |
| 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 |