Parts and BOMs (Window ID-53128)

From iDempiere en

Table of Contents

Window: Parts and BOMs

Description: Maintain Bill of Materials

Help: The Bill of Materials Window defines all product bills of materials used by an organization for light manufacturing.

Tab: Part

Description: The Product that will be produced from this Bill of Materials

Help:

Parts and BOMs - Part - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. M_Product.AD_Org_ID
numeric(10)
Table Direct
Search Key Search key for the record in the format required - must be unique A 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_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

M_Product.Value
character varying(40)
String
Version No Version Number M_Product.VersionNo
character varying(20)
String
Name Alphanumeric identifier of the entity The 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. M_Product.Name
character varying(255)
String
Description Optional short description of the record A description is limited to 255 characters. M_Product.Description
character varying(255)
String
Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. M_Product.Help
character varying(2000)
Text
Document Note Additional information for a Document The Document Note is used for recording any additional information regarding this product. M_Product.DocumentNote
character varying(2000)
Text
UPC/EAN Bar Code (Universal Product Code or its superset European Article Number) Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) M_Product.UPC
character varying(30)
String
SKU Stock Keeping Unit The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. M_Product.SKU
character varying(30)
String
Active The record is active in the system There 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.

M_Product.IsActive
character(1)
Yes-No
Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product.M_Product_Category_ID
numeric(10)
Table Direct
Classification Classification for grouping The Classification can be used to optionally group products. M_Product.Classification
character varying(12)
String
Tax Category Tax Category The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax. M_Product.C_TaxCategory_ID
numeric(10)
Table Direct
UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure M_Product.C_UOM_ID
numeric(10)
Table Direct
Product Type Type of product The type of product also determines accounting consequences. M_Product.ProductType
character(1)
List
Weight Weight of a product The Weight indicates the weight of the product in the Weight UOM of the Client M_Product.Weight
numeric
Amount
Volume Volume of a product The Volume indicates the volume of the product in the Volume UOM of the Client M_Product.Volume
numeric
Amount
Stocked Organization stocks this product The Stocked check box indicates if this product is stocked by this Organization. M_Product.IsStocked
character(1)
Yes-No
Manufactured This product is manufactured M_Product.IsManufactured
character(1)
Yes-No
Phantom Phantom Component Phantom Component are not stored and produced with the product. This is an option to avild maintaining an Engineering and Manufacturing Bill of Materials. M_Product.IsPhantom
character(1)
Yes-No
Kanban controlled This part is Kanban controlled M_Product.IsKanban
character(1)
Yes-No
Part Type M_Product.M_PartType_ID
numeric(10)
Table Direct
Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Product.M_Locator_ID
numeric(10)
Locator (WH)
Bill of Materials Bill of Materials The Bill of Materials check box indicates if this product consists of a bill of materials. M_Product.IsBOM
character(1)
Yes-No
Verified The BOM configuration has been verified The Verified check box indicates if the configuration of this product has been verified. This is used for products that consist of a bill of materials M_Product.IsVerified
character(1)
Yes-No
Verify BOM Structure Verify BOM for correctness The Verify BOM process checks for circular BOMs (unsupported). M_Product.Processing
character(1)
Button
Purchased Organization purchases this product The Purchased check box indicates if this product is purchased by this organization. M_Product.IsPurchased
character(1)
Yes-No
Sold Organization sells this product The Sold check box indicates if this product is sold by this organization. M_Product.IsSold
character(1)
Yes-No
Discontinued This product is no longer available The Discontinued check box indicates a product that has been discontinued. M_Product.Discontinued
character(1)
Yes-No
Discontinued At Discontinued At indicates Date when product was discontinued M_Product.DiscontinuedAt
timestamp without time zone
Date
Expense Type Expense report type M_Product.S_ExpenseType_ID
numeric(10)
Table Direct
Resource Resource M_Product.S_Resource_ID
numeric(10)
Table Direct
Subscription Type Type of subscription Subscription type and renewal frequency M_Product.C_SubscriptionType_ID
numeric(10)
Table Direct
Exclude Auto Delivery Exclude from automatic Delivery The product is excluded from generating Shipments. This allows manual creation of shipments for high demand items. If selected, you need to create the shipment manually.

But, the item is always included, when the delivery rule of the Order is Force (e.g. for POS). This allows finer granularity of the Delivery Rule Manual.

M_Product.IsExcludeAutoDelivery
character(1)
Yes-No
Image URL URL of image URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. M_Product.ImageURL
character varying(120)
URL
Description URL URL for the description M_Product.DescriptionURL
character varying(120)
URL
Guarantee Days Number of days the product is guaranteed or available If the value is 0, there is no limit to the availability or guarantee, otherwise the guarantee date is calculated by adding the days to the delivery date. M_Product.GuaranteeDays
numeric(10)
Integer
Min Guarantee Days Minimum number of guarantee days When selecting batch/products with a guarantee date, the minimum left guarantee days for automatic picking. You can pick any batch/product manually. M_Product.GuaranteeDaysMin
numeric(10)
Integer
Attribute Set Product Attribute Set Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking. M_Product.M_AttributeSet_ID
numeric(10)
Table Direct
Attribute Set Instance Product Attribute Values The values of the actual Product Attributes. Product Instance attributes are defined in the actual transactions. M_Product.M_AttributeSetInstance_ID
numeric(10)
Product Attribute

Tab: Bill of Materials

Description: The component products.

Help:

File:Parts and BOMs - Bill of Materials - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_BOM.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. M_Product_BOM.AD_Org_ID
numeric(10)
Table Direct
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_BOM.M_Product_ID
numeric(10)
Search
Line No Unique line for this document Indicates the unique line for a document. It will also control the display order of the lines within a document. M_Product_BOM.Line
numeric(10)
Integer
Active The record is active in the system There 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.

M_Product_BOM.IsActive
character(1)
Yes-No
Description Optional short description of the record A description is limited to 255 characters. M_Product_BOM.Description
character varying(255)
String
BOM Type Type of BOM The type of Bills of Materials determines the state M_Product_BOM.BOMType
character(1)
List
BOM Product Bill of Material Component Product The BOM Product identifies an element that is part of this Bill of Materials. M_Product_BOM.M_ProductBOM_ID
numeric(10)
Search
BOM Quantity Bill of Materials Quantity The BOM Quantity indicates the quantity of the product in its Unit of Measure (multiplication) M_Product_BOM.BOMQty
numeric
Quantity


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.