ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.plm/M Product
M_Product
Defines each product and identifies it for use in price lists and orders. The Location is the default location when receiving the stored products.
- Name:Product
- Classname:Product
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| M_Product_ID | N | VARCHAR2(32) | An item produced by a process. |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
| Created | N | DATE | The date that this record is completed. |
| CreatedBy | N | VARCHAR2(32) | User who created this records |
| Updated | N | DATE | x not implemented |
| UpdatedBy | N | VARCHAR2(32) | User who updated this records |
| Value | N | NVARCHAR2(40) | A fast method for finding a particular record. |
| Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
| Description | Y | NVARCHAR2(255) | A space to write additional related information. |
| DocumentNote | Y | NVARCHAR2(2000) | A space to write additional related information. |
| Help | Y | NVARCHAR2(2000) | A comment that adds additional information to help users work with fields. |
| UPC | Y | NVARCHAR2(30) | A bar code with a number to identify a product. |
| SKU | Y | VARCHAR2(30) | A "stock keeping unit" used to track items sold to business partners. |
| C_UOM_ID | N | VARCHAR2(32) | A non monetary unit of measure. |
| SalesRep_ID | Y | VARCHAR2(32) | The person in charge of a document. |
| IsSummary | N | CHAR(1) | A means of grouping fields in order to view or hide additional information. |
| IsStocked | N | CHAR(1) | Organization stocks this product |
| IsPurchased | N | CHAR(1) | An indication that an item may be purchased by a business partner. |
| IsSold | N | CHAR(1) | An indication that an item may be sold by a business partner. |
| IsBOM | N | CHAR(1) | Bill of Materials |
| IsInvoicePrintDetails | N | CHAR(1) | Print detail BOM elements on the invoice |
| IsPickListPrintDetails | N | CHAR(1) | Print detail BOM elements on the pick list |
| IsVerified | N | CHAR(1) | The BOM tree has been verified |
| M_Product_Category_ID | N | VARCHAR2(32) | A classification of items based on similar characteristics or attributes. |
| Classification | Y | CHAR(1) | x not implemented |
| Volume | Y | NUMBER | Volume of a product |
| Weight | Y | NUMBER | Weight of a product |
| ShelfWidth | Y | NUMBER(10, 0) | Shelf width required |
| ShelfHeight | Y | NUMBER(10, 0) | Shelf height required |
| ShelfDepth | Y | NUMBER(10, 0) | Shelf depth required |
| UnitsPerPallet | Y | NUMBER(10, 0) | Units Per Pallet |
| C_TaxCategory_ID | N | VARCHAR2(32) | A classification of tax options based on similar characteristics or attributes. |
| S_Resource_ID | Y | VARCHAR2(32) | x not implemented |
| Discontinued | Y | CHAR(1) | A statement mentioning that this product will no longer be available on the market. |
| DiscontinuedBy | Y | DATE | The name of the person who discontinues an item. |
| Processing | N | CHAR(1) | Verify BOM Structure |
| S_ExpenseType_ID | Y | VARCHAR2(32) | Expense report type |
| ProductType | N | VARCHAR2(60) | An important classification used to determine the accounting and management of a product. |
| ImageURL | Y | NVARCHAR2(120) | An address for the product image which can be accessed via internet. |
| DescriptionURL | Y | NVARCHAR2(120) | An address for the product description which can be accessed via internet. |
| GuaranteeDays | Y | NUMBER(10, 0) | Number of days the product is guaranteed or available |
| VersionNo | Y | NVARCHAR2(20) | Version Number |
| M_AttributeSet_ID | Y | VARCHAR2(32) | A group of attributes which are assigned to a selected product. |
| M_AttributeSetInstance_ID | Y | VARCHAR2(32) | An attribute associated with a product as part of an attribute set. |
| DownloadURL | Y | NVARCHAR2(120) | URL of the Download files |
| M_FreightCategory_ID | Y | VARCHAR2(32) | A classification used to help calculate shipping company freight amounts. |
| M_Locator_ID | Y | VARCHAR2(32) | A set of coordinates (x, y, z) which help locate an item in a warehouse. |
| AD_Image_ID | Y | VARCHAR2(32) | A visual picture used to describe an item. |
| C_BPartner_ID | Y | VARCHAR2(32) | Identifies a Business Partner |
| Ispriceprinted | Y | CHAR(1) | Defines if the pricestd is going to be printed or not in the document |
| Name2 | Y | NVARCHAR2(60) | Additional space to write the name of a business partner. |
| Costtype | Y | VARCHAR2(60) | A distinct cost characteristic used for processes. |
| Coststd | Y | NUMBER | null |
| Stock_Min | Y | NUMBER(10, 0) | Minimum stock of a product |
| Enforce_Attribute | Y | CHAR(1) | For differing the stock of a product by the attribute |
| Calculated | N | CHAR(1) | null |
| MA_Processplan_ID | Y | VARCHAR2(32) | A guide stating how a certain item must move through the transformation process. |
| Production | N | CHAR(1) | An indication that an item is being used in production. |
| Capacity | Y | NUMBER | Capacity |
| Delaymin | Y | NUMBER | Delaymin |
| MRP_Planner_ID | Y | VARCHAR2(32) | The person in charge of making an MRP plan. |
| MRP_Planningmethod_ID | Y | VARCHAR2(32) | null |
| Qtymax | Y | NUMBER | Maximum Quantity |
| Qtymin | Y | NUMBER | Minumun Quantity. |
| Qtystd | Y | NUMBER | Quantity Standard |
| Qtytype | Y | CHAR(1) | Quantity Type |
| Stockmin | Y | NUMBER | null |
| Attrsetvaluetype | Y | VARCHAR2(60) | A distinct Attribute Set Value characteristic. |
Other Info
Check constraints
These are the check constraints for this table:
- M_PRODUCT_ATSETVALTYPE_CHK: (M_ATTRIBUTESETINSTANCE_ID IS NULL) OR (ATTRSETVALUETYPE IS NOT NULL)
- M_PRODUCT_DISCONTINUED_CHECK: DISCONTINUED IN ('Y', 'N')
- M_PRODUCT_ENFORCE_ATTRIBUT_CHK: ENFORCE_ATTRIBUTE IN ('Y', 'N')
- M_PRODUCT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- M_PRODUCT_ISBOM_CHECK: ISBOM IN ('Y', 'N')
- M_PRODUCT_ISINVOICEPRINTDE_CHK: ISINVOICEPRINTDETAILS IN ('Y', 'N')
- M_PRODUCT_ISPICKLISTPRINTD_CHK: ISPICKLISTPRINTDETAILS IN ('Y', 'N')
- M_PRODUCT_ISPURCHASED_CHECK: ISPURCHASED IN ('Y', 'N')
- M_PRODUCT_ISSOLD_CHECK: ISSOLD IN ('Y', 'N')
- M_PRODUCT_ISSTOCKED_CHECK: ISSTOCKED IN ('Y', 'N')
- M_PRODUCT_ISVERIFIED_CHECK: ISVERIFIED IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Non Unique
- M_PRODUCT_BPARTNER
- M_PRODUCT_NAME
- M_PRODUCT_PRODUCTCATEGORY
- M_PRODUCT_UPC
Unique
- M_PRODUCT_EXPENSETYPE
- M_PRODUCT_KEY
- M_PRODUCT_RESOURCE
- M_PRODUCT_VALUE
Columns
Product
Identifies an item which is either purchased or sold in this organization.
- Physical column name: M_Product_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
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 reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Search Key
A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).
Usually, company's internal identifiers for various records (products, customers, etc) are stored here.
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Name
A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
Comments
The Document Note is used for recording any additional information regarding this product.
- Physical column name: DocumentNote
- Property Name: comments
- Reference: Text
Help/Comment
The Help field contains a hint, comment or help about the use of this item.
- Physical column name: Help
- Property Name: helpComment
- Reference: Text
UPC/EAN
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)
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
SKU
The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema.
- Physical column name: SKU
- Property Name: sKU
- Reference: String
UOM
- Physical column name: C_UOM_ID
- Property Name: uOM
- Reference: TableDir
Foreign key column to C_UOM table, (column: C_UOM_ID)
Sales Representative
- Physical column name: SalesRep_ID
- Property Name: salesRepresentative
- Reference: Table
Foreign key column to AD_User table, (column: AD_User_ID)
Reference Table AD_User SalesRep With the following where clause:
EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND bp.IsSalesRep='Y')
Summary Level
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.
- Physical column name: IsSummary
- Property Name: summaryLevel
- Reference: YesNo
Stocked
The Stocked check box indicates if this product is stocked by this Organization.
- Physical column name: IsStocked
- Property Name: stocked
- Reference: YesNo
- Default value: Y
Purchase
The Purchased check box indicates if this product is purchased by this organization.
- Physical column name: IsPurchased
- Property Name: purchase
- Reference: YesNo
- Default value: Y
Sale
The Sold check box indicates if this product is sold by this organization.
- Physical column name: IsSold
- Property Name: sale
- Reference: YesNo
- Default value: Y
Bill of Materials
The Bill of Materials check box indicates if this product consists of a bill of materials.
- Physical column name: IsBOM
- Property Name: billOfMaterials
- Reference: YesNo
- Default value: N
Print Details on Invoice
If “Print Details on Invoice” is checked then the details of the individual elements of the BOM will be printed on the Invoice.
- Physical column name: IsInvoicePrintDetails
- Property Name: printDetailsOnInvoice
- Reference: YesNo
Print Details on 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.
- Physical column name: IsPickListPrintDetails
- Property Name: printDetailsOnPickList
- Reference: YesNo
BOM Verified
Indicates if the bill of materials tree of this product has been verified. Verification involves a test for cycles within a tree so that there are no infinite loops.
- Physical column name: IsVerified
- Property Name: bOMVerified
- Reference: YesNo
- Default value: N
Product Category
- Physical column name: M_Product_Category_ID
- Property Name: productCategory
- Reference: TableDir
Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)
Classification
The Classification can be used to optionally group products.
- Physical column name: Classification
- Property Name: classification
- Reference: String
Volume
The Volume indicates the volume of the product in the Volume UOM of the Client
- Physical column name: Volume
- Property Name: volume
- Reference: Number
Weight
The Weight indicates the weight of the product in the Weight UOM of the Client
- Physical column name: Weight
- Property Name: weight
- Reference: Number
Shelf Width
The Shelf Width indicates the width dimension required on a shelf for a product
- Physical column name: ShelfWidth
- Property Name: shelfWidth
- Reference: Number
Shelf Height
The Shelf Height indicates the height dimension required on a shelf for a product
- Physical column name: ShelfHeight
- Property Name: shelfHeight
- Reference: Number
Shelf Depth
The Shelf Depth indicates the depth dimension required on a shelf for a product
- Physical column name: ShelfDepth
- Property Name: shelfDepth
- Reference: Number
Units Per Pallet
The Units per Pallet indicates the number of units of this product which fit on a pallet.
- Physical column name: UnitsPerPallet
- Property Name: unitsPerPallet
- Reference: Integer
Tax Category
- Physical column name: C_TaxCategory_ID
- Property Name: taxCategory
- Reference: TableDir
Foreign key column to C_TaxCategory table, (column: C_TaxCategory_ID)
Resource
- Physical column name: S_Resource_ID
- Property Name: resource
- Reference: TableDir
Foreign key column to S_Resource table, (column: S_Resource_ID)
Discontinued
The Discontinued check box indicates a product that has been discontinued.
- Physical column name: Discontinued
- Property Name: discontinued
- Reference: YesNo
Discontinued by
The Discontinued By indicates the individual who discontinued this product
- Physical column name: DiscontinuedBy
- Property Name: discontinuedBy
- Reference: Date
Verify BOM
The Verify BOM Structure checks the elements and steps which comprise a Bill of Materials.
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
- Default value: N
Expense Type
- Physical column name: S_ExpenseType_ID
- Property Name: expenseType
- Reference: TableDir
Foreign key column to S_ExpenseType table, (column: S_ExpenseType_ID)
Product Type
The type of product also determines accounting consequences.
- Physical column name: ProductType
- Property Name: productType
- Reference: List
- Default value: I
List values: M_Product_ProductType
The allowed values for this list are:
- E (Expense type)
- I (Item)
- O (Online)
- R (Resource)
- S (Service)
Image URL
URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png.
- Physical column name: ImageURL
- Property Name: imageURL
- Reference: String
- Default value: 800011
Description URL
URL for the description
- Physical column name: DescriptionURL
- Property Name: descriptionURL
- Reference: String
Guaranteed Days
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.
- Physical column name: GuaranteeDays
- Property Name: guaranteedDays
- Reference: Integer
Version No.
Version Number
- Physical column name: VersionNo
- Property Name: versionNo
- Reference: String
Attribute Set
- Physical column name: M_AttributeSet_ID
- Property Name: attributeSet
- Reference: TableDir
Foreign key column to M_AttributeSet table, (column: M_AttributeSet_ID)
Attribute Set Value
- Physical column name: M_AttributeSetInstance_ID
- Property Name: attributeSetValue
- Reference: PAttribute
Foreign key column to M_AttributeSetInstance table, (column: M_AttributeSetInstance_ID)
Download URL
Semicolon separated list of URLs to be downloaded or distributed
- Physical column name: DownloadURL
- Property Name: downloadURL
- Reference: String
Freight Category
- Physical column name: M_FreightCategory_ID
- Property Name: freightCategory
- Reference: TableDir
Foreign key column to M_FreightCategory table, (column: M_FreightCategory_ID)
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: Search
Foreign key column to M_Locator table, (column: M_Locator_ID)
Image
Defines a system image
- Physical column name: AD_Image_ID
- Property Name: image
- Reference: Image
Business Partner
A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Print Price
It allows you to print or not the price of a product in a document so you can summary many products in just one.
- Physical column name: Ispriceprinted
- Property Name: printPrice
- Reference: YesNo
- Default value: Y
Name 2
Additional Name
- Physical column name: Name2
- Property Name: name2
- Reference: String
Cost Type
Different types of cost
- Physical column name: Costtype
- Property Name: costType
- Reference: List
List values: Cost Type
The allowed values for this list are:
- AV (Average)
- ST (Standard)
Standard Cost
The value of the standard cost
- Physical column name: Coststd
- Property Name: standardCost
- Reference: Number
Minimum Stock
Minimum stock of a product
- Physical column name: Stock_Min
- Property Name: minimumStock
- Reference: Number
Enforce attribute
For differing the stock of a product by the attribute
- Physical column name: Enforce_Attribute
- Property Name: enforceAttribute
- Reference: YesNo
- Default value: N
Calculated
Indicates that the record has been calculated.
- Physical column name: Calculated
- Property Name: calculated
- Reference: YesNo
Process Plan
- Physical column name: MA_Processplan_ID
- Property Name: processPlan
- Reference: TableDir
Foreign key column to MA_Processplan table, (column: MA_Processplan_ID)
Production
A product that is used for production plans
- Physical column name: Production
- Property Name: production
- Reference: YesNo
Capacity
Capacity per day
- Physical column name: Capacity
- Property Name: capacity
- Reference: Number
Minimum Lead Time
Minimum number of days to complete the transaction
- Physical column name: Delaymin
- Property Name: minimumLeadTime
- Reference: Number
Planner
- Physical column name: MRP_Planner_ID
- Property Name: planner
- Reference: TableDir
Foreign key column to MRP_Planner table, (column: MRP_Planner_ID)
Planning Method
- Physical column name: MRP_Planningmethod_ID
- Property Name: planningMethod
- Reference: TableDir
Foreign key column to MRP_Planningmethod table, (column: MRP_Planningmethod_ID)
Max. Quantity
Maximum Quantity
- Physical column name: Qtymax
- Property Name: maxQuantity
- Reference: Quantity
Min. Quantity
Minumun Quantity.
- Physical column name: Qtymin
- Property Name: minQuantity
- Reference: Quantity
Standard Quantity
Quantity Standard
- Physical column name: Qtystd
- Property Name: standardQuantity
- Reference: Quantity
Quantity Type
Quantity Type
- Physical column name: Qtytype
- Property Name: quantityType
- Reference: YesNo
Safety Stock
Safety Stock
- Physical column name: Stockmin
- Property Name: safetyStock
- Reference: Number
Use Attribute Set Value As
Permits to define different types of Attribute Set Values, depending on their usage.
- Physical column name: Attrsetvaluetype
- Property Name: useAttributeSetValueAs
- Reference: List
List values: Use Attribute Set Value As
The allowed values for this list are:
- D (Default): This means that the attribute set value defined will be defaulted in each of the transactions. In other words, the user will not have to care about setting it each time when creating transactions such as goods receipts and shipments.
- F (Specification): This means that the attribute set value will specify completely the product. The attribute set value will always have this value and no other value will be allowed for it.
- O (Overwrite Specification): This means that the attribute set value will specify completely the product. Nevertheless, the attribute set value can be changed for this product.
Related tables
Tables that link this table:
- ApprovedVendor.Product
- BusinessPartnerProductTemplate.Product
- ClientInformation.Product for Freight
- DataImportGLJournal.Product
- DataImportInventory.Product
- DataImportInvoice.Product
- DataImportOrder.Product
- DataImportProduct.Product
- ExternalPOSProduct.Product
- FinancialMgmtAccountingCombination.Product
- FinancialMgmtAccountingFact.Product
- FinancialMgmtAcctSchemaElement.Product
- FinancialMgmtAsset.Product
- FinancialMgmtBudgetLine.Product
- InvoiceLine.Product
- InvoiceLineV2.Product
- Lot.Product
- MRPProductionRun.Product
- MRPProductionRunLine.Product
- MRPPurchasingRun.Product
- MRPPurchasingRunLine.Product
- MRPSalesForecastLine.Product
- ManufacturingCase.Product
- ManufacturingGlobalUse.Product
- ManufacturingOperationProduct.Product
- ManufacturingProductionLine.Product
- ManufacturingWorkRequirementProduct.Product
- MaterialMgmtCosting.Product
- MaterialMgmtInternalConsumptionLine.Product
- MaterialMgmtInternalMovementLine.Product
- MaterialMgmtInventoryCountLine.Product
- MaterialMgmtMaterialTransaction.Product
- MaterialMgmtProductionPlan.Product
- MaterialMgmtShipmentInOutLine.Product
- MaterialMgmtStorageDetail.Product
- MaterialMgmtStoragePending.Product
- OrderLine.Product
- OrderOpen.Product
- PricingAdjustmentProduct.Product
- PricingDiscount.Product
- PricingPriceListSchemeLine.Product
- PricingProductPrice.Product
- PricingVolumeDiscountProduct.Product
- ProcurementPOInvoiceMatch.Product
- ProcurementReceiptInvoiceMatch.Product
- ProcurementRequisitionLine.Product
- ProductBOM.BOM Product
- ProductCustomer.Product
- ProductOrg.Product
- ProductSubstitute.Product
- ProductSubstitute.Substitute Product
- ProductUOM.Product
- ProjectDetailsV.Product
- ProjectIssue.Product
- ProjectLine.Product
- ProjectPhase.Product
- ProjectProposalLine.Product
- ProjectStandardPhase.Product
- ProjectStandardTask.Product
- ProjectTask.Product
- Replenish.Product
- Request.Product
- RequestionAction.Product
- SalesCommission.Product
- SalesCommissionLine.Product
- ServiceLevel.Product
- Test.Product
- TimeAndExpenseSheetLine.Product
- TransactionSum.Product
- TransactionV.Product
- WarehouseScheduleProduct.Product