Purchasing.ShipMethod

Object type: Table

Shipping company lookup table.

Columns

Name Data type Nullable Description

ShipMethodID int No Column has identity seed value of 1 with a step value of 1.
Primary key for ShipMethod records.

Name Name No Shipping company name.

ShipBase money No Default value: 0.00
Minimum shipping charge.

ShipRate money No Default value: 0.00
Shipping charge per pound.

rowguid uniqueidentifier No Default value: NEWID()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.

Constraints

Name Type Columns Description

DF_ShipMethod_ShipBase DEFAULT ShipBase Value: 0.00
Default constraint value of 0.0

DF_ShipMethod_ShipRate DEFAULT ShipRate Value: 0.00
Default constraint value of 0.0

DF_ShipMethod_rowguid DEFAULT rowguid Value: NEWID()
Default constraint value of NEWID()

DF_ShipMethod_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()

CK_ShipMethod_ShipBase CHECK N/A Value: ([ShipBase] > 0.00)
Check constraint [ShipBase]>(0.00)

CK_ShipMethod_ShipRate CHECK N/A Value: ([ShipRate] > 0.00)
Check constraint [ShipRate]>(0.00)

PK_ShipMethod_ShipMethodID PRIMARY KEY ShipMethodID Clustered index created by a primary key constraint.

Indices

Name Description

AK_ShipMethod_Name Unique nonclustered index.

AK_ShipMethod_rowguid Unique nonclustered index.Used to support replication samples.

Triggers

Name Description

Purchasing.uShipMethod AFTER UPDATE trigger setting the ModifiedDate column in the ShipMethod table to the current date.

Linked tables

Name Description

Purchasing.PurchaseOrderHeader General purchase order information. See PurchaseOrderDetail.

Sales.SalesOrderHeader General sales order information.

Accessed by

Name Description

Sales Order Detail Detail of an individual Adventure Works order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.

Modified by

Name Description

Purchasing.uShipMethod AFTER UPDATE trigger setting the ModifiedDate column in the ShipMethod table to the current date.

Applies to

Tables | User

Name	Data type	Nullable	Description
ShipMethodID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for ShipMethod records.
Name	Name	No	Shipping company name.
ShipBase	money	No	Default value: 0.00 Minimum shipping charge.
ShipRate	money	No	Default value: 0.00 Shipping charge per pound.
rowguid	uniqueidentifier	No	Default value: NEWID() ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Name	Type	Columns	Description
DF_ShipMethod_ShipBase	DEFAULT	ShipBase	Value: 0.00 Default constraint value of 0.0
DF_ShipMethod_ShipRate	DEFAULT	ShipRate	Value: 0.00 Default constraint value of 0.0
DF_ShipMethod_rowguid	DEFAULT	rowguid	Value: NEWID() Default constraint value of NEWID()
DF_ShipMethod_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
CK_ShipMethod_ShipBase	CHECK	N/A	Value: ([ShipBase] > 0.00) Check constraint [ShipBase]>(0.00)
CK_ShipMethod_ShipRate	CHECK	N/A	Value: ([ShipRate] > 0.00) Check constraint [ShipRate]>(0.00)
PK_ShipMethod_ShipMethodID	PRIMARY KEY	ShipMethodID	Clustered index created by a primary key constraint.

Name	Description
AK_ShipMethod_Name	Unique nonclustered index.
AK_ShipMethod_rowguid	Unique nonclustered index.Used to support replication samples.

Name	Description
Purchasing.uShipMethod	AFTER UPDATE trigger setting the ModifiedDate column in the ShipMethod table to the current date.

Name	Description
Purchasing.PurchaseOrderHeader	General purchase order information. See PurchaseOrderDetail.
Sales.SalesOrderHeader	General sales order information.

Name	Description
Sales Order Detail	Detail of an individual Adventure Works order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.