First Data Rapid Connect Auth Retail Transaction UML


Added On:  09/22/14 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataRapidConnectAuthRetailTransaction 
First Data Rapid specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, First Data Rapid specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Available Fields:
Added On:  09/23/14
SQL Column:  
Java Field:  acctNum
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number of the card used in the transaction.
Added On:  09/22/14
SQL Column:  ACI
Java Field:  aci
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
A code used to request qualification in the Custom Payment Service (CPS) program as defined by Visa. Upon evaluation, the code may be changed in the response message if provided by Visa.
Added On:  10/29/14
SQL Column:  ACI_RESPONSE
Java Field:  aciResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
A code used to response qualification in the Custom Payment Service (CPS) program as defined by Visa.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE1_RESPONSE
Java Field:  addAmtAcctType1Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE10_RESPONSE
Java Field:  addAmtAcctType10Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE2_RESPONSE
Java Field:  addAmtAcctType2Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE3_RESPONSE
Java Field:  addAmtAcctType3Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE4_RESPONSE
Java Field:  addAmtAcctType4Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE5_RESPONSE
Java Field:  addAmtAcctType5Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE6_RESPONSE
Java Field:  addAmtAcctType6Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE7_RESPONSE
Java Field:  addAmtAcctType7Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE8_RESPONSE
Java Field:  addAmtAcctType8Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_ACCT_TYPE9_RESPONSE
Java Field:  addAmtAcctType9Response
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Additional amount account type returned in response messages.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY1_RESPONSE
Java Field:  addAmtCrncy1Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY10_RESPONSE
Java Field:  addAmtCrncy10Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY2_RESPONSE
Java Field:  addAmtCrncy2Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY3_RESPONSE
Java Field:  addAmtCrncy3Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY4_RESPONSE
Java Field:  addAmtCrncy4Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY5_RESPONSE
Java Field:  addAmtCrncy5Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY6_RESPONSE
Java Field:  addAmtCrncy6Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY7_RESPONSE
Java Field:  addAmtCrncy7Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY8_RESPONSE
Java Field:  addAmtCrncy8Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_CRNCY9_RESPONSE
Java Field:  addAmtCrncy9Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response for numeric currency of the additional amount in the transaction.
Added On:  09/22/14
SQL Column:  ADD_AMT_TYPE1
Java Field:  addAmtType1
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE1_RESPONSE
Java Field:  addAmtType1Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE10
Java Field:  addAmtType10
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE10_RESPONSE
Java Field:  addAmtType10Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE11
Java Field:  addAmtType11
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE12
Java Field:  addAmtType12
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE13
Java Field:  addAmtType13
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE14
Java Field:  addAmtType14
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  09/22/14
SQL Column:  ADD_AMT_TYPE2
Java Field:  addAmtType2
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE2_RESPONSE
Java Field:  addAmtType2Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  09/22/14
SQL Column:  ADD_AMT_TYPE3
Java Field:  addAmtType3
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE3_RESPONSE
Java Field:  addAmtType3Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  09/22/14
SQL Column:  ADD_AMT_TYPE4
Java Field:  addAmtType4
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE4_RESPONSE
Java Field:  addAmtType4Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  09/22/14
SQL Column:  ADD_AMT_TYPE5
Java Field:  addAmtType5
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE5_RESPONSE
Java Field:  addAmtType5Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  09/22/14
SQL Column:  ADD_AMT_TYPE6
Java Field:  addAmtType6
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Represents the type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE6_RESPONSE
Java Field:  addAmtType6Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE7
Java Field:  addAmtType7
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE7_RESPONSE
Java Field:  addAmtType7Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE8
Java Field:  addAmtType8
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE8_RESPONSE
Java Field:  addAmtType8Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  11/20/14
SQL Column:  ADD_AMT_TYPE9
Java Field:  addAmtType9
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Type of additional amount in the transaction.
Added On:  10/29/14
SQL Column:  ADD_AMT_TYPE9_RESPONSE
Java Field:  addAmtType9Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for type of additional amount in the transaction.
Added On:  09/22/14
SQL Column:  ADD_AMT1
Java Field:  addAmt1
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT1_RESPONSE
Java Field:  addAmt1Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT10
Java Field:  addAmt10
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT10_RESPONSE
Java Field:  addAmt10Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT11
Java Field:  addAmt11
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT12
Java Field:  addAmt12
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT13
Java Field:  addAmt13
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT14
Java Field:  addAmt14
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  09/22/14
SQL Column:  ADD_AMT2
Java Field:  addAmt2
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT2_RESPONSE
Java Field:  addAmt2Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  09/22/14
SQL Column:  ADD_AMT3
Java Field:  addAmt3
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT3_RESPONSE
Java Field:  addAmt3Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  09/22/14
SQL Column:  ADD_AMT4
Java Field:  addAmt4
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT4_RESPONSE
Java Field:  addAmt4Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  09/22/14
SQL Column:  ADD_AMT5
Java Field:  addAmt5
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT5_RESPONSE
Java Field:  addAmt5Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  09/22/14
SQL Column:  ADD_AMT6
Java Field:  addAmt6
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT6_RESPONSE
Java Field:  addAmt6Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT7
Java Field:  addAmt7
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT7_RESPONSE
Java Field:  addAmt7Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT8
Java Field:  addAmt8
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT8_RESPONSE
Java Field:  addAmt8Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  11/20/14
SQL Column:  ADD_AMT9
Java Field:  addAmt9
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Value for a single additional amount instance.
Added On:  10/29/14
SQL Column:  ADD_AMT9_RESPONSE
Java Field:  addAmt9Response
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Response value for a single additional amount instance.
Added On:  09/22/14
SQL Column:  ADDTL_RESP_DATA
Java Field:  addtlRespData
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Additional data that may be returned in an authorization response message. Could contain values that describe items such as the reason for a decline, the field in error, etc.

Note: сustomer should not code their application to the actual text in this field.
Added On:  09/22/14
SQL Column:  ALT_MERCH_ID
Java Field:  altMerchId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Alternate identifier assigned to a merchant by FirstData Prepaid Closed Loop.
For additional information please contact your account representative.
Added On:  09/23/14
SQL Column:  AM_EX_POS_DATA
Java Field:  amExPosData
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Transaction specific data that is returned by American Express and required on subsequent transactions.
Added On:  09/23/14
SQL Column:  
Java Field:  amexSecrAd
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
A cryptographic value that is generated during the Amex transaction authentication process i.e. American Express AEVV (American Express SafeKey).
Added On:  09/23/14
SQL Column:  AM_EX_TRAN_ID
Java Field:  amExTranId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
A unique value up to 20 digits assigned by American Express, used to identify and link all related transactions for authorization and settlement through American Express. Contains the transaction identifier and validation code returned by American Express.
Added On:  09/23/14
SQL Column:  
Java Field:  amexXid
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
A unique transaction ID set by the merchant and sent to the issuer authentication/service in the authentication request message. An optional transaction ID to identify the American Express SafeKey (AESK) transaction.
Added On:  06/17/15
SQL Column:  AMT_EXTRA_CHRGS
Java Field:  amtExtraChrgs
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Amount of extra charges.
Added On:  09/23/14
SQL Column:  
Java Field:  appExpDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
An application expirition date. It's value comes from Tag 5F24 captured from the chip data in the field EMV Group. EMV Data.
Added On:  06/16/16
SQL Column:  
Java Field:  applicationId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identification number of the used application.
Added On:  09/22/14
SQL Column:  ATH_NTWK_ID
Java Field:  athNtwkId
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Network ID as returned by the host, if available.
Added On:  06/17/15
SQL Column:  ATH_NTWK_NM
Java Field:  athNtwkNm
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Authorization network number.
Added On:  09/22/14
SQL Column:  AUTH_ID
Java Field:  authId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
The value assigned by the authorizer and returned in the response to the authorization request.
Added On:  06/17/15
SQL Column:  AUTO_AGREE_NUM
Java Field:  autoAgreeNum
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Number of the car agreement document.
Added On:  06/17/15
SQL Column:  AUTO_NO_SHOW
Java Field:  autoNoShow
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Information about a customer not showing up to pick up a rented car. Is sent only in car rental transactions for Visa.
Added On:  09/23/14
SQL Column:  AVS_BILLING_ADDR
Java Field:  avsBillingAddr
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Street address of the customer. Used to submit the street address of the cardholder when attempting to perform address verification.
Added On:  09/23/14
SQL Column:  AVS_BILLING_POSTAL_CODE
Java Field:  avsBillingPostalCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code of the cardholder. Used to submit ZIP (or postal) code of the cardholder when attempting to perform address verification.
Added On:  09/22/14
SQL Column:  AVS_RESULT_CODE
Java Field:  avsResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The result of checking the cardholder‘s postal code and any additional address information provided against the Issuer‘s system of record.
Added On:  09/23/14
SQL Column:  BANKNET_DATA
Java Field:  banknetData
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Data that is assigned by MasterCard, to every transaction that is processed through MasterCard‘s Banknet System.
Added On:  09/22/14
SQL Column:  BILL_PYMT_TXN_IND
Java Field:  billPymtTxnInd
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
An identifier used to indicate the type of bill payment transaction.
Added On:  09/23/14
SQL Column:  BILLING_IND
Java Field:  billingInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identifies the debit fee program that will be used for billing the transaction.
Added On:  09/22/14
SQL Column:  CARC
Java Field:  carc
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Visa-defined code to indicate card authentication results.
Added On:  09/22/14
SQL Column:  CARD_CAPT_CAP
Java Field:  cardCaptCap
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the terminal capability to capture the card data.
Added On:  09/23/14
SQL Column:  CARD_CLASS
Java Field:  cardClass
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
A value returned from the host that classifies the card usage. This value provides information about the card to the merchant.
Added On:  09/23/14
SQL Column:  CARD_COST
Java Field:  cardCost
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
The full cost of the stored value card, including service charges. May be provided when the transaction type is "Activation", "Load", or "Reload".
Added On:  09/23/14
SQL Column:  
Java Field:  cardExpiryDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date of the card used in the transaction. Usually printed on it's front side.

Format: MMYY.
Added On:  09/22/14
SQL Column:  CARD_LEVEL_RESULT
Java Field:  cardLevelResult
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
A value returned by Visa, to designate the type of card product used to process the transaction.
Added On:  09/22/14
SQL Column:  CARD_SEQ_NUM
Java Field:  cardSeqNum
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
A number used to differentiate cards that have the same Primary Account Number (PAN).
Added On:  09/22/14
SQL Column:  CARD_TYPE
Java Field:  cardType
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identifier used to indicate the card type.
Added On:  07/14/16
SQL Column:  CARD_TYPE_RESPONSE
Java Field:  cardTypeResponse
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Response message associated with the card type; generated by the processor.
Added On:  09/23/14
SQL Column:  CAVV_RESULT_CODE
Java Field:  cavvResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The result code to indicate the success or failure of a Visa Secure transaction.
Added On:  09/23/14
SQL Column:  
Java Field:  ccvData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CVV2, CVC2 and CID (referred to in Rapid Connect as CCV Data) are, Visa, MasterCard, American Express and Discover card verification tools designed to reduce fraud losses primarily on transactions when the card is not present. With the exception of American Express, this is a three character value printed on the back of the card in the signature panel, after the card number. For American Express, it is a four character value printed on the face of the card.
Added On:  09/23/14
SQL Column:  CCV_ERROR_CODE
Java Field:  ccvErrorCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
An error code that may be returned in response to the CCV data submitted at the time of authorization.
Added On:  09/22/14
SQL Column:  CCV_IND
Java Field:  ccvInd
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
An identifier provided in the authorization request to indicate the presence or absence of CCV data on the card.
Added On:  09/22/14
SQL Column:  CCV_RESULT_CODE
Java Field:  ccvResultCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The result code of the CCV verification.
Added On:  11/20/14
SQL Column:  CH_FIRST_NM
Java Field:  chFirstNm
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
First name of the cardholder.
Added On:  11/10/14
SQL Column:  CH_FULL_NM_RES
Java Field:  chFullNmRes
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
A response field containing the result of checking the cardholder’s first name and last name. Returned in the response of a Discover AVS transaction where the fields cardholder first name and cardholder last name were submitted in the request.
Added On:  11/20/14
SQL Column:  CH_LAST_NM
Java Field:  chLastNm
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Last name of the cardholder.
Added On:  09/23/14
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  11/10/14
SQL Column:  CLIENT_REF
Java Field:  clientRef
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
A value assigned by the merchant to uniquely reference a transaction and any subsequent related transactions.
Added On:  07/14/16
SQL Column:  CUST_DATA
Java Field:  custData
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Additional information about the customer.
Added On:  09/23/14
SQL Column:  CUST_SVC_PHONE_NUMBER
Java Field:  custSvcPhoneNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Phone number, provided by the merchant, used to discuss any processing issues.
Added On:  06/16/16
SQL Column:  
Java Field:  datawireId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identifier of datawire assigned by the processor.
Added On:  07/14/16
SQL Column:  DEPT_NUM
Java Field:  deptNum
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Department Number associated with the employee.
Added On:  09/23/14
SQL Column:  DEST_CTRY_CODE
Java Field:  destCtryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the location the item(s) in the purchase are being delivered to.
Added On:  09/23/14
SQL Column:  DEST_POSTAL_CODE
Java Field:  destPostalCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code of the location the item(s) in the purchase are being delivered to.
Added On:  09/23/14
SQL Column:  DEV_TYPE_IND
Java Field:  devTypeInd
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Identifies the form factor used at the POS for MasterCard PayPass transactions.
Added On:  09/23/14
SQL Column:  DISC_NRID
Java Field:  discNrid
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
The Network Result Indicator (NRID) assigned by Discover.
Added On:  09/23/14
SQL Column:  DISC_POS_DATA
Java Field:  discPosData
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
The specific POS capture conditions for the card information at the time of the transaction.
Added On:  09/23/14
SQL Column:  DISC_POS_ENTRY
Java Field:  discPosEntry
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
The entry mode provided to Discover for the transaction.
Added On:  09/23/14
SQL Column:  DISC_PROC_CODE
Java Field:  discProcCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Type of transaction sent to the card acceptor.
Added On:  09/23/14
SQL Column:  DISC_RESP_CODE
Java Field:  discRespCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The code assigned by Discover which indicates the status of the transaction.
Added On:  09/23/14
SQL Column:  DISC_TRANS_QUALIFIER
Java Field:  discTransQualifier
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Magnetic stripe conditions and the vulnerability to fraud for Discover card transactions.
Added On:  09/23/14
SQL Column:  DISCNT_AMT
Java Field:  discntAmt
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Discount amount for the purchase.
Added On:  07/14/16
SQL Column:  DRV_NUM
Java Field:  drvNum
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Driver license number associated with the employee.
Added On:  06/17/15
SQL Column:  DURATION
Java Field:  duration
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Duration of the rental.
Added On:  09/23/14
SQL Column:  DUTY_AMT
Java Field:  dutyAmt
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Duty amount for the purchase.
Added On:  08/05/16
SQL Column:  EBT_CARD_SEQ_NUM
Java Field:  ebtCardSeqNum
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Sequence number of the EBT card.
Added On:  09/23/14
SQL Column:  EBT_TYPE
Java Field:  ebtType
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Identifies whether the EBT card is being used for Cashback transactions.
Added On:  09/23/14
SQL Column:  ECOMM_TXN_IND
Java Field:  ecommTxnInd
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
An indicator provided by the merchant to identify the security level of an Ecommerce transaction. In the following description, the term 3-D Secure refers to authentication programs such as Verified by Visa, MasterCard SecureCode and American Express Safekey (AESK).
Added On:  09/23/14
SQL Column:  ECOMM_URL
Java Field:  ecommUrl
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
URL of the site performing the Ecommerce transaction.
Added On:  01/14/15
SQL Column:  EMV_DATA_REQUEST
Java Field:  emvDataRequest
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
The transaction EMV data request block.
Added On:  01/14/15
SQL Column:  EMV_DATA_RESPONSE
Java Field:  emvDataResponse
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
The transaction EMV data response block.
Added On:  09/22/14
SQL Column:  ERROR_DATA
Java Field:  errorData
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
A code and description returned in the response message that describes an error condition encountered when processing the transaction.
Added On:  07/14/16
SQL Column:  FLT_EMP_NUM
Java Field:  fltEmpNum
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Fleet Employee Number of the employee.
Added On:  09/23/14
SQL Column:  FPI
Java Field:  fpi
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
FPI code that may be returned on Debit or PLDebit transaction response.
Added On:  09/23/14
SQL Column:  FRGHT_AMT
Java Field:  frghtAmt
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount for freight included in the purchase.
Added On:  01/19/15
SQL Column:  GIFT_ACCOUNT_NUMBER
Java Field:  giftAccountNumber
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Account number of the gift card used in the transaction.
Added On:  01/23/15
SQL Column:  GIFT_CARD_EXPIRATION_DATE
Java Field:  giftCardExpirationDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Expiration date of a girt card used in the transaction.
Added On:  09/22/14
SQL Column:  GROUP_ID
Java Field:  groupId
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
An ID assigned by First Data, to identify the individual merchant or group of merchants.
Added On:  09/22/14
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  07/14/16
SQL Column:  JOB_ID
Java Field:  jobId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Identifier of the job associated with the merchant.
Added On:  07/14/16
SQL Column:  JOB_NUM
Java Field:  jobNum
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Identifier of the job associated with the eployee.
Added On:  09/23/14
SQL Column:  
Java Field:  keySerialNumData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Used to create the base PIN encryption key for DUKPT PIN Debit and EBT transactions.
Added On:  07/14/16
SQL Column:  LIC_NUM
Java Field:  licNum
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Licence number associated with the employee.
Added On:  09/22/14
SQL Column:  LOCAL_DATE_TIME
Java Field:  localDateTime
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Local date and time when the transaction is processed.
Added On:  06/17/15
SQL Column:  MC_ACI
Java Field:  mcAci
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
MasterCard auth characteristic indicator.
Added On:  06/17/15
SQL Column:  MC_ADD_DATA
Java Field:  mcAddData
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Additional information required for an incremental transaction.
Added On:  03/07/16
SQL Column:  MC_ADD_DATA_RESPONSE
Java Field:  mcAddDataResponse
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  09/23/14
SQL Column:  MC_MSDI
Java Field:  mcMsdi
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Identifies the industry for which the transaction data applies (i.e. healthcare, bill payment, etc.). It must be provided when the transaction is being submitted for one of the categories listed in the Value Set, and has a payment type of Credit.
Added On:  09/23/14
SQL Column:  MC_POS_DATA
Java Field:  mcPosData
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Transaction specific data that may be returned in MasterCard response messages. For merchants that send settlement files directly to PTS, the values in this field would be sent in the XE02 PTS record for MasterCard transactions.
Added On:  09/23/14
SQL Column:  
Java Field:  mcSecrAd
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
A cryptographic value that is generated during the MasterCard transaction authentication process (MasterCard UCAF/ SecureCode) or statically assigned to the merchant by MasterCard. Data must be passed unaltered by the merchant to Rapid Connect.
Added On:  11/20/14
SQL Column:  MCSC
Java Field:  mcsc
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Multiple Clearing Sequence Count. Represents the total number of Completion transactions being submitted for a single previously approved Authorization transaction.
Added On:  06/16/16
SQL Column:  MCSN
Java Field:  mcsn
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Multiple Clearing Sequence Number that represents the sequence number of the capture transaction. This field is used when there are multiple capture transactions for a single previously approved authorization transaction.
Added On:  08/10/16
SQL Column:  MERCH_ADDR
Java Field:  merchAddr
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Address of the merchant.
Added On:  09/22/14
SQL Column:  MERCH_ADVICE_CODE
Java Field:  merchAdviceCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
A code returned by the issuer, used to indicate the decline reason for a recurring transaction.
Added On:  09/22/14
SQL Column:  MERCH_CAT_CODE
Java Field:  merchCatCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Code of the merchant industry category used to classify a business by the type of goods or services it provides.
Added On:  08/10/16
SQL Column:  MERCH_CITY
Java Field:  merchCity
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
City of the merchant billing address.
Added On:  08/10/16
SQL Column:  MERCH_CNTY
Java Field:  merchCnty
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
City of the merchant's mailing address.
Added On:  08/10/16
SQL Column:  MERCH_CTRY
Java Field:  merchCtry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the merchant billing address.
Added On:  08/05/16
SQL Column:  MERCH_FNS_NUM
Java Field:  merchFnsNum
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Number issued by the US Department of Agriculture Food and Nutrition Service that is used in SNAP transactions. For eWIC processing, this field contains the state assigned retailer ID of the merchant.
Added On:  09/22/14
SQL Column:  MERCH_ID
Java Field:  merchId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Unique identifier assigned by FirstData used to identify the merchant within the system.
Added On:  08/10/16
SQL Column:  MERCH_NAME
Java Field:  merchName
Status:  Active
SQL Type:  varchar(38)
Java Type:  String
Attributes:
Name of the merchant.
Added On:  08/10/16
SQL Column:  MERCH_POSTAL_CODE
Java Field:  merchPostalCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Postal code of the merchant billing address.
Added On:  08/10/16
SQL Column:  MERCH_STATE
Java Field:  merchState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code of the merchant billing address.
Added On:  09/23/14
SQL Column:  MERCH_TAX_ID
Java Field:  merchTaxId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Tax ID collected by the merchant for the transaction.
Added On:  09/22/14
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  09/22/14
SQL Column:  MESSAGE_TYPE
Java Field:  messageType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Type of the message.
Added On:  09/22/14
SQL Column:  MRKT_SPECIFIC_DATA_IND
Java Field:  mrktSpecificDataInd
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Identifies the industry for which the transaction data applies (i.e. healthcare, bill payment, etc.). It must be provided when the transaction is being submitted for one of the categories listed in the Value Set, and has a payment type of Credit.
Added On:  07/14/16
SQL Column:  ODO
Java Field:  odo
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Identifier of the vehicle’s odometer reading keyed in by the employee.
Added On:  08/04/16
SQL Column:  ORDER_DATE
Java Field:  orderDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date when the order was submitted.
Added On:  09/22/14
SQL Column:  ORDER_NUM
Java Field:  orderNum
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Number of the order assigned to the transaction.
The value must be numeric and contain no more than 8 bytes of data unless prior approval is provided by FirstData.
Added On:  08/02/16
SQL Column:  ORIG_ATH_NTWK_ID
Java Field:  origAthNtwkId
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
This field contains the Network ID returned in the original authorization response.
Added On:  09/22/14
SQL Column:  ORIG_AUTH_ID
Java Field:  origAuthId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
The Authorization ID of the response to the original message.
Added On:  09/22/14
SQL Column:  ORIG_LOCAL_DATE_TIME
Java Field:  origLocalDateTime
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Local date and time of the original authorization transaction.
Added On:  09/22/14
SQL Column:  ORIG_RESP_CODE
Java Field:  origRespCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response code returned in the original authorization response.
Added On:  09/22/14
SQL Column:  ORIG_STAN
Java Field:  origStan
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
System Trace Audit Number (STAN) of the original transaction.
Added On:  09/22/14
SQL Column:  ORIG_TRAN_DATE_TIME
Java Field:  origTranDateTime
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Transmission date and time of the original transaction (in GMT/UTC).
Added On:  09/22/14
SQL Column:  PART_AUTHRZTN_APPRVL_CAPABLT1
Java Field:  partAuthrztnApprvlCapablt1
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
An identifier used to indicate whether or not the terminal/software can support partial authorization approvals. Partial Authorization support is generally required for all Merchants in card-present environments in order to accommodate cardholder accounts where limited funds may be available (e.g. Debit or Open Loop Prepaid cards). Additionally, Merchant Aggregators and MOTO Merchants are required to support Partial Authorization approvals. Ecommerce merchants have the option to support Partial Authorization approvals and are strongly encouraged to do so.

