---
title: "GL Account"
slug: "gl-account"
status: "new"
updated: 2026-10-27T17:34:18Z
published: 2026-10-27T17:44:04Z
canonical: "docs.restaurant365.com/gl-account"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# GL Account

GL accounts in the customer's chart of accounts, with one row per account.

Before querying this table, complete Snowflake Data Share setup. See [Snowflake Data Share Setup](/developer-hub/apidocs/snowflake-data-share-setup) for step-by-step instructions.

## Column reference

| Column | Type | Description |
| --- | --- | --- |
| tenant_id | NUMBER(38,0) | Unique identifier of the R365 tenant account. |
| id | UUID | Unique identifier for the GL account. |
| account_number | VARCHAR | Account number for this GL account. |
| gl_account_name | VARCHAR | Name of the GL account. |
| balance | NUMBER | Current account balance in the account's currency. |
| balance_base | NUMBER | Current account balance in the base currency. |
| is_available_to_managers | BOOLEAN | Indicates whether managers can view this account. |
| is_bank_account | BOOLEAN | Indicates whether this is a bank account. |
| default_budget_amount | NUMBER | Default budget amount for this account. |
| cash_flow_category | VARCHAR | Cash flow category classification for this account. |
| description | VARCHAR | Description of the GL account. |
| is_entry_disabled | BOOLEAN | Indicates whether manual journal entries to this account are disabled. |
| last_reconciled_balance | NUMBER | Balance at the time of the last reconciliation. |
| last_reconciled_balance_base | NUMBER | Base-currency balance at the time of the last reconciliation. |
| last_reconciled_date | DATE | Date of the last reconciliation. |
| next_check_number | INTEGER | Next check number for accounts that issue checks. |
| bank_company | VARCHAR | Bank company name associated with this account. |
| parent_account | UUID | Unique identifier of the parent account in the chart of accounts hierarchy. |
| subtype | VARCHAR | Subtype classification within the account type. |
| account_type | VARCHAR | Type classification for this account (e.g., Asset, Liability, Income, Expense). |
| legal_entity | UUID | Unique identifier of the legal entity this account belongs to. |
| location_id | UUID | Unique identifier of the location this account is associated with. |
| is_deposit_only | BOOLEAN | Indicates whether this account is used for deposits only. |
| is_second_signature_required | BOOLEAN | Indicates whether a second signature is required for transactions on this account. |
| second_signature_threshold | NUMBER | Dollar threshold above which a second signature is required. |
| budget_amount | NUMBER | Budget amount for this account in the current period. |
| bank_account_type | VARCHAR | Type of bank account (e.g., Checking, Savings). |
| is_statistical_account | BOOLEAN | Indicates whether this is a statistical (non-monetary) account. |
| statistical_balance_type | VARCHAR | Balance type for statistical accounts. |
| statistical_direction | VARCHAR | Direction (debit or credit) for statistical account entries. |
| is_control_account | BOOLEAN | Indicates whether this is a control account that prevents direct posting. |
| outstanding_debits | NUMBER | Total outstanding debit amounts for this account. |
| outstanding_credits | NUMBER | Total outstanding credit amounts for this account. |
| current_balance | NUMBER | Current balance including all posted and unposted transactions. |
| is_restricted_access | BOOLEAN | Indicates whether access to this account is restricted to specific users. |
| bank_account_verified_on | TIMESTAMP_NTZ | Date and time the bank account was verified. |
| created_on | TIMESTAMP_NTZ | Date and time the record was created. |
| created_by_id | UUID | Unique identifier of the user who created the record. |
| modified_on | TIMESTAMP_NTZ | Date and time the record was last modified. |
| modified_by_id | UUID | Unique identifier of the user who last modified the record. |
| is_deleted | BOOLEAN | Indicates whether the record has been soft-deleted. |