ERP/2.50/Developers Guide/Reference/Entity Model/PricingPriceListSchemeLine

PricingPriceListSchemeLine

Pricelists are created based on Product Purchase and Category Discounts. The parameters listed here allow to copy and calculate pricelists.
The calculation:

Copy and convert price from referenced price list

result plus Surcharge Amount<L To the database table (M_DiscountSchemaLine) of this entity. Back to the entity model.

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_DiscountSchemaLine_ID	Mandatory Max Length: 32	java.lang.String	For the Pricelist Discount Type, you enter how the list, standard and limit price is calculated.
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.
priceListSchema	M_DiscountSchema_ID	Mandatory	PricingPriceListSchema	After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price.
sequenceNumber^#	SeqNo	Mandatory	java.lang.Long	The Sequence indicates the order of records
productCategory	M_Product_Category_ID		ProductCategory	Identifies the category which this product belongs to. Product categories are used for pricing.
businessPartner	C_BPartner_ID		BusinessPartner	A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
product	M_Product_ID		Product	Identifies an item which is either purchased or sold in this organization.
conversionRateType	ConversionRateType	Mandatory Max Length: 60	java.lang.String	The Conversion Rate Type indicates the type of conversion rate. This allows you to enter multiple rates for the same currency pair. For example, one rate may be used for Spot conversions and a different rate for Revaluations.
conversionDate	ConversionDate	Mandatory	java.util.Date	The Conversion Date identifies the date used for currency conversion. The conversion rate chosen must include this date in it's date range
baseListPrice	List_Base	Mandatory Max Length: 60	java.lang.String	The List Price Base indicates the price to use as the basis for the calculation of a new price list.
surchargeListPriceAmount	List_AddAmt	Mandatory	java.math.BigDecimal	The List Price Surcharge Amount indicates the amount to be added to the price prior to multiplication.
listPriceDiscount	List_Discount	Mandatory	java.math.BigDecimal	The List Price Discount Percentage indicates the percentage discount which will be subtracted from the base price. A negative amount indicates the percentage which will be added to the base price.
listPriceRounding	List_Rounding	Mandatory Max Length: 60	java.lang.String	The List Price Rounding indicates how the final list price will be rounded.
minListPriceMargin	List_MinAmt	Mandatory	java.math.BigDecimal	The List Price Min Margin indicates the minimum margin for a product. The margin is calculated by subtracting the original list price from the newly calculated price. If this field contains 0.00 then it is ignored.
maxListPriceMargin	List_MaxAmt	Mandatory	java.math.BigDecimal	The List Price Max Margin indicates the maximum margin for a product. The margin is calculated by subtracting the original list price from the newly calculated price. If this field contains 0.00 then it is ignored.
fixedListPrice	List_Fixed		java.math.BigDecimal	Fixes List Price (not calculated)
standardBasePrice	Std_Base	Mandatory Max Length: 60	java.lang.String	The Standard Price Base indicates the price to use as the basis for the calculation of a new price standard.
surchargeStandardPriceAmount	Std_AddAmt	Mandatory	java.math.BigDecimal	The Standard Price Surcharge Amount indicates the amount to be added to the price prior to multiplication.
standardPriceDiscount	Std_Discount	Mandatory	java.math.BigDecimal	The Standard Price Discount Percentage indicates the percentage discount which will be subtracted from the base price. A negative amount indicates the percentage which will be added to the base price.
standardPriceRounding	Std_Rounding	Mandatory Max Length: 60	java.lang.String	The Standard Price Rounding indicates how the final Standard price will be rounded.
minStandardPriceMargin	Std_MinAmt	Mandatory	java.math.BigDecimal	The Standard Price Min Margin indicates the minimum margin for a product. The margin is calculated by subtracting the original Standard price from the newly calculated price. If this field contains 0.00 then it is ignored.
maxStandardMargin	Std_MaxAmt	Mandatory	java.math.BigDecimal	The Standard Price Max Margin indicates the maximum margin for a product. The margin is calculated by subtracting the original Standard price from the newly calculated price. If this field contains 0.00 then it is ignored.
fixedStandardPrice	Std_Fixed		java.math.BigDecimal	Fixed Standard Price (not calculated)
baseLimitPrice	Limit_Base	Mandatory Max Length: 60	java.lang.String	Identifies the price to be used as the base for calculating a new price list.
surchargePriceLimitAmount	Limit_AddAmt	Mandatory	java.math.BigDecimal	Indicates the amount to be added to the Limit price prior to multiplication.
priceLimitDiscount	Limit_Discount	Mandatory	java.math.BigDecimal	Indicates the discount in percent to be subtracted from base, if negative it will be added to base price
priceLimitRounding	Limit_Rounding	Mandatory Max Length: 60	java.lang.String	A drop down list box which indicates the rounding (if any) will apply to the final prices in this price list.
limitPriceMinMargin	Limit_MinAmt	Mandatory	java.math.BigDecimal	Indicates the minimum margin for a product. The margin is calculated by subtracting the original limit price from the newly calculated price. If this field contains 0.00 then it is ignored.
maxPriceLimitMargin	Limit_MaxAmt	Mandatory	java.math.BigDecimal	Indicates the maximum margin for a product. The margin is calculated by subtracting the original limit price from the newly calculated price. If this field contains 0.00 then it is ignored.
fixedLimitPrice	Limit_Fixed		java.math.BigDecimal	Fixed Limit Price (not calculated)

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.pricing.pricelist;
 
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.enterprise.Organization;
import org.openbravo.model.common.plm.Product;
import org.openbravo.model.common.plm.ProductCategory;
 
import java.lang.Boolean;
import java.lang.Long;
import java.lang.String;
 
import java.math.BigDecimal;
 
import java.util.Date;
 
/**
 * Entity class for entity PricingPriceListSchemeLine (stored in table M_DiscountSchemaLine).
 *
 * NOTE: This class should not be instantiated directly. To instantiate this
 * class the {@link org.openbravo.base.provider.OBProvider} should be used.
 */
public class PriceListSchemeLine extends BaseOBObject implements Traceable,
    ClientEnabled, OrganizationEnabled, ActiveEnabled {
    private static final long serialVersionUID = 1L;
    public static final String TABLE_NAME = "M_DiscountSchemaLine";
    public static final String PricingPriceListSchemeLine = "PricingPriceListSchemeLine";
    public static final String PROPERTY_ID = "id";
    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_PRICELISTSCHEMA = "priceListSchema";
    public static final String PROPERTY_SEQUENCENUMBER = "sequenceNumber";
    public static final String PROPERTY_PRODUCTCATEGORY = "productCategory";
    public static final String PROPERTY_BUSINESSPARTNER = "businessPartner";
    public static final String PROPERTY_PRODUCT = "product";
    public static final String PROPERTY_CONVERSIONRATETYPE =
        "conversionRateType";
    public static final String PROPERTY_CONVERSIONDATE = "conversionDate";
    public static final String PROPERTY_BASELISTPRICE = "baseListPrice";
    public static final String PROPERTY_SURCHARGELISTPRICEAMOUNT =
        "surchargeListPriceAmount";
    public static final String PROPERTY_LISTPRICEDISCOUNT = "listPriceDiscount";
    public static final String PROPERTY_LISTPRICEROUNDING = "listPriceRounding";
    public static final String PROPERTY_MINLISTPRICEMARGIN =
        "minListPriceMargin";
    public static final String PROPERTY_MAXLISTPRICEMARGIN =
        "maxListPriceMargin";
    public static final String PROPERTY_FIXEDLISTPRICE = "fixedListPrice";
    public static final String PROPERTY_STANDARDBASEPRICE = "standardBasePrice";
    public static final String PROPERTY_SURCHARGESTANDARDPRICEAMOUNT =
        "surchargeStandardPriceAmount";
    public static final String PROPERTY_STANDARDPRICEDISCOUNT =
        "standardPriceDiscount";
    public static final String PROPERTY_STANDARDPRICEROUNDING =
        "standardPriceRounding";
    public static final String PROPERTY_MINSTANDARDPRICEMARGIN =
        "minStandardPriceMargin";
    public static final String PROPERTY_MAXSTANDARDMARGIN = "maxStandardMargin";
    public static final String PROPERTY_FIXEDSTANDARDPRICE =
        "fixedStandardPrice";
    public static final String PROPERTY_BASELIMITPRICE = "baseLimitPrice";
    public static final String PROPERTY_SURCHARGEPRICELIMITAMOUNT =
        "surchargePriceLimitAmount";
    public static final String PROPERTY_PRICELIMITDISCOUNT =
        "priceLimitDiscount";
    public static final String PROPERTY_PRICELIMITROUNDING =
        "priceLimitRounding";
    public static final String PROPERTY_LIMITPRICEMINMARGIN =
        "limitPriceMinMargin";
    public static final String PROPERTY_MAXPRICELIMITMARGIN =
        "maxPriceLimitMargin";
    public static final String PROPERTY_FIXEDLIMITPRICE = "fixedLimitPrice";
 
    public PriceListSchemeLine() {
        setDefaultValue(PROPERTY_ACTIVE, true);
        setDefaultValue(PROPERTY_CONVERSIONRATETYPE, "S");
        setDefaultValue(PROPERTY_BASELISTPRICE, "L");
        setDefaultValue(PROPERTY_LISTPRICEROUNDING, "C");
        setDefaultValue(PROPERTY_STANDARDBASEPRICE, "S");
        setDefaultValue(PROPERTY_STANDARDPRICEROUNDING, "C");
        setDefaultValue(PROPERTY_BASELIMITPRICE, "X");
        setDefaultValue(PROPERTY_PRICELIMITROUNDING, "C");
    }
 
    @Override
    public String getEntityName() {
        return PricingPriceListSchemeLine;
    }
 
    public String getId() {
        return (String) get(PROPERTY_ID);
    }
 
    public void setId(String id) {
        set(PROPERTY_ID, id);
    }
 
    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 PriceListSchema getPriceListSchema() {
        return (PriceListSchema) get(PROPERTY_PRICELISTSCHEMA);
    }
 
    public void setPriceListSchema(PriceListSchema priceListSchema) {
        set(PROPERTY_PRICELISTSCHEMA, priceListSchema);
    }
 
    public Long getSequenceNumber() {
        return (Long) get(PROPERTY_SEQUENCENUMBER);
    }
 
    public void setSequenceNumber(Long sequenceNumber) {
        set(PROPERTY_SEQUENCENUMBER, sequenceNumber);
    }
 
    public ProductCategory getProductCategory() {
        return (ProductCategory) get(PROPERTY_PRODUCTCATEGORY);
    }
 
    public void setProductCategory(ProductCategory productCategory) {
        set(PROPERTY_PRODUCTCATEGORY, productCategory);
    }
 
    public BusinessPartner getBusinessPartner() {
        return (BusinessPartner) get(PROPERTY_BUSINESSPARTNER);
    }
 
    public void setBusinessPartner(BusinessPartner businessPartner) {
        set(PROPERTY_BUSINESSPARTNER, businessPartner);
    }
 
    public Product getProduct() {
        return (Product) get(PROPERTY_PRODUCT);
    }
 
    public void setProduct(Product product) {
        set(PROPERTY_PRODUCT, product);
    }
 
    public String getConversionRateType() {
        return (String) get(PROPERTY_CONVERSIONRATETYPE);
    }
 
    public void setConversionRateType(String conversionRateType) {
        set(PROPERTY_CONVERSIONRATETYPE, conversionRateType);
    }
 
    public Date getConversionDate() {
        return (Date) get(PROPERTY_CONVERSIONDATE);
    }
 
    public void setConversionDate(Date conversionDate) {
        set(PROPERTY_CONVERSIONDATE, conversionDate);
    }
 
    public String getBaseListPrice() {
        return (String) get(PROPERTY_BASELISTPRICE);
    }
 
    public void setBaseListPrice(String baseListPrice) {
        set(PROPERTY_BASELISTPRICE, baseListPrice);
    }
 
    public BigDecimal getSurchargeListPriceAmount() {
        return (BigDecimal) get(PROPERTY_SURCHARGELISTPRICEAMOUNT);
    }
 
    public void setSurchargeListPriceAmount(BigDecimal surchargeListPriceAmount) {
        set(PROPERTY_SURCHARGELISTPRICEAMOUNT, surchargeListPriceAmount);
    }
 
    public BigDecimal getListPriceDiscount() {
        return (BigDecimal) get(PROPERTY_LISTPRICEDISCOUNT);
    }
 
    public void setListPriceDiscount(BigDecimal listPriceDiscount) {
        set(PROPERTY_LISTPRICEDISCOUNT, listPriceDiscount);
    }
 
    public String getListPriceRounding() {
        return (String) get(PROPERTY_LISTPRICEROUNDING);
    }
 
    public void setListPriceRounding(String listPriceRounding) {
        set(PROPERTY_LISTPRICEROUNDING, listPriceRounding);
    }
 
    public BigDecimal getMinListPriceMargin() {
        return (BigDecimal) get(PROPERTY_MINLISTPRICEMARGIN);
    }
 
    public void setMinListPriceMargin(BigDecimal minListPriceMargin) {
        set(PROPERTY_MINLISTPRICEMARGIN, minListPriceMargin);
    }
 
    public BigDecimal getMaxListPriceMargin() {
        return (BigDecimal) get(PROPERTY_MAXLISTPRICEMARGIN);
    }
 
    public void setMaxListPriceMargin(BigDecimal maxListPriceMargin) {
        set(PROPERTY_MAXLISTPRICEMARGIN, maxListPriceMargin);
    }
 
    public BigDecimal getFixedListPrice() {
        return (BigDecimal) get(PROPERTY_FIXEDLISTPRICE);
    }
 
    public void setFixedListPrice(BigDecimal fixedListPrice) {
        set(PROPERTY_FIXEDLISTPRICE, fixedListPrice);
    }
 
    public String getStandardBasePrice() {
        return (String) get(PROPERTY_STANDARDBASEPRICE);
    }
 
    public void setStandardBasePrice(String standardBasePrice) {
        set(PROPERTY_STANDARDBASEPRICE, standardBasePrice);
    }
 
    public BigDecimal getSurchargeStandardPriceAmount() {
        return (BigDecimal) get(PROPERTY_SURCHARGESTANDARDPRICEAMOUNT);
    }
 
    public void setSurchargeStandardPriceAmount(
        BigDecimal surchargeStandardPriceAmount) {
        set(PROPERTY_SURCHARGESTANDARDPRICEAMOUNT, surchargeStandardPriceAmount);
    }
 
    public BigDecimal getStandardPriceDiscount() {
        return (BigDecimal) get(PROPERTY_STANDARDPRICEDISCOUNT);
    }
 
    public void setStandardPriceDiscount(BigDecimal standardPriceDiscount) {
        set(PROPERTY_STANDARDPRICEDISCOUNT, standardPriceDiscount);
    }
 
    public String getStandardPriceRounding() {
        return (String) get(PROPERTY_STANDARDPRICEROUNDING);
    }
 
    public void setStandardPriceRounding(String standardPriceRounding) {
        set(PROPERTY_STANDARDPRICEROUNDING, standardPriceRounding);
    }
 
    public BigDecimal getMinStandardPriceMargin() {
        return (BigDecimal) get(PROPERTY_MINSTANDARDPRICEMARGIN);
    }
 
    public void setMinStandardPriceMargin(BigDecimal minStandardPriceMargin) {
        set(PROPERTY_MINSTANDARDPRICEMARGIN, minStandardPriceMargin);
    }
 
    public BigDecimal getMaxStandardMargin() {
        return (BigDecimal) get(PROPERTY_MAXSTANDARDMARGIN);
    }
 
    public void setMaxStandardMargin(BigDecimal maxStandardMargin) {
        set(PROPERTY_MAXSTANDARDMARGIN, maxStandardMargin);
    }
 
    public BigDecimal getFixedStandardPrice() {
        return (BigDecimal) get(PROPERTY_FIXEDSTANDARDPRICE);
    }
 
    public void setFixedStandardPrice(BigDecimal fixedStandardPrice) {
        set(PROPERTY_FIXEDSTANDARDPRICE, fixedStandardPrice);
    }
 
    public String getBaseLimitPrice() {
        return (String) get(PROPERTY_BASELIMITPRICE);
    }
 
    public void setBaseLimitPrice(String baseLimitPrice) {
        set(PROPERTY_BASELIMITPRICE, baseLimitPrice);
    }
 
    public BigDecimal getSurchargePriceLimitAmount() {
        return (BigDecimal) get(PROPERTY_SURCHARGEPRICELIMITAMOUNT);
    }
 
    public void setSurchargePriceLimitAmount(
        BigDecimal surchargePriceLimitAmount) {
        set(PROPERTY_SURCHARGEPRICELIMITAMOUNT, surchargePriceLimitAmount);
    }
 
    public BigDecimal getPriceLimitDiscount() {
        return (BigDecimal) get(PROPERTY_PRICELIMITDISCOUNT);
    }
 
    public void setPriceLimitDiscount(BigDecimal priceLimitDiscount) {
        set(PROPERTY_PRICELIMITDISCOUNT, priceLimitDiscount);
    }
 
    public String getPriceLimitRounding() {
        return (String) get(PROPERTY_PRICELIMITROUNDING);
    }
 
    public void setPriceLimitRounding(String priceLimitRounding) {
        set(PROPERTY_PRICELIMITROUNDING, priceLimitRounding);
    }
 
    public BigDecimal getLimitPriceMinMargin() {
        return (BigDecimal) get(PROPERTY_LIMITPRICEMINMARGIN);
    }
 
    public void setLimitPriceMinMargin(BigDecimal limitPriceMinMargin) {
        set(PROPERTY_LIMITPRICEMINMARGIN, limitPriceMinMargin);
    }
 
    public BigDecimal getMaxPriceLimitMargin() {
        return (BigDecimal) get(PROPERTY_MAXPRICELIMITMARGIN);
    }
 
    public void setMaxPriceLimitMargin(BigDecimal maxPriceLimitMargin) {
        set(PROPERTY_MAXPRICELIMITMARGIN, maxPriceLimitMargin);
    }
 
    public BigDecimal getFixedLimitPrice() {
        return (BigDecimal) get(PROPERTY_FIXEDLIMITPRICE);
    }
 
    public void setFixedLimitPrice(BigDecimal fixedLimitPrice) {
        set(PROPERTY_FIXEDLIMITPRICE, fixedLimitPrice);
    }
}

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Reference/Entity_Model/PricingPriceListSchemeLine"

This page has been accessed 1,666 times. This page was last modified on 2 July 2011, at 21:36. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.

Category: Data Model