Merchant Account Group UML


Added On:  03/16/12 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantAccountGroup 
Encapsulates deposit information and stores all of the fields necessary for the remittance process to run. Depending on the configuration level of the merchant, each merchant or merchant account will have corresponding Merchant Account Group object for storing its information.
Available Fields:
Added On:  09/30/14
SQL Column:  ACCOUNT_STORE_CODE
Java Field:  accountStoreCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the store account.
Added On:  09/30/14
SQL Column:  ACCOUNT_STORE_CODE_CHARGE
Java Field:  accountStoreCodeCharge
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the charge for account store.
Added On:  02/05/15
SQL Column:  ACCOUNT_USAGE_CL_CHARGE
Java Field:  accountUsageClCharge
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents type of account usage selected for the merchant account group.
Added On:  08/22/17
SQL Column:  ACH_REMITTANCE_PERIOD
Java Field:  achRemittancePeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:1
Added On:  08/22/17
SQL Column:  AMEX_REMITTANCE_PERIOD
Java Field:  amexRemittancePeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:3
Added On:  08/23/17
SQL Column:  ANNUAL_FEE_POLICY
Java Field:  annualFeePolicy
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Defines a list of the months that should be available for annual fee setting for merchants under a particular portfolio.
Added On:  03/16/12
SQL Column:  BALANCE
Java Field:  balance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Shows the current balance of a merchant/merchant account. If the value is positive, 3rd party processor owes money to the merchant. If the value is negative, merchant owes money to a 3rd party processor.
Added On:  03/16/12
SQL Column:  BANK_ACCOUNT_HOLDER_NAME
Java Field:  bankAccountHolderName
Status:  Active
SQL Type:  varchar(56)
Java Type:  String
Attributes:
Full name of the account holder, where remittance deposits are directed.
Added On:  10/02/13
SQL Column:  BANK_ACCOUNT_HOLDER_NAME_CHARGE
Java Field:  bankAccountHolderNameCharge
Status:  Active
SQL Type:  varchar(56)
Java Type:  String
Attributes:
Full name of the holder of the account from which merchant fees are deducted.
Added On:  03/16/12
SQL Column:  BANK_ACCOUNT_NUMBER_MASKED
Java Field:  bankAccountNumberMasked
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Masked account number (last four digits) of the bank account associated with the merchant account group.
Added On:  10/02/13
SQL Column:  BANK_ACCOUNT_NUMBER_MASKED_CHARGE
Java Field:  bankAccountNumberMaskedCharge
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Masked account number (last four digits) of the bank account associated with the merchant account group.
Added On:  07/31/15
SQL Column:  BANK_ACCOUNT_TYPE_CL
Java Field:  bankAccountTypeCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the selected (or current) type of bank account.
Added On:  11/05/19
SQL Column:  BANK_CARD_BALANCE
Java Field:  bankCardBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  BANK_CARD_FEE_BALANCE
Java Field:  bankCardFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  BANK_CARD_FUTURE_FEE_BALANCE
Java Field:  bankCardFutureFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  BANK_CARD_FUTURE_RESERVE_BALANCE
Java Field:  bankCardFutureReserveBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  BANK_CARD_NET_BALANCE
Java Field:  bankCardNetBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  BANK_CARD_REATTEMPT_RETURNS_BALANCE
Java Field:  bankCardReattemptReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  BANK_CARD_RETURNS_BALANCE
Java Field:  bankCardReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  04/01/13
SQL Column:  BANK_NAME
Java Field:  bankName
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Name of the bank which holds the account where remittance deposits are directed.
Added On:  10/02/13
SQL Column:  BANK_NAME_CHARGE
Java Field:  bankNameCharge
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Name of the bank which holds the account from which merchant fees are deducted.
Added On:  04/01/13
SQL Column:  BANK_PHONE
Java Field:  bankPhone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Phone of the bank which holds the account where remittance deposits are directed.
Added On:  10/02/13
SQL Column:  BANK_PHONE_CHARGE
Java Field:  bankPhoneCharge
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Phone of the bank which holds the account from which merchant fees are deducted.
Added On:  03/16/12
SQL Column:  BANK_ROUTING_NUMBER_MASKED
Java Field:  bankRoutingNumberMasked
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Masked routing number (last four digits) of the bank account associated with the merchant account group.
Added On:  10/02/13
SQL Column:  BANK_ROUTING_NUMBER_MASKED_CHARGE
Java Field:  bankRoutingNumberMaskedCharge
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Masked routing number (last four digits) of the bank account associated with the merchant account group.
Added On:  08/22/17
SQL Column:  CC_REMITTANCE_PERIOD
Java Field:  ccRemittancePeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:2
Added On:  03/16/12
SQL Column:  CHARGEBACK_RESERVE_COLLECTED_AMOUNT
Java Field:  chargebackReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money available in the reserve after the last remittance happened. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  CHARGEBACK_RESERVE_MIN_AMOUNT
Java Field:  chargebackReserveMinAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Minimum amount of money that must be held in reserve at all times. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  CHARGEBACK_RESERVE_PERIOD
Java Field:  chargebackReservePeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:30
Time period in days, used to determine the requested amount of the reserve. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  CHARGEBACK_RESERVE_RATE
Java Field:  chargebackReserveRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Percentage of total transaction volume that should be retained as reserve. Using this rate and the Chargeback Reserve Period the requested amount of chargeback reserve is dynamically calculated and adjusted on each remittance. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  CHARGEBACK_RESERVE_REQUESTED_AMOUNT
Java Field:  chargebackReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money that must be maintained as chargebacks reserve. Requested amount gets dynamically adjusted as time progresses and processing volume changes. The requested amount should never drop below the minimum amount. See Reserves definition for additional information.
Added On:  02/16/15
SQL Column:  CONVENIENCE_FEE_BALANCE
Java Field:  convenienceFeeBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Shows the amount of money owed for convenience fee.
Added On:  11/05/19
SQL Column:  DIRECT_DEBIT_BALANCE
Java Field:  directDebitBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  DIRECT_DEBIT_FEE_BALANCE
Java Field:  directDebitFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  DIRECT_DEBIT_FUTURE_FEE_BALANCE
Java Field:  directDebitFutureFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  DIRECT_DEBIT_FUTURE_RESERVE_BALANCE
Java Field:  directDebitFutureReserveBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  DIRECT_DEBIT_NET_BALANCE
Java Field:  directDebitNetBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE
Java Field:  directDebitReattemptReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  DIRECT_DEBIT_RETURNS_BALANCE
Java Field:  directDebitReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/09/15
SQL Column:  DISTRIBUTION_SCHEMA_FK
Java Field:  distributionSchema
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Distribution Schema
Attributes:
Reference to the entity that represents information about funds distribution schema.
Added On:  10/29/13
SQL Column:  FEE_BALANCE
Java Field:  feeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Current outstanding balance for merchant fee.
Added On:  04/10/14
SQL Column:  FEE_SCHEMA_FK
Java Field:  feeSchema
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Fee Schema
Attributes:
Reference to the entity that represents fee schema.
Added On:  05/13/16
SQL Column:  FEE_TEMPLATE_CODE
Java Field:  feeTemplateCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the used fee template.
Added On:  10/11/13
SQL Column:  FEE_WITHDRAWAL_POLICY_CL
Java Field:  feeWithdrawalPolicyCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the type of current (or selected) approach used to withhold fees from a merchant.
Added On:  10/25/19
SQL Column:  FEES_RESPONSIBLE_CL
Java Field:  feesResponsibleCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References User Classifier
Attributes:
Added On:  03/16/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  03/16/12
SQL Column:  IS_CHARGEBACK_RESERVE_ENABLED
Java Field:  isChargebackReserveEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether chargeback reserve is enabled. If not enabled, money will not be withheld in the reserve.
Added On:  03/28/12
SQL Column:  IS_IGNORE_REMITTANCE_SOURCE
Java Field:  isIgnoreRemittanceSource
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Controls whether remittance source is ignored or not. If enabled, a single bank account will be used for all types of remittances and they will not be split based on the remittance source. See Remittance Source definition for additional information.
Added On:  11/05/12
SQL Column:  IS_MERCHANT_STATEMENT_ARCHIVING_ENABLED
Java Field:  isMerchantStatementArchivingEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether merchant statement archiving process is happening. Copies of statements are archived here: 126.
Added On:  08/23/13
SQL Column:  IS_MERCHANT_STATEMENT_EXPORT_ENABLED
Java Field:  isMerchantStatementExportEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the content of the Merchant Statements List report is exported to the merchant’s FTP via the data export mechanism.
Added On:  03/16/12
SQL Column:  IS_REFUND_RESERVE_ENABLED
Java Field:  isRefundReserveEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether refund reserve is enabled. If not enabled, limited refunds are allowed.
Added On:  10/02/12
SQL Column:  IS_REMITTANCE_HOLD_ENABLED
Java Field:  isRemittanceHoldEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether remittance process is enabled. When set to true, the balance of all of the newly generated remittance statements is not sent to the merchant, but transferred under the merchant's balance.
Added On:  03/16/12
SQL Column:  IS_RETURN_RESERVE_ENABLED
Java Field:  isReturnReserveEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether return reserve is enabled. If not enabled, money will not be withheld in the reserve.
Added On:  03/16/12
SQL Column:  LAST_COMMISSION_STATEMENT_DATE
Java Field:  lastCommissionStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the last reseller statement was sent to the merchant. See Statements definition for additional information.
Added On:  03/16/12
SQL Column:  LAST_DEPOSIT_STATEMENT_DATE
Java Field:  lastDepositStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the last deposit statement was generated for this merchant. See Statements definition for additional information.
Added On:  02/26/21
SQL Column:  LAST_MERCHANT_REMITTANCE_STATISTICS_UPDATE_DATE
Java Field:  lastMerchantRemittanceStatisticsUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/22/14
SQL Column:  LAST_MERCHANT_STATEMENT_STATISTICS_UPDATE_DATE
Java Field:  lastMerchantStatementStatisticsUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the merchant statement statistics was updated the last time.
Added On:  03/16/12
SQL Column:  LAST_REMITTANCE_DATE
Java Field:  lastRemittanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the last physical ACH transaction (deposit) was sent to the merchant. See Statements definition for additional information.
Added On:  05/04/18
SQL Column:  LAST_REMITTANCE_RECONCILIATION_STATISTICS_UPDATE_DATE
Java Field:  lastRemittanceReconciliationStatisticsUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  03/16/12
SQL Column:  LAST_STATEMENT_DATE
Java Field:  lastStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the last reconciliation statement was sent to the merchant. See Statements definition for additional information.
Added On:  08/02/23
SQL Column:  MADA_REMITTANCE_PERIOD
Java Field:  madaRemittancePeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:2
Added On:  03/19/15
SQL Column:  MAX_MERCHANT_STATEMENT_AMOUNT
Java Field:  maxMerchantStatementAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Maximum allowed amount of the merchant statement.
Added On:  03/19/15
SQL Column:  MAX_RESERVE_ADJUSTMENT_AMOUNT
Java Field:  maxReserveAdjustmentAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Shows the maximum amount of money that can be withheld for a single remittance to be placed in the reserve adjustments.
Added On:  10/02/12
SQL Column:  MAX_WITHHOLDING_AMOUNT
Java Field:  maxWithholdingAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Maximum amount of money that can be withheld in favor of reserves within a single remittance.
Added On:  03/16/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  04/10/14
SQL Column:  MERCHANT_CYCLE_FK
Java Field:  merchantCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Merchant Cycle
Attributes:
Reference to the entity that represents merchant cycle.
Added On:  04/10/14
SQL Column:  MERCHANT_FEE_FK
Java Field:  merchantFee
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Merchant Fee
Attributes:
Reference to the entity that represents various information about merchant's fee.
Added On:  08/04/22
SQL Column:  MERCHANT_FEE_SCHEMA_FK
Java Field:  merchantFeeSchema
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Merchant Fee Schema
Attributes:
Added On:  03/19/15
SQL Column:  MIN_MERCHANT_STATEMENT_AMOUNT
Java Field:  minMerchantStatementAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Minimum amount of the merchant statement.
Added On:  06/19/13
SQL Column:  MINIMUM_REMITTANCE_AMOUNT
Java Field:  minimumRemittanceAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Shows the minimum amount of funds that must be reached in order for the remittance process to occur.
Added On:  01/23/20
SQL Column:  MONTHLY_STATEMENT_SENT_DATE
Java Field:  monthlyStatementSentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  03/16/12
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Name of the merchant account group (company or person).
Added On:  10/13/12
SQL Column:  NET_BALANCE
Java Field:  netBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Shows the amount of money owed to the merchant excluding reserves.
Added On:  02/21/20
SQL Column:  OWNER_CL
Java Field:  ownerCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  Object
References User Classifier
Attributes:
Added On:  09/23/13
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Portfolio that this group belongs to.
Added On:  03/16/12
SQL Column:  PREV_COMMISSION_STATEMENT_DATE
Java Field:  prevCommissionStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the reseller statement before the last one was sent to the merchant. See Statements definition for additional information.
Added On:  03/16/12
SQL Column:  PREV_DEPOSIT_STATEMENT_DATE
Java Field:  prevDepositStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the deposit statement before the last one was generated for this merchant. See Statements definition for additional information.
Added On:  03/16/12
SQL Column:  PREV_REMITTANCE_DATE
Java Field:  prevRemittanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the physical ACH transaction (deposit) before the last one was sent to the merchant. See Statements definition for additional information.
Added On:  03/16/12
SQL Column:  PREV_STATEMENT_DATE
Java Field:  prevStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the reconciliation statement before the last one was sent to the merchant. See Statements definition for additional information.
Added On:  05/04/18
SQL Column:  PROCESSING_COST_BALANCE
Java Field:  processingCostBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  04/10/14
SQL Column:  PROVIDER_PROFILE_LOG_FK
Java Field:  providerProfileLog
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents provider profile log information.
Added On:  04/10/14
SQL Column:  REATTEMPT_RETURNS_BALANCE
Java Field:  reattemptReturnsBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Returns balance of the returns reattempt.
Added On:  12/23/22
SQL Column:  RECURRING_ANNUAL01_DATE
Java Field:  recurringAnnual01Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ANNUAL02_DATE
Java Field:  recurringAnnual02Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ANNUAL03_DATE
Java Field:  recurringAnnual03Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ANNUAL04_DATE
Java Field:  recurringAnnual04Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ANNUAL05_DATE
Java Field:  recurringAnnual05Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  10/02/13
SQL Column:  RECURRING_FEES_BEGIN_DATE
Java Field:  recurringFeesBeginDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when recurrent fees for a merchant begin to accrue.
Added On:  12/23/22
SQL Column:  RECURRING_ONETIME01_DATE
Java Field:  recurringOnetime01Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ONETIME02_DATE
Java Field:  recurringOnetime02Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ONETIME03_DATE
Java Field:  recurringOnetime03Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ONETIME04_DATE
Java Field:  recurringOnetime04Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ONETIME05_DATE
Java Field:  recurringOnetime05Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  12/23/22
SQL Column:  RECURRING_ONETIME06_DATE
Java Field:  recurringOnetime06Date
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  03/16/12
SQL Column:  REFUND_RESERVE_COLLECTED_AMOUNT
Java Field:  refundReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the reserve that the system managed to collect at the time of the last remittance. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  REFUND_RESERVE_REMAINING_AMOUNT
Java Field:  refundReserveRemainingAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money, against which refunds can be made. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  REFUND_RESERVE_REQUESTED_AMOUNT
Java Field:  refundReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the reserve that the system needs to maintain. See Reserves definition for additional information.
Added On:  08/17/15
SQL Column:  REMITTANCE_CURRENCY_CODE
Java Field:  remittanceCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes: Default:USD
Code of currency used for remittance.
Default value: USD.
Added On:  06/18/15
SQL Column:  REMITTANCE_HOLD_NOTE
Java Field:  remittanceHoldNote
Status:  Active
SQL Type:  varchar(500)
Java Type:  String
Attributes:
Any additional information about remittance hold.
Added On:  06/18/15
SQL Column:  REMITTANCE_HOLD_USER_CODE
Java Field:  remittanceHoldUserCode
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Code of the remittance hold user.
Added On:  08/22/17
SQL Column:  REMITTANCE_PERIOD
Java Field:  remittancePeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:1
Added On:  03/16/12
SQL Column:  REMITTANCE_RECIPIENT_LIST
Java Field:  remittanceRecipientList
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
List of email addresses of people that will receive a PDF copy of remittance statement once it is generated.
Added On:  11/12/19
SQL Column:  REMITTANCE_RECIPIENT_LIST_MONTHLY
Java Field:  remittanceRecipientListMonthly
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Added On:  04/06/16
SQL Column:  REMITTANCE_START_DATE
Java Field:  remittanceStartDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Start date of the remittance.
Added On:  05/04/18
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  05/04/18
SQL Column:  RETURN_BALANCE_REPORTED
Java Field:  returnBalanceReported
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  RETURN_FEE_BALANCE
Java Field:  returnFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  RETURN_FEE_BALANCE_REPORTED
Java Field:  returnFeeBalanceReported
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  RETURN_PROCESSING_COST_BALANCE
Java Field:  returnProcessingCostBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  RETURN_PROCESSING_COST_BALANCE_REPORTED
Java Field:  returnProcessingCostBalanceReported
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  RETURN_RESERVE_COLLECTED_AMOUNT
Java Field:  returnReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money for ACH returns available in the reserve after the last remittance happened. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  RETURN_RESERVE_MIN_AMOUNT
Java Field:  returnReserveMinAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Minimum amount of money for ACH returns that must be held in reserve at all times. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  RETURN_RESERVE_PERIOD
Java Field:  returnReservePeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:30
Time period in days, used to determine the requested amount of the reserve. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  RETURN_RESERVE_RATE
Java Field:  returnReserveRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Percentage of total transaction volume that should be retained as reserve for ACH returns. Using this rate and the Return Reserve Period the requested amount of return reserve is dynamically calculated and adjusted on each remittance. See Reserves definition for additional information.
Added On:  03/16/12
SQL Column:  RETURN_RESERVE_REQUESTED_AMOUNT
Java Field:  returnReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money for ACH returns that must be maintained as chargebacks reserve. Requested amount gets dynamically adjusted as time progresses and processing volume changes. The requested amount should never drop below the minimum amount. See Reserves definition for additional information.
Added On:  05/04/18
SQL Column:  RETURN_TAX_BALANCE
Java Field:  returnTaxBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  RETURN_TAX_BALANCE_REPORTED
Java Field:  returnTaxBalanceReported
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/15/13
SQL Column:  RETURNS_BALANCE
Java Field:  returnsBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Current balance of any returned withdrawals
Added On:  02/17/14
SQL Column:  STATEMENT_EMAILING_POLICY
Java Field:  statementEmailingPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Enumerates possible values of statement emailing policy for the merchant account group.
Added On:  11/15/13
SQL Column:  STATEMENT_POLICY_CL
Java Field:  statementPolicyCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumeration of possible values of statement policy for the merchant account group.
Added On:  02/25/19
SQL Column:  STATEMENT_VIEW_POLICY
Java Field:  statementViewPolicy
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  03/26/18
SQL Column:  TAX_BALANCE
Java Field:  taxBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  TOKEN_CODE
Java Field:  tokenCode
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Value, issued by the internal tokenization system that replaces actual bank account and routing number. Using that value system can obtain the real bank account number and routing number to process.
Added On:  10/02/13
SQL Column:  TOKEN_CODE_CHARGE
Java Field:  tokenCodeCharge
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Value, issued by the internal tokenization system that replaces actual bank account and routing number. Using that value system can obtain the real bank account number and routing number to process.