ERP — Manufacturing template
A plant-wide ERP: employees and the gate entry system, shifts and vacation, working stands, SOPs, items, BOM, warehouses and inventory, suppliers, purchase orders, customers, sales and production orders, quality, repairs, forwarders and shipments — with lot-traced goods receipts, 22 built pages and 17 workflows.
Tables
Departments
Code, Department, Plant, Manager, Cost centre, Shift model, Annual budget, Spend to date, Planned headcount, Team, Headcount, Monthly payroll, Building, Phone and 7 more
Employees
Personnel number, Name, Department, Department code, Position, Contract, Skills, Shift, Hired on, Gross salary, Hourly rate, Vacation days left, Appraisal, Badge and 6 more
Shift patterns
Code, Shift, Starts, Ends, Working days, Department, Plant, Shift supervisor, Rotation, Planned headcount, Minimum to run, Shift premium, Break, Paid hours and 7 more
Entry system
Entry, Employee, Badge, Name, Day, Week, Clock in, Clock out, Time on site, Gate, Shift, Status, Terminal IP, Terminal MAC and 3 more
Vacation planner
Request, Employee, Name, Type, Period, First day, Last day, Working days, Status, Approver, Submitted at, Cover, Department, Shift and 8 more
Working stands
Code, Working stand, Type, Department, Operating procedure, Status, Operator on duty, Shift, Capacity per hour, OEE, Availability, Hours since service, Machine serial, PLC address and 5 more
Standard operating procedures
Document, Title, Revision, Status, Category, Owning department, Author, Approved by, Effective from, Review due, Hazard level, Useful votes, Tags, Intranet link and 3 more
Items
SKU, Item, Type, Unit, EAN-13, UPC, HS code, UNSPSC, Standard cost, List price, Lead time (days), Minimum stock, Weight (kg), Quality critical and 5 more
Bill of materials
Line, Assembly, Assembly item, Component, Component item, Quantity per unit, Unit, Scrap allowance, Position, Operation, Supply, Component cost, Revision, Critical part and 6 more
Warehouses
Code, Warehouse, Type, Address, City, Country, Timezone, Opens, Warehouse keeper, Capacity (m³), Occupied (m³), Bin locations, Dock doors, Climate controlled and 7 more
Inventory
Lot, SKU, Item, Item name, Warehouse, Bin, Quantity, Unit, Status, Unit cost, ABC class, Reorder point, Responsible, Received and 8 more
Suppliers
Code, Supplier, Country, VAT number, DUNS, IBAN, BIC, Currency, Incoterm, Contact, E-mail, Phone, Website, Rating and 6 more
Purchase orders
Purchase order, Supplier, Supplier name, Status, Buyer, Ordered on, Promised, Received on, Incoterm, Currency, Order lines, Lines, Ordered quantity, Net amount and 7 more
Purchase order lines
Line, Purchase order, Order reference, Item, SKU, Description, Ordered, Received, Unit, Unit price, Discount, VAT rate, Line status, Deliver to and 7 more
Customers
Code, Customer, Country, VAT number, LEI, Delivery address, Contact, E-mail, Phone, Segment, Payment terms, Credit limit, Open balance, Account manager and 8 more
Sales orders
Sales order, Customer, Customer name, Status, Priority, Ordered on, Requested date, Confirmed date, Customer reference, Order value, Discount, Currency, Payment terms, Incoterm and 7 more
Production orders
Production order, Item, Item record, Item name, Sales order, Sales order reference, Working stand, Stand code, Status, Priority, Shift, Supervisor, Quantity ordered, Quantity produced and 16 more
Quality inspections
Inspection, Production order, Order reference, Lot number, Lot, Inspection type, Result, Inspector, Checked at, Sample size, Defects found, Measured value, Lower limit, Upper limit and 6 more
Nonconformities
Nonconformity, Inspection, Inspection reference, Item, Lot number, Lot, Severity, Status, Disposition, Owner, Opened, Due, Closed, Quantity affected and 6 more
Repairs and maintenance
Repair order, Working stand, Stand code, Type, Status, Priority, Technician, Reported at, Scheduled for, Completed, Downtime, Labour hours, Labour rate, Parts cost and 5 more
Forwarders
Code, Forwarder, Mode, Hub, Hub clock, DUNS, VAT number, Contact, E-mail, Phone, Tracking, Currency, Rating, On-time delivery and 3 more
Shipments
Shipment, Direction, Status, Sales order, Order reference, Forwarder, Forwarder name, From warehouse, Origin, Destination, Delivery address, Incoterm, Dispatched at, ETA and 10 more
Goods receipts
Receipt, Order line, Order line reference, Supplier, SKU, Item, Quantity received, Received on, Supplier batch, Lot number, Lot, Held in, Incoming inspection, Inspection and 2 more
Lot movements
Movement, Type, Lot, SKU, Item, Quantity, Document, Supplier or customer, When
Views
- All production orders (grid)
- Shop-floor board (kanban)
- Production schedule (timeline)
- Finish dates (calendar)
- Load per stand (workload)
- Output per stand (chart)
- Behind schedule (grid)
- All inspections (grid)
- Failed inspections (grid)
- Results by inspection type (chart)
- Nonconformity board (kanban)
- Stock on hand (grid)
- …and 33 more
Forms
- Receive goods
- New production order
- Report a machine fault
- Request leave
- Record an inspection
- Raise a purchase order
- Manual gate entry
- Open a nonconformity
Automations
- Goods receipt — book the lot and its incoming check
- Incoming inspection result — release or block the lot
- Released order — tell the shop floor
- Order completed — book the output
- Failed inspection — open a nonconformity
- Low stock sweep — draft a purchase order
- Approved order — send it to the supplier
- Preventive maintenance due
- Stand down — stop the schedule
- Leave requested — ask the manager
- …and 7 more
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.