Daily Sales Summary

Prev Next

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.