Merchant Statement Detail UML

Added On: 03/16/12

SQL Table: IAPP_MERCHANT_STATEMENT_DETAIL

Module: UniCore

Type: Entity Status: Active

Java Class: MerchantStatementDetail

Represents detailed information about merchant statement. Includes transaction submissions, deposits, reserves, processing and monthly fees etc.

Available Fields:

Activity Date
Amex Chargeback Amount
Amount
Authorization Amount
Authorization Currency Code
Buy Rate Amount
Caption
Caption Var0
Caption Var1
Caption Var10
Caption Var11
Caption Var12

Caption Var13
Caption Var2
Caption Var3
Creator Code
Deposit Statement FK
Description
Fee Schema Detail FK
Funds Source CL
GL Account FK
Id
Is Processed
Is Visible Externally

Merchant Account Code
Merchant Fee Detail FK
Merchant Statement
Remittance Source CL
Settlement Currency Code
Split Amount
Split Out Balance
Statement Detail Group FK
Stereotype
Submission CL
Submission Code
Tax Amount

Transaction CL

Activity Date

Added On: 03/16/12

SQL Column: ACTIVITY_DATE

Java Field: activityDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Amex Chargeback Amount

Added On: 02/12/14

SQL Column: AMEX_CHARGEBACK_AMOUNT

Java Field: amexChargebackAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount

Added On: 03/16/12

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.

Authorization Amount

Added On: 09/03/13

SQL Column: AUTHORIZATION_AMOUNT

Java Field: authorizationAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of authorization transaction for the merchant.

Authorization Currency Code

Added On: 08/20/13

SQL Column: AUTHORIZATION_CURRENCY_CODE

Java Field: authorizationCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of currency used for authorization.

Buy Rate Amount

Added On: 03/16/12

SQL Column: BUY_RATE_AMOUNT

Java Field: buyRateAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Caption

Added On: 03/16/12

SQL Column: CAPTION

Java Field: caption

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

General transaction information, which does not take part in remittance process.

Caption Var0

Added On: 03/16/12

SQL Column: CAPTION_VAR0

Java Field: captionVar0

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Caption Var1

Added On: 03/16/12

SQL Column: CAPTION_VAR1

Java Field: captionVar1

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Caption Var10

Added On: 03/16/12

SQL Column: CAPTION_VAR10

Java Field: captionVar10

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Caption Var11

Added On: 03/16/12

SQL Column: CAPTION_VAR11

Java Field: captionVar11

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Caption Var12

Added On: 03/16/12

SQL Column: CAPTION_VAR12

Java Field: captionVar12

Status: Active

SQL Type: decimal(10,2)

Java Type: Double

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Caption Var13

Added On: 03/16/12

SQL Column: CAPTION_VAR13

Java Field: captionVar13

Status: Active

SQL Type: decimal(10,2)

Java Type: Double

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Caption Var2

Added On: 03/16/12

SQL Column: CAPTION_VAR2

Java Field: captionVar2

Status: Active

SQL Type: decimal(10,2)

Java Type: Double

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Caption Var3

Added On: 03/16/12

SQL Column: CAPTION_VAR3

Java Field: captionVar3

Status: Active

SQL Type: decimal(10,2)

Java Type: Double

Attributes:

Caption intended to display one of the values, used for calculation of buy rate and fee, in the statements.

Creator Code

Added On: 03/16/12

SQL Column: CREATOR_CODE

Java Field: creatorCode

Status: Active

SQL Type: varchar(56)

Java Type: String

Attributes:

Code of the merchant statement creator.

Deposit Statement FK

Added On: 03/27/14

SQL Column: DEPOSIT_STATEMENT_FK

Java Field: depositStatement

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Statement

Attributes:

Reference to the entity that represents deposit statement information.

Description

Added On: 03/16/12

SQL Column: DESCRIPTION

Java Field: description

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Short description of the merchant statement.

Fee Schema Detail FK

Added On: 03/27/14

SQL Column: FEE_SCHEMA_DETAIL_FK

Java Field: feeSchemaDetail

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Fee Schema Detail

Attributes:

Reference to the entity that represents various details on fee schema used.

Funds Source CL

Added On: 10/10/12

SQL Column: FUNDS_SOURCE_CL

Java Field: fundsSourceCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Funds Source Classifier

Attributes:

Represents the selected source of funds for transaction.

GL Account FK

Added On: 03/27/14

SQL Column: GL_ACCOUNT_FK

Java Field: glAccount

Status: Active

SQL Type: bigint(20)

Java Type: Long

References GL Account

Attributes:

Reference to the entity that represents GL account.

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.

Is Processed

Added On: 05/31/17

SQL Column: IS_PROCESSED

Java Field: isProcessed

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Transient, Default:False

Is Visible Externally

Added On: 03/16/12

SQL Column: IS_VISIBLE_EXTERNALLY

Java Field: isVisibleExternally

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:true

Merchant Account Code

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.

Merchant Fee Detail FK

Added On: 03/27/14

SQL Column: MERCHANT_FEE_DETAIL_FK

Java Field: merchantFeeDetail

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Merchant Fee Detail

Attributes:

Reference to the entity that represents merchant fee details.

Merchant Statement

Added On: 08/31/16

SQL Column: MERCHANT_STATEMENT_FK

Java Field: merchantStatement

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Statement

Attributes:

Reference to the entity that represents merchant statement details information.

Remittance Source CL

Added On: 03/16/12

SQL Column: REMITTANCE_SOURCE_CL

Java Field: remittanceSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Remittance Source Classifier

Attributes:

Represents the selected source of remmitance.

Settlement Currency Code

Added On: 08/20/13

SQL Column: SETTLEMENT_CURRENCY_CODE

Java Field: settlementCurrencyCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of currency used for settlement.

Split Amount

Added On: 05/31/17

SQL Column: SPLIT_AMOUNT

Java Field: splitAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Transient

Amount included in the split transaction.

Split Out Balance

Added On: 05/31/17

SQL Column: SPLIT_OUT_BALANCE

Java Field: splitOutBalance

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Split Out Balance

Attributes: Transient

Split-out balance associated with the merchant.

Statement Detail Group FK

Added On: 03/27/14

SQL Column: STATEMENT_DETAIL_GROUP_FK

Java Field: statementDetailGroup

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Statement Detail Group

Attributes:

Reference to the entity that represents statement details group.

Stereotype

Added On: 10/30/13

SQL Column: STEREOTYPE

Java Field: stereotype

Status: Active

SQL Type: varchar(70)

Java Type: String

Attributes:

Submission CL

Added On: 03/16/12

SQL Column: SUBMISSION_CL

Java Field: submissionCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Submission Classifier

Attributes:

Represents the type of submission.

Submission Code

Added On: 03/16/12

SQL Column: SUBMISSION_CODE

Java Field: submissionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the submission.

Tax Amount

Added On: 02/08/24

SQL Column: TAX_AMOUNT

Java Field: taxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount (in cents) of the tax.

Transaction CL

Added On: 01/21/13

SQL Column: TRANSACTION_CL

Java Field: transactionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Transaction Classifier

Attributes:

Represents the selected transaction processing mode.