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. |