Added On:  03/16/12 
        
        
        
            Module:  UniCore 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  MerchantStatement 
                    
        
        
     
    
        
            
                
                    Merchant statement, compiled based on actual processing volumes and merchant fee details. It shows all the transactions processed for the given merchant during the specified time interval and all the fees deduced. Merchant statement is compiled for every remittance. 
                
             
         
     
        
        
                    
                        
                Added On:  03/16/12
                SQL Column:  ACH_REMITTANCE_AMOUNT
                Java Field:  achRemittanceAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of money for this statement that has to be remitted out of the given 
remittance source (in this case, ACH).                        
 
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  ACH_TRANSACTION_CODE
                Java Field:  achTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(24)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Reference number of the remittance transaction generated based on respective remittance amount and source (in this case - ACH).
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  ADJUSTED_AMOUNT
                Java Field:  adjustedAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Total amount on the statement after adjustments. 
If adjusted amount is below the original amount, it means that 
1) the money has been withdrawn "manually", or 
2) the balance in the previous statement was negative. 
If adjusted amount is above the original one, it means that: 
1) the money has been added manually, or 
2) some former debt has been returned, or
3) the money from reserve has been returned.
                        
                     
                 
             
                    
                        
                Added On:  03/16/14
                SQL Column:  ADVANCE_AMOUNT
                Java Field:  advanceAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Advance amount of the merchant statement.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_REMITTANCE_AMOUNT
                Java Field:  amexRemittanceAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of money for this statement that has to be remitted out of the given 
remittance source (in this case, American Express).                        
 
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_TRANSACTION_CODE
                Java Field:  amexTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(24)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Reference number of the remittance transaction generated based on respective remittance amount and source (in this case - American Express).
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  AMOUNT
                Java Field:  amount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Total remittance amount on the statement before any adjustments.
                        
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  APPROVAL_DATE
                Java Field:  approvalDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  APPROVER_CODE
                Java Field:  approverCode
             
            
                Status:  Active
                SQL Type:  varchar(56)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The user name of a person who approved the statement.
                        
                     
                 
             
                    
                        
                Added On:  08/25/16
                SQL Column:  ARCHIVING_DATE
                Java Field:  archivingDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the statement was archived.
                        
                     
                 
             
                    
                        
                Added On:  11/06/18
                SQL Column:  ASSESSMENTS_AMOUNT
                Java Field:  assessmentsAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  BALANCE
                Java Field:  balance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Actual balance on the merchant account for which the statement is generated.
                        
                     
                 
             
                    
                        
                Added On:  12/09/13
                SQL Column:  BALANCE_ADJUSTMENTS_AMOUNT
                Java Field:  balanceAdjustmentsAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the balance adjustment.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  BANK_CARD_REMITTANCE_AMOUNT
                Java Field:  bankCardRemittanceAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of money for this statement that has to be remitted out of the given 
remittance source (in this case, bank cards).                        
 
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  BANK_CARD_TRANSACTION_CODE
                Java Field:  bankCardTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(24)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Reference number of the remittance transaction generated based on respective remittance amount and source (in this case - bank cards).
                        
                     
                 
             
                    
                        
                Added On:  02/12/14
                SQL Column:  BATCH_DEPOSIT_POLICY
                Java Field:  batchDepositPolicy
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether the batch deposit is enabled or not.
                        
                     
                 
             
                    
                        
                Added On:  09/05/18
                SQL Column:  CHARGEBACK_RESERVE_MIN_AMOUNT
                Java Field:  chargebackReserveMinAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  12/06/12
                SQL Column:  CHARGEBACK_RESERVE_RATE
                Java Field:  chargebackReserveRate
             
            
                Status:  Active
                SQL Type:  decimal(10,2)
                Java Type:  Double
             
            
            
            
                
                    
                        
                        Current rate for chargeback reserve. Represents a percentage of the approved transactions deposited to the merchant that is held in reserve. See 
Reserves for more details.                        
 
                     
                 
             
                    
                        
                Added On:  09/05/18
                SQL Column:  CHARGEBACK_SALE_RESERVE_TOTAL_AMOUNT
                Java Field:  chargebackSaleReserveTotalAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  02/19/15
                SQL Column:  CONVENIENCE_FEE_DEDUCTION_AMOUNT
                Java Field:  convenienceFeeDeductionAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Deduction amount of convenience fee.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  CREATE_DATE
                Java Field:  createDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the record was created.
                        
                     
                 
             
                    
                        
                Added On:  08/28/18
                SQL Column:  DEPOSIT_CL
                Java Field:  depositCl
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/24/18
                SQL Column:  DEPOSIT_TYPE
                Java Field:  depositType
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
                
                    Attributes:
                    ReadOnly, Calculated                
                             
            
                    
                        
                Added On:  12/03/13
                SQL Column:  EMAIL_SENT_DATE
                Java Field:  emailSentDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the email was sent the last time.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  END_DATE
                Java Field:  endDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        End date of the time period covered by the statement.
                        
                     
                 
             
                    
                        
                Added On:  08/23/13
                SQL Column:  EXPORT_DATE
                Java Field:  exportDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  04/24/15
                SQL Column:  FEE_AMOUNT
                Java Field:  feeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the merchant's fee.
                        
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  FEE_AMOUNT_RECEIVABLE
                Java Field:  feeAmountReceivable
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  08/31/16
                SQL Column:  FEE_SCHEMA_FK
                Java Field:  feeSchema
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Reference to the entity that represents fee schema information.
                        
                     
                 
             
                    
                        
                Added On:  10/25/19
                SQL Column:  FEES_RESPONSIBLE_CL
                Java Field:  feesResponsibleCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/10/23
                SQL Column:  FUNDING_MODE_CL
                Java Field:  fundingModeCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  12/10/13
                SQL Column:  HOLD_AMOUNT
                Java Field:  holdAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the hold transaction.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.
                        
                     
                 
             
                    
                        
                Added On:  11/06/18
                SQL Column:  INTERCHANGE_AMOUNT
                Java Field:  interchangeAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  02/27/20
                SQL Column:  IS_IGNORE_REMITTANCE_SOURCE
                Java Field:  isIgnoreRemittanceSource
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
            
                    
                        
                Added On:  03/06/13
                SQL Column:  IS_PROCESSING_COST_BATCH_ACH_ENABLED
                Java Field:  isProcessingCostBatchAchEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the processing cost for ACH batch transactions is included in the statement.
                        
                     
                 
             
                    
                        
                Added On:  03/06/13
                SQL Column:  IS_PROCESSING_COST_BATCH_AMEX_ENABLED
                Java Field:  isProcessingCostBatchAmexEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the processing cost for Amex batch transactions is included in the statement.
                        
                     
                 
             
                    
                        
                Added On:  02/25/13
                SQL Column:  IS_PROCESSING_COST_BATCH_CARDS_ENABLED
                Java Field:  isProcessingCostBatchCardsEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the processing cost for batch bank card (Visa, MasterCard, Discover) transactions is included in the statement.
                        
                     
                 
             
                    
                        
                Added On:  03/06/13
                SQL Column:  IS_PROCESSING_COST_REALTIME_ACH_ENABLED
                Java Field:  isProcessingCostRealtimeAchEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the processing cost for ACH real-time transactions is included in the statement.
                        
                     
                 
             
                    
                        
                Added On:  03/06/13
                SQL Column:  IS_PROCESSING_COST_REALTIME_AMEX_ENABLED
                Java Field:  isProcessingCostRealtimeAmexEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the processing cost for Amex real-time transactions is included in the statement.
                        
                     
                 
             
                    
                        
                Added On:  02/25/13
                SQL Column:  IS_PROCESSING_COST_REALTIME_CARDS_ENABLED
                Java Field:  isProcessingCostRealtimeCardsEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the processing cost for real-time bank card (Visa, MasterCard, Discover) transactions is included in the statement.
                        
                     
                 
             
                    
                        
                Added On:  01/29/14
                SQL Column:  IS_REATTEMPT_WITHDRAWAL
                Java Field:  isReattemptWithdrawal
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates, that this is the second subsequent attempt to withdraw funds from merchant's deposit account.
                        
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  LAST_CHARGEBACK_RESERVE_COLLECTED_AMOUNT
                Java Field:  lastChargebackReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount held in chargeback reserve as of the previous statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  LAST_REFUND_RESERVE_REQUESTED_AMOUNT
                Java Field:  lastRefundReserveRequestedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of money required to be held in refund reserve as of the previous statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  LAST_RETURN_RESERVE_COLLECTED_AMOUNT
                Java Field:  lastReturnReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount held in return reserve as of the previous statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  MANUAL_ADJUSTMENTS_AMOUNT
                Java Field:  manualAdjustmentsAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        The total amount of manual adjustments, introduced into the statement.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        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:  08/31/16
                SQL Column:  MERCHANT_ACCOUNT_GROUP_FK
                Java Field:  merchantAccountGroup
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents merchant account group information.
                        
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  MERCHANT_CHARGE_AMOUNT
                Java Field:  merchantChargeAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  08/31/16
                SQL Column:  MERCHANT_CYCLE_DETAIL_FK
                Java Field:  merchantCycleDetail
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents merchant cycle details information.
                        
                     
                 
             
                    
                        
                Added On:  03/26/12
                SQL Column:  MERCHANT_DEPOSIT_DATE
                Java Field:  merchantDepositDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        The date when the money is expected to hit (be deposited to) the merchant's bank account.
                        
                     
                 
             
                    
                        
                Added On:  08/31/16
                SQL Column:  MERCHANT_FEE_FK
                Java Field:  merchantFee
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents merchant fee information.
                        
                     
                 
             
                    
                        
                Added On:  08/28/18
                SQL Column:  MERCHANT_STATEMENT_ACTIVITY_FK
                Java Field:  merchantStatementActivity
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  NEXT_CHARGEBACK_RESERVE_COLLECTED_AMOUNT
                Java Field:  nextChargebackReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount held in chargeback reserve in the current statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  NEXT_CHARGEBACK_RESERVE_REQUESTED_AMOUNT
                Java Field:  nextChargebackReserveRequestedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Required chargeback reserve amount as of current statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  02/19/15
                SQL Column:  NEXT_CONVENIENCE_FEE_AMOUNT
                Java Field:  nextConvenienceFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the next convenience fee of the merchant.
                        
                     
                 
             
                    
                        
                Added On:  10/29/13
                SQL Column:  NEXT_FEE_BALANCE
                Java Field:  nextFeeBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  NEXT_NET_BALANCE
                Java Field:  nextNetBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  NEXT_PROCESSING_COST_BALANCE
                Java Field:  nextProcessingCostBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  NEXT_REFUND_RESERVE_COLLECTED_AMOUNT
                Java Field:  nextRefundReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount held in refund reserve in the current statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  NEXT_REFUND_RESERVE_REQUESTED_AMOUNT
                Java Field:  nextRefundReserveRequestedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Money available in the refund reserve after the current statement is approved and necessary funds are withdrawn from 
the statement into the refund reserve. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  NEXT_RETURN_FEE_BALANCE
                Java Field:  nextReturnFeeBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  NEXT_RETURN_PROCESSING_COST_BALANCE
                Java Field:  nextReturnProcessingCostBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  NEXT_RETURN_RESERVE_COLLECTED_AMOUNT
                Java Field:  nextReturnReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount held in return reserve in the current statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  12/06/12
                SQL Column:  NEXT_RETURN_RESERVE_REQUESTED_AMOUNT
                Java Field:  nextReturnReserveRequestedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Required return reserve amount as of current statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  NEXT_RETURN_TAX_BALANCE
                Java Field:  nextReturnTaxBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  03/26/18
                SQL Column:  NEXT_TAX_BALANCE
                Java Field:  nextTaxBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  NOTE
                Java Field:  note
             
            
                Status:  Active
                SQL Type:  varchar(1024)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Any additional information about the statement.
                        
                     
                 
             
                    
                        
                Added On:  09/23/13
                SQL Column:  PORTFOLIO_CODE
                Java Field:  portfolioCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Portfolio that this group belongs to.
                        
                     
                 
             
                    
                        
                Added On:  02/22/18
                SQL Column:  PORTFOLIO_EXPORT_DATE
                Java Field:  portfolioExportDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  06/24/16
                SQL Column:  PREV_BALANCE
                Java Field:  prevBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Balance that was on the merchant account at the moment of previous statement generation.
                        
                     
                 
             
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_BANK_CARD_BALANCE
                Java Field:  prevBankCardBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_BANK_CARD_FEE_BALANCE
                Java Field:  prevBankCardFeeBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_BANK_CARD_NET_BALANCE
                Java Field:  prevBankCardNetBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_BANK_CARD_REATTEMPT_RETURNS_BALANCE
                Java Field:  prevBankCardReattemptReturnsBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_BANK_CARD_RETURNS_BALANCE
                Java Field:  prevBankCardReturnsBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  06/23/16
                SQL Column:  PREV_CHARGEBACK_RESERVE_COLLECTED_AMOUNT
                Java Field:  prevChargebackReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount held in chargeback reserve according to previous statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  02/19/15
                SQL Column:  PREV_CONVENIENCE_FEE_AMOUNT
                Java Field:  prevConvenienceFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the previous convenience fee of the merchant.
                        
                     
                 
             
                    
                        
                Added On:  08/31/23
                SQL Column:  PREV_DEPOSIT_STATEMENT_DATE
                Java Field:  prevDepositStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_DIRECT_DEBIT_BALANCE
                Java Field:  prevDirectDebitBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_DIRECT_DEBIT_FEE_BALANCE
                Java Field:  prevDirectDebitFeeBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_DIRECT_DEBIT_NET_BALANCE
                Java Field:  prevDirectDebitNetBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE
                Java Field:  prevDirectDebitReattemptReturnsBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/05/19
                SQL Column:  PREV_DIRECT_DEBIT_RETURNS_BALANCE
                Java Field:  prevDirectDebitReturnsBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  10/29/13
                SQL Column:  PREV_FEE_BALANCE
                Java Field:  prevFeeBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  06/24/16
                SQL Column:  PREV_NET_BALANCE
                Java Field:  prevNetBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  PREV_PROCESSING_COST_BALANCE
                Java Field:  prevProcessingCostBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  06/24/16
                SQL Column:  PREV_REATTEMPT_RETURNS_BALANCE
                Java Field:  prevReattemptReturnsBalance
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Total amount of reattempted ACH returns, chargebacks and reversals, that were included in previuos statement.
                        
                     
                 
             
                    
                        
                Added On:  06/23/16
                SQL Column:  PREV_REFUND_RESERVE_COLLECTED_AMOUNT
                Java Field:  prevRefundReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of money required being held in refund reserve as of the previous statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  08/31/23
                SQL Column:  PREV_REMITTANCE_DATE
                Java Field:  prevRemittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  PREV_RETURN_FEE_BALANCE
                Java Field:  prevReturnFeeBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  PREV_RETURN_PROCESSING_COST_BALANCE
                Java Field:  prevReturnProcessingCostBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  06/23/16
                SQL Column:  PREV_RETURN_RESERVE_COLLECTED_AMOUNT
                Java Field:  prevReturnReserveCollectedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount held in return reserve according to previous statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  PREV_RETURN_TAX_BALANCE
                Java Field:  prevReturnTaxBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  06/24/16
                SQL Column:  PREV_RETURNS_BALANCE
                Java Field:  prevReturnsBalance
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Total amount of ACH returns, chargebacks and reversals, that were included in previous statement.
                        
                     
                 
             
                    
                        
                Added On:  12/09/13
                SQL Column:  PREV_STATEMENT_BALANCE
                Java Field:  prevStatementBalance
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Previous statement balance of the selected merchant account.
                        
                     
                 
             
                    
                        
                Added On:  08/31/23
                SQL Column:  PREV_STATEMENT_DATE
                Java Field:  prevStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  03/26/18
                SQL Column:  PREV_TAX_BALANCE
                Java Field:  prevTaxBalance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  PROCESSED_AMOUNT
                Java Field:  processedAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  PROCESSING_COST_AMOUNT
                Java Field:  processingCostAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  PROCESSING_COST_AMOUNT_RECEIVABLE
                Java Field:  processingCostAmountReceivable
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  02/12/14
                SQL Column:  REALTIME_DEPOSIT_POLICY
                Java Field:  realtimeDepositPolicy
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether a realtime deposit is enabled or not.
                        
                     
                 
             
                    
                        
                Added On:  02/10/16
                SQL Column:  RECONCILIATION_STATE_CL
                Java Field:  reconciliationStateCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of current reconciliation state.
                        
                     
                 
             
                    
                        
                Added On:  02/10/16
                SQL Column:  RECONCILIATOR_CODE
                Java Field:  reconciliatorCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  12/06/12
                SQL Column:  REFUND_RESERVE_REQUESTED_AMOUNT
                Java Field:  refundReserveRequestedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of money required to be held in refund reserve as of the current statement. See 
Reserves for details.                        
 
                     
                 
             
                    
                        
                Added On:  01/10/14
                SQL Column:  REMITTANCE_CURRENCY_CODE
                Java Field:  remittanceCurrencyCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the currency used for the remittance transaction.
                        
                     
                 
             
                    
                        
                Added On:  06/20/15
                SQL Column:  REMITTANCE_INFO
                Java Field:  remittanceInfo
             
            
                Status:  Active
                SQL Type:  varchar(500)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Remittance transaction information.
                        
                     
                 
             
                    
                        
                Added On:  03/02/13
                SQL Column:  REMITTANCE_TRANSACTION_CL
                Java Field:  remittanceTransactionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the way, in which money was remitted.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  REMITTED_AMOUNT
                Java Field:  remittedAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Actual amount that was remitted to the merchant.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  REMITTER_CODE
                Java Field:  remitterCode
             
            
                Status:  Active
                SQL Type:  varchar(56)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The user name of a person who remits the money under manual (non-automated) remittance.
                        
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  RESELLER_CODE
                Java Field:  resellerCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  RESERVE_ADJUSTMENTS_AMOUNT
                Java Field:  reserveAdjustmentsAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Net amount of reserve-related adjustments, associated with the statement.
                        
                     
                 
             
                    
                        
                Added On:  09/05/18
                SQL Column:  RETURN_RESERVE_MIN_AMOUNT
                Java Field:  returnReserveMinAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  12/06/12
                SQL Column:  RETURN_RESERVE_RATE
                Java Field:  returnReserveRate
             
            
                Status:  Active
                SQL Type:  decimal(10,2)
                Java Type:  Double
             
            
            
            
                
                    
                        
                        Current rate for return reserve.  Represents a percentage of the approved transactions deposited to the merchant that is held in reserve. See 
Reserves for more details.                        
 
                     
                 
             
                    
                        
                Added On:  09/05/18
                SQL Column:  RETURN_SALE_RESERVE_TOTAL_AMOUNT
                Java Field:  returnSaleReserveTotalAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  RETURNS_AMOUNT
                Java Field:  returnsAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Total amount of ACH returns, chargebacks and reversals, that are included in the statement.
                        
                     
                 
             
                    
                        
                Added On:  03/19/15
                SQL Column:  REVIEW_POLICY
                Java Field:  reviewPolicy
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether statement review is enabled or not.
                        
                     
                 
             
                    
                        
                Added On:  05/31/17
                SQL Column:  SPLIT_ADJUSTED_AMOUNT
                Java Field:  splitAdjustedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount that is included in the split adjustment.
                        
                     
                 
             
                    
                        
                Added On:  05/04/18
                SQL Column:  SPLIT_AMOUNT
                Java Field:  splitAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  START_DATE
                Java Field:  startDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Start date of the time period covered in the statement.
                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  STATUS_CL
                Java Field:  statusCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current status of the statement.
                        
                     
                 
             
                    
                        
                Added On:  03/26/18
                SQL Column:  TAX_AMOUNT
                Java Field:  taxAmount
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/04/18
                SQL Column:  TAX_AMOUNT_RECEIVABLE
                Java Field:  taxAmountReceivable
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  05/31/17
                SQL Column:  UNPROCESSED_SPLIT_COUNT
                Java Field:  unprocessedSplitCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Number of splits that were not processed.
                        
                     
                 
             
                    
                        
                Added On:  12/10/13
                SQL Column:  WRITEOFFS_AMOUNT
                Java Field:  writeoffsAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the write-offs transactions.