Data Dictionary

Table of contents:

• Data model: wide_order
• Data model: wide_order_item
• Data model: wide_order_item_modifier
• Data model: wide_combo_order_item
• Data model: wide_payment
• Data model: wide_labor
• Data model: wide_schedule
• Data model: wide_liability_transaction
• Data model: wide_service_fee
• Data model: wide_tax
• Data model: fact_till
• Data model: fact_till_operations

Notes:
Every query statement execution time is limited to 15 minutes or 15K row limit. If execution time exceeds this limit, the query is canceled.

The meaning behind a few phrases:

• xxx_price : the amount of money that has to be paid to acquire a given product;
• xxx_amount : the entire amount of money that was paid for a particular measure, e.g. gross_amount : sum of all the components;
• xxx_cost : the costs of the product/modifier that are incurred to create a product/modifier.