Data model: wide

Resource	Data type	Mode	Description	Example
payment_id	int4	Required	Unique ID for a payment	5
cc_customer_identifier	varchar	‘N\A’	Unique identifier of a customer. This identifier is made by hashing a combination of customer’s credit card first name, last name and last 4 digits.	f9627bb25f2f9e87beb92357594ed927
payment_type_name	varchar	‘N\A’	The way payment was made	Cash
card_type_name	varchar	‘N\A’	Type of card used in making payment	Mastercard
payment_amount	numeric	Required	Amount paid by customer, monetary value	75.200000
tip_amount	numeric	Required	Amount paid as tip, monetary value.	5.000000
transaction_status	varchar	‘N\A’	Status of the payment. E.g Pending, Accepted, Declined, Captured or Unidentified.	Pending
is_refund	bool	Required	Identification if payment is a refund.	False
payment_source_type	varchar	Required	Where payment came from. Could be Regular or House account.	Regular
payment_created_at	timestamp	Required	2018-11-08 16:37:41
payment_updated_at	timestamp	Required	Payment last update date and time in UTC format.	2018-11-08 16:45:36
order_id	int4	Required	Unique ID for an order	3
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	Web Order
order_option	varchar	Required ‘Unknown’	Identification of order option, e.g. To-Go, Eat-In, Delivery or 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	Identification if order is paid	TRUE
establishment_id	int4	Required	Establishment unique Key	1
establishment_name	varchar	Required	Establishment Name	Company-1
establishment_city	varchar	Required	Establishment City	Atlanta
establishment_state	varchar	'N\A'	Establishment State	GA
establishment_country	varchar	Required	Establishment Country	US
company_name	varchar	Required	Company name	Company
company_url	varchar	Required	Company url address	`company.revelup.com`
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\|Group3\|
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