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.
- Paper & Pulp ERP
- Data model
The tables behind Paper & Pulp ERP
Paper & Pulp 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
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and settings
Entities, Users, distribution policies, Approvals and master changes establish scope and decision history.
Customers and sales
Customers, Quotes, sales orders and sales allocations retain accepted commercial demand.
Purchasing and suppliers
Requisitions, purchase orders, goods receipts and supplier invoices connect requested supply to accepted arrivals and bills.
Receiving and inventory
Products, product units, Inventory, Reservations, stock events and stock transfers retain physical and owned quantity.
Fulfillment and returns
Deliveries, delivery routes, delivery attempts and Returns record handoff and reverse movement.
Production
Bill of materials, Routings, work orders and production completions represent bounded assembly work.
Finance and collections
Customer invoices, cash receipts, Payments, journal entries and accounting periods retain the books and settlement evidence.
Every table, by feature
- Customers
Entity-scoped trade customers: commercial terms, credit identity and billing identity.
Linked to Entities, Payment terms, Price lists, Currencies - Customer contacts
Contacts and delivery sites belonging to a customer, separate from authentication.
Linked to Customers - Price lists
Effective entity/currency dealer 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 - Product units
Versioned product-specific buy/sell packs and base conversions.
Linked to Products, Units of measure, Master changes - 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, Approvals, 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 - Sales allocations
Atomic claim of accepted line quantity and net/tax value across staged fulfillment/billing.
Linked to Delivery lines, Entities, Customer invoice lines, Integration events
- Requisitions
Operational purchasing demand without automatic spend approval.
Linked to Entities, Document revisions, Users, Approvals - 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 - Suppliers
Entity purchasing counterparties with separately controlled beneficiary data.
Linked to Payment terms, Master changes, Entities - Supplier bank accounts
Restricted supplier payment destinations with independent finance confirmation.
Linked to Suppliers, Currencies, Master changes - 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 - Receipt acceptances
Independent bounded disposition tranches against one immutable actual arrival.
Linked to Entities, Integration events, Goods receipt lines, Cost standards - Supplier invoices
A supplier's invoice, matched line by line to the purchase order and the goods receipt within tolerances before it becomes payable.
Linked to Entities, Currencies, Exchange rates, Document revisions - Supplier invoice lines
Line items of a supplier invoice.
Linked to Supplier invoice lines, Supplier invoices, Purchase order lines, Return lines - Match exceptions
A difference the three-way match found between the invoice, the order and the receipt, with the amount and who it is with.
Linked to Match exceptions, Receipt acceptances, Entities, Integration events
- Products
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes - Product units
Versioned product-specific buy/sell packs and base conversions.
Linked to Products, Units of measure, Master changes - Units of measure
Dimension and precision for stock, purchase, sale and production quantities.
- 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 - Inventory
On-hand stock per product per warehouse, with custody state and carrying value.
Linked to Entities, Products, Warehouses, Locations - Reservations
Stock reserved against a sales order or work order need date, hard to a lot or soft to a quantity.
Linked to Entities, Integration events, Inventory, Stock layers - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Stock events, Entities, Integration events - Stock movements
Signed position/layer legs; transfers balance quantity and value by SKU.
Linked to Stock events, Inventory, Stock layers, Reservations - Stock layers
Remaining quantity/carrying value with receipt/output/return lineage.
Linked to Entities, Inventory, Products, Stock events - Stock transfers
Same-entity transfer with actual dispatch/partial receipt and retained owned transit.
Linked to Entities, Document revisions, Approvals, Warehouses - Stock transfer lines
Partial transfer quantities retain equal in-transit ownership and cost.
Linked to Stock transfers, Products, Locations - Count plans
A cycle count or full physical inventory: the warehouse, scope, when it runs and who approves the variances.
Linked to Entities, Approvals, Warehouses, Document revisions - Count lines
Observed base quantity and signed variance against an unchanged locked population.
Linked to Count plans, Inventory, Users, Stock events
- Sales orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates, Document revisions, Approvals, Customers - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Product units, Warehouses - Reservations
Stock reserved against a sales order or work order need date, hard to a lot or soft to a quantity.
Linked to Entities, Integration events, Inventory, Stock layers - 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
A shipment to a customer against a sales order: picked, packed and sent with the carrier reference.
Linked to Entities, Document revisions, Integration events, Sales orders - Delivery lines
Line items of a delivery.
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, Approvals - 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 - Returns
Bounded customer/supplier physical return authorization, separate from commercial credits.
Linked to Entities, Document revisions, Approvals, Customers - Return lines
Exact original commercial/stock scope and actual returned quantities.
Linked to Returns, Delivery lines, Goods receipt lines, Customer invoice lines
- Products
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes - Bill of materials
Bill of materials header: the recipe for producing a given product.
Linked to Master changes, Entities, Products - BOM components
Each component consumed to build the parent product.
Linked to Bill of materials, Products - Routings
Routing header: the sequence of operations required to build a product.
Linked to Entities, Bill of materials, Master changes - Routing operations
Ordered work instructions and declared labour/overhead bases.
Linked to Routings - 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
Exploded bill-of-materials demand for a work order: what material is needed and from where.
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
Shop-floor time and quantity transactions against a work-order operation.
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, Approvals, 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 components - Cost standards
The standard cost of an item by version, pending or current, activated on a date.
Linked to Entities, Products, Master changes
- Customer invoices
The customer invoice a delivery raises at the order price; partial deliveries invoice partially.
Linked to Entities, Currencies, Exchange rates, Document revisions - Customer invoice lines
Line items of a customer invoice.
Linked to Delivery lines, Customer invoice lines, Return lines, Sales allocations - Supplier invoices
A supplier's invoice, matched line by line to the purchase order and the goods receipt within tolerances before it becomes payable.
Linked to Entities, Currencies, Exchange rates, Document revisions - Supplier invoice lines
Line items of a supplier invoice.
Linked to Supplier invoice lines, Supplier invoices, Purchase order lines, Return lines - 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, Approvals, Cash receipts - Payment runs
Frozen payable settlement proposals and protected beneficiary snapshots.
Linked to Document revisions, Approvals, Users, Entities - 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 Payments, Supplier invoices, Exchange rates, Payment allocations - Bank statement lines
Actual external bank evidence, not inferred payment success.
Linked to Entities, Integration events, Bank accounts, Users - Journal entries
Balanced entity-functional journals with source identity and immutable postings.
Linked to Integration events, Approvals, Accounting periods, Journal entries - Journal entry lines
Line items of a journal entry.
Linked to Journal entries, Chart of accounts, Currencies - 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, Approvals - Revaluation runs
Delta remeasurement of entity monetary balances after reconciliation, not presentation consolidation.
Linked to Entities, Document revisions, Approvals, Accounting periods
Keys and references
Sales order lines link to sales orders and product units. Purchase order lines link to purchase orders, product units and Warehouses. Goods receipt lines link actual arrival to a purchase order lines source; receipt acceptances retain the accepted tranche. Inventory positions link Product, Warehouse, Location and Entity. Delivery lines link a shipment to its order line and reservation. Customer invoice lines preserve shipment or order allocation. Each posted financial effect belongs to an entity and its applicable period.
Migration order
- Create Entities, Currencies, Users and decision policies.
- Activate Products, units of measure, product units, Warehouses and Locations.
- Load Customers, Suppliers, price lists and payment terms.
- Reconcile opening Inventory, customer and supplier balances to the chosen cutoff.
- Bring forward open order, purchase, delivery and payment work with source identities.
- Check journals and close tasks before operating the next period.
Set up Paper & Pulp ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.