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 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.
Escrow Decimal Total amount of payment applied to escrow.
FITId String Transaction Id assigned by the financial institution.
Interest Decimal Amount of payment applied to interest. Loan statements only.
Memo String Notice from the payee to the customer.
PayeeName String Name of the payee.
Principal Decimal Amount of payment applied to principal. Loan statements only.
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.
PrinBalance Decimal Indicates the principal balance.
PrinBalanceDate Datetime Date of the principal balance.
TotalPrincipalLTD Decimal Total principal paid loan to date.
TotalPrincipalYTD Decimal Total principal paid year to date.
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