Merchant Account Profile UML


Added On:  02/13/12 
SQL Table:  MERCHANT_ACCOUNT_PROFILE 
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.
Available Fields:
Added On:  09/16/15
SQL Column:  ACCOUNT_UPDATER_AMEX_PROFILE_FK
Java Field:  accountUpdaterAmexProfile
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Default:2400
Added On:  09/16/15
SQL Column:  AMEX_ACCOUNT_UPDATER_PROFILE_TYPE
Java Field:  amexAccountUpdaterProfileType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
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
References Chargeback Profile
Attributes:
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
Attributes:
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
Attributes:
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
References Amex Profile
Attributes:
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
Attributes:
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
References Retail Profile
Attributes:
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
Attributes:
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
Attributes:
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
References Cards Cost Profile
Attributes:
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
Attributes:
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
References CC Profile
Attributes:
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
Attributes:
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
References Chargeback Profile
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
References Retail Profile
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
References EFT Profile
Attributes:
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
Attributes:
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
References EFT Profile
Attributes:
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
Attributes:
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
References Email Profile
Attributes:
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
Attributes:
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
References Retail Profile
Attributes:
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
Attributes:
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
References Fraud Profile
Attributes:
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
Attributes:
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
References Fulfillment Profile
Attributes:
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
Attributes:
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
References Retail Profile
Attributes:
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
Attributes:
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
Identifier / Primary Key
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
Attributes:
The list of IPs allowed.
Added On:  02/13/12
SQL Column:  IP_FILTERING_POLICY_CL
Java Field:  ipFilteringPolicyCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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
Attributes: Default:true
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
References Key Registry
Attributes:
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
References Letter Profile
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
References Phone Call Profile
Attributes:
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
Attributes:
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
References Post Rule
Attributes:
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
Attributes:
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
References Pre Rule
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Default:2400
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
References Retail Profile
Attributes:
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
Attributes:
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
References Return Profile
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
References Terminal
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Default:NNN
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.