CData Cmdlets for OFX 2019J - Online Help


CData Cmdlets for OFX 2019J - Build 19.0.7354

Query bank transactions for a single bank account.


Name Type Description
Id [KEY] String Id assigned for the transaction by the financial institution.
Aggregate String Transaction information aggregate.
Amount Decimal Amount of money exchanged during a given transaction.
Date Datetime Date the transaction was made by the account holder as recorded by the financial institution.
DatePosted Datetime Date the transaction was posted to the financial institution.
FITId String Transaction Id assigned by the financial institution.
Memo String Notice from the payee to the customer.
Payeename String Name of the payee.
TxnTypeDesc String Description of the transaction type.
CheckNumber Integer Check number of the original check.
ImageRef String Unique identifier for the transaction image.
ImageRefType String Transaction image retrieval method.
AvailBalance Decimal Indicates the available balance.
AvailBalanceDate Datetime Date of the available balance.
LedgerBalance Decimal Indicates the ledger balance.
LedgerBalanceDate Datetime Date of the ledger balance.
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