Square

Explore the interactive ERD

Table & Field Reference

loyalty_program_accrual_rule

Column	Type	Keys
`id`	Int	PK
`program_id`	String	PKFK
`accrual_type`	String
`catalog_object_id`	String
`category_id`	String
`points`	Int
`spend_amount`	Long
`spend_currency`	String
`visit_minimum_amount`	Long
`visit_minimum_currency`	String

gift_card_customer

Column	Type	Keys
`customer_id`	String	PKFK
`gift_card_id`	String	PKFK

order_custom_attribute

Column	Type	Keys
`key`	String	PKFK
`order_id`	String	PKFK
`created_at`	Instant
`updated_at`	Instant
`value`	Json
`version`	Int
`visibility`	String

loyalty_account

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`program_id`	String	FK
`balance`	Int
`created_at`	Instant
`enrolled_at`	Instant
`lifetime_points`	Int
`mapping_created_at`	Instant
`mapping_id`	String
`mapping_phone_number`	String
`updated_at`	Instant

team_member_wage

Column	Type	Keys
`id`	String	PK
`team_member_id`	String	FK
`hourly_rate_amount`	Long
`hourly_rate_currency`	String
`job_id`	String
`tip_eligible`	Boolean
`title`	String

device_component

Column	Type	Keys
`type`	String	PK
`device_id`	String	PKFK
`application_type`	String
`application_version`	String
`battery_external_power`	String
`battery_visible_percent`	Int
`card_reader_version`	String
`ethernet_active`	Boolean
`session_location`	String
`wifi_`

inventory_count_history

Column	Type	Keys
`calculated_at`	String	PK
`catalog_object_id`	String	PKFK
`location_id`	String	PKFK
`catalog_object_type`	String
`quantity`	String
`state`	String

order_line_item

Column	Type	Keys
`uid`	String	PK
`order_id`	String	PKFK
`catalog_object_id`	String	FK
`base_price_amount`	Long
`base_price_currency`	String
`gross_sales_amount`	Long
`gross_sales_currency`	String
`name`	String
`note`	String
`quantity`	Double
`total_amount`	Long
`total_currency`	String
`total_discount_amount`	Long
`total_discount_currency`	String
`total_tax_amount`	Long
`total_tax_currency`	String
`variation_name`	String

loyalty_program_reward_tier

Column	Type	Keys
`id`	String	PK
`program_id`	String	PKFK
`created_at`	Instant
`name`	String
`points`	Int
`pricing_rule_catalog_version`	Long
`pricing_rule_object_id`	String
`definition_`

team_member

Column	Type	Keys
`id`	String	PK
`assignment_type`	String
`created_at`	Instant
`email_address`	String
`family_name`	String
`given_name`	String
`is_owner`	Boolean
`phone_number`	String
`reference_id`	String
`status`	String
`updated_at`	Instant

order

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`closed_at`	Instant
`created_at`	Instant
`customer_id`	String
`order_source_name`	String
`reference_id`	String
`rounding_adjustment_amount_money_amount`	Long
`rounding_adjustment_amount_money_currency`	String
`rounding_adjustment_name`	String
`rounding_adjustment_uid`	String
`state`	String
`ticket_name`	String
`total_discount_amount`	Long
`total_discount_currency`	String
`total_money_amount`	Long
`total_money_currency`	String
`total_service_charge_amount`	Long
`total_service_charge_currency`	String
`total_tax_amount`	Long
`total_tax_currency`	String
`updated_at`	Instant
`net_amount_`
`return_amount_`

location_capability

Column	Type	Keys
`capability`	String	PK
`location_id`	String	PKFK

employee_wage

Column	Type	Keys
`id`	String	PK
`employee_id`	String	FK
`hourly_rate_amount`	Long
`hourly_rate_currency`	String
`title`	String

cash_drawer

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`closed_at`	Instant
`closed_cash_money_amount`	Long
`closed_cash_money_currency`	String
`description`	String
`ended_at`	Instant
`expected_cash_money_amount`	Long
`expected_cash_money_currency`	String
`opened_at`	Instant
`opened_cash_money_amount`	Long
`opened_cash_money_currency`	String
`state`	String

catalog_category

Column	Type	Keys
`id`	String	PKFK
`name`	String

gift_card_activity

Column	Type	Keys
`gift_card_id`	String	PK
`id`	String	PK
`adjust_decrement_activity_amount`	Long
`adjust_decrement_activity_currency`	String
`adjust_decrement_activity_reason`	String
`adjust_increment_activity_amount`	Long
`adjust_increment_activity_currency`	String
`adjust_increment_activity_reason`	String
`block_activity_reason`	String
`clear_balance_activity_reason`	String
`created_at`	Instant
`deactivate_activity_reason`	String
`gift_card_balance_amount`	Long
`gift_card_balance_currency`	String
`gift_card_gan`	String
`import_activity_amount`	Long
`import_activity_currency`	String
`import_reversal_activity_amount`	Long
`import_reversal_activity_currency`	String
`location_id`	String
`transfer_balance_from_activity_amount`	Long
`transfer_balance_from_activity_currency`	String
`transfer_balance_from_activity_transfer_to_gift_card_id`	String
`transfer_balance_to_activity_amount`	Long
`transfer_balance_to_activity_currency`	String
`transfer_balance_to_activity_transfer_from_gift_card_id`	String
`type`	String
`unblock_activity_reason`	String
`unlinked_activity_refund_activity_amount`	Long
`unlinked_activity_refund_activity_currency`	String
`unlinked_activity_refund_activity_payment_id`	String
`unlinked_activity_refund_activity_reference_id`	String
`activate_activity_`
`load_activity_`
`redeem_activity_`
`refund_activity_`

timecard_break

Column	Type	Keys
`id`	String	PK
`time_card_id`	String	FK
`break_type_id`	String
`end_at`	Instant
`expected_duration`	String
`is_paid`	Boolean
`name`	String
`start_at`	Instant

tender

Column	Type	Keys
`index`	Long	PK
`order_id`	String	PKFK
`location_id`	String	FK
`transaction_id`	String	FK
`amount_amount`	Long
`amount_currency`	String
`card_details_card_brand`	String
`card_details_entry_method`	String
`card_details_fingerprint`	String
`card_details_last_4`	String
`card_details_status`	String
`cash_details_buyer_tender_amount`	Long
`cash_details_buyer_tender_currency`	String
`cash_details_change_back_amount`	Long
`cash_details_change_back_currency`	String
`created_at`	Instant
`customer_id`	String
`note`	String
`processing_fee_amount`	Long
`processing_fee_currency`	String
`tender_id`	String
`tip_amount`	Long
`tip_currency`	String
`type`	String

card

Column	Type	Keys
`id`	String	PK
`card_brand`	String
`card_type`	String
`cardholder_name`	String
`exp_month`	Int
`exp_year`	Int
`fingerprint`	String
`last_4`	String
`prepaid_type`	String
`billing_address_`

catalog_discount

Column	Type	Keys
`id`	String	PKFK
`amount_money_amount`	Long
`amount_money_currency`	String
`discount_type`	String
`label_color`	String
`name`	String
`percentage`	Double
`pin_required`	Boolean

order_return_service_charge

Column	Type	Keys
`uid`	String	PK
`catalog_object_id`	String	FK
`source_service_charge_uid`	String	FK
`amount_money_amount`	Long
`amount_money_currency`	String
`applied_money_amount`	Long
`applied_money_currency`	String
`calculation_phase`	String
`name`	String
`percentage`	Double
`taxable`	Boolean
`total_money_amount`	Long
`total_money_currency`	String
`total_tax_money_amount`	Long
`total_tax_money_currency`	String

payment_processing_fee

Column	Type	Keys
`index`	Long	PK
`payment_id`	String	PKFK
`amount`	Long
`currency`	String
`effective_at`	Instant
`type`	String

segment

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

catalog_modifier_override

Column	Type	Keys
`item_id`	String	PKFK
`modifier_id`	String	PKFK
`modifier_list_id`	String	PKFK
`on_by_default`	Boolean

employee

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`first_name`	String
`last_name`	String
`status`	String
`updated_at`	Instant

loyalty_reward

Column	Type	Keys
`id`	String	PK
`loyalty_account_id`	String	FK
`order_id`	String	FK
`reward_tier_id`	String	FK
`created_at`	Instant
`points`	Int
`redeemed_at`	Instant
`status`	String
`updated_at`	Instant

custom_attribute_definition

Column	Type	Keys
`key`	String	PK
`created_at`	Instant
`description`	String
`name`	String
`schema`	Json
`updated_at`	Instant
`version`	Int
`visibility`	String

order_line_item_discount

Column	Type	Keys
`uid`	String	PK
`order_id`	String	PKFK
`catalog_object_id`	String	FK
`amount_money_amount`	Long
`amount_money_currency`	String
`applied_money_amount`	Long
`applied_money_currency`	String
`name`	String
`percentage`	Double
`scope`	String
`type`	String

cash_drawer_event

Column	Type	Keys
`id`	String	PK
`cash_drawer_id`	String	FK
`created_at`	Instant
`description`	String
`event_money_amount`	Long
`event_money_currency`	String
`event_type`	String

catalog_item

Column	Type	Keys
`id`	String	PKFK
`abbreviation`	String
`available_electronically`	Boolean
`available_for_pickup`	Boolean
`available_online`	Boolean
`category_id`	String
`description`	String
`description_html`	String
`description_plaintext`	String
`image_url`	String
`label_color`	String
`name`	String
`product_type`	String
`reporting_category_id`	String
`reporting_category_ordinal`	Long
`skip_modifier_screen`	Boolean

catalog_modifier_list

Column	Type	Keys
`id`	String	PKFK
`name`	String
`selection_type`	String

customer_group

Column	Type	Keys
`customer_id`	String	PKFK
`group_id`	String	PKFK

catalog_v_1_id

Column	Type	Keys
`catalog_v_1_id`	String	PK
`id`	String	PKFK
`location_id`	String	PKFK

catalog_custom_attribute_definition

Column	Type	Keys
`catalog_object_id`	String	PKFK
`allowed_object_types`	Json
`app_visibility`	String
`description`	String
`key`	String
`name`	String
`number_config_precision`	Int
`selection_config_allowed_selections`	Json
`selection_config_max_allowed_selections`	Int
`seller_visibility`	String
`source_application_id`	String
`source_application_name`	String
`source_application_product`	String
`string_config_enforce_uniqueness`	Boolean
`type`	String

location

Column	Type	Keys
`id`	String	PK
`business_name`	String
`country`	String
`created_at`	Instant
`currency`	String
`language_code`	String
`merchant_id`	String
`name`	String
`phone_number`	String
`status`	String
`timezone`	String
`type`	String
`website_url`	String
`address_`

payment

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`device_detail_device_id`	String	FK
`location_id`	String	FK
`order_id`	String	FK
`team_member_id`	String	FK
`amount_money_amount`	Long
`amount_money_currency`	String
`app_fee_money_amount`	Long
`app_fee_money_currency`	String
`buyer_email_address`	String
`created_at`	Instant
`delay_action`	String
`delay_duration`	String
`delayed_until`	String
`device_detail_device_installation_id`	String
`employee_id`	String
`note`	String
`receipt_number`	String
`receipt_url`	String
`reference_id`	String
`refunded_money_amount`	Long
`refunded_money_currency`	String
`source_type`	String
`status`	String
`tip_money_amount`	Long
`tip_money_currency`	String
`total_money_amount`	Long
`total_money_currency`	String
`updated_at`	Instant
`billing_address_`
`shipping_address_`

device

Column	Type	Keys
`id`	String	PK
`manufacturer`	String
`manufacturers_id`	String
`merchant_token`	String
`model`	String
`name`	String
`status_category`	String
`type`	String
`updated_at`	Instant
`version`	String

order_return_line_item_modifier

Column	Type	Keys
`uid`	String	PK
`catalog_object_id`	String	FK
`order_return_line_item_id`	String	FK
`source_modifier_uid`	String	FK
`base_price_amount`	Long
`base_price_currency`	String
`name`	String
`total_price_amount`	Long
`total_price_currency`	String

catalog_item_variation

Column	Type	Keys
`id`	String	PKFK
`item_id`	String	FK
`inventory_alert_threshold`	Int
`inventory_alert_type`	String
`name`	String
`ordinal`	Int
`price_money_amount`	Long
`price_money_currency`	String
`pricing_type`	String
`service_duration`	Int
`sku`	String
`track_inventory`	Boolean
`upc`	String
`user_data`	String

invoice_custom_field

Column	Type	Keys
`label`	String	PK
`invoice_id`	String	PKFK
`placement`	String
`value`	String

order_return_tax

Column	Type	Keys
`uid`	String	PK
`catalog_object_id`	String	FK
`order_return_id`	String	FK
`source_tax_uid`	String	FK
`applied_money_amount`	Long
`applied_money_currency`	String
`name`	String
`percentage`	Double
`scope`	String
`type`	String

catalog_modifier

Column	Type	Keys
`id`	String	PKFK
`name`	String
`price_money_amount`	Long
`price_money_currency`	String

shift

Column	Type	Keys
`id`	String	PK
`employee_id`	String	FK
`location_id`	String	FK
`team_member_id`	String	FK
`created_at`	Instant
`end_at`	Instant
`start_at`	Instant
`status`	String
`timezone`	String
`updated_at`	Instant
`version`	Int
`wage_hourly_rateamount`	Long
`wage_hourly_ratecurrency`	String
`wage_title`	String

order_return

Column	Type	Keys
`uid`	String	PK
`source_order_id`	String	PKFK

catalog_product_set

Column	Type	Keys
`id`	String	PKFK
`all_products`	Boolean
`name`	String
`quantity_exact`	Int
`quantity_max`	Int
`quantity_min`	Int

item_variation_location_override

Column	Type	Keys
`item_variation_id`	String	PKFK
`location_id`	String	PKFK
`inventory_alert_threshold`	Int
`inventory_alert_type`	String
`price_money_amount`	Long
`price_money_currency`	String
`pricing_type`	String
`track_inventory`	Boolean

catalog_custom_attribute_value

Column	Type	Keys
`key`	String	PK
`catalog_object_id`	String	PKFK
`custom_attribute_definition_id`	String	FK
`boolean_value`	Boolean
`name`	String
`number_value`	String
`selection_uid_values`	Json
`string_value`	String
`type`	String

invoice_payment_reminder

Column	Type	Keys
`uid`	String	PK
`payment_request_id`	String	PKFK
`message`	String
`relative_scheduled_days`	Int
`sent_at`	Instant
`status`	String

order_line_item_modifier

Column	Type	Keys
`uid`	String	PK
`order_id`	String	PKFK
`catalog_object_id`	String	FK
`order_line_item_id`	String	FK
`base_price_amount`	Long
`base_price_currency`	String
`name`	String
`total_price_amount`	Long
`total_price_currency`	String

invoice_recipient

Column	Type	Keys
`invoice_id`	String	PKFK
`customer_id`	String	FK
`tax_ids_eu_vat`	String

shift_break

Column	Type	Keys
`id`	String	PK
`shift_id`	String	FK
`break_type_id`	String
`end_at`	Instant
`expected_duration`	String
`is_paid`	Boolean
`name`	String
`start_at`	Instant

refund

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`order_id`	String	FK
`payment_id`	String	FK
`tender_id`	String	FK
`transaction_id`	String	FK
`amount_amount`	Long
`amount_currency`	String
`created_at`	Instant
`processing_fee_amount`	Long
`processing_fee_currency`	String
`reason`	String
`status`	String

break_type

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`break_name`	String
`created_at`	Instant
`expected_duration`	String
`is_paid`	Boolean
`updated_at`	Instant
`version`	Long

catalog_item_tax

Column	Type	Keys
`item_id`	String	PKFK
`tax_id`	String	PKFK

loyalty_program

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`expiration_policy_expiration_duration`	String
`location_ids`	Json
`status`	String
`terminology_one`	String
`terminology_other`	String
`updated_at`	Instant

additional_tender_recipient

Column	Type	Keys
`index`	Long	PK
`location_id`	String	PKFK
`tender_id`	String	PKFK
`amount_amount`	Long
`amount_currency`	String
`description`	String
`receivable_id`	String

merchant

Column	Type	Keys
`id`	String	PK
`main_location_id`	String	FK
`business_name`	String
`country`	String
`created_at`	Instant
`currency`	String
`language_code`	String
`status`	String

loyalty_account_mapping

Column	Type	Keys
`id`	String	PK
`account_id`	String	PKFK
`created_at`	Instant
`type`	String
`value`	String

bank_account

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`account_number_suffix`	String
`account_type`	String
`bank_name`	String
`country`	String
`creditable`	Boolean
`currency`	String
`debit_mandate_reference_id`	String
`debitable`	Boolean
`fingerprint`	String
`holder_name`	String
`primary_bank_identification_number`	String
`reference_id`	String
`secondary_bank_identification_number`	String
`status`	String
`version`	Int

