Data Imports
Manual CSV or Excel uploads from ERP exports. Each upload replaces the current dataset.
Datasets
| Dataset | Filename | Date Uploaded | Records | Last Successful Update | Expected Columns | |
|---|---|---|---|---|---|---|
| Orderbook | demo_orderbook.csv | 2026-09-29 08:00 | 21 | 2026-09-29 08:00 | Part Number, Part Description, Customer, Sales Order, Purchase Order, Order Line, Quantity Ordered, Quantity Outstanding, Customer Due Date, Promised Delivery Date, Planned Delivery Date, Order Status | |
| BOM | demo_bom.csv | 2026-09-29 08:00 | 19 | 2026-09-29 08:00 | Saleable Part Number, Saleable Part Description, Piece-Part Number, Piece-Part Description, Quantity Required Per Saleable Part | |
| Stock | demo_stock.csv | 2026-09-29 08:00 | 11 | 2026-09-29 08:00 | Part Number, Part Description, Quantity, Stock Location, GIN, ERP Reference | |
| Open Jobs | demo_open_jobs.csv | 2026-09-29 08:00 | 29 | 2026-09-29 08:00 | Job Number, Part Number, Description, Job Quantity, Category, Operation(s), Completed Operation(s), Current Operation | |
| Subcon POs | — | — | 0 | — | PO Number, PO Line Item, PO Date, Material Description, Job Part No., Despatch Date, Total Qty Received, Quantity Outstanding |
Jobs: separate route operations with “>”, e.g. Stores > CNC Milling > Final Inspection. Dates accept dd/mm/yyyy or yyyy-mm-dd. Data Hub sync pulls the latest Orderbook, made-parts Stock, Open Jobs and Subcon POs from MTI Data Hub; BOM is still a manual upload.