Processing Reconciliation Statistics

Added On:  05/16/18 

SQL Table:  IAPP_PROCESSING_RECONCILIATION_STATISTICS 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  ProcessingReconciliationStatistics 

Represents statistics associated with processor reconciliation report.

Available Fields:

• Difference Charge Amount
• Difference Return Amount
• Gateway Chargeback Amount
• Gateway Credit Amount
• Gateway Return Amount
• Gateway Reversal Amount

• Gateway Sale Amount
• Id
• Merchant Account Code
• Portfolio Code
• Processor Chargeback Amount
• Processor Credit Amount

• Processor Name
• Processor Return Amount
• Processor Reversal Amount
• Processor Sale Amount
• Readjustment Charge Amount
• Readjustment Return Amount

• Reconciliation Date
• Reseller Code

Difference Charge Amount

Added On:  09/08/17

SQL Column:  DIFFERENCE_CHARGE_AMOUNT

Java Field:  differenceChargeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Difference Return Amount

Added On:  09/08/17

SQL Column:  DIFFERENCE_RETURN_AMOUNT

Java Field:  differenceReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Chargeback Amount

Added On:  09/08/17

SQL Column:  GATEWAY_CHARGEBACK_AMOUNT

Java Field:  gatewayChargebackAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Credit Amount

Added On:  09/08/17

SQL Column:  GATEWAY_CREDIT_AMOUNT

Java Field:  gatewayCreditAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Return Amount

Added On:  09/08/17

SQL Column:  GATEWAY_RETURN_AMOUNT

Java Field:  gatewayReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Reversal Amount

Added On:  09/08/17

SQL Column:  GATEWAY_REVERSAL_AMOUNT

Java Field:  gatewayReversalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Gateway Sale Amount

Added On:  09/08/17

SQL Column:  GATEWAY_SALE_AMOUNT

Java Field:  gatewaySaleAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Id

Added On:  09/08/17

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required

Unique identifier assigned to the record.

Merchant Account Code

Added On:  09/08/17

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Portfolio Code

Added On:  09/08/17

SQL Column:  PORTFOLIO_CODE

Java Field:  portfolioCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processor Chargeback Amount

Added On:  09/08/17

SQL Column:  PROCESSOR_CHARGEBACK_AMOUNT

Java Field:  processorChargebackAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Credit Amount

Added On:  09/08/17

SQL Column:  PROCESSOR_CREDIT_AMOUNT

Java Field:  processorCreditAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Name

Added On:  09/08/17

SQL Column:  PROCESSOR_NAME

Java Field:  processorName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Processor Return Amount

Added On:  09/08/17

SQL Column:  PROCESSOR_RETURN_AMOUNT

Java Field:  processorReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Reversal Amount

Added On:  09/08/17

SQL Column:  PROCESSOR_REVERSAL_AMOUNT

Java Field:  processorReversalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Sale Amount

Added On:  09/08/17

SQL Column:  PROCESSOR_SALE_AMOUNT

Java Field:  processorSaleAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Readjustment Charge Amount

Added On:  12/21/17

SQL Column:  READJUSTMENT_CHARGE_AMOUNT

Java Field:  readjustmentChargeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Readjustment Return Amount

Added On:  12/21/17

SQL Column:  READJUSTMENT_RETURN_AMOUNT

Java Field:  readjustmentReturnAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Reconciliation Date

Added On:  09/08/17

SQL Column:  RECONCILIATION_DATE

Java Field:  reconciliationDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Reseller Code

Added On:  09/08/17

SQL Column:  RESELLER_CODE

Java Field:  resellerCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes: