Merchant Statement Extended UML

Added On: 05/21/19

SQL Table: MERCHANT_STATEMENT_EXTENDED

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantStatementExtended

Available Fields:

Account Type
Adjustments Amount
Bank Account Number Masked
Bank Routing Number Masked
Batch Deposit Policy
Capture Currency Code
Charges Amount
Content
Create Date
Deposit Cl
Deposit Date
Deposit Type
Direct Debit Blacklists Amount
Direct Debit Declines Amount
Direct Debit Errors Amount
Direct Debit Net Amount
Direct Debit Returns Amount
Direct Debit Submitted Amount
Direct Debit Voids Amount
End Date
Funding Mode Cl
Gross Amount
Id
Is Ignore Remittance Source
Is Statement Empty

Is Visible
Merchant Account Code
Payment Card Blacklists Amount
Payment Card Chargebacks Amount
Payment Card Declines Amount
Payment Card Errors Amount
Payment Card Net Amount
Payment Card Reversals Amount
Payment Card Submissions Amount
Payment Card Voids Amount
Processing Cost Amount
Profile Name
Provider Merchant Id
Provider Statement Id
Pull Ins Amount
Pull Outs Amount
Realtime Deposit Policy
Reconciliation Statement Fk
Record Content
Remitted Amount
Reserves Chargebacks Collected Amount
Reserves Chargebacks Current Balance
Reserves Chargebacks Min Amount
Reserves Chargebacks Previous Balance
Reserves Chargebacks Rate

Reserves Chargebacks Required Balance
Reserves Direct Debit Net Sales Amount
Reserves Payment Card Net Sales Amount
Reserves Refunds Collected Amount
Reserves Refunds Current Balance
Reserves Refunds Max Amount
Reserves Refunds Previous Balance
Reserves Returns Collected Amount
Reserves Returns Current Balance
Reserves Returns Min Amount
Reserves Returns Previous Balance
Reserves Returns Rate
Reserves Returns Required Balance
Source Cl
Spits Direct Debit Net Amount
Spits Payment Card Net Amount
Split Ins Amount
Split Outs Amount
Start Date
Statement Cl
Statement Code
Status Cl
Surcharge Fee Amount
Tax Amount
Total Collected Amount

Account Type

Added On: 01/31/19

SQL Column: ACCOUNT_TYPE

Java Field: accountType

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Calculated

Adjustments Amount

Added On: 11/06/18

SQL Column: ADJUSTMENTS_AMOUNT

Java Field: adjustmentsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Bank Account Number Masked

Added On: 11/06/18

SQL Column: BANK_ACCOUNT_NUMBER_MASKED

Java Field: bankAccountNumberMasked

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Bank Routing Number Masked

Added On: 11/06/18

SQL Column: BANK_ROUTING_NUMBER_MASKED

Java Field: bankRoutingNumberMasked

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Batch Deposit Policy

Added On: 12/13/20

SQL Column: BATCH_DEPOSIT_POLICY

Java Field: batchDepositPolicy

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Pattern:

Capture Currency Code

Added On: 11/06/18

SQL Column: CAPTURE_CURRENCY_CODE

Java Field: captureCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Charges Amount

Added On: 11/06/18

SQL Column: CHARGES_AMOUNT

Java Field: chargesAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Content

Added On: 09/21/18

SQL Column: CONTENT_FK

Java Field: content

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Merchant Statement Extended Content

Attributes:

Create Date

Added On: 09/21/18

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created.

Deposit Cl

Added On: 09/21/18

SQL Column: DEPOSIT_CL

Java Field: depositCl

Status: Active

SQL Type: varchar(3)

Java Type: String

References Deposit Classifier

Attributes:

Deposit Date

Added On: 11/06/18

SQL Column: DEPOSIT_DATE

Java Field: depositDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Deposit Type

Added On: 02/01/19

SQL Column: DEPOSIT_TYPE

Java Field: depositType

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Calculated

Direct Debit Blacklists Amount

Added On: 11/06/18

SQL Column: DIRECT_DEBIT_BLACKLISTS_AMOUNT

Java Field: directDebitBlacklistsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Direct Debit Declines Amount

Added On: 11/06/18

SQL Column: DIRECT_DEBIT_DECLINES_AMOUNT

Java Field: directDebitDeclinesAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Direct Debit Errors Amount

Added On: 11/06/18

SQL Column: DIRECT_DEBIT_ERRORS_AMOUNT

Java Field: directDebitErrorsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Direct Debit Net Amount

Added On: 11/06/18

