Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Purchasing ShipMethod (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:04


wikibot

TablePurchasing.ShipMethod
DescriptionShipping company lookup table.

ColumnData TypeNullableDefaultDescription / PK / Index
ShipMethodIDintnot null Primary key for ShipMethod records.
PK_ShipMethod_ShipMethodID
Namedbo.Namenot 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

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