These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Hospitality ERP
- Data model
The tables behind Hospitality ERP
Hospitality ERP ships with 131 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 131
- Features
- 8
- Change it
- Add fields and tables in Proto
How the model is organised
Bookings & front desk
Properties, room types, Rooms, PMS connections, PMS mappings, guest references, PMS reservations, PMS stay segments, PMS room assignments, PMS requests, PMS availability snapshots.
Housekeeping & room readiness
Room restrictions, room discrepancies, housekeeping plans, housekeeping tasks, housekeeping inspections.
Kitchen & food service
Products, units of measure, product units, BOMs, BOM lines, production routings, routing operations, work orders, work order materials, work order operations, production entries, production completions, work order cost entries, batch material allocations, batch reconciliations, shelf life policies, lot date events, kitchen check plans, kitchen check criteria, kitchen checks, kitchen check results, kitchen holds, kitchen dispositions.
Purchasing & suppliers
Suppliers, supplier bank accounts, Requisitions, requisition lines, purchase orders, purchase order lines, goods receipts, goods receipt lines, receipt acceptances, bill matches.
Inventory & property supply
Warehouses, Locations, Lots, lot portions, Serials, inventory positions, stock layers, stock events, stock movements, inventory reservations, stock transfers, stock transfer lines, count locks, inventory counts, count lines, Returns, return lines, return dispositions, property departments, department uses, department use lines.
Sales & billing
Accounts, contact persons, payment terms, price lists, price list entries, Quotes, quote lines, sales orders, sales order lines, sales allocations, credit reviews, pick tasks, Shipments, shipment lines, delivery confirmations, PMS folios, PMS ledger entries.
Finance
Entities, Currencies, exchange rates, accounting periods, chart of accounts, tax codes, standard costs, posting profiles, Invoices, invoice lines, Bills, bill lines, cash receipts, cash applications, credit applications, Refunds, finance corrections, bank accounts, bank statement lines, payment runs, Payments, payment allocations, revaluation runs, revaluation lines, journal entries, journal lines, close tasks, PMS financial batches, PMS financial components, PMS balance sources, PMS balance allocations, PMS tender settlements, PMS tender allocations, PMS reconciliations.
Reporting
Users, hospitality policies, master changes, document revisions, approval decisions, authority delegations, integration events, integration deliveries, migration batches, migration items.
Every table, by feature
- Bookings & front desk11
- Housekeeping & room readiness5
- Kitchen & food service23
- Purchasing & suppliers10
- Inventory & property supply21
- Sales & billing17
- Finance34
- Reporting10
- Properties
Separately mapped hotel properties with explicit company and business-date authority.
Linked to Entities, PMS connections, Hospitality policies, Master changes - Room types
Authoritative PMS room-type mapping without a local capacity ledger.
Linked to Properties, PMS connections - Rooms
Physical room identity with separately projected PMS occupancy and local work state.
Linked to Properties, Room types, PMS connections, PMS room assignments - PMS connections
Configured source namespace, event ordering and external authority, not an installed vendor connector.
Linked to Entities, Document revisions, Users, Master changes - PMS mappings
Versioned property/object/status and balanced financial source mapping rules.
Linked to Properties, Document revisions, Users, PMS connections - Guest references
Minimal protected source party references, not a local guest identity-document repository.
Linked to Properties, PMS connections, Accounts - PMS reservations
Versioned authoritative reservation mirror, never an independently confirmed local booking.
Linked to Entities, Properties, PMS connections, Integration events - PMS stay segments
Actual dated room/stay units under one external reservation, preserving amendments and performed history.
Linked to PMS connections, Integration events, PMS reservations, Room types - PMS room assignments
Authoritative physical-room occupancy segments; conflicts are visible, not silently rejected source reality.
Linked to Properties, PMS connections, Integration events, PMS stay segments - PMS requests
Approved or routine scoped intent with immutable idempotency and separate external outcome.
Linked to Entities, Properties, Document revisions, Users - PMS availability snapshots
Dated external room-type availability evidence for request preparation, not a local sellable pool.
Linked to Properties, PMS connections, Integration events, Room types
- Room restrictions
Independent local room restriction histories with overlapping active scope and approved releases.
Linked to Properties, Document revisions, Users, Integration events - Room discrepancies
Durable conflicts between PMS occupancy, local work, restrictions and source versions.
Linked to Properties, Integration events, Rooms, PMS room assignments - Housekeeping plans
Versioned task/check rules per property and service pattern, separate from occupancy authority.
Linked to Properties, Document revisions, Users, Master changes - Housekeeping tasks
Source-keyed actual room work with service-date deduplication and preserved completed revisions.
Linked to Properties, Document revisions, Users, Integration events - Housekeeping inspections
Independent actual cleaning/readiness check on one current completed turnover revision.
Linked to Properties, Document revisions, Users, Integration events
- Products
One canonical stocked SKU for each physical product/variant or produced kit; styles, barcodes and channel aliases never create extra stock.
Linked to Units of measure, Master changes, Shelf life policies - Units of measure
Dimension and precision for stock, purchase, sale and production quantities.
- Product units
Versioned product-specific buy/sell packs and base conversions.
Linked to Products, Units of measure, Master changes - BOMs
Versioned food recipe/formula for one primary output with independent technical and quality approval.
Linked to Entities, Products, Master changes, Kitchen check plans - BOM lines
Component quantities per explicit output basis, preserving dimensions and allowed loss.
Linked to BOMs, Products - Production routings
Versioned assembly/repacking instructions, distinct from delivery routes.
Linked to Entities, BOMs, Master changes - Routing operations
Ordered work instructions and declared labour/overhead bases.
Linked to Production routings - Work orders
Released bounded assembly/kitting/repacking, without plant APS or payroll scope.
Linked to Entities, Document revisions, Users, Approval decisions - Work order materials
Frozen required input and actual traced issue/return scope.
Linked to Work orders, BOM lines, Products, Inventory reservations - Work order operations
Frozen instructions and assigned actual work.
Linked to Work orders, Routing operations, Users - Production entries
Actual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.
Linked to Entities, Integration events, Work order operations, Users - Production completions
Accepted terminal output and WIP cost allocation, once per actual completed scope.
Linked to Entities, Integration events, Approval decisions, Work orders - Work order cost entries
Immutable WIP debit/credit sources and bounded actual-cost allocation.
Linked to Entities, Integration events, Work orders, Work order materials - Batch material allocations
Typed actual ingredient/packaging use and disjoint output/loss cost claims, separate from conservative exposure lineage.
Linked to Entities, Integration events, Approval decisions, Work orders - Batch reconciliations
Independent actual batch yield, component and packaging reconciliation with compatible units and exact WIP closure.
Linked to Entities, Document revisions, Users, Approval decisions - Shelf life policies
Versioned product-specific shelf, opening and remaining-life rules with explicit evidence and date meaning.
Linked to Entities, Document revisions, Users, Products - Lot date events
Immutable scoped manufacture, received, opening and date-decision evidence; current dates are controlled projections.
Linked to Entities, Document revisions, Users, Integration events - Kitchen check plans
Versioned product/operation criteria and sample/population rules for incoming, first-article, in-process and final decisions.
Linked to Entities, Products, Routing operations, Master changes - Kitchen check criteria
Actual measurable or pass/fail criteria with explicit units and known limits.
Linked to Kitchen check plans - Kitchen checks
Immutable sampled observations and reviewed population decisions, separately scoped from operations and financial completion.
Linked to Entities, Document revisions, Users, Integration events - Kitchen check results
One observed sample/characteristic result with evidence and explicit unavailable measurements.
Linked to Kitchen checks, Kitchen check criteria, Users - Kitchen holds
Restrictive exact material/output eligibility scope that follows descendants and blocks issue/dispatch even after relocation.
Linked to Entities, Integration events, Products, Lots - Kitchen dispositions
Bounded quality accept/rework/scrap/return decisions; production, stock and finance effects retain their own guarded evidence.
Linked to Entities, Document revisions, Users, Approval decisions
- Suppliers
Entity purchasing counterparties with separately controlled beneficiary data.
Linked to Entities, Payment terms, Master changes - Supplier bank accounts
Restricted supplier payment destinations with independent finance confirmation.
Linked to Suppliers, Currencies, Master changes - Requisitions
Operational purchasing demand without automatic spend approval.
Linked to Entities, Document revisions, Users, Approval decisions - Requisition lines
Requested product quantities and source demand identity.
Linked to Requisitions, Product units, Warehouses, Sales order lines - Purchase orders
Immutable approved supplier commitments; cumulative amendments cannot bypass authority.
Linked to Entities, Currencies, Exchange rates, Document revisions - Purchase order lines
Buy-unit quantities, frozen commercial costs and current accepted scope.
Linked to Purchase orders, Requisition lines, Product units, Tax codes - Goods receipts
Immutable actual arrivals and separately accepted quantities.
Linked to Entities, Document revisions, Users, Integration events - Goods receipt lines
Receipt history does not change as accepted inventory moves or is consumed.
Linked to Goods receipts, Purchase order lines, Locations, Standard costs - Receipt acceptances
Independent bounded disposition tranches against one immutable actual arrival.
Linked to Entities, Integration events, Goods receipt lines, Standard costs - Bill matches
Reserve and consume accepted receipt versus bill quantities/value once.
Linked to Entities, Integration events, Bill lines, Goods receipt lines
- Warehouses
Physical sites may host segregated entity-owned positions; legal owner stays on each position.
Linked to Users, Properties, Property departments - Locations
Shallow warehouse bins, staging and transit custody locations.
Linked to Warehouses - Lots
Entity/product lot identity with supplier/production provenance and independently controlled eligibility.
Linked to Entities, Products, Suppliers, Goods receipt lines - Lot portions
Identifiable internal lot populations with actual segregation and source-preserving splits; not independent regulatory lot codes.
Linked to Entities, Integration events, Lots, Stock events - Serials
Unique individual stock identity; same serial cannot be simultaneously stocked, consumed or delivered twice.
Linked to Entities, Products, Lots - Inventory positions
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Entities, Products, Warehouses, Locations - Stock layers
Remaining quantity/carrying value with receipt/output/return lineage.
Linked to Entities, Inventory positions, Products, Stock events - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Entities, Integration events, Approval decisions, Users - Stock movements
Signed position/layer legs; transfers balance quantity and value by SKU.
Linked to Stock events, Inventory positions, Stock layers, Inventory reservations - Inventory reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Inventory positions, Stock layers - Stock transfers
Same-entity transfer with actual dispatch/partial receipt and retained owned transit.
Linked to Entities, Document revisions, Users, Approval decisions - Stock transfer lines
Partial transfer quantities retain equal in-transit ownership and cost.
Linked to Stock transfers, Products, Locations - Count locks
Time-bounded counted scope protecting all identities, including newly appearing positions.
Linked to Entities, Inventory counts, Warehouses - Inventory counts
Blind scoped counts with explicit review and cost before adjustment.
Linked to Entities, Document revisions, Users, Approval decisions - Count lines
Observed base quantity and signed variance against an unchanged locked population.
Linked to Inventory counts, Inventory positions, Users, Stock events - Returns
Bounded customer/supplier physical return authorization, separate from commercial credits.
Linked to Entities, Document revisions, Users, Approval decisions - Return lines
Exact original commercial/stock scope and actual returned quantities.
Linked to Returns, Shipment lines, Goods receipt lines, Invoice lines - Return dispositions
Independent actual goods disposition without automatic credit or refund.
Linked to Entities, Integration events, Approval decisions, Return lines - Property departments
Actual property storeroom, kitchen, housekeeping and outlet cost/custody dimensions.
Linked to Entities, Properties, Warehouses, Chart of accounts - Department uses
Independently authorized actual irreversible food/supply use, separate from stock transfer and PMS charge.
Linked to Entities, Properties, Document revisions, Users - Department use lines
Exact source quantity/value slices consumed once by one actual department-use event.
Linked to Department uses, Products, Inventory reservations, Stock layers
- Accounts
Entity-scoped actual customer counterparty with accepted commercial and credit terms.
Linked to Entities, Payment terms, Price lists, Currencies - Contact persons
Actual customer business contacts and purposes, separate from application users and signers.
Linked to Accounts - Payment terms
Due-date terms, independent of actual cash settlement.
Linked to Entities, Master changes - Price lists
Effective entity/currency customer pricing; no accepted-price mutation.
Linked to Entities, Currencies, Master changes - Price list entries
Quantity-tier price basis in a named product unit.
Linked to Price lists, Product units - Quotes
Versioned customer offers with known pricing basis and real acceptance lineage.
Linked to Entities, Currencies, Exchange rates, Document revisions - Quote lines
All line/header discounts allocated once into accepted net value.
Linked to Quotes, Product units, Tax codes, Standard costs - Sales orders
Account-accepted scope plus mandatory independent commercial approval.
Linked to Entities, Currencies, Exchange rates, Document revisions - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Product units, Warehouses - Sales allocations
Atomic claim of accepted line quantity and net/tax value across staged fulfillment/billing.
Linked to Entities, Integration events, Sales order lines, Shipment lines - Credit reviews
Atomic customer exposure review and separately bounded exception.
Linked to Entities, Accounts, Sales orders, Currencies - Pick tasks
Actual picked quantities remain exclusively tied to the order and do not post COGS.
Linked to Entities, Integration events, Sales order lines, Inventory reservations - Shipments
Approved customer shipment/customer handover scope with actual title evidence, not a documentary bank event.
Linked to Entities, Document revisions, Users, Integration events - Shipment lines
Actual dispatch quantities and current title-transferred/delivered portions.
Linked to Shipments, Sales order lines, Inventory reservations, Stock events - Delivery confirmations
Actual customer delivery confirmation against an already handed-over packet, without another title or cost event.
Linked to Shipment lines, Return lines, Entities, Integration events - PMS folios
Authoritative guest/corporate/deposit subaccount mirror, not local invoice or spendable cash.
Linked to Entities, Properties, PMS connections, Integration events - PMS ledger entries
Immutable authoritative PMS economic component and wrapper evidence with exclusive financial routing.
Linked to Entities, Properties, PMS connections, Integration events
- Entities
Separate legal books and stock ownership; shared masters do not consolidate balances.
Linked to Currencies, Hospitality policies - Currencies
Currency precision and display rules.
- Exchange rates
Immutable dated conversion evidence; no hidden fallback.
Linked to Entities, Currencies, Users - Accounting periods
Entity-specific fiscal periods and guarded close.
Linked to Entities, Approval decisions - Chart of accounts
Entity ledger accounts, including controlled subledger accounts.
Linked to Entities, Master changes - Tax codes
Configured additive tax treatment and evidence; no universal tax engine or filing claim.
Linked to Entities, Chart of accounts, Master changes - Standard costs
Entity/product standard per base unit with immutable effective versions.
Linked to Entities, Products, Master changes - Posting profiles
Approved source-specific stock, production and trade posting mappings.
Linked to Entities, Products, Chart of accounts, Master changes - Invoices
Local customer debit/credit documents with mandatory independent Finance Manager approval.
Linked to Entities, Currencies, Exchange rates, Document revisions - Invoice lines
Exact unbilled title-transferred accepted price allocation or original credit scope.
Linked to Invoices, Sales order lines, Shipment lines, Return lines - Bills
Local supplier debit/credit documents with matching, carrying and separate settlement.
Linked to Entities, Currencies, Exchange rates, Document revisions - Bill lines
Supplier charges matched to accepted receipts, with explicit nonstock exceptions.
Linked to Bills, Purchase order lines, Return lines, Products - Cash receipts
Actual customer cash recognized once to unapplied liability before invoice allocation.
Linked to Entities, Currencies, Exchange rates, Integration events - Cash applications
Cross-currency cash allocation consumes both receipt and invoice scope atomically.
Linked to Entities, Integration events, Approval decisions, Cash receipts - Credit applications
Bounded customer/supplier credit allocation with retained surplus and reservations.
Linked to Entities, Integration events, Approval decisions, Invoices - Refunds
Independent finance-authorized cash movement from exactly one available credit/unapplied source.
Linked to Entities, Document revisions, Users, Integration events - Finance corrections
Independent reviewed reversals, bank returns, write-offs and charges without editing posted history.
Linked to Entities, Document revisions, Users, Integration events - Bank accounts
Entity-owned bank currency balances and restricted destination data.
Linked to Entities, Currencies, Chart of accounts, Master changes - Bank statement lines
Actual external bank evidence, not inferred payment success.
Linked to Entities, Integration events, Bank accounts, Users - Payment runs
Frozen payable settlement proposals and protected beneficiary snapshots.
Linked to Entities, Document revisions, Users, Approval decisions - Payments
One economic supplier disbursement with authoritative settlement/rejection/return evidence.
Linked to Entities, Integration events, Payment runs, Suppliers - Payment allocations
Reserved bill and payment currency quantities with current-carrying settlement.
Linked to Entities, Integration events, Payments, Bills - Revaluation runs
Delta remeasurement of entity monetary balances after reconciliation, not presentation consolidation.
Linked to Entities, Document revisions, Users, Approval decisions - Revaluation lines
One remaining monetary source, not both detail and its control total.
Linked to Revaluation runs, Currencies, Exchange rates - Journal entries
Balanced entity-functional journals with source identity and immutable postings.
Linked to Entities, Document revisions, Users, Integration events - Journal lines
Nonnegative debit/credit magnitudes, one side per line, balanced in functional precision.
Linked to Journal entries, Chart of accounts, Currencies, Properties - Close tasks
Current source reconciliation evidence for an entity cutoff.
Linked to Entities, Accounting periods, Users - PMS financial batches
Finite independently approved balanced ERP GL bridge packet of immutable source components.
Linked to Entities, Properties, Document revisions, Users - PMS financial components
Exact signed GL leg and source/control ownership within an approved PMS bridge packet.
Linked to PMS financial batches, PMS ledger entries, PMS mappings, Chart of accounts - PMS balance sources
Positive disjoint PMS-controlled receivable, liability and tender sources with local carrying and no second local AR ledger.
Linked to Entities, Properties, PMS folios, PMS ledger entries - PMS balance allocations
Shared exact existing control-source claims for authoritative deposit/payment/credit/transfer/correction events.
Linked to Entities, Integration events, PMS balance sources, PMS financial components - PMS tender settlements
Actual bank/cash custody versus previously recognized PMS tender clearing, never another guest receipt or sale.
Linked to Entities, Properties, Document revisions, Users - PMS tender allocations
Exact signed tender asset/liability source slices sharing one actual settlement packet and all source claims.
Linked to PMS tender settlements, PMS balance sources, Finance corrections - PMS reconciliations
Immutable source-cutoff coverage and control-balance reconciliation, not a new snapshot posting.
Linked to Entities, Properties, Document revisions, Users
- Users
Authenticated actors and explicit entity/role scope; no party record automatically creates an account.
Linked to Master changes - Hospitality policies
Versioned operational and financial rules with explicit finite limits.
Linked to Entities, Currencies, Users, Approval decisions - Master changes
Protected master activation without direct Manage permission bypass.
Linked to Entities, Users, Approval decisions - Document revisions
Immutable typed document snapshots and source basis.
Linked to Entities, Users - Approval decisions
Authoritative human decisions independent of document lifecycle.
Linked to Entities, Document revisions, Users, Authority delegations - Integration events
Authenticated inbound/manual evidence with idempotent economic effects.
Linked to Entities, Users - Integration deliveries
Outbound intent, attempt and reconciliation; a timeout is not nonexecution.
Linked to Entities, Document revisions, Integration events - Migration batches
Reviewed cutover: one full opening GL plus nonposting detailed balances.
Linked to Entities, Journal entries, Users, Approval decisions - Migration items
Replay-safe original identities, detailed remaining balances and prior effects.
Linked to Migration batches
Keys and references
A property room number, guest name or folio label is not a universal key. PMS references retain the connection, property and external object or event identity. Source versions and content hashes distinguish a repeated message from a changed fact. Conflicting or incomplete updates remain visible until the authoritative source is reconciled.
Reservations and stay segments describe PMS facts. Housekeeping records describe actual local work and inspection. Cleaning does not itself change occupancy, and an authoritative occupancy change cannot erase a local restriction or discrepancy. Each decision applies to its exact current source and actual person.
PMS ledger detail retains its external financial identity. The reviewed bridge owns its one local journal effect, with guest, deposit, corporate and tender-clearing sources kept distinct. Local goods invoices and cash applications own a separate route. A summary, component and local invoice cannot all post the same sale.
Stock and production references preserve original quantity and carrying through current positions, layers and exclusive claims. Department transfers retain stock; actual use consumes its own remaining source. Partial lots, returns and work in progress keep their original history rather than reviving a depleted balance.
Migration order
- Establish the masters and mappings. Create legal companies, properties, departments and source connections with approved authority. Map rooms, guest references and financial source codes. Review products, units, recipes, accounts and currency bases before importing dependent work.
- Reconcile the source history. Bring forward current PMS reservations, stay segments, room assignments and ledger references with their original identities. Preserve room restrictions, completed and unfinished housekeeping, source event versions and prior consumed or posted scope. Missing predecessor history remains unresolved.
- Approve the opening position. Reconcile stock, lot/date evidence, issued production work and local open finance alongside external guest, deposit, corporate and tender-clearing balances. Finance approves one company opening ledger at the cutoff; imported detail explains that opening without creating another posting.
- Verify the first native work. Confirm the next booking request, room turnover, receipt, production completion and financial bridge event use only their eligible remaining source. Reconcile duplicate, late and uncertain outcomes before enabling the wider scope. Historical imports must not repeat work already performed.
Set up Hospitality ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.