Note: If a Merchant sends the Partial Authorization Approval Capability indicator of ― "0", when they were required to send the Partial Authorization Approval Capability indicator of ― "1", they will receive higher fees, interchange downgrades or possibly both. For more information, please contact your Account Representative.
Added On:  09/23/14
SQL Column:  
Java Field:  payeeAcctNum
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number of the payee (biller).
Added On:  09/23/14
SQL Column:  PAYEE_ID
Java Field:  payeeId
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Payee ID for the data being submitted for processing.

  • On sale transaction - contains payee (biller) information.
  • On refund transaction - contains the cardholder‘s name.
Added On:  09/23/14
SQL Column:  PAYEE_PHONE_NUM
Java Field:  payeePhoneNum
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
The phone number of the payee (biller) as part of the data being submitted for processing.
Added On:  09/23/14
SQL Column:  PC_ORDER_NUM
Java Field:  pcOrderNum
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
The reference number or order number to be reported as a part of the purchase card data.
Added On:  08/10/16
SQL Column:  PC3_ADD
Java Field:  pc3Add
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Number of Level 3 details in the purchase card transaction.
Added On:  09/23/14
SQL Column:  
Java Field:  pinData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Encrypted PIN block for the Debit or EBT transaction being submitted.
Added On:  08/18/16
SQL Column:  PL_POS_DEBIT_FLG
Java Field:  plPosDebitFlg
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identifier used to indicate whether the terminal/software can support swiped PINLess Debit transactions.
Added On:  08/18/16
SQL Column:  PL_POS_DEBIT_FLG_RESPONSE
Java Field:  plPosDebitFlgResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Response message that indicates whether the swiped PINLess transaction was processed as credit or debit.
Added On:  09/22/14
SQL Column:  POS_COND_CODE
Java Field:  posCondCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
An identifier used to indicate the transaction condition at the POS.
Added On:  09/22/14
SQL Column:  POS_ENTRY_MODE
Java Field:  posEntryMode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
An identifier used to indicate how the account number was entered on the transaction and the PIN entry capability of the POS (Point of Sale).
Added On:  09/23/14
SQL Column:  POS_ENTRY_MODE_CHG
Java Field:  posEntryModeChg
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identifies that POS entry mode was changed by the Issuer.
Added On:  09/02/16
SQL Column:  POS_ID
Java Field:  posId
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Identifies the specific device or point of entry where the transaction originated. For example, pump number, lane number, etc.
Added On:  09/22/14
SQL Column:  PROC_IND
Java Field:  procInd
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Identifies the transaction processing type as returned by MasterCard.
Added On:  12/16/14
SQL Column:  PROC_INFO
Java Field:  procInfo
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Additional information about the issuer returned by MasterCard during the cryptogram validation.
Added On:  09/23/14
SQL Column:  PROD_DESC
Java Field:  prodDesc
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Description of an item purchased with the card.
Added On:  09/22/14
SQL Column:  PROGRAM_ID
Java Field:  programId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
An identifier used by the merchant to designate the preferred authorizer for a prepaid card.
Added On:  09/23/14
SQL Column:  PURCH_IDFR
Java Field:  purchIdfr
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Represents the data used by the merchant or customer to identify the purchase. This can be a SKU, code, or reference number.
Added On:  09/22/14
SQL Column:  PYMT_TYPE
Java Field:  pymtType
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Payment type of the transaction.
Added On:  09/22/14
SQL Column:  REF_NUM
Java Field:  refNum
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Value assigned by a merchant to uniquely reference a transaction and any subsequent related transactions.
Added On:  06/17/15
SQL Column:  RENTAL_CITY
Java Field:  rentalCity
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
City where the car was rented.
Added On:  06/17/15
SQL Column:  RENTAL_CTRY
Java Field:  rentalCtry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
City where the car was rented.
Added On:  06/17/15
SQL Column:  RENTAL_DATE
Java Field:  rentalDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when the car was rented.
Added On:  06/17/15
SQL Column:  RENTAL_DURATION
Java Field:  rentalDuration
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Duration of the car rent.
Added On:  06/17/15
SQL Column:  RENTAL_EXTRA_CHRGS
Java Field:  rentalExtraChrgs
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Rental extra charges.
Added On:  06/17/15
SQL Column:  RENTAL_STATE
Java Field:  rentalState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code where the car was rented.
Added On:  06/17/15
SQL Column:  RENTAL_TIME
Java Field:  rentalTime
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Time when the car was rented.
Added On:  06/17/15
SQL Column:  RENTER_NAME
Java Field:  renterName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Name of the renter.
Added On:  09/22/14
SQL Column:  RESP_CODE
Java Field:  respCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Сode representing status of the transaction.

Note: If the message format is not valid then a RejectResponse message may be returned containing Error Data.
Added On:  09/23/14
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  06/17/15
SQL Column:  RETURN_CITY
Java Field:  returnCity
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
City where the car was returned.
Added On:  10/29/14
SQL Column:  RETURN_CODE
Java Field:  returnCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Return code of the transaction.
Added On:  06/17/15
SQL Column:  RETURN_CTRY
Java Field:  returnCtry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
City where the car was returned.
Added On:  06/17/15
SQL Column:  RETURN_DATE
Java Field:  returnDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when the car was returned.
Added On:  06/17/15
SQL Column:  RETURN_STATE
Java Field:  returnState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code where the car was returned.
Added On:  06/17/15
SQL Column:  RETURN_TIME
Java Field:  returnTime
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Time when the car was returned.
Added On:  09/22/14
SQL Column:  REVERSAL_IND
Java Field:  reversalInd
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Reason code of the transaction that is being reversed.
Added On:  06/17/15
SQL Column:  RT_IND
Java Field:  rtInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Retail transaction indicator.
Added On:  09/23/14
SQL Column:  SAFEKEY
Java Field:  safekey
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The result code to indicate the success or failure of an American Express Safekey transaction.
Added On:  09/22/14
SQL Column:  SERV_CODE
Java Field:  servCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
A three digit value contained in the track data.
Added On:  07/14/16
SQL Column:  SERV_RES_CD
Java Field:  servResCd
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response code generated by the system.
Added On:  06/16/16
SQL Column:  
Java Field:  serviceId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identifier of the merchant assigned by the processor.
Added On:  09/22/14
SQL Column:  SETTLE_IND
Java Field:  settleInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identifies a type of settlement other than Host Capture. This field is not applicable for Host Capture merchants. If sent with a value of 1, then response messages will contain several fields that are normally not returned for host capture merchants, but are needed to build a PTS settlement file. Includes the merchant category code in common group for Debit, PINLess Debit, EBT, and Credit transactions. If the transaction is a MasterCard transaction, MasterCard POS Data in the MasterCard group will also be returned.

