Heartland Portico Auth Retail Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  04/26/13 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  HeartlandPorticoAuthRetailTransaction 
                    
        
        
     
    
        
            
                
                    Heartland Portico specific low-level representation of Retail Transaction produced by 
Forward Transformation Process within 
Authorization Process.
During 
Generation Process, Heartland Portico specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
                
 
         
     
        
        
                    
                        
                Added On:  08/27/14
                SQL Column:  ACTION
                Java Field:  action
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of Alias action requested
Valid values are as follows: DELETE, ADD, CREATE.                        
                     
                 
             
                    
                        
                Added On:  08/27/14
                SQL Column:  ALIAS
                Java Field:  alias
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Alternate identifier used to reference a stored value account.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  ALLOW_PARTIAL_AUTH
                Java Field:  allowPartialAuth
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether partial authorization is supported. Default is 'N'.
Valid values = 'Y' or 'N'.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  AMT
                Java Field:  amt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains total amount of additional amounts.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  AUTH_AMT
                Java Field:  authAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If supplied from the Issuer on a partial authorization, the authorized amount (lass than the original or requested amount).
                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  AUTH_CODE
                Java Field:  authCode
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If authorized, authorization code returned by the Issuer.
Maximum characters = 8                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  AVAILABLE_BALANCE
                Java Field:  availableBalance
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If supplied from the Issuer, the available balance on the associated card.
                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  AVS_RSLT_CODE
                Java Field:  avsRsltCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Required Address verification result code.
Maximum length = 1                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  AVS_RSLT_TEXT
                Java Field:  avsRsltText
             
            
                Status:  Active
                SQL Type:  varchar(200)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Description of AVS result code.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  BALANCE_AMOUNT
                Java Field:  balanceAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If authorized, the new balance on the gift card.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  BALANCE_INQUIRY_TYPE
                Java Field:  balanceInquiryType
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Balance Inquiry Type:
CASH = Cash Benefits
FOODSTAMP = Food Stamp                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_ADDR
                Java Field:  cardHolderAddr
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder address that can be used for address verification.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_CITY
                Java Field:  cardHolderCity
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder city.
Maximum length = 20.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_EMAIL
                Java Field:  cardHolderEmail
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder email address.
Maximum length = 40.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_FIRST_NAME
                Java Field:  cardHolderFirstName
             
            
                Status:  Active
                SQL Type:  varchar(26)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder first name.
Maximum length = 26.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_LAST_NAME
                Java Field:  cardHolderLastName
             
            
                Status:  Active
                SQL Type:  varchar(26)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder last name.
Maximum length = 26.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_PHONE
                Java Field:  cardHolderPhone
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder phone number.
Maximum length = 10.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_PO_NBR
                Java Field:  cardHolderPoNbr
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Purchase order number assigned by the cardholder.
Maximum length = 17.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_STATE
                Java Field:  cardHolderState
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder state.
Maximum length = 20.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_HOLDER_ZIP
                Java Field:  cardHolderZip
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cardholder zip code that can be used for address verification.
Maximum length = 9.                        
                     
                 
             
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  cardNbr
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        The number of the credit card or bank account.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_PRESENT
                Java Field:  cardPresent
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether a card reader was present when card data was manually entered.
Valid values = Y or N.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CARD_TYPE
                Java Field:  cardType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/26/13
                SQL Column:  CASH_BACK_AMT_INFO
                Java Field:  cashBackAmtInfo
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cash back amount information, the portion of the settlement amount that represents cash back given to the cardholder.
                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents transaction of type Sale.                         
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CPC_IND
                Java Field:  cpcInd
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If the commercial card was specified in the request, the commercial card response indicator returned by the Issuer.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CPC_REQ
                Java Field:  cpcReq
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Commercial card request.
Valid values = Y or N.                        
                     
                 
             
                    
                        
                Added On:  08/02/14
                SQL Column:  CURRENCY
                Java Field:  currency
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies the currency of the transaction amount.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CVV_RSLT_CODE
                Java Field:  cvvRsltCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Result code if CW was requested.
Maximum length = 1                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CVV_RSLT_TEXT
                Java Field:  cvvRsltText
             
            
                Status:  Active
                SQL Type:  varchar(200)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Description of CVV result code.                        
                     
                 
             
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  cvv2
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Card verification code on the card.
Maximum length = 6.
                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  CVV2_STATUS
                Java Field:  cvv2Status
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates why the CVV2 value was not provided. Valid values include: ILLEGIBLE and NOTPRESENT.
Note:This field is NOT used for EBT transactions.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  DEVELOPER_ID
                Java Field:  developerId
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Developer Identifier, field length is exactly 6 characters.
NOTE: Even though this field is optional in the schema, it is now required for all new certifications.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  DEVICE_ID
                Java Field:  deviceId
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Device identifier, assigned by Heartland Payment Systems during registration.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  DIRECT_MKT_INVOICE_NBR
                Java Field:  directMktInvoiceNbr
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Invoice number for direct marketing.
Maximum length = 25.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  DIRECT_MKT_SHIP_DAY
                Java Field:  directMktShipDay
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Ship day for direct marketing.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  DIRECT_MKT_SHIP_MONTH
                Java Field:  directMktShipMonth
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Ship month for direct marketing.
                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  ECOMMERCE
                Java Field:  ecommerce
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies this transaction as eCommerce or mail order/telephone order.
Valid values = ECOM or MOTO                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  ELECTRONIC_VOUCHER_SERIAL_NBR
                Java Field:  electronicVoucherSerialNbr
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Serial Number provides by EBT voice authorization System.                        
                     
                 
             
                    
                        
                Added On:  03/19/15
                SQL Column:  
                Java Field:  emvRequest
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  03/19/15
                SQL Column:  EMV_RESPONSE
                Java Field:  emvResponse
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        The response received from EMV.                        
                     
                 
             
                    
                        
                Added On:  03/19/15
                SQL Column:  EXP_MONTH
                Java Field:  expMonth
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        The card expiration date. The format is MM.                        
                     
                 
             
                    
                        
                Added On:  03/19/15
                SQL Column:  EXP_YEAR
                Java Field:  expYear
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        The card expiration date. The format is YY.                        
                     
                 
             
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  exprDate
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Voucher Expiration date.
The format is MMYY.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  FIRST_ADDITIONAL_AMT
                Java Field:  firstAdditionalAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        First Amount object. 
The first amount must have an AmtType of "4S."                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  FIRST_ADDITIONAL_AMT_TYPE
                Java Field:  firstAdditionalAmtType
             
            
                Status:  Active
                SQL Type:  varchar(28)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The first amount type is '4S'.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  FOURTH_ADDITIONAL_AMT
                Java Field:  fourthAdditionalAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/26/13
                SQL Column:  FOURTH_ADDITIONAL_AMT_TYPE
                Java Field:  fourthAdditionalAmtType
             
            
                Status:  Active
                SQL Type:  varchar(28)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of forth amount object: date and time.                         
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  GATEWAY_RSP_CODE
                Java Field:  gatewayRspCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response code returned by the POS Gateway.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  GATEWAY_RSP_MSG
                Java Field:  gatewayRspMsg
             
            
                Status:  Active
                SQL Type:  varchar(250)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response message returned by the POS Gateway.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  GATEWAY_TXN_ID
                Java Field:  gatewayTxnId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Transaction identifier assigned by POS Gateway.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  GRATUITY_AMT_INFO
                Java Field:  gratuityAmtInfo
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If present, revises (replaces) the gratuity amount information of the original auth. If not present, does not affect the gratuity amount information, if any, of the original auth. This element is for informational purposes only and does not affect the authorized amount.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required, CreateOnly, ReadOnly                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  INVOICE_NBR
                Java Field:  invoiceNbr
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Invoice number for direct marketing. 
Maximum length = 25                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  LICENSE_ID
                Java Field:  licenseId
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        License identifier, assigned by Heartland Payment Systems Administrator during registration.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_ADVANCED_DEPOSIT_TYPE
                Java Field:  lodgingAdvancedDepositType
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the type of advanced lodging deposit.
Valid values: ASSURED_RESERVATION, CARD_ DEPOSIT, PURCHASE, OTHER.
                        
                     
                 
             
                    
                        
                Added On:  07/06/15
                SQL Column:  LODGING_CHECK_IN_DATE
                Java Field:  lodgingCheckInDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the check in date.                        
                     
                 
             
                    
                        
                Added On:  07/06/15
                SQL Column:  LODGING_CHECK_OUT_DATE
                Java Field:  lodgingCheckOutDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the check out date.                        
                     
                 
             
                    
                        
                Added On:  07/06/15
                SQL Column:  LODGING_DURATION
                Java Field:  lodgingDuration
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Indicates the duration of stay.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_EXTRA_CHARGES_GIFT_SHOP
                Java Field:  lodgingExtraChargesGiftShop
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the extra charge is included in the bill.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_EXTRA_CHARGES_LAUNDRY
                Java Field:  lodgingExtraChargesLaundry
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the extra charge is included in the bill.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_EXTRA_CHARGES_MINI_BAR
                Java Field:  lodgingExtraChargesMiniBar
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the extra charge is included in the bill.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_EXTRA_CHARGES_OTHER
                Java Field:  lodgingExtraChargesOther
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the extra charge is included in the bill.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_EXTRA_CHARGES_RESTAURANT
                Java Field:  lodgingExtraChargesRestaurant
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the extra charge is included in the bill.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_EXTRA_CHARGES_TELEPHONE
                Java Field:  lodgingExtraChargesTelephone
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the extra charge is included in the bill.                        
                     
                 
             
                    
                        
                Added On:  07/06/15
                SQL Column:  LODGING_FOLIO_NUMBER
                Java Field:  lodgingFolioNumber
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to identify lodging transaction by the lodging system/software.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  LODGING_NO_SHOW
                Java Field:  lodgingNoShow
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the extra charge is included in the bill.                        
                     
                 
             
                    
                        
                Added On:  07/06/15
                SQL Column:  LODGING_ROOM_RATE_AMOUNT
                Java Field:  lodgingRoomRateAmount
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the daily room rate amount.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        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:  03/19/15
                SQL Column:  NEW_CARD_NBR
                Java Field:  newCardNbr
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  03/19/15
                SQL Column:  NEW_TRACK_DATA
                Java Field:  newTrackData
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        New track data read from the card by the card reader.                        
                     
                 
             
                    
                        
                Added On:  08/02/14
                SQL Column:  NOTES
                Java Field:  notes
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains rewards messages to be displayed on a receipt, mobile app, or web page to inform an account holder about special rewards or promotions available on the account.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  OFFLINE_AUTH_CODE
                Java Field:  offlineAuthCode
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Authorization code obtained from the Issuer outside of the POS Gateway.
Maximum characters = 8                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  ONE_TIME_PAYMENT
                Java Field:  oneTimePayment
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether this is a one time payment (Y) or a recurring payment.
Valid values = Y or N.                        
                     
                 
             
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  password
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  pinBlock
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/02/14
                SQL Column:  POINTS_BALANCE_AMT
                Java Field:  pointsBalanceAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If authorized, the new balance on the stored value account in points.                        
                     
                 
             
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  primaryAcctNbr
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Customer Primary Account Number.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  READER_PRESENT
                Java Field:  readerPresent
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether a card reader was present when card data was manually entered.
Valid values = Y or N.                        
                     
                 
             
                    
                        
                Added On:  06/14/13
                SQL Column:  REAL_TIME_SUBSTANTIATION
                Java Field:  realTimeSubstantiation
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates if a Merchant used an Inventory Approval System to verify items purchased qualify for healthcare auto-substantiation. Default is 'N'.
Valid values = Y or N.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  REF_NBR
                Java Field:  refNbr
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Reference number returned by the Issuer.
Maximum characters = 12                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  REFUND_AMOUNT
                Java Field:  refundAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If authorized, the new balance that was on the card before it was deactivated and should be refunded to the cardholder.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  REQUEST_TYPE
                Java Field:  requestType
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains an identifier to aid in determining the type of client's request.                         
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
                Java Field:  retailTransactionCycle
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents a group of real-time transactions which must be settled together.                        
                     
                 
             
                    
                        
                Added On:  08/02/14
                SQL Column:  REWARDS
                Java Field:  rewards
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies rewards (dollars or points) added to the account as a result of a transaction.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  RSP_CODE
                Java Field:  rspCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Authorization response code returned by the Issuer.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  RSP_DT
                Java Field:  rspDt
             
            
                Status:  Active
                SQL Type:  varchar(27)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The transaction response date and time in the merchant's time zone that is stored on the POS Gateway. This is expected to be used for printing date and time on receipts.                         
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  RSP_TEXT
                Java Field:  rspText
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Authorization response text returned by the Issuer. 
                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  SECOND_ADDITIONAL_AMT
                Java Field:  secondAdditionalAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/26/13
                SQL Column:  SECOND_ADDITIONAL_AMT_TYPE
                Java Field:  secondAdditionalAmtType
             
            
                Status:  Active
                SQL Type:  varchar(28)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/26/13
                SQL Column:  SITE_ID
                Java Field:  siteId
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Site identifier, assigned by Heartland Payment Systems during registration.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  SITE_TRACE
                Java Field:  siteTrace
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Site trace, specified by client and echoed in the response for validation.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  SPLIT_TENDER_BALANCE_DUE_AMT
                Java Field:  splitTenderBalanceDueAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If insufficient funds on gift card to complete sale, the portion of the total sale that was not funded by the gift card and thus is still due from the cardholder.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  SPLIT_TENDER_CARD_AMT
                Java Field:  splitTenderCardAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        If insufficient funds on gift card to complete sale, the split tender portion of the total sale that was subtracted from the gift card balance.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  TAX_AMT
                Java Field:  taxAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/26/13
                SQL Column:  TAX_TYPE
                Java Field:  taxType
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Tax type indicator that qualifies the CPC tax amount.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  THIRD_ADDITIONAL_AMT
                Java Field:  thirdAdditionalAmt
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/26/13
                SQL Column:  THIRD_ADDITIONAL_AMT_TYPE
                Java Field:  thirdAdditionalAmtType
             
            
                Status:  Active
                SQL Type:  varchar(28)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  trackData
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Track data read from the card by the card reader.                        
                     
                 
             
                    
                        
                Added On:  07/10/15
                SQL Column:  TRACK_DATA_METHOD
                Java Field:  trackDataMethod
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to indicate how the associated track data was obtained. The valid values for Method are Swipe or Proximity. 
Example of the XML follows: 
<TrackData method="swipe">
 ...full data from MSR here... 
</TrackData>                         
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  USER_NAME
                Java Field:  userName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        User name, assigned by Heartland Payment Systems Administrator during registration.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  VERSION_NBR
                Java Field:  versionNbr
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        POS Version Number. 
NOTE: Even though this field is optional in the schema, it is now required for all new certifications.                        
                     
                 
             
                    
                        
                Added On:  04/26/13
                SQL Column:  VOUCHER_APPROVAL_CD
                Java Field:  voucherApprovalCd
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Provided by EBT Voice Authorization System.