Merchant Account Profile                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  02/13/12 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  MerchantAccountProfile 
                    
        
        
     
    
        
            
                
                    Represents a set of configuration settings that can be defined either on Merchant or Merchant Account level.
                
             
         
     
        
        
                    
                        
                Added On:  09/16/15
                SQL Column:  ACCOUNT_UPDATER_AMEX_PROFILE_FK
                Java Field:  accountUpdaterAmexProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents Amex account updater profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_UPDATER_PROFILE_FK
                Java Field:  accountUpdaterProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents various settlement options for account updater.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  ACCOUNT_UPDATER_PROFILE_TYPE
                Java Field:  accountUpdaterProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used account updater profile.
                        
                     
                 
             
                    
                        
                Added On:  11/23/18
                SQL Column:  ACH_REALTIME_PERIOD
                Java Field:  achRealtimePeriod
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  09/16/15
                SQL Column:  AMEX_ACCOUNT_UPDATER_PROFILE_TYPE
                Java Field:  amexAccountUpdaterProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of account updater profile for Amex.
                        
                     
                 
             
                    
                        
                Added On:  07/15/13
                SQL Column:  AMEX_CHARGEBACK_PROFILE_FK
                Java Field:  amexChargebackProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents configuration settings for chargeback processing through AmEx.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  AMEX_CHARGEBACK_PROFILE_TYPE
                Java Field:  amexChargebackProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used American Express chargeback profile.
                        
                     
                 
             
                    
                        
                Added On:  10/10/14
                SQL Column:  AMEX_MID
                Java Field:  amexMid
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field contains the external American Express merchant ID number. 
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  AMEX_PROFILE_FK
                Java Field:  amexProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents configuration settings for processing of batch transactions through AmEx.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  AMEX_PROFILE_TYPE
                Java Field:  amexProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used Amex profile.
                        
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  AMEX_REALTIME_PROFILE_FK
                Java Field:  amexRealtimeProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that adds real-time specific processing settings to 
Billing Profile.                        
 
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  AMEX_REALTIME_PROFILE_TYPE
                Java Field:  amexRealtimeProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used Amex realtime profile.
                        
                     
                 
             
                    
                        
                Added On:  10/10/14
                SQL Column:  CARD_DESCRIPTOR
                Java Field:  cardDescriptor
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The desired description for transactions when they appear on the banking statement of a customer.
                        
                     
                 
             
                    
                        
                Added On:  01/21/13
                SQL Column:  CARDS_COST_PROFILE_FK
                Java Field:  cardsCostProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents cards cost profile.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  CARDS_COST_PROFILE_TYPE
                Java Field:  cardsCostProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used cards cost profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CC_PROFILE_FK
                Java Field:  ccProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents CC profile.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  CC_PROFILE_TYPE
                Java Field:  ccProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used CC profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CHARGEBACK_PROFILE_FK
                Java Field:  chargebackProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents chargeback profile.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  CHARGEBACK_PROFILE_TYPE
                Java Field:  chargebackProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used chargeback profile.
                        
                     
                 
             
                    
                        
                Added On:  06/09/17
                SQL Column:  CLIENT_ABORT_ACTION_CL
                Java Field:  clientAbortActionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Reference to the entity that represents possible ways to handle void for unprocessed transactions.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CREDIT_AGENCY_PROFILE_FK
                Java Field:  creditAgencyProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time specific processing settings to credit agency profile. 
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  CREDIT_AGENCY_PROFILE_TYPE
                Java Field:  creditAgencyProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used credit agency profile.
                        
                     
                 
             
                    
                        
                Added On:  10/10/14
                SQL Column:  CUSTOMER_SERVICE_PHONE
                Java Field:  customerServicePhone
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Phone number of the customer service.
                        
                     
                 
             
                    
                        
                Added On:  02/01/13
                SQL Column:  DEBIT_REALTIME_PROFILE_FK
                Java Field:  debitRealtimeProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time profile of tha processor.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  DEBIT_REALTIME_PROFILE_TYPE
                Java Field:  debitRealtimeProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used debit realtime profile.
                        
                     
                 
             
                    
                        
                Added On:  07/10/14
                SQL Column:  DEFAULT_POST_RULE_ACTION_CL
                Java Field:  defaultPostRuleActionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of post-rule actions selected for this merchant account profile.
                        
                     
                 
             
                    
                        
                Added On:  02/06/15
                SQL Column:  DEFAULT_PRE_RULE_ACTION_CL
                Java Field:  defaultPreRuleActionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of pre-rule actions selected for this merchant account profile.
                        
                     
                 
             
                    
                        
                Added On:  10/10/14
                SQL Column:  DISCOVER_MID
                Java Field:  discoverMid
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field contains the external Discover merchant ID number. 
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  DUPLICATE_POLICY_CL
                Java Field:  duplicatePolicyCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of selected duplicate policy.
                        
                     
                 
             
                    
                        
                Added On:  10/10/14
                SQL Column:  ECHECK_DESCRIPTOR
                Java Field:  echeckDescriptor
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The desired description for eCheck transactions when they appear on the banking statement of a customer.
This field specifies the billing descriptor used for eCheck transactions. You should specify this element when the subMerchant is enabled for eCheck transaction.
                        
                     
                 
             
                    
                        
                Added On:  10/10/14
                SQL Column:  ECHECK_MERCHANT_NAME
                Java Field:  echeckMerchantName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The merchant's name for eCheck transactions when they appear on the banking statement of a customer.
This field specifies the merchant name used for eCheck transactions. You should specify this element when the subMerchant is enabled for eCheck transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  EFT_PROFILE_FK
                Java Field:  eftProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents EFT profile.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  EFT_PROFILE_TYPE
                Java Field:  eftProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used EFT profile.
                        
                     
                 
             
                    
                        
                Added On:  01/23/14
                SQL Column:  EFT_REALTIME_PROFILE_FK
                Java Field:  eftRealtimeProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents configuration settings for processing of realtime transactions through EFT.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  EFT_REALTIME_PROFILE_TYPE
                Java Field:  eftRealtimeProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used EFT realtime profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  EMAIL_PROFILE_FK
                Java Field:  emailProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time specific processing settings to email profile. 
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  EMAIL_PROFILE_TYPE
                Java Field:  emailProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used email profile.
                        
                     
                 
             
                    
                        
                Added On:  11/26/14
                SQL Column:  EMV_REALTIME_PROFILE_FK
                Java Field:  emvRealtimeProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that adds real-time specific processing settings to 
Billing Profile.                        
 
                     
                 
             
                    
                        
                Added On:  11/26/14
                SQL Column:  EMV_REALTIME_PROFILE_TYPE
                Java Field:  emvRealtimeProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used realtime EMV profile.
                        
                     
                 
             
                    
                        
                Added On:  10/09/14
                SQL Column:  FRAUD_PROFILE_FK
                Java Field:  fraudProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents various settlement options for fraud profile.
                        
                     
                 
             
                    
                        
                Added On:  10/09/14
                SQL Column:  FRAUD_PROFILE_TYPE
                Java Field:  fraudProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used fraud profile.
                        
                     
                 
             
                    
                        
                Added On:  09/25/15
                SQL Column:  FULFILLMENT_PROFILE_FK
                Java Field:  fulfillmentProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents fulfillment center's profile.
                        
                     
                 
             
                    
                        
                Added On:  09/25/15
                SQL Column:  FULFILLMENT_PROFILE_TYPE
                Java Field:  fulfillmentProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of fulfillment center's profile.
                        
                     
                 
             
                    
                        
                Added On:  07/29/14
                SQL Column:  GIFT_REALTIME_PROFILE_FK
                Java Field:  giftRealtimeProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that adds real-time specific processing settings to 
Billing Profile.                        
 
                     
                 
             
                    
                        
                Added On:  07/29/14
                SQL Column:  GIFT_REALTIME_PROFILE_TYPE
                Java Field:  giftRealtimeProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used gift cards realtime profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IP_FILTER_LIST
                Java Field:  ipFilterList
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  IP_FILTERING_POLICY_CL
                Java Field:  ipFilteringPolicyCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of selected IP filter for the merchant.
                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  IS_AMEX_OPT_BLUE_ACQUIRED
                Java Field:  isAmexOptBlueAcquired
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether OptBlue service for processing Amex transactions is enabled.
                        
                     
                 
             
                    
                        
                Added On:  12/11/13
                SQL Column:  IS_DAILY_SUMMARY_NOTIFICATION_ENABLED
                Java Field:  isDailySummaryNotificationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the daily summary notification is enabled for the merchant.
                        
                     
                 
             
                    
                        
                Added On:  12/09/13
                SQL Column:  IS_FILE_NOTIFICATION_ENABLED
                Java Field:  isFileNotificationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the file notification is enabled for the merchant.
                        
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  IS_REALTIME_FIXED_TIME
                Java Field:  isRealtimeFixedTime
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                
                    
                        
                        Indicates whether the time of realtime transaction is fixed in the system.
                        
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  IS_REALTIME_MANUAL_CLIENT_CAPTURE
                Java Field:  isRealtimeManualClientCapture
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether a manual capture of realtime transactions is enabled.
                        
                     
                 
             
                    
                        
                Added On:  12/11/13
                SQL Column:  IS_SETTLEMENT_NOTIFICATION_ENABLED
                Java Field:  isSettlementNotificationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the settlement notification is enabled for the merchant.
                        
                     
                 
             
                    
                        
                Added On:  07/01/14
                SQL Column:  KEY_REGISTRY_FK
                Java Field:  keyRegistry
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time specific key registry settings.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  LETTER_PROFILE_FK
                Java Field:  letterProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time specific processing settings to letter profile. 
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  LETTER_PROFILE_TYPE
                Java Field:  letterProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used letter profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MAX_CLIENT_TRANSACTION_COUNT_PER_DAY
                Java Field:  maxClientTransactionCountPerDay
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The maximum number of transactions allowable for a customer per day.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MAX_CLIENT_TRANSACTION_COUNT_PER_HOUR
                Java Field:  maxClientTransactionCountPerHour
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The maximum number of transactions allowable for a customer per hour.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MAX_MERCHANT_TRANSACTION_COUNT_PER_DAY
                Java Field:  maxMerchantTransactionCountPerDay
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The maximum number of transactions allowable for a merchant per day.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MAX_MERCHANT_TRANSACTION_COUNT_PER_HOUR
                Java Field:  maxMerchantTransactionCountPerHour
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The maximum number of transactions allowable for a merchant per hour.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MAX_RISK_SCORE
                Java Field:  maxRiskScore
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Maximum risk score of the merchant account.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MAX_TRANSACTION_AMOUNT
                Java Field:  maxTransactionAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The maximum amount for a transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
                
                    Attributes:
                    Unique, 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:  10/10/14
                SQL Column:  MERCHANT_CATEGORY_CODE
                Java Field:  merchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant category code assigned by the signing member or processor to identify a merchant industry classification. This value is similar to the Standard Industry Code (SIC).
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MIN_TRANSACTION_AMOUNT
                Java Field:  minTransactionAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The minimum amount for a transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  NAME
                Java Field:  name
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The name associated with this merchant account.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PHONE_CALL_PROFILE_FK
                Java Field:  phoneCallProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time specific processing settings to phone call. 
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  PHONE_CALL_PROFILE_TYPE
                Java Field:  phoneCallProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used phone call profile.
                        
                     
                 
             
                    
                        
                Added On:  06/21/16
                SQL Column:  POST_RULES
                Java Field:  postRules
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represent post rule information.
                        
                     
                 
             
                    
                        
                Added On:  02/06/15
                SQL Column:  POST_RULE_USER_MESSAGE
                Java Field:  postRuleUserMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Post-rule user message content.
                        
                     
                 
             
                    
                        
                Added On:  06/21/16
                SQL Column:  PRE_RULES
                Java Field:  preRules
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents pre-rules information.
                        
                     
                 
             
                    
                        
                Added On:  02/06/15
                SQL Column:  PRE_RULE_USER_MESSAGE
                Java Field:  preRuleUserMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Pre-rule user message content.
                        
                     
                 
             
                    
                        
                Added On:  06/17/16
                SQL Column:  PROCESSING_POLICY_CL
                Java Field:  processingPolicyCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of selected processing policy.
                        
                     
                 
             
                    
                        
                Added On:  02/04/13
                SQL Column:  REALTIME_PERIOD
                Java Field:  realtimePeriod
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Period for realtime transactions processing.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  RETAIL_PROFILE_FK
                Java Field:  retailProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that adds real-time specific processing settings to 
Billing Profile.                        
 
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  RETAIL_PROFILE_TYPE
                Java Field:  retailProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used retail profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  RETURN_PROFILE_FK
                Java Field:  returnProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents various settlement options for return profile.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  RETURN_PROFILE_TYPE
                Java Field:  returnProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used return profile.
                        
                     
                 
             
                    
                        
                Added On:  04/06/16
                SQL Column:  SETTLEMENT_MODE_CL
                Java Field:  settlementModeCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of selected settlement mode.
                        
                     
                 
             
                    
                        
                Added On:  07/29/12
                SQL Column:  SKIP_TRACING_PROFILE_FK
                Java Field:  skipTracingProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents skip tracing profile.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  SKIP_TRACING_PROFILE_TYPE
                Java Field:  skipTracingProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used skip tracing profile.
                        
                     
                 
             
                    
                        
                Added On:  06/21/16
                SQL Column:  TERMINALS
                Java Field:  terminals
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents information about terminal device.
                        
                     
                 
             
                    
                        
                Added On:  07/31/15
                SQL Column:  THREE_D_SECURE_PROFILE_FK
                Java Field:  threeDSecureProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents 3-D secure profile.
                        
                     
                 
             
                    
                        
                Added On:  08/03/15
                SQL Column:  THREE_D_SECURE_PROFILE_TYPE
                Java Field:  threeDSecureProfileType
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of 3-D secure profile.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TOKEN_REGISTER_PROFILE_FK
                Java Field:  tokenRegisterProfile
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents base type for all provider profiles defining tokenization functionality.
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  TOKEN_REGISTER_PROFILE_TYPE
                Java Field:  tokenRegisterProfileType
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of used token register profile.
                        
                     
                 
             
                    
                        
                Added On:  06/08/17
                SQL Column:  TRANSACTION_DUPLICATE_POLICY
                Java Field:  transactionDuplicatePolicy
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Defines how duplicate transactions are handled for realtime, batch and CAU transactions. The values can be the following: N – No duplicates check, D – Decline if duplicate, O – Return original transaction.