SQL Column: DIRECT_DEBIT_NET_AMOUNT

Java Field: directDebitNetAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Direct Debit Returns Amount

Added On: 11/06/18

SQL Column: DIRECT_DEBIT_RETURNS_AMOUNT

Java Field: directDebitReturnsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Direct Debit Submitted Amount

Added On: 11/06/18

SQL Column: DIRECT_DEBIT_SUBMITTED_AMOUNT

Java Field: directDebitSubmittedAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Direct Debit Voids Amount

Added On: 11/06/18

SQL Column: DIRECT_DEBIT_VOIDS_AMOUNT

Java Field: directDebitVoidsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

End Date

Added On: 09/21/18

SQL Column: END_DATE

Java Field: endDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Funding Mode Cl

Added On: 07/10/23

SQL Column: FUNDING_MODE_CL

Java Field: fundingModeCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Funding Mode Classifier

Attributes:

Gross Amount

Added On: 12/10/20

SQL Column: GROSS_AMOUNT

Java Field: grossAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Total amount on the statement after all adjustments have been applied.

Added On: 09/21/18

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Identifier of the object used for references; auto-incremented integer value.

Is Ignore Remittance Source

Added On: 02/27/20

SQL Column: IS_IGNORE_REMITTANCE_SOURCE

Java Field: isIgnoreRemittanceSource

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Statement Empty

Added On: 03/27/20

SQL Column: IS_STATEMENT_EMPTY

Java Field: isStatementEmpty

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Is Visible

Added On: 01/31/21

SQL Column: IS_VISIBLE

Java Field: isVisible

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Merchant Account Code

Added On: 09/21/18

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Code of Merchant Account to which instance of this object is attributed to.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Payment Card Blacklists Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_BLACKLISTS_AMOUNT

Java Field: paymentCardBlacklistsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment Card Chargebacks Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_CHARGEBACKS_AMOUNT

Java Field: paymentCardChargebacksAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment Card Declines Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_DECLINES_AMOUNT

Java Field: paymentCardDeclinesAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment Card Errors Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_ERRORS_AMOUNT

Java Field: paymentCardErrorsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment Card Net Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_NET_AMOUNT

Java Field: paymentCardNetAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment Card Reversals Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_REVERSALS_AMOUNT

Java Field: paymentCardReversalsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment Card Submissions Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_SUBMISSIONS_AMOUNT

Java Field: paymentCardSubmissionsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Payment Card Voids Amount

Added On: 11/06/18

SQL Column: PAYMENT_CARD_VOIDS_AMOUNT

Java Field: paymentCardVoidsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Processing Cost Amount

Added On: 11/06/18

SQL Column: PROCESSING_COST_AMOUNT

Java Field: processingCostAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Profile Name

Added On: 09/21/18

SQL Column: PROFILE_NAME

Java Field: profileName

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Provider Merchant Id

Added On: 09/21/18

SQL Column: PROVIDER_MERCHANT_ID

Java Field: providerMerchantId

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Provider Statement Id

Added On: 09/21/18

SQL Column: PROVIDER_STATEMENT_ID

Java Field: providerStatementId

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Pull Ins Amount

Added On: 11/06/18

SQL Column: PULL_INS_AMOUNT

Java Field: pullInsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Pull Outs Amount

Added On: 11/06/18

SQL Column: PULL_OUTS_AMOUNT

Java Field: pullOutsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Realtime Deposit Policy

Added On: 12/13/20

SQL Column: REALTIME_DEPOSIT_POLICY

Java Field: realtimeDepositPolicy

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Pattern:

Reconciliation Statement Fk

Added On: 02/27/20

SQL Column: RECONCILIATION_STATEMENT_FK

Java Field: reconciliationStatementFk

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Record Content

Added On: 04/03/19

SQL Column: RECORD_CONTENT

Java Field: recordContent

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Transient

Remitted Amount

Added On: 09/21/18

SQL Column: REMITTED_AMOUNT

Java Field: remittedAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Chargebacks Collected Amount

Added On: 11/06/18

SQL Column: RESERVES_CHARGEBACKS_COLLECTED_AMOUNT

Java Field: reservesChargebacksCollectedAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Chargebacks Current Balance

Added On: 11/06/18

SQL Column: RESERVES_CHARGEBACKS_CURRENT_BALANCE

Java Field: reservesChargebacksCurrentBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Chargebacks Min Amount

Added On: 11/06/18

SQL Column: RESERVES_CHARGEBACKS_MIN_AMOUNT

Java Field: reservesChargebacksMinAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Chargebacks Previous Balance

Added On: 11/06/18

SQL Column: RESERVES_CHARGEBACKS_PREVIOUS_BALANCE

Java Field: reservesChargebacksPreviousBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Chargebacks Rate

Added On: 11/06/18

SQL Column: RESERVES_CHARGEBACKS_RATE

Java Field: reservesChargebacksRate

Status: Active

SQL Type: decimal(10,2)

Java Type: Double

Attributes:

Reserves Chargebacks Required Balance

Added On: 11/06/18

SQL Column: RESERVES_CHARGEBACKS_REQUIRED_BALANCE

Java Field: reservesChargebacksRequiredBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Direct Debit Net Sales Amount

Added On: 11/06/18

SQL Column: RESERVES_DIRECT_DEBIT_NET_SALES_AMOUNT

Java Field: reservesDirectDebitNetSalesAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Payment Card Net Sales Amount

Added On: 11/06/18

SQL Column: RESERVES_PAYMENT_CARD_NET_SALES_AMOUNT

Java Field: reservesPaymentCardNetSalesAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Refunds Collected Amount

Added On: 11/06/18

SQL Column: RESERVES_REFUNDS_COLLECTED_AMOUNT

Java Field: reservesRefundsCollectedAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Refunds Current Balance

Added On: 11/06/18

SQL Column: RESERVES_REFUNDS_CURRENT_BALANCE

Java Field: reservesRefundsCurrentBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Refunds Max Amount

Added On: 11/06/18

SQL Column: RESERVES_REFUNDS_MAX_AMOUNT

Java Field: reservesRefundsMaxAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Refunds Previous Balance

Added On: 11/06/18

SQL Column: RESERVES_REFUNDS_PREVIOUS_BALANCE

Java Field: reservesRefundsPreviousBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Returns Collected Amount

Added On: 11/06/18

SQL Column: RESERVES_RETURNS_COLLECTED_AMOUNT

Java Field: reservesReturnsCollectedAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Returns Current Balance

Added On: 11/06/18

SQL Column: RESERVES_RETURNS_CURRENT_BALANCE

Java Field: reservesReturnsCurrentBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Returns Min Amount

Added On: 11/06/18

SQL Column: RESERVES_RETURNS_MIN_AMOUNT

Java Field: reservesReturnsMinAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Returns Previous Balance

Added On: 11/06/18

SQL Column: RESERVES_RETURNS_PREVIOUS_BALANCE

Java Field: reservesReturnsPreviousBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Reserves Returns Rate

Added On: 11/06/18

SQL Column: RESERVES_RETURNS_RATE

Java Field: reservesReturnsRate

Status: Active

SQL Type: decimal(10,2)

Java Type: Double

Attributes:

Reserves Returns Required Balance

Added On: 11/06/18

SQL Column: RESERVES_RETURNS_REQUIRED_BALANCE

Java Field: reservesReturnsRequiredBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Source Cl

Added On: 05/23/19

SQL Column: SOURCE_CL

Java Field: sourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Statement Source Classifier

Attributes:

Spits Direct Debit Net Amount

Added On: 02/27/20

SQL Column: SPITS_DIRECT_DEBIT_NET_AMOUNT

Java Field: spitsDirectDebitNetAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Spits Payment Card Net Amount

Added On: 02/27/20

SQL Column: SPITS_PAYMENT_CARD_NET_AMOUNT

Java Field: spitsPaymentCardNetAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Split Ins Amount

Added On: 11/06/18

SQL Column: SPLIT_INS_AMOUNT

Java Field: splitInsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Split Outs Amount

Added On: 11/06/18

SQL Column: SPLIT_OUTS_AMOUNT

Java Field: splitOutsAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Start Date

Added On: 09/21/18

SQL Column: START_DATE

Java Field: startDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Statement Cl

Added On: 09/21/18

SQL Column: STATEMENT_CL

Java Field: statementCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Statement Classifier

Attributes:

Statement Code

Added On: 11/06/18

SQL Column: STATEMENT_CODE

Java Field: statementCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Status Cl

Added On: 06/17/21

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: Object

References Statement Status Classifier

Attributes:

Surcharge Fee Amount

Added On: 11/06/18

SQL Column: SURCHARGE_FEE_AMOUNT

Java Field: surchargeFeeAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Tax Amount

Added On: 11/06/18

SQL Column: TAX_AMOUNT

Java Field: taxAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Total Collected Amount

Added On: 11/06/18

SQL Column: TOTAL_COLLECTED_AMOUNT

Java Field: totalCollectedAmount

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes: