Merchant Financial Statistics


Added On:  03/16/12 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantFinancialStatistics 
Represents information about merchant financial statistics.
Added On:  03/16/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  03/16/12
SQL Column:  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:  03/16/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created.
Added On:  03/16/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount of the transaction. Supply the value in cents without a decimal point.
Added On:  03/16/12
SQL Column:  SUBMISSION_DATE
Java Field:  submissionDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the submission.
Added On:  03/16/12
SQL Column:  REQUEST_DATE
Java Field:  requestDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the request.
Added On:  03/16/12
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the response.
Added On:  03/16/12
SQL Column:  DEPOSIT_DATE
Java Field:  depositDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the deposit.
Added On:  03/16/12
SQL Column:  REMITTANCE_DATE
Java Field:  remittanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the remittance.
Added On:  03/16/12
SQL Column:  TRANSACTION_SOURCE_CL
Java Field:  transactionSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of transaction source.
Added On:  03/16/12
SQL Column:  PAYMENT_CL
Java Field:  paymentCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
References Payment Classifier
Attributes:
Represents the selected type of payment (asset transactions).
Added On:  03/16/12
SQL Column:  ATTEMPT_COUNT
Java Field:  attemptCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number of attempts.
Added On:  03/16/12
SQL Column:  SUBMISSION_CODE
Java Field:  submissionCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the submission.
Added On:  03/16/12
SQL Column:  IS_SUBMISSION_CLOSED
Java Field:  isSubmissionClosed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Indicates whether the submission is closed.
Added On:  03/16/12
SQL Column:  IS_OUTSIDE_SUBMISSION
Java Field:  isOutsideSubmission
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Indicates whether the submission is outside.
Added On:  03/16/12
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the type of asset transaction.
Added On:  03/16/12
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
The unique code of the financial transaction.
Added On:  03/16/12
SQL Column:  MERCHANT_ACCOUNT_GROUP_CODE
Java Field:  merchantAccountGroupCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the corresponding merchant account group.
Added On:  03/16/12
SQL Column:  SUBMISSION_CL
Java Field:  submissionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of submission selected.
Added On:  03/16/12
SQL Column:  PROVIDER_NAME
Java Field:  providerName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the provider.
Added On:  03/16/12
SQL Column:  IS_FINAL_ATTEMPT
Java Field:  isFinalAttempt
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether the attempt is final.
Added On:  04/02/12
SQL Column:  FUNDING_DATE
Java Field:  fundingDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the funding.
Added On:  01/27/13
SQL Column:  ENTRY_CL
Java Field:  entryCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
References Entry Classifier
Attributes:
Represents the type of selected credit card entering mode.
Added On:  02/15/13
SQL Column:  IS_INTERREGIONAL
Java Field:  isInterregional
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the merchant transaction is interregional.
Added On:  02/15/13
SQL Column:  IS_PREPAID
Java Field:  isPrepaid
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the transaction is prepaid.
Added On:  02/15/13
SQL Column:  INTERCHANGE_RATE_NAME
Java Field:  interchangeRateName
Status:  Active
SQL Type:  varchar(82)
Java Type:  String
Attributes:
Added On:  02/15/13
SQL Column:  INTERCHANGE_PERCENTAGE_FEE4P
Java Field:  interchangePercentageFee4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/15/13
SQL Column:  INTERCHANGE_FEE_AMOUNT4P
Java Field:  interchangeFeeAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The column is calculated using the following formula:

Interchange Percentage Fee 4p + Interchange Flat Fee4p = Interchange Fee Amount4p
Added On:  02/15/13
SQL Column:  INTERCHANGE_FLAT_FEE4P
Java Field:  interchangeFlatFee4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/15/13
SQL Column:  PROCESSOR_FEE_AMOUNT4P
Java Field:  processorFeeAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/15/13
SQL Column:  ASSESSMENTS_FEE_AMOUNT4P
Java Field:  assessmentsFeeAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The total of assessment fees charged by an association for processing/settlement of the transaction. When processing through Paymentech Stratus, this field contains fees that are applied to chargebacks.
Added On:  02/15/13
SQL Column:  PROCESSING_FEE_AMOUNT4P
Java Field:  processingFeeAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/15/13
SQL Column:  PERITEM_FEE_AMOUNT4P
Java Field:  peritemFeeAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/15/13
SQL Column:  PROCESSING_COST_AMOUNT4P
Java Field:  processingCostAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The column is calculated using the following formula:

Interchange Fee Amount4p + Processor Fee Amount4p + Assessments Fee Amount4p = Processing Cost Amount4p
Added On:  03/01/13
SQL Column:  REBILL_ATTEMPT_COUNT
Java Field:  rebillAttemptCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number (count) of attemts of rebill operation.
Added On:  03/02/13
SQL Column:  SETTLEMENT_RECONCILIATION_DATE
Java Field:  settlementReconciliationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the settlement reconciliation for the merchant.
Added On:  04/17/13
SQL Column:  AUTHORIZATION_RECONCILIATION_DATE
Java Field:  authorizationReconciliationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the authorization reconciliation for the merchant.
Added On:  05/10/13
SQL Column:  IS_AVS_ENABLED
Java Field:  isAvsEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether AVS approvement is enabled.
Added On:  08/04/13
SQL Column:  SETTLEMENT_AMOUNT
Java Field:  settlementAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount required for the transaction to be settled.
Added On:  08/04/13
SQL Column:  AUTHORIZATION_CURRENCY_CODE
Java Field:  authorizationCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used for authorization transaction.
Added On:  08/04/13
SQL Column:  SETTLEMENT_CURRENCY_CODE
Java Field:  settlementCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used for settlement transaction.
Added On:  11/14/13
SQL Column:  AGGREGATE_TRANSACTION_CODE
Java Field:  aggregateTransactionCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the aggregate transaction.
Added On:  03/16/14
SQL Column:  FEE_AMOUNT
Java Field:  feeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of fee for the merchant (in dollars).
Added On:  06/26/14
SQL Column:  IS_CHARGEBACK_TRANSACTION
Java Field:  isChargebackTransaction
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the type of financial transaction is chargeback.
Added On:  03/19/15
SQL Column:  PROVIDER_TRANSACTION_CODE
Java Field:  providerTransactionCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Transaction code of the provider.
Added On:  06/09/15
SQL Column:  USER_CODE
Java Field:  userCode
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Code of the user in the system.
Added On:  06/09/15
SQL Column:  ADJUSTMENT_DATE
Java Field:  adjustmentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the financial transaction is adjusted.
Added On:  06/09/15
SQL Column:  ADJUSTMENT_NOTE
Java Field:  adjustmentNote
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Any additional notes related to the adjustment of the transaction within the system.
Added On:  12/16/15
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the portfolio, associated with this record.
Added On:  04/28/17
SQL Column:  SPLIT_MERCHANT_ACCOUNT_CODE
Java Field:  splitMerchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  PROCESSOR_RECONCILIATION_DATE
Java Field:  processorReconciliationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/08/17
SQL Column:  ORIGINAL_TRANSACTION_CODE
Java Field:  originalTransactionCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/23/17
SQL Column:  IS_CSC_ENABLED
Java Field:  isCscEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  12/06/17
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: