| AdventureWorks Database : Sales Schema |
| Table | Description |
|---|---|
| Sales.ContactCreditCard | Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table. |
| Sales.CountryRegionCurrency | Cross-reference table mapping ISO currency codes to a country or region. |
| Sales.CreditCard | Customer credit card information. |
| Sales.Currency | Lookup table containing standard ISO currencies. |
| Sales.CurrencyRate | Currency exchange rates. |
| Sales.Customer | Current customer information. Also see the Individual and Store tables. |
| Sales.CustomerAddress | Cross-reference table mapping customers to their address(es). |
| Sales.Individual | Demographic data about customers that purchase Adventure Works products online. |
| Sales.SalesOrderDetail | Individual products associated with a specific sales order. See SalesOrderHeader. |
| Sales.SalesOrderHeader | General sales order information. |
| Sales.SalesOrderHeaderSalesReason | Cross-reference table mapping sales orders to sales reason codes. |
| Sales.SalesPerson | Sales representative current information. |
| Sales.SalesPersonQuotaHistory | Sales performance tracking. |
| Sales.SalesReason | Lookup table of customer purchase reasons. |
| Sales.SalesTaxRate | Tax rate lookup table. |
| Sales.SalesTerritory | Sales territory lookup table. |
| Sales.SalesTerritoryHistory | Sales representative transfers to other sales territories. |
| Sales.ShoppingCartItem | Contains online customer orders until the order is submitted or cancelled. |
| Sales.SpecialOffer | Sale discounts lookup table. |
| Sales.SpecialOfferProduct | Cross-reference table mapping products to special offer discounts. |
| Sales.Store | Customers (resellers) of Adventure Works products. |
| Sales.StoreContact | Cross-reference table mapping stores and their employees. |
| View | Description |
|---|---|
| Sales.vIndividualCustomer | Individual customers (names and addresses) that purchase Adventure Works Cycles products online. |
| Sales.vIndividualDemographics | Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table. |
| Sales.vSalesPerson | Sales representiatives (names and addresses) and their sales-related information. |
| Sales.vSalesPersonSalesByFiscalYears | Uses PIVOT to return aggregated sales information for each sales representative. |
| Sales.vStoreWithDemographics | Stores (names and addresses) that sell Adventure Works Cycles products to consumers. |