ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.plm/M Product PO
M_Product_PO
- Name:M_Product_PO
- Classname:ApprovedVendor
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. |
DeliveryTime_Actual | Yes | DECIMAL (10,0) | The Actual Delivery Time indicates the number of days elapsed between placing an order and the delivery of the order |
C_BPartner_ID | No | VARCHAR (32) | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. |
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. |
C_Currency_ID | Yes | VARCHAR (32) | Indicates the currency to be used when processing this document. |
IsCurrentVendor | No | CHAR (1) | The Current Vendor indicates if prices are used and Product is reordered from this vendor |
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 |
CostPerOrder | Yes | DECIMAL | The Cost Per Order indicates the fixed charge levied when an order for this product is placed. |
PriceLastInv | Yes | DECIMAL | The Last Invoice Price indicates the last price paid (per the invoice) for this product. |
PriceLastPO | Yes | DECIMAL | The Last PO Price indicates the last price paid (per the purchase order) for this product. |
PriceList | Yes | DECIMAL | The Net List Price is the official price stated by the selected pricelist and the currency of the document. |
M_Product_PO_ID | No | VARCHAR (32) | |
Manufacturer | Yes | NVARCHAR (30) | Manufacturer |
Order_Min | Yes | DECIMAL | The Minimum Order Quantity indicates the smallest quantity of this product which can be ordered. |
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. |
PriceEffective | Yes | TIMESTAMP (7) | The Price Effective indicates the date this price is for. This allows you to enter future prices for products which will become effective when appropriate. |
M_Product_ID | No | VARCHAR (32) | Identifies an item which is either purchased or sold in this organization. |
PricePO | Yes | DECIMAL | The PO Price indicates the price for a product per the purchase order. |
DeliveryTime_Promised | Yes | DECIMAL (10,0) | Indicates the number of days between placing an order and the actual delivery as promised by the vendor. |
QualityRating | Yes | DECIMAL | The Quality Rating indicates how a vendor is rated (higher number = higher quality) |
Qtytype | Yes | VARCHAR (60) | Quantity Type |
Order_Pack | Yes | DECIMAL | The Order Pack Quantity indicates the number of units in each pack of this product. |
RoyaltyAmt | Yes | DECIMAL | (Included) Amount for copyright, etc. |
Qtystd | Yes | DECIMAL | Quantity Standard |
C_UOM_ID | Yes | VARCHAR (32) | The UOM defines a unique non monetary unit of measure |
UPC | Yes | NVARCHAR (20) | 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) |
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. |
VendorCategory | Yes | NVARCHAR (30) | The Vendor Category identifies the category used by the vendor for this product. |
VendorProductNo | Yes | NVARCHAR (40) | The Vendor Product Number identifies the number used by the vendor for this product. |
Columns
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Actual Delivery Days
- Physical column name: DeliveryTime_Actual
- Property Name: actualDeliveryDays
- Reference: Integer
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- 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 C_BPartner table, (column: C_BPartner_ID)
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)
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
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
Current Vendor
- Physical column name: IsCurrentVendor
- Property Name: currentVendor
- Reference: YesNo
- Default value: Y
Discontinued
- Physical column name: Discontinued
- Property Name: discontinued
- Reference: YesNo
- Default value: N
Discontinued by
- Physical column name: DiscontinuedBy
- Property Name: discontinuedBy
- Reference: Date
Fixed Cost per Order
- Physical column name: CostPerOrder
- Property Name: fixedCostPerOrder
- Reference: Amount
- Default value: 0
Last Invoice Price
- Physical column name: PriceLastInv
- Property Name: lastInvoicePrice
- Reference: Price
- Default value: 0
Last Purchase Price
- Physical column name: PriceLastPO
- Property Name: lastPurchasePrice
- Reference: Price
- Default value: 0
List Price
- Physical column name: PriceList
- Property Name: listPrice
- Reference: Price
- Default value: 0
M_Product_PO_ID
- Physical column name: M_Product_PO_ID
- Property Name: id
- Reference: ID
Manufacturer
- Physical column name: Manufacturer
- Property Name: manufacturer
- Reference: String
Minimum Order Qty.
- Physical column name: Order_Min
- Property Name: minimumOrderQty
- Reference: Quantity
- Default value: 0
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Price Effective From
- Physical column name: PriceEffective
- Property Name: priceEffectiveFrom
- Reference: Date
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)
Purchase Order Price
- Physical column name: PricePO
- Property Name: purchaseOrderPrice
- Reference: Price
- Default value: 0
Purchasing Lead Time
- Physical column name: DeliveryTime_Promised
- Property Name: purchasingLeadTime
- Reference: Integer
Quality Rating
- Physical column name: QualityRating
- Property Name: qualityRating
- Reference: Integer
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)
Quantity per Package
- Physical column name: Order_Pack
- Property Name: quantityPerPackage
- Reference: Quantity
- Default value: 0
Royalty Amount
- Physical column name: RoyaltyAmt
- Property Name: royaltyAmount
- Reference: Amount
- Default value: 0
Standard Quantity
- Physical column name: Qtystd
- Property Name: standardQuantity
- Reference: Quantity
UOM
- Physical column name: C_UOM_ID
- Property Name: uOM
- Reference: TableDir
Foreign key column to C_UOM table, (column: C_UOM_ID)
UPC/EAN
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
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)
Vendor Category
- Physical column name: VendorCategory
- Property Name: vendorCategory
- Reference: String
Vendor Product No.
- Physical column name: VendorProductNo
- Property Name: vendorProductNo
- Reference: String
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_PROD_PO_BPARTNER_IDX Not Unique. Columns:
- C_BPARTNER_ID
- M_PROD_PO_PRODUCT_IDX Not Unique. Columns:
- M_PRODUCT_ID
Check Constraints
These are the check constraints for this table:
- M_PRODUCT_PO_DISCONTINUED_CHK: DISCONTINUED IN ('Y', 'N')
- M_PRODUCT_PO_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- M_PRODUCT_PO_ISCURRENTVEND_CHK: ISCURRENTVENDOR IN ('Y', 'N')
![]() | Back to org.openbravo.model.common.plm |