Vantiv Lowell Sub Merchant Transaction UML
Added On: 04/16/13
Module: UniCharge
Type: Entity
Status: Active
Java Class: VantivLowellSubMerchantTransaction
Represents submerchant account creation transaction as it is defined in Vantiv Lowell's provisioning specification.
Added On: 09/30/16
SQL Column: ACCOUNT_NUMBER_MASKED
Java Field: accountNumberMasked
Status: Active
SQL Type: varchar(25)
Java Type: String
Masked account number assigned to the transaction processing of the sub-merchant.
Added On: 04/16/13
SQL Column: AMEX_MID
Java Field: amexMid
Status: Active
SQL Type: varchar(15)
Java Type: String
Existing merchant ID with American Express.
Added On: 09/02/14
SQL Column: AMEX_SELLER_ID
Java Field: amexSellerId
Status: Active
SQL Type: varchar(10)
Java Type: String
Identification number of the AmEx seller account.
Added On: 09/12/14
SQL Column:
Java Field: bankAccountNumber
Status: Active
SQL Type:
Java Type: String
Merchant bank account number.
Transient field.
Added On: 09/12/14
SQL Column:
Java Field: bankRoutingNumber
Status: Active
SQL Type:
Java Type: String
Routing number (expiration date) of the merchant's bank account.
Added On: 04/16/13
SQL Column: CC_VANTIV_LOWELL_PROFILE_FK
Java Field: ccVantivLowellProfile
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents credit card merchant profile information.
Added On: 04/16/13
SQL Column: CITY
Java Field: city
Status: Active
SQL Type: varchar(35)
Java Type: String
City of the merchant's mailing address.
Added On: 04/16/13
SQL Column: COUNTRY_CODE
Java Field: countryCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Country code of the merchant's mailing address.
Added On: 04/16/13
SQL Column: CREATE_CREDENTIALS
Java Field: createCredentials
Status: Active
SQL Type: varchar(5)
Java Type: String
Added On: 06/20/14
SQL Column: CREATE_DATE
Java Field: createDate
Status: Active
SQL Type: datetime
Java Type: Date
Date when the record was created.
Added On: 04/16/13
SQL Column: CUSTOMER_SERVICE_NUMBER
Java Field: customerServiceNumber
Status: Active
SQL Type: varchar(13)
Java Type: String
Service phone number of the merchant used for discussing any processing issues.
Added On: 05/10/13
SQL Column: DISABLED
Java Field: disabled
Status: Active
SQL Type: varchar(5)
Java Type: String
Indicates whether merchant profile is disabled.
Added On: 04/16/13
SQL Column: DISCOVER_CONVEYED_MID
Java Field: discoverConveyedMid
Status: Active
SQL Type: varchar(15)
Java Type: String
Merchant identifier associated with Discover, assigned by a processor.
Added On: 05/10/13
SQL Column: ECHECK_BILLING_DESCRIPTOR
Java Field: echeckBillingDescriptor
Status: Active
SQL Type: varchar(10)
Java Type: String
Description of the e-check billing assigned to the sub-merchant.
Added On: 05/10/13
SQL Column: ECHECK_COMPANY_NAME
Java Field: echeckCompanyName
Status: Active
SQL Type: varchar(16)
Java Type: String
Name of the company that assigns the e-checks.
Added On: 04/16/13
SQL Column: EFT_VANTIV_LOWELL_PROFILE_FK
Java Field: eftVantivLowellProfile
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents EFT profile of the merchant.
Added On: 04/16/13
SQL Column: EMAIL_ADDRESS
Java Field: emailAddress
Status: Active
SQL Type: varchar(100)
Java Type: String
Legal email address of the merchant.
Added On: 04/24/13
SQL Column: ERROR_MESSAGE
Java Field: errorMessage
Status: Active
SQL Type: varchar(512)
Java Type: String
Message explaining the occured error.
Added On: 04/16/13
SQL Column: FIRST_NAME
Java Field: firstName
Status: Active
SQL Type: varchar(50)
Java Type: String
First name of the merchant.
Added On: 04/16/13
SQL Column: HARD_CODED_BILLING_DESCRIPTOR
Java Field: hardCodedBillingDescriptor
Status: Active
SQL Type: varchar(25)
Java Type: String
Hardcoded description of the billing assigned to the sub-merchant.
Added On: 04/16/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/25/16
SQL Column: IS_AMEX_ACQUIRED
Java Field: isAmexAcquired
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Identifies whether processing of Amex associated transactions is required.
Added On: 09/30/16
SQL Column: IS_ECHECK_ENABLED
Java Field: IsEcheckEnabled
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Indicates whether e-checks are enabled for payment.
Added On: 04/16/13
SQL Column: LAST_NAME
Java Field: lastName
Status: Active
SQL Type: varchar(50)
Java Type: String
Last name of the merchant.
Added On: 04/16/13
SQL Column: LEGAL_ENTITY_ID
Java Field: legalEntityId
Status: Active
SQL Type: varchar(19)
Java Type: String
Identifier of the legal entity assigned to the sub-merchant.
Added On: 04/16/13
SQL Column: MAX_TRANSACTION_AMOUNT
Java Field: maxTransactionAmount
Status: Active
SQL Type: varchar(19)
Java Type: String
Maximum possible amount of the transaction.
Added On: 04/16/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: 04/16/13
SQL Column: MERCHANT_CATEGORY_CODE
Java Field: merchantCategoryCode
Status: Active
SQL Type: varchar(4)
Java Type: String
Category code of the selected merchant.
Added On: 05/10/13
SQL Column: MERCHANT_IDENT_STRING
Java Field: merchantIdentString
Status: Active
SQL Type: varchar(19)
Java Type: String
Merchant identifier string.
Added On: 04/16/13
SQL Column: MERCHANT_NAME
Java Field: merchantName
Status: Active
SQL Type: varchar(50)
Java Type: String
Name of the merchant in the system.
Added On: 09/12/14
SQL Column:
Java Field: password
Status: Active
SQL Type:
Java Type: String
Password of the client used to login the merchant's paypage.
Added On: 05/10/13
SQL Column: PAYPAGE_ID
Java Field: paypageId
Status: Active
SQL Type: varchar(16)
Java Type: String
Identification number of the pay[page used by this merchant.
Added On: 05/10/13
SQL Column: PAYPAGE_USERNAME
Java Field: paypageUsername
Status: Active
SQL Type: varchar(20)
Java Type: String
Username of the client used to login the paypage of the merchant.
Added On: 04/16/13
SQL Column: PHONE
Java Field: phone
Status: Active
SQL Type: varchar(13)
Java Type: String
Phone number of the merchant used for discussing any processing issues.
Added On: 09/30/16
SQL Column: PORTFOLIO_CODE
Java Field: portfolioCode
Status: Active
SQL Type: int(11)
Java Type: Integer
Code of the portfolio assigned to the merchant.
Added On: 04/16/13
SQL Column: POSTAL_CODE
Java Field: postalCode
Status: Active
SQL Type: varchar(20)
Java Type: String
ZIP (or postal) code of the merchant's mailing address.
Added On: 04/16/13
SQL Column: PROVISION_PROFILE_NAME
Java Field: provisionProfileName
Status: Active
SQL Type: varchar(50)
Java Type: String
Name of the provisioning profile assigned to the sub-merchant.
Added On: 09/30/16
SQL Column: PROVISIONING_TRANSACTION_FK
Java Field: provisioningTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents information about provisioning transaction.
Added On: 04/16/13
SQL Column: PSP_MERCHANT_ID
Java Field: pspMerchantId
Status: Active
SQL Type: varchar(32)
Java Type: String
Merchant identifier assigned by a payment service provider.
Added On: 06/07/13
SQL Column: PURCHASE_CURRENCY
Java Field: purchaseCurrency
Status: Active
SQL Type: varchar(3)
Java Type: String
Currency allowed for purchasing transactions.
Added On: 06/20/14
SQL Column: REQUEST_CL
Java Field: requestCl
Status: Active
SQL Type: varchar(3)
Java Type: String
Represents the type of request.
Added On: 09/30/16
SQL Column: RESELLER_CODE
Java Field: resellerCode
Status: Active
SQL Type: int(11)
Java Type: Integer
Code of the reseller associated with the merchant.
Added On: 04/16/13
SQL Column: RETAIL_VANTIV_LOWELL_PROFILE_FK
Java Field: retailVantivLowellProfile
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents retail profile information of the merchant.
Added On: 09/30/16
SQL Column: ROUTING_NUMBER_MASKED
Java Field: routingNumberMasked
Status: Active
SQL Type: varchar(9)
Java Type: String
Masked routing number assigned to the transaction.
Added On: 09/02/14
SQL Column: SETTLEMENT_CURRENCY
Java Field: settlementCurrency
Status: Active
SQL Type: varchar(3)
Java Type: String
Code of the currency used to place settlement transaction.
Added On: 04/16/13
SQL Column: STATE_PROVINCE
Java Field: stateProvince
Status: Active
SQL Type: varchar(3)
Java Type: String
State (or province) code of the merchant's mailing address.
Added On: 04/16/13
SQL Column: STREET_ADDRESS1
Java Field: streetAddress1
Status: Active
SQL Type: varchar(60)
Java Type: String
Street (line 1) of the merchant's mailing address.
Added On: 04/16/13
SQL Column: STREET_ADDRESS2
Java Field: streetAddress2
Status: Active
SQL Type: varchar(60)
Java Type: String
Street (line two) of the merchant's mailing address.
Added On: 05/10/13
SQL Column: SUBMERCHANT_ID
Java Field: submerchantId
Status: Active
SQL Type: varchar(19)
Java Type: String
Identification code of the sub-merchant in the system.
Added On: 05/15/13
SQL Column: TRANSACTION_ID
Java Field: transactionId
Status: Active
SQL Type: varchar(19)
Java Type: String
Identification number of the initial transaction.
Added On: 04/16/13
SQL Column: URL
Java Field: url
Status: Active
SQL Type: varchar(120)
Java Type: String
URL used for merchant authorization.
Added On: 05/10/13
SQL Column: USERNAME
Java Field: username
Status: Active
SQL Type: varchar(20)
Java Type: String
User name used for processing of transactions.
Added On: 04/16/13
SQL Column: VANTIV_LOWELL_LEGAL_ENTITY_TRANSACTION_FK
Java Field: vantivLowellLegalEntityTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents legal transaction information.