ShipMethod Table (AdventureWorks)
In a lookup table that contains the companies that ship, or delivery.
The ShipMethod table is contained in the Purchasing schema.
Column | Data type | Nullability | Description |
---|---|---|---|
ShipMethodID |
int |
Not null |
Primary key. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Shipping company name. |
ShipBase |
money |
Not null |
Minimum shipping charge. |
ShipRate |
money |
Not null |
Shipping charge per pound. |
rowguid |
uniqueidentifier |
Not null |
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
PurchaseOrderDetail Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)