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.
- Mining ERP
- Data model
The tables behind Mining ERP
Mining 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 work
Buyers, Quotes, sales orders and their lines hold the accepted demand and price basis.
Supply
Purchase orders, goods receipts and receipt acceptances separate commitment, arrival and usable stock.
Owned inventory
Stockpiles, stockpile positions, stockpile reservations and stock events represent custody and movement.
Processing and delivery
Work orders, processing completions, Dispatches and haulage results record actual output and buyer handoff.
Books
Invoices, Bills, cash receipts, journal entries and accounting periods connect operational sources to entity finance.
Every table, by feature
- Buyer orders10
- Purchasing11
- Stockpiles14
- Processing11
- Haulage and dispatch9
- Finance13
- Reporting12
- Shared and settings34
- Buyers
Entity-scoped trade customers, including dealer terms, holds and billing identity.
Linked to Entities, Payment terms, Price lists, Currencies - Buyer contacts
Contacts and delivery sites belong to the dealer and are separate from authentication.
Linked to Buyers - 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, Material units - Quotes
Versioned dealer offers with known pricing basis and real acceptance lineage.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Quote lines
All line/header discounts allocated once into accepted net value.
Linked to Quotes, Material units, Tax codes, Standard costs - Sales orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates 2, Document revisions, Approval decisions, Buyers - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Material units, Stockpiles - Credit reviews
Atomic dealer exposure review and separately bounded exception.
Linked to Entities, Buyers, Sales orders, Currencies - Sales allocations
Atomic claim of accepted line quantity and net/tax value across staged fulfillment/billing.
Linked to Dispatch lines, Entities, Invoice lines, Integration events
- Suppliers
Entity purchasing counterparties with separately controlled beneficiary data.
Linked to Payment terms, Master changes, Entities - 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, Material units, Stockpiles - Purchase orders
Immutable approved supplier commitments; cumulative amendments cannot bypass authority.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Purchase order lines
Buy-unit quantities, frozen commercial costs and current accepted scope.
Linked to Purchase orders, Requisition lines, Material 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, Stockpile locations, Standard costs - Receipt acceptances
Independent bounded disposition tranches against one immutable actual arrival.
Linked to Entities, Integration events, Goods receipt lines, Standard costs - Bills
Local supplier debit/credit documents with matching, carrying and separate settlement.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Bill lines
Supplier charges matched to accepted receipts, with explicit nonstock exceptions.
Linked to Bills, Return lines, Purchase order lines, Materials - Bill matches
Reserve and consume accepted receipt versus bill quantities/value once.
Linked to Receipt acceptances, Entities, Integration events, Bill lines
- Materials
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes - Material units
Versioned product-specific buy/sell packs and base conversions.
Linked to Materials, Units of measure, Master changes - Stockpiles
Physical sites may host segregated entity-owned positions; legal owner stays on each position.
Linked to Users - Stockpile locations
Shallow warehouse bins, staging and transit custody locations.
Linked to Stockpiles - Stockpile positions
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Entities, Materials, Stockpiles, Stockpile locations - Stockpile reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Stockpile positions, Stock layers - Stock transfers
Same-entity transfer with actual dispatch/partial receipt and retained owned transit.
Linked to Entities, Document revisions, Approval decisions, Stockpiles - Stock transfer lines
Partial transfer quantities retain equal in-transit ownership and cost.
Linked to Stock transfers, Materials, Stockpile locations - Stockpile counts
Blind scoped counts with explicit review and cost before adjustment.
Linked to Entities, Approval decisions, Stockpiles, Document revisions - Count lines
Observed base quantity and signed variance against an unchanged locked population.
Linked to Stockpile counts, Stockpile positions, Users, Stock events - Count locks
Time-bounded counted scope protecting all identities, including newly appearing positions.
Linked to Entities, Stockpile counts, Stockpiles - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Entities, Integration events, Approval decisions - Stock movements
Signed position/layer legs; transfers balance quantity and value by SKU.
Linked to Stock events, Stockpile positions, Stock layers, Stockpile reservations - Stock layers
Remaining quantity/carrying value with receipt/output/return lineage.
Linked to Entities, Stockpile positions, Materials, Stock events
- BOMs
Effective distribution assembly/repacking recipes with explicit output basis.
Linked to Master changes, Entities, Materials - BOM lines
Component quantities per explicit output basis, preserving dimensions and allowed loss.
Linked to BOMs, Materials - Processing routings
Versioned assembly/repacking instructions, distinct from delivery routes.
Linked to Entities, BOMs, Master changes - Processing operations
Ordered work instructions and declared labour/overhead bases.
Linked to Processing 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 materials
Frozen required input and actual traced issue/return scope.
Linked to Work orders, BOM lines, Materials, Stockpile reservations - Work order operations
Frozen instructions and assigned actual work.
Linked to Work orders, Processing operations, Users - Processing entries
Actual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.
Linked to Entities, Integration events, Work order operations, Users - Processing 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 - Stockpile reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Stockpile positions, Stock layers
- Load out tasks
Actual picked quantities remain exclusively tied to the order and do not post COGS.
Linked to Entities, Integration events, Sales order lines, Stockpile reservations - Dispatches
Actual dispatch and title/delivery state separated for partial deliveries.
Linked to Entities, Document revisions, Integration events, Sales orders - Dispatch lines
Actual dispatch quantities and current title-transferred/delivered portions.
Linked to Dispatches, Sales order lines, Stockpile reservations, Stock events - Haulage routes
Manual route/stop sequence and assigned execution; no optimization or live tracking.
Linked to Users, Entities, Document revisions, Approval decisions - Haulage stops
Explicit stable sequence and exact order/shipment ownership.
Linked to Haulage routes, Dispatches - Haulage attempts
Actual visit/handoff facts, separate from line outcomes and legal title.
Linked to Entities, Integration events, Haulage stops, Users - Haulage results
Each attempt allocates line outcomes once; one visit may partially deliver many lines.
Linked to Haulage attempts, Dispatch lines, Stock events, Return lines - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Material units, Stockpiles - Stockpile reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Stockpile positions, Stock layers
- Invoices
Local customer debit/credit documents with mandatory independent Finance Manager approval.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Invoice lines
Exact unbilled title-transferred accepted price allocation or original credit scope.
Linked to Dispatch lines, Return lines, Sales allocations, Invoices - Cash receipts
Actual customer cash recognized once to unapplied liability before invoice allocation.
Linked to Entities, Currencies, Exchange rates 2, Integration events - Cash applications
Cross-currency cash allocation consumes both receipt and invoice scope atomically.
Linked to Entities, Integration events, Approval decisions, Cash receipts - Bills
Local supplier debit/credit documents with matching, carrying and separate settlement.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Bill matches
Reserve and consume accepted receipt versus bill quantities/value once.
Linked to Receipt acceptances, Entities, Integration events, Bill lines - Payment runs
Frozen payable settlement proposals and protected beneficiary snapshots.
Linked to Document revisions, Approval decisions, 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, Bills, Exchange rates 2, Entities - Journal entries
Balanced entity-functional journals with source identity and immutable postings.
Linked to Integration events, Approval decisions, Accounting periods, Entities - Journal lines
Nonnegative debit/credit magnitudes, one side per line, balanced in functional precision.
Linked to Journal entries, Chart of accounts, Currencies - Accounting periods
Entity-specific fiscal periods and guarded close.
Linked to Entities, Approval decisions - Close tasks
Current source reconciliation evidence for an entity cutoff.
Linked to Entities, Accounting periods, Users
- Sales orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates 2, Document revisions, Approval decisions, Buyers - Sales order lines
Bounded accepted quantity/value and retained original promise.
Linked to Sales orders, Quote lines, Material units, Stockpiles - Purchase orders
Immutable approved supplier commitments; cumulative amendments cannot bypass authority.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Goods receipts
Immutable actual arrivals and separately accepted quantities.
Linked to Entities, Document revisions, Integration events, Purchase orders - Stockpile positions
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Entities, Materials, Stockpiles, Stockpile locations - Stock transfers
Same-entity transfer with actual dispatch/partial receipt and retained owned transit.
Linked to Entities, Document revisions, Approval decisions, Stockpiles - Dispatches
Actual dispatch and title/delivery state separated for partial deliveries.
Linked to Entities, Document revisions, Integration events, Sales orders - Haulage results
Each attempt allocates line outcomes once; one visit may partially deliver many lines.
Linked to Haulage attempts, Dispatch lines, Stock events, Return lines - Invoices
Local customer debit/credit documents with mandatory independent Finance Manager approval.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Bills
Local supplier debit/credit documents with matching, carrying and separate settlement.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Close tasks
Current source reconciliation evidence for an entity cutoff.
Linked to Entities, Accounting periods, Users - Journal entries
Balanced entity-functional journals with source identity and immutable postings.
Linked to Integration events, Approval decisions, Accounting periods, Entities
Keys and references
Keep source identities when importing orders, lots and financial balances. Each legal entity owns its own positions and books. References connect order lines to reservations, dispatch and billing; receipt lines to acceptance and bill matching; work orders to input and output. Corrections retain the original source.
Migration order
- Load entities, currencies, users and authority policies.
- Load materials, units, suppliers, buyers, terms, prices and stockpiles.
- Reconcile opening stock positions, open orders and financial balances to a single cutoff.
- Activate reviewed opening evidence before processing new receipts, dispatches or payments.
Set up Mining ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.