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.
- Telecom ERP
- Data model
The tables behind Telecom ERP
Telecom 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
Dealer trade
Subscribers, subscriber contacts, service quotes, service quote lines, service orders and service order lines keep the account, offer and accepted demand separate.
Supply
Requisitions, purchase orders, goods receipts and receipt acceptances connect shortage to actual accepted arrivals.
Stock and work
Service items, inventory positions, inventory reservations, stock events, stock transfers and work orders distinguish item identity, custody and movement.
Delivery
Pick tasks, Shipments, delivery routes, route stops and delivery results retain planning and actual outcomes.
Finance
Invoices, cash receipts, Bills, Payments, journal entries and accounting periods keep commercial documents and posted books linked.
Every table, by feature
- Dealer sales10
- Purchasing and receipts9
- Warehouse inventory12
- Assembly and kitting10
- Fulfillment and delivery9
- Finance and returns13
- Shared and settings38
- Subscribers
Entity-scoped trade customers, including dealer terms, holds and billing identity.
Linked to Entities, Payment terms, Rate plans, Currencies - Subscriber contacts
Contacts and delivery sites belong to the dealer and are separate from authentication.
Linked to Subscribers - Service quotes
Versioned dealer offers with known pricing basis and real acceptance lineage.
Linked to Entities, Currencies, Exchange rates, Document revisions - Service quote lines
All line/header discounts allocated once into accepted net value.
Linked to Service quotes, Service item units, Tax codes, Standard costs - Rate plans
Effective entity/currency dealer pricing; no accepted-price mutation.
Linked to Entities, Currencies, Master changes - Rate plan entries
Quantity-tier price basis in a named product unit.
Linked to Rate plans, Service item units - Service orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates, Document revisions, Approval decisions, Subscribers - Service order lines
Bounded accepted quantity/value and retained original promise.
Linked to Service orders, Service quote lines, Service item units, Service sites - Credit reviews
Atomic dealer exposure review and separately bounded exception.
Linked to Entities, Subscribers, Service orders, Currencies - Approval decisions
Authoritative human decisions independent of document lifecycle.
Linked to Users, Authority delegations, Exchange rates, 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 Service order lines, Requisitions, Service item units, Service sites - 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, Service item 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, 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 Bill matches, Receipt acceptances, Entities, Integration events - Bills
Local supplier debit/credit documents with matching, carrying and separate settlement.
Linked to Entities, Currencies, Exchange rates, Document revisions
- Service items
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Master changes - Service item units
Versioned product-specific buy/sell packs and base conversions.
Linked to Service items, Units of measure, Master changes - Service sites
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 Service sites - Inventory positions
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Entities, Service items, Service sites, Locations - 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, Approval decisions, Service sites - Stock transfer lines
Partial transfer quantities retain equal in-transit ownership and cost.
Linked to Stock transfers, Service items, Locations - Inventory counts
Blind scoped counts with explicit review and cost before adjustment.
Linked to Entities, Approval decisions, Service sites, Document revisions - Count lines
Observed base quantity and signed variance against an unchanged locked population.
Linked to Inventory counts, Inventory positions, Users, Stock events - Count locks
Time-bounded counted scope protecting all identities, including newly appearing positions.
Linked to Entities, Inventory counts, Service sites - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Stock events, Entities, Integration events
- BO ms
Effective distribution assembly/repacking recipes with explicit output basis.
Linked to Master changes, Entities, Service items - BOM lines
Component quantities per explicit output basis, preserving dimensions and allowed loss.
Linked to BO ms, Service items - Production routings
Versioned assembly/repacking instructions, distinct from delivery routes.
Linked to Entities, BO ms, 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 Service order lines, Users, Entities, Document revisions - Work order materials
Frozen required input and actual traced issue/return scope.
Linked to Work orders, BOM lines, Service items, 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
- Pick tasks
Actual picked quantities remain exclusively tied to the order and do not post COGS.
Linked to Entities, Integration events, Service order lines, Inventory reservations - Shipments
Actual dispatch and title/delivery state separated for partial deliveries.
Linked to Entities, Document revisions, Integration events, Service orders - Shipment lines
Actual dispatch quantities and current title-transferred/delivered portions.
Linked to Shipments, Service order lines, Inventory 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, Shipments, 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, Shipment lines, Stock events, Return lines - Inventory reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Inventory positions, Stock layers - Stock events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Stock events, Entities, Integration events
- 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 Shipment lines, Invoice lines, Return lines, Service 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 - Returns
Bounded customer/supplier physical return authorization, separate from commercial credits.
Linked to Entities, Document revisions, Approval decisions, Subscribers - 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 Return lines, Locations, Users, Stock events - Bills
Local supplier debit/credit documents with matching, carrying and separate settlement.
Linked to Entities, Currencies, Exchange rates, Document revisions - Bill matches
Reserve and consume accepted receipt versus bill quantities/value once.
Linked to Bill matches, Receipt acceptances, Entities, Integration events - 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, Vendors - Bank statement lines
Actual external bank evidence, not inferred payment success.
Linked to Entities, Integration events, Bank accounts, Users - Finance corrections
Independent reviewed reversals, bank returns, write-offs and charges without editing posted history.
Linked to Entities, Document revisions, Integration events, Approval decisions
Keys and references
Each document has its own number, revision, entity and source references. Lines carry the quantity that downstream records may consume. Approval decisions hold independent human decisions; document revisions hold frozen document content. Stock events and integration events preserve the economic event and its operation key. Users provide accountable actors while scope controls which entity and warehouse they can work in.
Migration order
- Configure Entities, Currencies, Users, distribution policies and approval authority.
- Load service items, service item units, service sites, Locations, rate plans, Vendors and Subscribers.
- Reconcile opening inventory positions, supplier and customer balances with migration batches.
- Bring current service orders, purchase orders and open fulfillment scope into the operating cycle.
- Verify journals, bank balances and open accounting periods before posting new activity.
Set up Telecom ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.