ScrewTurn Wiki

Edit

wikibot

TablePurchasing.ShipMethod
DescriptionShipping company lookup table.

Edit

Columns

ColumnData TypeNullableDefaultDescription
ShipMethodIDintnot null Primary key for ShipMethod records.
Namedbo.Namenot null Shipping company name.
ShipBasemoneynot null((0.00))Minimum shipping charge.
ShipRatemoneynot null((0.00))Shipping charge per pound.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_ShipMethod_ShipMethodIDShipMethodID

Edit

Indexes

IndexTypeColumns
AK_ShipMethod_NameUniqueName
AK_ShipMethod_rowguidUniquerowguid

Edit

Check Constraints

Check ConstraintExpressionDescription
CK_ShipMethod_ShipBase(ShipBase>(0.00))Check constraint ShipBase > (0.00)
CK_ShipMethod_ShipRate(ShipRate>(0.00))Check constraint ShipRate > (0.00)

Edit

Detail Tables

Detail TableColumnReferencing Column
Purchasing.PurchaseOrderHeaderShipMethodIDShipMethodID
Sales.SalesOrderHeaderShipMethodIDShipMethodID

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaPurchasing

Edit

wikivalues

Table ValuesPurchasing.ShipMethod

ShipMethodIDNameShipBaseShipRate
1XRQ - TRUCK GROUND3.950.99
2ZY - EXPRESS9.951.99
3OVERSEAS - DELUXE29.952.99
4OVERNIGHT J-FAST21.951.29
5CARGO TRANSPORT 58.991.49

Edit

automatically generated

TablePurchasing.ShipMethod
DescriptionShipping company lookup table.

ColumnData TypeNullableDefaultDescription / PK / Index
ShipMethodIDintnot null Primary key for ShipMethod records.
PK_ShipMethod_ShipMethodID
NameNamenot null Shipping company name.
AK_ShipMethod_Name
ShipBasemoneynot null(0.00)Minimum shipping charge.
ShipRatemoneynot null(0.00)Shipping charge per pound.
rowguiduniqueidentifiernot null(NEWID())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_ShipMethod_rowguid
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



Detail TableColumnReferencing Column
Purchasing.PurchaseOrderHeaderShipMethodIDShipMethodID
Sales.SalesOrderHeaderShipMethodIDShipMethodID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaPurchasing

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.