iDempiere Product Master BOM (Bill of Materials)

BOM Tab defines the list of components used to manufacture or assemble a product. Each line represents a component and its required quantity.

  • Allows specifying BOM Type (Standard, Optional, etc.) and effective dates.
  • Supports detailed tracking using Attribute Set Instances.
  • Essential for managing production, kitting, and assembly workflows.

Tab name: BOM(AD_Tab_ID=53286)
Table Name: PP_Product_BOM(AD_Table_ID=53018)

Field NameDescriptionColumn Name
DataType
Reference Type
AD_Column_ID
TenantThe client or business entity using the system* AD_Client_ID
* numeric(10)
* Table Direct
* 53331
OrganizationThe specific organization or store location* AD_Org_ID
* numeric(10)
* Table Direct
* 53341
ProductRefers to the main product for which the BOM (Bill of Materials) is being defined. This is typically a manufactured or assembled item.* M_Product_ID
* numeric(10)
* Search
* 53333
Attribute Set InstanceSpecifies the instance of the product’s attributes (like color, size, lot number). Used for tracking specific variants of a product.* M_AttributeSetInstance_ID
* numeric(10)
* Product Attribute
* 53340
Search KeyA unique identifier or code used to quickly find the product. Usually short and easily searchable.* Value
* character varying(80)
* String
* 53321
NameThe name of the product/component in the BOM line. This is usually auto-filled from the product reference.* Name
* character varying(60)
* Text
* 53322
DescriptionAdditional information or details about the product/component. Helpful for documentation or clarification.* Description
* character varying(255)
* String
* 53325
Comment/HelpField used for internal notes or explanations to help users understand the record’s purpose or use.* Help
* character varying(2000)
* Text
* 53329
ActiveA checkbox to indicate whether the BOM line is active. Inactive lines are ignored during processing.* IsActive
* character(1)
* Yes-No
* 53330
RevisionOptional field to track the revision level of the BOM. Useful when BOM changes over time due to design or production changes.* Revision
* character varying(10)
* String
* 53324
BOM TypeSpecifies the type of BOM line (e.g., Component, Phantom, Optional, etc.). Controls how the line is treated during manufacturing.* BOMType
* character(1)
* List
* 53342
BOM UseIndicates where the BOM is used (e.g., Manufacturing, Engineering, Maintenance). Helps classify and separate BOMs by purpose.* BOMUse
* character(1)
* List
* 53343
Copy BOM Lines FromA utility field that allows you to copy existing BOM lines from another product. Simplifies setup when similar BOMs are reused.* CopyFrom
* character(1)
* Button
* 53326

Leave a Reply

Your email address will not be published. Required fields are marked *