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


S_ExpenseType_ID Yes VARCHAR (32) Expense report type
DownloadURL Yes NVARCHAR (120) Semicolon separated list of URLs to be downloaded or distributed
M_FreightCategory_ID Yes VARCHAR (32) Freight Categories are used to calculate the Freight for the Shipper selected
S_Resource_ID Yes VARCHAR (32) The ID identifies a unique resource
M_Locator_ID Yes VARCHAR (32) The Locator ID indicates where in a Warehouse a product is located.
M_AttributeSetInstance_ID Yes VARCHAR (32) The values of the actual Product Attributes
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.
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.
VersionNo Yes NVARCHAR (20) Version Number
DescriptionURL Yes NVARCHAR (120) URL for the description
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.
AD_Image_ID Yes VARCHAR (32) Defines a system image
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.
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.
Name2 Yes NVARCHAR (60) Additional Name
Costtype Yes VARCHAR (60) Different types of cost.
Coststd Yes DECIMAL The value of the standard cost used by the legacy engine
Stock_Min Yes DECIMAL (10,0) Minimum stock of a product
Enforce_Attribute Yes CHAR (1) For differing the stock of a product by the attribute
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.

Calculated No CHAR (1) Indicates that the record has been calculated.
MA_Processplan_ID Yes VARCHAR (32) Indicates a process plan.
Production No CHAR (1) A product that is used for production plans
Capacity Yes DECIMAL Capacity per day
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.
Delaymin Yes DECIMAL Minimum number of days to complete the transaction
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.
Qtymax Yes DECIMAL Maximum Quantity
Qtymin Yes DECIMAL Minumun Quantity.
M_Product_Category_ID No VARCHAR (32) Identifies the category which this product belongs to. Product categories are used for pricing.
Qtystd Yes DECIMAL Quantity Standard
Qtytype Yes CHAR (1) Quantity Type
Stockmin Yes DECIMAL Safety Stock
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.

C_TaxCategory_ID No VARCHAR (32) The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax.
Attrsetvaluetype Yes VARCHAR (60) Permits to define different types of Attribute Set Values, depending on their usage.
Isquantityvariable No CHAR (1) If checked, goods shipment lines and sales invoice lines with quantity greater than quantity ordered are permitted for this product.
Isdeferredrevenue No CHAR (1) When flagged revenue of the product will be deferred using the plan and the number of periods
Revplantype Yes VARCHAR (60) Set the type of plan to be used when deferring revenue
Periodnumber Yes DECIMAL Set here the number of periods to be used when deferring the revenue
Isdeferredexpense No CHAR (1) When flagged expense of the product will be deferred using the plan and the number of periods
Expplantype Yes VARCHAR (60) Set the type of plan to be used when deferring expense
Periodnumber_Exp Yes DECIMAL Set here the number of periods to be used when deferring the expense
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.
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.
IsGeneric No CHAR (1) Identifies a generic product. A generic product cannot be purchased or sold.
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.
CreateVariants Yes CHAR (1)
Characteristic_Desc Yes NVARCHAR (2000) Text with the concatenation of the characteristics and its values assigned to the product.
Updateinvariants Yes CHAR (1)
ManageVariants Yes CHAR (1)
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.
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)
Print_Description No CHAR (1) If selected, the ticket footer printing should add the description of the Service
Returnable No CHAR (1) Indicates is the Service is Returnable or not
Overdue_Return_Days Yes DECIMAL Indicates if a Service is Returnable how many days has the customer to return it after buying
Ispricerulebased No CHAR (1) Indicates if the Service has a fixed price or it obtains the price based on a Service Price Rule.
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.
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

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.
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.
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
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.
Processing No CHAR (1) When this field is set as 'Y' a process is being performed on this record.
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.
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.
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.
IsBOM No CHAR (1) The Bill of Materials check box indicates if this product consists of a bill of materials.
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.
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.
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
DocumentNote Yes NVARCHAR (2000) The Document Note is used for recording any additional information regarding this product.
DiscontinuedBy Yes TIMESTAMP (7) The Discontinued By indicates the individual who discontinued this product
Discontinued Yes CHAR (1) The Discontinued check box indicates a product that has been discontinued.
UnitsPerPallet Yes DECIMAL (10,0) The Units per Pallet indicates the number of units of this product which fit on a pallet.
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
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.
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)
Weight Yes DECIMAL The Weight indicates the weight of the product in the Weight UOM of the Client
Volume Yes DECIMAL The Volume indicates the volume of the product in the Volume UOM of the Client
IsSold No CHAR (1) The Sold check box indicates if this product is sold by this organization.
IsPurchased No CHAR (1) The Purchased check box indicates if this product is purchased by this organization.
IsStocked No CHAR (1) The Stocked check box indicates if this product is stocked by this Organization.
C_UOM_ID No VARCHAR (32) The UOM defines a unique non monetary unit of measure
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.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
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.
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.

AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
M_Product_ID No VARCHAR (32) Identifies an item which is either purchased or sold in this organization.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
Classification Yes CHAR (1) The Classification can be used to optionally group products.

Columns

Expense Type


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

top


Download URL



top


Freight Category


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

top


Resource


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

top


Storage Bin


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

top


Attribute Set Value


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

top


Attribute Set


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

top


Guaranteed Days



top


Version No.



top


Description URL



top


Image URL



top


Image


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

top


Business Partner


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

top


Print Price



top


Name 2



top


Cost Type



List values: Cost Type

The allowed values for this list are:

top


Standard Cost



top


Minimum Stock



top


Enforce attribute



top


Search Key



top


Calculated



top


Process Plan


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

top


Production



top


Capacity



top


Name


top


Minimum Lead Time



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


Max. Quantity



top


Min. Quantity



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


Standard Quantity



top


Quantity Type



top


Safety Stock



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 [1] Java Class.

List values: M_Product_ProductType

The allowed values for this list are:

top


Tax Category


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

top


Use Attribute Set Value As



List values: Use Attribute Set Value As

The allowed values for this list are:

top


Isquantityvariable



top


Deferred Revenue



top


Revenue Plan Type



List values: Accruals and Deferrals Plan Types

The allowed values for this list are:

top


Period Number



top


Isdeferredexpense



top


Expplantype



List values: Accruals and Deferrals Plan Types

The allowed values for this list are:

top


Periodnumber_Exp



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


Book Using Purchase Order Price



top


Brand


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

top


Is Generic



top


Generic Product


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

top


Create Variants



top


Characteristic Description



top


UpdateInvariants



top


Manage Variants



top


UOM for Weight


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

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


Print_Description



top


Returnable



top


Overdue_Return_Days



top


Ispricerulebased



top


Unique_Per_Document



top


Relateprodcattoservice



top


Relateprodtoservice



top


linkedToProduct



top


Quantity_Rule



List values: M_Services Quantity Rule

The allowed values for this list are:

top


Allow Deferred Sell



top


Deferred Sell Max Days



top


Process Now



top


BOM Verified



top


Print Details on Pick List



top


Print Details on Invoice



top


Bill of Materials



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 [2] Java Class.

top


Sales Representative


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

top


Help/Comment



top


Comments



top


Discontinued by



top


Discontinued



top


Units Per Pallet



top


Shelf Depth



top


Shelf Height



top


Shelf Width



top


SKU



top


UPC/EAN



top


Weight



top


Volume



top


Sale



top


Purchase



top


Stocked



top


UOM


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

top


Summary Level



top


Description



top


Updated By


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

top


Created By


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

top


Creation Date



top


Active



top


Client


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

top


Product



top


Updated



top


Classification



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 3,493 times. This page was last modified on 1 September 2016, at 02:29. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.