DiscountsApplied Table
The DiscountsApplied table in the transactions database contains information about discounts that have been applied to completed orders.
The following table describes the columns in the DiscountsApplied table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group that is associated with the discount. |
LineItemId |
uniqueidentifier |
no |
The ID of the line item that is associated with the discount. This is a primary key and a foreign key. |
DiscountId |
int |
no |
The ID of the discount. This is a primary key. |
Priority |
int |
no |
The priority of the discount. |
LastModified |
datetime |
no |
The date that the discount was last modified. |
DiscountAmount |
money |
no |
The amount of the discount, for example $10 US. |
DiscountType |
int |
no |
The type of the discount. This is either a fixed amount or a percentage. |
DiscountValue |
money |
no |
The value which, when it is combined with the discount type, specifies how much the discount is. For example, a 25% discount would have a discount type of "percentage" and a discount value of "25". |
DiscountName |
nvarchar(64) |
yes |
The name of the discount. |
PromoCode |
nvarchar(64) |
yes |
The promotion code that is associated with the discount. |
BasketDisplayMessage |
nvarchar(255) |
yes |
The text to display for the discount. |
PromoCodeDefinitionId |
int |
yes |
The ID of the promotion code definition. |
ParentCollectionDiscriminator |
int |
no |
Whether the discount was applied to a line item or to a shipment. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |