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