OrderTemplatesAndBaskets Table
The OrderTemplatesAndBaskets table in the transactions database contains information about orders during the time that the orders are in progress. As soon as the order has been completed, it is no longer stored in the OrderTemplatesAndBaskets table.
Note
Order templates and baskets are specific types of order groups. The phrase "order group" is used throughout this topic to reference both order templates and baskets.
The following table describes the columns in the OrderTemplatesAndBaskets table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group. This is the primary key. |
Name |
nvarchar(64) |
yes |
The name of the order group. |
StatusCode |
int |
no |
Whether the order group is an order template or a basket. |
SubTotal |
money |
yes |
The cost of the line items in the order group. |
ShippingTotal |
money |
yes |
The shipping cost for the order group. |
HandlingTotal |
money |
yes |
The handling cost for the order group. |
TaxTotal |
money |
yes |
The tax for the order group. |
Total |
money |
yes |
The total cost for the order group. |
LineItemCount |
int |
no |
The number of line items that are associated with the order group. |
SoldToId |
uniqueidentifier |
yes |
The ID of the customer who is associated with the order group. |
SoldToAddressId |
nvarchar(50) |
yes |
The ID of the address of the customer. |
BillingCurrency |
nvarchar(64) |
yes |
The currency that is being used to pay for the order. |
Status |
nvarchar(64) |
null |
The status of the order. |
Created |
datetime |
no |
The date the order group was created. |
ModifiedBy |
nvarchar(64) |
no |
The user ID of the person who last modified the order group. |
LastModified |
datetime |
no |
The date the order group was last modified. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |