CData Cmdlets for OFX 2019J - Online Help


CData Cmdlets for OFX 2019J - Build 19.0.7354

Query transactions for a single investment account.


Name Type Description
Id [KEY] String Id assigned for the transaction by the financial institution.
Aggregate String Transaction information aggregate.
DatePosted Datetime Date when the transaction trade occured.
DateSettle Datetime Date when the settlement occured. For stock splits, this is the execution date.
FITId String Transaction Id assigned by the financial institution.
Memo String Information regarding the transaction from the broker to the customer.
Name String Name for the transaction, if provided by the server.
SecurityId String Security Id for this investment transaction.
SubAcctFund String Subaccount associated with the funds for the transaction.
SubAcctSec String Subaccount type for the security.
Total Decimal Transaction amount including fees, commissions, taxes, etc.
TypeDesc String Description of the transaction type.
UnitPrice Decimal Price per commonly quoted unit, excluding markup/markdown.
Units Double The quantity for security-based actions other than stock splits.
CurrencyCode String Default currency code for transactions.
StatementDate Datetime Date and time for the statement download.
Sec_Aggregate String Security information aggregate.
Sec_AssetClass String Asset class for the security.
Sec_Name String Full name of the security.
Sec_Ticker String Ticker symbol of the security.
Sec_UnitPrice Decimal The current unit price of the security as provided by the server. This may be a real-time or delayed quote.
Sec_Yield String Current yield reported as a portion of the fund's assets.


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