CData Cmdlets for OFX 2019J - Online Help


CData Cmdlets for OFX 2019J - Build 19.0.7354

Query loan transactions for a single account.


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.
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.
DateDue Datetime Next payment due date.
MinimumPayment Decimal Next minimum amount due.
InterestRate Double Current loan interest rate.
InterestRateType String Type of the current loan interest rate.
TotalInterest Decimal Total interest.
CurrencyCode String Default currency code for transactions.


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 create a local file containing the OFX data, including OFX headers, returned by the financial institution.

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