Legal Entity

Prev Next

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.