Vantiv Lowell Batch Transaction UML


Added On:  02/13/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  VantivLowellBatchTransaction 
Entity that represents a batch transaction as it is defined in Vantiv Lowell's batch processing specification.
Added On:  06/14/16
SQL Column:  
Java Field:  accNum
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number of the customer.
Added On:  02/13/12
SQL Column:  ACC_TYPE
Java Field:  accType
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
The accType element is a required child of the echeck, originalAccountInfo, and newAccountInfo elements defining the type of eCheck account used in the transaction.
We use such values:
Checking, Savings, Corporate
Added On:  02/13/12
SQL Column:  ADDRESS_LINE1
Java Field:  addressLine1
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
The element addressLine1 define the address information in both the billToAddress and shipToAddress elements.
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 specifies the authorization code from the associated Authorization or Sale transaction.
Added On:  02/13/12
SQL Column:  AVS_RESULT
Java Field:  avsResult
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The avsResult element is an optional child element of the fraudResult element. It 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:  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 in the billToAddress and shipToAddress elements. In the customBilling element, city defines the location of the merchant for card-present transactions.
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:  06/14/16
SQL Column:  
Java Field:  expDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/12/14
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
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/12/14
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
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. The length of the token is the same as the length of the submitted account number for credit card tokens or a fixed length of seventeen (17) characters for eCheck account tokens.
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. For example, when you submit a Capture transaction, you include the litleTxnId for the associated Authorization.
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:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
The message element contains a brief definition of the response code returned for the transaction.
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 in both the billToAddress and shipToAddress elements.

The name element is required for Echeck transactions. If you do not submit the customer name in an Echeck transaction, Litle returns Response Code 330 - Invalid Payment Type.
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/14/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(9)
Java Type:  String
Attributes:
The orderSource element defines the order entry source for the type of transaction.

If you submit the wrong <orderSource> value, Litle returns the response code 370 - Internal System Error - Contact Litle.
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:  01/15/18
SQL Column:  PROCESSING_TYPE
Java Field:  processingType
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Added On:  03/04/13
SQL Column:  REPORT_GROUP
Java Field:  reportGroup
Status:  Active
SQL Type:  varchar(10)
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. The message element provides a brief definition of the response code.
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:  06/14/16
SQL Column:  
Java Field:  routingNum
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
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 in both the billToAddress and shipToAddress elements.
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:  02/13/12
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Litle Batch processing supports all transaction types except Voids and eCheck Voids, which are handled as Online transactions only. We use such transaction types as:
ES - eCheck Sales Transaction
EC - eCheck Credit Transaction
S - Sales Transaction
C - Credit Transaction
Added On:  02/13/12
SQL Column:  TYPE
Java Field:  type
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The type element defines the card type in terms of prepaid, credit, debit, FSA, or unknown.
We use such values:
VI -Visa Credit, Visa Debit,
MC - MasterCard Credit, MasterCard Debit,
AX - Amex,
DI - Discover,
DC - Dinners
or empty
Added On:  07/05/16
SQL Column:  VANTIV_LOWELL_BATCH_FK
Java Field:  vantivLowellBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Vantiv Lowell Batch
Attributes:
Reference to the entity that represents provider charge transaction information.
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 in both the billToAddress and shipToAddress elements.

Although the schema specifies the maxLength of the <zip> element as 20 characters, in practice you should never exceed 10 characters in your submissions.