Lightspeed Retail X-Series
Explore the interactive ERD
Table & Field Reference
inventory
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
outlet_id | Unknown | FK |
product_id | Unknown | FK |
average_cost | Unknown | |
current_amount | Unknown | |
deleted_at | Instant | |
inventory_level | Unknown | |
reorder_amount | Unknown | |
reorder_point | Unknown | |
version | Unknown |
supplier
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_company_name | Unknown | |
contact_email | Unknown | |
contact_fax | Unknown | |
contact_first_name | Unknown | |
contact_last_name | Unknown | |
contact_mobile | Unknown | |
contact_phone | Unknown | |
contact_physical_address_1 | Unknown | |
contact_physical_address_2 | Unknown | |
contact_physical_city | Unknown | |
contact_physical_country_id | Unknown | |
contact_physical_postcode | Unknown | |
contact_physical_state | Unknown | |
contact_physical_suburb | Unknown | |
contact_postal_address_1 | Unknown | |
contact_postal_address_2 | Unknown | |
contact_postal_city | Unknown | |
contact_postal_country_id | Unknown | |
contact_postal_postcode | Unknown | |
contact_postal_state | Unknown | |
contact_postal_suburb | Unknown | |
contact_twitter | Unknown | |
contact_website | Unknown | |
default_markup | Unknown | |
deleted_at | Instant | |
description | Unknown | |
name | Unknown | |
source | Unknown | |
version | Unknown |
outlet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attributes | Json | |
currency | Unknown | |
currency_symbol | Unknown | |
deleted_at | Instant | |
display_price | Unknown | |
email | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
name | Unknown | |
phone | Unknown | |
physical_address_1 | Unknown | |
physical_address_2 | Unknown | |
physical_city | Unknown | |
physical_country_id | Unknown | |
physical_postcode | Unknown | |
physical_state | Unknown | |
physical_suburb | Unknown | |
time_zone | Unknown | |
version | Unknown |
brand
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deleted_at | Instant | |
description | Unknown | |
name | Unknown | |
version | Unknown |
product_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
product_id | Unknown | PKFK |
product_category_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
product_id | Unknown | PKFK |
deleted_at | Unknown | |
name | Unknown | |
version | Unknown |
product_variant_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | PKFK |
name | Unknown | |
values | Json |
product_supplier
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | PKFK |
supplier_id | Unknown | FK |
code | Unknown | |
price | Unknown |
product_code
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_id | Unknown | PKFK |
code | Unknown | |
id | Unknown | |
type | Unknown |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
brand_id | Unknown | FK |
product_category_id | Unknown | FK |
supplier_id | Unknown | FK |
account_code | Unknown | |
account_code_purchase | Unknown | |
active | Unknown | |
attributes | Json | |
button_order | Unknown | |
created_at | Instant | |
deleted_at | Instant | |
description | Unknown | |
dimensions_unit | Unknown | |
ecwid_enabled_webstore | Unknown | |
family_id | Unknown | |
handle | Unknown | |
has_inventory | Unknown | |
height | Unknown | |
image_thumbnail_url | Unknown | |
image_url | Unknown | |
images | Json | |
is_active | Unknown | |
is_composite | Unknown | |
is_variant | Unknown | |
length | Unknown | |
loyalty_amount | Unknown | |
name | Unknown | |
packaging_breaks_into | Json | |
packaging_made_from | Json | |
price_excluding_tax | Unknown | |
price_including_tax | Unknown | |
sku | Unknown | |
sku_images | Json | |
source | Unknown | |
source_id | Unknown | |
source_variant_id | Unknown | |
supplier_code | Unknown | |
supply_price | Unknown | |
type_deleted_at | Unknown | |
type_version | Unknown | |
updated_at | Instant | |
variant_count | Unknown | |
variant_name | Unknown | |
variant_parent_id | Unknown | |
version | Unknown | |
weight | Unknown | |
weight_unit | Unknown | |
width | Unknown |
retailer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
discount_product_id | Unknown | FK |
account_status | Unknown | |
account_type | Unknown | |
activated_at | Instant | |
country | Unknown | |
create_customer_by_email_receipt | Unknown | |
created_at | Instant | |
culture | Unknown | |
currency_code | Unknown | |
currency_symbol | Unknown | |
default_dimensions_unit | Unknown | |
default_tax_id | Unknown | |
default_weight_unit | Unknown | |
disable_onboarding_tour | Unknown | |
domain_prefix | Unknown | |
ecwid_onboarding_survey_state | Unknown | |
embedded_barcode_option | Unknown | |
enabled_integrations | Json | |
enabled_platform_apps | Json | |
gift_cards_enabled | Unknown | |
gift_cards_never_enabled | Unknown | |
has_web_register | Unknown | |
label_printer_format | Unknown | |
lightspeed_unique_id | Unknown | |
loyalty_claim_url | Unknown | |
loyalty_enabled | Unknown | |
loyalty_offer_signup_bonus | Unknown | |
loyalty_ratio | Unknown | |
loyalty_send_welcome_email | Unknown | |
loyalty_signup_bonus | Unknown | |
name | Unknown | |
no_tax_group_id | Unknown | |
on_account_default_limit | Unknown | |
register_migration_date | Unknown | |
require_password_on_user_switch | Unknown | |
restriction_state | Unknown | |
restriction_state_reason | Unknown | |
sku_sequence_enabled | Unknown | |
sku_sequence_value | Unknown | |
sso_enabled | Unknown | |
store_credit | Unknown | |
store_url | Unknown | |
subscription_plan_version | Unknown | |
subscription_state | Unknown | |
subscription_trial_expires_at | Unknown | |
tax_exclusive | Unknown | |
terms_and_conditions_accepted | Unknown | |
terms_and_conditions_effective_date | Unknown | |
terms_and_conditions_terms_version | Unknown | |
timezone | Json | |
version | Unknown |
cosignment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
outlet_id | Unknown | FK |
source_outlet_id | Unknown | FK |
supplier_id | Unknown | FK |
consignment_date | Instant | |
created_at | Instant | |
deleted_at | Instant | |
due_at | Instant | |
name | Unknown | |
received_at | Instant | |
reference | Unknown | |
status | Unknown | |
supplier_invoice | Unknown | |
total_cost_gain | Unknown | |
total_cost_loss | Unknown | |
total_count_gain | Unknown | |
total_count_loss | Unknown | |
updated_at | Instant | |
version | Unknown |
users_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
name | Unknown | |
system_role_id | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_type | Unknown | |
created_at | Instant | |
deleted_at | Instant | |
display_name | Unknown | |
email | Unknown | |
email_verified_at | Unknown | |
enabled | Unknown | |
enabled_mfa | Unknown | |
image_original | Unknown | |
image_sl | Unknown | |
image_sm | Unknown | |
image_source | Unknown | |
image_ss | Unknown | |
image_st | Unknown | |
image_standard | Unknown | |
image_thumb | Unknown | |
is_primary_user | Unknown | |
permission | Json | |
require_password_change | Unknown | |
restricted_outlet_ids | Json | |
rules | Json | |
seen_at | Instant | |
switch_id | Unknown | |
target_daily | Unknown | |
target_monthly | Unknown | |
target_weekly | Unknown | |
time_until_deletion | Unknown | |
updated_at | Instant | |
username | Unknown | |
version | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deleted_at | Instant | |
name | Unknown | |
version | Unknown |
sale_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sale_id | Unknown | PKFK |
product_id | Unknown | FK |
cost | Unknown | |
discount | Unknown | |
discount_total | Unknown | |
gift_card_number | Unknown | |
is_return | Unknown | |
loyalty_value | Unknown | |
note | Unknown | |
price | Unknown | |
price_set | Unknown | |
price_total | Unknown | |
promotions | Json | |
quantity | Unknown | |
return_reason | Unknown | |
sales_person_id | Unknown | |
sequence | Unknown | |
status | Unknown | |
surcharges | Json | |
tax | Unknown | |
tax_components | Json | |
tax_id | Unknown | |
unit_cost | Unknown | |
unit_discount | Unknown | |
unit_loyalty_value | Unknown | |
unit_price | Unknown | |
unit_tax | Unknown |
sale_payment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sale_id | Unknown | PKFK |
outlet_id | Unknown | FK |
amount | Unknown | |
deleted_at | Instant | |
external_applications | Json | |
external_attributes | Json | |
name | Unknown | |
payment_date | Instant | |
register_id | Unknown | |
register_open_sequence_id | Unknown | |
retailer_payment_type_id | Unknown | |
source_id | Unknown | |
surcharge | Json |
sale_adjustment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sale_id | Unknown | PKFK |
adjustment_type | Unknown | |
name | Unknown | |
tax_components | Json | |
value | Unknown |
sale_ecom_custom_charge
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sale_id | Unknown | PKFK |
name | Unknown | |
source_id | Unknown | |
tax_components | Json | |
total | Unknown | |
total_incl | Unknown | |
total_tax | Unknown |
sale_tax
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sale_id | Unknown | PKFK |
amount | Unknown | |
name | Unknown | |
rate | Unknown |
sale
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
outlet_id | Unknown | FK |
user_id | Unknown | FK |
accounts_transaction_id | Unknown | |
attributes | Json | |
complete_open_sequence_id | Unknown | |
created_at | Instant | |
deleted_at | Instant | |
ecom_custom_charges_total | Unknown | |
ecom_custom_charges_total_incl | Unknown | |
ecom_custom_charges_total_tax | Unknown | |
external_applications | Json | |
has_unsynced_on_account_payments | Unknown | |
invoice_number | Unknown | |
invoice_sequence | Unknown | |
note | Unknown | |
receipt_number | Unknown | |
register_id | Unknown | |
return_for | Unknown | |
return_ids | Json | |
sale_date | Instant | |
short_code | Unknown | |
source | Unknown | |
source_id | Unknown | |
state | Unknown | |
status | Unknown | |
total_loyalty | Unknown | |
total_surcharge | Unknown | |
updated_at | Instant | |
version | Unknown |
customer_service_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
created_at | Instant | |
created_by | Unknown | |
description | Unknown | |
initial_condition | Unknown | |
name | Unknown | |
serial_number | Unknown | |
updated_at | Instant | |
updated_by | Unknown |
service_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
service_id | Unknown | PKFK |
product_id | Unknown | FK |
fulfillment_type | Unknown | |
gift_card | Unknown | |
is_picklist_pickable | Unknown | |
note | Unknown | |
price_set | Unknown | |
promotions | Json | |
quantity | Unknown | |
register_id | Unknown | |
register_sequence_id | Unknown | |
sales_person_id | Unknown | |
sequence | Unknown | |
sku | Unknown | |
state | Unknown | |
tax_components | Json | |
unit_discount | Unknown | |
unit_loyalty | Unknown | |
unit_price | Unknown |
service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
retailer_id | Unknown | FK |
sale_id | Unknown | FK |
agenda_date | Unknown | |
agenda_minutes_scheduled | Unknown | |
assigned_user_id | Unknown | |
created_at | Instant | |
is_sale_level_discount_percentage | Unknown | |
notes | Json | |
sale_level_discount_value | Unknown | |
service_item_created_at | Instant | |
service_item_created_by | Unknown | |
service_item_detail_description | Unknown | |
service_item_detail_serial_number | Unknown | |
service_item_id | Unknown | |
service_item_initial_condition | Unknown | |
service_item_name | Unknown | |
service_item_updated_at | Instant | |
service_item_updated_by | Unknown | |
status | Unknown | |
sub_total | Unknown | |
total_amount | Unknown | |
total_promotion | Unknown | |
total_tax | Unknown | |
updated_at | Instant | |
updated_by | Unknown |
sales_fulfillment_users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
sales_fulfillment_id | Unknown | PKFK |
sales_fulfillment_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sales_fulfillment_id | Unknown | PKFK |
product_id | Unknown | FK |
fulfilled_quantity | Unknown | |
packed_quantity | Unknown | |
picked_quantity | Unknown | |
quantity | Unknown |
sales_fulfillment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
outlet_id | Unknown | FK |
sale_id | Unknown | FK |
created_at | Instant | |
note | Unknown | |
shipping_address_id | Unknown | |
state | Unknown | |
type | Unknown | |
updated_at | Instant | |
version | Unknown |
product_category_path
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_category_id | Unknown | PKFK |
name | Unknown |
product_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
leaf_category | Unknown | |
name | Unknown | |
parent_category_id | Unknown | |
payload_id | Unknown | |
root_category_id | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
balance | Unknown | |
company_name | Unknown | |
created_at | Instant | |
custom_field_1 | Unknown | |
custom_field_2 | Unknown | |
custom_field_3 | Unknown | |
custom_field_4 | Unknown | |
customer_code | Unknown | |
customer_group_ids | Json | |
date_of_birth | Unknown | |
deleted_at | Instant | |
do_not_email | Unknown | |
email | Unknown | |
enable_loyalty | Unknown | |
fax | Unknown | |
first_name | Unknown | |
gender | Unknown | |
last_name | Unknown | |
loyalty_balance | Unknown | |
loyalty_email_sent | Unknown | |
mobile | Unknown | |
note | Unknown | |
on_account_limit | Unknown | |
phone | Unknown | |
physical_address_1 | Unknown | |
physical_address_2 | Unknown | |
physical_city | Unknown | |
physical_country_id | Unknown | |
physical_postcode | Unknown | |
physical_state | Unknown | |
physical_suburb | Unknown | |
postal_address_1 | Unknown | |
postal_address_2 | Unknown | |
postal_city | Unknown | |
postal_country_id | Unknown | |
postal_postcode | Unknown | |
postal_state | Unknown | |
postal_suburb | Unknown | |
source_unique_id | Unknown | |
tax_id | Unknown | |
time_until_deletion | Unknown | |
twitter | Unknown | |
updated_at | Instant | |
version | Unknown | |
website | Unknown | |
year_to_date | Unknown |