ERP 2.50:Developers Guide/Database Model/org.openbravo.model.pricing.pricelist/M DiscountSchemaLine
M_DiscountSchemaLine
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
- Name:PricingPriceListSchemeLine
- Classname:PriceListSchemeLine
Name Nullable Data Type Description M_DiscountSchemaLine_ID N VARCHAR2(32) Line of the pricelist trade discount schema AD_Client_ID N VARCHAR2(32) Client for this installation. AD_Org_ID N VARCHAR2(32) Organizational entity within client IsActive N CHAR(1) A flag indicating whether this record is available for use or de-activated. Created N DATE The date that this record is completed. CreatedBy N VARCHAR2(32) User who created this records Updated N DATE x not implemented UpdatedBy N VARCHAR2(32) User who updated this records M_DiscountSchema_ID N VARCHAR2(32) A set of guidelines applied to current Price List in order to create a price list. SeqNo N NUMBER(10, 0) The order of records in a specified document. M_Product_Category_ID Y VARCHAR2(32) A classification of items based on similar characteristics or attributes. C_BPartner_ID Y VARCHAR2(32) Anyone who takes part in daily business operations by acting as a customer, employee, etc. M_Product_ID Y VARCHAR2(32) An item produced by a process. ConversionRateType N VARCHAR2(60) A distinct conversion rate characteristic used for processes. ConversionDate N DATE Date for selecting conversion rate List_Base N VARCHAR2(60) Price used as the basis for price list calculations List_AddAmt N NUMBER List Price Surcharge Amount List_Discount N NUMBER Discount from list price as a percentage List_Rounding N VARCHAR2(60) Rounding rule for final list price List_MinAmt N NUMBER Minimum margin for a product List_MaxAmt N NUMBER Maximum margin for a product List_Fixed Y NUMBER Fixes List Price (not calculated) Std_Base N VARCHAR2(60) Base price for calculating new standard price Std_AddAmt N NUMBER Amount added to a price as a surcharge Std_Discount N NUMBER Discount percentage to subtract from base price Std_Rounding N VARCHAR2(60) Rounding rule for calculated price Std_MinAmt N NUMBER Minimum margin allowed for a product Std_MaxAmt N NUMBER Maximum margin allowed for a product Std_Fixed Y NUMBER Fixed Standard Price (not calculated) Limit_Base N VARCHAR2(60) Base price for calculation of the new price Limit_AddAmt N NUMBER Amount added to the converted/copied price before multiplying Limit_Discount N NUMBER Discount in percent to be subtracted from base, if negative it will be added to base price Limit_Rounding N VARCHAR2(60) Rounding of the final result Limit_MinAmt N NUMBER Minimum difference to original limit price; ignored if zero Limit_MaxAmt N NUMBER Maximum difference to original limit price; ignored if zero Limit_Fixed Y NUMBER Fixed Limit Price (not calculated) Other Info
Check constraints
These are the check constraints for this table:
- M_DISCOUNTSCHEMALINE_ISACT_CHK: ISACTIVE IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- M_DISCOUNTSCHEMALINE_KEY
Columns
Discount Pricelist
For the Pricelist Discount Type, you enter how the list, standard and limit price is calculated.
- Physical column name: M_DiscountSchemaLine_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
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.- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Price List Schema
- Physical column name: M_DiscountSchema_ID
- Property Name: priceListSchema
- Reference: TableDir
- This column is a child for a buisiness object (is Parent)
Foreign key column to M_DiscountSchema table, (column: M_DiscountSchema_ID)
Sequence Number
The Sequence indicates the order of records
- Physical column name: SeqNo
- Property Name: sequenceNumber
- Reference: Integer
- Default value: @SQL=SELECT COALESCE(MAX(SeqNo),0)+10 AS DefaultValue FROM M_DiscountSchemaLine WHERE M_DiscountSchema_ID=@M_DiscountSchema_ID@
- This column is part of the table's identifier
Product Category
- Physical column name: M_Product_Category_ID
- Property Name: productCategory
- Reference: TableDir
Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Conversion Rate Type
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.
- Physical column name: ConversionRateType
- Property Name: conversionRateType
- Reference: List
- Default value: S
List values: C_Conversion_Rate Types
The allowed values for this list are:
- A (Average): Average Rates
- C (Company): Company Rate
- F (Fixed): Euro Fixed Currency
- M (Manual Rate): Manual Rate
- N (None): No Conversion Rate
- P (Period End): Period Conversion Type
- S (Spot): Spot Conversation Rate Type
- U (User Type): User Rate Type
Conversion Date
The Conversion Date identifies the date used for currency conversion. The conversion rate chosen must include this date in it's date range
- Physical column name: ConversionDate
- Property Name: conversionDate
- Reference: Date
- Default value: @#Date@
Base List Price
The List Price Base indicates the price to use as the basis for the calculation of a new price list.
- Physical column name: List_Base
- Property Name: baseListPrice
- Reference: List
- Default value: L
List values: M_DiscountPriceList Base
The allowed values for this list are:
- F (Fixed Price)
- L (List Price)
- S (Standard Price)
- X (Limit (PO) Price)
Surcharge List Price Amount
The List Price Surcharge Amount indicates the amount to be added to the price prior to multiplication.
- Physical column name: List_AddAmt
- Property Name: surchargeListPriceAmount
- Reference: Amount
List Price Discount %
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.
- Physical column name: List_Discount
- Property Name: listPriceDiscount
- Reference: Number
List Price Rounding
The List Price Rounding indicates how the final list price will be rounded.
- Physical column name: List_Rounding
- Property Name: listPriceRounding
- Reference: List
- Default value: C
List values: M_DiscountPriceList RoundingRule
The allowed values for this list are:
- 0 (Whole Number .00): Number w/o decimals
- 2 (Two Decimals)
- 3 (Three decimals)
- 4 (Four decimals)
- 5 (Nickel .05, .10, .15, ...)
- C (Currency Precision)
- D (Dime .10, .20, .30, ...)
- N (No Rounding)
- Q (Quarter .25 .50 .75)
- T (Ten 10.00, 20.00, ..)
Min. List Price Margin
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.
- Physical column name: List_MinAmt
- Property Name: minListPriceMargin
- Reference: Amount
Max. List Price Margin
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.
- Physical column name: List_MaxAmt
- Property Name: maxListPriceMargin
- Reference: Amount
Fixed List Price
Fixes List Price (not calculated)
- Physical column name: List_Fixed
- Property Name: fixedListPrice
- Reference: Price
Standard Base Price
The Standard Price Base indicates the price to use as the basis for the calculation of a new price standard.
- Physical column name: Std_Base
- Property Name: standardBasePrice
- Reference: List
- Default value: S
List values: M_DiscountPriceList Base
The allowed values for this list are:
- F (Fixed Price)
- L (List Price)
- S (Standard Price)
- X (Limit (PO) Price)
Surcharge Standard Price Amount
The Standard Price Surcharge Amount indicates the amount to be added to the price prior to multiplication.
- Physical column name: Std_AddAmt
- Property Name: surchargeStandardPriceAmount
- Reference: Amount
Standard Price Discount %
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.
- Physical column name: Std_Discount
- Property Name: standardPriceDiscount
- Reference: Number
Standard Price Rounding
The Standard Price Rounding indicates how the final Standard price will be rounded.
- Physical column name: Std_Rounding
- Property Name: standardPriceRounding
- Reference: List
- Default value: C
List values: M_DiscountPriceList RoundingRule
The allowed values for this list are:
- 0 (Whole Number .00): Number w/o decimals
- 2 (Two Decimals)
- 3 (Three decimals)
- 4 (Four decimals)
- 5 (Nickel .05, .10, .15, ...)
- C (Currency Precision)
- D (Dime .10, .20, .30, ...)
- N (No Rounding)
- Q (Quarter .25 .50 .75)
- T (Ten 10.00, 20.00, ..)
Min. Standard Price Margin
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.
- Physical column name: Std_MinAmt
- Property Name: minStandardPriceMargin
- Reference: Amount
Max. Standard Margin
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.
- Physical column name: Std_MaxAmt
- Property Name: maxStandardMargin
- Reference: Amount
Fixed Standard Price
Fixed Standard Price (not calculated)
- Physical column name: Std_Fixed
- Property Name: fixedStandardPrice
- Reference: Price
Base Limit Price
Identifies the price to be used as the base for calculating a new price list.
- Physical column name: Limit_Base
- Property Name: baseLimitPrice
- Reference: List
- Default value: X
List values: M_DiscountPriceList Base
The allowed values for this list are:
- F (Fixed Price)
- L (List Price)
- S (Standard Price)
- X (Limit (PO) Price)
Surcharge Price Limit Amount
Indicates the amount to be added to the Limit price prior to multiplication.
- Physical column name: Limit_AddAmt
- Property Name: surchargePriceLimitAmount
- Reference: Amount
Price Limit Discount %
Indicates the discount in percent to be subtracted from base, if negative it will be added to base price
- Physical column name: Limit_Discount
- Property Name: priceLimitDiscount
- Reference: Number
Price Limit Rounding
A drop down list box which indicates the rounding (if any) will apply to the final prices in this price list.
- Physical column name: Limit_Rounding
- Property Name: priceLimitRounding
- Reference: List
- Default value: C
List values: M_DiscountPriceList RoundingRule
The allowed values for this list are:
- 0 (Whole Number .00): Number w/o decimals
- 2 (Two Decimals)
- 3 (Three decimals)
- 4 (Four decimals)
- 5 (Nickel .05, .10, .15, ...)
- C (Currency Precision)
- D (Dime .10, .20, .30, ...)
- N (No Rounding)
- Q (Quarter .25 .50 .75)
- T (Ten 10.00, 20.00, ..)
Limit price min Margin
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.
- Physical column name: Limit_MinAmt
- Property Name: limitPriceMinMargin
- Reference: Amount
Max. Price Limit Margin
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.
- Physical column name: Limit_MaxAmt
- Property Name: maxPriceLimitMargin
- Reference: Amount
Fixed Limit Price
Fixed Limit Price (not calculated)
- Physical column name: Limit_Fixed
- Property Name: fixedLimitPrice
- Reference: Price