Location

Prev Next

Restaurant and catering locations with their operational configuration, account mappings, and reporting settings, with one row per location.

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

name

VARCHAR

Display name of the restaurant location.

is_pos_auto_import_enabled

BOOLEAN

Flag indicating whether POS auto import is enabled.

catering_name

VARCHAR

Name for the catering location.

city

VARCHAR

City in which the restaurant location operates.

state

VARCHAR

State or province in which the restaurant location operates.

address1

VARCHAR

Primary street address line for the restaurant location.

address2

VARCHAR

Secondary address line (such as suite or unit) for the restaurant location.

postal_code

VARCHAR

ZIP or postal code for the restaurant location.

close_time

NUMBER(38,0)

A whole-number code for the location's closing time, picked from a fixed drop-down list in older R365 location setup. It is not a clock time, and the meaning of each number is not published. Current opening and closing hours are kept in the separate location hours setting.

closing_time

TIMESTAMP_NTZ

Not currently used by R365. Current opening and closing hours are kept in the location's operating hours setting.

daily_manager_salary_estimate_amount

NUMBER(38,4)

Amount for the daily manager salary estimate.

daily_target_avg_check

NUMBER(38,2)

Target average check amount for the location for a day, set on the location's Goals tab.

is_deposited_on_friday

BOOLEAN

Flag indicating deposited on friday status.

is_deposited_on_monday

BOOLEAN

Flag indicating deposited on monday status.

is_deposited_on_saturday

BOOLEAN

Flag indicating deposited on saturday status.

is_deposited_on_sunday

BOOLEAN

Flag indicating deposited on sunday status.

is_deposited_on_thursday

BOOLEAN

Flag indicating deposited on thursday status.

is_deposited_on_tuesday

BOOLEAN

Flag indicating deposited on tuesday status.

is_deposited_on_wednesday

BOOLEAN

Flag indicating deposited on wednesday status.

fax

VARCHAR

Fax number on record for the location (optional).

is_based_on_financial_status

BOOLEAN

Which measure the location's status is based on, as set in 'Status Based On' in location setup: false means Sales, true means Labor. New locations are set up as Sales; where the value is blank, R365's location list shows Labor.

labor_goal

NUMBER(38,10)

Goal for the labor.

labor_goal_sunday

NUMBER(38,10)

Labor goal for Sunday.

labor_goal_monday

NUMBER(38,10)

Labor goal for Monday.

labor_goal_tuesday

NUMBER(38,10)

Labor goal for Tuesday.

labor_goal_wednesday

NUMBER(38,10)

Labor goal for Wednesday.

labor_goal_thursday

NUMBER(38,10)

Labor goal for Thursday.

labor_goal_friday

NUMBER(38,10)

Labor goal for Friday.

labor_goal_saturday

NUMBER(38,10)

Labor goal for Saturday.

payroll_tax_estimate

NUMBER(38,10)

Payroll tax estimate percentage.

payroll_other_estimate

NUMBER(38,10)

Payroll other estimate percentage.

payroll_benefit_estimate

NUMBER(38,10)

Payroll benefit estimate percentage.

location_number

VARCHAR

Short reference code assigned to the restaurant location.

start_date

TIMESTAMP_NTZ

Date for the start.

is_weekly_journal_entry

BOOLEAN

Flag indicating weekly journal entry status.

concept_name

VARCHAR

Name for the concept.

location_manager

VARCHAR

Identifier of the employee assigned as primary manager of the location (an employee ID, not a name). This person receives notifications for employee schedule requests. Blank when no manager is assigned.

accounts_payable_account_id

VARCHAR

Identifier for the accounts payable account.

cash_account_id

VARCHAR

Identifier for the cash account.

cash_offset_account_id

VARCHAR

Identifier for the cash offset account.

credit_expected_account_id

VARCHAR

Identifier for the credit expected account.

manager_payroll_account_id

VARCHAR

Identifier for the manager payroll account.

over_short_account_id

VARCHAR

Identifier for the over short account.

payroll_benefit_estimate_account_id

VARCHAR

Identifier for the payroll benefit estimate account.

payroll_estimate_offset_account_id

VARCHAR

Identifier for the payroll estimate offset account.

payroll_other_estimate_account_id

VARCHAR

Identifier for the payroll other estimate account.

payroll_tax_estimate_account_id

VARCHAR

Identifier for the payroll tax estimate account.

petty_cash_account_id

VARCHAR

Identifier for the petty cash account.

tips_payable_account_id

VARCHAR

Identifier for the tips payable account.

legal_entity_id

VARCHAR

Unique identifier for the legal entity (business unit) that this location belongs to.

default_budget_id

VARCHAR

Identifier for the default budget.

pos_system

VARCHAR

Name of the POS system used at the location.

pos_import_start

TIMESTAMP_NTZ

Date on which the POS integration starts importing daily sales summary data for the location. Data from before this date is not imported.

comp_start_date

TIMESTAMP_NTZ

Date for the comp start.

comp_end_date

TIMESTAMP_NTZ

Date for the comp end.

location_category1

VARCHAR

Custom grouping attribute 1 assigned to the location (organization-defined).

location_category2

VARCHAR

Custom grouping attribute 2 assigned to the location (organization-defined).

location_category3

VARCHAR

Custom grouping attribute 3 assigned to the location (organization-defined).

location_category4

VARCHAR

Custom grouping attribute 4 assigned to the location (organization-defined).

location_category5

VARCHAR

Custom grouping attribute 5 assigned to the location (organization-defined).

location_category6

VARCHAR

Custom grouping attribute 6 assigned to the location (organization-defined).

location_category7

VARCHAR

Custom grouping attribute 7 assigned to the location (organization-defined).

location_category8

VARCHAR

Custom grouping attribute 8 assigned to the location (organization-defined).

location_category9

VARCHAR

Custom grouping attribute 9 assigned to the location (organization-defined).

location_category10

VARCHAR

Custom grouping attribute 10 assigned to the location (organization-defined).

is_credit_card_tips_taxed

BOOLEAN

Flag indicating whether credit card tips are taxed.

name_on_check

VARCHAR

Alternate name for the location that prints on R365 Payments checks and check stubs in place of the default location name. Optional.

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.