ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.plm/M Product Org
M_Product_Org
- Name:M_Product_Org
- Classname:ProductOrg
This table contains the following columns:
Name | Nullable | Data Type | Description
|
Abc | Yes | VARCHAR (60) | ABC classification according to a Pareto distribution |
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. |
Capacity | Yes | DECIMAL | Capacity per day |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
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. |
M_Product_Org_ID | No | VARCHAR (32) | Details for a product in different organizations. |
Qtymax | Yes | DECIMAL | Maximum Quantity |
Maximumqty | Yes | DECIMAL | Max Qty of the product in stock, not reserved. When running purchasing plan to suggest needed purchase orders to fullfill the pending sales orders and safety stock, it will buy enough to leave as well the stock in this Max Qty. |
Qtymin | Yes | DECIMAL | Minumun Quantity. |
Delaymin | Yes | DECIMAL | Minimum number of days to complete the transaction |
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. |
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. |
M_Product_Po_ID | Yes | VARCHAR (32) | Identifies a product preferred vendor. |
M_Product_ID | No | VARCHAR (32) | Identifies an item which is either purchased or sold in this organization. |
Qtytype | Yes | VARCHAR (60) | Quantity Type |
Stockmin | Yes | DECIMAL | Safety Stock |
Qtystd | Yes | DECIMAL | Quantity Standard |
M_Locator_ID | Yes | VARCHAR (32) | The Locator ID indicates where in a Warehouse a product is located. |
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. |
Columns
Abc
- Physical column name: Abc
- Property Name: abc
- Reference: List
List values: M_Product_Org - ABC
The allowed values for this list are:
- A (A)
- B (B)
- C (C)
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Capacity
- Physical column name: Capacity
- Property Name: capacity
- Reference: Number
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
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
M_Product_Org_ID
- Physical column name: M_Product_Org_ID
- Property Name: id
- Reference: ID
Max. Quantity
- Physical column name: Qtymax
- Property Name: maxQuantity
- Reference: Quantity
Maximumqty
- Physical column name: Maximumqty
- Property Name: maximumqty
- Reference: Number
Min. Quantity
- Physical column name: Qtymin
- Property Name: minQuantity
- Reference: Quantity
Minimum Lead Time
- Physical column name: Delaymin
- Property Name: minimumLeadTime
- Reference: Integer
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- This column is part of the table's identifier
Foreign key column to AD_Org table, (column: AD_Org_ID)
It has a validation "AD_Org show product's child organizations", with the following code
AD_ISORGINCLUDED(ad_org.ad_org_id, @Product_Org@, ad_org.ad_client_id)<>-1 AND IsReady = 'Y'
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)
Preferred Vendor
- Physical column name: M_Product_Po_ID
- Property Name: preferredVendor
- Reference: TableDir
Foreign key column to M_Product_PO table, (column: M_Product_PO_ID)
It has a validation "M_Product_PO of the m_product_id", with the following code
m_product_po.discontinued = 'N' and m_product_po.m_product_id = @M_Product_ID@
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
- This column is part of the table's identifier
- This column is a child for a business object (is Parent)
Foreign key column to M_Product table, (column: M_Product_ID)
Quantity Type
- Physical column name: Qtytype
- Property Name: quantityType
- Reference: List
List values: Quantity type
The allowed values for this list are:
- E (Exact)
- M (Multiple)
Safety Stock
- Physical column name: Stockmin
- Property Name: safetyStock
- Reference: Number
Standard Quantity
- Physical column name: Qtystd
- Property Name: standardQuantity
- Reference: Quantity
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: Search
Foreign key column to M_Locator table, (column: M_Locator_ID)
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)
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_PRODUCT_ORG_BIN Not Unique. Columns:
- M_LOCATOR_ID
- M_PRODUCT_ORG_PRODUCT Not Unique. Columns:
- M_PRODUCT_ID
Check Constraints
These are the check constraints for this table:
- M_PRODUCT_ORG_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
![]() | Back to org.openbravo.model.common.plm |