ItemPricingDiscount

Stores details on promotional and volume-based discounts applied to items, supporting dynamic pricing strategies.

Columns


Name	Type	References	Description
id [KEY]	Integer		Unique identifier for the item pricing discount entry. This serves as the primary key for referencing the discount record.
fromquantity	Double		Minimum quantity required for the discount to apply. This defines the threshold at which the discount starts.
itempricing	Integer		Reference to the item pricing record associated with this discount. This links the discount to a specific item pricing structure.
itempricingrecord	String		Identifier for the item pricing record, providing additional details about the pricing configuration applied to the item.
memo	String		Optional field for storing notes or additional information about this discount entry. This can include internal comments or explanations.
percent	Double		The percentage discount applied when the quantity threshold is met. This value determines the reduction applied to the standard price.
quantityordered	Double		The actual quantity of items ordered that is eligible for this discount is used to determine if the discount criteria are met.