GL Account

Prev Next

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 for step-by-step instructions.

Column reference

Column

Type

Description

tenant_id

NUMBER(38,0)

Customer's account identifier within the R365 platform.

id

VARCHAR

The unique identifier for the GL account.

account_number

VARCHAR

General ledger account number.

gl_account_name

VARCHAR

Display name of the general ledger account.

balance

NUMBER(38,4)

The current balance of the GL account.

balance_base

NUMBER(38,4)

The base currency balance of the GL account.

is_available_to_managers

BOOLEAN

Indicates if the account is available to managers.

is_bank_account

BOOLEAN

Indicates if this is a bank account.

default_budget_amount

NUMBER(38,10)

The default budget amount for this account.

cash_flow_category

NUMBER(38,0)

The cash flow category for this account.

description

VARCHAR

Description of the GL account.

is_entry_disabled

BOOLEAN

Indicates if manual entries are disabled for this account.

last_reconciled_balance

NUMBER(38,4)

The balance at last reconciliation.

last_reconciled_balance_base

NUMBER(38,4)

The base currency balance at last reconciliation.

last_reconciled_date

TIMESTAMP_NTZ

The date of last reconciliation.

operational_report_category

NUMBER(38,0)

A numeric operational report category code for the account. No R365 account screen sets it; the category shown in R365 as Operational Reports Category is in special_category.

is_retained_earnings

BOOLEAN

Indicates if this is a retained earnings account.

special_category

NUMBER(38,0)

The operational reporting category assigned to this account (shown as 'Operational Reports Category' in R365). It groups the account into sales, cost of goods sold, labor or other key controllable lines used by operational reports. Blank or 0 means no category.

parent_account

VARCHAR

Parent account ID for hierarchical accounts.

subtype

VARCHAR

The subtype of the GL account.

account_type

VARCHAR

The type of the GL account.

legal_entity

VARCHAR

The legal entity associated with the account.

location_id

VARCHAR

The default location identifier for the account.

is_deposit_only

BOOLEAN

Indicates if the account is deposit only.

is_second_signature_required

BOOLEAN

Indicates if a second signature is required.

second_signature_threshold

NUMBER(38,2)

Amount threshold requiring second signature.

budget_amount

NUMBER(38,2)

The budgeted amount for this account.

bank_account_type

NUMBER(38,0)

Type of bank account (checking, savings, etc.).

is_statistical_account

BOOLEAN

Indicates if this is a statistical account.

statistical_balance_type

NUMBER(38,0)

Balance type for statistical accounts.

statistical_direction

NUMBER(38,0)

Direction indicator for statistical accounts (better/worse).

is_control_account

BOOLEAN

Indicates if this is a control account.

outstanding_debits

NUMBER(38,4)

Total outstanding debit amounts.

outstanding_credits

NUMBER(38,4)

Total outstanding credit amounts.

current_balance

NUMBER(38,4)

Current account balance.

is_restricted_access

BOOLEAN

Indicates if access is restricted.

created_on

TIMESTAMP_NTZ

Timestamp when the record was created.

created_by_id

VARCHAR

Identifier of the user who created the record.

modified_on

TIMESTAMP_NTZ

Timestamp when the record was last modified.

modified_by_id

VARCHAR

Identifier of the user who last modified the record.

is_deleted

BOOLEAN

Flag indicating whether the record is currently deleted. Derived from the latest event for the entity.