Statement List Export

Added On:  11/06/18 

SQL Table:  STATEMENT_LIST_EXPORT 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  StatementListExport 

Available Fields:

• Account Id
• Adjustments Amount
• Bank Account Number Masked
• Bank Routing Number Masked
• Capture Currency Code
• Charges Amount
• Create Date
• Data Registry Export Code
• 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
• Id
• 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
• Pull Ins Amount
• Pull Outs Amount
• 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 Type
• Split Ins Amount
• Split Outs Amount
• Start Date
• Statement Id
• Statement Type
• Surcharge Fee Amount
• Tax Amount
• Total Collected Amount

Account Id

Added On:  11/06/18

SQL Column:  ACCOUNT_ID

Java Field:  accountId

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

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:

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:

Create Date

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.

Data Registry Export Code

Added On:  11/06/18

SQL Column:  DATA_REGISTRY_EXPORT_CODE

Java Field:  dataRegistryExportCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

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:  11/06/18

SQL Column:  DEPOSIT_TYPE

Java Field:  depositType

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Deposit Classifier

Attributes:

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:  11/06/18

SQL Column:  END_DATE

Java Field:  endDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Id

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.

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:  11/06/18

SQL Column:  PROFILE_NAME

Java Field:  profileName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Provider Merchant Id

Added On:  11/06/18

SQL Column:  PROVIDER_MERCHANT_ID

Java Field:  providerMerchantId

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:

Remitted Amount

Added On:  11/06/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 Type

Added On:  11/06/18

SQL Column:  SOURCE_TYPE

Java Field:  sourceType

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Statement Source Classifier

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:  11/06/18

SQL Column:  START_DATE

Java Field:  startDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Statement Id

Added On:  11/06/18

SQL Column:  STATEMENT_ID

Java Field:  statementId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Statement Type

Added On:  11/06/18

SQL Column:  STATEMENT_TYPE

Java Field:  statementType

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Statement 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: