Data Dictionary

Prev Next
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
Brands and brand concepts associated with the customer's account, with one row per active brand. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column reference ...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
Fiscal calendar definitions for each legal entity, with one row per calendar date per legal entity. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column reference ...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
Daily sales, labor, tender, and close data for each location, with one row per business date per location. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column refe...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
GL accounts in the customer's chart of accounts, with one row per account. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column reference
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
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 ...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
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-...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
POS-to-GL account mappings for sales categories, payment types, jobs, and paid-outs, with one row per mapping. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column ...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
Customer accounts (tenants) on the R365 platform, with one row per account and its current instance name. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column refe...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
Financial transactions including AP invoices, AP payments, AR invoices, and journal entries, with one row per transaction. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructio...
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
Line-item detail rows for each financial transaction, with one row per transaction line. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column reference
  • Updated on Oct 27, 2026
  • Published on Oct 27, 2026
R365 user accounts and access settings, with one row per user. Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions. Column reference