Skip to content
ERPNext Data Model
Esc
navigateopen⌘Jpreview
On this page

Manufacturing

BOM, Production Plan, Work Order and Job Card — planning and executing production against stock.

Production planning and execution: BOM, Work Order, Job Card, Workstation, Operation, Routing, Production Plan and their capacity/cost structures.

What it does

Manufacturing plans and consumes. A BOM defines what a finished item is made of and, through its Routing, which Operations run on which Workstations. A Production Plan aggregates demand from Sales Orders and Material Requests and explodes it into Work Orders; each Work Order issues raw materials and receives finished goods via Stock Entries, while Job Cards capture time and quantity at each operation.

Key features

  • Bill of Materials — multi-level, versioned, with scrap items, operating costs and BOM Update/Comparison tools.
  • Routing and capacity — Operation, Workstation, Workstation Type and Plant Floor, with capacity-based scheduling.
  • Production Plan — demand aggregation, material-requirement explosion, and sub-assembly planning.
  • Work Order — required-items table, per-operation status, and backflush or manual material consumption.
  • Job Card — shop-floor time logs, operator assignment and scrap capture; drives Downtime Entry analysis.
  • Disassembly Order — reverse a manufactured item back into its components.

Entity relationships

Each diagram below is one connected cluster of entities. Edges are labelled with the fieldname that carries them — see relationship notation for how to read the crow’s feet.

Job Card

Job Card records execution of a Work Order operation and brings together its workstation, employees, time logs, scheduled slots, consumed items, and completed quantities.

Split across 3 diagrams so each stays legible; Job Card repeats in each.

Document composition

Parent documents and the child tables they own.

Parent Table field Child table Req
BOM exploded_items BOM Explosion Item
BOM items BOM Item yes
BOM operations BOM Operation
BOM secondary_items BOM Secondary Item
BOM Creator items BOM Creator Item
Blanket Order items Blanket Order Item yes
Job Card employee Job Card Time Log
Job Card items Job Card Item
Job Card scheduled_time_logs Job Card Scheduled Time
Job Card secondary_items Job Card Secondary Item
Job Card sub_operations Job Card Operation
Job Card time_logs Job Card Time Log
Master Production Schedule items Master Production Schedule Item
Master Production Schedule material_requests Production Plan Material Request
Master Production Schedule sales_orders Production Plan Sales Order
Master Production Schedule select_items Master Production Schedule Item
Operation sub_operations Sub Operation
Production Plan material_requests Production Plan Material Request
Production Plan mr_items Material Request Plan Item
Production Plan po_items Production Plan Item yes
Production Plan prod_plan_references Production Plan Item Reference
Production Plan sales_orders Production Plan Sales Order
Production Plan sub_assembly_items Production Plan Sub Assembly Item
Production Plan warehouses Production Plan Material Request Warehouse
Routing operations BOM Operation
Sales Forecast items Sales Forecast Item
Sales Forecast selected_items Sales Forecast Item yes
Work Order non_stock_items Work Order Additional Item
Work Order operations Work Order Operation
Work Order required_items Work Order Item
Work Order secondary_items Work Order Additional Item
Workstation working_hours Workstation Working Hour
Workstation workstation_costs Workstation Cost
Workstation Operating Component accounts Workstation Operating Component Account
Workstation Type workstation_costs Workstation Cost

Entity reference

Look it up

Was this page helpful?