ManPageW ProductBOM

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Product BOM

= BETA FUNCTIONALITY =

Description : Maintain Product Bill of Materials

Help :



Tab: Product

Description : Maintain Product Information

Help :

Table Name  : M_Product

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. AD_Client_ID

NUMBER(10)

TableDir

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. AD_Org_ID

NUMBER(10)

TableDir

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).

Value

NVARCHAR2(510)

String

Version No Version Number VersionNo

NVARCHAR2(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. Name

NVARCHAR2(510)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

Document Note Additional information for a Document The Document Note is used for recording any additional information regarding this product. DocumentNote

NVARCHAR2(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) UPC

VARCHAR2

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. SKU

VARCHAR2

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.

IsActive

CHAR(1)

YesNo

Summary Level This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary

CHAR(1)

YesNo

Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product_Category_ID

NUMBER(10)

TableDir

Classification Classification for grouping The Classification can be used to optionally group products. Classification

CHAR(1)

String

Tax Category Tax Category The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax. C_TaxCategory_ID

NUMBER(10)

TableDir

Revenue Recognition Method for recording revenue The Revenue Recognition indicates how revenue will be recognized for this product C_RevenueRecognition_ID

NUMBER(10)

TableDir

UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure C_UOM_ID

NUMBER(10)

TableDir

Company Agent Purchase or Company Agent Purchase agent for the document. Any Sales Rep must be a valid internal user. SalesRep_ID

NUMBER(10)

Table

Product Type Type of product The type of product also determines accounting consequences. ProductType

CHAR(1)

List

Mail Template Text templates for mailings The Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).

So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.
For Multi-Lingual systems, the template is translated based on the Business Partner's language selection.

R_MailText_ID

NUMBER(10)

TableDir

Weight Weight of a product The Weight indicates the weight of the product in the Weight UOM of the Client Weight

NUMBER

Amount

Volume Volume of a product The Volume indicates the volume of the product in the Volume UOM of the Client Volume

NUMBER

Amount

Freight Category Category of the Freight Freight Categories are used to calculate the Freight for the Shipper selected M_FreightCategory_ID

NUMBER(10)

TableDir

Drop Shipment Drop Shipments are sent from the Vendor directly to the Customer Drop Shipments do not cause any Inventory reservations or movements as the Shipment is from the Vendor's inventory. The Shipment of the Vendor to the Customer must be confirmed. IsDropShip

CHAR(1)

YesNo

Stocked Organization stocks this product The Stocked check box indicates if this product is stocked by this Organization. IsStocked

CHAR(1)

YesNo

Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID

NUMBER(10)

Locator

Shelf Width Shelf width required The Shelf Width indicates the width dimension required on a shelf for a product ShelfWidth

NUMBER(10)

Integer

Shelf Height Shelf height required The Shelf Height indicates the height dimension required on a shelf for a product ShelfHeight

NUMBER(10)

Integer

Shelf Depth Shelf depth required The Shelf Depth indicates the depth dimension required on a shelf for a product ShelfDepth

NUMBER(10)

Integer

Units Per Pallet Units Per Pallet The Units per Pallet indicates the number of units of this product which fit on a pallet. UnitsPerPallet

NUMBER(10)

Integer

Bill of Materials Bill of Materials The Bill of Materials check box indicates if this product consists of a bill of materials. IsBOM

CHAR(1)

YesNo

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 IsVerified

CHAR(1)

YesNo

Verify BOM Verify BOM Structure The Verify BOM Structure checks the elements and steps which comprise a Bill of Materials. Processing

CHAR(1)

Button

Print detail records on invoice Print detail BOM elements on the invoice The Print Details on Invoice indicates that the BOM element products will print on the Invoice as opposed to this product. IsInvoicePrintDetails

CHAR(1)

YesNo

Print detail records on pick list Print detail BOM elements on the pick list The Print Details on Pick List indicates that the BOM element products will print on the Pick List as opposed to this product. IsPickListPrintDetails

CHAR(1)

YesNo

Purchased Organization purchases this product The Purchased check box indicates if this product is purchased by this organization. IsPurchased

CHAR(1)

YesNo

Sold Organization sells this product The Sold check box indicates if this product is sold by this organization. IsSold

CHAR(1)

YesNo

Discontinued This product is no longer available The Discontinued check box indicates a product that has been discontinued. Discontinued

CHAR(1)

YesNo

Discontinued by Discontinued By The Discontinued By indicates the individual who discontinued this product DiscontinuedBy

DATE

Date

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. ImageURL

NVARCHAR2(120)

Unknown (40)

Description URL URL for the description DescriptionURL

NVARCHAR2(120)

Unknown (40)

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. GuaranteeDays

NUMBER(10)

Integer

Min Guarantee Days Minumum 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. GuaranteeDaysMin

NUMBER(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_AttributeSet_ID

NUMBER(10)

TableDir

Attribute Set Instance Product Attribute Values The values of the actual Product Attributes. Product Instance attributes are defined in the actual transactions. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

Featured in Web Store If selected, the product is displayed in the inital or any empy search In the display of products in the Web Store, the product is displayed in the inital view or if no search criteria are entered. To be displayed, the product must be in the price list used. IsWebStoreFeatured

CHAR(1)

YesNo

Self-Service This is a Self-Service entry or this entry can be changed via Self-Service Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. IsSelfService

CHAR(1)

YesNo


Tab: Alternative Groups

Description : Product BOM Alternative Group

Help : Alternative groups allow you to group Bill of Material components, which are exclusive (i.e. only one is valid). Examples different engine sizes.

Table Name  : M_BOMAlternative

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. AD_Client_ID

NUMBER(10)

TableDir

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. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

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. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

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.

IsActive

CHAR(1)

YesNo


Tab: Operation

Description : Product Manufacturing Operation

Help : The Operations to create the product. Note that the actual used operation and sequence is determined by the BOM Product.

Table Name  : M_ProductOperation

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. AD_Client_ID

NUMBER(10)

TableDir

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. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

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. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

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.

IsActive

CHAR(1)

YesNo

Setup Time Setup time before starting Production Once per operation SetupTime

NUMBER

Number

Teardown Time Time at the end of the operation Onec per operation TeardownTime

NUMBER

Number

Runtime per Unit Time to produce one unit UnitRuntime

NUMBER

Number


Tab: Operation Resource

Description : Product Operation Resources

Help : Resources for the Operation. You can have multiple resources (e.g. tool, labor) per operation.

Table Name  : M_OperationResource

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. AD_Client_ID

NUMBER(10)

TableDir

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. AD_Org_ID

NUMBER(10)

TableDir

Product Operation Product Manufacturing Operation The Operations to create the product. Note that the actual used operation and sequence is determined by the BOM Product. M_ProductOperation_ID

NUMBER(10)

TableDir

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. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

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.

IsActive

CHAR(1)

YesNo

Asset Asset used internally or by customers An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. A_Asset_ID

NUMBER(10)

TableDir

Position Job Position C_Job_ID

NUMBER(10)

TableDir

Setup Time Setup time before starting Production Once per operation SetupTime

NUMBER

Number

Teardown Time Time at the end of the operation Onec per operation TeardownTime

NUMBER

Number

Runtime per Unit Time to produce one unit UnitRuntime

NUMBER

Number


Tab: BOM

Description : Bill of Materials

Help :

Table Name  : M_BOM

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. AD_Client_ID

NUMBER(10)

TableDir

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. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Change Notice Bill of Materials (Engineering) Change Notice (Version) M_ChangeNotice_ID

NUMBER(10)

TableDir

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. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

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.

IsActive

CHAR(1)

YesNo

BOM Type Type of BOM The type of Bills of Materials determines the state BOMType

CHAR(1)

List

BOM Use The use of the Bill of Material By default the Master BOM is used, if the alternatives are not defined BOMUse

CHAR(1)

List

Process Now Processing

CHAR(1)

Button


Tab: BOM Component

Description : Bill of Material Component (Product)

Help : The Bill of Material Compoment determines what products, services and outside processing is included in producing the Product. It references the operation and determines it's sequence.

Table Name  : M_BOMProduct

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. AD_Client_ID

NUMBER(10)

TableDir

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. AD_Org_ID

NUMBER(10)

TableDir

BOM Bill of Material The composition of the Product M_BOM_ID

NUMBER(10)

TableDir

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. Line

NUMBER(10)

Integer

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

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.

IsActive

CHAR(1)

YesNo

Component Type BOM Product Type BOMProductType

CHAR(1)

List

Alternative Group Product BOM Alternative Group Alternative groups allow you to group Bill of Material components, which are exclusive (i.e. only one is valid). Examples different engine sizes. M_BOMAlternative_ID

NUMBER(10)

TableDir

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. IsPhantom

CHAR(1)

YesNo

BOM Product Bill of Material Component Product The BOM Product identifies an element that is part of this Bill of Materials. M_ProductBOM_ID

NUMBER(10)

Search

Change Notice Bill of Materials (Engineering) Change Notice (Version) M_ChangeNotice_ID

NUMBER(10)

TableDir

BOM Quantity Bill of Materials Quantity The BOM Quantity indicates the quantity of the product in its Unit of Measure (multiplication) BOMQty

NUMBER

Quantity

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

Product Operation Product Manufacturing Operation The Operations to create the product. Note that the actual used operation and sequence is determined by the BOM Product. M_ProductOperation_ID

NUMBER(10)

TableDir

Sequence Method of ordering records; lowest number comes first The Sequence indicates the order of records SeqNo

NUMBER(10)

Integer

Lead Time Offset Optional Lead Time offest before starting production LeadTimeOffset

NUMBER(10)

Integer

Contributions

  • Some simple BOM how to guide
Personal tools