ERP 2.50:Developers Guide/Reference/Entity Model/ApprovedVendor
ApprovedVendor
The Purchasing defines the pricing and rules ( pack quantity, UPC, minimum order quantity) for each product. The Product Details allows you to display and maintain all products for a selected Vendor.
To the database table (M_Product_PO) of this entity.
Properties
Note:
- Properties marked with a * are part of the Id of the Entity.
- Properties marked with a # are part of the Identifier of the Entity.
Property | Column | Constraints | Type | Description |
id* | M_Product_PO_ID | Mandatory Max Length: 32 | java.lang.String | |
product# | M_Product_ID | Mandatory | Product | Identifies an item which is either purchased or sold in this organization. |
businessPartner# | C_BPartner_ID | Mandatory | BusinessPartner | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. |
client | AD_Client_ID | Mandatory | ADClient | A Client is a company or a legal entity. You cannot share data between Clients. |
organization | AD_Org_ID | Mandatory | Organization | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
active | IsActive | Mandatory | java.lang.Boolean | 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. |
creationDate | Created | Mandatory | java.util.Date | The Created field indicates the date that this record was created. |
createdBy | CreatedBy | Mandatory | ADUser | The Created By field indicates the user who created this record. |
updated | Updated | Mandatory | java.util.Date | The Updated field indicates the date that this record was updated. |
updatedBy | UpdatedBy | Mandatory | ADUser | The Updated By field indicates the user who updated this record. |
currentVendor | IsCurrentVendor | Mandatory | java.lang.Boolean | The Current Vendor indicates if prices are used and Product is reordered from this vendor |
uOM | C_UOM_ID | UOM | The UOM defines a unique non monetary unit of measure | |
currency | C_Currency_ID | Currency | Indicates the currency to be used when processing this document. | |
listPrice | PriceList | java.math.BigDecimal | The List Price is the official price stated by the selected pricelist and the currency of the document. | |
purchaseOrderPrice | PricePO | java.math.BigDecimal | The PO Price indicates the price for a product per the purchase order. | |
priceEffectiveFrom | PriceEffective | java.util.Date | 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. | |
lastPurchasePrice | PriceLastPO | java.math.BigDecimal | The Last PO Price indicates the last price paid (per the purchase order) for this product. | |
lastInvoicePrice | PriceLastInv | java.math.BigDecimal | The Last Invoice Price indicates the last price paid (per the invoice) for this product. | |
vendorProductNo | VendorProductNo | Mandatory Max Length: 40 | java.lang.String | The Vendor Product Number identifies the number used by the vendor for this product. |
uPCEAN | UPC | Max Length: 20 | java.lang.String | 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) |
vendorCategory | VendorCategory | Max Length: 30 | java.lang.String | The Vendor Category identifies the category used by the vendor for this product. |
discontinued | Discontinued | java.lang.Boolean | The Discontinued check box indicates a product that has been discontinued. | |
discontinuedBy | DiscontinuedBy | java.util.Date | The Discontinued By indicates the individual who discontinued this product | |
minimumOrderQty | Order_Min | java.math.BigDecimal | The Minimum Order Quantity indicates the smallest quantity of this product which can be ordered. | |
quantityPerPackage | Order_Pack | java.math.BigDecimal | The Order Pack Quantity indicates the number of units in each pack of this product. | |
fixedCostPerOrder | CostPerOrder | java.math.BigDecimal | The Cost Per Order indicates the fixed charge levied when an order for this product is placed. | |
purchasingLeadTime | DeliveryTime_Promised | java.lang.Long | Indicates the number of days between placing an order and the actual delivery as promised by the vendor. | |
actualDeliveryDays | DeliveryTime_Actual | java.lang.Long | The Actual Delivery Time indicates the number of days elapsed between placing an order and the delivery of the order | |
qualityRating | QualityRating | java.lang.Long | The Quality Rating indicates how a vendor is rated (higher number = higher quality) | |
royaltyAmount | RoyaltyAmt | java.math.BigDecimal | (Included) Amount for copyright, etc. | |
manufacturer | Manufacturer | Max Length: 30 | java.lang.String | Manufacturer |
capacity | Capacity | java.math.BigDecimal | Capacity per day | |
standardQuantity | Qtystd | java.math.BigDecimal | Quantity Standard | |
quantityType | Qtytype | Max Length: 60 | java.lang.String | Quantity Type |
Java Entity Class
/* ************************************************************************* * The contents of this file are subject to the Openbravo Public License * Version 1.1 (the "License"), being the Mozilla Public License * Version 1.1 with a permitted attribution clause; you may not use this * file except in compliance with the License. You may obtain a copy of * the License at http://www.openbravo.com/legal/license.html * Software distributed under the License is distributed on an "AS IS" * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the * License for the specific language governing rights and limitations * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU * All portions are Copyright (C) 2008-2010 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ */ package org.openbravo.model.common.plm; import org.openbravo.base.structure.ActiveEnabled; import org.openbravo.base.structure.BaseOBObject; import org.openbravo.base.structure.ClientEnabled; import org.openbravo.base.structure.OrganizationEnabled; import org.openbravo.base.structure.Traceable; import org.openbravo.model.ad.access.User; import org.openbravo.model.ad.system.Client; import org.openbravo.model.common.businesspartner.BusinessPartner; import org.openbravo.model.common.currency.Currency; import org.openbravo.model.common.enterprise.Organization; import java.lang.Boolean; import java.lang.Long; import java.lang.String; import java.math.BigDecimal; import java.util.Date; /** * Entity class for entity ApprovedVendor (stored in table M_Product_PO). * * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class ApprovedVendor extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "M_Product_PO"; public static final String ApprovedVendor = "ApprovedVendor"; public static final String PROPERTY_ID = "id"; public static final String PROPERTY_PRODUCT = "product"; public static final String PROPERTY_BUSINESSPARTNER = "businessPartner"; public static final String PROPERTY_CLIENT = "client"; public static final String PROPERTY_ORGANIZATION = "organization"; public static final String PROPERTY_ACTIVE = "active"; public static final String PROPERTY_CREATIONDATE = "creationDate"; public static final String PROPERTY_CREATEDBY = "createdBy"; public static final String PROPERTY_UPDATED = "updated"; public static final String PROPERTY_UPDATEDBY = "updatedBy"; public static final String PROPERTY_CURRENTVENDOR = "currentVendor"; public static final String PROPERTY_UOM = "uOM"; public static final String PROPERTY_CURRENCY = "currency"; public static final String PROPERTY_LISTPRICE = "listPrice"; public static final String PROPERTY_PURCHASEORDERPRICE = "purchaseOrderPrice"; public static final String PROPERTY_PRICEEFFECTIVEFROM = "priceEffectiveFrom"; public static final String PROPERTY_LASTPURCHASEPRICE = "lastPurchasePrice"; public static final String PROPERTY_LASTINVOICEPRICE = "lastInvoicePrice"; public static final String PROPERTY_VENDORPRODUCTNO = "vendorProductNo"; public static final String PROPERTY_UPCEAN = "uPCEAN"; public static final String PROPERTY_VENDORCATEGORY = "vendorCategory"; public static final String PROPERTY_DISCONTINUED = "discontinued"; public static final String PROPERTY_DISCONTINUEDBY = "discontinuedBy"; public static final String PROPERTY_MINIMUMORDERQTY = "minimumOrderQty"; public static final String PROPERTY_QUANTITYPERPACKAGE = "quantityPerPackage"; public static final String PROPERTY_FIXEDCOSTPERORDER = "fixedCostPerOrder"; public static final String PROPERTY_PURCHASINGLEADTIME = "purchasingLeadTime"; public static final String PROPERTY_ACTUALDELIVERYDAYS = "actualDeliveryDays"; public static final String PROPERTY_QUALITYRATING = "qualityRating"; public static final String PROPERTY_ROYALTYAMOUNT = "royaltyAmount"; public static final String PROPERTY_MANUFACTURER = "manufacturer"; public static final String PROPERTY_CAPACITY = "capacity"; public static final String PROPERTY_STANDARDQUANTITY = "standardQuantity"; public static final String PROPERTY_QUANTITYTYPE = "quantityType"; public ApprovedVendor() { setDefaultValue(PROPERTY_ACTIVE, true); setDefaultValue(PROPERTY_CURRENTVENDOR, true); setDefaultValue(PROPERTY_DISCONTINUED, false); } @Override public String getEntityName() { return ApprovedVendor; } public String getId() { return (String) get(PROPERTY_ID); } public void setId(String id) { set(PROPERTY_ID, id); } public Product getProduct() { return (Product) get(PROPERTY_PRODUCT); } public void setProduct(Product product) { set(PROPERTY_PRODUCT, product); } public BusinessPartner getBusinessPartner() { return (BusinessPartner) get(PROPERTY_BUSINESSPARTNER); } public void setBusinessPartner(BusinessPartner businessPartner) { set(PROPERTY_BUSINESSPARTNER, businessPartner); } public Client getClient() { return (Client) get(PROPERTY_CLIENT); } public void setClient(Client client) { set(PROPERTY_CLIENT, client); } public Organization getOrganization() { return (Organization) get(PROPERTY_ORGANIZATION); } public void setOrganization(Organization organization) { set(PROPERTY_ORGANIZATION, organization); } public Boolean isActive() { return (Boolean) get(PROPERTY_ACTIVE); } public void setActive(Boolean active) { set(PROPERTY_ACTIVE, active); } public Date getCreationDate() { return (Date) get(PROPERTY_CREATIONDATE); } public void setCreationDate(Date creationDate) { set(PROPERTY_CREATIONDATE, creationDate); } public User getCreatedBy() { return (User) get(PROPERTY_CREATEDBY); } public void setCreatedBy(User createdBy) { set(PROPERTY_CREATEDBY, createdBy); } public Date getUpdated() { return (Date) get(PROPERTY_UPDATED); } public void setUpdated(Date updated) { set(PROPERTY_UPDATED, updated); } public User getUpdatedBy() { return (User) get(PROPERTY_UPDATEDBY); } public void setUpdatedBy(User updatedBy) { set(PROPERTY_UPDATEDBY, updatedBy); } public Boolean isCurrentVendor() { return (Boolean) get(PROPERTY_CURRENTVENDOR); } public void setCurrentVendor(Boolean currentVendor) { set(PROPERTY_CURRENTVENDOR, currentVendor); } public org.openbravo.model.common.uom.UOM getUOM() { return (org.openbravo.model.common.uom.UOM) get(PROPERTY_UOM); } public void setUOM(org.openbravo.model.common.uom.UOM uOM) { set(PROPERTY_UOM, uOM); } public Currency getCurrency() { return (Currency) get(PROPERTY_CURRENCY); } public void setCurrency(Currency currency) { set(PROPERTY_CURRENCY, currency); } public BigDecimal getListPrice() { return (BigDecimal) get(PROPERTY_LISTPRICE); } public void setListPrice(BigDecimal listPrice) { set(PROPERTY_LISTPRICE, listPrice); } public BigDecimal getPurchaseOrderPrice() { return (BigDecimal) get(PROPERTY_PURCHASEORDERPRICE); } public void setPurchaseOrderPrice(BigDecimal purchaseOrderPrice) { set(PROPERTY_PURCHASEORDERPRICE, purchaseOrderPrice); } public Date getPriceEffectiveFrom() { return (Date) get(PROPERTY_PRICEEFFECTIVEFROM); } public void setPriceEffectiveFrom(Date priceEffectiveFrom) { set(PROPERTY_PRICEEFFECTIVEFROM, priceEffectiveFrom); } public BigDecimal getLastPurchasePrice() { return (BigDecimal) get(PROPERTY_LASTPURCHASEPRICE); } public void setLastPurchasePrice(BigDecimal lastPurchasePrice) { set(PROPERTY_LASTPURCHASEPRICE, lastPurchasePrice); } public BigDecimal getLastInvoicePrice() { return (BigDecimal) get(PROPERTY_LASTINVOICEPRICE); } public void setLastInvoicePrice(BigDecimal lastInvoicePrice) { set(PROPERTY_LASTINVOICEPRICE, lastInvoicePrice); } public String getVendorProductNo() { return (String) get(PROPERTY_VENDORPRODUCTNO); } public void setVendorProductNo(String vendorProductNo) { set(PROPERTY_VENDORPRODUCTNO, vendorProductNo); } public String getUPCEAN() { return (String) get(PROPERTY_UPCEAN); } public void setUPCEAN(String uPCEAN) { set(PROPERTY_UPCEAN, uPCEAN); } public String getVendorCategory() { return (String) get(PROPERTY_VENDORCATEGORY); } public void setVendorCategory(String vendorCategory) { set(PROPERTY_VENDORCATEGORY, vendorCategory); } public Boolean isDiscontinued() { return (Boolean) get(PROPERTY_DISCONTINUED); } public void setDiscontinued(Boolean discontinued) { set(PROPERTY_DISCONTINUED, discontinued); } public Date getDiscontinuedBy() { return (Date) get(PROPERTY_DISCONTINUEDBY); } public void setDiscontinuedBy(Date discontinuedBy) { set(PROPERTY_DISCONTINUEDBY, discontinuedBy); } public BigDecimal getMinimumOrderQty() { return (BigDecimal) get(PROPERTY_MINIMUMORDERQTY); } public void setMinimumOrderQty(BigDecimal minimumOrderQty) { set(PROPERTY_MINIMUMORDERQTY, minimumOrderQty); } public BigDecimal getQuantityPerPackage() { return (BigDecimal) get(PROPERTY_QUANTITYPERPACKAGE); } public void setQuantityPerPackage(BigDecimal quantityPerPackage) { set(PROPERTY_QUANTITYPERPACKAGE, quantityPerPackage); } public BigDecimal getFixedCostPerOrder() { return (BigDecimal) get(PROPERTY_FIXEDCOSTPERORDER); } public void setFixedCostPerOrder(BigDecimal fixedCostPerOrder) { set(PROPERTY_FIXEDCOSTPERORDER, fixedCostPerOrder); } public Long getPurchasingLeadTime() { return (Long) get(PROPERTY_PURCHASINGLEADTIME); } public void setPurchasingLeadTime(Long purchasingLeadTime) { set(PROPERTY_PURCHASINGLEADTIME, purchasingLeadTime); } public Long getActualDeliveryDays() { return (Long) get(PROPERTY_ACTUALDELIVERYDAYS); } public void setActualDeliveryDays(Long actualDeliveryDays) { set(PROPERTY_ACTUALDELIVERYDAYS, actualDeliveryDays); } public Long getQualityRating() { return (Long) get(PROPERTY_QUALITYRATING); } public void setQualityRating(Long qualityRating) { set(PROPERTY_QUALITYRATING, qualityRating); } public BigDecimal getRoyaltyAmount() { return (BigDecimal) get(PROPERTY_ROYALTYAMOUNT); } public void setRoyaltyAmount(BigDecimal royaltyAmount) { set(PROPERTY_ROYALTYAMOUNT, royaltyAmount); } public String getManufacturer() { return (String) get(PROPERTY_MANUFACTURER); } public void setManufacturer(String manufacturer) { set(PROPERTY_MANUFACTURER, manufacturer); } public BigDecimal getCapacity() { return (BigDecimal) get(PROPERTY_CAPACITY); } public void setCapacity(BigDecimal capacity) { set(PROPERTY_CAPACITY, capacity); } public BigDecimal getStandardQuantity() { return (BigDecimal) get(PROPERTY_STANDARDQUANTITY); } public void setStandardQuantity(BigDecimal standardQuantity) { set(PROPERTY_STANDARDQUANTITY, standardQuantity); } public String getQuantityType() { return (String) get(PROPERTY_QUANTITYTYPE); } public void setQuantityType(String quantityType) { set(PROPERTY_QUANTITYTYPE, quantityType); } }