Sales (schema)

Modified on 2011/08/27 11:16 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Schema'''
| Sales
|- valign="top"
| '''Description'''
| Contains objects related to customers, sales orders, and sales territories.
|}

=== Source ===
{{{{<nowiki>
CREATE SCHEMA Sales AUTHORIZATION dbo
</nowiki>}}}}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type'''
| '''Object Type'''
| '''Referencing Object'''

|- valign="top"
| Schema
| Table
| [[Sales ContactCreditCard (table)|Sales.ContactCreditCard]]

|- valign="top"
| Schema
| Table
| [[Sales CountryRegionCurrency (table)|Sales.CountryRegionCurrency]]

|- valign="top"
| Schema
| Table
| [[Sales CreditCard (table)|Sales.CreditCard]]

|- valign="top"
| Schema
| Table
| [[Sales Currency (table)|Sales.Currency]]

|- valign="top"
| Schema
| Table
| [[Sales CurrencyRate (table)|Sales.CurrencyRate]]

|- valign="top"
| Schema
| Table
| [[Sales Customer (table)|Sales.Customer]]

|- valign="top"
| Schema
| Table
| [[Sales CustomerAddress (table)|Sales.CustomerAddress]]

|- valign="top"
| Schema
| Table
| [[Sales Individual (table)|Sales.Individual]]

|- valign="top"
| Schema
| Table
| [[Sales SalesOrderDetail (table)|Sales.SalesOrderDetail]]

|- valign="top"
| Schema
| Table
| [[Sales SalesOrderHeader (table)|Sales.SalesOrderHeader]]

|- valign="top"
| Schema
| Table
| [[Sales SalesOrderHeaderSalesReason (table)|Sales.SalesOrderHeaderSalesReason]]

|- valign="top"
| Schema
| Table
| [[Sales SalesPerson (table)|Sales.SalesPerson]]

|- valign="top"
| Schema
| Table
| [[Sales SalesPersonQuotaHistory (table)|Sales.SalesPersonQuotaHistory]]

|- valign="top"
| Schema
| Table
| [[Sales SalesReason (table)|Sales.SalesReason]]

|- valign="top"
| Schema
| Table
| [[Sales SalesTaxRate (table)|Sales.SalesTaxRate]]

|- valign="top"
| Schema
| Table
| [[Sales SalesTerritory (table)|Sales.SalesTerritory]]

|- valign="top"
| Schema
| Table
| [[Sales SalesTerritoryHistory (table)|Sales.SalesTerritoryHistory]]

|- valign="top"
| Schema
| Table
| [[Sales ShoppingCartItem (table)|Sales.ShoppingCartItem]]

|- valign="top"
| Schema
| Table
| [[Sales SpecialOffer (table)|Sales.SpecialOffer]]

|- valign="top"
| Schema
| Table
| [[Sales SpecialOfferProduct (table)|Sales.SpecialOfferProduct]]

|- valign="top"
| Schema
| Table
| [[Sales Store (table)|Sales.Store]]

|- valign="top"
| Schema
| Table
| [[Sales StoreContact (table)|Sales.StoreContact]]

|- valign="top"
| Schema
| View
| [[Sales vIndividualCustomer (view)|Sales.vIndividualCustomer]]

|- valign="top"
| Schema
| View
| [[Sales vIndividualDemographics (view)|Sales.vIndividualDemographics]]

|- valign="top"
| Schema
| View
| [[Sales vSalesPerson (view)|Sales.vSalesPerson]]

|- valign="top"
| Schema
| View
| [[Sales vSalesPersonSalesByFiscalYears (view)|Sales.vSalesPersonSalesByFiscalYears]]

|- valign="top"
| Schema
| View
| [[Sales vStoreWithDemographics (view)|Sales.vStoreWithDemographics]]

|- valign="top"
| Schema
| XML Schema Collection
| [[Sales IndividualSurveySchemaCollection (xml schema collection)|Sales.IndividualSurveySchemaCollection]]

|- valign="top"
| Schema
| XML Schema Collection
| [[Sales StoreSurveySchemaCollection (xml schema collection)|Sales.StoreSurveySchemaCollection]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Sales (schema)
