Shipments Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The Shipments table in the transactions database contains information about shipments that are associated with a completed order.
The following table describes the columns in the Shipments table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
ShipmentId |
uniqueidentifier |
no |
The ID of the shipment. This is the primary key. |
OrderFormId |
uniqueidentifier |
no |
The ID of the order form that is associated with the shipment. This is a foreign key. |
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group that is associated with the shipment. |
ShippingMethodId |
uniqueidentifier |
no |
The ID of the shipping method. |
ShippingAddressId |
nvarchar(50) |
yes |
The ID of the address that is to which the shipment should be delivered. |
ShipmentTrackingNumber |
nvarchar(128) |
yes |
The tracking number for the shipment. |
ShipmentTotal |
money |
yes |
The shipping charges for the shipment before applying discounts. |
ShippingDiscountAmount |
money |
no |
The discount that was applied to the shipping charges for this shipment. |
ShippingMethodName |
nvarchar(128) |
yes |
The name of the shipping method. |
Status |
nvarchar(64) |
yes |
The status of the shipment. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |