Vantiv Lowell Auth Retail Transaction UML


Added On:  02/13/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  VantivLowellAuthRetailTransaction 
Vantiv Lowell specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Vantiv Lowell specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  02/13/12
SQL Column:  ADDRESS_LINE1
Java Field:  addressLine1
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Transient
Added On:  06/16/16
SQL Column:  
Java Field:  authenticationValue
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/13/12
SQL Column:  AVS_RESULT
Java Field:  avsResult
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Transient
Added On:  02/13/12
SQL Column:  CARD_VALIDATION_RESULT
Java Field:  cardValidationResult
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
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
Attributes:
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
References Charge Transaction
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes: Transient
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
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
Attributes:
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
Attributes:
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
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  02/13/12
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  06/16/16
SQL Column:  
Java Field:  number
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/13/12
SQL Column:  ORDER_ID
Java Field:  orderId
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
Added On:  06/16/16
SQL Column:  
Java Field:  password
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  12/09/13
SQL Column:  PAYPAGE_REGISTRATION_ID
Java Field:  paypageRegistrationId
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  REPORT_GROUP
Java Field:  reportGroup
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  RESPONSE
Java Field:  response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  TOKEN_MESSAGE
Java Field:  tokenMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
Added On:  06/16/16
SQL Column:  
Java Field:  track
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/13/12
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  02/13/12
SQL Column:  VOID_LITLE_TXN_ID
Java Field:  voidLitleTxnId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The ZIP element defines the customer’s postal code.