Merchant Processing Statistics UML

Added On:  02/15/23 

SQL Table:  MERCHANT_PROCESSING_STATISTICS 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  MerchantProcessingStatistics 

Available Fields:

• Activity Date
• Agent Code
• Agent Commissions Rate
• Agent Platform Fee Rate
• Authorization Currency Code
• Batch Deposit Policy
• Buy Rate Amount
• Buy Rate Handling Mode Cl
• Create Date
• Fees Responsible Cl
• Franchise Fee Amount
• Gateway Activity Amount
• Gateway Activity Count
• Gateway Adjustment Amount
• Gateway Agent Merchant Charge Amount
• Gateway Assessment Cost Amount
• Gateway Chargeback Reserve Amount
• Gateway Commissions Adjustment Amount
• Gateway Convenience Fee Adjustment Amount
• Gateway Fee Adjustment Amount
• Gateway Flat Commissionable Amount
• Gateway Flat Commissions Amount
• Gateway Flat Fee Amount
• Gateway Interchange Cost Amount
• Gateway Merchant Charge Amount
• Gateway Merchant Charges Amount
• Gateway Merchant Cost Amount
• Gateway Payment Aggregated Amount
• Gateway Payment Aggregated Count
• Gateway Payment Amount
• Gateway Payment Blacklist Amount
• Gateway Payment Blacklist Count
• Gateway Payment Chargeback Aggregated Amount
• Gateway Payment Chargeback Aggregated Count
• Gateway Payment Chargeback Amount
• Gateway Payment Chargeback Count
• Gateway Payment Count
• Gateway Payment Decline Amount
• Gateway Payment Decline Count

• Gateway Payment Error Amount
• Gateway Payment Error Count
• Gateway Payment Reject Amount
• Gateway Payment Return Aggregated Amount
• Gateway Payment Return Aggregated Count
• Gateway Payment Return Amount
• Gateway Payment Return Count
• Gateway Payment Reversal Aggregated Amount
• Gateway Payment Reversal Aggregated Count
• Gateway Payment Reversal Amount
• Gateway Payment Reversal Count
• Gateway Payment Void Amount
• Gateway Payment Void Count
• Gateway Processing Commissionable Amount
• Gateway Processing Commissions Amount
• Gateway Processing Fee Amount
• Gateway Processor Cost Amount
• Gateway Processor Tax Amount
• Gateway Recurring Commissionable Amount
• Gateway Recurring Commissions Amount
• Gateway Recurring Fee Amount
• Gateway Refund Aggregated Amount
• Gateway Refund Aggregated Count
• Gateway Refund Amount
• Gateway Refund Blacklist Amount
• Gateway Refund Blacklist Count
• Gateway Refund Chargeback Aggregated Amount
• Gateway Refund Chargeback Aggregated Count
• Gateway Refund Chargeback Amount
• Gateway Refund Chargeback Count
• Gateway Refund Count
• Gateway Refund Decline Amount
• Gateway Refund Decline Count
• Gateway Refund Error Amount
• Gateway Refund Error Count
• Gateway Refund Reject Amount
• Gateway Refund Reserve Amount
• Gateway Refund Return Aggregated Amount
• Gateway Refund Return Aggregated Count

• Gateway Refund Return Amount
• Gateway Refund Return Count
• Gateway Refund Reversal Aggregated Amount
• Gateway Refund Reversal Aggregated Count
• Gateway Refund Reversal Amount
• Gateway Refund Reversal Count
• Gateway Refund Void Amount
• Gateway Refund Void Count
• Gateway Remittance Return Amount
• Gateway Return Reserve Amount
• Gateway Split Amount
• Gateway Tax Amount
• Id
• Master Reseller Statement Code
• Merchant Account Code
• Merchant Account Group Code
• Merchant Processing Statistics Details
• Merchant Processing Statistics Fee Details
• Merchant Statement Code
• Portfolio Code
• Processing Cost Cl
• Processor Activity Amount
• Processor Activity Count
• Processor Chargeback Amount
• Processor Chargeback Count
• Processor Fee Amount
• Processor Identity
• Processor Name
• Processor Return Amount
• Processor Return Count
• Processor Reversal Amount
• Processor Reversal Count
• Realtime Deposit Policy
• Reconciliation Date
• Remittance Date
• Reseller Code
• Reseller Commissions Rate
• Reseller Platform Fee Rate
• Settlement Currency Code

