# Heartland Retail POS schema ERD

Table and field reference for the Fivetran Heartland Retail POS connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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_** |  |  |

## Relationships

- location(updated_by_user_id) → users(id)
- location(created_by_user_id) → users(id)
- purchase_order_line(item_id) → item(id)
- purchase_order_line(purchase_order_id) → purchase_order(id)
- grid_controlled_item_field(item_grid_id) → item_grid(id)
- item_grid_image(item_grid_id) → item_grid(id)
- item_grid_image(item_grid_dimension_value_id) → item_grid_image_dimension_filter_value(id)
- item_grid_image_dimension_filter_value(item_grid_id) → item_grid(id)
- item_grid(updated_by_user_id) → users(id)
- item_grid(created_by_user_id) → users(id)
- inventory_value_search(item_id) → item(id)
- inventory_value_search(location_id) → location(id)
- purchase_receipt_line(item_id) → item(id)
- purchase_receipt_line(purchase_receipt_id) → purchase_receipt(id)
- item(updated_by_user_id) → users(id)
- item(created_by_user_id) → users(id)
- item(grid_id) → item_grid(id)
- purchase_order(created_by_user_id) → users(id)
- purchase_order(receive_at_location_id) → location(id)
- purchase_order(purchase_vendor_id) → purchase_vendor(id)
- purchase_order(last_emailed_by_user_id) → users(id)
- purchase_order(first_emailed_by_user_id) → users(id)
- purchase_receipt(purchase_order_id) → purchase_order(id)
- purchase_receipt(receive_at_location_id) → location(id)
- purchase_return_line(item_id) → item(id)
- purchase_return_line(purchase_return_id) → purchase_return(id)
- sale_ticket_line(sales_transaction_id) → sale_ticket(id)
- sale_ticket_line(item_id) → item(id)
- sale_ticket_line(customer_id) → customer(id)
- sale_ticket_line(created_by_user_id) → users(id)
- sale_ticket_line(updated_by_user_id) → users(id)
- purchase_return(updated_by_user_id) → users(id)
- purchase_return(created_by_user_id) → users(id)
- purchase_return(purchase_vendor_id) → purchase_vendor(id)
- purchase_return(return_from_location_id) → location(id)
- sale_ticket_rep(sale_ticket_id) → sale_ticket(id)
- sale_ticket(updated_by_user_id) → users(id)
- sale_ticket(created_by_user_id) → users(id)
- sale_ticket(order_id) → purchase_order(id)
- sale_ticket(source_location_id) → location(id)
- sale_ticket(customer_id) → customer(id)