Data model: wide_combo_order

Resource	Data type	Mode	Description	Example
order_id	int4	Required	Unique ID for an Order	5
order_created_at	timestamp	Required	Order creation date and time in UTC format.	2018-11-08 16:37:41
order_updated_at	timestamp	Required	Order last update date and time in UTC format	2018-11-08 16:45:36
created_by_employee_first_name	varchar	'N/A'	First name of employee who created an order. If order wasn’t created by employee, then value is `N/A`	John
created_by_employee_last_name	varchar	'N/A'	Last name of employee who created an order. If order wasn’t created by employee, then value is `N/A`	Doe
created_by_employee_is_active	bool	Nullable	Identification of whether employee is active. If order wasn’t created by employee, then value is `NULL`	TRUE
last_updated_by_employee_first_name	varchar	'N/A'	First name of last employee who updated an order. If order wasn’t updated by employee, then value is `N/A`	John
last_updated_by_employee_last_name	varchar	'N/A'	Last name of last employee who created an order. If order wasn’t created by employee, then value is `N/A`	Doe
last_updated_by_employee_is_active	bool	Nullable	Identification of whether employee is active. If order wasn’t updated by employee, then value is `NULL`	TRUE
order_source	varchar	Required ‘Unknown’	Source channel of the order or pos mode if applicable: Web Order Smart Order Table service Quick service Retail Kiosk Pizza Grocery Donation Gas station	Quick Service
order_option	varchar	Required ‘Unknown’	Identification of order option, e.g. To-Go, Eat-In, Delivery, etc. If it is custom order option, then value is `Custom`. If it is not recognised it is `Unknown`	To Go
order_status	varchar	Required	Status of the order	Closed
is_order_paid	bool	Required	Order payment status.	TRUE
combo_order_item_id	int4	Required	Unique ID of a combo order item	3
product_name_override	varchar	‘N/A’	Overriden product name	Ice Cream Gift
unit_price	numeric	Required	Unit price of the product in the order. It does not include price for modifiers or combos, monetary value.	7.000000
unit_cost	numeric	Required	Unit cost of the product	4.000000
unit_of_measure	varchar	'N/A'	Unit, weighted, etc.	Unit
quantity	int4	Required	Number of ordered products(s)	1
weight	float	Nullable	Number of weight for the product, which is weighted. unit_of_measure contains types of data, e.g. Oz.	7.0
total_price	numeric	Required	Total price for the products(s) in the Order, monetary value. Formula: unit price + modifiers_amount + combo_savings_amount * quantity	11.600000
total_cost	numeric	Required	Total costs for the item(s) in the Order, monetary value. Formula: unit cost + modifier cost * quantity	3.000000
modifiers_amount	numeric	Required	Total amount of all the modifiers of single product, monetary value.	1.600000
modifiers_cost	numeric	Required	Total cost of all the modifiers of single product, monetary value.	0.170000
combo_savings_amount	numeric	Required	Amount, which is saved by the customer using combo, monetary value.	14.200000
is_valid_record	bool	Required	Identifies, if a record is valid and should be trusted or not.	TRUE
product_id	int4	Nullable	Unique ID of the product.	102
product_sku	varchar	‘N/A’	Unique SKU of the product. At least 4 characters.	AB123
product_name	varchar	‘N/A’	Name of the product Always reflects the newest name If product_id is NULL then manually entered product name will be shown.	Beef Sandwich
is_product_active	bool	Nullable	Identification if product is active, e.g. TRUE or FALSE.	TRUE
category_name	varchar	‘N/A’	Product category	Salad
is_category_active	bool	Nullable	Identification if product’s category is active, e.g. TRUE or FALSE.	TRUE
sub_category_name	varchar	‘N/A’	Product sub-category.	Hot Salad
is_sub_category_active	bool	Nullable	Identification if product’s sub-category is active, e.g. TRUE or FALSE.	TRUE
product_class_name	varchar	‘N/A’	Product class name	Drinks
is_product_class_active	bool	Nullable	Identification if product’s class is active, e.g. TRUE or FALSE.	TRUE
combo_shell_product_id	varchar	‘N/A’	Unique ID of the combo shell product.	132
combo_shell_product_sku	varchar	‘N/A’	Unique SKU of a combo shell product. At least 4 characters.	ZC123
combo_shell_product_name	varchar	‘N/A’	Name of the combo shell product It always reflects the newest name if product_id is NULL then manually entered product name will be shown.	Sandwich + Drink
product_group_name_list	varchar	‘N/A’	List of product’s group names.	\|Product Group A\|
establishment_id	int4	Required	Establishment unique Key	1
establishment_name	varchar	Required	Establishment Name	Company-1
company_name	varchar	Required	Company name	Company
company_url	varchar	Required	Company url address	company.revelup.com
establishment_country	varchar	Required	Establishment Country	US
establishment_state	varchar	'N/A'	Establishment State.	GA
establishment_city	varchar	Required	Establishment City.	Atlanta
establishment_latitude	float	Nullable	Establishment Latitude	34.6843294
establishment_longitude	float	Nullable	Establishment Longitude	-86.4109566
establishment_post_code	varchar	Required	Establishment Post Code	30314
is_establishment_active	bool	Required	Identification if establishment is active, e.g. TRUE or FALSE.	TRUE
establishment_group_name_list	varchar	Required	List of establishment’s group names	\|Group1\|Group2
timezone	varchar	Required	The configured timezone of the establishment	US/Eastern
establishment_division	varchar	'N/A'	Establishment division. If establishment does not belong to a division, then value is `N/A`.	Division - 1
establishment_sub_division	varchar	'N/A'	Establishment sub-division. If establishment does not belong to a sub-division, then value is `N/A`.	Sub-division - 1