Note: Non host capture merchants are required to send the Settlement Indicator on all transactions, including transactions for which there will be no subsequent settlement, e.g. a Prepaid Closed Loop Load.
Added On:  09/23/14
SQL Column:  SHIP_FROM_POSTAL_CODE
Java Field:  shipFromPostalCode
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code the item(s) in the purchase are to be shipped from.
Added On:  06/17/15
SQL Column:  SIG_IND
Java Field:  sigInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Signature indicator.
Added On:  09/22/14
SQL Column:  SOURCE_REASON_CODE
Java Field:  sourceReasonCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The source of the decision for the transaction.
Added On:  11/20/14
SQL Column:  SPEND_Q_IND
Java Field:  spendQInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Response only field representing an indicator that describes whether the transaction met the spend assessment threshold defined by Visa.
Added On:  09/22/14
SQL Column:  STAN
Java Field:  stan
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Number assigned by the merchant to uniquely reference the transaction. This number must be unique within a day per merchant ID and terminal ID.
Added On:  10/29/14
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Status of processing of the transaction.
Added On:  09/22/14
SQL Column:  STTLM_DATE
Java Field:  sttlmDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Date when the transaction will be settled.
Added On:  09/23/14
SQL Column:  TAX_AMT
Java Field:  taxAmt
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of the tax included in the transaction.
Added On:  09/23/14
SQL Column:  TAX_AMT_CAPABLT
Java Field:  taxAmtCapablt
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
An indicator that describes the capability of the terminal to prompt for the tax amount, and then handle the Commercial card type in the response message.
Added On:  09/23/14
SQL Column:  TAX_AMT_CAPABLT_RESPONSE
Java Field:  taxAmtCapabltResponse
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
A response indicator that describes the capability of the terminal to prompt for the tax amount, and then handle the Commercial card type in the response message.
Added On:  09/23/14
SQL Column:  TAX_IND
Java Field:  taxInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identifies the taxable status of the transaction.
Added On:  09/22/14
SQL Column:  TERM_CAT_CODE
Java Field:  termCatCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
An identifier used to describe the type of terminal being used for the transaction.
Added On:  09/22/14
SQL Column:  TERM_ENTRY_CAPABLT
Java Field:  termEntryCapablt
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
An identifier used to indicate the entry mode capability of the terminal.
Added On:  09/22/14
SQL Column:  TERM_ID
Java Field:  termId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Unique identifier assigned by FirstData to identify a terminal.
Added On:  09/22/14
SQL Column:  TERM_LOC_IND
Java Field:  termLocInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates the location of the terminal.
Added On:  03/31/17
SQL Column:  TPP_ID
Java Field:  tppId
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Rapid Connect identifier assigned by FirstData for a specific version of vendor/merchant software.
Added On:  09/23/14
SQL Column:  
Java Field:  track1Data
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Unaltered track 1 data from the magnetic stripe of the card.
Added On:  09/23/14
SQL Column:  
Java Field:  track2Data
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Unaltered track 2 data from the magnetic stripe of the card.
Added On:  09/23/14
SQL Column:  TRAN_EDIT_ERR_CODE
Java Field:  tranEditErrCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identifies the error encountered with the track data provided in the authorization request message.
Added On:  09/22/14
SQL Column:  TRANS_ID
Java Field:  transId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Unique value up to 20 digits assigned by Visa, used to identify and link all related transactions for authorization and settlement through Visa. Сontains transaction identifier and validation code.
Added On:  09/22/14
SQL Column:  TRNMSN_DATE_TIME
Java Field:  trnmsnDateTime
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Transmission date and time of the transaction (in GMT/UTC).
Added On:  11/10/14
SQL Column:  TRNMSN_DATE_TIME_RESPONSE
Java Field:  trnmsnDateTimeResponse
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
The transmission date and time of the transaction (in GMT/UTC) (from provider's response).
Added On:  09/22/14
SQL Column:  TXN_AMT
Java Field:  txnAmt
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of the transaction inclusive of all additional amounts provided in the Additional Amounts Group or other amount fields, e.g. tax amount in Purchase Card L2 Group. It is submitted in the currency represented by the Transaction Currency field. The transaction amount returned in the response will be different than the amount submitted in the request for an approved partial authorization.
Added On:  09/22/14
SQL Column:  TXN_AMT_RESPONSE
Java Field:  txnAmtResponse
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Response for transaction amount.
Added On:  09/22/14
SQL Column:  TXN_CRNCY
Java Field:  txnCrncy
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Numeric currency code of the transaction amount.
Added On:  09/22/14
SQL Column:  TXN_TYPE
Java Field:  txnType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Type of the transaction.
Added On:  09/23/14
SQL Column:  UCAF_COLLECT_IND
Java Field:  ucafCollectInd
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Identifies whether the merchant supports MasterCard UCAF (secure code) data collection.
Added On:  07/14/16
SQL Column:  USER_ID
Java Field:  userId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Identifier of the user within the system assigned by a processor.
Added On:  06/17/15
SQL Column:  VAT_TAX_AMT
Java Field:  vatTaxAmt
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of tax.
Added On:  06/17/15
SQL Column:  VAT_TAX_RT
Java Field:  vatTaxRt
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Rate of tax.
Added On:  07/14/16
SQL Column:  VEH_ID_NUM
Java Field:  vehIdNum
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Identifier of the vehicle associated with the merchant. Assigned by a processor.
Added On:  07/14/16
SQL Column:  VEH_NUM
Java Field:  vehNum
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Number of the vehicle associated with the employee.
Added On:  10/31/16
SQL Column:  VERSION
Java Field:  version
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Version of the software used by the merchant.
Added On:  09/23/14
SQL Column:  
Java Field:  visaSecrTxnAd
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
A cryptographic value that is generated during the VISA transaction authentication process i.e. VISA CAVV (3-D Secure).
Added On:  09/23/14
SQL Column:  
Java Field:  visaXid
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
A unique transaction ID set by the merchant and sent to the issuer authentication/service in the authentication request message. This is an optional transaction ID to identify the Visa 3-D Secure transaction.
Added On:  08/05/16
SQL Column:  VOUCHER_NUM
Java Field:  voucherNum
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Code of the voucher associated with the EBT card.
Added On:  09/22/14
SQL Column:  XCODE_RESP
Java Field:  xcodeResp
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Represents the authorizing agent ID code as received from MasterCard.