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

Masters

Manufacturing masters — 8 entities with their key fields and relationships.

Reference data with an independent lifecycle: created once, referenced many times.

8 entities in Manufacturing.

Downtime Entry

Records a period when a workstation was unavailable so manufacturing reports can account for lost operating time.

Naming: Naming Series · 11 fields · 0 inbound refs

Key fields

Field Type Req Label
from_time Datetime yes From Time
to_time Datetime yes To Time
stop_reason Select yes Stop Reason
naming_series Select yes Naming Series

Relationships

Field Type References Req
operator Link Employee yes
workstation Link Workstation yes

Master Production Schedule

Turns forecast, Sales Order, and Material Request demand for a date range into a time-phased production schedule.

Naming: Naming Series · 27 fields · 3 inbound refs

Key fields

Field Type Req Label
posting_date Date yes Posting Date
naming_series Select yes Naming Series
from_date Date yes From Date

Relationships

Field Type References Req
amended_from Link Master Production Schedule
company Link Company yes
parent_warehouse Link Warehouse
sales_forecast Link Sales Forecast
items Table Master Production Schedule Item
material_requests Table Production Plan Material Request
sales_orders Table Production Plan Sales Order
select_items Table MultiSelect Master Production Schedule Item

Operation

Defines a reusable manufacturing step that can be assigned to BOMs, Routings, Workstations, and Job Cards.

Naming: user prompt · 13 fields · 11 inbound ref

Relationships

Field Type References Req
quality_inspection_template Link Quality Inspection Template
workstation Link Workstation
sub_operations Table Sub Operation

Plant Floor

Provides a visual layout for monitoring the workstations and job cards assigned to a manufacturing floor.

Naming: field floor_name · 9 fields · 1 inbound ref

Relationships

Field Type References Req
company Link Company
warehouse Link Warehouse

Routing

Defines a reusable ordered set of manufacturing operations for a BOM.

Naming: field routing_name · 3 fields · 2 inbound refs

Key fields

Field Type Req Label
disabled Check Disabled

Relationships

Field Type References Req
operations Table BOM Operation

Workstation

Represents a machine or work area where manufacturing operations are scheduled and costed.

Naming: field workstation_name · 30 fields · 5 inbound refs

Key fields

Field Type Req Label
workstation_name Data yes Workstation Name
description Text Description
production_capacity Int yes Job Capacity
status Select Status
disabled Check Disabled

Relationships

Field Type References Req
holiday_list Link Holiday List
plant_floor Link Plant Floor
warehouse Link Warehouse
workstation_type Link Workstation Type
working_hours Table Workstation Working Hour
workstation_costs Table Workstation Cost

Workstation Operating Component

Defines a workstation operating-cost component and the company expense accounts used to record it.

Naming: field component_name · 3 fields · 1 inbound ref

Key fields

Field Type Req Label
component_name Data yes Component Name

Relationships

Field Type References Req
accounts Table Workstation Operating Component Account

Workstation Type

Groups interchangeable workstations so jobs and operating costs can be assigned by machine type rather than by one specific workstation.

Naming: field workstation_type · 7 fields · 4 inbound refs

Key fields

Field Type Req Label
workstation_type Data yes Workstation Type
description Small Text Description

Relationships

Field Type References Req
workstation_costs Table Workstation Cost

Was this page helpful?