View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.plm/M Product

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.plm


Contents

M_Product

This table contains the following columns:

Name Nullable Data Type Description


IsActive No CHAR (1) 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.

Allow_Deferred_Sell No CHAR (1) Boolean field available for product of type service that defines whether the service can be linked to a product in a non-active ticket or not
M_AttributeSet_ID Yes VARCHAR (32) 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_AttributeSetInstance_ID Yes VARCHAR (32) The values of the actual Product Attributes
IsVerified No CHAR (1) 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.
IsBOM No CHAR (1) The Bill of Materials check box indicates if this product consists of a bill of materials.
Bookusingpoprice No CHAR (1) When checked, the Purchase Order posting will use the Purchase Order Price instead of the Product Cost.
M_Brand_ID Yes VARCHAR (32) The brand identifies the Manufacturer or a type of product manufactured by a company under a particular name.
C_BPartner_ID Yes VARCHAR (32) A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
Calculated No CHAR (1) Indicates that the record has been calculated.
Capacity Yes DECIMAL Capacity per day
Characteristic_Desc Yes NVARCHAR (2000) Text with the concatenation of the characteristics and its values assigned to the product.
Classification Yes CHAR (1) The Classification can be used to optionally group products.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
DocumentNote Yes NVARCHAR (2000) The Document Note is used for recording any additional information regarding this product.
Copyservicemodifytaxconfig No CHAR (1) Process to copy configuration from current service to selected services. This process erases existing configuration for the target service/s.
CreateVariants Yes CHAR (1)
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
DefaultPeriod Yes VARCHAR (60) Used for the different calculation methods of default period in a deferred revenue/expense plan.
DefaultPeriod_Exp Yes VARCHAR (60) Used for the different calculation methods of default period in a deferred revenue/expense plan.
Isdeferredrevenue No CHAR (1) When flagged revenue of the product will be deferred using the plan and the number of periods
Deferred_Sell_Max_Days Yes DECIMAL Defines in the case of services that does allow deferred sell the maximum days after the original product was sold, this service can be linked with it.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
DescriptionURL Yes NVARCHAR (120) URL for the description
Discontinued Yes CHAR (1) The Discontinued check box indicates a product that has been discontinued.
DiscontinuedBy Yes TIMESTAMP (7) The Discontinued By indicates the individual who discontinued this product
DownloadURL Yes NVARCHAR (120) Semicolon separated list of URLs to be downloaded or distributed
Enforce_Attribute Yes CHAR (1) For differing the stock of a product by the attribute
S_ExpenseType_ID Yes VARCHAR (32) Expense report type
Expplantype Yes VARCHAR (60) Set the type of plan to be used when deferring expense
M_FreightCategory_ID Yes VARCHAR (32) Freight Categories are used to calculate the Freight for the Shipper selected
Generic_Product_ID Yes VARCHAR (32) Generic product related to this product. The product will inherit all the properties defined in the generic product. Such as taxes or price.
GuaranteeDays Yes DECIMAL (10,0) 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.
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
AD_Image_ID Yes VARCHAR (32) Defines a system image
ImageURL Yes NVARCHAR (120) URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png.
Prod_Cat_Selection Yes VARCHAR (60) Defines the way Product Categories will be selected (including or excluding the taken ones)
Product_Selection Yes VARCHAR (60) Defines the way Products will be selected (including or excluding the taken ones)
IsGeneric No CHAR (1) Identifies a generic product. A generic product cannot be purchased or sold.
Isdeferredexpense No CHAR (1) When flagged expense of the product will be deferred using the plan and the number of periods
Ispricerulebased No CHAR (1) Indicates if the Service has a fixed price or it obtains the price based on a Service Price Rule.
Isquantityvariable No CHAR (1) If checked, goods shipment lines and sales invoice lines with quantity greater than quantity ordered are permitted for this product.
M_Product_Status_ID Yes VARCHAR (32) Product Lifecycle Management Status
ManageVariants Yes CHAR (1)
Qtymax Yes DECIMAL Maximum Quantity
Qtymin Yes DECIMAL Minumun Quantity.
Delaymin Yes DECIMAL Minimum number of days to complete the transaction
Stock_Min Yes DECIMAL (10,0) Minimum stock of a product
Ismodifytax No CHAR (1) The service can modify the tax of the linked products. If so, when adding the product to a Sales Order, the related service product can assign a different tax category to the linked products following the service product configuration.
Name No NVARCHAR (60) 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.
Name2 Yes NVARCHAR (60) Additional Name
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Overdue_Return_Days Yes DECIMAL Indicates if a Service is Returnable how many days has the customer to return it after buying
Periodnumber Yes DECIMAL Set here the number of periods to be used when deferring the revenue
Periodnumber_Exp Yes DECIMAL Set here the number of periods to be used when deferring the expense
MRP_Planner_ID Yes VARCHAR (32) Identifies a planner of the MRP.
MRP_Planningmethod_ID Yes VARCHAR (32) Identifies a method for filtering the input for planning processes.
IsInvoicePrintDetails No CHAR (1) If ?Print Details on Invoice? is checked then the details of the individual elements of the BOM will be printed on the Invoice.
IsPickListPrintDetails No CHAR (1) The Print Details on Pick List indicates that the BOM element products will print on the Pick List as opposed to this product.
Ispriceprinted Yes CHAR (1) It allows you to print or not the price of a product in a document so you can summary many products in just one.
Print_Description No CHAR (1) If selected, the ticket footer printing should add the description of the Service
Processing No CHAR (1) When this field is set as 'Y' a process is being performed on this record.
MA_Processplan_ID Yes VARCHAR (32) Indicates a process plan.
M_Product_ID No VARCHAR (32) Identifies an item which is either purchased or sold in this organization.
M_Product_Category_ID No VARCHAR (32) Identifies the category which this product belongs to. Product categories are used for pricing.
ProductType No VARCHAR (60) There are four types of products available. Item type can be used to configure any product such as raw materials or finished products ready to be sold. An item can be flagged as Socked or not, can be part of a production process and/or can be a bill of materials. Item type is the only one for which a cost type calculation can be configured. Service type can be used to configure consultancy, transport or insurance services. Service type can be purchased or sold but can not be stocked. A service can be a bill of materials. Finally Resource and Expense are product types which can be used to distinguish between different types of products which can be purchased or sold but make not sense to stock. Expense type can be used to configure travel expenses fto be used while reporting Employee Expenses.

The fact of using a given product type does not mean a different accounting. All product types account same way while being purchased, stocked or sold. All of them use the ledger accounts defined in the Accounting tab of the Product window.

Production No CHAR (1) A product that is used for production plans
IsPurchased No CHAR (1) The Purchased check box indicates if this product is purchased by this organization.
Qtytype Yes CHAR (1) Quantity Type
Quantity_Rule Yes VARCHAR (60) There are two values:
* As per product: One relation line per each different product line will be created.
* Unique quantity: Only one relation line will be created with the total amount of all related lines.
Relateprodcattaxtoservice No CHAR (1) Process to define the Modify Tax configuration for the selected services
Relateprodcattoservice Yes CHAR (1) P&E to include/exclude product categories in Products tab to indicate that the Service could be applied on those product categories.

This P&E is only visible for Service Type Products

Relateprodtoservice Yes CHAR (1) P&E to include/exclude products in Products tab to indicate that the Service could be applied on those products.

This P&E is only visible for Service Type Products

S_Resource_ID Yes VARCHAR (32) The ID identifies a unique resource
Returnable No CHAR (1) Indicates if the Product is Returnable or not
Revplantype Yes VARCHAR (60) Set the type of plan to be used when deferring revenue
SKU Yes VARCHAR (30) The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema.
Stockmin Yes DECIMAL Safety Stock
IsSold No CHAR (1) The Sold check box indicates if this product is sold by this organization.
SalesRep_ID Yes VARCHAR (32) Indicates the sales representative responsible for the transaction that the document specifies . A valid sales representative is a business partner marked as an employee and a sales representative.
Value No NVARCHAR (40) 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.

ShelfDepth Yes DECIMAL (10,0) The Shelf Depth indicates the depth dimension required on a shelf for a product
ShelfHeight Yes DECIMAL (10,0) The Shelf Height indicates the height dimension required on a shelf for a product
ShelfWidth Yes DECIMAL (10,0) The Shelf Width indicates the width dimension required on a shelf for a product
Qtystd Yes DECIMAL Quantity Standard
IsStocked No CHAR (1) The Stocked check box indicates if this product is stocked by this Organization.
M_Locator_ID Yes VARCHAR (32) The Locator ID indicates where in a Warehouse a product is located.
IsSummary No CHAR (1) 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.
C_TaxCategory_ID No VARCHAR (32) The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax.
C_UOM_ID No VARCHAR (32) The UOM defines a unique non monetary unit of measure
C_Uom_Weight_ID Yes VARCHAR (32) The Standard UOM for Weight indicates the UOM to use for products referenced by weight in a document.
UPC Yes NVARCHAR (30) 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)
Unique_Per_Document No CHAR (1) This flag indicates if the Service can only be added once in a ticket. This Service could be related to zero, one or more than one lines of the ticket.
UnitsPerPallet Yes DECIMAL (10,0) The Units per Pallet indicates the number of units of this product which fit on a pallet.
Updateinvariants Yes CHAR (1)
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
Attrsetvaluetype Yes VARCHAR (60) Permits to define different types of Attribute Set Values, depending on their usage.
VersionNo Yes NVARCHAR (20) Version Number
Volume Yes DECIMAL The Volume indicates the volume of the product in the Volume UOM of the Client
Weight Yes DECIMAL The Weight indicates the weight of the product in the Weight UOM of the Client
Islinkedtoproduct No CHAR (1) The service can be linked to a Product. If so, when adding the product to a Sales Order, the related service product could be added to the Sales Order also, following special rules to set the quantity to be added and the price of the service, both of them based on the product.

Columns

Active



top


Allow Deferred Sell



top


Attribute Set


Foreign key column to M_AttributeSet table, (column: M_AttributeSet_ID)

top


Attribute Set Value


Foreign key column to M_AttributeSetInstance table, (column: M_AttributeSetInstance_ID)

top


BOM Verified



top


Bill of Materials



top


Book Using Purchase Order Price



top


Brand


Foreign key column to M_Brand table, (column: M_Brand_ID)

top


Business Partner


Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top


Calculated



top


Capacity



top


Characteristic Description



top


Classification



top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID)

top


Comments



top


Copyservicemodifytaxconfig



top


Create Variants



top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Default Period



List values: Default Period Options

The allowed values for this list are:

top


Default Period Expense



List values: Default Period Options

The allowed values for this list are:

top


Deferred Revenue



top


Deferred Sell Max Days



top


Description



top


Description URL



top


Discontinued



top


Discontinued by



top


Download URL



top


Enforce attribute



top


Expense Type


Foreign key column to S_ExpenseType table, (column: S_ExpenseType_ID)

top


Expplantype



List values: Accruals and Deferrals Plan Types

The allowed values for this list are:

top


Freight Category


Foreign key column to M_FreightCategory table, (column: M_FreightCategory_ID)

top


Generic Product


Foreign key column to M_Product table, (column: M_Product_ID)

top


Guaranteed Days



top


Help/Comment



top


Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Image URL



top


Included Product Categories



List values: Offers

The allowed values for this list are:

top


Included Products



List values: Offers

The allowed values for this list are:

top


Is Generic



top


Isdeferredexpense



top


Ispricerulebased



top


Isquantityvariable



top


M_Product_Status_ID


Foreign key column to M_Product_Status table, (column: M_Product_Status_ID)

top


Manage Variants



top


Max. Quantity



top


Min. Quantity



top


Minimum Lead Time



top


Minimum Stock



top


ModifyTax



top


Name


top


Name 2



top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

Callout: SL_TaxCategory_Org

This column has a callout associated.

It is implemented by [1] Java Class.

top


Overdue_Return_Days



top


Period Number



top


Periodnumber_Exp



top


Planner


Foreign key column to MRP_Planner table, (column: MRP_Planner_ID)

top


Planning Method


Foreign key column to MRP_PlanningMethod table, (column: MRP_Planningmethod_ID)

top


Print Details on Invoice



top


Print Details on Pick List



top


Print Price



top


Print_Description



top


Process Now



top


Process Plan


Foreign key column to MA_ProcessPlan table, (column: MA_Processplan_ID)

top


Product



top


Product Category


Foreign key column to M_Product_Category table, (column: M_Product_Category_ID) It has a validation "M_ProductCategory(Only Leaf)", with the following code

Issummary='N'

top


Product Type


Callout: SL_Product_Type

This column has a callout associated. This callout changes the value of the stocked field if the product type is Service.

It is implemented by [2] Java Class.

List values: M_Product_ProductType

The allowed values for this list are:

top


Production



top


Purchase



top


Quantity Type



top


Quantity_Rule



List values: M_Services Quantity Rule

The allowed values for this list are:

top


Relateprodcattaxtoservice



top


Relateprodcattoservice



top


Relateprodtoservice



top


Resource


Foreign key column to S_Resource table, (column: S_Resource_ID)

top


Returnable



top


Revenue Plan Type



List values: Accruals and Deferrals Plan Types

The allowed values for this list are:

top


SKU



top


Safety Stock



top


Sale



top


Sales Representative


Foreign key column to AD_User table, (column: AD_User_ID)

top


Search Key



top


Shelf Depth



top


Shelf Height



top


Shelf Width



top


Standard Quantity



top


Stocked



top


Storage Bin


Foreign key column to M_Locator table, (column: M_Locator_ID)

top


Summary Level



top


Tax Category


Foreign key column to C_TaxCategory table, (column: C_TaxCategory_ID)

top


UOM


Foreign key column to C_UOM table, (column: C_UOM_ID)

top


UOM for Weight


Foreign key column to C_UOM table, (column: C_UOM_ID)

top


UPC/EAN



top


Unique_Per_Document



top


Units Per Pallet



top


UpdateInvariants



top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Use Attribute Set Value As



List values: Use Attribute Set Value As

The allowed values for this list are:

top


Version No.



top


Volume



top


Weight



top


linkedToProduct



top


Other Info

Indices

These are the indices for this table (for each index there is a list of all the columns included within it):

top

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.common.plm

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.plm/M_Product"

This page has been accessed 12,383 times. This page was last modified on 6 February 2023, at 01:41. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.