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 reference
Column | Type | Description |
|---|---|---|
tenant_id | NUMBER(38,0) | Customer's account identifier within the R365 platform. |
id | VARCHAR | Daily sales summary id. |
name | VARCHAR | Name describing the DSS including location and date. |
100_bills | NUMBER(38,0) | Count of $100 bills. |
50_bills | NUMBER(38,0) | Count of $50 bills. |
20_bills | NUMBER(38,0) | Count of $20 bills. |
10_bills | NUMBER(38,0) | Count of $10 bills. |
5_bills | NUMBER(38,0) | Count of $5 bills. |
2_bills | NUMBER(38,0) | Count of $2 bills. |
1_bills | NUMBER(38,0) | Count of $1 bills. |
approval_status | NUMBER(38,0) | Approval status: NULL/0/1 = not approved, 2 = approved. |
average_check | NUMBER(38,2) | Average check amount. |
average_check_prior_year | NUMBER(38,2) | Average check amount prior year. |
cash_check_coin | NUMBER(38,2) | Cash, check, and coin total. |
cash_payment_amount | NUMBER(38,2) | Total amount of cash payments for the day. |
cash_payment_count | NUMBER(38,0) | Number of cash payments for the day. |
closing_status | NUMBER(38,0) | Not currently used. Empty on every row, and no list of status values exists. |
comp_payment_amount | NUMBER(38,2) | Complimentary payment amount. |
comp_payment_count | NUMBER(38,0) | Complimentary payment count. |
coupon_payment_amount | NUMBER(38,2) | Total amount of coupon payments for the day. |
coupon_payment_count | NUMBER(38,0) | Number of coupon payments for the day. |
credit_card_payment_amount | NUMBER(38,2) | Total amount of credit card payments for the day. |
credit_card_payment_count | NUMBER(38,0) | Number of credit card payments for the day. |
current_year_date | TIMESTAMP_NTZ | Currently not populated: this column is empty on every row. |
daily_comment | VARCHAR | Currently not populated: this column is empty on every row. |
date | TIMESTAMP_NTZ | Business date the sales and labor occurred on. |
is_deposited | BOOLEAN | Currently not populated: this column is empty on every row. |
discount_payment_amount | NUMBER(38,2) | Total amount of discount payments for the day. |
discount_payment_count | NUMBER(38,0) | Number of discount payments for the day. |
dss_type | NUMBER(38,0) | Currently not populated: this column is empty on every row. |
gift_card_payment_amount | NUMBER(38,2) | Total amount of gift card payments for the day. |
gift_card_payment_count | NUMBER(38,0) | Number of gift card payments for the day. |
guest_count | NUMBER(38,0) | Total count of guests served. |
guest_count_prior_year | NUMBER(38,0) | Total count of guests served prior year. |
house_account_payment_amount | NUMBER(38,2) | Total amount of house account payments for the day. |
house_account_payment_count | NUMBER(38,0) | Number of house account payments for the day. |
journal_entry_adjustment | NUMBER(38,4) | Currently not populated: this column is always 0. |
labor_goal | NUMBER(38,0) | Target labor cost percentage for the location on this day, taken from the location labor goal settings. |
labor_overtime_amount | NUMBER(38,4) | Cost of overtime labor for the day. |
labor_other_amount | NUMBER(38,4) | Labor cost for the day other than regular and overtime pay, mainly the manager's daily salary. It is already included in total labor, so do not add it to total labor. |
labor_other_hours | NUMBER(38,4) | Hours of labor other than regular and overtime hours for the day. |
labor_overtime_hours | NUMBER(38,4) | Hours of overtime labor for the day. |
labor_percent | NUMBER(38,0) | Total labor cost as a percentage of net sales for the day. |
labor_regular_amount | NUMBER(38,4) | Cost of regular (non-overtime) labor for the day. |
labor_regular_hours | NUMBER(38,4) | Hours of regular (non-overtime) labor for the day. |
net_sales | NUMBER(38,2) | Net sales after discounts, comps, and other adjustments. |
non_cash_tips | NUMBER(38,2) | Amount of tips for the day that were received by non-cash payment (for example added to card charges) rather than as cash. Blank when not reported. |
over_short | NUMBER(38,2) | Over/short amount. |
paid_out_total | NUMBER(38,2) | Total amount paid out. |
payroll_approved | BOOLEAN | Payroll approved status. |
pay_tips_with_payroll | BOOLEAN | Whether the location pays out tips through payroll. |
petty_cash | NUMBER(38,2) | Petty cash amount set for the location and copied onto each day, in dollars. It is used in the day's over/short figure. |
petty_cash_in_daily_close | BOOLEAN | Whether the location tracks petty cash as part of the daily close. When true, the deposit step includes petty cash fields. |
pia_payment_amount | NUMBER(38,2) | Dollars received as paid-ins for the day (money put in the register that is not a sale). Blank or 0 when there were none. |
pia_payment_count | NUMBER(38,0) | Number of paid-in transactions for the day. 0 or blank when there were none. |
pos_cash_coin_check_total | NUMBER(38,2) | Point of sale cash, coin, and check total. |
pos_cash_minus_paid_out | NUMBER(38,2) | Point of sale cash minus paid out. |
r365_operations_import_version | VARCHAR | Currently not populated: this column is empty on every row. |
review_comments | VARCHAR | Currently not populated: this column is empty on every row. |
sales_percent_of_last_year | NUMBER(38,4) | Percent change in net sales versus the same day last year (positive = up). Shown as 100 when there are no sales last year to compare against. |
tips_paid_with_petty_cash | NUMBER(38,2) | Amount of tips paid out of petty cash for the day. |
total_100_bills | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_10_bills | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_1_bills | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_20_bills | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_2_bills | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_50_bills | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_5_bills | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_cash | NUMBER(38,4) | Currently not populated: this column is always 0. |
total_cash_coin | NUMBER(38,2) | Total cash and coin. |
total_checks | NUMBER(38,2) | Total amount of checks included in the deposit. |
total_coin | NUMBER(38,2) | Total dollar amount of coin included in the deposit. |
total_deposit | NUMBER(38,2) | Total amount deposited for the day, calculated from the deposits entered or imported. |
total_labor | NUMBER(38,4) | Total labor cost for the day: regular, overtime and other labor (including the manager's daily salary). It does not include payroll tax, benefit or other burden estimates. Blank when labor has not been calculated for the day. |
total_non_cash_tender | NUMBER(38,4) | Not currently used. Nothing in R365 fills it in. |
total_sales | NUMBER(38,2) | Total sales for the day. |
total_tender | NUMBER(38,4) | Currently not populated: this column is always 0. |
unpaid_cash_tips | NUMBER(38,2) | Cash tips for the day that have not yet been paid out to employees. |
void_payment_amount | NUMBER(38,2) | Total amount of voided payments for the day. |
void_payment_count | NUMBER(38,0) | Number of voided payments for the day. |
closing_employee_id | VARCHAR | Currently not populated: this column is empty on every row. |
fiscal_date | VARCHAR | Currently not populated: this column is empty on every row. |
journal_entry_id | VARCHAR | Currently not populated: this column is empty on every row. |
legal_entity_id | VARCHAR | Identifier of the legal entity the location belongs to. |
location_id | VARCHAR | Identifier of the location the daily sales summary is for. |
daily_manager_salary | NUMBER(38,4) | Daily salaried manager labor cost included in the day's labor, as set on the location record. |
deposit_1 | NUMBER(38,2) | Dollar amount of the first deposit made for the day. |
deposit_2 | NUMBER(38,2) | Dollar amount of the second deposit made for the day. |
deposit_3 | NUMBER(38,2) | Dollar amount of the third deposit made for the day. |
deposit_4 | NUMBER(38,2) | Dollar amount of the fourth deposit made for the day. |
deposit_5 | NUMBER(38,2) | Dollar amount of the fifth deposit made for the day. |
total_labor_burdened | NUMBER(38,4) | Total labor cost for the day plus the estimated labor burden. |
labor_burdened | NUMBER(38,4) | Estimated labor burden for the day: payroll tax, benefit and other estimates applied to labor, using the location's percentage estimates. |
labor_percent_burdened | NUMBER(38,4) | Fully burdened labor cost (labor plus payroll tax, benefit and other estimates) as a percent of net sales for the day. It is 0 when net sales are 0 and blank when it was never calculated. |
declared_tips_total | NUMBER(38,2) | Total tips declared by employees for the day. |
payroll_tax_total | NUMBER(38,4) | Total employer payroll tax for the day. This is not sales tax. |
payroll_benefit_total | NUMBER(38,4) | Estimated employer payroll benefit cost for the day: the day's total labor cost times the location's Payroll Benefit % Estimate. It is 0 when the location has no benefit percentage set, and blank when labor has not been calculated. |
payroll_other_total | NUMBER(38,4) | Estimated other employer payroll cost for the day: the day's total labor cost times the location's Payroll Other % Estimate. It is 0 when the location has no such percentage set, and blank when labor has not been calculated. |
same_day_last_year_gross_sales | NUMBER(38,2) | Gross sales for the same fiscal day in the prior fiscal year. |
gross_sales | NUMBER(38,2) | Gross sales before deductions such as discounts or comps. |
entree | NUMBER(38,4) | Number of entree items sold for the day: sales lines for menu items marked as entrees, not counting voided lines. Blank when no entree items were counted. |
sales_count | NUMBER(38,0) | Number of sales tickets (checks) for the day. |
labor_count | NUMBER(38,0) | Number of labor records (punches or shifts) counted for the location and business day. |
paid_in_total | NUMBER(38,2) | Total amount of paid-ins for the day. A paid-in is money added to a safe or register for a particular purpose. |
currency_exchange_rate | NUMBER(38,4) | Exchange rate used to convert the location's local currency into the base currency (US dollars) for that day's imported figures. It is 0 for US-dollar locations. |
total_transactions | NUMBER(38,4) | Number of transactions (checks) for the day. |
is_summary_sales | BOOLEAN | True when the day's figures came from a daily summary import (totals only, with no individual checks or transactions) instead of detailed POS data. |
is_labor_complete | BOOLEAN | True when the labor step of the day's close-out has been marked complete. |
is_deposit_complete | BOOLEAN | True when the deposit step of the day's close-out has been marked complete. |
is_transaction_complete | BOOLEAN | True when the transactions step of the day's close-out has been marked complete. |
steps_complete | BOOLEAN | Whether all required DSS review steps have been completed. |
expected_cash_amount | NUMBER(38,2) | Amount of cash the location is expected to have for the day, based on cash payments, paid-outs and paid-ins. Compare with the total deposit. |
row_version | VARCHAR | Row version used to track changes and updates to the record over time. |
gift_card_sold_amount | NUMBER(38,2) | Total value of gift cards sold on the day. |
completed_by | VARCHAR | Identifier of the user who completed the operational review or approval of the day. Usually matches the id column in user_table, but some values have no matching row in the shared user table. Blank when the day was not reviewed. |
completed_on | TIMESTAMP_NTZ | Timestamp when the daily sales information was completed. |
is_labor_edited | BOOLEAN | True when labor for the day was edited by a person in R365 (for example a punch edit) after the labor was imported. Once true it stays true. |
labor_double_overtime_amount | NUMBER(38,4) | Pay cost of double-time labor for the day. Populated on very few rows, blank otherwise. |
labor_double_overtime_hours | NUMBER(38,4) | Hours of double-time labor for the day. Populated on very few rows, blank otherwise. |
pay_taxes_on_credit_card_tips | BOOLEAN | Currently not populated: this column is empty on every row. |
source | NUMBER(38,0) | Code for how the day's labor figures were last produced. 0 = Undefined, 1 = Import, 2 = Punch edit, 3 = Time clock, 4 = Time card, 5 = Employee merge. 1 is by far the most common. |
online_order_employee | VARCHAR | Identifier of the employee that online-order sales and tips are attributed to for tip distribution, as set on the location record. Currently empty on every row. |
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. |
sales_detail_count | NUMBER(38,0) | Number of sales detail records associated with this DSS. |
sales_payment_count | NUMBER(38,0) | Number of sales payment records associated with this DSS. |
ticket_net_sales | NUMBER(38,2) | Total net sales amount from the POS tickets. |
ticket_gross_sales | NUMBER(38,2) | Total gross sales amount from the POS tickets. |
is_deleted | BOOLEAN | Flag indicating whether the record is currently deleted. Derived from the latest event for the entity. |