Statement UML


Added On:  03/16/12 
SQL Table:  IAPP_MERCHANT_STATEMENT 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantStatement 
Merchant statement, compiled based on actual processing volumes and merchant fee details. It shows all the transactions processed for the given merchant during the specified time interval and all the fees deduced. Merchant statement is compiled for every remittance.
Available Fields:
Added On:  03/16/12
SQL Column:  ACH_REMITTANCE_AMOUNT
Java Field:  achRemittanceAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money for this statement that has to be remitted out of the given remittance source (in this case, ACH).
Added On:  03/16/12
SQL Column:  ACH_TRANSACTION_CODE
Java Field:  achTransactionCode
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Reference number of the remittance transaction generated based on respective remittance amount and source (in this case - ACH).
Added On:  03/16/12
SQL Column:  ADJUSTED_AMOUNT
Java Field:  adjustedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount on the statement after adjustments.
If adjusted amount is below the original amount, it means that
1) the money has been withdrawn "manually", or
2) the balance in the previous statement was negative.
If adjusted amount is above the original one, it means that:
1) the money has been added manually, or
2) some former debt has been returned, or
3) the money from reserve has been returned.
Added On:  03/16/14
SQL Column:  ADVANCE_AMOUNT
Java Field:  advanceAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Advance amount of the merchant statement.
Added On:  03/16/12
SQL Column:  AMEX_REMITTANCE_AMOUNT
Java Field:  amexRemittanceAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money for this statement that has to be remitted out of the given remittance source (in this case, American Express).
Added On:  03/16/12
SQL Column:  AMEX_TRANSACTION_CODE
Java Field:  amexTransactionCode
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Reference number of the remittance transaction generated based on respective remittance amount and source (in this case - American Express).
Added On:  03/16/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total remittance amount on the statement before any adjustments.
Added On:  05/04/18
SQL Column:  APPROVAL_DATE
Java Field:  approvalDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  03/16/12
SQL Column:  APPROVER_CODE
Java Field:  approverCode
Status:  Active
SQL Type:  varchar(56)
Java Type:  String
Attributes:
The user name of a person who approved the statement.
Added On:  08/25/16
SQL Column:  ARCHIVING_DATE
Java Field:  archivingDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the statement was archived.
Added On:  11/06/18
SQL Column:  ASSESSMENTS_AMOUNT
Java Field:  assessmentsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  BALANCE
Java Field:  balance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Actual balance on the merchant account for which the statement is generated.
Added On:  12/09/13
SQL Column:  BALANCE_ADJUSTMENTS_AMOUNT
Java Field:  balanceAdjustmentsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the balance adjustment.
Added On:  03/16/12
SQL Column:  BANK_CARD_REMITTANCE_AMOUNT
Java Field:  bankCardRemittanceAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money for this statement that has to be remitted out of the given remittance source (in this case, bank cards).
Added On:  03/16/12
SQL Column:  BANK_CARD_TRANSACTION_CODE
Java Field:  bankCardTransactionCode
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Reference number of the remittance transaction generated based on respective remittance amount and source (in this case - bank cards).
Added On:  02/12/14
SQL Column:  BATCH_DEPOSIT_POLICY
Java Field:  batchDepositPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Indicates whether the batch deposit is enabled or not.
Added On:  09/05/18
SQL Column:  CHARGEBACK_RESERVE_MIN_AMOUNT
Java Field:  chargebackReserveMinAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  12/06/12
SQL Column:  CHARGEBACK_RESERVE_RATE
Java Field:  chargebackReserveRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Current rate for chargeback reserve. Represents a percentage of the approved transactions deposited to the merchant that is held in reserve. See Reserves for more details.
Added On:  09/05/18
SQL Column:  CHARGEBACK_SALE_RESERVE_TOTAL_AMOUNT
Java Field:  chargebackSaleReserveTotalAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/19/15
SQL Column:  CONVENIENCE_FEE_DEDUCTION_AMOUNT
Java Field:  convenienceFeeDeductionAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Deduction amount of convenience fee.
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:  08/28/18
SQL Column:  DEPOSIT_CL
Java Field:  depositCl
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
References Deposit Classifier
Attributes:
Added On:  05/24/18
SQL Column:  DEPOSIT_TYPE
Java Field:  depositType
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: ReadOnly, Calculated
Added On:  12/03/13
SQL Column:  EMAIL_SENT_DATE
Java Field:  emailSentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the email was sent the last time.
Added On:  03/16/12
SQL Column:  END_DATE
Java Field:  endDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
End date of the time period covered by the statement.
Added On:  08/23/13
SQL Column:  EXPORT_DATE
Java Field:  exportDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of export.
Added On:  04/24/15
SQL Column:  FEE_AMOUNT
Java Field:  feeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the merchant's fee.
Added On:  05/04/18
SQL Column:  FEE_AMOUNT_RECEIVABLE
Java Field:  feeAmountReceivable
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  08/31/16
SQL Column:  FEE_SCHEMA_FK
Java Field:  feeSchema
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Fee Schema
Attributes:
Reference to the entity that represents fee schema information.
Added On:  10/25/19
SQL Column:  FEES_RESPONSIBLE_CL
Java Field:  feesResponsibleCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References User Classifier
Attributes:
Added On:  07/10/23
SQL Column:  FUNDING_MODE_CL
Java Field:  fundingModeCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  12/10/13
SQL Column:  HOLD_AMOUNT
Java Field:  holdAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the hold transaction.
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:  11/06/18
SQL Column:  INTERCHANGE_AMOUNT
Java Field:  interchangeAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/27/20
SQL Column:  IS_IGNORE_REMITTANCE_SOURCE
Java Field:  isIgnoreRemittanceSource
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  03/06/13
SQL Column:  IS_PROCESSING_COST_BATCH_ACH_ENABLED
Java Field:  isProcessingCostBatchAchEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the processing cost for ACH batch transactions is included in the statement.
Added On:  03/06/13
SQL Column:  IS_PROCESSING_COST_BATCH_AMEX_ENABLED
Java Field:  isProcessingCostBatchAmexEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the processing cost for Amex batch transactions is included in the statement.
Added On:  02/25/13
SQL Column:  IS_PROCESSING_COST_BATCH_CARDS_ENABLED
Java Field:  isProcessingCostBatchCardsEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the processing cost for batch bank card (Visa, MasterCard, Discover) transactions is included in the statement.
Added On:  03/06/13
SQL Column:  IS_PROCESSING_COST_REALTIME_ACH_ENABLED
Java Field:  isProcessingCostRealtimeAchEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the processing cost for ACH real-time transactions is included in the statement.
Added On:  03/06/13
SQL Column:  IS_PROCESSING_COST_REALTIME_AMEX_ENABLED
Java Field:  isProcessingCostRealtimeAmexEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the processing cost for Amex real-time transactions is included in the statement.
Added On:  02/25/13
SQL Column:  IS_PROCESSING_COST_REALTIME_CARDS_ENABLED
Java Field:  isProcessingCostRealtimeCardsEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the processing cost for real-time bank card (Visa, MasterCard, Discover) transactions is included in the statement.
Added On:  01/29/14
SQL Column:  IS_REATTEMPT_WITHDRAWAL
Java Field:  isReattemptWithdrawal
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates, that this is the second subsequent attempt to withdraw funds from merchant's deposit account.
Added On:  12/06/12
SQL Column:  LAST_CHARGEBACK_RESERVE_COLLECTED_AMOUNT
Java Field:  lastChargebackReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount held in chargeback reserve as of the previous statement. See Reserves for details.
Added On:  12/06/12
SQL Column:  LAST_REFUND_RESERVE_REQUESTED_AMOUNT
Java Field:  lastRefundReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money required to be held in refund reserve as of the previous statement. See Reserves for details.
Added On:  12/06/12
SQL Column:  LAST_RETURN_RESERVE_COLLECTED_AMOUNT
Java Field:  lastReturnReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount held in return reserve as of the previous statement. See Reserves for details.
Added On:  03/16/12
SQL Column:  MANUAL_ADJUSTMENTS_AMOUNT
Java Field:  manualAdjustmentsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The total amount of manual adjustments, introduced into the statement.
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:  08/31/16
SQL Column:  MERCHANT_ACCOUNT_GROUP_FK
Java Field:  merchantAccountGroup
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents merchant account group information.
Added On:  05/04/18
SQL Column:  MERCHANT_CHARGE_AMOUNT
Java Field:  merchantChargeAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  08/31/16
SQL Column:  MERCHANT_CYCLE_DETAIL_FK
Java Field:  merchantCycleDetail
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents merchant cycle details information.
Added On:  03/26/12
SQL Column:  MERCHANT_DEPOSIT_DATE
Java Field:  merchantDepositDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the money is expected to hit (be deposited to) the merchant's bank account.
Added On:  08/31/16
SQL Column:  MERCHANT_FEE_FK
Java Field:  merchantFee
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Merchant Fee
Attributes:
Reference to the entity that represents merchant fee information.
Added On:  08/28/18
SQL Column:  MERCHANT_STATEMENT_ACTIVITY_FK
Java Field:  merchantStatementActivity
Status:  Active
SQL Type:  bigint(20)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  NEXT_CHARGEBACK_RESERVE_COLLECTED_AMOUNT
Java Field:  nextChargebackReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount held in chargeback reserve in the current statement. See Reserves for details.
Added On:  12/06/12
SQL Column:  NEXT_CHARGEBACK_RESERVE_REQUESTED_AMOUNT
Java Field:  nextChargebackReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Required chargeback reserve amount as of current statement. See Reserves for details.
Added On:  02/19/15
SQL Column:  NEXT_CONVENIENCE_FEE_AMOUNT
Java Field:  nextConvenienceFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the next convenience fee of the merchant.
Added On:  10/29/13
SQL Column:  NEXT_FEE_BALANCE
Java Field:  nextFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Next fee balance.
Added On:  05/04/18
SQL Column:  NEXT_NET_BALANCE
Java Field:  nextNetBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  NEXT_PROCESSING_COST_BALANCE
Java Field:  nextProcessingCostBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  NEXT_REFUND_RESERVE_COLLECTED_AMOUNT
Java Field:  nextRefundReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount held in refund reserve in the current statement. See Reserves for details.
Added On:  12/06/12
SQL Column:  NEXT_REFUND_RESERVE_REQUESTED_AMOUNT
Java Field:  nextRefundReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Money available in the refund reserve after the current statement is approved and necessary funds are withdrawn from
the statement into the refund reserve. See Reserves for details.
Added On:  05/04/18
SQL Column:  NEXT_RETURN_FEE_BALANCE
Java Field:  nextReturnFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  NEXT_RETURN_PROCESSING_COST_BALANCE
Java Field:  nextReturnProcessingCostBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  NEXT_RETURN_RESERVE_COLLECTED_AMOUNT
Java Field:  nextReturnReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount held in return reserve in the current statement. See Reserves for details.
Added On:  12/06/12
SQL Column:  NEXT_RETURN_RESERVE_REQUESTED_AMOUNT
Java Field:  nextReturnReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Required return reserve amount as of current statement. See Reserves for details.
Added On:  05/04/18
SQL Column:  NEXT_RETURN_TAX_BALANCE
Java Field:  nextReturnTaxBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/26/18
SQL Column:  NEXT_TAX_BALANCE
Java Field:  nextTaxBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  NOTE
Java Field:  note
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Any additional information about the statement.
Added On:  09/23/13
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Portfolio that this group belongs to.
Added On:  02/22/18
SQL Column:  PORTFOLIO_EXPORT_DATE
Java Field:  portfolioExportDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  06/24/16
SQL Column:  PREV_BALANCE
Java Field:  prevBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Balance that was on the merchant account at the moment of previous statement generation.
Added On:  11/05/19
SQL Column:  PREV_BANK_CARD_BALANCE
Java Field:  prevBankCardBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_BANK_CARD_FEE_BALANCE
Java Field:  prevBankCardFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_BANK_CARD_NET_BALANCE
Java Field:  prevBankCardNetBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_BANK_CARD_REATTEMPT_RETURNS_BALANCE
Java Field:  prevBankCardReattemptReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_BANK_CARD_RETURNS_BALANCE
Java Field:  prevBankCardReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  06/23/16
SQL Column:  PREV_CHARGEBACK_RESERVE_COLLECTED_AMOUNT
Java Field:  prevChargebackReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount held in chargeback reserve according to previous statement. See Reserves for details.
Added On:  02/19/15
SQL Column:  PREV_CONVENIENCE_FEE_AMOUNT
Java Field:  prevConvenienceFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the previous convenience fee of the merchant.
Added On:  08/31/23
SQL Column:  PREV_DEPOSIT_STATEMENT_DATE
Java Field:  prevDepositStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  11/05/19
SQL Column:  PREV_DIRECT_DEBIT_BALANCE
Java Field:  prevDirectDebitBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_DIRECT_DEBIT_FEE_BALANCE
Java Field:  prevDirectDebitFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_DIRECT_DEBIT_NET_BALANCE
Java Field:  prevDirectDebitNetBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE
Java Field:  prevDirectDebitReattemptReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/05/19
SQL Column:  PREV_DIRECT_DEBIT_RETURNS_BALANCE
Java Field:  prevDirectDebitReturnsBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/29/13
SQL Column:  PREV_FEE_BALANCE
Java Field:  prevFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Previous fee balance.
Added On:  06/24/16
SQL Column:  PREV_NET_BALANCE
Java Field:  prevNetBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  05/04/18
SQL Column:  PREV_PROCESSING_COST_BALANCE
Java Field:  prevProcessingCostBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  06/24/16
SQL Column:  PREV_REATTEMPT_RETURNS_BALANCE
Java Field:  prevReattemptReturnsBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of reattempted ACH returns, chargebacks and reversals, that were included in previuos statement.
Added On:  06/23/16
SQL Column:  PREV_REFUND_RESERVE_COLLECTED_AMOUNT
Java Field:  prevRefundReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money required being held in refund reserve as of the previous statement. See Reserves for details.
Added On:  08/31/23
SQL Column:  PREV_REMITTANCE_DATE
Java Field:  prevRemittanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  05/04/18
SQL Column:  PREV_RETURN_FEE_BALANCE
Java Field:  prevReturnFeeBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  PREV_RETURN_PROCESSING_COST_BALANCE
Java Field:  prevReturnProcessingCostBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  06/23/16
SQL Column:  PREV_RETURN_RESERVE_COLLECTED_AMOUNT
Java Field:  prevReturnReserveCollectedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount held in return reserve according to previous statement. See Reserves for details.
Added On:  05/04/18
SQL Column:  PREV_RETURN_TAX_BALANCE
Java Field:  prevReturnTaxBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  06/24/16
SQL Column:  PREV_RETURNS_BALANCE
Java Field:  prevReturnsBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of ACH returns, chargebacks and reversals, that were included in previous statement.
Added On:  12/09/13
SQL Column:  PREV_STATEMENT_BALANCE
Java Field:  prevStatementBalance
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Previous statement balance of the selected merchant account.
Added On:  08/31/23
SQL Column:  PREV_STATEMENT_DATE
Java Field:  prevStatementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  03/26/18
SQL Column:  PREV_TAX_BALANCE
Java Field:  prevTaxBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  PROCESSED_AMOUNT
Java Field:  processedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  PROCESSING_COST_AMOUNT
Java Field:  processingCostAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  PROCESSING_COST_AMOUNT_RECEIVABLE
Java Field:  processingCostAmountReceivable
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  02/12/14
SQL Column:  REALTIME_DEPOSIT_POLICY
Java Field:  realtimeDepositPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Indicates whether a realtime deposit is enabled or not.
Added On:  02/10/16
SQL Column:  RECONCILIATION_STATE_CL
Java Field:  reconciliationStateCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of current reconciliation state.
Added On:  02/10/16
SQL Column:  RECONCILIATOR_CODE
Java Field:  reconciliatorCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Reconciliator code.
Added On:  12/06/12
SQL Column:  REFUND_RESERVE_REQUESTED_AMOUNT
Java Field:  refundReserveRequestedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of money required to be held in refund reserve as of the current statement. See Reserves for details.
Added On:  01/10/14
SQL Column:  REMITTANCE_CURRENCY_CODE
Java Field:  remittanceCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used for the remittance transaction.
Added On:  06/20/15
SQL Column:  REMITTANCE_INFO
Java Field:  remittanceInfo
Status:  Active
SQL Type:  varchar(500)
Java Type:  String
Attributes:
Remittance transaction information.
Added On:  03/02/13
SQL Column:  REMITTANCE_TRANSACTION_CL
Java Field:  remittanceTransactionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the way, in which money was remitted.
Added On:  03/16/12
SQL Column:  REMITTED_AMOUNT
Java Field:  remittedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Actual amount that was remitted to the merchant.
Added On:  03/16/12
SQL Column:  REMITTER_CODE
Java Field:  remitterCode
Status:  Active
SQL Type:  varchar(56)
Java Type:  String
Attributes:
The user name of a person who remits the money under manual (non-automated) remittance.
Added On:  05/04/18
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  RESERVE_ADJUSTMENTS_AMOUNT
Java Field:  reserveAdjustmentsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Net amount of reserve-related adjustments, associated with the statement.
Added On:  09/05/18
SQL Column:  RETURN_RESERVE_MIN_AMOUNT
Java Field:  returnReserveMinAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  12/06/12
SQL Column:  RETURN_RESERVE_RATE
Java Field:  returnReserveRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Current rate for return reserve. Represents a percentage of the approved transactions deposited to the merchant that is held in reserve. See Reserves for more details.
Added On:  09/05/18
SQL Column:  RETURN_SALE_RESERVE_TOTAL_AMOUNT
Java Field:  returnSaleReserveTotalAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  RETURNS_AMOUNT
Java Field:  returnsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total amount of ACH returns, chargebacks and reversals, that are included in the statement.
Added On:  03/19/15
SQL Column:  REVIEW_POLICY
Java Field:  reviewPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Indicates whether statement review is enabled or not.
Added On:  05/31/17
SQL Column:  SPLIT_ADJUSTED_AMOUNT
Java Field:  splitAdjustedAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Transient
Amount that is included in the split adjustment.
Added On:  05/04/18
SQL Column:  SPLIT_AMOUNT
Java Field:  splitAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  03/16/12
SQL Column:  START_DATE
Java Field:  startDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Start date of the time period covered in the statement.
Added On:  03/16/12
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents current status of the statement.
Added On:  03/26/18
SQL Column:  TAX_AMOUNT
Java Field:  taxAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/04/18
SQL Column:  TAX_AMOUNT_RECEIVABLE
Java Field:  taxAmountReceivable
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/31/17
SQL Column:  UNPROCESSED_SPLIT_COUNT
Java Field:  unprocessedSplitCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Transient
Number of splits that were not processed.
Added On:  12/10/13
SQL Column:  WRITEOFFS_AMOUNT
Java Field:  writeoffsAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the write-offs transactions.