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.