Transactions
Query QuickBooks transactions. You may search the Transactions using a number of values including Type, Entity, Account, ReferenceNumber, Item, Class, Date, and TimeModified.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier of the transaction. | |
| TxnLineId [KEY] | 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. | |
| AccountName | String | The name of the account associated with the transaction. | |
| AccountId | String |
Accounts.ID | 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. | |
| CurrencyName | String | The name of the currency for this customer. A minimum QBXML Version of 8.0 is required for this feature. | |
| CurrencyId | String |
Currency.ID | 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-Columns
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 | |
| 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. | |
| PaidStatus | 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. |