Difference between revisions of "Purchasing.ShipMethod (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.ShipMethod |- |} {| border="1" cellpadding="5" cellspacing="0" st...)
 
Line 78: Line 78:
 
| ShipMethodID
 
| ShipMethodID
 
| ShipMethodID
 
| ShipMethodID
 +
|}
 +
 +
== wikivalues ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table Values
 +
| Purchasing.ShipMethod
 +
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''ShipMethodID
 +
| '''Name
 +
| '''ShipBase
 +
| '''ShipRate
 +
|-
 +
| 1
 +
| XRQ - TRUCK GROUND
 +
| 3.95
 +
| 0.99
 +
|-
 +
| 2
 +
| ZY - EXPRESS
 +
| 9.95
 +
| 1.99
 +
|-
 +
| 3
 +
| OVERSEAS - DELUXE
 +
| 29.95
 +
| 2.99
 +
|-
 +
| 4
 +
| OVERNIGHT J-FAST
 +
| 21.95
 +
| 1.29
 +
|-
 +
| 5
 +
| CARGO TRANSPORT 5
 +
| 8.99
 +
| 1.49
 
|}
 
|}

Revision as of 14:53, 3 January 2009

wikibot

Table Purchasing.ShipMethod


Column Data Type Nullable Default PK Index
ShipMethodID int not null PK_ShipMethod_ShipMethodID
Name dbo.Name not null AK_ShipMethod_Name
ShipBase money not null ((0.00))
ShipRate money not null ((0.00))
rowguid uniqueidentifier not null (newid()) AK_ShipMethod_rowguid
ModifiedDate datetime not null (getdate())


Detail Table Column Referencing Column
Purchasing.PurchaseOrderHeader ShipMethodID ShipMethodID
Sales.SalesOrderHeader ShipMethodID ShipMethodID

wikivalues

Table Values Purchasing.ShipMethod


ShipMethodID Name ShipBase ShipRate
1 XRQ - TRUCK GROUND 3.95 0.99
2 ZY - EXPRESS 9.95 1.99
3 OVERSEAS - DELUXE 29.95 2.99
4 OVERNIGHT J-FAST 21.95 1.29
5 CARGO TRANSPORT 5 8.99 1.49
Retrieved from "http://dbshelp.devio.at/index.php?title=Purchasing.ShipMethod_(table)&oldid=307"