• Submission Cl
• Submission Code

Activity Date

Added On:  02/15/23

SQL Column:  ACTIVITY_DATE

Java Field:  activityDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Agent Code

Added On:  05/13/24

SQL Column:  AGENT_CODE

Java Field:  agentCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Agent Commissions Rate

Added On:  05/13/24

SQL Column:  AGENT_COMMISSIONS_RATE

Java Field:  agentCommissionsRate

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Agent Platform Fee Rate

Added On:  05/13/24

SQL Column:  AGENT_PLATFORM_FEE_RATE

Java Field:  agentPlatformFeeRate

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Authorization Currency Code

Added On:  02/15/23

SQL Column:  AUTHORIZATION_CURRENCY_CODE

Java Field:  authorizationCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Batch Deposit Policy

Added On:  02/15/23

SQL Column:  BATCH_DEPOSIT_POLICY

Java Field:  batchDepositPolicy

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Buy Rate Amount

Added On:  05/22/24

SQL Column:  BUY_RATE_AMOUNT

Java Field:  buyRateAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Buy Rate Handling Mode Cl

Added On:  05/22/24

SQL Column:  BUY_RATE_HANDLING_MODE_CL

Java Field:  buyRateHandlingModeCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Buy Rate Handling Mode Classifier

Attributes:

Create Date

Added On:  02/15/23

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Fees Responsible Cl

Added On:  02/15/23

SQL Column:  FEES_RESPONSIBLE_CL

Java Field:  feesResponsibleCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References User Classifier

Attributes:

Franchise Fee Amount

Added On:  07/07/23

SQL Column:  FRANCHISE_FEE_AMOUNT

Java Field:  franchiseFeeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Activity Amount

Added On:  02/15/23

SQL Column:  GATEWAY_ACTIVITY_AMOUNT

Java Field:  gatewayActivityAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Activity Count

Added On:  02/15/23

SQL Column:  GATEWAY_ACTIVITY_COUNT

Java Field:  gatewayActivityCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Adjustment Amount

Added On:  02/15/23

SQL Column:  GATEWAY_ADJUSTMENT_AMOUNT

Java Field:  gatewayAdjustmentAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Agent Merchant Charge Amount

Added On:  05/13/24

SQL Column:  GATEWAY_AGENT_MERCHANT_CHARGE_AMOUNT

Java Field:  gatewayAgentMerchantChargeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Assessment Cost Amount

Added On:  02/15/23

SQL Column:  GATEWAY_ASSESSMENT_COST_AMOUNT

Java Field:  gatewayAssessmentCostAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Chargeback Reserve Amount

Added On:  02/15/23

SQL Column:  GATEWAY_CHARGEBACK_RESERVE_AMOUNT

Java Field:  gatewayChargebackReserveAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Commissions Adjustment Amount

Added On:  02/15/23

SQL Column:  GATEWAY_COMMISSIONS_ADJUSTMENT_AMOUNT

Java Field:  gatewayCommissionsAdjustmentAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Convenience Fee Adjustment Amount

Added On:  02/15/23

SQL Column:  GATEWAY_CONVENIENCE_FEE_ADJUSTMENT_AMOUNT

Java Field:  gatewayConvenienceFeeAdjustmentAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Fee Adjustment Amount

Added On:  02/15/23

SQL Column:  GATEWAY_FEE_ADJUSTMENT_AMOUNT

Java Field:  gatewayFeeAdjustmentAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Flat Commissionable Amount

Added On:  05/13/24

SQL Column:  GATEWAY_FLAT_COMMISSIONABLE_AMOUNT

Java Field:  gatewayFlatCommissionableAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Flat Commissions Amount

Added On:  02/15/23

SQL Column:  GATEWAY_FLAT_COMMISSIONS_AMOUNT

Java Field:  gatewayFlatCommissionsAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Flat Fee Amount

Added On:  02/15/23

SQL Column:  GATEWAY_FLAT_FEE_AMOUNT

Java Field:  gatewayFlatFeeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Interchange Cost Amount

Added On:  02/15/23

SQL Column:  GATEWAY_INTERCHANGE_COST_AMOUNT

Java Field:  gatewayInterchangeCostAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Merchant Charge Amount

Added On:  02/15/23

SQL Column:  GATEWAY_MERCHANT_CHARGE_AMOUNT

Java Field:  gatewayMerchantChargeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Merchant Charges Amount

Added On:  02/15/23

SQL Column:  GATEWAY_MERCHANT_CHARGES_AMOUNT

Java Field:  gatewayMerchantChargesAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Merchant Cost Amount

Added On:  02/15/23

SQL Column:  GATEWAY_MERCHANT_COST_AMOUNT

Java Field:  gatewayMerchantCostAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_AGGREGATED_AMOUNT

Java Field:  gatewayPaymentAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_AGGREGATED_COUNT

Java Field:  gatewayPaymentAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_AMOUNT

Java Field:  gatewayPaymentAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Blacklist Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_BLACKLIST_AMOUNT

Java Field:  gatewayPaymentBlacklistAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Blacklist Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_BLACKLIST_COUNT

Java Field:  gatewayPaymentBlacklistCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Chargeback Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_CHARGEBACK_AGGREGATED_AMOUNT

Java Field:  gatewayPaymentChargebackAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Chargeback Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_CHARGEBACK_AGGREGATED_COUNT

Java Field:  gatewayPaymentChargebackAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Chargeback Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_CHARGEBACK_AMOUNT

Java Field:  gatewayPaymentChargebackAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Chargeback Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_CHARGEBACK_COUNT

Java Field:  gatewayPaymentChargebackCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_COUNT

Java Field:  gatewayPaymentCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Decline Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_DECLINE_AMOUNT

Java Field:  gatewayPaymentDeclineAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Decline Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_DECLINE_COUNT

Java Field:  gatewayPaymentDeclineCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Error Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_ERROR_AMOUNT

Java Field:  gatewayPaymentErrorAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Error Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_ERROR_COUNT

Java Field:  gatewayPaymentErrorCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Reject Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_REJECT_AMOUNT

Java Field:  gatewayPaymentRejectAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Return Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_RETURN_AGGREGATED_AMOUNT

Java Field:  gatewayPaymentReturnAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Return Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_RETURN_AGGREGATED_COUNT

Java Field:  gatewayPaymentReturnAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Return Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_RETURN_AMOUNT

Java Field:  gatewayPaymentReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Return Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_RETURN_COUNT

Java Field:  gatewayPaymentReturnCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Reversal Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_REVERSAL_AGGREGATED_AMOUNT

Java Field:  gatewayPaymentReversalAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Reversal Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_REVERSAL_AGGREGATED_COUNT

Java Field:  gatewayPaymentReversalAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Reversal Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_REVERSAL_AMOUNT

Java Field:  gatewayPaymentReversalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Reversal Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_REVERSAL_COUNT

Java Field:  gatewayPaymentReversalCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Payment Void Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_VOID_AMOUNT

Java Field:  gatewayPaymentVoidAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Payment Void Count

Added On:  02/15/23

SQL Column:  GATEWAY_PAYMENT_VOID_COUNT

Java Field:  gatewayPaymentVoidCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Processing Commissionable Amount

Added On:  05/13/24

SQL Column:  GATEWAY_PROCESSING_COMMISSIONABLE_AMOUNT

Java Field:  gatewayProcessingCommissionableAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Processing Commissions Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PROCESSING_COMMISSIONS_AMOUNT

Java Field:  gatewayProcessingCommissionsAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Processing Fee Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PROCESSING_FEE_AMOUNT

Java Field:  gatewayProcessingFeeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Processor Cost Amount

Added On:  02/15/23

SQL Column:  GATEWAY_PROCESSOR_COST_AMOUNT

Java Field:  gatewayProcessorCostAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Processor Tax Amount

Added On:  11/22/23

SQL Column:  GATEWAY_PROCESSOR_TAX_AMOUNT

Java Field:  gatewayProcessorTaxAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Amount (in cents) of the Processor Tax.

Gateway Recurring Commissionable Amount

Added On:  05/13/24

SQL Column:  GATEWAY_RECURRING_COMMISSIONABLE_AMOUNT

Java Field:  gatewayRecurringCommissionableAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Recurring Commissions Amount

Added On:  02/15/23

SQL Column:  GATEWAY_RECURRING_COMMISSIONS_AMOUNT

Java Field:  gatewayRecurringCommissionsAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Recurring Fee Amount

Added On:  02/15/23

SQL Column:  GATEWAY_RECURRING_FEE_AMOUNT

Java Field:  gatewayRecurringFeeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_AGGREGATED_AMOUNT

Java Field:  gatewayRefundAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_AGGREGATED_COUNT

Java Field:  gatewayRefundAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_AMOUNT

Java Field:  gatewayRefundAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Blacklist Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_BLACKLIST_AMOUNT

Java Field:  gatewayRefundBlacklistAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Blacklist Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_BLACKLIST_COUNT

Java Field:  gatewayRefundBlacklistCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Chargeback Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_CHARGEBACK_AGGREGATED_AMOUNT

Java Field:  gatewayRefundChargebackAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Chargeback Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_CHARGEBACK_AGGREGATED_COUNT

Java Field:  gatewayRefundChargebackAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Chargeback Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_CHARGEBACK_AMOUNT

Java Field:  gatewayRefundChargebackAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Chargeback Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_CHARGEBACK_COUNT

Java Field:  gatewayRefundChargebackCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_COUNT

Java Field:  gatewayRefundCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Decline Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_DECLINE_AMOUNT

Java Field:  gatewayRefundDeclineAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Decline Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_DECLINE_COUNT

Java Field:  gatewayRefundDeclineCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Error Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_ERROR_AMOUNT

Java Field:  gatewayRefundErrorAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Error Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_ERROR_COUNT

Java Field:  gatewayRefundErrorCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Reject Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_REJECT_AMOUNT

Java Field:  gatewayRefundRejectAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Reserve Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_RESERVE_AMOUNT

Java Field:  gatewayRefundReserveAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Return Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_RETURN_AGGREGATED_AMOUNT

Java Field:  gatewayRefundReturnAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Return Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_RETURN_AGGREGATED_COUNT

Java Field:  gatewayRefundReturnAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Return Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_RETURN_AMOUNT

Java Field:  gatewayRefundReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Return Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_RETURN_COUNT

Java Field:  gatewayRefundReturnCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Reversal Aggregated Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_REVERSAL_AGGREGATED_AMOUNT

Java Field:  gatewayRefundReversalAggregatedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Reversal Aggregated Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_REVERSAL_AGGREGATED_COUNT

Java Field:  gatewayRefundReversalAggregatedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Reversal Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_REVERSAL_AMOUNT

Java Field:  gatewayRefundReversalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Reversal Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_REVERSAL_COUNT

Java Field:  gatewayRefundReversalCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Refund Void Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_VOID_AMOUNT

Java Field:  gatewayRefundVoidAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Refund Void Count

Added On:  02/15/23

SQL Column:  GATEWAY_REFUND_VOID_COUNT

Java Field:  gatewayRefundVoidCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Gateway Remittance Return Amount

Added On:  02/15/23

SQL Column:  GATEWAY_REMITTANCE_RETURN_AMOUNT

Java Field:  gatewayRemittanceReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Return Reserve Amount

Added On:  02/15/23

SQL Column:  GATEWAY_RETURN_RESERVE_AMOUNT

Java Field:  gatewayReturnReserveAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Split Amount

Added On:  02/15/23

SQL Column:  GATEWAY_SPLIT_AMOUNT

Java Field:  gatewaySplitAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Tax Amount

Added On:  11/22/23

SQL Column:  GATEWAY_TAX_AMOUNT

Java Field:  gatewayTaxAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Amount (in cents) of the Tax.

Id

Added On:  02/15/23

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Master Reseller Statement Code

Added On:  02/15/23

SQL Column:  MASTER_RESELLER_STATEMENT_CODE

Java Field:  masterResellerStatementCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Merchant Account Code

