SambaPOS

Documentation Website

User Tools

Site Tools


Sidebar

Installation

User interface

Basic concepts

  • Departments
  • Terminals
  • Users & user roles
  • Work periods
  • Tickets & orders
  • The POS menu
    • Products & product categories
    • Menus
    • Recipes
    • Product modifiers

Quick-start: setting up a (very basic) POS configuration

Advanced concepts

Customizing your POS system

Extra

Mobile Client

SambaPOS License

the_sambapos_database_structure

1

Tables

  • AccountScreens
  • AccountScreenValues
  • AccountTransactionDocumentAccountMaps
  • AccountTransactionDocuments
  • AccountTransactionDocumentTypes
  • AccountTransactionDocumentTypeMaps
  • AccountTransactionDocumentTypes
  • AccountTransactions
  • AccountTransactionTypes
  • AccountTransactionValues
  • AccountTypes
  • ActionContainers
  • AppActions
  • AppRuleMaps
  • AppRules
  • AutomationCommandMaps
  • AutomationCommands
  • Calculations
  • CalculationTypes
  • CalculationSelectorMaps
  • CalculationSelectors
  • ChangePayments
  • ChangePaymentTypeMaps
  • ChangePaymentTypes
  • CostItems
  • Departments
  • Entities
  • EntityCustomFields
  • EntityScreenItems
  • EntityScreenMaps
  • EntityScreens
  • EntityStateValues
  • EntityTypeAssignments
  • EntityTypes
  • ForeignCurrencies
  • InventoryitemGroupCodes
  • InventoryItems
  • InventoryTransactionDocuments
  • InventoryTransactionDocumentTypes
  • InventoryTransactions
  • InventoryTransactionTypes
  • MenuAssignments
  • MenuItemPortions
  • MenuItemPriceDefinitions
  • MenuItemPrices
  • MenuItems
  • Numerators
  • OrderTagGroups
  • OrderTagMaps
  • OrderTags
  • PaidItems
  • Payments
  • PaymentTypeMaps
  • PaymentTypes
  • PeriodicConsumptionItems
  • PeriodicConsumptions
  • Permissions
  • PrinterMaps
  • Printers
  • PrinterTemplates
  • PrintJobs
  • ProdcutTimerMaps
  • ProductTimers
  • ProductTimerValues
  • ProgramSettingValues
  • RecipeItems
  • Recipes
  • ScreenMenuCategories
  • ScreenMenuItems
  • ScreenMenus
  • Scripts
  • States
  • TaskCustomFields
  • Tasks
  • TaskTokens
  • TaskTypes
  • TaxTemplateMaps
  • TaxTemplates
  • Terminals
  • TicketEntities
  • Tickets
  • TicketTagGroups
  • TicketTagMaps
  • TicketTags
  • TicketTypes
  • Triggers
  • UserRoles
  • Users
  • VersionInfo
  • WarehouseConsumptions
  • Warehouses
  • WarehouseTypes
  • Widgets
  • Workperiods
  • Example
the_sambapos_database_structure.txt · Last modified: 2019/04/19 03:24 by 93.179.68.108