Sales - AdventureWorks

AdventureWorks

- AdventureWorks

Sales module holds information about shopping cart, sales orders, special offers and sales people.

Tables

		Name
1		Sales.CountryRegionCurrency
2		Sales.CreditCard
3		Sales.Currency
4		Sales.CurrencyRate
5		Sales.Customer
6		Sales.PersonCreditCard
7		Sales.SalesOrderDetail
8		Sales.SalesOrderHeader
9		Sales.SalesOrderHeaderSalesReason
10		Sales.SalesPerson
11		Sales.SalesPersonQuotaHistory
12		Sales.SalesReason
13		Sales.SalesTaxRate
14		Sales.SalesTerritory
15		Sales.SalesTerritoryHistory
16		Sales.ShoppingCartItem
17		Sales.SpecialOffer
18		Sales.SpecialOfferProduct
19		Sales.Store

Views

		Name
1		Sales.vIndividualCustomer
2		Sales.vPersonDemographics
3		Sales.vSalesPerson
4		Sales.vSalesPersonSalesByFiscalYears
5		Sales.vStoreWithAddresses
6		Sales.vStoreWithContacts
7		Sales.vStoreWithDemographics

Functions

		Name
1		dbo.ufnGetAccountingEndDate
2		dbo.ufnGetAccountingStartDate
3		dbo.ufnGetSalesOrderStatusText
4		dbo.ufnLeadingZeros