View source | Discuss this page | Page history | Printable version   

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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.plm

Index

Contents

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.

This table contains the following columns:

Name Nullable Data Type Description
M_Product_ID NVARCHAR2(32)An item produced by a process.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
Value NNVARCHAR2(40)A fast method for finding a particular record.
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Description YNVARCHAR2(255)A space to write additional related information.
DocumentNote YNVARCHAR2(2000)A space to write additional related information.
Help YNVARCHAR2(2000)A comment that adds additional information to help users work with fields.
UPC YNVARCHAR2(30)A bar code with a number to identify a product.
SKU YVARCHAR2(30)A "stock keeping unit" used to track items sold to business partners.
C_UOM_ID NVARCHAR2(32)A non monetary unit of measure.
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
IsSummary NCHAR(1)A means of grouping fields in order to view or hide additional information.
IsStocked NCHAR(1)Organization stocks this product
IsPurchased NCHAR(1)An indication that an item may be purchased by a business partner.
IsSold NCHAR(1)An indication that an item may be sold by a business partner.
IsBOM NCHAR(1)Bill of Materials
IsInvoicePrintDetails NCHAR(1)Print detail BOM elements on the invoice
IsPickListPrintDetails NCHAR(1)Print detail BOM elements on the pick list
IsVerified NCHAR(1)The BOM tree has been verified
M_Product_Category_ID NVARCHAR2(32)A classification of items based on similar characteristics or attributes.
Classification YCHAR(1)x not implemented
Volume YNUMBERVolume of a product
Weight YNUMBERWeight of a product
ShelfWidth YNUMBER(10, 0)Shelf width required
ShelfHeight YNUMBER(10, 0)Shelf height required
ShelfDepth YNUMBER(10, 0)Shelf depth required
UnitsPerPallet YNUMBER(10, 0)Units Per Pallet
C_TaxCategory_ID NVARCHAR2(32)A classification of tax options based on similar characteristics or attributes.
S_Resource_ID YVARCHAR2(32)x not implemented
Discontinued YCHAR(1)A statement mentioning that this product will no longer be available on the market.
DiscontinuedBy YDATEThe name of the person who discontinues an item.
Processing NCHAR(1)Verify BOM Structure
S_ExpenseType_ID YVARCHAR2(32)Expense report type
ProductType NVARCHAR2(60)An important classification used to determine the accounting and management of a product.
ImageURL YNVARCHAR2(120)An address for the product image which can be accessed via internet.
DescriptionURL YNVARCHAR2(120)An address for the product description which can be accessed via internet.
GuaranteeDays YNUMBER(10, 0)Number of days the product is guaranteed or available
VersionNo YNVARCHAR2(20)Version Number
M_AttributeSet_ID YVARCHAR2(32)A group of attributes which are assigned to a selected product.
M_AttributeSetInstance_ID YVARCHAR2(32)An attribute associated with a product as part of an attribute set.
DownloadURL YNVARCHAR2(120)URL of the Download files
M_FreightCategory_ID YVARCHAR2(32)A classification used to help calculate shipping company freight amounts.
M_Locator_ID YVARCHAR2(32)A set of coordinates (x, y, z) which help locate an item in a warehouse.
AD_Image_ID YVARCHAR2(32)A visual picture used to describe an item.
C_BPartner_ID YVARCHAR2(32)Identifies a Business Partner
Ispriceprinted YCHAR(1)Defines if the pricestd is going to be printed or not in the document
Name2 YNVARCHAR2(60)Additional space to write the name of a business partner.
Costtype YVARCHAR2(60)A distinct cost characteristic used for processes.
Coststd YNUMBERnull
Stock_Min YNUMBER(10, 0)Minimum stock of a product
Enforce_Attribute YCHAR(1)For differing the stock of a product by the attribute
Calculated NCHAR(1)null
MA_Processplan_ID YVARCHAR2(32)A guide stating how a certain item must move through the transformation process.
Production NCHAR(1)An indication that an item is being used in production.
Capacity YNUMBERCapacity
Delaymin YNUMBERDelaymin
MRP_Planner_ID YVARCHAR2(32)The person in charge of making an MRP plan.
MRP_Planningmethod_ID YVARCHAR2(32)null
Qtymax YNUMBERMaximum Quantity
Qtymin YNUMBERMinumun Quantity.
Qtystd YNUMBERQuantity Standard
Qtytype YCHAR(1)Quantity Type
Stockmin YNUMBERnull
Attrsetvaluetype YVARCHAR2(60)A distinct Attribute Set Value characteristic.

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

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

Non Unique

Unique

top

Columns

Product

Identifies an item which is either purchased or sold in this organization.

top

Client

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

top

Organization

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

top

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

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

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

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

top

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.

top

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.

top

Description

A description is limited to 255 characters.

top

Comments

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

top

Help/Comment

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

top

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)

top

SKU

The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema.

top

UOM

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

top

Sales Representative

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


top

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.

top

Stocked

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

top

Purchase

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

top

Sale

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

top

Bill of Materials

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

top

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.

top

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.

top

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.

top

Product Category

Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)

top

Classification

The Classification can be used to optionally group products.

top

Volume

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

top

Weight

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

top

Shelf Width

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

top

Shelf Height

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

top

Shelf Depth

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

top

Units Per Pallet

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

top

Tax Category

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

top

Resource

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

top

Discontinued

The Discontinued check box indicates a product that has been discontinued.

top

Discontinued by

The Discontinued By indicates the individual who discontinued this product

top

Verify BOM

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

top

Expense Type

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

top

Product Type

The type of product also determines accounting consequences.

List values: M_Product_ProductType

The allowed values for this list are:

top

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.

top

Description URL

URL for the description

top

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.

top

Version No.

Version Number

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

Download URL

Semicolon separated list of URLs to be downloaded or distributed

top

Freight Category

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

top

Storage Bin

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

top

Image

Defines a system image

top

Business Partner

A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson

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

top

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.

top

Name 2

Additional Name

top

Cost Type

Different types of cost

List values: Cost Type

The allowed values for this list are:

top

Standard Cost

The value of the standard cost

top

Minimum Stock

Minimum stock of a product

top

Enforce attribute

For differing the stock of a product by the attribute

top

Calculated

Indicates that the record has been calculated.

top

Process Plan

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

top

Production

A product that is used for production plans

top

Capacity

Capacity per day

top

Minimum Lead Time

Minimum number of days to complete the transaction

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

Maximum Quantity

top

Min. Quantity

Minumun Quantity.

top

Standard Quantity

Quantity Standard

top

Quantity Type

Quantity Type

top

Safety Stock

Safety Stock

top

Use Attribute Set Value As

Permits to define different types of Attribute Set Values, depending on their usage.

List values: Use Attribute Set Value As

The allowed values for this list are:

top

Related tables

Tables that link this table:

top

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

This page has been accessed 8,239 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.