Merchant Statement Extended UML


Added On:  05/21/19 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  MerchantStatementExtended 
Available Fields:
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.
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.
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.
Added On:  09/21/18
SQL Column:  REMITTED_AMOUNT
Java Field:  remittedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  09/21/18
SQL Column:  START_DATE
Java Field:  startDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/21/18
SQL Column:  END_DATE
Java Field:  endDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/21/18
SQL Column:  PROVIDER_STATEMENT_ID
Java Field:  providerStatementId
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/21/18
SQL Column:  PROVIDER_MERCHANT_ID
Java Field:  providerMerchantId
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/21/18
SQL Column:  PROFILE_NAME
Java Field:  profileName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/21/18
SQL Column:  CONTENT_FK
Java Field:  content
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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:
Added On:  09/21/18
SQL Column:  STATEMENT_CL
Java Field:  statementCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  01/31/19
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Calculated
Added On:  02/01/19
SQL Column:  DEPOSIT_TYPE
Java Field:  depositType
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Calculated
Added On:  04/03/19
SQL Column:  RECORD_CONTENT
Java Field:  recordContent
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Transient
Added On:  05/23/19
SQL Column:  SOURCE_CL
Java Field:  sourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  STATEMENT_CODE
Java Field:  statementCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_SUBMISSIONS_AMOUNT
Java Field:  paymentCardSubmissionsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_DECLINES_AMOUNT
Java Field:  paymentCardDeclinesAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_VOIDS_AMOUNT
Java Field:  paymentCardVoidsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_CHARGEBACKS_AMOUNT
Java Field:  paymentCardChargebacksAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_BLACKLISTS_AMOUNT
Java Field:  paymentCardBlacklistsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_ERRORS_AMOUNT
Java Field:  paymentCardErrorsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_REVERSALS_AMOUNT
Java Field:  paymentCardReversalsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PAYMENT_CARD_NET_AMOUNT
Java Field:  paymentCardNetAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DIRECT_DEBIT_SUBMITTED_AMOUNT
Java Field:  directDebitSubmittedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DIRECT_DEBIT_DECLINES_AMOUNT
Java Field:  directDebitDeclinesAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DIRECT_DEBIT_VOIDS_AMOUNT
Java Field:  directDebitVoidsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DIRECT_DEBIT_RETURNS_AMOUNT
Java Field:  directDebitReturnsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DIRECT_DEBIT_BLACKLISTS_AMOUNT
Java Field:  directDebitBlacklistsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DIRECT_DEBIT_ERRORS_AMOUNT
Java Field:  directDebitErrorsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DIRECT_DEBIT_NET_AMOUNT
Java Field:  directDebitNetAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  TOTAL_COLLECTED_AMOUNT
Java Field:  totalCollectedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  SURCHARGE_FEE_AMOUNT
Java Field:  surchargeFeeAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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:
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:
Added On:  11/06/18
SQL Column:  RESERVES_RETURNS_RATE
Java Field:  reservesReturnsRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_RETURNS_MIN_AMOUNT
Java Field:  reservesReturnsMinAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_RETURNS_REQUIRED_BALANCE
Java Field:  reservesReturnsRequiredBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_RETURNS_PREVIOUS_BALANCE
Java Field:  reservesReturnsPreviousBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_RETURNS_COLLECTED_AMOUNT
Java Field:  reservesReturnsCollectedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_RETURNS_CURRENT_BALANCE
Java Field:  reservesReturnsCurrentBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_CHARGEBACKS_RATE
Java Field:  reservesChargebacksRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_CHARGEBACKS_MIN_AMOUNT
Java Field:  reservesChargebacksMinAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_CHARGEBACKS_REQUIRED_BALANCE
Java Field:  reservesChargebacksRequiredBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_CHARGEBACKS_PREVIOUS_BALANCE
Java Field:  reservesChargebacksPreviousBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_CHARGEBACKS_COLLECTED_AMOUNT
Java Field:  reservesChargebacksCollectedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_CHARGEBACKS_CURRENT_BALANCE
Java Field:  reservesChargebacksCurrentBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_REFUNDS_MAX_AMOUNT
Java Field:  reservesRefundsMaxAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_REFUNDS_PREVIOUS_BALANCE
Java Field:  reservesRefundsPreviousBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_REFUNDS_COLLECTED_AMOUNT
Java Field:  reservesRefundsCollectedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  RESERVES_REFUNDS_CURRENT_BALANCE
Java Field:  reservesRefundsCurrentBalance
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  SPLIT_INS_AMOUNT
Java Field:  splitInsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  SPLIT_OUTS_AMOUNT
Java Field:  splitOutsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PULL_INS_AMOUNT
Java Field:  pullInsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PULL_OUTS_AMOUNT
Java Field:  pullOutsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  TAX_AMOUNT
Java Field:  taxAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  CHARGES_AMOUNT
Java Field:  chargesAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  ADJUSTMENTS_AMOUNT
Java Field:  adjustmentsAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  PROCESSING_COST_AMOUNT
Java Field:  processingCostAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DEPOSIT_DATE
Java Field:  depositDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  11/06/18
SQL Column:  CAPTURE_CURRENCY_CODE
Java Field:  captureCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BANK_ACCOUNT_NUMBER_MASKED
Java Field:  bankAccountNumberMasked
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BANK_ROUTING_NUMBER_MASKED
Java Field:  bankRoutingNumberMasked
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Added On:  03/27/20
SQL Column:  IS_STATEMENT_EMPTY
Java Field:  isStatementEmpty
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
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:  02/27/20
SQL Column:  RECONCILIATION_STATEMENT_FK
Java Field:  reconciliationStatementFk
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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:
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:
Added On:  12/13/20
SQL Column:  BATCH_DEPOSIT_POLICY
Java Field:  batchDepositPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Pattern:   ALPHANUMERIC
Added On:  12/13/20
SQL Column:  REALTIME_DEPOSIT_POLICY
Java Field:  realtimeDepositPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Pattern:   ALPHANUMERIC
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:  01/31/21
SQL Column:  IS_VISIBLE
Java Field:  isVisible
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true