Merchant Activity


Added On:  03/16/12 
SQL Table:  IAPP_MERCHANT_ACTIVITY 
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:  int(11)
Java Type:  Integer
Attributes:
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 / Primary Key
Attributes: Required
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  03/16/12
SQL Column:  LAST_MERCHANT_STATEMENT_DATE
Java Field:  lastMerchantStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  09/08/17
SQL Column:  LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE2
Java Field:  lastProcessorProcessingStatisticsUpdateDate2
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/08/17
SQL Column:  LAST_PROCESSOR_PROCESSING_STATISTICS_UPDATE_DATE3
Java Field:  lastProcessorProcessingStatisticsUpdateDate3
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  01/29/14
SQL Column:  LAST_REMITTANCE_RETURNS_IMPORT_DATE
Java Field:  lastRemittanceReturnsImportDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
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:  02/11/13
SQL Column:  PREV_AGENT_REMITTANCE_DATE
Java Field:  prevAgentRemittanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  09/08/17
SQL Column:  PROCESSOR_NAME2
Java Field:  processorName2
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  PROCESSOR_NAME3
Java Field:  processorName3
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  07/27/17
SQL Column:  RETURN_SEQUENCE_NUMBER
Java Field:  returnSequenceNumber
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Sequence Number of the last return file.