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.
- Furniture ERP
- Data model
The tables behind Furniture ERP
Furniture ERP ships with 97 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
- 97
- Features
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Commercial demand
Customers, Quotes, sales orders and their lines identify the dealer, accepted scope and original promise.
Supply and inventory
Purchase orders, goods receipts, Inventory, Reservations and stock transfers distinguish committed, accepted, owned and available quantity.
Assembly
Bill of materials, Routings, work orders and production log connect a versioned recipe with actual operation evidence.
Fulfillment
Pick tasks, Deliveries, delivery routes and delivery results connect approved demand to actual movement and visit outcomes.
Finance
Customer invoices, cash receipts, cash applications and accounting periods retain approved amounts and their source.
Every table, by feature
- Sales and dealer orders7
- Purchasing and receiving8
- Inventory and transfers9
- Assembly and kitting9
- Fulfillment and delivery8
- Returns and corrections7
- Finance and collections8
- Shared and settings45
- Quotes
Versioned dealer 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, Cost standards - Sales orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates, Document revisions, Approval decisions, Customers - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Product units, Warehouses - Credit reviews
Atomic dealer exposure review and separately bounded exception.
Linked to Entities, Customers, Sales orders, Currencies - Customers
Entity-scoped trade customers, including dealer terms, holds and billing identity.
Linked to Entities, Payment terms, Price lists, Currencies - Customer contacts
Contacts and delivery sites belong to the dealer and are separate from authentication.
Linked to Customers
- 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 Sales order lines, Requisitions, Product units, Warehouses - 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, Integration events, Purchase orders - Goods receipt lines
Receipt history does not change as accepted inventory moves or is consumed.
Linked to Goods receipts, Purchase order lines, Locations, Cost standards - Suppliers
Entity purchasing counterparties with separately controlled beneficiary data.
Linked to Payment terms, Master changes, Entities - Supplier invoices
Local supplier debit/credit documents with matching, carrying and separate settlement.
Linked to Entities, Currencies, Exchange rates, Document revisions
- Products
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes - Inventory
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Entities, Products, Warehouses, Locations - Reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Inventory, Stock layers - Stock transfers
Same-entity transfer with actual dispatch/partial receipt and retained owned transit.
Linked to Entities, Document revisions, Approval decisions, Warehouses - Stock transfer lines
Partial transfer quantities retain equal in-transit ownership and cost.
Linked to Stock transfers, Products, Locations - Count plans
Blind scoped counts with explicit review and cost before adjustment.
Linked to Entities, Approval decisions, Warehouses, Document revisions - Count lines
Observed base quantity and signed variance against an unchanged locked population.
Linked to Count plans, Inventory, Users, Stock events - Warehouses
Physical sites may host segregated entity-owned positions; legal owner stays on each position.
Linked to Users - Locations
Shallow warehouse bins, staging and transit custody locations.
Linked to Warehouses
- Bill of materials
Effective distribution assembly/repacking recipes with explicit output basis.
Linked to Master changes, Entities, Products - BOM components
Component quantities per explicit output basis, preserving dimensions and allowed loss.
Linked to Bill of materials, Products - Routings
Versioned assembly/repacking instructions, distinct from delivery routes.
Linked to Entities, Bill of materials, Master changes - Work orders
Released bounded assembly/kitting/repacking, without plant APS or payroll scope.
Linked to Sales order lines, Users, Entities, Document revisions - Work order components
Frozen required input and actual traced issue/return scope.
Linked to Work orders, BOM components, Products, Reservations - Work order operations
Frozen instructions and assigned actual work.
Linked to Work orders, Routing operations, Users - Production log
Actual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.
Linked to Entities, Integration events, Work order operations, Users - Cost standards
Entity/product standard per base unit with immutable effective versions.
Linked to Entities, Products, Master changes - Products
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes
- Pick tasks
Actual picked quantities remain exclusively tied to the order and do not post COGS.
Linked to Entities, Integration events, Sales order lines, Reservations - Deliveries
Actual dispatch and title/delivery state separated for partial deliveries.
Linked to Entities, Document revisions, Integration events, Sales orders - Delivery lines
Actual dispatch quantities and current title-transferred/delivered portions.
Linked to Deliveries, Sales order lines, Reservations, Stock events - Delivery routes
Manual route/stop sequence and assigned execution; no optimization or live tracking.
Linked to Users, Entities, Document revisions, Approval decisions - Route stops
Explicit stable sequence and exact order/shipment ownership.
Linked to Delivery routes, Deliveries, Route stops - Delivery attempts
Actual visit/handoff facts, separate from line outcomes and legal title.
Linked to Entities, Integration events, Route stops, Users - Delivery results
Each attempt allocates line outcomes once; one visit may partially deliver many lines.
Linked to Delivery attempts, Delivery lines, Stock events, Return lines - Sales orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates, Document revisions, Approval decisions, Customers
- Returns
Bounded customer/supplier physical return authorization, separate from commercial credits.
Linked to Entities, Document revisions, Approval decisions, Customers - Return lines
Exact original commercial/stock scope and actual returned quantities.
Linked to Returns, Delivery lines, Goods receipt lines, Customer invoice lines - Return dispositions
Independent actual goods disposition without automatic credit or refund.
Linked to Return lines, Locations, Users, Stock events - Delivery results
Each attempt allocates line outcomes once; one visit may partially deliver many lines.
Linked to Delivery attempts, Delivery lines, Stock events, Return lines - Finance corrections
Independent reviewed reversals, bank returns, write-offs and charges without editing posted history.
Linked to Entities, Document revisions, Integration events, Approval decisions - Customer invoices
Local customer debit/credit documents with mandatory independent Finance Manager approval.
Linked to Entities, Currencies, Exchange rates, Document revisions - Approval decisions
Authoritative human decisions independent of document lifecycle.
Linked to Users, Authority delegations, Exchange rates, Entities
- Customer invoices
Local customer debit/credit documents with mandatory independent Finance Manager approval.
Linked to Entities, Currencies, Exchange rates, Document revisions - Customer invoice lines
Exact unbilled title-transferred accepted price allocation or original credit scope.
Linked to Delivery lines, Customer invoice lines, Return lines, Sales allocations - 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 - Bank statement lines
Actual external bank evidence, not inferred payment success.
Linked to Entities, Integration events, Bank accounts, Users - Close tasks
Current source reconciliation evidence for an entity cutoff.
Linked to Entities, Accounting periods, Users - Accounting periods
Entity-specific fiscal periods and guarded close.
Linked to Entities, Approval decisions - Journal entries
Balanced entity-functional journals with source identity and immutable postings.
Linked to Integration events, Approval decisions, Accounting periods, Journal entries
Keys and references
Each document has a stable business number and an internal identity. Reference columns bind lines to parents, approved decisions to frozen revisions, and financial records to the physical event they recognize. Entity and warehouse references define the operating boundary. Corrections point back to their source rather than replacing posted history.
Migration order
- Set the legal context. Load currencies, entities, users and authority policies.
- Prepare masters. Load customers, suppliers, products, units, warehouses and locations.
- Load control versions. Review prices, cost standards, bills of materials and routings.
- Open operations. Load accepted orders, purchasing commitments and reconciled opening inventory.
- Reconcile finance. Confirm open invoices, cash, bank and period balances before live transactions.
Set up Furniture ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.