ManPageW ProductBOM
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: Product BOM
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. |
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
