InvBalancesCData JDBC Driver for OFX 2019J - Build 19.0.7354
Query balances for a single investment account.
|Id [KEY]||String||Id assigned for the transaction by the financial institution.|
|Aggregate||String||Balance information aggregate.|
|Name||String||The name for the current balance.|
|Amount||String||The value of the current balance.|
|Description||String||Description of the current balance.|
|TypeDescription||String||Description of the balance type.|
|CurrencyCode||String||Default currency code for transactions.|
|StatementDate||Datetime||Date and time for the statement download.|
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.
|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.|