Remittance Reconciliation Statistics

Added On:  05/04/18 

SQL Table:  IAPP_REMITTANCE_RECONCILIATION_STATISTICS 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  RemittanceReconciliationStatistics 

Available Fields:

• Activity Date
• Adjustment Amount
• Balance
• Create Date
• Fee Amount Due
• Fee Amount Receivable
• Fee Schema Code
• Id

• Merchant Account Code
• Merchant Charge Amount
• Merchant Statement Code
• Portfilio Code
• Processed Amount
• Processing Cost Amount Due
• Processing Cost Amount Receivable
• Record Cl

• Remittance Amount
• Remitter Code
• Reseller Code
• Reserve Amount
• Split Amount
• Tax Amount Due
• Tax Amount Receivable
• Unremitted Amount

• Withdrawal Amount

Activity Date

Added On:  05/04/18

SQL Column:  ACTIVITY_DATE

Java Field:  activityDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Adjustment Amount

Added On:  05/04/18

SQL Column:  ADJUSTMENT_AMOUNT

Java Field:  adjustmentAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Balance

Added On:  05/04/18

SQL Column:  BALANCE

Java Field:  balance

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Create Date

Added On:  05/04/18

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Fee Amount Due

Added On:  05/04/18

SQL Column:  FEE_AMOUNT_DUE

Java Field:  feeAmountDue

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Fee Amount Receivable

Added On:  05/04/18

SQL Column:  FEE_AMOUNT_RECEIVABLE

Java Field:  feeAmountReceivable

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Fee Schema Code

Added On:  05/04/18

SQL Column:  FEE_SCHEMA_CODE

Java Field:  feeSchemaCode

Status:  Active

SQL Type:  int(11)(2)

Java Type:  Integer

Attributes:

Id

Added On:  05/04/18

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Merchant Account Code

Added On:  05/04/18

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Charge Amount

Added On:  05/04/18

SQL Column:  MERCHANT_CHARGE_AMOUNT

Java Field:  merchantChargeAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Merchant Statement Code

Added On:  05/04/18

SQL Column:  MERCHANT_STATEMENT_CODE

Java Field:  merchantStatementCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Portfilio Code

Added On:  05/04/18

SQL Column:  PORTFILIO_CODE

Java Field:  portfilioCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processed Amount

Added On:  05/04/18

SQL Column:  PROCESSED_AMOUNT

Java Field:  processedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processing Cost Amount Due

Added On:  05/04/18

SQL Column:  PROCESSING_COST_AMOUNT_DUE

Java Field:  processingCostAmountDue

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processing Cost Amount Receivable

Added On:  05/04/18

SQL Column:  PROCESSING_COST_AMOUNT_RECEIVABLE

Java Field:  processingCostAmountReceivable

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Record Cl

Added On:  05/04/18

SQL Column:  RECORD_CL

Java Field:  recordCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  Object

References Remittance Reconciliation Statistics Classifier

Attributes:

Remittance Amount

Added On:  05/04/18

SQL Column:  REMITTANCE_AMOUNT

Java Field:  remittanceAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Remitter Code

Added On:  05/04/18

SQL Column:  REMITTER_CODE

Java Field:  remitterCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Reseller Code

Added On:  05/04/18

SQL Column:  RESELLER_CODE

Java Field:  resellerCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Reserve Amount

Added On:  05/04/18

SQL Column:  RESERVE_AMOUNT

Java Field:  reserveAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Split Amount

Added On:  05/04/18

SQL Column:  SPLIT_AMOUNT

Java Field:  splitAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Tax Amount Due

Added On:  05/04/18

SQL Column:  TAX_AMOUNT_DUE

Java Field:  taxAmountDue

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Tax Amount Receivable

Added On:  05/04/18

SQL Column:  TAX_AMOUNT_RECEIVABLE

Java Field:  taxAmountReceivable

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Unremitted Amount

Added On:  05/04/18

SQL Column:  UNREMITTED_AMOUNT

Java Field:  unremittedAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Withdrawal Amount

Added On:  05/04/18

SQL Column:  WITHDRAWAL_AMOUNT

Java Field:  withdrawalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes: