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