ShippingDiscounts Table
The ShippingDiscounts table in the transactions database contains information about discounts that apply to shipping charges.
The following table describes the columns in the ShippingDiscounts table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group that is associated with the shipping discount. |
ShipmentId |
uniqueidentifier |
no |
The ID of the shipment that is associated with the shipping 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 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 that, 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 |
no |
The ID of the promotion code definition. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |