ERP/3.0/Developers Guide/Database Model/org.openbravo.model.pricing.pricelist/M DiscountSchemaLine
M_DiscountSchemaLine
- Name:M_DiscountSchemaLine
- Classname:PricingPriceListSchemeLine
This table contains the following columns:
Name | Nullable | Data Type | Description
|
IsActive | No | CHAR (1) | 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. |
Limit_Base | No | VARCHAR (60) | Identifies the price to be used as the base for calculating a new price list. |
List_Base | No | VARCHAR (60) | The List Price Base indicates the price to use as the basis for the calculation of a new price list. |
C_BPartner_ID | Yes | VARCHAR (32) | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
ConversionDate | No | TIMESTAMP (7) | The Conversion Date identifies the date used for currency conversion. The conversion rate chosen must include this date in it's date range |
ConversionRateType | No | VARCHAR (60) | 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. |
CreatedBy | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
M_DiscountSchemaLine_ID | No | VARCHAR (32) | For the Pricelist Discount Type, you enter how the list, standard and limit price is calculated. |
Limit_Fixed | Yes | DECIMAL | Fixed Limit Price (not calculated) |
List_Fixed | Yes | DECIMAL | Fixes List Price (not calculated) |
Std_Fixed | Yes | DECIMAL | Fixed Standard Price (not calculated) |
Limit_Margin | No | DECIMAL | |
Limit_MinAmt | No | DECIMAL | 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. |
List_Discount | No | DECIMAL | 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_Margin | No | DECIMAL | |
List_Rounding | No | VARCHAR (60) | The List Price Rounding indicates how the final list price will be rounded. |
List_MaxAmt | No | DECIMAL | 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. |
Limit_MaxAmt | No | DECIMAL | 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. |
Std_MaxAmt | No | DECIMAL | 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. |
List_MinAmt | No | DECIMAL | 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. |
Std_MinAmt | No | DECIMAL | 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. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
Limit_Discount | No | DECIMAL | Indicates the discount in percent to be subtracted from base, if negative it will be added to base price |
Limit_Rounding | No | VARCHAR (60) | A drop down list box which indicates the rounding (if any) will apply to the final prices in this price list. |
M_DiscountSchema_ID | No | VARCHAR (32) | After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price. |
M_Product_ID | Yes | VARCHAR (32) | Identifies an item which is either purchased or sold in this organization. |
M_Product_Category_ID | Yes | VARCHAR (32) | Identifies the category which this product belongs to. Product categories are used for pricing. |
SeqNo | No | DECIMAL (10,0) | The Sequence indicates the order of records |
Std_Base | No | VARCHAR (60) | Net unit price before applying this promotion. In case multiple promotions are applied in cascade, this price is the one after applying all promotions with more priority than current one.
This field is populated in case the used price list does not include taxes. |
Std_Discount | No | DECIMAL | 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_Rounding | No | VARCHAR (60) | The Standard Price Rounding indicates how the final Standard price will be rounded. |
List_AddAmt | No | DECIMAL | The List Price Surcharge Amount indicates the amount to be added to the price prior to multiplication. |
Limit_AddAmt | No | DECIMAL | Indicates the amount to be added to the Limit price prior to multiplication. |
Std_AddAmt | No | DECIMAL | The Standard Price Surcharge Amount indicates the amount to be added to the price prior to multiplication. |
STD_Margin | No | DECIMAL | |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
UpdatedBy | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
Columns
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Base Limit Price
- Physical column name: Limit_Base
- Property Name: baseLimitPrice
- Reference: List
List values: M_DiscountPriceList Base
The allowed values for this list are:
- S (Net Unit Price)
- X (Limit (PO) Price)
- F (Fixed Price)
- FCM (Fixed Price or Cost plus Margin Based)
- FC (Fixed Price or Cost Based)
- C (Cost)
- L (Net List Price)
Base List Price
- Physical column name: List_Base
- Property Name: baseListPrice
- Reference: List
List values: M_DiscountPriceList Base
The allowed values for this list are:
- S (Net Unit Price)
- X (Limit (PO) Price)
- F (Fixed Price)
- FCM (Fixed Price or Cost plus Margin Based)
- FC (Fixed Price or Cost Based)
- C (Cost)
- L (Net List Price)
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Conversion Date
- Physical column name: ConversionDate
- Property Name: conversionDate
- Reference: Date
Conversion Rate Type
- Physical column name: ConversionRateType
- Property Name: conversionRateType
- Reference: List
List values: C_Conversion_Rate Types
The allowed values for this list are:
- A (Average): Average Rates
- C (Company): Company Rate
- U (User Type): User Rate Type
- M (Manual Rate): Manual Rate
- S (Spot): Spot Conversation Rate Type
- P (Period End): Period Conversion Type
- N (None): No Conversion Rate
- F (Fixed): Euro Fixed Currency
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Discount Pricelist
- Physical column name: M_DiscountSchemaLine_ID
- Property Name: id
- Reference: ID
Fixed Limit Price
- Physical column name: Limit_Fixed
- Property Name: fixedLimitPrice
- Reference: Price
- Default value: 0
Fixed List Price
- Physical column name: List_Fixed
- Property Name: fixedListPrice
- Reference: Price
- Default value: 0
Fixed Standard Price
- Physical column name: Std_Fixed
- Property Name: fixedStandardPrice
- Reference: Price
- Default value: 0
Limit Price Margin %
- Physical column name: Limit_Margin
- Property Name: limitPriceMargin
- Reference: Number
- Default value: 0
Limit price min Margin
- Physical column name: Limit_MinAmt
- Property Name: limitPriceMinMargin
- Reference: Amount
- Default value: 0
List Price Discount %
- Physical column name: List_Discount
- Property Name: listPriceDiscount
- Reference: Number
List Price Margin %
- Physical column name: List_Margin
- Property Name: listPriceMargin
- Reference: Number
- Default value: 0
List Price Rounding
- Physical column name: List_Rounding
- Property Name: listPriceRounding
- Reference: List
List values: M_DiscountPriceList RoundingRule
The allowed values for this list are:
- 0 (Whole Number .00): Number w/o decimals
- N (No Rounding)
- Q (Quarter .25 .50 .75)
- D (Dime .10, .20, .30, ...)
- 5 (Nickel .05, .10, .15, ...)
- T (Ten 10.00, 20.00, ..)
- C (Currency Precision)
- 2 (Two Decimals)
- 3 (Three decimals)
- 4 (Four decimals)
Max. List Price Margin
- Physical column name: List_MaxAmt
- Property Name: maxListPriceMargin
- Reference: Amount
- Default value: 0
Max. Price Limit Margin
- Physical column name: Limit_MaxAmt
- Property Name: maxPriceLimitMargin
- Reference: Amount
- Default value: 0
Max. Standard Margin
- Physical column name: Std_MaxAmt
- Property Name: maxStandardMargin
- Reference: Amount
- Default value: 0
Min. List Price Margin
- Physical column name: List_MinAmt
- Property Name: minListPriceMargin
- Reference: Amount
- Default value: 0
Min. Standard Price Margin
- Physical column name: Std_MinAmt
- Property Name: minStandardPriceMargin
- Reference: Amount
- Default value: 0
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Price Limit Discount %
- Physical column name: Limit_Discount
- Property Name: priceLimitDiscount
- Reference: Number
Price Limit Rounding
- Physical column name: Limit_Rounding
- Property Name: priceLimitRounding
- Reference: List
List values: M_DiscountPriceList RoundingRule
The allowed values for this list are:
- 0 (Whole Number .00): Number w/o decimals
- N (No Rounding)
- Q (Quarter .25 .50 .75)
- D (Dime .10, .20, .30, ...)
- 5 (Nickel .05, .10, .15, ...)
- T (Ten 10.00, 20.00, ..)
- C (Currency Precision)
- 2 (Two Decimals)
- 3 (Three decimals)
- 4 (Four decimals)
Price List Schema
- Physical column name: M_DiscountSchema_ID
- Property Name: priceListSchema
- Reference: TableDir
- This column is a child for a business object (is Parent)
Foreign key column to M_DiscountSchema table, (column: M_DiscountSchema_ID)
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
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)
Sequence Number
- Physical column name: SeqNo
- Property Name: sequenceNumber
- Reference: Integer
- This column is part of the table's identifier
Standard Base Price
- Physical column name: Std_Base
- Property Name: standardBasePrice
- Reference: List
List values: M_DiscountPriceList Base
The allowed values for this list are:
- S (Net Unit Price)
- X (Limit (PO) Price)
- F (Fixed Price)
- FCM (Fixed Price or Cost plus Margin Based)
- FC (Fixed Price or Cost Based)
- C (Cost)
- L (Net List Price)
Standard Price Discount %
- Physical column name: Std_Discount
- Property Name: standardPriceDiscount
- Reference: Number
Standard Price Rounding
- Physical column name: Std_Rounding
- Property Name: standardPriceRounding
- Reference: List
List values: M_DiscountPriceList RoundingRule
The allowed values for this list are:
- 0 (Whole Number .00): Number w/o decimals
- N (No Rounding)
- Q (Quarter .25 .50 .75)
- D (Dime .10, .20, .30, ...)
- 5 (Nickel .05, .10, .15, ...)
- T (Ten 10.00, 20.00, ..)
- C (Currency Precision)
- 2 (Two Decimals)
- 3 (Three decimals)
- 4 (Four decimals)
Surcharge List Price Amount
- Physical column name: List_AddAmt
- Property Name: surchargeListPriceAmount
- Reference: Amount
- Default value: 0
Surcharge Price Limit Amount
- Physical column name: Limit_AddAmt
- Property Name: surchargePriceLimitAmount
- Reference: Amount
- Default value: 0
Surcharge Standard Price Amount
- Physical column name: Std_AddAmt
- Property Name: surchargeStandardPriceAmount
- Reference: Amount
- Default value: 0
Unit Price Margin %
- Physical column name: STD_Margin
- Property Name: unitPriceMargin
- Reference: Number
- Default value: 0
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- M_DISCTSCHMLINE_DISCTSCHM_IDX Not Unique. Columns:
- M_DISCOUNTSCHEMA_ID
Check Constraints
These are the check constraints for this table:
- M_DISCOUNTSCHEMALINE_ISACT_CHK: ISACTIVE IN ('Y', 'N')