Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The PromoCodeRecord table in the transactions database contains information about a promotion that is associated with a completed order.
The following table describes the columns in the PromoCodeRecord table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
OrderFormId |
uniqueidentifier |
no |
The ID of the order form that is associated with the promotion. This is the primary key and a foreign key. |
PromoCode |
nvarchar(64) |
no |
The promotion code. |
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group that is associated with the promotion. |
PromoCodeDefinitionId |
int |
no |
The ID of the promotion code definition. |
PromoCodeLookupDate |
datetime |
no |
The date the promotion code was validated or reserved. |
PromoCodeStatus |
int |
no |
The status of the promotion. |
PromoApplied |
bit |
no |
Whether the discount that is associated with the promotion has been applied to the order. |
PromoCodeReserved |
bit |
no |
Whether the promotion was successfully reserved for the order. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |