Added On:  03/16/12 
        
        
        
            Module:  UniCore 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  MerchantActivity 
                    
        
        
     
    
        
            
                
                    Stores statistical time-sensitive information for a merchant, which is mostly used by internal processes to log last time when a certain action got performed.                
             
         
     
        
        
                    
                        
                Added On:  03/16/12
                SQL Column:  BALANCE
                Java Field:  balance
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Current total balance of the merchant.                        
                     
                 
             
                    
                        
                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:  02/11/13
                SQL Column:  LAST_AGENT_REMITTANCE_DATE
                Java Field:  lastAgentRemittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last agent remittance.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  LAST_AGENT_STATEMENT_DATE
                Java Field:  lastAgentStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last agent statement.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  LAST_BATCH_RESPONSE_DATE
                Java Field:  lastBatchResponseDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when UniPay generated a batch response file to the merchant through FTP gates.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  LAST_BILLING_STATISTICS_UPDATE_DATE
                Java Field:  lastBillingStatisticsUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the merchant billing statistics information was updated the last time.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  LAST_COMPANY_REMITTANCE_DATE
                Java Field:  lastCompanyRemittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last company remittance.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  LAST_COMPANY_STATEMENT_DATE
                Java Field:  lastCompanyStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last company statement.                        
                     
                 
             
                    
                        
                Added On:  02/05/15
                SQL Column:  LAST_DATA_EXPORT_DATE
                Java Field:  lastDataExportDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last data export.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  LAST_DEPOSIT_STATISTICS_UPDATE_DATE
                Java Field:  lastDepositStatisticsUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the merchant deposit statistics information was updated the last time.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  LAST_FINANCIAL_STATISTICS_UPDATE_DATE
                Java Field:  lastFinancialStatisticsUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the  merchant financial statistics information was updated the last time.                        
                     
                 
             
                    
                        
                Added On:  02/05/15
                SQL Column:  LAST_FUNDS_DISTRIBUTION_UPDATE_DATE
                Java Field:  lastFundsDistributionUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last funds distribution update.                        
                     
                 
             
                    
                        
                Added On:  09/08/17
                SQL Column:  LAST_MERCHANT_PROCESSING_STATISTICS_UPDATE_DATE
                Java Field:  lastMerchantProcessingStatisticsUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  LAST_MERCHANT_STATEMENT_DATE
                Java Field:  lastMerchantStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the last merchant statement was generated for this merchant.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  LAST_PARTNER_REMITTANCE_DATE
                Java Field:  lastPartnerRemittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last partner remittance.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  LAST_PARTNER_STATEMENT_DATE
                Java Field:  lastPartnerStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last partner statement.                        
                     
                 
             
                    
                        
                Added On:  05/24/24
                SQL Column:  LAST_PROCESSING_RECONCILIATION_STATISTICS_UPDATE_DATE
                Java Field:  lastProcessingReconciliationStatisticsUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the processing reconciliaton statistics information was updated the last time.                        
                     
                 
             
                    
                        
                Added On:  06/05/14
                SQL Column:  LAST_PROCESSING_STATISTICS_UPDATE_DATE
                Java Field:  lastProcessingStatisticsUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last processing statistics update.                        
                     
                 
             
                    
                        
                Added On:  09/08/17
                SQL Column:  LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE1
                Java Field:  lastProcessorProcessingStatisticsUpdateDate1
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  09/08/17
                SQL Column:  LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE2
                Java Field:  lastProcessorProcessingStatisticsUpdateDate2
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  09/08/17
                SQL Column:  LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE3
                Java Field:  lastProcessorProcessingStatisticsUpdateDate3
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  01/29/14
                SQL Column:  LAST_REMITTANCE_RETURNS_IMPORT_DATE
                Java Field:  lastRemittanceReturnsImportDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last remittance returns file import.                        
                     
                 
             
                    
                        
                Added On:  07/27/17
                SQL Column:  LAST_RETURNS_RESPONSE_DATE
                Java Field:  lastReturnsResponseDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date and time of the last generation of the return file.                        
                     
                 
             
                    
                        
                Added On:  08/20/13
                SQL Column:  LAST_SETTLEMENT_CURRENCY_UPDATE_DATE
                Java Field:  lastSettlementCurrencyUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the last settlement currency update.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  LAST_STATISTICS_UPDATE_DATE
                Java Field:  lastStatisticsUpdateDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the  merchant activity statistics information was updated the last time.                        
                     
                 
             
                    
                        
                Added On:  01/15/16
                SQL Column:  LAST_SUBSCRIPTION_RESPONSE_DATE
                Java Field:  lastSubscriptionResponseDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the subscription response was updated last time.                        
                     
                 
             
                    
                        
                Added On:  10/06/15
                SQL Column:  LAST_UPDATE_RESPONSE_DATE
                Java Field:  lastUpdateResponseDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the response was updated last time.                        
                     
                 
             
                    
                        
                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:  02/11/13
                SQL Column:  PREV_AGENT_REMITTANCE_DATE
                Java Field:  prevAgentRemittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the previous agent remittance.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  PREV_AGENT_STATEMENT_DATE
                Java Field:  prevAgentStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the previous agent statement.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  PREV_COMPANY_REMITTANCE_DATE
                Java Field:  prevCompanyRemittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the previous company remittance.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  PREV_COMPANY_STATEMENT_DATE
                Java Field:  prevCompanyStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the previous company statement.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  PREV_PARTNER_REMITTANCE_DATE
                Java Field:  prevPartnerRemittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the previous partner remittance.                        
                     
                 
             
                    
                        
                Added On:  02/11/13
                SQL Column:  PREV_PARTNER_STATEMENT_DATE
                Java Field:  prevPartnerStatementDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date of the previous partner statement.                        
                     
                 
             
                    
                        
                Added On:  09/08/17
                SQL Column:  PROCESSOR_NAME1
                Java Field:  processorName1
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/08/17
                SQL Column:  PROCESSOR_NAME2
                Java Field:  processorName2
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/08/17
                SQL Column:  PROCESSOR_NAME3
                Java Field:  processorName3
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/27/17
                SQL Column:  RETURN_SEQUENCE_NUMBER
                Java Field:  returnSequenceNumber
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Sequence Number of the last return file.