| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| company_discount_family_id |
Foreign key of the discount family this rule applies to (when scoped by discount family rather than a single company). |
globally unique identifier | |
| company_id |
Foreign key of the company this discount rule applies to. |
globally unique identifier | |
| article_category_id |
Foreign key of the article category this discount rule applies to, when scoped to a whole category rather than a single article. |
globally unique identifier | |
| article_id |
Foreign key of the specific article this discount rule applies to. |
globally unique identifier | |
| article_price_label_id |
Foreign key of the price label/list this rule's overrides. |
globally unique identifier | |
| quantity_min |
Minimum order quantity for this discount rule to apply. |
integer | |
| quantity_max |
Maximum order quantity for this discount rule to apply. |
integer | |
| price |
Overridden unit price to apply when this rule matches. |
decimal number | |
| discount |
Discount amount/percentage to apply when this rule matches. |
decimal number | |
| date_from |
Date and time from which this discount rule becomes valid. |
date | |
| date_to |
Date and time until which this discount rule remains valid. |
date | |
| modified_dateutc |
Readonly system field managed by the database, filled with GetUtcDate when adding,updating |
date |