The tables behind Automotive ERP

Vehicle Fitments for ERP for Automotive - which part fits which vehicle make, model and model year.

Warranty Claims for ERP for Automotive - part failures reported against a vehicle VIN.

Catalog of all items: finished goods, sub-assemblies, raw materials, components, and consumables.

People for ERP for Automotive.

Catalog of all items: finished goods, sub-assemblies, raw materials, components, and consumables.

BOM header - the recipe for producing a given product.

Each raw or sub-assembly consumed to build the parent product.

Routing header - the sequence of operations required to build a product.

Each operation in the routing sequence.

An engineering change order groups the item, bill and routing edits that land together, carries its approvals, and applies on an effective date.

Forecast demand by item and period, entered or imported, consumed by actual orders as they arrive.

The master production schedule: what finished goods will be built, in what quantity, in which period, at which plant, inside its time fences.

A proposal from the MRP run: a planned work order or planned purchase, pegged to the demand that caused it.

The action list from the planning run: expedite, de-expedite, cancel, past due and the shortage list, sorted by need date.

Working calendars for the plant and its work centres: working days, hours per day, holidays and planned downtime the planning run respects.

A shift on a calendar: when it starts and ends, and the work centre it runs at.

Machines, cells, and assembly stations where operations are performed.

Shop-floor orders to produce a specific product in a specific quantity.

Exploded BOM demand for a work order - what raw material is needed and from where.

Exploded routing steps for a work order - what runs where, in what sequence.

Shop-floor orders to produce a specific product in a specific quantity.

Exploded BOM demand for a work order - what raw material is needed and from where.

Exploded routing steps for a work order - what runs where, in what sequence.

Shop-floor time/qty transactions against a work-order operation.

Every physical movement of stock - receipt, issue to WIP, completion, transfer, scrap.

A shop-floor operator: the employee, the work centre they run, their shift and how they report time and quantity.

A request to buy: item, quantity, need date, cost centre and reason, from the MRP run or from a person.

Orders to vendors for raw materials and components.

Line items of a Purchase Order.

The supplier record: the contact, terms, currency, lead time, whether receipts need inspection and whether the supplier is on the approved list.

An item a supplier is approved to supply: their item number, the agreed price, minimum order and lead time.

A request for quotation sent to several suppliers for an item, with the replies compared on one screen and the award recorded.

Physical receipt of raw materials against a purchase order.

A supplier's invoice, matched line by line to the purchase order and the goods receipt within tolerances before it becomes payable.

A difference the three-way match found between the invoice, the order and the receipt, with the amount and who it is with.

One decision on a requisition, purchase order, count variance, change order or supplier invoice: who decided, when, and the reason on the record.

A payment run releasing matched invoices: who prepared it, who authorised it, and the bank account it draws on.

One supplier payment inside a run: the invoice it settles, the amount and the reference the bank returns.

What to check for an item at a point, incoming, in-process at an operation or final, with the sampling rule; versioned.

One characteristic on a plan: what is measured, how, with which instrument, and the limits.

Quality inspections on incoming material, in-process, and final release.

The measured value or pass and fail per characteristic on one inspection.

Gauges and instruments with calibration intervals; an overdue instrument cannot be selected on an inspection.

Certificates of conformance, material test reports and calibration certificates, attached to a supplier lot or an instrument.

A hold on a lot, a receipt or a work-order operation: nothing on hold can be issued, shipped or completed until the disposition lifts it.

A failed inspection, a customer complaint or a floor observation, pointing at the lot, supplier, machine and operator, with its root cause.

The action that closes a non-conformance: an owner, a due date, and a verification by someone else before it closes.

A quantity received or made together: supplier lot, receipt date and expiry, traced through issue, production and shipment.

One record per serialised unit: its lot, the work order that made it and the delivery it left on.

Master list of business contacts (customers, vendors).

A priced offer to a customer: items, quantities, the price from the list or a configuration, and the requested date.

Line items of a quote.

Customer orders driving finished-goods demand.

Line items of a Sales Order.

Stock reserved against a sales order or work order need date, hard to a lot or soft to a quantity.

A shipment to a customer against a sales order: picked, packed and sent with the carrier reference, and the lots and serials on it.

The customer invoice a shipment raises at the order price; partial shipments invoice partially.

Money received from a customer and applied to its invoices.

A cost rollup run: it walks the bill and routing into a pending standard, is reviewed, and activates with a revaluation entry.

The standard cost of an item by element, material, labour, overhead and outside processing, pending or current, activated on a date.

Accounting chart of accounts.

Accounting journal entries auto-posted from stock movements, work-order closures, receipts, and shipments.

Line items of a journal entry.

The fiscal periods postings land in; a locked period takes a posting only after a named role reopens it.

A supplier's invoice, matched line by line to the purchase order and the goods receipt within tolerances before it becomes payable.

A difference the three-way match found between the invoice, the order and the receipt, with the amount and who it is with.

A payment run releasing matched invoices: who prepared it, who authorised it, and the bank account it draws on.

One supplier payment inside a run: the invoice it settles, the amount and the reference the bank returns.

The customer invoice a shipment raises at the order price; partial shipments invoice partially.

Money received from a customer and applied to its invoices.

Read-only effective exchange rates for this app.

One counted item and location: the book quantity, the counted quantity and the variance waiting for approval.

A cycle count or a full physical inventory: the warehouse, the ABC class it picks, when it runs and who approves the variances.

Organizational departments (Production, Quality, Procurement, Finance, HR, IT).

Plant employees including operators, planners, buyers, and QC inspectors.

On-hand stock per product per warehouse.

Bins, racks, line-side positions and docks inside a warehouse, with the zone an item may be restricted to.

Per receipt, the facts the supplier scorecard rolls up: on time, quantity accurate, the inspection result and the price variance.

Users

Physical storage locations including raw stores, WIP buffers, and finished-goods warehouses.