Understand the locations table | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/ecommerce-pos-understand-the-locations-table Publisher: Pixie Technologies LLC Technical architecture, tables and endpoint reference Understand the locations table Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Map the module-owned locations records without editing them directly. Audience: Developers, auditors and support engineers; Permission: Read-only code review plus the permission of the relevant live action; Module v1.0.0 · code-inspected; Where to goModule code and Enterprise POS administration What this guide helps you do Map the module-owned locations records without editing them directly. This section maps all module-owned tables, controller endpoints, transactions, tenant keys and host integrations without instructing direct database edits. Follow these steps - Go to Module code and Enterprise POS administration and open the workflow that matches “Understand the locations table”. Confirm the page or record context before making a change. - Use the supplied module package as the authoritative source. - Map the requested workflow to its controller, model/service method, table and permission. - Check tenant and transaction boundaries. - Use live UI/API behaviour for functional tests. - Do not change schema or records outside the verified module lifecycle. Fields and options - Guide focus: Map the module-owned locations records without editing them directly. - Purpose: Tenant operating locations and timezones. - Physical name uses the host prefix plus bpos_locations. - 25 module tables - 3 controllers plus one compatibility controller - Model and service transaction methods - Host hooks for activation, cron and invoice payments - Public/API/admin routes - Tenant key, correlation IDs and immutable snapshots Rules and limits - Purpose: Tenant operating locations and timezones. - Physical name uses the host prefix plus bpos_locations. - Business writes run inside database transactions where required. - Tenant key is applied to module-owned records. - Existing order line/payment/stock snapshots are not recalculated from current product values. - Core invoice linkage uses invoice_id and host models/hooks rather than modifying unrelated core schema. Check it worked - The specific outcome described by this guide is visible and remains tenant-scoped. - Support engineers can trace each workflow from route to persisted evidence. - Schema references accurately distinguish live UI from reserved/future-capable structures. Safety checks and troubleshooting - Do not run direct database commands from this documentation. - Do not expose secret/hash fields. - Do not infer a user interface merely because a table/column exists. Stay within the supported module flow Use the supplied UI, host module lifecycle and documented endpoints. Do not bypass tenant filters, permissions, CSRF, idempotency, rate limits, audit evidence or transaction checks. A stored table or field does not imply that version 1.0.0 exposes a management screen for it. Related guides eCommerce & POS Module overview (https://pixiecrm.com/help-centre/ecommerce-pos-module-overview)Understand cron and payment hooks (https://pixiecrm.com/help-centre/ecommerce-pos-understand-cron-and-payment-hooks)Understand the categories table (https://pixiecrm.com/help-centre/ecommerce-pos-understand-the-categories-table)Understand the registers table (https://pixiecrm.com/help-centre/ecommerce-pos-understand-the-registers-table)Understand the shifts table (https://pixiecrm.com/help-centre/ecommerce-pos-understand-the-shifts-table)Understand the public shop route map (https://pixiecrm.com/help-centre/ecommerce-pos-understand-the-public-shop-route-map)Troubleshoot a module activation error (https://pixiecrm.com/help-centre/ecommerce-pos-troubleshoot-a-module-activation-error)Browse the connected Technical architecture, tables and endpoint reference topic (https://pixiecrm.com/help-centre/topic/ecommerce-pos-technical)Browse all eCommerce & POS Module guides (https://pixiecrm.com/help-centre/category/ecommerce-pos)Open the related Help Centre category (https://pixiecrm.com/help-centre/category/data-privacy-security)