# Sage Intacct: Ap Ar Enhanced

## Description

* All transactions for each bill or invoice with their associated accounting period and due dates. Includes additional detail regarding the customer, location, department, vendor, and account. Lastly, contains fields like the line number and total number of items in the overall bill or invoice.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/sage_intacct/resources/sage_intacct_logo.svg" alt="" data-size="line"> Sage Intacct

## Columns

| Type     | Name                       | Description                                                                                              |
| -------- | -------------------------- | -------------------------------------------------------------------------------------------------------- |
| STRING   | document\_id               | Invoice or bill id                                                                                       |
| STRING   | document\_item\_id         | Unique key identifying the document item id                                                              |
| STRING   | document\_type             | Whether the document is a bill or invoice                                                                |
| DATE     | entry\_date\_at            | Entry date                                                                                               |
| STRING   | entry\_description         | Description of entry                                                                                     |
| DECIMAL  | amount                     | Value of the document item                                                                               |
| STRING   | currency                   | Currency of item                                                                                         |
| INTEGER  | due\_in\_days              | Days until due                                                                                           |
| STRING   | item\_id                   | Item ID                                                                                                  |
| STRING   | item\_name                 | Item name                                                                                                |
| INTEGER  | line\_no                   | Line number of the item out of the overall document                                                      |
| BOOLEAN  | line\_item                 | True or false                                                                                            |
| STRING   | customer\_id               | ID of customer                                                                                           |
| STRING   | customer\_name             | Name of customer                                                                                         |
| STRING   | department\_id             | ID of department                                                                                         |
| STRING   | department\_name           | Name of department                                                                                       |
| STRING   | location\_id               | ID of location                                                                                           |
| STRING   | location\_name             | Name of location                                                                                         |
| STRING   | vendor\_id                 | ID of vendor                                                                                             |
| STRING   | vendor\_name               | Name of vendor                                                                                           |
| DECIMAL  | account\_no                | ID of account                                                                                            |
| STRING   | account\_title             | Name of account                                                                                          |
| STRING   | class\_id                  | ID of class                                                                                              |
| STRING   | class\_name                | Name of class                                                                                            |
| DATETIME | created\_at                | Creation date as entered by user                                                                         |
| DATETIME | modified\_at               | Modified date                                                                                            |
| DECIMAL  | total\_due                 | Total amount due                                                                                         |
| DECIMAL  | total\_entered             | Total amount entered                                                                                     |
| DECIMAL  | total\_paid                | Total amount paid                                                                                        |
| INTEGER  | number\_of\_items          | Total number of items                                                                                    |
| DECIMAL  | total\_item\_paid          | Total item paid                                                                                          |
| INTEGER  | offset\_gl\_account\_no    | Offsetting account no from GL\_ACCOUNT                                                                   |
| STRING   | offset\_gl\_account\_title | Offsetting account title from GL\_ACCOUNT                                                                |
| STRING   | record\_id                 | ID of invoice or bill. Maps to GL\_DETAIL.RECORDID, which has all the records belonging to that 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/sage-intacct-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.