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.
- Supply Chain
- Data model and import order
The tables behind Supply Chain
Supply Chain ships with 38 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
- 38
- Features
- 8, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Demand planning:
Demand forecasts, forecast versions, forecast buckets, MRP runs, replenishment plans.
Procurement:
Purchase orders, purchase order items, vendor splits, supplier contracts, Contacts, vendor scorecards.
Receiving and invoices:
Goods receipts, goods receipt lines, supplier invoices.
Inventory and warehouses:
Inventory, Warehouses, Bins, stock movements, Allocations, Transfers.
Counts and adjustments:
Cycle counts, physical inventories.
Quality:
Quality plans, quality inspections, Nonconformances, CAP as.
Shipping and returns:
Shipments, shipment tracking, Carriers, shipping methods, return authorizations.
Products and production:
Products, item masters, product categories, units of measure, production orders, exchange rates.
Every table, by feature
- Demand planning5
- Procurement6
- Receiving and invoices5
- Inventory and warehouses6
- Counts and adjustments5
- Quality5
- Shipping and returns6
- Products and production5
- Shared and settings2
- Demand forecasts
Forecasted demand per product per warehouse per bucket under a version.
Linked to Products, Warehouses, Forecast buckets, Forecast versions - Forecast versions
Named forecast iterations: baseline, S1, S2, locked.
- Forecast buckets
Time buckets against which forecasts are stored.
- MRP runs
Execution-level record of a material requirements planning run.
Linked to Users, Forecast versions - Replenishment plans
MRP and reorder-point-driven net demand suggestions.
Linked to MRP runs, Products, Warehouses, Contacts
- Purchase orders
Orders to suppliers for materials, components, goods and services.
Linked to Users, Contacts, Supplier contracts, Warehouses - Purchase order items
Line items of a purchase order.
Linked to Purchase orders, Products, Warehouses - Vendor splits
Optional split of a purchase order across supplier sites or dual-sourced suppliers.
Linked to Purchase orders, Contacts - Supplier contracts
Signed procurement agreements: rate cards, rebate tiers and SL as.
Linked to Contacts - Contacts
Supplier and customer master records. Type distinguishes vendors from customers.
Linked to Shipping methods - Vendor scorecards
Periodic supplier performance rollups.
Linked to Contacts
- Goods receipts
Physical receipt of goods against a purchase order.
Linked to Purchase orders, Users, Contacts, Warehouses - Goods receipt lines
Line-level receipts: what was received, into which bin, in what disposition.
Linked to Goods receipts, Products, Bins, Purchase order items - Supplier invoices
Vendor bills against received purchase orders.
Linked to Contacts, Purchase orders, Goods receipts - Purchase orders
Orders to suppliers for materials, components, goods and services.
Linked to Users, Contacts, Supplier contracts, Warehouses - Purchase order items
Line items of a purchase order.
Linked to Purchase orders, Products, Warehouses
- Inventory
On-hand, allocated and available-to-promise stock per product, warehouse, bin and lot.
Linked to Products, Warehouses, Bins - Warehouses
Physical warehouse and distribution center master.
Linked to Users - Bins
Bin-level storage locations within a warehouse.
Linked to Warehouses - Stock movements
Every physical movement of stock.
Linked to Users, Products, Warehouses, Bins - Allocations
Commitments of on-hand inventory against outbound shipments or production orders.
Linked to Products, Warehouses, Bins - Transfers
Inter-warehouse stock transfers.
Linked to Users, Warehouses, Products
- Cycle counts
Scheduled partial inventory counts.
Linked to Users, Warehouses, Products, Bins - Physical inventories
Periodic full-warehouse wall-to-wall counts.
Linked to Users, Warehouses - Stock movements
Every physical movement of stock.
Linked to Users, Products, Warehouses, Bins - Inventory
On-hand, allocated and available-to-promise stock per product, warehouse, bin and lot.
Linked to Products, Warehouses, Bins - Bins
Bin-level storage locations within a warehouse.
Linked to Warehouses
- Quality plans
Inspection rule templates per product, category or supplier.
Linked to Products, Product categories, Contacts - Quality inspections
Quality inspections on inbound, in-process and outbound material.
Linked to Users, Quality plans, Products - Nonconformances
Formal records of rejected or out-of-spec material.
Linked to Quality inspections, Contacts, Products - CAP as
Corrective and preventive action records.
Linked to Users, Nonconformances - Contacts
Supplier and customer master records. Type distinguishes vendors from customers.
Linked to Shipping methods
- Shipments
Outbound shipments of finished goods to customers.
Linked to Users, Contacts, Warehouses, Carriers - Shipment tracking
Carrier scan events along a shipment.
Linked to Shipments - Carriers
Freight carriers: parcel, LTL, FTL, ocean, air, rail and courier.
- Shipping methods
Named service levels per carrier.
Linked to Carriers - Allocations
Commitments of on-hand inventory against outbound shipments or production orders.
Linked to Products, Warehouses, Bins
- Products
Catalog of sellable and stockable items: finished goods, components, raw materials, consumables and spares.
Linked to Product categories, Contacts - Item masters
SKU-level logistics, physical, regulatory and handling attributes.
Linked to Products - Product categories
Hierarchical product categories.
Linked to Product categories - Units of measure
Unit of measure master with conversion factors.
Linked to Units of measure - Production orders
Lightweight production orders raised from replenishment for made-in-house items.
Linked to Products, Warehouses, Replenishment plans
Keys and references
Products reference a category and primary and alternate suppliers in Contacts; item masters reference one product. Forecasts reference a product, warehouse, bucket and version; replenishment plans reference an MRP run, product and warehouse. Purchase orders reference a supplier, buyer, warehouse and contract; lines reference a product and destination warehouse. Receipts reference a purchase order and supplier; receipt lines reference a receipt, product, bin and order line. Invoices reference a supplier, order and receipt. Inventory, movements, allocations and counts reference a product, warehouse and bin. Shipments reference a customer, warehouse, carrier and method.
Import products by SKU, contacts by supplier or customer code, warehouses by code and bins by bin code within warehouse.
Migration order
- Load Users, units of measure, product categories, Warehouses and Bins.
- Load Contacts, Carriers and shipping methods, then Products and item masters.
- Load supplier contracts and quality plans.
- Load opening Inventory by warehouse, bin and lot.
- Load open purchase orders with lines, open Transfers, Shipments and return authorizations, and current forecast versions with demand forecasts.
- Reconcile stock, open orders and open invoices with the source, test permissions and replay the exception cases before go-live.
Set up Supply Chain your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.