# Sage Intacct: General Ledger

## Description

* Records all transactions from Sage general ledger. Additionally adds category, classification, and account type.

## 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   | gl\_detail\_id      | Unique identifier of the gl\_detail entry.                 |
| STRING   | account\_no         | ID of the account                                          |
| STRING   | account\_title      | Name of the account                                        |
| INTEGER  | amount              | Value of transaction                                       |
| STRING   | book\_id            | ID of the book                                             |
| DECIMAL  | credit\_amount      | If credit, the value                                       |
| DECIMAL  | debit\_amount       | If debit, the value                                        |
| STRING   | currency            | Currency of transaction                                    |
| STRING   | description         | Description of the transaction                             |
| STRING   | doc\_number         | Document number                                            |
| STRING   | customer\_id        | ID of the customer                                         |
| STRING   | customer\_name      | Name of the customer                                       |
| DATE     | entry\_date\_at     | Timestamp of entry                                         |
| STRING   | entry\_state        | State of entry                                             |
| STRING   | entry\_description  | Description of entry                                       |
| INTEGER  | line\_no            | The number of each line item of the transaction            |
| STRING   | record\_id          | ID of record, which corresponds to the bill or invoice ID. |
| STRING   | record\_type        | Type of record, for example AP Bill                        |
| DECIMAL  | total\_due          | Value of amount due                                        |
| DECIMAL  | total\_entered      | Value entered                                              |
| DECIMAL  | total\_paid         | Value paid                                                 |
| INTEGER  | tr\_type            | Transaction type                                           |
| DECIMAL  | trx\_amount         | Transaction amount                                         |
| DECIMAL  | trx\_credit\_amount | If credit, transaction amount                              |
| DECIMAL  | trx\_debit\_amount  | If debit, transaction amount                               |
| STRING   | vendor\_id          | Id of vendor                                               |
| STRING   | vendor\_name        | Name of vendor                                             |
| DATE     | created\_at         | Creation date as entered by user                           |
| DATE     | due\_at             | When transaction is due                                    |
| DATETIME | modified\_at        | When transaction is modified                               |
| DATE     | paid\_at            | When transaction was paid                                  |
| STRING   | category            | Accounting category, like Cost of Sales Revenue            |
| STRING   | classification      | Accounting classification, like Revenue                    |
| STRING   | account\_type       | Income statement or balance sheet                          |


---

# 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-general-ledger.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.