Added On:  02/15/23

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Account Group Code

Added On:  02/15/23

SQL Column:  MERCHANT_ACCOUNT_GROUP_CODE

Java Field:  merchantAccountGroupCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Merchant Processing Statistics Details

Added On:  02/15/23

SQL Column:  MERCHANT_PROCESSING_STATISTICS_DETAILS_FK

Java Field:  merchantProcessingStatisticsDetails

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Merchant Processing Statistics Detail

Attributes:

Merchant Processing Statistics Fee Details

Added On:  02/15/23

SQL Column:  MERCHANT_PROCESSING_STATISTICS_FEE_DETAILS_FK

Java Field:  merchantProcessingStatisticsFeeDetails

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Merchant Processing Statistics Fee Detail

Attributes:

Merchant Statement Code

Added On:  02/15/23

SQL Column:  MERCHANT_STATEMENT_CODE

Java Field:  merchantStatementCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Portfolio Code

Added On:  02/15/23

SQL Column:  PORTFOLIO_CODE

Java Field:  portfolioCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processing Cost Cl

Added On:  05/22/24

SQL Column:  PROCESSING_COST_CL

Java Field:  processingCostCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Processing Cost Classifier

Attributes:

Processor Activity Amount

Added On:  02/15/23

SQL Column:  PROCESSOR_ACTIVITY_AMOUNT

Java Field:  processorActivityAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Activity Count

Added On:  02/15/23

SQL Column:  PROCESSOR_ACTIVITY_COUNT

Java Field:  processorActivityCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processor Chargeback Amount

Added On:  02/15/23

SQL Column:  PROCESSOR_CHARGEBACK_AMOUNT

Java Field:  processorChargebackAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Chargeback Count

Added On:  02/15/23

SQL Column:  PROCESSOR_CHARGEBACK_COUNT

Java Field:  processorChargebackCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processor Fee Amount

Added On:  02/15/23

SQL Column:  PROCESSOR_FEE_AMOUNT

Java Field:  processorFeeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Identity

Added On:  02/15/23

SQL Column:  PROCESSOR_IDENTITY

Java Field:  processorIdentity

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Processor Name

Added On:  02/15/23

SQL Column:  PROCESSOR_NAME

Java Field:  processorName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Processor Return Amount

Added On:  02/15/23

SQL Column:  PROCESSOR_RETURN_AMOUNT

Java Field:  processorReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Return Count

Added On:  02/15/23

SQL Column:  PROCESSOR_RETURN_COUNT

Java Field:  processorReturnCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processor Reversal Amount

Added On:  02/15/23

SQL Column:  PROCESSOR_REVERSAL_AMOUNT

Java Field:  processorReversalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Reversal Count

Added On:  02/15/23

SQL Column:  PROCESSOR_REVERSAL_COUNT

Java Field:  processorReversalCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Realtime Deposit Policy

Added On:  02/15/23

SQL Column:  REALTIME_DEPOSIT_POLICY

Java Field:  realtimeDepositPolicy

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Reconciliation Date

Added On:  02/15/23

SQL Column:  RECONCILIATION_DATE

Java Field:  reconciliationDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Remittance Date

Added On:  02/15/23

SQL Column:  REMITTANCE_DATE

Java Field:  remittanceDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Reseller Code

Added On:  02/15/23

SQL Column:  RESELLER_CODE

Java Field:  resellerCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Reseller Commissions Rate

Added On:  05/13/24

SQL Column:  RESELLER_COMMISSIONS_RATE

Java Field:  resellerCommissionsRate

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Reseller Platform Fee Rate

Added On:  05/13/24

SQL Column:  RESELLER_PLATFORM_FEE_RATE

Java Field:  resellerPlatformFeeRate

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Settlement Currency Code

Added On:  02/15/23

SQL Column:  SETTLEMENT_CURRENCY_CODE

Java Field:  settlementCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Submission Cl

Added On:  02/15/23

SQL Column:  SUBMISSION_CL

Java Field:  submissionCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Submission Classifier

Attributes:

Submission Code

Added On:  02/15/23

SQL Column:  SUBMISSION_CODE

Java Field:  submissionCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes: