# Quickbooks: Expenses Sales Enhanced

## Description

* Table that unions all expense records from int\_quickbooks\_\_expenses\_union and all sales records from the int\_quickbooks\_\_sales\_union while also adding customer, vendor, and department level detail to the expense and sales records.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/quickbooks/resources/quickbooks.svg" alt="" data-size="line"> QuickBooks

## Columns

| Type    | Name                  | Description                                                                                                 |
| ------- | --------------------- | ----------------------------------------------------------------------------------------------------------- |
| STRING  | transaction\_source   | Set to 'expense' if the transaction type is an expense and 'sale' if the transaction type is a sale.        |
| STRING  | transaction\_id       | Unique identifier of the transaction for either the expense or sale.                                        |
| STRING  | source\_relation      | The source of the record if the unioning functionality is being used. If not this field will be null.       |
| INTEGER | transaction\_line\_id | Unique identifier of either the expense or sale line item.                                                  |
| STRING  | doc\_number           | The QuickBooks document number reference.                                                                   |
| STRING  | transaction\_type     | Specifies the expense or sale transaction type (ie. invoice, sales\_receipt, deposit, journal entry, etc.). |
| DATE    | transaction\_date     | The date that the transaction occurred.                                                                     |
| STRING  | item\_id              | Unique identifier of the item included in a sale transaction.                                               |
| DECIMAL | item\_quantity        | Quantity of items included in the sale transaction.                                                         |
| DECIMAL | item\_unit\_price     | Unit price of the item included in the sale transaction.                                                    |
| STRING  | account\_id           | The identifier of the account associated with either the expense or sale.                                   |
| STRING  | account\_name         | Name of the account associated with either the expense or sale.                                             |
| STRING  | account\_sub\_type    | Sub type of the account associated with either the expense or sale.                                         |
| STRING  | class\_id             | Reference to the class associated with either the expense or sale.                                          |
| STRING  | department\_id        | Reference to the department associated with either the expense or sale.                                     |
| STRING  | department\_name      | Name of the department associated with either the expense or sale.                                          |
| STRING  | customer\_id          | Reference to the customer associated with either the expense or sale.                                       |
| STRING  | customer\_name        | Name of the customer associated with either the expense or sale.                                            |
| STRING  | customer\_website     | The website url of the customer.                                                                            |
| STRING  | vendor\_id            | Reference to the vendor associated with either the expense or sale.                                         |
| STRING  | vendor\_name          | Name of the vendor associated with either the expense or sale.                                              |
| STRING  | billable\_status      | Status indicating whether the expense or sale is billable.                                                  |
| STRING  | description           | Description given to either the expense or sale transaction.                                                |
| DECIMAL | amount                | Monetary amount of either the expense or sale line item.                                                    |
| DECIMAL | total\_amount         | Total monetary amount of either the expense or sale.                                                        |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/quickbooks-expenses-sales-enhanced.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.