CData Cmdlets for OFX 2019J - Online Help

BankClosingDetails

CData Cmdlets for OFX 2019J - Build 19.0.7354

Query bank statement closing details for a single bank account.

Columns

Name Type Description
Id [KEY] String Id assigned for the transaction by the financial institution.
Aggregate String Bank statement closing details aggregate.
BalanceOpening Decimal Opening statement balance.
BalanceClosing Decimal Closing statement balance.
DateOpen Datetime Opening statement date.
DateClose Datetime Closing statement date.
DateStart Datetime Start date of transaction data for this statement.
DateEnd Datetime End date of transaction data for this statement.
TotalCredit Decimal Total credit posted on the account for this statement (period indicated by DateStart and DateEnd).
TotalDebit Decimal Total debit posted on the account for this statement (period indicated by DateStart and DateEnd).
TotalFees Decimal Total fees.
TotalInterest Decimal Total interest.
CurrencyCode String Default currency code for transactions.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
OFXReadFile String Specify a file path to read OFX data from a local file. Data will not be requested from the financial institution and the local OFX data will be parsed.
OFXWriteFile String Specify a file path to log to a local file the OFX response, including headers, returned by the financial institution.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0