ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Purchasing.ShipMethod_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Purchasing.ShipMethod |- valign="top" | '''Description''' | Shipping company lookup table. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | ShipMethodID | int | not null | | Primary key for ShipMethod records. |- valign="top" | Name | dbo.Name | not null | | Shipping company name. |- valign="top" | ShipBase | money | not null | ((0.00)) | Minimum shipping charge. |- valign="top" | ShipRate | money | not null | ((0.00)) | Shipping charge per pound. |- valign="top" | rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_ShipMethod_ShipMethodID | ShipMethodID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | AK_ShipMethod_Name | Unique | Name |- valign="top" | AK_ShipMethod_rowguid | Unique | rowguid |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | CK_ShipMethod_ShipBase | ([ShipBase]>(0.00)) | Check constraint [ShipBase] > (0.00) |- valign="top" | CK_ShipMethod_ShipRate | ([ShipRate]>(0.00)) | Check constraint [ShipRate] > (0.00) |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]] | ShipMethodID | ShipMethodID |- valign="top" | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ShipMethodID | ShipMethodID |} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Data Type | Type | [[dbo.Name_(type)|dbo.Name]] |- valign="top" | Schema | Schema | [[Purchasing_(schema)|Purchasing]] |} == wikivalues == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table Values''' | Purchasing.ShipMethod |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''ShipMethodID''' | '''Name''' | '''ShipBase''' | '''ShipRate''' |- valign="top" | 1 | XRQ - TRUCK GROUND | 3.95 | 0.99 |- valign="top" | 2 | ZY - EXPRESS | 9.95 | 1.99 |- valign="top" | 3 | OVERSEAS - DELUXE | 29.95 | 2.99 |- valign="top" | 4 | OVERNIGHT J-FAST | 21.95 | 1.29 |- valign="top" | 5 | CARGO TRANSPORT 5 | 8.99 | 1.49 |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Purchasing.ShipMethod |- valign="top" | '''Description''' | Shipping company lookup table. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | ShipMethodID | int | not null | | Primary key for ShipMethod records.<br />PK_ShipMethod_ShipMethodID |- | Name | Name | not null | | Shipping company name.<br />AK_ShipMethod_Name |- | ShipBase | money | not null | (0.00) | Minimum shipping charge.<br /> |- | ShipRate | money | not null | (0.00) | Shipping charge per pound.<br /> |- | rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ShipMethod_rowguid |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]] | ShipMethodID | ShipMethodID |- | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ShipMethodID | ShipMethodID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Data Type | Type | [[dbo.Name_(type)|dbo.Name]] |- | Schema | Schema | [[Purchasing_(schema)|Purchasing]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.