Latest revision |
Your text |
Line 1: |
Line 1: |
| == wikibot == | | == wikibot == |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- valign="top"
| |
− | | '''Schema
| |
− | | Purchasing
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Contains objects related to vendors and purchase orders.
| |
− | |}
| |
− |
| |
− | === Source ===
| |
− | <pre>
| |
− | CREATE SCHEMA Purchasing AUTHORIZATION dbo
| |
− | </pre>
| |
− |
| |
− | === Dependencies ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | View
| |
− | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| |- | | |- |
| | '''schema | | | '''schema |
− | | Purchasing | + | | .Purchasing |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Contains objects related to vendors and purchase orders.
| |
| |- | | |- |
| |} | | |} |
Line 80: |
Line 11: |
| CREATE SCHEMA Purchasing AUTHORIZATION dbo | | CREATE SCHEMA Purchasing AUTHORIZATION dbo |
| </pre> | | </pre> |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Table
| |
− | | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | View
| |
− | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
| |
− |
| |
− | |}
| |