ShippingDiscounts Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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. |