Manufacturing Order BOM Line

PP_Order_BOMLine

Overview

Table NamePP_Order_BOMLine
Access LevelClient Only
Entity TypeEE01
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableM_Product
WikiView on iDempiere Wiki

Columns (44)

Column Type Required Default Description
CostAllocationPerc Number(22) No 0 Cost allocation percent in case of a co-product.
M_Product_ID Search(22) Yes - Product, Service, Item
AD_Client_ID Table Direct(22) Yes - Tenant for this installation.
AD_Org_ID Table Direct(22) Yes - Organizational entity within tenant
AD_User_ID Table(22) No - User within the system - Internal or Business Partner Contact
Assay Quantity(22) No - Indicated the Quantity Assay to use into Quality Order
BackflushGroup String(30) No - The Grouping Components to the Backflush
ComponentType List(2) No CO Component Type for a Bill of Material or Formula
Created Date+Time(7) Yes SYSDATE Date this record was created
CreatedBy Search(22) Yes - User who created this records
C_UOM_ID Table Direct(22) Yes - Unit of Measure
DateDelivered Date+Time(7) No - Date when the product was delivered
Description String(255) No - Optional short description of the record
Feature String(30) No - Indicated the Feature for Product Configure
Forecast Quantity(22) No - Indicated the % of participation this component into a of the BOM Planning
Help Text(2000) No - Comment or Hint
IsActive Yes-No(1) Yes - The record is active in the system
IsCritical Yes-No(1) Yes - Indicate that a Manufacturing Order can not begin without have this component
IsQtyPercentage Yes-No(1) No - Indicate that this component is based in % Quantity
IssueMethod List(1) No - There are two methods for issue the components to Manufacturing Order
LeadTimeOffset Integer(10) No - Optional Lead Time offest before starting production
Line Integer(22) Yes @SQL=SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM PP_Order_BOMLine WHERE PP_Order_ID=@PP_Order_ID@ Unique line for this document
M_AttributeSetInstance_ID Product Attribute(22) No - Product Attribute Set Instance
M_ChangeNotice_ID Table Direct(10) No - Bill of Materials (Engineering) Change Notice (Version)
M_Locator_ID Locator (WH)(22) No - Warehouse Locator
M_Warehouse_ID Table Direct(22) Yes - Storage Warehouse and Service Point
PP_Order_BOM_ID Table Direct(22) Yes - -
PP_Order_BOMLine_ID ID(10) Yes - -
PP_Order_BOMLine_UU String(36) No - -
PP_Order_ID Table Direct(22) Yes - Manufacturing Order
QtyBatch Quantity(22) Yes - Indicate the Quantity % use in this Formula
QtyBOM Quantity(22) Yes - Indicate the Quantity use in this BOM
QtyDelivered Quantity(22) Yes - Delivered Quantity
QtyEntered Quantity(22) No 1 The Quantity Entered is based on the selected UoM
QtyPost Quantity(22) Yes - -
QtyReject Quantity(22) Yes - -
QtyRequired Quantity(22) No - -
QtyReserved Quantity(22) Yes - Reserved Quantity
QtyScrap Quantity(22) Yes - Scrap % Quantity for this component
Scrap Number(22) No - Indicate the Scrap % for calculate the Scrap Quantity
Updated Date+Time(7) Yes SYSDATE Date this record was updated
UpdatedBy Search(22) Yes - User who updated this records
ValidFrom Date+Time(7) Yes @#Date@ Valid from including this date (first day)
ValidTo Date+Time(7) No - Valid to including this date (last day)

Foreign Keys

Column References Description
M_Product_ID M_Product.M_Product_ID Product, Service, Item
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant
AD_User_ID AD_User.AD_User_ID User within the system - Internal or Business Partner Contact
C_UOM_ID C_UOM.C_UOM_ID Unit of Measure
M_AttributeSetInstance_ID M_AttributeSetInstance.M_AttributeSetInstance_ID Product Attribute Set Instance
M_ChangeNotice_ID M_ChangeNotice.M_ChangeNotice_ID Bill of Materials (Engineering) Change Notice (Version)
M_Locator_ID M_Locator.M_Locator_ID Warehouse Locator
M_Warehouse_ID M_Warehouse.M_Warehouse_ID Storage Warehouse and Service Point
PP_Order_BOM_ID PP_Order_BOM.PP_Order_BOM_ID -
PP_Order_ID PP_Order.PP_Order_ID Manufacturing Order

Generated on 2026-05-03T17:59:05.029621877Z