Vantiv Lowell Auth Retail Transaction UML
Added On: 02/13/12
Module: UniCharge
Type: Entity
Status: Active
Java Class: VantivLowellAuthRetailTransaction
Added On: 02/13/12
SQL Column: ADDRESS_LINE1
Java Field: addressLine1
Status: Active
SQL Type: varchar(35)
Java Type: String
The elements addressLine1 defines the address information
Added On: 03/11/13
SQL Column: ADVANCED_AVS_RESULT
Java Field: advancedAvsResult
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 02/13/12
SQL Column: AMOUNT
Java Field: amount
Status: Active
SQL Type: int(11)
Java Type: Integer
The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.
Added On: 02/13/12
SQL Column: AUTH_CODE
Java Field: authCode
Status: Active
SQL Type: varchar(6)
Java Type: String
The authCode element it specifies the authorization code from the associated Authorization transaction.
Added On: 02/13/12
SQL Column: AUTHENTICATION_RESULT
Java Field: authenticationResult
Status: Active
SQL Type: varchar(1)
Java Type: String
The authenticationResult element defines the Visa CAVV Result code (from Verified by Visa).
Added On: 06/16/16
SQL Column:
Java Field: authenticationTransactionId
Status: Active
SQL Type:
Java Type: String
Added On: 06/16/16
SQL Column:
Java Field: authenticationValue
Status: Active
SQL Type:
Java Type: String
Added On: 02/13/12
SQL Column: AVS_RESULT
Java Field: avsResult
Status: Active
SQL Type: varchar(2)
Java Type: String
The avsResult defines the Address Verification response code returned by the networks.
Added On: 02/13/12
SQL Column: BIN
Java Field: bin
Status: Active
SQL Type: varchar(6)
Java Type: String
The BIN element provides the 6-digit Bank (or Issuer) Identification Number of the Issuing Bank. The system returns this value in XML responses when issuing new tokens to replace Visa or MasterCard account numbers. For Discover and American Express cards, this element is empty.
Added On: 02/13/12
SQL Column: CAPABILITY
Java Field: capability
Status: Active
SQL Type: varchar(10)
Java Type: String
The capability element is a required child of the pos element, which describes the capability of the point of sale terminal.
Added On: 06/16/16
SQL Column:
Java Field: cardValidationNum
Status: Active
SQL Type:
Java Type: String
Added On: 02/13/12
SQL Column: CARD_VALIDATION_RESULT
Java Field: cardValidationResult
Status: Active
SQL Type: varchar(2)
Java Type: String
The cardValidationResult defines the Card Validation response code returned by the networks.
Added On: 02/13/12
SQL Column: CARDHOLDER_ID
Java Field: cardholderId
Status: Active
SQL Type: varchar(12)
Java Type: String
The cardholderId element is a required child of the pos element, which describes the method used for cardholder identification at the point of sale.
Added On: 02/13/12
SQL Column: CHARGE_TRANSACTION_FK
Java Field: chargeTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents real-time financial transaction.
Added On: 02/13/12
SQL Column: CITY
Java Field: city
Status: Active
SQL Type: varchar(35)
Java Type: String
The city element defines the customer’s city name
Added On: 03/11/13
SQL Column: CLINIC_OTHER_AMOUNT
Java Field: clinicOtherAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
This value is used to submit the amount of all Clinical or other qualified medical expenses contained within this purchase.
Added On: 02/13/12
SQL Column: CUSTOMER_ID
Java Field: customerId
Status: Active
SQL Type: varchar(50)
Java Type: String
A value assigned by the merchant to identify the consumer.
Added On: 03/11/13
SQL Column: DENTAL_AMOUNT
Java Field: dentalAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 02/13/12
SQL Column: EMAIL
Java Field: email
Status: Active
SQL Type: varchar(100)
Java Type: String
The email element defines the email address of the customer
Added On: 02/13/12
SQL Column: ENTRY_MODE
Java Field: entryMode
Status: Active
SQL Type: varchar(12)
Java Type: String
The entryMode element is a required child of the pos element, which describes the method used for card data entry at the point of sale.
Added On: 06/16/16
SQL Column:
Java Field: expDate
Status: Active
SQL Type:
Java Type: String
Added On: 02/13/12
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
Attributes:
Unique, Required
Identifier of the object used for references; auto-incremented integer value.
Added On: 02/13/12
SQL Column: LITLE_TOKEN
Java Field: litleToken
Status: Active
SQL Type: varchar(25)
Java Type: String
The litleToken element defines the value of the token. The system returns this value in XML responses when issuing new tokens to replace account numbers.
Added On: 02/13/12
SQL Column: LITLE_TXN_ID
Java Field: litleTxnId
Status: Active
SQL Type: varchar(19)
Java Type: String
The litleTxnId element is used to identify transactions in the Litle system. The system returns this element in XML responses. You use it in various requests to reference the original transaction.
Added On: 02/13/12
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: 02/13/12
SQL Column: MERCHANT_ID
Java Field: merchantId
Status: Active
SQL Type: varchar(50)
Java Type: String
The merchantId element is used when you request an Account Update file. This value is a unique string used to identify the merchant within the Litle system.
Added On: 02/13/12
SQL Column: MESSAGE
Java Field: message
Status: Active
SQL Type: varchar(512)
Java Type: String
The message element provides a brief definition of the response code.
Added On: 02/13/12
SQL Column: NAME
Java Field: name
Status: Active
SQL Type: varchar(100)
Java Type: String
The name element defines the customer name.
Added On: 01/15/18
SQL Column: NETWORK_TRANSACTION_ID
Java Field: networkTransactionId
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 06/16/16
SQL Column:
Java Field: number
Status: Active
SQL Type:
Java Type: String
Added On: 02/13/12
SQL Column: ORDER_ID
Java Field: orderId
Status: Active
SQL Type: varchar(25)
Java Type: String
The orderId element defines a merchant-assigned value representing the order in the merchant’s system.
Added On: 02/13/12
SQL Column: ORDER_SOURCE
Java Field: orderSource
Status: Active
SQL Type: varchar(17)
Java Type: String
The orderSource element defines the order entry source for the type of transaction.
Added On: 01/15/18
SQL Column: ORIGINAL_NETWORK_TRANSACTION_ID
Java Field: originalNetworkTransactionId
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 06/16/16
SQL Column:
Java Field: password
Status: Active
SQL Type:
Java Type: String
Added On: 12/09/13
SQL Column: PAYPAGE_REGISTRATION_ID
Java Field: paypageRegistrationId
Status: Active
SQL Type: varchar(512)
Java Type: String
Added On: 02/13/12
SQL Column: PHONE
Java Field: phone
Status: Active
SQL Type: varchar(20)
Java Type: String
Defines the customers phone number.
Added On: 02/13/12
SQL Column: POST_DATE
Java Field: postDate
Status: Active
SQL Type: varchar(10)
Java Type: String
The postDate element defines the date the transaction was posted. The format is YYYY-MM-DD. It occurs only in response to Online transactions.
Added On: 01/15/18
SQL Column: PROCESSING_TYPE
Java Field: processingType
Status: Active
SQL Type: varchar(18)
Java Type: String
Added On: 02/13/12
SQL Column: REPORT_GROUP
Java Field: reportGroup
Status: Active
SQL Type: varchar(10)
Java Type: String
Defines the merchant sub-group in the user interface where this transaction will be displayed.
Added On: 02/13/12
SQL Column: REQUEST_ID
Java Field: requestId
Status: Active
SQL Type: varchar(25)
Java Type: String
Added On: 02/13/12
SQL Column: RESPONSE
Java Field: response
Status: Active
SQL Type: varchar(3)
Java Type: String
The response element contains a three digit numeric code which specifies either that the transaction is approved (000 code) or declined.
Added On: 02/13/12
SQL Column: RESPONSE_TIME
Java Field: responseTime
Status: Active
SQL Type: varchar(19)
Java Type: String
The responseTime element provides a date/time stamp of the response. The format of the element is YYYY-MM-DDTHH:MM:SS.
Added On: 02/13/12
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: 03/11/13
SQL Column: RX_AMOUNT
Java Field: rxAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 02/13/12
SQL Column: STATE
Java Field: state
Status: Active
SQL Type: varchar(30)
Java Type: String
The state element defines the customer’s state name
Added On: 08/01/14
SQL Column: TERMINAL_ID
Java Field: terminalId
Status: Active
SQL Type: varchar(10)
Java Type: String
Added On: 02/13/12
SQL Column: TOKEN_MESSAGE
Java Field: tokenMessage
Status: Active
SQL Type: varchar(255)
Java Type: String
The tokenMessage element contains a short, human-readable explanation of the tokenResponseCode.
Added On: 02/13/12
SQL Column: TOKEN_RESPONSE_CODE
Java Field: tokenResponseCode
Status: Active
SQL Type: varchar(3)
Java Type: String
The tokenResponseCode element provides a 3-digit code indicating the results of a transaction involving the conversion or attempted conversion of an account number to a token.
Added On: 03/11/13
SQL Column: TOTAL_HEALTHCARE_AMOUNT
Java Field: totalHealthcareAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/16/16
SQL Column:
Java Field: track
Status: Active
SQL Type:
Java Type: String
Added On: 02/13/12
SQL Column: TRANSACTION_TYPE
Java Field: transactionType
Status: Active
SQL Type: varchar(1)
Java Type: String
We use such values:
C - Credit Transactions
A - Authorization Transactions
V - Void Transactions
The Credit transaction enables you to refund money to a customer, even if the original transaction occurred outside of the Litle & Co. system.
The Authorization transaction enables you to confirm that a customer has submitted a valid payment method with their order and has sufficient funds to purchase the goods or services they ordered.
You use a Void transaction to cancel a transaction that occurred during the same business day.
Added On: 02/13/12
SQL Column: TYPE
Java Field: type
Status: Active
SQL Type: varchar(2)
Java Type: String
Defines the type of account used in the transaction.
We use such values:
VI -Visa Credit, Visa Debit,
MC - MasterCard Credit, MasterCard Debit,
AX - Amex,
DI - Discover,
DC - Dinners
or empty
Added On: 02/13/12
SQL Column: USER
Java Field: user
Status: Active
SQL Type: varchar(20)
Java Type: String
The user element is a required child of the authentication element. It is a unique identifier of the user/merchant used to authenticate that the message is from a valid source.
Added On: 03/11/13
SQL Column: VISION_AMOUNT
Java Field: visionAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 02/13/12
SQL Column: VOID_LITLE_TXN_ID
Java Field: voidLitleTxnId
Status: Active
SQL Type: varchar(19)
Java Type: String
Added On: 02/13/12
SQL Column: ZIP
Java Field: zip
Status: Active
SQL Type: varchar(20)
Java Type: String
The ZIP element defines the customer’s postal code.