# Quickbooks: Ap Ar Enhanced

## Description

* Table that unions all accounts payable records from int\_quickbooks\_\_bill\_join and all accounts receivable records from int\_quickbooks\_\_invoice\_join while also adding customer, vendor, address, and department level detail to the accounts payable and receivable records. Further, date and amountcalculations are included to show if the payable/receivable has been fully paid and/or paid on time.

## Supported Data Sources

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

## Columns

| Type    | Name                               | Description                                                                                             |
| ------- | ---------------------------------- | ------------------------------------------------------------------------------------------------------- |
| STRING  | transaction\_type                  | Set to 'bill' of the transaction is a bill and 'invoice' if the transaction is an invoice.              |
| STRING  | transaction\_id                    | Unique identifier of the transaction for the bill or invoice.                                           |
| STRING  | source\_relation                   | The source of the record if the unioning functionality is being used. If not this field will be null.   |
| STRING  | doc\_number                        | The QuickBooks document number reference.                                                               |
| STRING  | estimate\_id                       | Unique identifier of the estimate associated with the invoice.                                          |
| STRING  | department\_name                   | Name of the department associated with either the invoice or bill.                                      |
| STRING  | transaction\_with                  | Set to 'vendor' if the transaction type is a bill and 'customer' if the transaction type is an invoice. |
| STRING  | customer\_vendor\_name             | Full name of the vendor (if a bill) or the customer (if an invoice).                                    |
| DECIMAL | customer\_vendor\_balance          | Total current account balance of the vendor (if a bill) or the customer (if an invoice).                |
| STRING  | customer\_vendor\_address\_city    | City of the vendor (if a bill) or the customer (if an invoice).                                         |
| STRING  | customer\_vendor\_address\_country | Country of the vendor (if a bill) or the customer (if an invoice).                                      |
| STRING  | customer\_vendor\_address\_line    | Address line of the vendor (if a bill) or the customer (if an invoice).                                 |
| STRING  | customer\_vendor\_website          | The website url of the customer or vendor.                                                              |
| STRING  | delivery\_type                     | How the invoice was delivered to the customer.                                                          |
| STRING  | estimate\_status                   | The status of the invoice estimate (if applicable).                                                     |
| DECIMAL | total\_amount                      | The total monetary amount of the invoice or bill.                                                       |
| DECIMAL | estimate\_amount                   | The total amount estimated of the bill or invoice (if applicable).                                      |
| DECIMAL | current\_balance                   | The bill or invoice defined remaining balance of the bill or invoice.                                   |
| DECIMAL | total\_current\_payment            | Sum of all total payments made towards the bill or invoice.                                             |
| DATE    | due\_date                          | The due date for the bill or invoice.                                                                   |
| BOOLEAN | is\_overdue                        | Boolean indicating whether the bill or invoice full payment is overdue.                                 |
| INTEGER | days\_overdue                      | The recent payment minus the due date to show the total days the total payment is overdue.              |
| DATE    | initial\_payment\_date             | The first date a payment was provided for the bill or invoice                                           |
| DATE    | recent\_payment\_date              | The last date a payment was provided for the bill or invoice.                                           |


---

# 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-ap-ar-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.