Difference between revisions of "Sales (schema)"
| Line 17: | Line 17: | ||
| '''schema | | '''schema | ||
| .Sales | | .Sales | ||
| − | |- | + | |- valign="top" |
| '''Description | | '''Description | ||
| Line 28: | Line 28: | ||
CREATE SCHEMA Sales AUTHORIZATION dbo | CREATE SCHEMA Sales AUTHORIZATION dbo | ||
</pre> | </pre> | ||
| + | |||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Referencing Object | ||
| + | | '''Object Type | ||
| + | | '''Reference Type | ||
| + | |||
| + | |- | ||
| + | | [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.CreditCard_(table)|Sales.CreditCard]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.Currency_(table)|Sales.Currency]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.Customer_(table)|Sales.Customer]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.Individual_(table)|Sales.Individual]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesPerson_(table)|Sales.SalesPerson]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesReason_(table)|Sales.SalesReason]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.Store_(table)|Sales.Store]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.StoreContact_(table)|Sales.StoreContact]] | ||
| + | | Table | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] | ||
| + | | View | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]] | ||
| + | | View | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] | ||
| + | | View | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] | ||
| + | | View | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] | ||
| + | | View | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|Sales.IndividualSurveySchemaCollection]] | ||
| + | | XML Schema Collection | ||
| + | | Schema | ||
| + | |- | ||
| + | | [[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|Sales.StoreSurveySchemaCollection]] | ||
| + | | XML Schema Collection | ||
| + | | Schema | ||
| + | |} | ||
Revision as of 06:25, 30 November 2009
wikibot
| schema | .Sales |
CREATE SCHEMA Sales AUTHORIZATION dbo
automatically generated
| schema | .Sales |
| Description | Contains objects related to customers, sales orders, and sales territories. |
CREATE SCHEMA Sales AUTHORIZATION dbo
