ManPageW DiscountSchema

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Window: Discount Schema

Description : Maintain Trade Discount Schema

Help : Trade discount schema calculates the trade discount percentage



Tab: Discount Schema

Description : Trade Discount Schema

Help : Trade discount schema calculates the trade discount percentage

Table Name  : M_DiscountSchema

ManPageW DiscountSchema DiscountSchema.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Name 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

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active 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

CHAR(1)

YesNo

Discount Type Type of trade discount calculation Type of procedure used to calculate the trade discount percentage DiscountType

CHAR(1)

List

Script Dynamic Java Language Script to calculate result Use Java language constructs to define the result of the calculation Script

NVARCHAR2(2000)

Text

B.Partner Flat Discount Use flat discount defined on Business Partner Level For calculation of the discount, use the discount defined on Business Partner Level IsBPartnerFlatDiscount

CHAR(1)

YesNo

Flat Discount % Flat discount percentage FlatDiscount

NUMBER

Number

Quantity based Trade discount break level based on Quantity (not value) The calculation of the trade discount level is based on the quantity of the order and not the value amount of the order IsQuantityBased

CHAR(1)

YesNo

Accumulation Level Level for accumulative calculations CumulativeLevel

CHAR(1)

List

Renumber Renumber Discount entries Processing

CHAR(1)

Button


Tab: Discount Break

Description : Trade discount based on breaks (steps)

Help :

Table Name  : M_DiscountSchemaBreak

ManPageW DiscountSchema DiscountBreak.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Discount Schema Schema to calculate the trade discount percentage After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price. M_DiscountSchema_ID

NUMBER(10)

TableDir

Active 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

CHAR(1)

YesNo

Sequence Method of ordering records; lowest number comes first The Sequence indicates the order of records SeqNo

NUMBER(10)

Integer

Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product_Category_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Break Value Low Value of trade discount break level Starting Quantity or Amount Value for break level BreakValue

NUMBER

Number

B.Partner Flat Discount Use flat discount defined on Business Partner Level For calculation of the discount, use the discount defined on Business Partner Level IsBPartnerFlatDiscount

CHAR(1)

YesNo

Break Discount % Trade Discount in Percent for the break level Trade Discount in Percent for the break level BreakDiscount

NUMBER

Number

Contributions