All applications583

Find your application

583 applications

Open full catalog

Browse applications by category or open the full catalog.

  1. Hospitality ERP
  2. Data model
Reference

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 desk

11 tablesAbout this feature
  • 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

Housekeeping & room readiness

5 tablesAbout this feature
  • 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

Kitchen & food service

23 tablesAbout this feature
  • 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

Purchasing & suppliers

10 tablesAbout this feature
  • 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

Inventory & property supply

21 tablesAbout this feature
  • 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

Sales & billing

17 tablesAbout this feature
  • 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

Finance

34 tablesAbout this feature
  • 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

Reporting

10 tablesAbout this feature
  • 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
  • Authority delegations

    Time- and scope-bounded coverage, never a new role.

    Linked to Entities, Users, Currencies
  • 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

  1. 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.
  2. 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.
  3. 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.
  4. 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.

How to get started

A personal agent for your business

Get started with Proto

Your app is selected. Download Proto, then open it with this context.

Selected appHospitality ERP

Choose your computer’s platform.

Download Proto

Install Proto, then return to this panel.

Already installed? Open Proto

Free to use. Your own model provider may charge for usage.