PromoCodeRecord Table
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. |