The Location view is the restaurant location master dataset for R365. It contains address details, parent legal entity assignments, and custom category groupings for all locations in an organization.
Location Columns
column_name | data_type | description |
|---|---|---|
tenant_id | integer | Customer's account identifier within the R365 platform. |
legal_entity_id | UUID | Unique identifier for the legal entity (business unit) that this location belongs to. |
legal_entity_name | string | Display name of the legal entity (business unit) that this location belongs to. |
location_id | UUID | Unique identifier for the restaurant location. |
location_number | string | Short reference code assigned to the restaurant location. |
location_name | string | Display name of the restaurant location. |
location_category1 | UUID | Custom grouping attribute 1 assigned to the location (organization-defined). |
location_category2 | UUID | Custom grouping attribute 2 assigned to the location (organization-defined). |
location_category3 | UUID | Custom grouping attribute 3 assigned to the location (organization-defined). |
location_category4 | UUID | Custom grouping attribute 4 assigned to the location (organization-defined). |
location_category5 | UUID | Custom grouping attribute 5 assigned to the location (organization-defined). |
location_category6 | UUID | Custom grouping attribute 6 assigned to the location (organization-defined). |
location_category7 | UUID | Custom grouping attribute 7 assigned to the location (organization-defined). |
location_category8 | UUID | Custom grouping attribute 8 assigned to the location (organization-defined). |
location_category9 | UUID | Custom grouping attribute 9 assigned to the location (organization-defined). |
location_category10 | UUID | Custom grouping attribute 10 assigned to the location (organization-defined). |
address1 | string | Primary street address line for the restaurant location. |
address2 | string | Secondary address line (e.g., suite, unit) for the restaurant location. |
city | string | City in which the restaurant location operates. |
state | string | State or province in which the restaurant location operates. |
zip_code | string | ZIP or postal code for the restaurant location. |
is_deleted | boolean | Indicates whether this location has been deactivated and is no longer in active use. |