OrderForms Table
The OrderForms table in the transactions database contains information about the order forms that are associated with completed orders.
The following table describes the columns in the OrderForms table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
OrderFormId |
uniqueidentifier |
no |
The ID of the order form. This is the primary key. |
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group that is associated with the order form. This is a foreign key. |
Name |
nvarchar(64) |
yes |
The name of the order form. |
BillingAddressId |
nvarchar(50) |
yes |
The ID of the billing address that is associated with the order form. |
PromoUserIdentity |
nvarchar(64) |
yes |
An identifier for the user who is associated with the promotion code, for example, the user's logon name or e-mail address. |
SubTotal |
money |
no |
The cost of the line items in the order form. |
ShippingTotal |
money |
no |
The shipping cost for the items in the order form. |
HandlingTotal |
money |
no |
The handling cost for the line items in the order form. |
TaxTotal |
money |
no |
The tax for the items in the order form. |
Total |
money |
no |
The total cost for the order form. |
Created |
datetime |
no |
The date the order form was created. |
LastModified |
datetime |
no |
The date the order form was last modified. |
ModifiedBy |
nvarchar(64) |
no |
The user ID of the person who last modified the order form. |
Status |
nvarchar(64) |
yes |
The status of the order form. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |