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.
- Media ERP
- Data model and import order
The tables behind Media ERP
Media 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
Customer orders:
Advertisers, Quotes, quote lines, ad orders, ad order lines and credit reviews retain the accepted commercial scope.
Purchasing:
Requests, vendor orders, ingest receipts, ingest acceptances, Bills and bill matches connect supplier commitment with actual accepted goods and charges.
Stock:
Content items, content libraries, content availability, content batches, content reservations, content events and content transfers carry identity, quantity, custody and cost.
Assembly:
Content assemblies, Projects, production materials, production entries and production completions connect input with terminal output.
Fulfillment:
Pick tasks, Shipments, delivery routes, route stops, delivery attempts, delivery results and Returns record physical outcomes.
Finance:
Invoices, cash receipts, cash applications, payment runs, Payments, journal entries and accounting periods carry receivables, payables and close.
Every table, by feature
- Customer orders10
- Purchasing10
- Stock control12
- Assembly and kitting10
- Fulfillment and delivery9
- Returns8
- Finance13
- Shared and settings32
- Advertisers
Entity-scoped trade customers, including dealer terms, holds and billing identity.
Linked to Entities, Payment terms, Rate cards, Currencies - Advertiser contacts
Contacts and delivery sites belong to the dealer and are separate from authentication.
Linked to Advertisers - 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, Content files, Tax codes, Standard rates - Ad orders
Dealer-accepted scope plus mandatory independent commercial approval.
Linked to Exchange rates 2, Document revisions, Approval decisions, Advertisers - Ad order lines
Bounded accepted quantity/value and retained original promise.
Linked to Ad orders, Quote lines, Content files, Content libraries - Credit reviews
Atomic dealer exposure review and separately bounded exception.
Linked to Entities, Advertisers, Ad orders, Currencies - Rate cards
Effective entity/currency dealer pricing; no accepted-price mutation.
Linked to Entities, Currencies, Configuration changes - Rate card entries
Quantity-tier price basis in a named product unit.
Linked to Rate cards, Content files - Approval decisions
Authoritative human decisions independent of document lifecycle.
Linked to Users, Authority delegations, Exchange rates 2, Entities
- Requests
Operational purchasing demand without automatic spend approval.
Linked to Entities, Document revisions, Users, Approval decisions - Request lines
Requested product quantities and source demand identity.
Linked to Ad order lines, Requests, Content files, Content libraries - Vendor orders
Immutable approved supplier commitments; cumulative amendments cannot bypass authority.
Linked to Entities, Currencies, Exchange rates 2, Document revisions - Vendor order lines
Buy-unit quantities, frozen commercial costs and current accepted scope.
Linked to Vendor orders, Request lines, Content files, Tax codes - Ingest receipts
Immutable actual arrivals and separately accepted quantities.
Linked to Entities, Document revisions, Integration events, Vendor orders - Ingest lines
Receipt history does not change as accepted inventory moves or is consumed.
Linked to Ingest receipts, Vendor order lines, Locations, Standard rates - Ingest acceptances
Independent bounded disposition tranches against one immutable actual arrival.
Linked to Entities, Integration events, Ingest lines, Standard rates - 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 Bill lines, Bills, Return lines, Vendor order lines - Bill matches
Reserve and consume accepted receipt versus bill quantities/value once.
Linked to Bill matches, Ingest acceptances, Entities, Integration events
- Content items
Trade goods and assembly outputs; master values do not rewrite transactions.
Linked to Units of measure, Configuration changes - Content files
Versioned product-specific buy/sell packs and base conversions.
Linked to Content items, Units of measure, Configuration changes - Content libraries
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 Content libraries - Content availability
Current owned stock by complete identity and custody state; provenance is not a second balance.
Linked to Entities, Content items, Content libraries, Locations - Content batches
Remaining quantity/carrying value with receipt/output/return lineage.
Linked to Entities, Content availability, Content items, Content events - Content reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Content availability, Content batches - Content transfers
Same-entity transfer with actual dispatch/partial receipt and retained owned transit.
Linked to Entities, Document revisions, Approval decisions, Content libraries - Content transfer lines
Partial transfer quantities retain equal in-transit ownership and cost.
Linked to Content transfers, Content items, Locations - Content events
One immutable group of stock movements and the associated journal effect.
Linked to Journal entries, Content events, Entities, Integration events - Content movements
Signed position/layer legs; transfers balance quantity and value by SKU.
Linked to Content events, Content availability, Content batches, Content reservations - Content audits
Blind scoped counts with explicit review and cost before adjustment.
Linked to Entities, Approval decisions, Content libraries, Document revisions
- Content assemblies
Effective distribution assembly/repacking recipes with explicit output basis.
Linked to Configuration changes, Entities, Content items - Assembly components
Component quantities per explicit output basis, preserving dimensions and allowed loss.
Linked to Content assemblies, Content items - Production workflows
Versioned assembly/repacking instructions, distinct from delivery routes.
Linked to Entities, Content assemblies, Configuration changes - Workflow steps
Ordered work instructions and declared labour/overhead bases.
Linked to Production workflows - Projects
Released bounded assembly/kitting/repacking, without plant APS or payroll scope.
Linked to Ad order lines, Users, Entities, Document revisions - Production tasks
Frozen instructions and assigned actual work.
Linked to Projects, Workflow steps, Users - Production materials
Frozen required input and actual traced issue/return scope.
Linked to Projects, Assembly components, Content items, Content reservations - Production entries
Actual operation throughput, scrap and labour evidence; intermediate counts do not sum to output.
Linked to Entities, Integration events, Production tasks, Users - Production completions
Accepted terminal output and WIP cost allocation, once per actual completed scope.
Linked to Entities, Integration events, Approval decisions, Projects - Project costs
Immutable WIP debit/credit sources and bounded actual-cost allocation.
Linked to Entities, Integration events, Projects, Production materials
- Pick tasks
Actual picked quantities remain exclusively tied to the order and do not post COGS.
Linked to Entities, Integration events, Ad order lines, Content reservations - Shipments
Actual dispatch and title/delivery state separated for partial deliveries.
Linked to Entities, Document revisions, Integration events, Ad orders - Shipment lines
Actual dispatch quantities and current title-transferred/delivered portions.
Linked to Shipments, Ad order lines, Content reservations, Content 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, Content events, Return lines - Content reservations
Exclusive bounded demand claims through picking and owned transit.
Linked to Entities, Integration events, Content availability, Content batches - Ad allocations
Atomic claim of accepted line quantity and net/tax value across staged fulfillment/billing.
Linked to Shipment lines, Entities, Invoice lines, Integration events
- Returns
Bounded customer/supplier physical return authorization, separate from commercial credits.
Linked to Entities, Document revisions, Approval decisions, Advertisers - Return lines
Exact original commercial/stock scope and actual returned quantities.
Linked to Returns, Shipment lines, Ingest lines, Invoice lines - Return dispositions
Independent actual goods disposition without automatic credit or refund.
Linked to Return lines, Locations, Users, Content events - Shipment lines
Actual dispatch quantities and current title-transferred/delivered portions.
Linked to Shipments, Ad order lines, Content reservations, Content events - Ingest lines
Receipt history does not change as accepted inventory moves or is consumed.
Linked to Ingest receipts, Vendor order lines, Locations, Standard rates - 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 - Refunds
Independent finance-authorized cash movement from exactly one available credit/unapplied source.
Linked to Document revisions, Integration events, Approval decisions, Invoices
- 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 Shipment lines, Invoice lines, Return lines, Ad allocations - 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 lines
Supplier charges matched to accepted receipts, with explicit nonstock exceptions.
Linked to Bill lines, Bills, Return lines, Vendor order 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, Vendors - Payment allocations
Reserved bill and payment currency quantities with current-carrying settlement.
Linked to Payments, Bills, Exchange rates 2, Payment allocations - Journal entries
Balanced entity-functional journals with source identity and immutable postings.
Linked to Integration events, Approval decisions, Accounting periods, Journal entries - 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
Keys and references
Use stable item, customer, supplier and source document identifiers. Keep legal entity on each owned balance and economic effect. A warehouse can host separate entity positions without merging their ownership. Preserve the source revision and operation key for repeated messages. Store actual movement and title transfer separately from planned route dates.
Migration order
- Load Entities, Users, Currencies, units of measure and reviewed control policies.
- Load Advertisers, Vendors, content items, content files, content libraries and Locations.
- Load approved open ad orders, vendor orders and their line references.
- Reconcile opening content availability, content batches, Invoices, Bills and journal entries under a reviewed import batches cutoff.
- Test partial receipts, shipments, returns, cash application and close before widening use.
Set up Media ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.