Merchant Statement Detail UML


Added On:  03/16/12 
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.
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:  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:  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.
Added On:  03/16/12
SQL Column:  BUY_RATE_AMOUNT
Java Field:  buyRateAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
Added On:  03/16/12
SQL Column:  SUBMISSION_CL
Java Field:  submissionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of submission.
Added On:  03/16/12
SQL Column:  ACTIVITY_DATE
Java Field:  activityDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  03/16/12
SQL Column:  REMITTANCE_SOURCE_CL
Java Field:  remittanceSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the selected source of remmitance.
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
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.
Added On:  10/10/12
SQL Column:  FUNDS_SOURCE_CL
Java Field:  fundsSourceCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the selected source of funds for transaction.
Added On:  01/21/13
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the selected transaction processing mode.
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.
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.
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.
Added On:  10/30/13
SQL Column:  STEREOTYPE
Java Field:  stereotype
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  02/12/14
SQL Column:  AMEX_CHARGEBACK_AMOUNT
Java Field:  amexChargebackAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
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/27/14
SQL Column:  STATEMENT_DETAIL_GROUP_FK
Java Field:  statementDetailGroup
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents statement details group.
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.
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.
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
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.
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.