Masters

Stock masters — 21 entities with their key fields and relationships.

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

21 entities in Stock.

Batch

Identifies a group of units produced or received together so their quantity, dates, and stock movements can be traced as one batch.

Naming: field batch_id · 26 fields · 21 inbound ref

Key fields

Field	Type	Req	Label
`disabled`	Check		Disabled
`batch_id`	Data	yes	Batch ID
`item_name`	Data		Item Name
`batch_qty`	Float		Batch Quantity

Relationships

Field	Type	References	Req
`item`	Link	Item	yes
`parent_batch`	Link	Batch
`reference_doctype`	Link	DocType (fw)
`stock_uom`	Link	UOM
`supplier`	Link	Supplier
`reference_name`	Dynamic Link	resolved via `reference_doctype`

Customs Tariff Number

Defines a customs tariff classification number and description for use on Items.

Naming: field tariff_number · 2 fields · 1 inbound ref

Key fields

Field	Type	Req	Label
`tariff_number`	Data	yes	Tariff Number
`description`	Data		Description

Relationships

No outgoing relationships.

Inventory Dimension

Defines an additional dimension, beyond Warehouse, Batch, and Serial No, for tracking stock balances and ledger entries.

Naming: field dimension_name · 24 fields · 0 inbound refs

Key fields

Field	Type	Req	Label
`dimension_name`	Data	yes	Dimension Name

Relationships

Field	Type	References	Req
`document_type`	Link	DocType (fw)
`reference_document`	Link	DocType (fw)	yes

Item

Represents a product or service that the company buys, sells, manufactures, or keeps in stock.

Naming: field item_code · 132 fields · 112 inbound refs

Key fields

Field	Type	Req	Label
`naming_series`	Select		Series
`item_code`	Data	yes	Item Code
`item_name`	Data		Item Name
`disabled`	Check		Disabled
`is_stock_item`	Check		Maintain Stock
`opening_stock`	Float		Opening Stock
`standard_rate`	Currency		Standard Selling Rate
`is_fixed_asset`	Check		Is Fixed Asset
`is_sales_item`	Check		Allow Sales

Relationships

Field	Type	References	Req
`asset_category`	Link	Asset Category
`brand`	Link	Brand
`country_of_origin`	Link	Country (fw)
`customs_tariff_number`	Link	Customs Tariff Number
`default_bom`	Link	BOM
`default_item_manufacturer`	Link	Manufacturer
`item_group`	Link	Item Group	yes
`purchase_tax_withholding_category`	Link	Tax Withholding Category
`purchase_uom`	Link	UOM
`quality_inspection_template`	Link	Quality Inspection Template
`sales_tax_withholding_category`	Link	Tax Withholding Category
`sales_uom`	Link	UOM
`stock_uom`	Link	UOM	yes
`variant_of`	Link	Item
`weight_uom`	Link	UOM
`attributes`	Table	Item Variant Attribute
`barcodes`	Table	Item Barcode
`customer_items`	Table	Item Customer Detail
`item_defaults`	Table	Item Default
`reorder_levels`	Table	Item Reorder
`supplier_items`	Table	Item Supplier
`taxes`	Table	Item Tax
`uoms`	Table	UOM Conversion Detail

Item Alternative

Links an Item to a substitute that may be used in manufacturing when alternatives are allowed.

Naming: hash · 6 fields · 0 inbound refs

Relationships

Field	Type	References	Req
`alternative_item_code`	Link	Item
`item_code`	Link	Item

Item Attribute

Defines a characteristic and its allowed values for generating and describing Item variants.

Naming: field attribute_name · 11 fields · 1 inbound ref

Key fields

Field	Type	Req	Label
`attribute_name`	Data	yes	Attribute Name
`disabled`	Check		Disabled

Relationships

Field	Type	References	Req
`item_attribute_values`	Table	Item Attribute Value

Item Lead Time

Stores an item’s purchasing and manufacturing lead-time inputs, including capacity, shifts, workstation time, and yield.

Naming: field item_code · 25 fields · 0 inbound refs

Key fields

Field	Type	Label
`buffer_time`	Int	Buffer Time
`capacity_per_day`	Int	Capacity
`purchase_time`	Int	Purchase Time

Relationships

Field	Type	References	Req
`item_code`	Link	Item
`stock_uom`	Link	UOM

Item Manufacturer

Associates an Item with a manufacturer’s part number and identifies the default manufacturer mapping when needed.

Naming: hash · 7 fields · 0 inbound refs

Key fields

Field	Type	Req	Label
`manufacturer_part_no`	Data	yes	Manufacturer Part Number
`is_default`	Check		Is Default

Relationships

Field	Type	References	Req
`item_code`	Link	Item	yes
`manufacturer`	Link	Manufacturer	yes

Manufacturer

Defines a manufacturer that can be associated with Items and manufacturer-specific part numbers.

Naming: field short_name · 11 fields · 9 inbound refs

Key fields

Field	Type	Req	Label
`short_name`	Data	yes	Short Name
`full_name`	Data		Full Name

Relationships

Field	Type	References	Req
`country`	Link	Country (fw)

Price List

Groups Item Prices under a buying, selling, or combined pricing context.

Naming: field price_list_name · 9 fields · 22 inbound refs

Key fields

Field	Type	Req	Label
`price_list_name`	Data	yes	Price List Name
`buying`	Check		Buying
`selling`	Check		Selling

Relationships

Field	Type	References	Req
`currency`	Link	Currency (fw)	yes
`countries`	Table	Price List Country

Putaway Rule

Chooses a target Warehouse for incoming stock from Item, Warehouse, capacity, and priority rules.

Naming: Expression (old style) · 12 fields · 2 inbound refs

Key fields

Field	Type	Req	Label
`capacity`	Float	yes	Capacity
`priority`	Int		Priority

Relationships

Field	Type	References	Req
`company`	Link	Company	yes
`item_code`	Link	Item	yes
`stock_uom`	Link	UOM
`uom`	Link	UOM
`warehouse`	Link	Warehouse	yes

Quality Inspection Parameter

Defines a measurable inspection parameter that can be grouped and reused in quality-inspection templates.

Naming: field parameter · 3 fields · 2 inbound refs

Key fields

Field	Type	Req	Label
`parameter`	Data	yes	Parameter

Relationships

Field	Type	References	Req
`parameter_group`	Link	Quality Inspection Parameter Group

Quality Inspection Parameter Group

Groups related Quality Inspection Parameters under a reusable name.

Naming: field group_name · 1 fields · 3 inbound refs

Key fields

Field	Type	Req	Label
`group_name`	Data	yes	Parameter Group Name

Relationships

No outgoing relationships.

Quality Inspection Template

Collects reusable item-inspection parameters that can be copied into a Quality Inspection.

Naming: field quality_inspection_template_name · 2 fields · 5 inbound refs

Key fields

Field	Type	Req	Label
`quality_inspection_template_name`	Data	yes	Quality Inspection Template Name

Relationships

Field	Type	References	Req
`item_quality_inspection_parameter`	Table	Item Quality Inspection Parameter	yes

Serial No

Identifies one distinct unit of a serialized item so its stock movement, status, and warranty history can be traced individually.

Naming: field serial_no · 36 fields · 4 inbound refs

Key fields

Field	Type	Req	Label
`serial_no`	Data	yes	Serial No
`status`	Select		Status
`posting_date`	Date		Posting Date

Relationships

Field	Type	References	Req
`asset`	Link	Asset
`batch_no`	Link	Batch
`brand`	Link	Brand
`company`	Link	Company	yes
`customer`	Link	Customer
`employee`	Link	Employee
`item_code`	Link	Item	yes
`item_group`	Link	Item Group
`location`	Link	Location
`reference_doctype`	Link	DocType (fw)
`warehouse`	Link	Warehouse
`work_order`	Link	Work Order
`reference_name`	Dynamic Link	resolved via `reference_doctype`

Shipment Parcel Template

Stores reusable parcel dimensions and weight for creating Shipment parcel rows.

Naming: field parcel_template_name · 5 fields · 1 inbound ref

Key fields

Field	Type	Req	Label
`length`	Float	yes	Length (cm)
`width`	Float	yes	Width (cm)
`height`	Float	yes	Height (cm)
`weight`	Float	yes	Weight (kg)
`parcel_template_name`	Data	yes	Parcel Template Name

Relationships

No outgoing relationships.

Stock Closing Balance

Stores the consolidated quantity, valuation, and FIFO position produced by a Stock Closing Entry for an item, warehouse, and inventory dimensions.

Naming: hash · 25 fields · 0 inbound refs

Key fields

Field	Type	Req	Label
`posting_date`	Date		Posting Date
`actual_qty`	Float		Qty Change

Relationships

Field	Type	References
`batch_no`	Link	Batch
`company`	Link	Company
`item_code`	Link	Item
`item_group`	Link	Item Group
`stock_closing_entry`	Link	Stock Closing Entry
`stock_uom`	Link	UOM
`warehouse`	Link	Warehouse

Stock Entry Type

Defines a named Stock Entry purpose and whether that movement uses an in-transit warehouse.

Naming: user prompt · 3 fields · 1 inbound ref

Key fields

Field	Type	Req	Label
`purpose`	Select	yes	Purpose

Relationships

No outgoing relationships.

UOM Category

Groups compatible units so conversion factors can be defined between them.

Naming: field category_name · 1 fields · 2 inbound refs

Key fields

Field	Type	Req	Label
`category_name`	Data	yes	Category Name

Relationships

No outgoing relationships.

Warehouse

Represents a logical stock location against which quantities, values, and movements are maintained.

Naming: hash · 35 fields · 128 inbound refs · tree / nested set

Key fields

Field	Type	Req	Label
`warehouse_name`	Data	yes	Warehouse Name
`is_group`	Check		Is Group Warehouse
`disabled`	Check		Disabled

Relationships

Field	Type	References	Req
`account`	Link	Account
`company`	Link	Company	yes
`customer`	Link	Customer
`default_in_transit_warehouse`	Link	Warehouse
`old_parent`	Link	Warehouse
`parent_warehouse`	Link	Warehouse
`warehouse_type`	Link	Warehouse Type

Warehouse Type

Defines a reusable classification for Warehouses.

Naming: user prompt · 1 fields · 1 inbound ref

Relationships

No outgoing relationships.