Provisioning Transaction UML


Added On:  03/26/15 
SQL Table:  PROVISIONING_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ProvisioningTransaction 
Represents information about provisioning transaction.
Available Fields:
Added On:  03/26/15
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:  03/26/15
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:  03/26/15
SQL Column:  REQUEST_DATE
Java Field:  requestDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the request.
Added On:  03/26/15
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents current transaction status.
Added On:  03/26/15
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Gateway generated response code.
Added On:  03/26/15
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(421)
Java Type:  String
Attributes:
Gateway generated response message.
Added On:  03/26/15
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the transaction response.
Added On:  03/26/15
SQL Column:  OPERATION_CL
Java Field:  operationCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of current operation.
Added On:  03/26/15
SQL Column:  BILLING_PROFILE_TYPE
Java Field:  billingProfileType
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Type of the billing profile.
Added On:  03/26/15
SQL Column:  PROVIDER_MERCHANT_CODE
Java Field:  providerMerchantCode
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Merchant code assigned by the provider.
Added On:  03/26/15
SQL Column:  MERCHANT_CODE
Java Field:  merchantCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Codeof the merchant within the system.
Added On:  03/26/15
SQL Column:  MERCHANT_IS_ACTIVE
Java Field:  merchantIsActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Indicates whether the merchant is active in the system.
Added On:  03/26/15
SQL Column:  MERCHANT_CREATE_DATE
Java Field:  merchantCreateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the merchant was created.
Added On:  03/26/15
SQL Column:  MERCHANT_DEACTIVATE_DATE
Java Field:  merchantDeactivateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the merchant account was deactivated.
Added On:  03/26/15
SQL Column:  MERCHANT_TIME_ZONE
Java Field:  merchantTimeZone
Status:  Active
SQL Type:  varchar(33)
Java Type:  String
Attributes:
Time zone of the merchant.
Added On:  03/26/15
SQL Column:  MERCHANT_DEPOSIT_INFO_HOLDER_NAME
Java Field:  merchantDepositInfoHolderName
Status:  Active
SQL Type:  varchar(56)
Java Type:  String
Attributes:
Holder name of the deposit merchant account.
Added On:  03/26/15
SQL Column:  
Java Field:  merchantDepositInfoRoutingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Routing number of the deposit merchant account.
Added On:  03/26/15
SQL Column:  
Java Field:  merchantDepositInfoAccountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number of the deposit merchant account.
Added On:  03/26/15
SQL Column:  MERCHANT_PROCESSING_CONFIG_MERCHANT_CATEGORY_CODE
Java Field:  merchantProcessingConfigMerchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Merchant category code assigned to the processing configuration of the merchant.
Added On:  03/26/15
SQL Column:  MERCHANT_PROCESSING_CONFIG_CARD_DESCRIPTOR
Java Field:  merchantProcessingConfigCardDescriptor
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Dynamic description of the card processing configuration of the merchant.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_LEGAL_NAME
Java Field:  businessInfoLegalName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The legal name of the company.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_STREET1
Java Field:  businessInfoStreet1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street1 of the company's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_STREET2
Java Field:  businessInfoStreet2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street2 of the company's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_CITY
Java Field:  businessInfoCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the company's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_STATE
Java Field:  businessInfoState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State of the company's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_ZIP_CODE
Java Field:  businessInfoZipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP/postal code of the company's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_COUNTRY_CODE
Java Field:  businessInfoCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the company's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_WEB_SITE
Java Field:  businessInfoWebSite
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
URL of the corporate website of the company.
Added On:  03/26/15
SQL Column:  BUSINESS_INFO_ESTIMATED_AVG_TRANSACTION_AMOUNT
Java Field:  businessInfoEstimatedAvgTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The estimated average amount of transactions expected to be processed during the indicated estimation period.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_CONTACT_NAME
Java Field:  contactInfoContactName
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Contact name of the merchant.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_STREET1
Java Field:  contactInfoStreet1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 1) of the merchant's mailing address.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_STREET2
Java Field:  contactInfoStreet2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 2) of the merchant's mailing address.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_CITY
Java Field:  contactInfoCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the merchant's mailing address.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_STATE
Java Field:  contactInfoState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the merchant's mailing address.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_ZIP_CODE
Java Field:  contactInfoZipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP/postal code of the merchant's mailing address.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_COUNTRY_CODE
Java Field:  contactInfoCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the merchant's mailing address.
Added On:  03/26/15
SQL Column:  CONTACT_INFO_PHONE
Java Field:  contactInfoPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Contact phone number of the merchant for discussing any processing issues.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_FIRST_NAME
Java Field:  businessOwnerPrimaryFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
First name of the primary business owner.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_LAST_NAME
Java Field:  businessOwnerPrimaryLastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Last name of the primary business owner.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_BIRTH_DATE
Java Field:  businessOwnerPrimaryBirthDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Birth date of the primary business owner.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_STREET1
Java Field:  businessOwnerPrimaryStreet1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 1) of the primary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_STREET2
Java Field:  businessOwnerPrimaryStreet2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 2) of the primary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_CITY
Java Field:  businessOwnerPrimaryCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the primary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_STATE
Java Field:  businessOwnerPrimaryState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the primary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_ZIP_CODE
Java Field:  businessOwnerPrimaryZipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP/postal code of the primary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_COUNTRY_CODE
Java Field:  businessOwnerPrimaryCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the primary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_PHONE
Java Field:  businessOwnerPrimaryPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number of the primary business owner for discussing any processing issues.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_PRIMARY_EMAIL
Java Field:  businessOwnerPrimaryEmail
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email of the primary business owner.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_FIRST_NAME
Java Field:  businessOwnerSecondaryFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
First name of the secondary business owner.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_LAST_NAME
Java Field:  businessOwnerSecondaryLastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Last name of the secondary business owner.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_BIRTH_DATE
Java Field:  businessOwnerSecondaryBirthDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Birth date of the secondary business owner.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_STREET1
Java Field:  businessOwnerSecondaryStreet1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 1) of the secondary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_STREET2
Java Field:  businessOwnerSecondaryStreet2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 2) of the secondary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_CITY
Java Field:  businessOwnerSecondaryCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the secondary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_STATE
Java Field:  businessOwnerSecondaryState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the secondary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_ZIP_CODE
Java Field:  businessOwnerSecondaryZipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP/postal code of the secondary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_COUNTRY_CODE
Java Field:  businessOwnerSecondaryCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the secondary business owner's mailing address.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_PHONE
Java Field:  businessOwnerSecondaryPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number of the secondary business owner for discussing any processing issues.
Added On:  03/26/15
SQL Column:  BUSINESS_OWNER_SECONDARY_EMAIL
Java Field:  businessOwnerSecondaryEmail
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address of the secondary business owner.
Added On:  03/26/15
SQL Column:  PROCESSING_PROFILE_FK
Java Field:  processingProfile
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Processing Profile
Attributes:
Reference to the entity that represents Provider specific merchant account. Encapsulates all information necessary to identify a merchant in Provider's system. Billing Profile may also contain configuration values defining system's behavior for this specific configuration.
Added On:  04/06/15
SQL Column:  BUSINESS_INFO_ESTIMATED_TRANSACTION_VOLUME
Java Field:  businessInfoEstimatedTransactionVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The estimated volume of transactions expected to be processed during the indicated estimation period.
Added On:  11/02/15
SQL Column:  BUSINESS_INFO_EMAIL
Java Field:  businessInfoEmail
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address of a company.
Added On:  11/02/15
SQL Column:  BUSINESS_INFO_OWNERSHIP_STRUCTURE
Java Field:  businessInfoOwnershipStructure
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible ownership types of the company.
Added On:  11/02/15
SQL Column:  BUSINESS_INFO_CURRENCY_CODE
Java Field:  businessInfoCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The code of currency which the company processes transactions in.
Added On:  11/02/15
SQL Column:  BUSINESS_INFO_ESTIMATION_PERIOD
Java Field:  businessInfoEstimationPeriod
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible time periods for which transaction volume and average transaction amount are defined.
Added On:  11/02/15
SQL Column:  BUSINESS_INFO_ESTIMATED_MAX_TRANSACTION_AMOUNT
Java Field:  businessInfoEstimatedMaxTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Maximum estimated amount of transaction.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_ENTRY_MODE_RETAIL
Java Field:  businessEstimatesEntryModeRetail
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode estimates of the merchant's retail business.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_ENTRY_MODE_ECOMMERCE
Java Field:  businessEstimatesEntryModeEcommerce
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode estimates of the merchant's ecommerce business.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_ENTRY_MODE_MAIL
Java Field:  businessEstimatesEntryModeMail
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode estimates of the merchant's business email address.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_ENTRY_MODE_PHONE
Java Field:  businessEstimatesEntryModePhone
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode estimates of the merchant's business phone number.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_ENTRY_MODE_TRADESHOW
Java Field:  businessEstimatesEntryModeTradeshow
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Entry mode estimates of the merchant's tradeshow business.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_CARD_TYPE_VISA
Java Field:  businessEstimatesCardTypeVisa
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Card type estimates assigned to Visa.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_CARD_TYPE_MASTERCARD
Java Field:  businessEstimatesCardTypeMastercard
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Card type estimates assigned to MasterCard.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_CARD_TYPE_AMEX
Java Field:  businessEstimatesCardTypeAmex
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Card type estimates assigned to AmEx.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_CARD_TYPE_DISCOVER
Java Field:  businessEstimatesCardTypeDiscover
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Card type estimates assigned to Discover.
Added On:  11/02/15
SQL Column:  BUSINESS_ESTIMATES_CARD_TYPE_OTHER
Java Field:  businessEstimatesCardTypeOther
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Card type estimates assigned to any card brand (excluding Visa, MasterCard, AmEx and Discover).
Added On:  11/04/15
SQL Column:  MERCHANT_PROCESSING_CONFIG_VISA_MID
Java Field:  merchantProcessingConfigVisaMid
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
Merchant identifier assigned to Visa processing configurations of the merchant.
Added On:  11/04/15
SQL Column:  MERCHANT_PROCESSING_CONFIG_MASTER_CARD_MID
Java Field:  merchantProcessingConfigMasterCardMid
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
Merchant identifier assigned to MasterCard processing configurations of the merchant.
Added On:  11/04/15
SQL Column:  MERCHANT_PROCESSING_CONFIG_AMEX_MID
Java Field:  merchantProcessingConfigAmexMid
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
Merchant identifier assigned to AmEx processing configurations of the merchant.
Added On:  11/04/15
SQL Column:  MERCHANT_PROCESSING_CONFIG_DISCOVER_MID
Java Field:  merchantProcessingConfigDiscoverMid
Status:  Active
SQL Type:  varchar(21)
Java Type:  String
Attributes:
Merchant identifier assigned to the merchant's Discover configurations.
Added On:  11/06/15
SQL Column:  MERCHANT_CHARGE_INFO_HOLDER_NAME
Java Field:  merchantChargeInfoHolderName
Status:  Active
SQL Type:  varchar(56)
Java Type:  String
Attributes:
Name of the credit card holder.
Added On:  11/06/15
SQL Column:  MERCHANT_CHARGE_INFO_ACCOUNT_NUMBER_MASKED
Java Field:  merchantChargeInfoAccountNumberMasked
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Masked account number of the merchant.
Added On:  11/06/15
SQL Column:  MERCHANT_CHARGE_INFO_ROUTING_NUMBER_MASKED
Java Field:  merchantChargeInfoRoutingNumberMasked
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Masked routing number of the merchant.
Added On:  11/11/15
SQL Column:  MERCHANT_PROCESSING_CONFIG_CUSTOMER_SERVICE_PHONE
Java Field:  merchantProcessingConfigCustomerServicePhone
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Phone of the support team used for discussing merchant's configuration issues.
Added On:  12/04/15
SQL Column:  BUSINESS_INFO_BUSINESS_NAME
Java Field:  businessInfoBusinessName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the merchant used in business information.
Added On:  02/05/16
SQL Column:  MERCHANT_DEPOSIT_INFO_BANK_NAME
Java Field:  merchantDepositInfoBankName
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Name of the bank assigned to the merchant's deposit information.
Added On:  02/05/16
SQL Column:  CONTACT_INFO_EMAIL
Java Field:  contactInfoEmail
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Contact email of the merchant.
Added On:  03/28/16
SQL Column:  SUB_BATCH_FK
Java Field:  subBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Sub Batch
Attributes:
Reference to the entity taht represents provisioning transaction information.
Added On:  04/02/16
SQL Column:  MERCHANT_CHARGE_INFO_BANK_NAME
Java Field:  merchantChargeInfoBankName
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Name of the bank that is assigned to the merchant charge information.
Added On:  05/27/16
SQL Column:  ONBOARDING_APPLICATION_CODE
Java Field:  onboardingApplicationCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the used onboarding application.
Added On:  05/31/16
SQL Column:  BUSINESS_INFO_CUSTOMER_SERVICE_PHONE
Java Field:  businessInfoCustomerServicePhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Service phone of the customer used for discussing any processing issues.
Added On:  06/02/16
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Codeof the reseller for this transaction.
Added On:  06/03/16
SQL Column:  FEE_SCHEMA
Java Field:  feeSchema
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Fee schema used for this provisioning transaction.
Added On:  06/17/16
SQL Column:  PROCESSOR_IDENTITY1
Java Field:  processorIdentity1
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Field used for identifier of the processor.
Added On:  06/17/16
SQL Column:  PROCESSOR_IDENTITY2
Java Field:  processorIdentity2
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Field used for identifier of the processor.
Added On:  06/17/16
SQL Column:  PROCESSOR_IDENTITY3
Java Field:  processorIdentity3
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Field used for identifier of the processor.
Added On:  06/17/16
SQL Column:  MERCHANT_DEPOSIT_INFO_ACCOUNT_NUMBER_MASKED
Java Field:  merchantDepositInfoAccountNumberMasked
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Account number associated with merchant deposit information, masked for security purposes.
Added On:  06/17/16
SQL Column:  MERCHANT_DEPOSIT_INFO_ROUTING_NUMBER_MASKED
Java Field:  merchantDepositInfoRoutingNumberMasked
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Routing number associated with merchant deposit information, masked for security purposes.
Added On:  06/17/16
SQL Column:  BUSINESS_INFO_FEDERAL_TAX_ID
Java Field:  businessInfoFederalTaxId
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Federal tax identifier of the company.
Added On:  06/17/16
SQL Column:  
Java Field:  businessOwnerPrimarySocialSecurity
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Social security number of the primary business owner.
Added On:  06/17/16
SQL Column:  
Java Field:  businessOwnerSecondarySocialSecurity
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Social security number of the secondary business owner.
Added On:  06/17/16
SQL Column:  BUSINESS_INFO_OWNERSHIP_STRUCTURE
Java Field:  businessInfoOwnershipStructure
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the ownership structure associated with business owner.
Added On:  06/17/16
SQL Column:  BUSINESS_INFO_ESTIMATION_PERIOD
Java Field:  businessInfoEstimationPeriod
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Estimation period of the merchant included in business information.
Added On:  06/17/16
SQL Column:  
Java Field:  merchantChargeInfoAccountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number associated with merchant charge information.
Added On:  06/17/16
SQL Column:  
Java Field:  merchantChargeInfoRoutingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Routing number associated with merchant charge nformation.
Added On:  06/17/16
SQL Column:  
Java Field:  processorTransactionCode
Status:  Active
SQL Type:  
Java Type:  Long
Attributes: Transient
Code of the transaction within the processor's system.
Added On:  06/17/16
SQL Column:  
Java Field:  isNextTransactionRequired
Status:  Active
SQL Type:  
Java Type:  Boolean
Attributes: Transient, Default:false
Indicates whether repeated transaction processing is enabled.
Added On:  06/17/16
SQL Column:  VANTIV_TANDEM_PROVISIONING_TRANSACTION_FK
Java Field:  vantivTandemProvisioningTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents settings applied to Vantiv Tandem Provisioning transaction.
Added On:  07/05/16
SQL Column:  PROVISIONING_TRANSACTION_RESPONSE_DETAIL_FK
Java Field:  provisioningTransactionResponseDetails
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents provisioning transaction response details.
Added On:  09/30/16
SQL Column:  
Java Field:  businessOwnerDriverLicense
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Number of the driver license of the business owner.
Added On:  09/30/16
SQL Column:  BUSINESS_OWNER_DRIVER_LICENSE_MASKED
Java Field:  businessOwnerDriverLicenseMasked
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Number of driver license of the business owner, masked for security purposes.
Added On:  09/30/16
SQL Column:  BUSINESS_OWNER_DRIVER_LICENSE_STATE
Java Field:  businessOwnerDriverLicenseState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the state where driver license of the business owner was issued.
Added On:  09/30/16
SQL Column:  BUSINESS_OWNER_DRIVER_LICENSE_COUNTRY_CODE
Java Field:  businessOwnerDriverLicenseCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the country where driver license of the business owner was issued.
Added On:  09/30/16
SQL Column:  MERCHANT_PROCESSING_CONFIG_ECHECK_DESCRIPTOR
Java Field:  merchantProcessingConfigEcheckDescriptor
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Dynamic descriptor of eCheck transactions assigned to the merchant while a provider profile setup.
Added On:  09/30/16
SQL Column:  MERCHANT_PROCESSING_CONFIG_ECHECK_MERCHANT_NAME
Java Field:  merchantProcessingConfigEcheckMerchantName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Merchant name, that is associated with the eCheck, included in processing configurations of the merchant.
Added On:  09/30/16
SQL Column:  MERCHANT_PROCESSING_CONFIG_IS_AMEX_OPT_BLUE_ACQUIRED
Java Field:  merchantProcessingConfigIsAmexOptBlueAcquired
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Indicates in processing configurations of the merchant whether Amex Opt Blue mechanism is aquired.
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 eCheck processing is enabled.
Added On:  10/10/16
SQL Column:  REQUEST_TYPE
Java Field:  requestType
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Type of the request associated with the transaction.
Added On:  11/23/16
SQL Column:  MERCHANT_NOTES
Java Field:  merchantNotes
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Additional information associated with the merchant.
Added On:  11/23/16
SQL Column:  MERCHANT_DEPOSIT_INFO_ACCOUNT_TYPE
Java Field:  merchantDepositInfoAccountType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Account type used for deposit operations associated with the merchant.
Added On:  12/06/16
SQL Column:  BUSINESS_INFO_WORK_HOURS
Java Field:  businessInfoWorkHours
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Working hours of the business entity.
Added On:  12/06/16
SQL Column:  BUSINESS_INFO_REGISTRATION_YEAR
Java Field:  businessInfoRegistrationYear
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Year of registration of the business entity.
Added On:  12/06/16
SQL Column:  BUSINESS_INFO_REGISTRATION_STATE
Java Field:  businessInfoRegistrationState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the state where the business entity was registered.
Added On:  12/06/16
SQL Column:  BUSINESS_INFO_REGISTRATION_COUNTRY_CODE
Java Field:  businessInfoRegistrationCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the country where the business entity was registered.
Added On:  12/13/16
SQL Column:  FEE_PREFIX
Java Field:  feePrefix
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Prefix used for identification of the fee schema associated with the record.
Added On:  01/19/17
SQL Column:  PROCESSOR_APPLICATION_ID
Java Field:  processorApplicationId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Application ID assigned by a processor.
Added On:  01/20/17
SQL Column:  FEE_TEMPLATE_CODE_ENCRYPTED
Java Field:  feeTemplateCodeEncrypted
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Encrypted code of the fee template associated with the merchant.
Added On:  01/27/17
SQL Column:  DISTRIBUTION_SCHEMA_CODE
Java Field:  distributionSchemaCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Code of the distribution schema associated with the merchant.
Added On:  02/07/17
SQL Column:  NOTIFICATION_POLICY
Java Field:  notificationPolicy
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Policy of how notifications about onboarding process results are delivered to the merchant.
Added On:  03/11/17
SQL Column:  PARENT_MERCHANT_CODE
Java Field:  parentMerchantCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the parent merchant that the account is being created for.
Added On:  04/11/17
SQL Column:  MERCHANT_MERCHANT_PROFILE
Java Field:  merchantMerchantProfile
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Profile associated with the merchant that is being onboarded.
Added On:  04/11/17
SQL Column:  BUSINESS_INFO_RELATIONSHIP_BEGIN_DATE
Java Field:  businessInfoRelationshipBeginDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when business relationship between the processor and a merchant was registered.
Added On:  06/12/17
SQL Column:  ACCOUNT_STORE_FK
Java Field:  accountStore
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Account Store
Attributes:
Storage for the account numbers represented as tokens.
Added On:  06/26/17
SQL Column:  CLIENT_HOST
Java Field:  clientHost
Status:  Active
SQL Type:  varchar(63)
Java Type:  String
Attributes:
IP address associated with API call sent by the merchant.
Added On:  06/12/17
SQL Column:  ACCOUNT_STORE_FK
Java Field:  accountStore
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Account Store
Attributes:
Added On:  07/17/17
SQL Column:  MERCHANT_TYPE
Java Field:  merchantType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Type of the merchant (Affiliate, Merchant, etc.).
Added On:  03/28/16
SQL Column:  SUB_BATCH_FK
Java Field:  subBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Sub Batch
Attributes:
Reference to the entity taht represents provisioning transaction information.
Added On:  12/12/17
SQL Column:  PROCESSOR_IDENTITY4
Java Field:  processorIdentity4
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  05/10/18
SQL Column:  BUSINESS_OWNER_PRIMARY_STAKE_PERCENTAGE
Java Field:  businessOwnerPrimaryStakePercentage
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  05/16/18
SQL Column:  NEXT_ACTION
Java Field:  nextAction
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PROCESSOR_IDENTITY3_BAK
Java Field:  processorIdentity3Bak
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  ORIGINAL_PROVISIONING_TRANSACTION
Java Field:  originalProvisioningTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/30/18
SQL Column:  PROCESSOR_IDENTITY0
Java Field:  processorIdentity0
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  PROCESSOR_IDENTITY1_BAK
Java Field:  processorIdentity1Bak
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  PROCESSOR_IDENTITY2_BAK
Java Field:  processorIdentity2Bak
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  09/04/18
SQL Column:  PROVIDER_PROVISIONING_TRANSACTION
Java Field:  providerProvisioningTransaction
Status:  Active
SQL Type:  longtext
Java Type:  Object
Attributes: Transient
Added On:  10/24/18
SQL Column:  PROVIDER_RESPONSE_CODE
Java Field:  providerResponseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  10/24/18
SQL Column:  PROVIDER_RESPONSE_MESSAGE
Java Field:  providerResponseMessage
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Added On:  10/24/18
SQL Column:  PROVIDER_REFERENCE_NUMBER
Java Field:  providerReferenceNumber
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  12/10/18
SQL Column:  ONBOARDING_APPLICATION_STAGE_FK
Java Field:  onboardingApplicationStage
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  12/13/18
SQL Column:  BUSINESS_OWNER_PRIMARY_TITLE
Java Field:  businessOwnerPrimaryTitle
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  02/22/19
SQL Column:  BUSINESS_INFO_DESCRIPTOR_PHONE
Java Field:  businessInfoDescriptorPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  01/19/17
SQL Column:  PROCESSOR_APPLICATION_ID
Java Field:  processorApplicationId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Application ID assigned by a processor.
Added On:  07/22/19
SQL Column:  ESTIMATES_ANNUAL_DIRECT_DEBIT_VOLUME
Java Field:  estimatesAnnualDirectDebitVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  07/22/19
SQL Column:  ESTIMATES_ANNUAL_CARDS_VOLUME
Java Field:  estimatesAnnualCardsVolume
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  07/22/19
SQL Column:  ESTIMATES_AVG_DIRECT_DEBIT_TRANSACTION_AMOUNT
Java Field:  estimatesAvgDirectDebitTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  07/22/19
SQL Column:  ESTIMATES_AVG_CARDS_TRANSACTION_AMOUNT
Java Field:  estimatesAvgCardsTransactionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/26/15
SQL Column:  OPERATION_CL
Java Field:  operationCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of current operation.
Added On:  03/26/15
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents current transaction status.
Added On:  03/26/15
SQL Column:  PROCESSING_PROFILE_FK
Java Field:  processingProfile
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents Provider specific merchant account. Encapsulates all information necessary to identify a merchant in Provider's system. Billing Profile may also contain configuration values defining system's behavior for this specific configuration.