Explore the Lightspeed Restaurant POS (O-Series/Kounta) data model

See how the various Lightspeed Restaurant POS (O-Series/Kounta) endpoints relate to each other, using our handy Entity Relationship Diagram.

Pulling data from Lightspeed Restaurant POS (O-Series/Kounta) is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only pull your Lightspeed Restaurant POS (O-Series/Kounta) endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Order

Documentation: https://apidoc.kounta.com/orders/#get-an-order

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
SaleNumber string - -
Status string - -
Notes string - -
Total decimal - -
Paid decimal - -
Tips decimal - -
SiteID int Site → ID -
RegisterID int Register → ID -
CreatedAt datetime - -
StaffMemberID int StaffMember → ID -
PriceVariation decimal - -
PriceFixedVariation decimal -
  • 12 Jul 2021 The price_fixed_variation only applies if there is a fixed-dollar discount against this order. It is mutually exclusive to price_variation
RefundedOrderID string - -
Deleted boolean - -
UpdatedAt datetime - -
Guests int -
  • 2 Dec 2020 Kounta only adds this property if `Guest Tracking` is enabled and if the number of guests is added against an order
OrderType string -
  • 2 Dec 2020 Kounta only adds this property if `Order Types` is enabled and if the order type is set in the order
CustomerID int Customer → ID -
Tip decimal - -
Tax decimal - -
RemoteStaffMemberID string - -
RemoteSiteID string - -
SaleID string - -
IsRefund boolean - -

OrderItem

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Number int - -
LineID string - -
Quantity decimal - -
Notes string - -
UnitPrice decimal - -
UnitTax decimal - -
LineTotalExTax decimal - -
LineTotalTax decimal - -
PriceVariation decimal - -
PriceFixedVariation decimal -
  • 12 Jul 2021 The price_fixed_variation only applies if there is a fixed-dollar discount against this order. It is mutually exclusive to price_variation
UnitPriceGross decimal - -
OrderID int Order → ID -
ProductID int Product → ID -

Product

Documentation: https://apidoc.kounta.com/products/#get-a-product

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
CreatedAt datetime - -
UpdatedAt datetime - -
VariantParentID int - -
Code string - -
FriendlyName string - -
Barcode string - -
Number string -
  • 15 Jul 2021 Although this field is called 'number', it is actually a string/code
IsModifier boolean - -
ShowOnline boolean - -
TopSeller boolean - -
SpecialItem boolean - -
AlwaysPrompt boolean - -
VariablePrice boolean - -
MinSellPrice decimal - -
MaxSellPrice decimal - -
UnitOfMeasure string - -
Measure decimal - -
IsSold boolean - -
Deleted boolean - -
Price decimal - -

Payment

Documentation: https://apidoc.kounta.com/payments/

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Number int - -
Amount decimal - -
Tip decimal - -
Reference string - -
CreatedAt datetime - -
OrderID int Order → ID -
PaymentMethodID string - -

OrderItemModifier

Column Type Relates to Notes
RemoteID string - -
OrderItemRemoteID string OrderItem → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
IsAddedToOrder boolean - -
IsRemovedFromOrder boolean - -
ProductID int Product → ID -
OrderItemID string OrderItem → RemoteID -

Site

Documentation: https://apidoc.kounta.com/sites/#get-a-site

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
TimeZone string - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Code string - -
BusinessNumber string - -
Email string - -
Mobile string - -
Phone string - -
Fax string - -
Website string - -
RegisterLevelReconciliation boolean - -

Customer

Documentation: https://apidoc.kounta.com/customers/#get-all-customers

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Phone string - -
Address string - -
City string - -
State string - -
PostalCode string - -
Country string - -
FirstName string - -
LastName string - -
PrimaryEmailAddress string - -
Image string - -
Email string - -
AvatarURL string - -
FullName string - -

Table

Documentation: https://apidoc.kounta.com/tables/#get-all-tables-for-a-site

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Siteid int Site → ID -
SectionName string - -
RemoteSiteID string - -

StaffMember

Documentation: https://apidoc.kounta.com/staff/#get-a-staff-member

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Fax string - -
Code string - -
PinRotationDays int - -
Mobile string - -
IsAdmin boolean - -
Address string - -
City string - -
State string - -
PostalCode string - -
Country string - -
FirstName string - -
LastName string - -
PrimaryEmailAddress string - -
Image string - -
Email string - -
AvatarURL string - -
FullName string - -

PriceList

Documentation: https://apidoc.kounta.com/price_lists/#get-a-price-list

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
ParentID int - -

ProductPrice

Column Type Relates to Notes
RemoteID string - -
PriceListRemoteID string PriceList → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID int Product → ID -
UnitPrice decimal - -
PriceListID int PriceList → ID -

Category

Documentation: https://apidoc.kounta.com/categories/#get-all-categories

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
ProductCount int - -

ProductCategory

Column Type Relates to Notes
RemoteID string - -
CategoryRemoteID string Category → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID int Product → ID -
CategoryID int Category → ID -
ProductRemoteID string - -

ReportingGroup

Documentation: https://apidoc.kounta.com/reporting_groups/#get-all-reporting-groups

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -

ReportingGroupProduct

Column Type Relates to Notes
RemoteID string - -
ReportingGroupRemoteID string ReportingGroup → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID int Product → ID -
ReportingGroupID int ReportingGroup → ID -

Register

Documentation: https://apidoc.kounta.com/registers/#get-a-register

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Code string - -
SalePrefix string - -
ReturnPrefix string - -
RemoteSiteID string - -

PurchaseOrder

Documentation: https://apidoc.kounta.com/purchase_orders/#get-a-purchase-order

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Status string - -
SupplierID int -
  • 26 May 2020 This seems to be pointing to a supplier id in a supplier table but there's no endpoint for suppliers in Kouanta API.
SupplierName string - -
SupplierEmail string - -
SiteID int Site → ID -
Notes string - -
PurchaseNumber string - -
SupplierInvoiceNumber string - -
Total decimal - -
TotalTax decimal - -
CreatedAt datetime - -
PlacedAt datetime - -
UpdatedAt datetime - -
DeliveredAt datetime - -
ReceivedAt datetime - -

PurchaseOrdersDetailLine

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Number int - -
ProductID int Product → ID -
Format string - -
Quantity decimal - -
UnitPriceExTax decimal - -
UnitTax decimal - -
LineTotalExTax decimal - -
LineTotalTax decimal - -
PurchaseOrderID int PurchaseOrder → ID -

Inventory

Documentation: https://apidoc.kounta.com/inventory/

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime -
  • 19 May 2020 Inventory is a snapshot in time, so it is fair to stamp this with the current timestamp
WhenModified datetime -
  • 19 May 2020 Inventory is a snapshot in time, so it is fair to stamp this with the current timestamp
ID int - -
ProductID int - -
Stock decimal - -
SiteID int Site → ID -

Reconciliation

Documentation: https://apidoc.kounta.com/reconciliations/#get-a-reconciliation

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Number int - -
Processed boolean - -
ReconciliationLevel string - -
RegisterID int Register → ID -
SiteID int Site → ID -
StaffMemberID int StaffMember → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
GiftCardPaymentsRedeemed decimal - -
PrePaymentsOut decimal - -

ReconciliationRevenueSale

Column Type Relates to Notes
RemoteID string - -
ReconciliationRemoteID string Reconciliation → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReconciliationID int Reconciliation → ID -
ProductID int Product → ID -

ReconciliationRevenueSaleAmount

Column Type Relates to Notes
RemoteID string - -
ReconciliationRevenueSaleRemoteID string ReconciliationRevenueSale → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ParentID string ReconciliationRevenueSale → RemoteID -
ParentType string - -
TaxID int -
  • 26 May 2020 Foreign Key: Refers to `Taxes` (not implemented).
Net decimal - -
Tax decimal - -

ReconciliationRevenueAccount

Column Type Relates to Notes
RemoteID string - -
ReconciliationRemoteID string Reconciliation → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReconciliationID int Reconciliation → ID -
ProductID int Product → ID -

ReconciliationRevenueAccountAmount

Column Type Relates to Notes
RemoteID string - -
ReconciliationRevenueAccountRemoteID string ReconciliationRevenueAccount → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ParentID string ReconciliationRevenueAccount → RemoteID -
ParentType string - -
TaxID int -
  • 26 May 2020 Foreign Key: Refers to `Taxes` (not implemented).
Net decimal - -
Tax decimal - -

ReconciliationRevenueLayby

Column Type Relates to Notes
RemoteID string - -
ReconciliationRemoteID string Reconciliation → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReconciliationID int Reconciliation → ID -
ProductID int Product → ID -

ReconciliationRevenueLaybyAmount

Column Type Relates to Notes
RemoteID string - -
ReconciliationRevenueLaybyRemoteID string ReconciliationRevenueLayby → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ParentID string ReconciliationRevenueLayby → RemoteID -
ParentType string - -
TaxID int -
  • 26 May 2020 Foreign Key: Refers to `Taxes` (not implemented).
Net decimal - -
Tax decimal - -

ReconciliationPaymentMethod

Column Type Relates to Notes
RemoteID string - -
ReconciliationRemoteID string Reconciliation → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ReconciliationID int Reconciliation → ID -
PaymentMethodID int PaymentMethod → ID -
TakingsSalesRecorded decimal - -
TakingsSalesCounted decimal - -
TakingsAccountsRecorded decimal - -
TakingsAccountsCounted decimal - -
TakingsLaybysRecorded decimal - -
TakingsLaybysCounted decimal - -
AdjustmentsCashIn decimal - -
AdjustmentsCashOut decimal - -
AdjustmentsTips decimal - -
GiftCardsTopup decimal - -
PrePaymentsIn decimal - -

CustomerTag

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerID int Customer → ID -
TagName string - -

PaymentMethod

Documentation: https://apidoc.kounta.com/payment_methods/

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
LedgerCode string - -

ProductSite

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SiteID int Site → ID -
ProductID int Product → ID -
UnitPrice decimal - -
UnitPriceExTax decimal - -
CostPrice decimal - -
CostPriceExTax decimal - -
IsInventory boolean - -
IsAvailable boolean - -

ProductTag

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID int Product → ID -
Tag string - -