Statement List Export


Added On:  11/06/18 
SQL Table:  STATEMENT_LIST_EXPORT 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  StatementListExport 
Added On:  11/06/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:  11/06/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:  11/06/18
SQL Column:  PROVIDER_MERCHANT_ID
Java Field:  providerMerchantId
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  PROFILE_NAME
Java Field:  profileName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  ACCOUNT_ID
Java Field:  accountId
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  STATEMENT_ID
Java Field:  statementId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  STATEMENT_TYPE
Java Field:  statementType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  DEPOSIT_TYPE
Java Field:  depositType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
References Deposit Classifier
Attributes:
Added On:  11/06/18
SQL Column:  END_DATE
Java Field:  endDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  11/06/18
SQL Column:  START_DATE
Java Field:  startDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
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:  REMITTED_AMOUNT
Java Field:  remittedAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DATA_REGISTRY_EXPORT_CODE
Java Field:  dataRegistryExportCode
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:  11/06/18
SQL Column:  SOURCE_TYPE
Java Field:  sourceType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: