Heartland Retail POS

Explore the interactive ERD

Table & Field Reference

purchase_vendor

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`address_id`	Unknown
`contact_id`	Unknown
`created_at`	Unknown
`import_set_id`	Unknown
`name`	Unknown
`public_id`	Unknown
`sort_key`	Unknown
`updated_at`	Instant
`uuid`	Unknown
`vendor_import_batch_id`	Unknown

location

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`updated_by_user_id`	Unknown	FK
`active`	Unknown
`address_id`	Unknown
`address_revision_id`	Unknown
`cash_discount_item_conditions`	Unknown
`cash_discount_rate`	Unknown
`created_at`	Unknown
`credit_cards_configured`	Unknown
`internal`	Unknown
`metadata`	Json
`metadata_private`	Unknown
`name`	Unknown
`price_list_id`	Unknown
`public_id`	Unknown
`settings`	Json
`timezone_identifier_id`	Unknown
`updated_at`	Instant
`uuid`	Unknown
`custom_`

purchase_order_line

Column	Type	Keys
`id`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`item_id`	Unknown	FK
`allocation`	Json
`created_at`	Unknown
`extended_cost`	Unknown
`item_vendor_detail_custom`	Unknown
`line_display_id`	Unknown
`name`	Unknown
`open_cost`	Unknown
`original_cost`	Unknown
`po_line_import_batch_id`	Unknown
`qty`	Unknown
`qty_expected`	Unknown
`qty_received`	Unknown
`received_cost`	Unknown
`sort_key`	Unknown
`status`	Unknown
`unit_cost`	Unknown
`updated_at`	Instant
`vendor_item_public_id`	Unknown

grid_controlled_item_field

Column	Type	Keys
`index`	Unknown	PK
`item_grid_id`	Unknown	PKFK
`grid_controlled_item_field`	Unknown

item_grid_image

Column	Type	Keys
`id`	Unknown	PK
`item_grid_dimension_value_id`	Unknown	FK
`item_grid_id`	Unknown	FK
`created_at`	Unknown
`is_primary`	Unknown
`kind`	Unknown
`metadata_private`	Unknown
`new_thumbnail_url`	Unknown
`new_url`	Unknown
`old_thumbnail_url`	Unknown
`old_url`	Unknown
`url`	Unknown
`variant_thumbnail_url`	Unknown

item_grid_image_dimension_filter_value

Column	Type	Keys
`id`	Unknown	PK
`item_grid_id`	Unknown	PKFK
`dimension_id`	Unknown
`primary_image_id`	Unknown
`value`	Unknown

item_grid

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`updated_by_user_id`	Unknown	FK
`active`	Unknown
`created_at`	Unknown
`default_lookup_id`	Unknown
`default_price_list_id`	Unknown
`description`	Unknown
`has_empty_cells`	Unknown
`has_images`	Unknown
`image_dimension_custom_field_id`	Unknown
`image_dimension_id`	Unknown
`image_dimension_name`	Unknown
`import_set_id`	Unknown
`item_available_online`	Unknown
`long_description`	Unknown
`metadata`	Unknown
`metadata_private`	Unknown
`primary_image_id`	Unknown
`public_id`	Unknown
`sort_key`	Unknown
`updated_at`	Instant
`updating`	Unknown
`uuid`	Unknown
`custom_`

inventory_value_search

Column	Type	Keys
`item_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`qty`	Unknown
`qty_available`	Unknown
`qty_committed`	Unknown
`qty_contributed_to_unit_cost`	Unknown
`qty_in_transit`	Unknown
`qty_on_hand`	Unknown
`qty_on_po`	Unknown
`qty_with_customer`	Unknown
`unit_cost`	Unknown

purchase_receipt_line

Column	Type	Keys
`id`	Unknown	PK
`purchase_receipt_id`	Unknown	PKFK
`item_id`	Unknown	FK
`created_at`	Unknown
`extended_cost`	Unknown
`order_line_id`	Unknown
`qty`	Unknown
`qty_expected`	Unknown
`qty_unauthorized`	Unknown
`unit_cost`	Unknown
`updated_at`	Instant
`vendor_item_public_id`	Unknown

item

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`grid_id`	Unknown	FK
`updated_by_user_id`	Unknown	FK
`active`	Unknown
`add_on_for_items_matching_filter`	Unknown
`add_on_item_filter`	Unknown
`allow_fractional_qty`	Unknown
`available_online`	Unknown
`cost`	Unknown
`created_at`	Unknown
`default_lookup_id`	Unknown
`default_price_list_id`	Unknown
`depth`	Unknown
`depth_unit`	Unknown
`description`	Unknown
`dynamic_margin`	Unknown
`financial_class_id`	Unknown
`has_images`	Unknown
`height`	Unknown
`height_unit`	Unknown
`import_batch_id`	Unknown
`import_set_id`	Unknown
`long_description`	Unknown
`metadata`	Json
`metadata_private`	Unknown
`original_price`	Unknown
`price`	Unknown
`primary_barcode`	Unknown
`primary_image_id`	Unknown
`primary_vendor_id`	Unknown
`product_type`	Unknown
`prompt_for_description`	Unknown
`prompt_for_price`	Unknown
`public_id`	Unknown
`sort_key`	Unknown
`track_inventory`	Unknown
`type`	Unknown
`updated_at`	Instant
`use_dynamic_margin`	Unknown
`uuid`	Unknown
`weight`	Unknown
`weight_unit`	Unknown
`width`	Unknown
`width_unit`	Unknown
`custom_`

purchase_order

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`first_emailed_by_user_id`	Unknown	FK
`last_emailed_by_user_id`	Unknown	FK
`purchase_vendor_id`	Unknown	FK
`receive_at_location_id`	Unknown	FK
`allocated`	Unknown
`allocated_location_ids`	Json
`created_at`	Unknown
`description`	Unknown
`end_shipment_at`	Unknown
`export_email`	Unknown
`first_emailed_at`	Unknown
`freight_cost`	Unknown
`import_set_id`	Unknown
`initial_margin_ratio`	Unknown
`last_emailed_at`	Unknown
`location_ids`	Json
`nuorder_id`	Unknown
`overdue`	Unknown
`po_import_batch_id`	Unknown
`public_id`	Unknown
`sort_key`	Unknown
`start_shipment_at`	Unknown
`status`	Unknown
`total_cost`	Unknown
`total_open_cost`	Unknown
`total_open_price`	Unknown
`total_open_qty`	Unknown
`total_price`	Unknown
`total_qty`	Unknown
`total_received_cost`	Unknown
`total_received_price`	Unknown
`total_received_qty`	Unknown
`total_unauthorized_cost`	Unknown
`total_unauthorized_qty`	Unknown
`updated_at`	Instant
`custom_`

purchase_receipt

Column	Type	Keys
`id`	Unknown	PK
`purchase_order_id`	Unknown	FK
`receive_at_location_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`freight_cost`	Unknown
`items_cost`	Unknown
`local_completed_at`	Unknown
`local_created_at`	Unknown
`local_updated_at`	Unknown
`public_id`	Unknown
`require_unauthorized_quantities_acknowledgement`	Unknown
`status`	Unknown
`total_cost`	Unknown
`total_cost_unauthorized`	Unknown
`total_qty`	Unknown
`total_qty_expected`	Unknown
`total_qty_unauthorized`	Unknown
`updated_at`	Instant
`custom_`

purchase_return_line

Column	Type	Keys
`id`	Unknown	PK
`purchase_return_id`	Unknown	PKFK
`item_id`	Unknown	FK
`created_at`	Unknown
`extended_cost`	Unknown
`qty`	Unknown
`unit_cost`	Unknown
`updated_at`	Instant
`vendor_item_public_id`	Unknown

sale_ticket_line

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`customer_id`	Unknown	FK
`item_id`	Unknown	FK
`sales_transaction_id`	Unknown	FK
`updated_by_user_id`	Unknown	FK
`action_id`	Unknown
`add_on_item_lines`	Json
`address_id`	Unknown
`address_revision_id`	Unknown
`adjusted_unit_price`	Unknown
`allowable_custom_field_keys`	Json
`bundle_id`	Unknown
`bundle_item_id`	Unknown
`cash_discounted_value`	Unknown
`created_at`	Unknown
`current_unit_price`	Unknown
`deleted`	Unknown
`deleted_add_on_item_lines`	Json
`deposit_item_tracking_number_id`	Unknown
`description`	Unknown
`discount_value`	Unknown
`final_unit_price`	Unknown
`gift_card_balance_loaded`	Unknown
`gift_card_id`	Unknown
`image_thumbnail_url`	Unknown
`image_url`	Unknown
`item_line_id`	Unknown
`item_metadata_private`	Unknown
`item_public_id`	Unknown
`lookup_id`	Unknown
`loyalty_point`	Unknown
`manually_added`	Unknown
`metadata_private`	Unknown
`order_discount_id`	Unknown
`order_line_id`	Unknown
`original_unit_price`	Unknown
`original_value`	Unknown
`permanent`	Unknown
`possible_add_ons`	Json
`price_adjustments`	Json
`price_list_id`	Unknown
`prompt_for_missing_fields`	Json
`prompt_for_missing_reason_codes`	Json
`public_id`	Unknown
`qty`	Unknown
`reason_codes`	Json
`removal_reason`	Unknown
`sales_rep`	Unknown
`sales_rep_ids`	Json
`sales_transaction_line_id`	Unknown
`shipping_line_id`	Unknown
`shipping_method_id`	Unknown
`source_id`	Unknown
`source_type`	Unknown
`tax_rule_id`	Unknown
`ticket_level_discount`	Unknown
`ticket_level_discounted_value`	Unknown
`type`	Unknown
`unit_cost`	Unknown
`unit_price`	Unknown
`updated_at`	Instant
`value`	Unknown
`custom_`

customer

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`address_city`	Unknown
`address_country`	Unknown
`address_current_revision_hash`	Unknown
`address_current_revision_id`	Unknown
`address_full_address`	Unknown
`address_id`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_metadata`	Json
`address_metadata_private`	Unknown
`address_phone`	Unknown
`address_postal_code`	Unknown
`address_revision_hash`	Unknown
`address_square_feet`	Unknown
`address_state`	Unknown
`address_street_address`	Unknown
`address_type`	Unknown
`address_uuid`	Unknown
`billing_address_id`	Unknown
`created_at`	Unknown
`customer_import_batch_id`	Unknown
`default_lookup_id`	Unknown
`deleted_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`import_set_id`	Unknown
`last_name`	Unknown
`loyalty_points_balance`	Unknown
`loyalty_points_total`	Unknown
`metadata`	Json
`metadata_private`	Unknown
`name`	Unknown
`phone_number`	Unknown
`promotional_email`	Unknown
`promotional_message`	Unknown
`public_id`	Unknown
`shipping_address_id`	Unknown
`sort_key`	Unknown
`type`	Unknown
`updated_at`	Instant
`uuid`	Unknown
`address_custom_`
`custom_`

purchase_return

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`purchase_vendor_id`	Unknown	FK
`return_from_location_id`	Unknown	FK
`updated_by_user_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`local_completed_at`	Unknown
`local_created_at`	Unknown
`local_updated_at`	Unknown
`public_id`	Unknown
`status`	Unknown
`total_cost`	Unknown
`total_qty`	Unknown
`updated_at`	Instant
`custom_`

users

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`all_location`	Unknown
`created_at`	Unknown
`email`	Unknown
`email_verification_sent_at`	Unknown
`email_verified_at`	Unknown
`eula_accepted`	Unknown
`eula_last_reviewed_at`	Unknown
`external`	Unknown
`failed_auth_attempt`	Unknown
`failed_pin_attempt`	Unknown
`first_name`	Unknown
`has_pincode`	Unknown
`internal`	Unknown
`is_account_admin`	Unknown
`is_account_owner`	Unknown
`is_admin`	Unknown
`last_name`	Unknown
`locked_at`	Unknown
`login`	Unknown
`mfa_liability_accepted`	Unknown
`mfa_liability_accepted_at`	Unknown
`mfa_required`	Unknown
`name`	Unknown
`phone`	Unknown
`public_id`	Unknown
`roles_name`	Json
`sales_rep`	Unknown
`sso_id`	Unknown
`updated_at`	Instant
`uuid`	Unknown

sale_ticket_rep

Column	Type	Keys
`sales_rep_id`	Unknown	PK
`sale_ticket_id`	Unknown	PKFK

sale_ticket

Column	Type	Keys
`id`	Unknown	PK
`created_by_user_id`	Unknown	FK
`customer_id`	Unknown	FK
`order_id`	Unknown	FK
`source_location_id`	Unknown	FK
`updated_by_user_id`	Unknown	FK
`balance`	Unknown
`billing_address_id`	Unknown
`cash_balance`	Unknown
`cash_discount_rate`	Unknown
`cash_discount_tax_lines`	Json
`cash_round`	Unknown
`cash_total`	Unknown
`change`	Unknown
`completed`	Unknown
`completed_at`	Unknown
`coupon_id`	Unknown
`created_at`	Unknown
`local_completed_at`	Unknown
`local_created_at`	Unknown
`local_updated_at`	Unknown
`metadata`	Json
`metadata_private`	Unknown
`minimum_deposit_value`	Unknown
`original_subtotal`	Unknown
`parent_transaction_id`	Unknown
`payment_exception`	Unknown
`penny_rounded_balance`	Unknown
`penny_rounded_cash_balance`	Unknown
`penny_rounded_cash_total`	Unknown
`penny_rounded_change`	Unknown
`promotion_state_coupon_id`	Json
`public_id`	Unknown
`read_only`	Unknown
`recalculate`	Unknown
`sales_rep`	Unknown
`search_vector`	Unknown
`signatures_required`	Unknown
`station_id`	Unknown
`status`	Unknown
`total`	Unknown
`total_discount`	Unknown
`total_item_qty`	Unknown
`total_paid`	Unknown
`type`	Unknown
`updated_at`	Instant
`value_of_all_added_item_discount_lines`	Unknown
`voided`	Unknown
`custom_`