Legal entities (companies) within the customer's organization, with one row per legal entity.
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 | Unique identifier for the legal entity. |
name | VARCHAR | Display name of the legal entity (business unit). |
number | VARCHAR | Number that identifies the legal entity. Required when the legal entity is set up. |
phone | VARCHAR | Primary phone number on record for the legal entity. |
address1 | VARCHAR | Primary street address line for the legal entity. |
address2 | VARCHAR | Secondary address line (such as suite or floor) for the legal entity. |
city | VARCHAR | City in which the legal entity is registered. |
state | VARCHAR | State or province in which the legal entity is registered. |
zip | VARCHAR | ZIP or postal code for the legal entity's registered address. |
closed_date | TIMESTAMP_NTZ | Latest period end date for which the legal entity is closed. |
due_from_account_id | VARCHAR | Identifier for the due from account. |
due_to_account_id | VARCHAR | Identifier for the due to account. |
payroll_check_account_id | VARCHAR | Identifier for the payroll check account. |
is_tip_earning_included_in_payroll_export | BOOLEAN | Flag indicating tip earning included in payroll export report. |
is_payroll_common_payer | BOOLEAN | Flag indicating whether or not this legal entity is the common payer for other legal entities. |
is_tax_form_1099_common_payer | BOOLEAN | Flag indicating whether or not this legal entity is the common payer for 1099 tax forms. |
display_name_on_check | VARCHAR | Alternate name for the legal entity that prints on R365 Payments checks and check stubs in place of the default legal entity name. Optional. |
payroll_check_printing_grouping_key | NUMBER(38,0) | Setting that controls how payroll checks are grouped when a paycheck run is created: by legal entity or by location. |
is_primary_reporting_entity | BOOLEAN | Flag indicating primary reporting entity status. |
default_checking_account_id | VARCHAR | Identifier for the default checking account. |
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_active | BOOLEAN | Indicates whether the legal entity is active (true) or inactive (false). |
is_deleted | BOOLEAN | Indicates whether this legal entity has been deactivated and is no longer in active use. |