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