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
Attributes:
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
Attributes:
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
Attributes:
Identification number of the AmEx seller account.
Added On:  09/12/14
SQL Column:  
Java Field:  bankAccountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Merchant bank account number.
Transient field.
Added On:  09/12/14
SQL Column:  
Java Field:  bankRoutingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  06/20/14
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Identifier / Primary Key
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
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:  04/16/13
SQL Column:  MERCHANT_CATEGORY_CODE
Java Field:  merchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
Merchant identifier string.
Added On:  04/16/13
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the merchant in the system.
Added On:  09/12/14
SQL Column:  
Java Field:  password
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Reference to the entity that represents legal transaction information.