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: 32java.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: 60java.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: 60java.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: 60java.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: 60java.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: 60java.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: 60java.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: 60java.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); } }