http://dbshelp.devio.at/api.php?action=feedcontributions&feedformat=atom&user=WikiSysop
dbscript Online Help - User contributions [en]
2026-06-03T00:38:56Z
User contributions
MediaWiki 1.30.0
http://dbshelp.devio.at/index.php?title=Purchasing.ShipMethod_(table)&diff=2002
Purchasing.ShipMethod (table)
2009-12-28T22:11:12Z
<p>WikiSysop: Undo revision 2000 by Bot (Talk)</p>
<hr />
<div>== wikibot ==<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|-<br />
| '''Table<br />
| Purchasing.ShipMethod<br />
|- valign="top"<br />
| '''Description<br />
| Shipping company lookup table.<br />
|-<br />
|}<br />
<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|- style="background:silver"<br />
| '''Column<br />
| '''Data Type<br />
| '''Nullable<br />
| '''Default<br />
| '''Description / PK / Index<br />
<br />
|- valign="top"<br />
| ShipMethodID<br />
| int<br />
| not null<br />
| <br />
| Primary key for ShipMethod records.<br />PK_ShipMethod_ShipMethodID<br />
|- valign="top"<br />
| Name<br />
| dbo.Name<br />
| not null<br />
| <br />
| Shipping company name.<br />AK_ShipMethod_Name<br />
|- valign="top"<br />
| ShipBase<br />
| money<br />
| not null<br />
| ((0.00))<br />
| Minimum shipping charge.<br /><br />
|- valign="top"<br />
| ShipRate<br />
| money<br />
| not null<br />
| ((0.00))<br />
| Shipping charge per pound.<br /><br />
|- valign="top"<br />
| rowguid<br />
| uniqueidentifier<br />
| not null<br />
| (newid())<br />
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ShipMethod_rowguid<br />
|- valign="top"<br />
| ModifiedDate<br />
| datetime<br />
| not null<br />
| (getdate())<br />
| Date and time the record was last updated.<br /><br />
|}<br />
<br />
<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|- style="background:silver"<br />
| '''Detail Table<br />
| '''Column<br />
| '''Referencing Column<br />
<br />
|-<br />
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]<br />
| ShipMethodID<br />
| ShipMethodID<br />
|-<br />
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]<br />
| ShipMethodID<br />
| ShipMethodID<br />
|}<br />
<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|- style="background:silver"<br />
| '''Dependency Type<br />
| '''Object Type<br />
| '''Referenced Object<br />
<br />
|-<br />
| Data Type<br />
| Type<br />
| [[dbo.Name_(type)|dbo.Name]]<br />
<br />
|}<br />
<br />
<br />
<br />
== wikivalues ==<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|-<br />
| '''Table Values<br />
| Purchasing.ShipMethod<br />
|-<br />
|}<br />
<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|- style="background:silver" <br />
| '''ShipMethodID<br />
| '''Name<br />
| '''ShipBase<br />
| '''ShipRate<br />
|- <br />
| 1<br />
| XRQ - TRUCK GROUND<br />
| 3.95<br />
| 0.99<br />
|- <br />
| 2<br />
| ZY - EXPRESS<br />
| 9.95<br />
| 1.99<br />
|- <br />
| 3<br />
| OVERSEAS - DELUXE<br />
| 29.95<br />
| 2.99<br />
|- <br />
| 4<br />
| OVERNIGHT J-FAST<br />
| 21.95<br />
| 1.29<br />
|- <br />
| 5<br />
| CARGO TRANSPORT 5<br />
| 8.99<br />
| 1.49<br />
|}<br />
== automatically generated ==<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|-<br />
| '''Table<br />
| Purchasing.ShipMethod<br />
|- valign="top"<br />
| '''Description<br />
| Shipping company lookup table.<br />
|-<br />
|}<br />
<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|- style="background:silver"<br />
| '''Column<br />
| '''Data Type<br />
| '''Nullable<br />
| '''Default<br />
| '''Description / PK / Index<br />
<br />
|- valign="top"<br />
| ShipMethodID<br />
| int<br />
| not null<br />
| <br />
| Primary key for ShipMethod records.<br />PK_ShipMethod_ShipMethodID<br />
|- valign="top"<br />
| Name<br />
| Name<br />
| not null<br />
| <br />
| Shipping company name.<br />AK_ShipMethod_Name<br />
|- valign="top"<br />
| ShipBase<br />
| money<br />
| not null<br />
| (0.00)<br />
| Minimum shipping charge.<br /><br />
|- valign="top"<br />
| ShipRate<br />
| money<br />
| not null<br />
| (0.00)<br />
| Shipping charge per pound.<br /><br />
|- valign="top"<br />
| rowguid<br />
| uniqueidentifier<br />
| not null<br />
| (NEWID())<br />
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ShipMethod_rowguid<br />
|- valign="top"<br />
| ModifiedDate<br />
| datetime<br />
| not null<br />
| (GETDATE())<br />
| Date and time the record was last updated.<br /><br />
|}<br />
<br />
<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|- style="background:silver"<br />
| '''Detail Table<br />
| '''Column<br />
| '''Referencing Column<br />
<br />
|-<br />
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]<br />
| ShipMethodID<br />
| ShipMethodID<br />
|-<br />
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]<br />
| ShipMethodID<br />
| ShipMethodID<br />
|}<br />
<br />
<br />
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"<br />
|- style="background:silver"<br />
| '''Dependency Type<br />
| '''Object Type<br />
| '''Referenced Object<br />
<br />
|-<br />
| Data Type<br />
| Type<br />
| [[dbo.Name_(type)|dbo.Name]]<br />
<br />
|-<br />
| Schema<br />
| Schema<br />
| [[Purchasing_(schema)|Purchasing]]<br />
<br />
|}</div>
WikiSysop
http://dbshelp.devio.at/index.php?title=MediaWiki:Sidebar&diff=610
MediaWiki:Sidebar
2009-07-07T13:24:16Z
<p>WikiSysop: </p>
<hr />
<div>* dbscript.help<br />
** mainpage|mainpage<br />
** recentchanges-url|recentchanges<br />
* dbscript.web<br />
** http://www.devio.at/index.php/dbscript|Homepage<br />
** http://devio.wordpress.com/category/dbscript/|Blog<br />
** http://gforge.devio.at/projects/dbscript/|Download<br />
** http://forum.devio.at/index.php|Forum</div>
WikiSysop
http://dbshelp.devio.at/index.php?title=MediaWiki:Sidebar&diff=609
MediaWiki:Sidebar
2009-07-07T13:23:40Z
<p>WikiSysop: </p>
<hr />
<div>* navigation<br />
** mainpage|mainpage<br />
** recentchanges-url|recentchanges<br />
* dbscript.web<br />
** http://www.devio.at/index.php/dbscript|Homepage<br />
** http://devio.wordpress.com/category/dbscript/|Blog<br />
** http://gforge.devio.at/projects/dbscript/|Download<br />
** http://forum.devio.at/index.php|Forum</div>
WikiSysop
http://dbshelp.devio.at/index.php?title=MediaWiki:Sidebar&diff=608
MediaWiki:Sidebar
2009-07-07T13:22:51Z
<p>WikiSysop: </p>
<hr />
<div>* navigation<br />
** mainpage|mainpage<br />
** recentchanges-url|recentchanges<br />
** --<br />
** [http://www.devio.at/index.php/dbscript Homepage]<br />
** [http://devio.wordpress.com/category/dbscript/ Blog]<br />
** [http://gforge.devio.at/projects/dbscript/ Download]<br />
** [http://forum.devio.at/index.php Forum]</div>
WikiSysop
http://dbshelp.devio.at/index.php?title=MediaWiki:Sidebar&diff=607
MediaWiki:Sidebar
2009-07-07T13:22:33Z
<p>WikiSysop: </p>
<hr />
<div>* navigation<br />
** mainpage|mainpage<br />
** recentchanges-url|recentchanges<br />
* dbscript.web<br />
** [http://www.devio.at/index.php/dbscript Homepage]<br />
** [http://devio.wordpress.com/category/dbscript/ Blog]<br />
** [http://gforge.devio.at/projects/dbscript/ Download]<br />
** [http://forum.devio.at/index.php Forum]</div>
WikiSysop
http://dbshelp.devio.at/index.php?title=MediaWiki:Sidebar&diff=606
MediaWiki:Sidebar
2009-07-07T13:21:46Z
<p>WikiSysop: </p>
<hr />
<div>* navigation<br />
** mainpage|mainpage<br />
** recentchanges-url|recentchanges<br />
<br />
* dbscript.web<br />
** [[http://www.devio.at/index.php/dbscript Homepage]]<br />
** [[http://devio.wordpress.com/category/dbscript/ Blog]]<br />
** [[http://gforge.devio.at/projects/dbscript/ Download]]<br />
** [[http://forum.devio.at/index.php Forum]]</div>
WikiSysop
http://dbshelp.devio.at/index.php?title=MediaWiki:Sidebar&diff=104
MediaWiki:Sidebar
2008-11-11T20:31:10Z
<p>WikiSysop: New page: * navigation ** mainpage|mainpage ** recentchanges-url|recentchanges ** randompage-url|randompage</p>
<hr />
<div>* navigation<br />
** mainpage|mainpage<br />
** recentchanges-url|recentchanges<br />
** randompage-url|randompage</div>
WikiSysop