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.
- Textiles ERP
- Data model and import order
The tables behind Textiles ERP
Textiles ERP ships with 70 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
- 70
- Features
- 8, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Textile Operations
Dye lots references work orders and retains yarn lot, dye recipe, shade code and colorfastness grade. Garment sizes references Products through Style, with required units and completed units by size code and color code. People references Users.
Engineering and BOM
Products anchors bill of materials and Routings. BOM components links the parent bill to the component product. Routing operations links each routing to work centers. Engineering change orders groups the affected product, bill and route.
Demand and MRP
Sales orders and sales order lines establish customer demand; Forecasts and master schedule hold period quantities. Planned orders and MRP exceptions retain proposed supply, ownership and due dates.
Production Schedule
Calendars, Shifts and Operators support the work centers and employee assignments. Work orders carries the selected bill and route; work order operations holds planned and actual intervals.
Shop Floor
Work order components records required and issued quantities. Production log records operation time and output. Stock movements retains the product, warehouse and source reference for physical changes.
Purchasing and Receiving
Suppliers and supplier items describe the supply relationship. Requisitions, purchase orders and purchase order lines connect to goods receipts, supplier invoices and match exceptions. Approvals retains the assigned decision.
Quality and Release
Inspection plans, inspection characteristics and inspection results describe checks and results. Quality holds references the affected production or receipt evidence; non conformance reports and corrective actions retain investigation and follow-up.
Inventory and Finance
Inventory, Lots, Reservations and count lines retain stock context. Cost standards and cost rollups describe cost versions. Deliveries, customer invoices and cash receipts support customer reconciliation; journal entries and journal entry lines post within accounting periods.
Every table, by feature
- Textile Operations6
- Engineering and BOM8
- Demand and MRP10
- Production Schedule8
- Shop Floor8
- Purchasing and Receiving10
- Quality and Release10
- Inventory and Finance17
- Shared and settings9
- Dye lots
Dye lots for ERP for Textiles.
Linked to Work orders - Garment sizes
Garment sizes for ERP for Textiles.
Linked to Products - Products
Catalog of all items: finished goods, sub-assemblies, raw materials, components and consumables.
- Work orders
Shop-floor orders to produce a specific product in a specific quantity.
Linked to Products, Bill of materials, Routings, Sales orders - Lots
A quantity received or made together, traced through issue, production and shipment.
Linked to Products, Suppliers, Work orders - People
People for ERP for Textiles.
Linked to Users
- Products
Catalog of all items: finished goods, sub-assemblies, raw materials, components and consumables.
- Bill of materials
BOM header - the recipe for producing a given product.
Linked to Products - BOM components
Each raw or sub-assembly consumed to build the parent product.
Linked to Bill of materials, Products - Routings
Routing header - the sequence of operations required to build a product.
Linked to Products - Routing operations
Each operation in the routing sequence.
Linked to Routings, Work centers - Engineering change orders
Groups the item, bill and routing edits that land together.
Linked to Products, Bill of materials, Routings, Employees - Work centers
Machines, cells and assembly stations where operations are performed.
Linked to Departments, Employees - Approvals
One decision on a requisition, purchase order, count variance, change order or supplier invoice.
Linked to Employees
- Sales orders
Customer orders driving finished-goods demand.
Linked to Contacts, Employees - Sales order lines
Line items of a Sales Order.
Linked to Sales orders, Products - Forecasts
Forecast demand by item and period.
Linked to Products, Warehouses - Master schedule
The master production schedule.
Linked to Products, Warehouses, Employees - Planned orders
A proposal from the MRP run: a planned work order or planned purchase.
Linked to Products, Suppliers, Employees, Work orders - MRP exceptions
The action list from the planning run.
Linked to Products, Planned orders, Work orders, Purchase orders - Inventory
On-hand stock per product per warehouse.
Linked to Products, Warehouses - Products
Catalog of all items: finished goods, sub-assemblies, raw materials, components and consumables.
- Work orders
Shop-floor orders to produce a specific product in a specific quantity.
Linked to Products, Bill of materials, Routings, Sales orders - Purchase orders
Orders to vendors for raw materials and components.
Linked to Contacts, Employees
- Work orders
Shop-floor orders to produce a specific product in a specific quantity.
Linked to Products, Bill of materials, Routings, Sales orders - Work order operations
Exploded routing steps for a work order.
Linked to Work orders, Work centers, Employees - Work centers
Machines, cells and assembly stations where operations are performed.
Linked to Departments, Employees - Calendars
Working calendars for the plant and its work centres.
- Shifts
A shift on a calendar: when it starts and ends, and the work centre it runs at.
Linked to Calendars, Work centers - Operators
A shop-floor operator: the employee, the work centre they run and their shift.
Linked to Employees, Work centers, Shifts - Employees
Plant employees including operators, planners, buyers and QC inspectors.
Linked to Departments - Departments
Organizational departments.
Linked to Employees
- Work orders
Shop-floor orders to produce a specific product in a specific quantity.
Linked to Products, Bill of materials, Routings, Sales orders - Work order components
Exploded BOM demand for a work order.
Linked to Work orders, Products, Warehouses - Work order operations
Exploded routing steps for a work order.
Linked to Work orders, Work centers, Employees - Production log
Shop-floor time and quantity transactions against a work-order operation.
Linked to Work orders, Employees, Work centers - Stock movements
Every physical movement of stock - receipt, issue to WIP, completion, transfer, scrap.
Linked to Products, Warehouses, Employees - Products
Catalog of all items: finished goods, sub-assemblies, raw materials, components and consumables.
- Inventory
On-hand stock per product per warehouse.
Linked to Products, Warehouses - Lots
A quantity received or made together, traced through issue, production and shipment.
Linked to Products, Suppliers, Work orders
- Suppliers
The supplier record: contact, terms, currency, lead time and approval status.
Linked to Contacts, Employees - Supplier items
An item a supplier is approved to supply.
Linked to Suppliers, Products - Contacts
Master list of business contacts (customers, vendors).
- Requisitions
A request to buy: item, quantity, need date, cost centre and reason.
Linked to Products, Departments, Employees, Purchase orders - Purchase orders
Orders to vendors for raw materials and components.
Linked to Contacts, Employees - Purchase order lines
Line items of a Purchase Order.
Linked to Purchase orders, Products, Warehouses - Approvals
One decision on a requisition, purchase order, count variance, change order or supplier invoice.
Linked to Employees - Goods receipts
Physical receipt of raw materials against a purchase order.
Linked to Purchase orders, Warehouses, Employees - Supplier invoices
A supplier's invoice, matched line by line to the purchase order and goods receipt.
Linked to Suppliers, Purchase orders, Goods receipts, Employees - Match exceptions
A difference the three-way match found between invoice, order and receipt.
Linked to Supplier invoices, Purchase order lines, Employees
- Quality inspections
Quality inspections on incoming material, in-process and final release.
Linked to Products, Employees - Inspection plans
What to check for an item at a point, with the sampling rule.
Linked to Products, Routing operations - Inspection characteristics
One characteristic on a plan: what is measured, how, with which instrument and the limits.
Linked to Inspection plans, Instruments - Inspection results
The measured value or pass and fail per characteristic on one inspection.
Linked to Quality inspections, Inspection characteristics, Instruments, Employees - Instruments
Gauges and instruments with calibration intervals.
Linked to Work centers, Certificates - Certificates
Certificates of conformance, material test reports and calibration certificates.
Linked to Suppliers, Products, Lots - Quality holds
A hold on a lot, a receipt or a work-order operation.
Linked to Lots, Goods receipts, Work orders, Non conformance reports - Non conformance reports
A failed inspection, a customer complaint or a floor observation.
Linked to Products, Lots, Work orders, Suppliers - Corrective actions
The action that closes a non-conformance.
Linked to Non conformance reports, Employees, Suppliers - Dye lots
Dye lots for ERP for Textiles.
Linked to Work orders
- Inventory
On-hand stock per product per warehouse.
Linked to Products, Warehouses - Lots
A quantity received or made together, traced through issue, production and shipment.
Linked to Products, Suppliers, Work orders - Warehouses
Physical storage locations including raw stores, WIP buffers and finished-goods warehouses.
Linked to Employees - Locations
Bins, racks, line-side positions and docks inside a warehouse.
Linked to Warehouses - Reservations
Stock reserved against a sales order or work order need date.
Linked to Products, Warehouses, Lots, Sales orders - Count plans
A cycle count or a full physical inventory.
Linked to Warehouses, Employees - Count lines
One counted item and location with book, counted and variance quantities.
Linked to Count plans, Products, Locations, Lots - Stock movements
Every physical movement of stock - receipt, issue to WIP, completion, transfer, scrap.
Linked to Products, Warehouses, Employees - Cost standards
The standard cost of an item by element.
Linked to Products, Employees - Cost rollups
A cost rollup run that walks the bill and routing into a pending standard.
Linked to Products, Bill of materials, Routings, Employees - Deliveries
A shipment to a customer against a sales order.
Linked to Sales orders, Contacts, Warehouses, Employees - Customer invoices
The customer invoice a shipment raises at the order price.
Linked to Contacts, Sales orders, Deliveries, Journal entries - Cash receipts
Money received from a customer and applied to its invoices.
Linked to Contacts, Customer invoices, Journal entries - Journal entries
Accounting journal entries auto-posted from stock movements, closures, receipts and shipments.
- Journal entry lines
Line items of a journal entry.
Linked to Journal entries, Chart of accounts - Accounting periods
The fiscal periods postings land in.
Linked to Employees - Chart of accounts
Accounting chart of accounts.
Linked to Chart of accounts
Keys and references
Preserve stored record identities as well as human-readable numbers. Resolve each reference to its target before loading dependent rows. Dye lots.yarn lot is a text identifier: agree its matching convention with Lots.lot number. Garment sizes.Style identifies the product whose size balance is being recorded. Reconcile that style-level balance with accepted production during the operating review.
Map the employee used by personal work queues to the correct signed-in user. Retain original movement and source-log identities during imports so replayed events can be recognized. Review currencies, units and dates before combining source totals.
Migration order
- Load Users, People, Departments and Employees in dependency-aware passes, then resolve employee-manager references.
- Load chart of accounts, accounting periods, Warehouses and Locations; reconcile the intended opening balances.
- Load Products, Contacts and Suppliers, followed by supplier items, work centers, Calendars, Shifts and Operators.
- Load bill of materials, BOM components, Routings and routing operations, then inspection plans, characteristics and instruments.
- Load open customer demand, planning and purchasing scope; resolve work orders and their component and operation references.
- Load Lots and Inventory, then dye lots, garment sizes and production evidence. Reconcile receipts, invoices and journal sources before importing further events.
Set up Textiles ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.