ApplyDiscountOnMRP | Apply Discount On MRP | Boolean | Yes | Stored but not used by the scheme engine. Not on the shipped forms. |
ConversionRatio | Conversion Ratio | Number | | The conversion ratio of the UOM unit, copied from the item when the quantity is derived. Not used by the scheme engine. |
ConversionRatio1 | Conversion Ratio 1 | Number | | The conversion ratio of the UOM 1 unit, copied from the item when the quantity is derived. Not used by the scheme engine. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DiscountAmount | Discount Amount | Number | | Amount off. For Line Level Discount Amount it is multiplied by the repeat count and split across the open lines by base amount (or by quantity when Reward Multiplier is Quantity), rounded so the shares add up. On item benefits it takes priority over Discount Percent when above 0. |
DiscountedItemGroupId | Discounted Item Group | Lookup → ItemGroup | | The item group whose items a Discounted Item Group benefit discounts. Automatic application only discounts group lines already on the document; new group lines are added only through Apply Scheme, for the items the user picks. |
DiscountedItemId | Discounted Item | Lookup → Item | | The item given free or at a discount by a Discounted Item benefit. Matching existing lines are discounted first; a new line for this item is added for the remaining quantity only at Discount Percent 100. Make it a different item from the qualifying item, otherwise the ordered line is split into paid and free units. |
DiscountedItemLotTypeId | Discounted Item Lot Type | Lookup → ItemLotType | | Only lines of this lot type are rewarded, and new free lines get this lot type. |
DiscountedItemQuantity | Discounted Item Quantity | Number | | Units rewarded per grant; 0 counts as 1. Multiplied by the qualification count with Repeat Reward, or by the achievement ratio with Repeat Rewards In Ratio. Also limits how many units of existing lines are discounted: a larger line is split. Can be derived from UOM and UOM Quantity on the record page. |
DiscountedItemRanking | Discounted Item Ranking | PickList | | Order in which matching existing lines receive the reward: High To Low starts with the most expensive line, Low To High or blank with the cheapest. Unit price is compared on sales and service documents, unit cost on purchase orders and bills. Not on the shipped forms. Values: High To Low, Low To High. |
DiscountedItemSKUId | Discounted SKU | Lookup → SKU | | Only lines of this SKU are rewarded, and new free lines get this SKU. For a Discounted Item Group benefit every added line gets this one SKU. |
DiscountedSKUId | Discounted SKU | Lookup → SKU, hidden, inactive | | Inactive legacy field with no stored value. Use Discounted SKU (DiscountedItemSKUId). |
DiscountPercent | Discount Percent | Percent | | Percentage off, entered 0 to 100. For line-level benefits it applies once to every open line, whatever the qualification count. For Discounted Item benefits a new free line is added only when this is 100; a lower value only discounts matching lines already on the document. |
ExcludeDiscountedItemGroupId | Exclude Discounted Item Group | Lookup → ItemGroup | | Lines of items in this group are never chosen to receive the reward, and its items are never added as free lines. Not on the shipped forms. |
ExcludeQualifyingItems | Exclude Qualifying Items | Boolean | Yes | When on, lines of items named in the slab's conditions are not rewarded, and matching lines are always split rather than discounted whole. |
Id | Id | Guid | Yes | |
LimitExpiryDays | Limit Expiry Days | Number | | Copied onto the lines that receive the reward and cleared by Reset Scheme. On invoices with free-item stock checking on, it steers which lot is reserved for a free line. Not on the shipped forms. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | The benefit's reference, numbered automatically from the SBN series. Not shown on the shipped forms. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
RecommendationText | Recommendation Text | LongMultiLineText | | The wording shown for this benefit on scheme recommendation cards in the catalogue and the item panel, ahead of Title. No effect on qualification or application. Not on the shipped forms. |
RecordTypeId | Record Type | Guid, hidden | | |
RepeatReward | Repeat Reward | Boolean | Yes | When on, the benefit is granted once per qualification count, the whole number of times the condition threshold was reached. Applies to Discount Amount and free-item quantities, not to Discount Percent or Reward Points. Editable on the record page only. Off by default. |
RepeatRewardForEveryQualification | Repeat Reward For Every Qualification | Boolean | | A switch on the benefit forms that the scheme engine does not read. Use Repeat Reward instead. |
RepeatRewardsInRatio | Repeat Rewards In Ratio | Boolean | Yes | When on, the benefit is scaled by the achievement-to-target ratio, which can be fractional, and takes precedence over Repeat Reward. Free quantities are not rounded. Not on the shipped forms. |
RewardMultiplier | Reward Multiplier | PickList | | How a Discount Amount is split across lines: Quantity splits by line quantity; Amount or blank splits by line base amount. The shipped picklist offers Amount only. Values: Amount. |
RewardPoints | Reward Points | Number | | Points for a Reward Points benefit, written onto every line of the document that is not scheme-generated (also replacing the slab link of lines another benefit discounted) and onto each line's Scheme Ledger row. Not multiplied by repeats and not counted against budgets. |
RewardType | Reward Type | PickList | Yes | What the benefit gives: Line Level Discount Percentage, Line Level Discount Amount, Discounted Item, Discounted Item Group or Reward Points. Line-level types apply to every open line of the document, not only the lines that met the conditions. An empty or unknown value gives nothing. Values: Line Level Discount Percentage, Line Level Discount Amount, Discounted Item, Discounted Item Group, Reward Points. |
SchemeId | Scheme | Lookup → Scheme | | The scheme the benefit belongs to, filled in by the slab card. The scheme engine does not read it: the scheme is taken from the benefit's slab. |
SchemeLineId | Scheme Slab | Lookup → SchemeLine | | The slab that grants this benefit. The only link the scheme engine uses, so a benefit with no slab never applies. The list offers only slabs of the chosen Scheme. |
SequenceNumber | Sequence Number | Number | Yes | Order of the benefit within its slab. The slab card numbers rewards 1, 2, 3 in the order they are added; these are the numbers Reward Custom Logic refers to, and the order breaks ties for Any One With Lowest or Highest Value. |
Title | Title | Text | | A short label for the reward. Shown on scheme recommendation cards when the benefit has no Recommendation Text. Not used to apply the benefit. |
UIProps | UI Props | Text | | |
UOM | UOM | PickList | | Unit of measure for entering the free quantity on the record page. Must be a unit defined on the Discounted Item; with UOM Quantity it sets Discounted Item Quantity through the item's conversion ratio. Values: Pack, Each. |
UOM1 | UOM 1 | PickList | | Second unit of measure for the free quantity, added to the first. Must be a unit defined on the Discounted Item. Values: Pack, Each. |
UOMQuantity | UOM Quantity | Number | | Free quantity in the UOM unit. Multiplied by that unit's conversion ratio to set Discounted Item Quantity. |
UOMQuantity1 | UOM Quantity 1 | Number | | Free quantity in the UOM 1 unit, added to the first unit's quantity. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
ValidFrom | Val From | Date | | First document date on which the benefit can apply, inclusive. Empty means no lower limit beyond the scheme's own validity. |
ValidTo | Val To | Date | | Last document date on which the benefit can apply, inclusive. Empty means no upper limit beyond the scheme's own validity. |
