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) | Unique identifier of the R365 tenant account. |
id | UUID | Unique identifier for the location. |
name | VARCHAR | Name of the location. |
location_number | VARCHAR | User-defined number for the location. |
address1 | VARCHAR | First line of the location's address. |
address2 | VARCHAR | Second line of the location's address. |
city | VARCHAR | City of the location's address. |
state | VARCHAR | State or province of the location's address. |
postal_code | VARCHAR | ZIP or postal code of the location's address. |
fax | VARCHAR | Fax number for the location. |
catering_name | VARCHAR | Name used for the location's catering operations. |
concept_name | VARCHAR | Name of the restaurant concept associated with this location. |
location_manager | VARCHAR | Name of the location manager. |
name_on_check | VARCHAR | Name printed on checks issued by this location. |
pos_system | VARCHAR | POS system used by this location. |
start_date | DATE | Date the location opened or began operating. |
comp_start_date | DATE | Start date for comparable-period sales reporting. |
comp_end_date | DATE | End date for comparable-period sales reporting. |
pos_import_start | DATE | Date from which POS data imports begin for this location. |
close_time | TIME | Time the location closes. |
closing_time | TIME | Closing time used for daily sales summary calculations. |
is_pos_auto_import_enabled | BOOLEAN | Indicates whether automatic POS data import is enabled for this location. |
is_weekly_journal_entry | BOOLEAN | Indicates whether this location generates weekly journal entries instead of daily. |
is_based_on_financial_status | BOOLEAN | Indicates whether this location's reporting is based on financial status. |
daily_manager_salary_estimate_amount | NUMBER | Estimated daily manager salary allocated to this location. |
daily_target_avg_check | NUMBER | Target average check amount per guest for this location. |
labor_goal | NUMBER | Target labor cost percentage for this location. |
payroll_tax_estimate | NUMBER | Estimated payroll tax amount per period for this location. |
payroll_other_estimate | NUMBER | Estimated other payroll costs per period for this location. |
payroll_benefit_estimate | NUMBER | Estimated employee benefit costs per period for this location. |
day_part1_name | VARCHAR | Name of day part 1 (e.g., Breakfast, Lunch). |
day_part2_name | VARCHAR | Name of day part 2. |
day_part3_name | VARCHAR | Name of day part 3. |
day_part4_name | VARCHAR | Name of day part 4. |
day_part5_name | VARCHAR | Name of day part 5. |
day_part6_name | VARCHAR | Name of day part 6. |
day_part1_avg_check_goal | NUMBER | Target average check amount for day part 1. |
day_part2_avg_check_goal | NUMBER | Target average check amount for day part 2. |
day_part3_avg_check_goal | NUMBER | Target average check amount for day part 3. |
day_part4_avg_check_goal | NUMBER | Target average check amount for day part 4. |
day_part5_avg_check_goal | NUMBER | Target average check amount for day part 5. |
day_part6_avg_check_goal | NUMBER | Target average check amount for day part 6. |
day_part1_start_time | TIME | Start time for day part 1. |
day_part2_start_time | TIME | Start time for day part 2. |
day_part3_start_time | TIME | Start time for day part 3. |
day_part4_start_time | TIME | Start time for day part 4. |
day_part5_start_time | TIME | Start time for day part 5. |
day_part6_start_time | TIME | Start time for day part 6. |
is_deposited_on_sunday | BOOLEAN | Indicates whether deposits are made on Sundays for this location. |
is_deposited_on_monday | BOOLEAN | Indicates whether deposits are made on Mondays for this location. |
is_deposited_on_tuesday | BOOLEAN | Indicates whether deposits are made on Tuesdays for this location. |
is_deposited_on_wednesday | BOOLEAN | Indicates whether deposits are made on Wednesdays for this location. |
is_deposited_on_thursday | BOOLEAN | Indicates whether deposits are made on Thursdays for this location. |
is_deposited_on_friday | BOOLEAN | Indicates whether deposits are made on Fridays for this location. |
is_deposited_on_saturday | BOOLEAN | Indicates whether deposits are made on Saturdays for this location. |
labor_goal_sunday | NUMBER | Target labor cost percentage for Sundays at this location. |
labor_goal_monday | NUMBER | Target labor cost percentage for Mondays at this location. |
labor_goal_tuesday | NUMBER | Target labor cost percentage for Tuesdays at this location. |
labor_goal_wednesday | NUMBER | Target labor cost percentage for Wednesdays at this location. |
labor_goal_thursday | NUMBER | Target labor cost percentage for Thursdays at this location. |
labor_goal_friday | NUMBER | Target labor cost percentage for Fridays at this location. |
labor_goal_saturday | NUMBER | Target labor cost percentage for Saturdays at this location. |
accounts_payable_account_id | UUID | Unique identifier of the accounts payable GL account for this location. |
cash_account_id | UUID | Unique identifier of the cash GL account for this location. |
cash_offset_account_id | UUID | Unique identifier of the cash offset GL account for this location. |
credit_expected_account_id | UUID | Unique identifier of the credit expected GL account for this location. |
manager_payroll_account_id | UUID | Unique identifier of the manager payroll GL account for this location. |
over_short_account_id | UUID | Unique identifier of the over/short GL account for this location. |
payroll_benefit_estimate_account_id | UUID | Unique identifier of the GL account for payroll benefit estimates. |
payroll_estimate_offset_account_id | UUID | Unique identifier of the GL account for payroll estimate offsets. |
payroll_other_estimate_account_id | UUID | Unique identifier of the GL account for other payroll estimates. |
payroll_tax_estimate_account_id | UUID | Unique identifier of the GL account for payroll tax estimates. |
petty_cash_account_id | UUID | Unique identifier of the petty cash GL account for this location. |
tips_payable_account_id | UUID | Unique identifier of the tips payable GL account for this location. |
legal_entity_id | UUID | Unique identifier of the legal entity this location belongs to. |
default_budget_id | UUID | Unique identifier of the default budget assigned to this location. |
location_category_1 | VARCHAR | User-defined category label 1 for this location, used for reporting and filtering. |
location_category_2 | VARCHAR | User-defined category label 2 for this location. |
location_category_3 | VARCHAR | User-defined category label 3 for this location. |
location_category_4 | VARCHAR | User-defined category label 4 for this location. |
location_category_5 | VARCHAR | User-defined category label 5 for this location. |
location_category_6 | VARCHAR | User-defined category label 6 for this location. |
location_category_7 | VARCHAR | User-defined category label 7 for this location. |
location_category_8 | VARCHAR | User-defined category label 8 for this location. |
location_category_9 | VARCHAR | User-defined category label 9 for this location. |
location_category_10 | VARCHAR | User-defined category label 10 for this location. |
created_on | TIMESTAMP_NTZ | Date and time the record was created. |
created_by_id | UUID | Unique identifier of the user who created the record. |
modified_on | TIMESTAMP_NTZ | Date and time the record was last modified. |
modified_by_id | UUID | Unique identifier of the user who last modified the record. |
is_deleted | BOOLEAN | Indicates whether the record has been soft-deleted. |