Adempiere3.4.0/en/ManPageW DiscountSchema olh
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
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
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 |
