ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.plm/M Product
M_Product
- Name:M_Product
- Classname: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
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Allow Deferred Sell
- Physical column name: Allow_Deferred_Sell
- Property Name: allowDeferredSell
- Reference: YesNo
- Default value: N
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)
BOM Verified
- Physical column name: IsVerified
- Property Name: bOMVerified
- Reference: YesNo
- Default value: N
Bill of Materials
- Physical column name: IsBOM
- Property Name: billOfMaterials
- Reference: YesNo
- Default value: N
Book Using Purchase Order Price
- Physical column name: Bookusingpoprice
- Property Name: bookUsingPurchaseOrderPrice
- Reference: YesNo
- Default value: N
Brand
- Physical column name: M_Brand_ID
- Property Name: brand
- Reference: TableDir
Foreign key column to M_Brand table, (column: M_Brand_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Calculated
- Physical column name: Calculated
- Property Name: calculated
- Reference: YesNo
- Default value: N
Capacity
- Physical column name: Capacity
- Property Name: capacity
- Reference: Number
Characteristic Description
- Physical column name: Characteristic_Desc
- Property Name: characteristicDescription
- Reference: Product Characteristics
Classification
- Physical column name: Classification
- Property Name: classification
- Reference: String
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Comments
- Physical column name: DocumentNote
- Property Name: comments
- Reference: Text
Copyservicemodifytaxconfig
- Physical column name: Copyservicemodifytaxconfig
- Property Name: copyservicemodifytaxconfig
- Reference: Button
- Default value: N
Create Variants
- Physical column name: CreateVariants
- Property Name: createVariants
- Reference: Button
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Default Period
- Physical column name: DefaultPeriod
- Property Name: defaultPeriod
- Reference: List
List values: Default Period Options
The allowed values for this list are:
- C (Current Month)
- N (Next Month)
- M (Manual)
Default Period Expense
- Physical column name: DefaultPeriod_Exp
- Property Name: defaultPeriodExpense
- Reference: List
List values: Default Period Options
The allowed values for this list are:
- C (Current Month)
- N (Next Month)
- M (Manual)
Deferred Revenue
- Physical column name: Isdeferredrevenue
- Property Name: deferredRevenue
- Reference: YesNo
- Default value: N
Deferred Sell Max Days
- Physical column name: Deferred_Sell_Max_Days
- Property Name: deferredSellMaxDays
- Reference: Integer
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Description URL
- Physical column name: DescriptionURL
- Property Name: descriptionURL
- Reference: String
Discontinued
- Physical column name: Discontinued
- Property Name: discontinued
- Reference: YesNo
- Default value: N
Discontinued by
- Physical column name: DiscontinuedBy
- Property Name: discontinuedBy
- Reference: Date
Download URL
- Physical column name: DownloadURL
- Property Name: downloadURL
- Reference: String
Enforce attribute
- Physical column name: Enforce_Attribute
- Property Name: enforceAttribute
- Reference: YesNo
- 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)
Expplantype
- Physical column name: Expplantype
- Property Name: expplantype
- Reference: List
List values: Accruals and Deferrals Plan Types
The allowed values for this list are:
- M (Monthly)
Freight Category
- Physical column name: M_FreightCategory_ID
- Property Name: freightCategory
- Reference: TableDir
Foreign key column to M_FreightCategory table, (column: M_FreightCategory_ID)
Generic Product
- Physical column name: Generic_Product_ID
- Property Name: genericProduct
- Reference: Table
Foreign key column to M_Product table, (column: M_Product_ID)
Guaranteed Days
- Physical column name: GuaranteeDays
- Property Name: guaranteedDays
- Reference: Integer
Help/Comment
- Physical column name: Help
- Property Name: helpComment
- Reference: Text
Image
- Physical column name: AD_Image_ID
- Property Name: image
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Image URL
- Physical column name: ImageURL
- Property Name: imageURL
- Reference: String
Included Product Categories
- Physical column name: Prod_Cat_Selection
- Property Name: includedProductCategories
- Reference: List
List values: Offers
The allowed values for this list are:
- N (Only those defined)
- Y (All excluding defined)
Included Products
- Physical column name: Product_Selection
- Property Name: includedProducts
- Reference: List
List values: Offers
The allowed values for this list are:
- N (Only those defined)
- Y (All excluding defined)
Is Generic
- Physical column name: IsGeneric
- Property Name: isGeneric
- Reference: YesNo
- Default value: N
Isdeferredexpense
- Physical column name: Isdeferredexpense
- Property Name: isdeferredexpense
- Reference: YesNo
- Default value: N
Ispricerulebased
- Physical column name: Ispricerulebased
- Property Name: ispricerulebased
- Reference: YesNo
- Default value: N
Isquantityvariable
- Physical column name: Isquantityvariable
- Property Name: isquantityvariable
- Reference: YesNo
- Default value: N
M_Product_Status_ID
- Physical column name: M_Product_Status_ID
- Property Name: productStatus
- Reference: OBUISEL_Selector Reference
Foreign key column to M_Product_Status table, (column: M_Product_Status_ID)
Manage Variants
- Physical column name: ManageVariants
- Property Name: manageVariants
- Reference: Button
- Default value: N
Max. Quantity
- Physical column name: Qtymax
- Property Name: maxQuantity
- Reference: Quantity
Min. Quantity
- Physical column name: Qtymin
- Property Name: minQuantity
- Reference: Quantity
Minimum Lead Time
- Physical column name: Delaymin
- Property Name: minimumLeadTime
- Reference: Number
Minimum Stock
- Physical column name: Stock_Min
- Property Name: minimumStock
- Reference: Number
ModifyTax
- Physical column name: Ismodifytax
- Property Name: modifyTax
- Reference: YesNo
- Default value: N
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Name 2
- Physical column name: Name2
- Property Name: name2
- Reference: String
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
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.
Overdue_Return_Days
- Physical column name: Overdue_Return_Days
- Property Name: overdueReturnDays
- Reference: Integer
Period Number
- Physical column name: Periodnumber
- Property Name: periodNumber
- Reference: Integer
Periodnumber_Exp
- Physical column name: Periodnumber_Exp
- Property Name: periodnumberExp
- Reference: Integer
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)
Print Details on Invoice
- Physical column name: IsInvoicePrintDetails
- Property Name: printDetailsOnInvoice
- Reference: YesNo
- Default value: N
Print Details on Pick List
- Physical column name: IsPickListPrintDetails
- Property Name: printDetailsOnPickList
- Reference: YesNo
- Default value: N
Print Price
- Physical column name: Ispriceprinted
- Property Name: printPrice
- Reference: YesNo
Print_Description
- Physical column name: Print_Description
- Property Name: printDescription
- Reference: YesNo
- Default value: N
Process Now
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
- Default value: N
Process Plan
- Physical column name: MA_Processplan_ID
- Property Name: processPlan
- Reference: TableDir
Foreign key column to MA_ProcessPlan table, (column: MA_Processplan_ID)
Product
- Physical column name: M_Product_ID
- Property Name: id
- Reference: ID
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)
It has a validation "M_ProductCategory(Only Leaf)", with the following code
Issummary='N'
Product Type
- Physical column name: ProductType
- Property Name: productType
- Reference: List
- Default value: I
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:
- I (Item)
- S (Service)
- R (Resource)
- E (Expense type)
- O (Online)
Production
- Physical column name: Production
- Property Name: production
- Reference: YesNo
- Default value: N
Purchase
- Physical column name: IsPurchased
- Property Name: purchase
- Reference: YesNo
- Default value: Y
Quantity Type
- Physical column name: Qtytype
- Property Name: quantityType
- Reference: YesNo
Quantity_Rule
- Physical column name: Quantity_Rule
- Property Name: quantityRule
- Reference: List
List values: M_Services Quantity Rule
The allowed values for this list are:
- PP (As per product)
- UQ (Unique quantity)
Relateprodcattaxtoservice
- Physical column name: Relateprodcattaxtoservice
- Property Name: relateprodcattaxtoservice
- Reference: Button
- Default value: N
Relateprodcattoservice
- Physical column name: Relateprodcattoservice
- Property Name: relateprodcattoservice
- Reference: Button
Relateprodtoservice
- Physical column name: Relateprodtoservice
- Property Name: relateprodtoservice
- Reference: Button
Resource
- Physical column name: S_Resource_ID
- Property Name: resource
- Reference: TableDir
Foreign key column to S_Resource table, (column: S_Resource_ID)
Returnable
- Physical column name: Returnable
- Property Name: returnable
- Reference: YesNo
- Default value: Y
Revenue Plan Type
- Physical column name: Revplantype
- Property Name: revenuePlanType
- Reference: List
List values: Accruals and Deferrals Plan Types
The allowed values for this list are:
- M (Monthly)
SKU
- Physical column name: SKU
- Property Name: sKU
- Reference: String
Safety Stock
- Physical column name: Stockmin
- Property Name: safetyStock
- Reference: Number
Sale
- Physical column name: IsSold
- Property Name: sale
- Reference: YesNo
- Default value: Y
Sales Representative
- Physical column name: SalesRep_ID
- Property Name: salesRepresentative
- Reference: Table
Foreign key column to AD_User table, (column: AD_User_ID)
Search Key
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Shelf Depth
- Physical column name: ShelfDepth
- Property Name: shelfDepth
- Reference: Number
Shelf Height
- Physical column name: ShelfHeight
- Property Name: shelfHeight
- Reference: Number
Shelf Width
- Physical column name: ShelfWidth
- Property Name: shelfWidth
- Reference: Number
Standard Quantity
- Physical column name: Qtystd
- Property Name: standardQuantity
- Reference: Quantity
Stocked
- Physical column name: IsStocked
- Property Name: stocked
- Reference: YesNo
- Default value: Y
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: Search
Foreign key column to M_Locator table, (column: M_Locator_ID)
Summary Level
- Physical column name: IsSummary
- Property Name: summaryLevel
- Reference: YesNo
- Default value: N
Tax Category
- Physical column name: C_TaxCategory_ID
- Property Name: taxCategory
- Reference: TableDir
Foreign key column to C_TaxCategory table, (column: C_TaxCategory_ID)
UOM
- Physical column name: C_UOM_ID
- Property Name: uOM
- Reference: TableDir
Foreign key column to C_UOM table, (column: C_UOM_ID)
UOM for Weight
- Physical column name: C_Uom_Weight_ID
- Property Name: uOMForWeight
- Reference: Table
Foreign key column to C_UOM table, (column: C_UOM_ID)
UPC/EAN
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
Unique_Per_Document
- Physical column name: Unique_Per_Document
- Property Name: uniquePerDocument
- Reference: YesNo
- Default value: N
Units Per Pallet
- Physical column name: UnitsPerPallet
- Property Name: unitsPerPallet
- Reference: Integer
UpdateInvariants
- Physical column name: Updateinvariants
- Property Name: updateInvariants
- Reference: Button
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Use Attribute Set Value As
- Physical column name: Attrsetvaluetype
- Property Name: useAttributeSetValueAs
- Reference: List
List values: Use Attribute Set Value As
The allowed values for this list are:
- 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.
- 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.
Version No.
- Physical column name: VersionNo
- Property Name: versionNo
- Reference: String
Volume
- Physical column name: Volume
- Property Name: volume
- Reference: Number
- Default value: 0
Weight
- Physical column name: Weight
- Property Name: weight
- Reference: Number
- Default value: 0
linkedToProduct
- Physical column name: Islinkedtoproduct
- Property Name: linkedToProduct
- Reference: YesNo
- Default value: N
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- M_PRODUC_ISGENERID_IDX Not Unique. Columns:
- ISGENERIC
- M_PRODUCT_BPARTNER Not Unique. Columns:
- C_BPARTNER_ID
- M_PRODUCT_BRAND_ID Not Unique. Columns:
- M_BRAND_ID
- M_PRODUCT_GEN_PROD Not Unique. Columns:
- GENERIC_PRODUCT_ID
- M_PRODUCT_NAME_ID Not Unique. Columns:
- NAME
- M_PRODUCT_ID
- M_PRODUCT_PRODUCTCATEGORY Not Unique. Columns:
- M_PRODUCT_CATEGORY_ID
- M_PRODUCT_SALESREP Not Unique. Columns:
- SALESREP_ID
- M_PRODUCT_UPC_ID Not Unique. Columns:
- UPC
- M_PRODUCT_ID
- M_PRODUCT_VALUE_ID Not Unique. Columns:
- VALUE
- M_PRODUCT_ID
Check Constraints
These are the check constraints for this table:
- M_PROD_LINKEDTOPROD_QRUL_CHECK: ISLINKEDTOPRODUCT = 'Y' AND QUANTITY_RULE IS NOT NULL OR ISLINKEDTOPRODUCT = 'N'
- M_PROD_LINKEDTOPROD_SEL_CHECK: ISLINKEDTOPRODUCT = 'Y' AND (PROD_CAT_SELECTION IS NOT NULL OR PRODUCT_SELECTION IS NOT NULL) OR ISLINKEDTOPRODUCT = 'N'
- M_PROD_LINKEDTOPRODUCT_CHECK: ISLINKEDTOPRODUCT IN ('Y', 'N')
- 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_ISEXPDEFCOMPLETE_CHK: ISDEFERREDEXPENSE = 'N' OR ISDEFERREDEXPENSE = 'Y' AND EXPPLANTYPE IS NOT NULL AND DEFAULTPERIOD_EXP IS NOT NULL AND PERIODNUMBER_EXP IS NOT NULL
- M_PRODUCT_ISEXPDEFERRED_CHK: ISDEFERREDEXPENSE IN ('Y', 'N')
- M_PRODUCT_ISGENERIC: ISGENERIC IN ('Y', 'N')
- M_PRODUCT_ISINVOICEPRINTDE_CHK: ISINVOICEPRINTDETAILS IN ('Y', 'N')
- M_PRODUCT_ISMODIFYTAX_CHK: ISMODIFYTAX IN ('Y', 'N')
- M_PRODUCT_ISPICKLISTPRINTD_CHK: ISPICKLISTPRINTDETAILS IN ('Y', 'N')
- M_PRODUCT_ISPURCHASED_CHECK: ISPURCHASED IN ('Y', 'N')
- M_PRODUCT_ISQTYVAR_CHECK: ISQUANTITYVARIABLE IN ('Y', 'N')
- M_PRODUCT_ISREVDEFCOMPLETE_CHK: ISDEFERREDREVENUE = 'N' OR ISDEFERREDREVENUE = 'Y' AND REVPLANTYPE IS NOT NULL AND DEFAULTPERIOD IS NOT NULL AND PERIODNUMBER IS NOT NULL
- M_PRODUCT_ISREVDEFERRED_CHK: ISDEFERREDREVENUE 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')
- M_PRODUCT_PERIODNUMBER_CHK: ISDEFERREDREVENUE = 'Y' AND PERIODNUMBER > 0 OR ISDEFERREDREVENUE = 'N'
- M_PRODUCT_PERIODNUMEXP_CHK: ISDEFERREDEXPENSE = 'Y' AND PERIODNUMBER_EXP > 0 OR ISDEFERREDEXPENSE = 'N'
- M_PRODUCT_PRICERULEBASED_CHECK: ISPRICERULEBASED IN ('Y', 'N')
- M_PRODUCT_PRINT_DESCRIP_CHECK: PRINT_DESCRIPTION IN ('Y', 'N')
- M_PRODUCT_RETURNABLE_CHECK: RETURNABLE IN ('Y', 'N')
- M_PRODUCT_UN_PERDOCUMENT_CHECK: UNIQUE_PER_DOCUMENT IN ('Y', 'N')
![]() | Back to org.openbravo.model.common.plm |