dispute_evidence

Column	Type	Keys
`id`	String	PK
`dispute_id`	String	FK
`evidence_filename`	String
`evidence_filetype`	String
`evidence_type`	String
`uploaded_at`	Instant

transaction

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`order_id`	String	FK
`client_id`	String
`created_at`	Instant
`product`	String
`reference_id`	String
`shipping_address_`

customer_card

Column	Type	Keys
`card_id`	String	PKFK
`customer_id`	String	PKFK

gift_card

Column	Type	Keys
`id`	String	PK
`balance_amount`	Long
`balance_currency`	String
`created_at`	Instant
`gan`	String
`gan_source`	String
`state`	String
`type`	String

customer_segment

Column	Type	Keys
`customer_id`	String	PKFK
`segment_id`	String	PKFK

employee_location

Column	Type	Keys
`employee_id`	String	PKFK
`location_id`	String	PKFK

catalog_tax

Column	Type	Keys
`id`	String	PKFK
`applies_to_custom_amounts`	Boolean
`calculation_phase`	String
`enabled`	Boolean
`inclusion_type`	String
`name`	String
`percentage`	Double

workweek_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`created_at`	Instant
`start_of_day_local_time`	String
`start_of_week`	String
`version`	Long

catalog_modifier_in_catalog_modifier_list

Column	Type	Keys
`modifier_id`	String	PKFK
`modifier_list_id`	String	PKFK

catalog_object

Column	Type	Keys
`id`	String	PK
`absent_at_location_ids`	Json
`image_url`	String
`is_deleted`	Boolean
`present_at_all_locations`	Boolean
`present_at_location_ids`	Json
`type`	String
`updated_at`	Instant
`version`	Long

order_return_discount

Column	Type	Keys
`uid`	String	PK
`catalog_object_id`	String	FK
`order_return_id`	String	FK
`source_discount_uid`	String	FK
`amount_money_amount`	Long
`amount_money_currency`	String
`applied_money_amount`	Long
`applied_money_currency`	String
`name`	String
`percentage`	Double
`scope`	String
`type`	String

catalog_pricing_rule_customer_group

Column	Type	Keys
`catalog_pricing_rule_id`	String	PKFK
`customer_group_id`	String	PKFK

catalog_item_category

Column	Type	Keys
`catalog_item_id`	String	PKFK
`id`	String	PKFK
`ordinal`	Long

order_line_item_tax

Column	Type	Keys
`uid`	String	PK
`order_id`	String	PKFK
`catalog_object_id`	String	FK
`applied_money_amount`	Long
`applied_money_currency`	String
`name`	String
`percentage`	Double
`scope`	String
`type`	String

card_payment_details

Column	Type	Keys
`payment_id`	String	PKFK
`card_id`	String	FK
`application_cryptogram`	String
`application_identifier`	String
`application_name`	String
`auth_result_code`	String
`avs_status`	String
`cvv_status`	String
`entry_method`	String
`refund_requires_card_presence`	Boolean
`statement_description`	String
`status`	String
`tip_money_device_id`	String
`tip_money_device_name`	String
`verification_method`	String
`verification_results`	String

merchant_custom_attribute

Column	Type	Keys
`key`	String	PKFK
`merchant_id`	String	PKFK
`created_at`	Instant
`updated_at`	Instant
`value`	String
`version`	Int
`visibility`	String

group

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

customer

Column	Type	Keys
`id`	String	PK
`birthday`	String
`company_name`	String
`created_at`	Instant
`creation_source`	String
`email_address`	String
`family_name`	String
`given_name`	String
`nickname`	String
`note`	String
`phone_number`	String
`preferences_email_unsubscribed`	Boolean
`reference_id`	String
`updated_at`	Instant
`address_`

customer_group_info

Column	Type	Keys
`id`	String	PK
`customer_id`	String	PKFK
`name`	String

order_service_charge

Column	Type	Keys
`uid`	String	PK
`order_id`	String	PKFK
`catalog_object_id`	String	FK
`amount_money_amount`	Long
`amount_money_currency`	String
`applied_money_amount`	Long
`applied_money_currency`	String
`calculation_money`	String
`name`	String
`percentage`	Double
`taxable`	Boolean
`total_money_amount`	Long
`total_money_currency`	String
`total_tax_money_amount`	Long
`total_tax_money_currency`	String

order_fulfillment

Column	Type	Keys
`_fivetran_id`	String	PK
`order_id`	String	PKFK
`state`	String
`type`	String
`pickup_detail_`

catalog_pricing_rule

Column	Type	Keys
`id`	String	PKFK
`discount_id`	String	FK
`exclude_products_id`	String
`exclude_strategy`	String
`match_products_id`	String
`minimum_order_subtotal_money_amount`	Long
`minimum_order_subtotal_money_currency`	String
`name`	String
`valid_from_date`	String
`valid_from_local_time`	String
`valid_until_date`	String
`valid_until_local_time`	String

order_custom_attribute_definition

Column	Type	Keys
`key`	String	PK
`created_at`	Instant
`description`	String
`name`	String
`schema`	Json
`updated_at`	Instant
`version`	Int
`visibility`	String

team_member_assigned_location

Column	Type	Keys
`location_id`	String	PKFK
`team_member_id`	String	PKFK

dispute

Column	Type	Keys
`id`	String	PK
`disputed_payment_id`	String	FK
`location_id`	String	FK
`amount_money_amount`	Long
`amount_money_currency`	String
`brand_dispute_id`	String
`card_brand`	String
`created_at`	Instant
`dispute_id`	String
`due_at`	Instant
`reason`	String
`reported_at`	Instant
`reported_date`	Instant
`state`	String
`updated_at`	Instant
`version`	Int

invoice

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`order_id`	String	FK
`created_at`	Instant
`delivery_method`	String
`description`	String
`invoice_number`	String
`next_payment_amount`	Long
`next_payment_currency`	String
`payment_conditions`	String
`public_url`	String
`sale_or_service_date`	LocalDate
`scheduled_at`	Instant
`status`	String
`store_payment_method_enabled`	Boolean
`subscription_id`	String
`timezone`	String
`title`	String
`updated_at`	Instant
`version`	Int
`accepted_payment_method_`

order_return_line_item

Column	Type	Keys
`uid`	String	PK
`catalog_object_id`	String	FK
`order_return_id`	String	FK
`source_line_item_uid`	String	FK
`base_price_money_amount`	Long
`base_price_money_currency`	String
`gross_return_money_amount`	Long
`gross_return_money_currency`	String
`name`	String
`note`	String
`quantity`	String
`quantity_measurement_area_unit`	String
`quantity_measurement_custom_unit_abbrevation`	String
`quantity_measurement_custom_unit_name`	String
`quantity_measurement_generic_unit`	String
`quantity_measurement_length_unit`	String
`quantity_measurement_volume_unit`	String
`quantity_measurement_weight_unit`	String
`quantity_precision`	Int
`total_discount_money_amount`	Long
`total_discount_money_currency`	String
`total_money_amount`	Long
`total_money_currency`	String
`total_tax_money_amount`	Long
`total_tax_money_currency`	String
`variation_name`	String
`variation_total_price_money_amount`	Long
`variation_total_price_money_currency`	String

catalog_item_modifier_list_info

Column	Type	Keys
`item_id`	String	PKFK
`modifier_list_id`	String	PKFK
`enabled`	Boolean
`max_selected_modifiers`	Int
`min_selected_modifiers`	Int

invoice_payment_request

Column	Type	Keys
`uid`	String	PK
`invoice_id`	String	PKFK
`automatic_payment_source`	String
`card_id`	String
`computed_amount`	Long
`computed_currency`	String
`due_date`	LocalDate
`fixed_amount_requested_amount`	Long
`fixed_amount_requested_currency`	String
`percentage_requested`	String
`request_type`	String
`rounding_adjustment_included_amount`	Long
`rounding_adjustment_included_currency`	String
`tipping_enabled`	Boolean
`total_completed_amount`	Long
`total_completed_currency`	String

timecard

Column	Type	Keys
`id`	String	PK
`location_id`	String	FK
`team_member_id`	String	FK
`created_at`	Instant
`declared_cash_tip_amount`	Long
`declared_cash_tip_currency`	String
`end_at`	Instant
`start_at`	Instant
`status`	String
`timezone`	String
`updated_at`	Instant
`version`	Int
`wage_`

additional_refund_recipient

Column	Type	Keys
`location_id`	String	PKFK
`refund_id`	String	PKFK
`amount_amount`	Long
`amount_currency`	String
`description`	String
`receivable_id`	String