Difference between revisions of "Purchasing (schema)"

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Schema
 
| '''Schema
 
| Purchasing
 
| Purchasing
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Contains objects related to vendors and purchase orders.
 
| Contains objects related to vendors and purchase orders.
|-
 
 
|}
 
|}
 
  
 
=== Source ===
 
=== Source ===
Line 24: Line 22:
 
| '''Referencing Object
 
| '''Referencing Object
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Table
 
| Table
 
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
 
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Table
 
| Table
 
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Table
 
| Table
 
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Table
 
| Table
 
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
 
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Table
 
| Table
 
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Table
 
| Table
 
| [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
 
| [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Table
 
| Table
 
| [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
 
| [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| View
 
| View

Latest revision as of 23:15, 23 June 2010

wikibot[edit]

Schema Purchasing
Description Contains objects related to vendors and purchase orders.

Source[edit]

CREATE SCHEMA Purchasing AUTHORIZATION dbo

Dependencies[edit]

Reference Type Object Type Referencing Object
Schema Table Purchasing.ProductVendor
Schema Table Purchasing.PurchaseOrderDetail
Schema Table Purchasing.PurchaseOrderHeader
Schema Table Purchasing.ShipMethod
Schema Table Purchasing.Vendor
Schema Table Purchasing.VendorAddress
Schema Table Purchasing.VendorContact
Schema View Purchasing.vVendor


automatically generated[edit]

schema Purchasing
Description Contains objects related to vendors and purchase orders.
CREATE SCHEMA Purchasing AUTHORIZATION dbo


Reference Type Object Type Referencing Object
Schema Table Purchasing.ProductVendor
Schema Table Purchasing.PurchaseOrderDetail
Schema Table Purchasing.PurchaseOrderHeader
Schema Table Purchasing.ShipMethod
Schema Table Purchasing.Vendor
Schema Table Purchasing.VendorAddress
Schema Table Purchasing.VendorContact
Schema View Purchasing.vVendor