Skip to main content

Window: Bill of Materials and Formula

[Created: 17/12/2007 - Updated: 08/12/2023 ]
Description: Maintain Product Bill of Materials & Formula
Help: It is a list of all the subassemblies, intermediates, parts and raw material that go into a parent assembly showing the quantity of each required to make an assembly. There are a variety of display formats of bill of material, including single level bill of material, indented bill of material, modular (planning), costed bill of material, etc. May also be called "formula", "recipe", "ingredients list" in certain industries.It answers the question, what are the components of the product?

Tab: Parent Product

[Created: 17/12/2007 - Updated: 17/12/2007 ]
Description: Define the Parent Product to this BOM & Formula
Help: Define the Parent Product to this BOM & Formula
Tab Level: 0

Table 10: Parent Product - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.pp_product_bom.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.pp_product_bom.AD_Org_ID numeric(10)
Table Direct
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.pp_product_bom.M_Product_ID numeric(10)
Search
Attribute Set InstanceProduct Attribute Set InstanceThe values of the actual Product Attribute Instances. The product level attributes are defined on Product level.pp_product_bom.M_AttributeSetInstance_ID numeric(10)
Product Attribute
Search KeySearch key for the record in the format required - must be uniqueA search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).pp_product_bom.Value character varying(80)
String
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.pp_product_bom.Name character varying(60)
Text
DescriptionOptional short description of the recordA description is limited to 255 characters.pp_product_bom.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.pp_product_bom.Help character varying(2000)
Text
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.pp_product_bom.IsActive character(1)
Yes-No
Revisionpp_product_bom.Revision character varying(10)
String
BOM TypeType of BOMThe type of Bills of Materials determines the statepp_product_bom.BOMType character(1)
List
BOM UseThe use of the Bill of MaterialBy default the Master BOM is used, if the alternatives are not definedpp_product_bom.BOMUse character(1)
List
Copy BOM Lines FromCopy BOM Lines from an existing BOMCopy BOM Lines from an existing BOM. The BOM being copied to, must not have any existing BOM Lines.pp_product_bom.CopyFrom character(1)
Button

Tab: Parent Product Translation

[Created: 18/04/2009 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 1

Table 15: Parent Product Translation - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.pp_product_bom_trl.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.pp_product_bom_trl.AD_Org_ID numeric(10)
Table Direct
BOM & FormulaBOM & Formulapp_product_bom_trl.PP_Product_BOM_ID numeric(10)
Table Direct
LanguageLanguage for this entityThe Language identifies the language to use for display and formattingpp_product_bom_trl.AD_Language character varying(6)
Table
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.pp_product_bom_trl.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.pp_product_bom_trl.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.pp_product_bom_trl.Help character varying(2000)
Text
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.pp_product_bom_trl.IsActive character(1)
Yes-No
TranslatedThis column is translatedThe Translated checkbox indicates if this column is translated.pp_product_bom_trl.IsTranslated character(1)
Yes-No

Tab: Components of the BOM & Formula

[Created: 17/12/2007 - Updated: 21/04/2009 ]
Description: Components of the BOM & Formula
Help: The information relative to every component that will be used in the BOM & Formula of the finished product.
Tab Level: 1

Table 20: Components of the BOM & Formula - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
Line NoUnique line for this documentIndicates the unique line for a document. It will also control the display order of the lines within a document.pp_product_bomline.Line numeric(10)
Integer
BOM & FormulaBOM & Formulapp_product_bomline.PP_Product_BOM_ID numeric(10)
Search
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.pp_product_bomline.M_Product_ID numeric(10)
Search
Attribute Set InstanceProduct Attribute Set InstanceThe values of the actual Product Attribute Instances. The product level attributes are defined on Product level.pp_product_bomline.M_AttributeSetInstance_ID numeric(10)
Product Attribute
Component TypeComponent Type for a Bill of Material or FormulaThe Component Type can be:1.- By Product: Define a By Product as Component into BOM2.- Component: Define a normal Component into BOM 3.- Option: Define an Option for Product Configure BOM4.- Phantom: Define a Phantom as Component into BOM5.- Packing: Define a Packing as Component into BOM6.- Planning : Define Planning as Component into BOM7.- Tools: Define Tools as Component into BOM8.- Variant: Define Variant for Product Configure BOMpp_product_bomline.ComponentType character(2)
List
DescriptionOptional short description of the recordA description is limited to 255 characters.pp_product_bomline.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.pp_product_bomline.Help character varying(2000)
Text
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.pp_product_bomline.IsActive character(1)
Yes-No
QuantityIndicate the Quantity use in this BOMExist two way the add a component to a BOM or Formula:1.- Adding a Component based in quantity to use in this BOM2.- Adding a Component based in % to use the Order Quantity of Manufacturing Order in this Formula.pp_product_bomline.QtyBOM numeric
Number
FeatureIndicated the Feature for Product ConfigureIndicated the Feature for Product Configurepp_product_bomline.Feature character varying(30)
String

Tab: Components Translation

[Created: 21/04/2009 - Updated: 27/10/2024 ]
Description: BOM & Formula Line Translation
Help:
Tab Level: 2

Table 30: Components Translation - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.pp_product_bomline_trl.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.pp_product_bomline_trl.AD_Org_ID numeric(10)
Table Direct
BOM LineBOM LineThe BOM Line is a unique identifier for a BOM line in an BOM.pp_product_bomline_trl.PP_Product_BOMLine_ID numeric(10)
Table Direct
LanguageLanguage for this entityThe Language identifies the language to use for display and formattingpp_product_bomline_trl.AD_Language character varying(6)
Table
DescriptionOptional short description of the recordA description is limited to 255 characters.pp_product_bomline_trl.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.pp_product_bomline_trl.Help character varying(2000)
Text
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.pp_product_bomline_trl.IsActive character(1)
Yes-No
TranslatedThis column is translatedThe Translated checkbox indicates if this column is translated.pp_product_bomline_trl.IsTranslated character(1)
Yes-No