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 | INTEGER | Unique identifier of the R365 tenant account. |
id | VARCHAR | Unique identifier for the daily sales summary record. |
name | VARCHAR | Name of the daily sales summary record. |
100_bills | INTEGER | Count of $100 bills counted during the daily close. |
50_bills | INTEGER | Count of $50 bills counted during the daily close. |
20_bills | INTEGER | Count of $20 bills counted during the daily close. |
10_bills | INTEGER | Count of $10 bills counted during the daily close. |
5_bills | INTEGER | Count of $5 bills counted during the daily close. |
2_bills | INTEGER | Count of $2 bills counted during the daily close. |
1_bills | INTEGER | Count of $1 bills counted during the daily close. |
approval_status | INTEGER | Approval status of the daily sales summary. NULL, 0, or 1 = not approved; 2 = approved. |
average_check | NUMBER | Average check amount for the day. |
average_check_prior_year | NUMBER | Average check amount for the same day in the prior year. |
cash_check_coin | NUMBER | Total cash, checks, and coins counted during the daily close. |
cash_payment_amount | NUMBER | Total amount of cash payments received. |
cash_payment_count | INTEGER | Number of cash payment transactions. |
closing_status | INTEGER | Closing status indicator. Not currently used. |
comp_payment_amount | NUMBER | Total amount of complimentary (comp) payments. |
comp_payment_count | INTEGER | Number of complimentary payment transactions. |
coupon_payment_amount | NUMBER | Total amount of coupon payments. |
coupon_payment_count | INTEGER | Number of coupon payment transactions. |
credit_card_payment_amount | NUMBER | Total amount of credit card payments received. |
credit_card_payment_count | INTEGER | Number of credit card payment transactions. |
current_year_date | TIMESTAMP_NTZ | Current year date reference. Not populated. |
daily_comment | VARCHAR | Free-text comment for the day. Not populated. |
date | TIMESTAMP_NTZ | Business date for this daily sales summary record. |
is_deposited | BOOLEAN | Indicates whether the deposit has been completed. Not populated. |
discount_payment_amount | NUMBER | Total amount of discounts applied. |
discount_payment_count | INTEGER | Number of discount transactions. |
dss_type | INTEGER | Daily sales summary type indicator. Not populated. |
gift_card_payment_amount | NUMBER | Total amount of gift card payments received. |
gift_card_payment_count | INTEGER | Number of gift card payment transactions. |
guest_count | INTEGER | Number of guests served during the business day. |
guest_count_prior_year | INTEGER | Number of guests served on the same day in the prior year. |
house_account_payment_amount | NUMBER | Total amount of house account payments received. |
house_account_payment_count | INTEGER | Number of house account payment transactions. |
journal_entry_adjustment | NUMBER | Journal entry adjustment amount. Always 0. |
labor_goal | INTEGER | Target labor cost percentage for the location on this day. |
labor_overtime_amount | NUMBER | Total dollar amount of overtime labor. |
labor_other_amount | NUMBER | Labor amount from other categories, already included in total labor. |
labor_other_hours | NUMBER | Hours from other labor categories. |
labor_overtime_hours | NUMBER | Total hours of overtime worked. |
labor_percent | INTEGER | Actual labor cost as a percentage of net sales. |
labor_regular_amount | NUMBER | Total dollar amount of regular (non-overtime) labor. |
labor_regular_hours | NUMBER | Total regular hours worked. |
net_sales | NUMBER | Total net sales for the day, after discounts and comps. |
non_cash_tips | NUMBER | Total tips received through non-cash payment methods. |
over_short | NUMBER | Difference between expected and actual cash at close. |
paid_out_total | NUMBER | Total amount of paid-outs from the register. |
payroll_approved | BOOLEAN | Indicates whether the labor records for this day have been approved. |
pay_tips_with_payroll | BOOLEAN | Indicates whether tips for this day are paid through payroll. |
petty_cash | NUMBER | Total petty cash transactions for the day. |
petty_cash_in_daily_close | BOOLEAN | Indicates whether petty cash is included in the daily close. |
pia_payment_amount | NUMBER | Total amount of paid-in-advance payments. |
pia_payment_count | INTEGER | Number of paid-in-advance payment transactions. |
pos_cash_coin_check_total | NUMBER | Total cash, coin, and check amount reported by the POS system. |
pos_cash_minus_paid_out | NUMBER | POS cash total minus paid-out amounts. |
r365_operations_import_version | VARCHAR | Version of the R365 operations import that created this record. Not populated. |
review_comments | VARCHAR | Comments entered during the daily review. Not populated. |
sales_percent_of_last_year | NUMBER | Net sales as a percentage of the same day's net sales in the prior year. |
tips_paid_with_petty_cash | NUMBER | Total tips paid to employees from petty cash. |
total_100_bills | NUMBER | Total value of $100 bills. Always 0. |
total_10_bills | NUMBER | Total value of $10 bills. Always 0. |
total_1_bills | NUMBER | Total value of $1 bills. Always 0. |
total_20_bills | NUMBER | Total value of $20 bills. Always 0. |
total_2_bills | NUMBER | Total value of $2 bills. Always 0. |
total_50_bills | NUMBER | Total value of $50 bills. Always 0. |
total_5_bills | NUMBER | Total value of $5 bills. Always 0. |
total_cash | NUMBER | Total cash value. Always 0. |
total_cash_coin | NUMBER | Total cash and coin counted during the daily close. |
total_checks | NUMBER | Total value of checks received. |
total_coin | NUMBER | Total value of coins counted during the daily close. |
total_deposit | NUMBER | Total amount deposited for the day. |
total_labor | NUMBER | Total labor cost for the day. Blank when labor has not been calculated. |
total_non_cash_tender | NUMBER | Total non-cash tender amount. Not used. |
total_sales | NUMBER | Total gross sales before discounts and comps. |
total_tender | NUMBER | Total tender amount. Always 0. |
unpaid_cash_tips | NUMBER | Total cash tips that have not yet been paid to employees. |
void_payment_amount | NUMBER | Total amount of voided transactions. |
void_payment_count | INTEGER | Number of voided transactions. |
closing_employee_id | VARCHAR | Unique identifier of the employee who closed the day. Not populated. |
fiscal_date | VARCHAR | Fiscal date for this record. Not populated. |
journal_entry_id | VARCHAR | Unique identifier of the associated journal entry. Not populated. |
legal_entity_id | VARCHAR | Unique identifier of the legal entity for this location. |
location_id | VARCHAR | Unique identifier of the location. |
daily_manager_salary | NUMBER | Estimated daily manager salary allocated to this day. |
deposit_1 | NUMBER | First deposit amount for the day. |
deposit_2 | NUMBER | Second deposit amount for the day. |
deposit_3 | NUMBER | Third deposit amount for the day. |
deposit_4 | NUMBER | Fourth deposit amount for the day. |
deposit_5 | NUMBER | Fifth deposit amount for the day. |
total_labor_burdened | NUMBER | Total burdened labor cost including payroll taxes and benefits. |
labor_burdened | NUMBER | Burdened labor cost amount. |
labor_percent_burdened | NUMBER | Burdened labor cost as a percentage of net sales. |
declared_tips_total | NUMBER | Total tips declared by employees. |
payroll_tax_total | NUMBER | Total payroll tax for the day. Does not include sales tax. |
payroll_benefit_total | NUMBER | Total employee benefit costs allocated to this day. |
payroll_other_total | NUMBER | Total other payroll costs allocated to this day. |
same_day_last_year_gross_sales | NUMBER | Gross sales for the same day in the prior year. |
gross_sales | NUMBER | Total gross sales before any deductions. |
entree | NUMBER | Total entree sales amount. |
sales_count | INTEGER | Number of sales transactions. |
labor_count | INTEGER | Number of labor records for the day. |
paid_in_total | NUMBER | Total amount of paid-ins to the register. |
currency_exchange_rate | NUMBER | Currency exchange rate for this location. Returns 0 for US-dollar locations. |
total_transactions | NUMBER | Total number of transactions for the day. |
is_summary_sales | BOOLEAN | Indicates whether this record uses summary-level sales data. |
is_labor_complete | BOOLEAN | Indicates whether labor data entry is complete for this day. |
is_deposit_complete | BOOLEAN | Indicates whether the deposit is complete for this day. |
is_transaction_complete | BOOLEAN | Indicates whether transaction entry is complete for this day. |
steps_complete | BOOLEAN | Indicates whether all required daily close steps are complete. |
expected_cash_amount | NUMBER | Expected cash amount based on sales and payments. |
row_version | VARCHAR | Version identifier for this record, used for concurrency control. |
gift_card_sold_amount | NUMBER | Total value of gift cards sold during the day. |
completed_by | VARCHAR | Name of the user who completed the daily review. Blank when the day has not been reviewed. |
completed_on | TIMESTAMP_NTZ | Date and time the daily review was completed. |
is_labor_edited | BOOLEAN | Indicates whether labor data has been manually edited. Once set to true, remains true. |
labor_double_overtime_amount | NUMBER | Total dollar amount of double-overtime labor. |
labor_double_overtime_hours | NUMBER | Total hours of double-overtime worked. |
pay_taxes_on_credit_card_tips | BOOLEAN | Indicates whether payroll taxes apply to credit card tips. Not populated. |
source | INTEGER | Source of the daily sales data. 0 = Undefined, 1 = Import, 2 = Punch edit, 3 = Time clock, 4 = Time card, 5 = Employee merge. |
online_order_employee | VARCHAR | Employee associated with online orders. Currently empty. |
created_on | TIMESTAMP_NTZ | Date and time the record was created. |
created_by_id | VARCHAR | Unique identifier of the user who created the record. |
modified_on | TIMESTAMP_NTZ | Date and time the record was last modified. |
modified_by_id | VARCHAR | Unique identifier of the user who last modified the record. |
sales_detail_count | INTEGER | Number of sales detail records for this day. |
sales_payment_count | INTEGER | Number of sales payment records for this day. |
ticket_net_sales | NUMBER | Total net sales at the ticket level. |
ticket_gross_sales | NUMBER | Total gross sales at the ticket level. |
is_deleted | BOOLEAN | Indicates whether the record has been soft-deleted. |