Query QuickBooks transactions. You may search the Transactions using a number of values including Type, Entity, Account, ReferenceNumber, Item, Class, Date, and TimeModified.
|ID [KEY]||String||The unique identifier of the transaction.|
|TxnLineId||String||The id of the individual line item.|
|Type||String||The transaction type of the result.|
|Date||Date||The date of the transaction.|
|Entity||String||The name of the entity associated with the transaction. For example, the name of a customer, vendor, employee, or other name.|
|EntityId||String||The Id of the entity associated with the transaction. For example, the name of a customer, vendor, employee, or other name.|
|The name of the account associated with the transaction.|
|The Id of the account associated with the transaction.|
|ReferenceNumber||String||The reference number of the transaction, if applicable.|
|Amount||Decimal||The amount of the transaction.|
|The name of the currency for this customer. A minimum QBXML Version of 8.0 is required for this feature.|
|The unique Id of the currency for this customer. A minimum QBXML Version of 8.0 is required for this feature.|
|ExchangeRate||Double||The market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the home currency.|
|AmountInHomeCurrency||Decimal||The amount of the transaction in units of the home currency.|
|Memo||String||The memo appearing on the transaction.|
|TimeModified||Datetime||When the transaction was last modified.|
|TimeCreated||Datetime||When the transaction was created.|
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.
|ItemName||String||The item name appearing in the transaction.|
|ItemId||String||The item Id appearing in the transaction.|
|ClassName||String||The class name applied to the transaction.|
|ClassId||String||The class Id applied to the transaction.|
|PostingStatus||String||The posting status of transactions to return.
The allowed values are Either, NonPosting, Posting.
The default value is Either.
|IsPaid||String||The paid status of transactions to return. Enter either true or false.|
|DetailLevel||String||The level of detail to use when filtering objects.
The allowed values are All, AllExceptSummary, SummaryOnly.
The default value is SummaryOnly.