PurchaseOrders Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The PurchaseOrders table in the transactions database contains information about completed orders.
The following table describes the columns in the PurchaseOrders table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
OrderGroupId |
uniqueidentifier |
no |
The ID of the purchase order. This is the primary key. |
Name |
nvarchar(64) |
yes |
The name of the purchase order. |
SoldToId |
uniqueidentifier |
no |
The ID of the user who purchased the order. |
SoldToAddressId |
nvarchar(50) |
yes |
The ID of the address that is associated with the user who purchased the order. |
LineItemCount |
int |
no |
The number of line items that are associated with the purchase order. |
ShippingTotal |
money |
no |
The shipping cost for the items in the purchase order. |
HandlingTotal |
money |
no |
The handling cost of the purchase order. |
TaxTotal |
money |
no |
The tax for the purchase order. |
SubTotal |
money |
no |
The cost of the line items in the purchase order. |
Total |
money |
no |
The total cost for the purchase order. |
Created |
datetime |
no |
The date the purchase order was created. |
LastModified |
datetime |
no |
The date the purchase order was last modified. |
ModifiedBy |
nvarchar(64) |
no |
The user ID of the person who last modified the purchase order. |
TrackingNumber |
nvarchar(32) |
yes |
A tracking number for the purchase order. |
BasketId |
uniqueidentifier |
yes |
The ID of the basket that was converted to the purchase order. |
BillingCurrency |
nvarchar(32) |
yes |
The currency that is being used to pay for the order. |
Status |
nvarchar(64) |
yes |
The status of the purchase order. |
SoldToName |
nvarchar(64) |
yes |
The name of the user who purchased the order. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |