Price List Schema (Janela ID-337)

Janela: Price List Schema

Descrição: Maintain Price List Schema

Ajudar: Price List schema defines calculation rules for price lists

TAB: Price List Schema

Descrição: Price List Schema

Ajudar Price List schema defines calculation rules for price lists

Ficheiro:Price List Schema - Price List Schema - Janela (iDempiere 1.0.0).png

Nome	Nome	Descrição	Ajudar	Especificações
Client	Empresa	A Empresa instalada neste sistema.	A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organismo	Unidade organizacional componente da Empresa	A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.	AD_Org_ID numeric(10) NOT NULL Table Direct
Name	Nome	Alphanumeric identifier of the entity	The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.	Name character varying(60) NOT NULL String
Description	Descrição	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Active	Activo	The record is active in the system	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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Valid from	Válido de	Valid from including this date (first day)	The Valid From date indicates the first day of a date range	ValidFrom timestamp without time zone NOT NULL Date
Discount Type	Tipo Desconto	Type of trade discount calculation	Type of procedure used to calculate the trade discount percentage	DiscountType character(1) NOT NULL List
Renumber	Renumerar	Renumber Discount entries	null	Processing character(1) Button

TAB: Desconto, Linha

Descrição: Trade Discount Price List Lines

Ajudar 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
• result minus Discount
• if resulting price is less than the original limit price plus min Margin, use this price (only if Margin is not zero)
• if resulting price is more than the original limit price plus max Margin, use this price (only if Margin us not zero)
• Round resulting price

The Formula is
NewPrice = (Convert(BasePrice) + Surcharge) * (100-Discount) / 100;
if MinMargin <> 0 then NewPrice = Max (NewPrice, Convert(OrigLimitPrice) + MinMargin);
if MaxMargin <> 0 then NewPrice = Min (NewPrice, Convert(OrigLimitPrice) + MaxMargin);

Example: (assuming same currency)
Original Prices: List=300, Standard=250, Limit=200;
New List Price: Base=List, Surcharge=0, Discount=0, Round

Ficheiro:Price List Schema - Desconto, Linha - Janela (iDempiere 1.0.0).png

Nome	Nome	Descrição	Ajudar	Especificações
Client	Empresa	A Empresa instalada neste sistema.	A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas.	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organismo	Unidade organizacional componente da Empresa	A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas.	AD_Org_ID numeric(10) NOT NULL Table Direct
Price List Schema	Esquema de Descontos	Esquema para calcular os descontos (em percentagem) sobre o preço	Após determinar/calcular o preço (base), este Esquema é aplicado para calcular o desconto sobre o preço e determinar o preço final.	M_DiscountSchema_ID numeric(10) NOT NULL Table
Active	Activo	The record is active in the system	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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.	IsActive character(1) NOT NULL Yes-No
Sequence	Sequência	Metodo de ordenar registos; o numero mais baixo será o primeiro	A Sequência indica a ordem dos registos	SeqNo numeric(10) NOT NULL Integer
Currency Type	Divisa, Tipo	Currency Conversion Rate Type	The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates.	C_ConversionType_ID numeric(10) NOT NULL Table Direct
Conversion Date	Câmbio, Data	Date for selecting conversion rate	The Conversion Date identifies the date used for currency conversion. The conversion rate chosen must include this date in it's date range	ConversionDate timestamp without time zone NOT NULL Date
Business Partner	Terceiros	Identifica uma entidade externa à empresa (cliente, fornecedor, vendedor, etc. )	Terceiros são todas as instituições, sociedades ou individuos com quem a empresa tem um relacionamento comercial ou de trabalho. Exemplos: clientes, fornecedores, funcionários, vendedores ou representantes comerciais, etc.	C_BPartner_ID numeric(10) Search
Product	Artigo	Product, Service, Item	Identifies an item which is either purchased or sold in this organization.	M_Product_ID numeric(10) Search
Product Category	Categoria de Artigo	Category this product is part of	Identifies the category which this product belongs to. Product categories are used for pricing.	M_Product_Category_ID numeric(10) Table Direct
Classification	Classificação	Classification for grouping	The Classification can be used to optionally group products.	Classification character varying(12) String
Group1	Group1	null	null	Group1 character varying(255) String
Group2	Group2	null	null	Group2 character varying(255) String
List price Base	Preço Base	Price used as the basis for price list calculations	The List Price Base indicates the price to use as the basis for the calculation of a new price list.	List_Base character(1) NOT NULL List
List price min Margin	Listar Margem Mínima Preço	Minimum margin for a product	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.	List_MinAmt numeric NOT NULL Amount
List price Surcharge Amount	Listar Valor Sobretaxa de Preço	List Price Surcharge Amount	The List Price Surcharge Amount indicates the amount to be added to the price prior to multiplication.	List_AddAmt numeric NOT NULL Amount
List price max Margin	Listar Margem Máxima Preço	Maximum margin for a product	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.	List_MaxAmt numeric NOT NULL Amount
List price Discount %	Listar % Desconto Preço	Discount from list price as a percentage	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.	List_Discount numeric NOT NULL Number
List price Rounding	Listar Arredondamento Preço	Rounding rule for final list price	The List Price Rounding indicates how the final list price will be rounded.	List_Rounding character(1) NOT NULL List
Fixed List Price	Preço Negociado	Fixes List Price (not calculated)	null	List_Fixed numeric Amount
Standard price Base	Preço Padrão, Base	Base price for calculating new standard price	The Standard Price Base indicates the price to use as the basis for the calculation of a new price standard.	Std_Base character(1) NOT NULL List
Standard price min Margin	Preço Padrão, Margem Mínima	Minimum margin allowed for a product	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.	Std_MinAmt numeric NOT NULL Amount
Standard price Surcharge Amount	Preço Padrão, Custo Adicional	Amount added to a price as a surcharge	The Standard Price Surcharge Amount indicates the amount to be added to the price prior to multiplication.	Std_AddAmt numeric NOT NULL Amount
Standard max Margin	Preço Padrão, Margem Máxima	Maximum margin allowed for a product	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.	Std_MaxAmt numeric NOT NULL Amount
Standard price Discount %	Preço Padrão, % Desconto	Discount percentage to subtract from base price	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.	Std_Discount numeric NOT NULL Number
Standard price Rounding	Preço Padrão, Arredondamento	Rounding rule for calculated price	The Standard Price Rounding indicates how the final Standard price will be rounded.	Std_Rounding character(1) NOT NULL List
Fixed Standard Price	Preço Padrão Fixo	Fixed Standard Price (not calculated)	null	Std_Fixed numeric Amount
Limit price Base	Preço Limite, Base	Base price for calculation of the new price	Identifies the price to be used as the base for calculating a new price list.	Limit_Base character(1) NOT NULL List
Limit price min Margin	Preço Limite, Margem Mínima	Minimum difference to original limit price; ignored if zero	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.	Limit_MinAmt numeric NOT NULL Amount
Limit price Surcharge Amount	Preço Limite, Valor Sobretaxa	Amount added to the converted/copied price before multiplying	Indicates the amount to be added to the Limit price prior to multiplication.	Limit_AddAmt numeric NOT NULL Amount
Limit price max Margin	Preço Limite, Margem Máxima	Maximum difference to original limit price; ignored if zero	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.	Limit_MaxAmt numeric NOT NULL Amount
Limit price Discount %	Preço Limite, % Desconto	Discount in percent to be subtracted from base, if negative it will be added to base price	Indicates the discount in percent to be subtracted from base, if negative it will be added to base price	Limit_Discount numeric NOT NULL Number
Limit price Rounding	Preço Limite, Arredondamento	Rounding of the final result	A drop down list box which indicates the rounding (if any) will apply to the final prices in this price list.	Limit_Rounding character(1) NOT NULL List
Fixed Limit Price	Preço Limite Fixo	Fixed Limit Price (not calculated)	null	Limit_Fixed numeric Amount