Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
wikibot
Table Sales.SalesOrderHeader Description General sales order information. Columns Column Data Type Nullable Default Description SalesOrderID int not null Primary key. RevisionNumber tinyint not null ((0)) Incremental number to track changes to the sales order over time. OrderDate datetime not null (getdate()) Dates the sales order was created. DueDate datetime not null Date the order is due to the customer. ShipDate datetime null Date the order [...]
wikibot
Schema Sales Description Contains objects related to customers, sales orders, and sales territories. Source
CREATE SCHEMA Sales AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Sales.ContactCreditCard Schema Table Sales.CountryRegionCurrency Schema Table Sales.CreditCard [...]
wikibot
Table Sales.SalesOrderDetail Description Individual products associated with a specific sales order. See SalesOrderHeader. Columns Column Data Type Nullable Default Description SalesOrderID int not null Primary key. Foreign key to SalesOrderHeader.SalesOrderID. SalesOrderDetailID int not null Primary key. One incremental unique number per product sold. CarrierTrackingNumber nvarchar(25) null Shipment tracking number supplied by the shipper. OrderQty smallint not null Quantity ordered per product. ProductID [...]
[...] AWBuildVersion (dbo)
BillOfMaterials (Production)
Contact (Person)
ContactCreditCard (Sales)
ContactType (Person)
CountryRegion (Person)
CountryRegionCurrency (Sales)
CreditCard (Sales)
Culture (Production)
Currency (Sales)
CurrencyRate (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo)
Department (HumanResources) [...]
wikibot
Table Sales.Individual Description Demographic data about customers that purchase Adventure Works products online. Columns Column Data Type Nullable Default Description CustomerID int not null Unique customer identification number. Foreign key to Customer.CustomerID. ContactID int not null Identifies the customer in the Contact table. Foreign key to Contact.ContactID. Demographics xml null Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis. ModifiedDate [...]
wikibot
Table Sales.Store Description Customers (resellers) of Adventure Works products. Columns Column Data Type Nullable Default Description CustomerID int not null Primary key. Foreign key to Customer.CustomerID. Name dbo.Name not null Name of the store. SalesPersonID int null ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID. Demographics xml null Demographic informationg about the store such as the number of employees, annual sales and [...]
wikibot
Table Sales.SalesTerritory Description Sales territory lookup table. Columns Column Data Type Nullable Default Description TerritoryID int not null Primary key for SalesTerritory records. Name dbo.Name not null Sales territory description CountryRegionCode nvarchar(3) not null ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. Group nvarchar(50) not null Geographic area to which the sales territory belong. SalesYTD [...]
wikibot
Table Sales.SalesPerson Description Sales representative current information. Columns Column Data Type Nullable Default Description SalesPersonID int not null Primary key for SalesPerson records. TerritoryID int null Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID. SalesQuota money null Projected yearly sales. Bonus money not null ((0.00)) Bonus due if quota is met. CommissionPct smallmoney not null ((0.00)) Commision percent received per sale. [...]
wikibot
View Sales.vStoreWithDemographics Description Stores (names and addresses) that sell Adventure Works Cycles products to consumers. Source
CREATE VIEW [Sales].[vStoreWithDemographics] AS
SELECT
s.[CustomerID]
,s.[Name]
,ct.[Name] AS [ContactType]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,at.[Name] AS [AddressType]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,sp.[Name] AS [StateProvinceName] [...]
wikibot
View Sales.vIndividualCustomer Description Individual customers (names and addresses) that purchase Adventure Works Cycles products online. Source
CREATE VIEW [Sales].[vIndividualCustomer]
AS
SELECT
i.[CustomerID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,at.[Name] AS [AddressType]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,[StateProvinceName] = sp.[Name]
,a.[PostalCode]
,[CountryRegionName] [...]
wikibot
View Sales.vSalesPersonSalesByFiscalYears Description Uses PIVOT to return aggregated sales information for each sales representative. Source
CREATE VIEW [Sales].[vSalesPersonSalesByFiscalYears]
AS
SELECT
pvt.[SalesPersonID]
,pvt.[FullName]
,pvt.[Title]
,pvt.[SalesTerritory]
,pvt.[2002]
,pvt.[2003]
,pvt.[2004]
FROM (SELECT
soh.[SalesPersonID]
,c.[FirstName] + ' ' + COALESCE(c.[MiddleName], '') + ' ' + c.[LastName] AS [FullName]
[...]
wikibot
Table Sales.Customer Description Current customer information. Also see the Individual and Store tables. Columns Column Data Type Nullable Default Description CustomerID int not null Primary key for Customer records. TerritoryID int null ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID. AccountNumber Unique number identifying the customer assigned by the accounting system. CustomerType nchar(1) not null Customer type: I = Individual, S = Store rowguid uniqueidentifier not null [...]
wikibot
View Sales.vSalesPerson Description Sales representiatives (names and addresses) and their sales-related information. Source
CREATE VIEW [Sales].[vSalesPerson]
AS
SELECT
s.[SalesPersonID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,[JobTitle] = e.[Title]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,[StateProvinceName] = sp.[Name]
,a.[PostalCode]
[...]
wikibot
Table Sales.SalesTerritoryHistory Description Sales representative transfers to other sales territories. Columns Column Data Type Nullable Default Description SalesPersonID int not null Primary key for SalesTerritoryHistory records. TerritoryID int not null Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID. StartDate datetime not null Date the sales representive started work in the territory. EndDate datetime null [...]
wikibot
Table Sales.SalesPersonQuotaHistory Description Sales performance tracking. Columns Column Data Type Nullable Default Description SalesPersonID int not null Sales person identification number. Foreign key to SalesPerson.SalesPersonID. QuotaDate datetime not null Sales quota date. SalesQuota money not null Sales quota amount. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. [...]
[...] Columns AK_ContactType_Name Unique Name Detail Tables Detail Table Column Referencing Column Sales.StoreContact ContactTypeID ContactTypeID Purchasing.VendorContact ContactTypeID ContactTypeID References Dependency Type Object Type Referenced Object Data Type Type dbo.Name Schema Schema Person Dependencies Reference Type Object Type Referencing Object Select View Purchasing.vVendor Select View Sales.vStoreWithDemographics Select SQL table-valued-function dbo.ufnGetContactInformation
wikivalues
[...]
[...] EmailPromotion >= (0) AND EmailPromotion Detail Tables Detail Table Column Referencing Column Sales.ContactCreditCard ContactID ContactID HumanResources.Employee ContactID ContactID Sales.Individual ContactID ContactID Sales.SalesOrderHeader ContactID ContactID Sales.StoreContact ContactID ContactID Purchasing.VendorContact ContactID ContactID References Dependency Type Object Type Referenced Object Data Type Type dbo.Name Data Type Type dbo.NameStyle [...]
wikibot
Table Sales.SalesReason Description Lookup table of customer purchase reasons. Columns Column Data Type Nullable Default Description SalesReasonID int not null Primary key for SalesReason records. Name dbo.Name not null Sales reason description. ReasonType dbo.Name not null Category the sales reason belongs to. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_SalesReason_SalesReasonID SalesReasonID [...]
wikibot
Table Sales.Currency Description Lookup table containing standard ISO currencies. Columns Column Data Type Nullable Default Description CurrencyCode nchar(3) not null The ISO code for the Currency. Name dbo.Name not null Currency name. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Currency_CurrencyCode CurrencyCode Indexes Index Type Columns AK_Currency_Name Unique Name Detail Tables Detail Table Column Referencing Column Sales.CountryRegionCurrency [...]
wikibot
Table SH.SALES Description facts table, without a primary key; all rows are uniquely identified by the combination of all foreign keys Columns Column Data Type Nullable Default Description PROD_ID NUMBER not null FK to the products dimension table CUST_ID NUMBER not null FK to the customers dimension table TIME_ID DATE(7) not null FK to the times dimension table CHANNEL_ID NUMBER not null FK to the channels dimension table PROMO_ID NUMBER not null promotion identifier, without FK constraint (intentionally) to show outer join optimization [...]
wikibot
Table Sales.SalesOrderHeaderSalesReason Description Cross-reference table mapping sales orders to sales reason codes. Columns Column Data Type Nullable Default Description SalesOrderID int not null Primary key. Foreign key to SalesOrderHeader.SalesOrderID. SalesReasonID int not null Primary key. Foreign key to SalesReason.SalesReasonID. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID [...]
wikibot
View Sales.vIndividualDemographics Description Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table. Source
CREATE VIEW [Sales].[vIndividualDemographics]
AS
SELECT
i.[CustomerID]
,[IndividualSurvey].[ref].[value](N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey";
TotalPurchaseYTD[1]', 'money') AS [TotalPurchaseYTD]
,CONVERT(datetime, REPLACE([IndividualSurvey].[ref].[value](N'declare [...]
wikibot
Table Sales.CurrencyRate Description Currency exchange rates. Columns Column Data Type Nullable Default Description CurrencyRateID int not null Primary key for CurrencyRate records. CurrencyRateDate datetime not null Date and time the exchange rate was obtained. FromCurrencyCode nchar(3) not null Exchange rate was converted from this currency code. ToCurrencyCode nchar(3) not null Exchange rate was converted to this currency code. AverageRate money not null Average exchange rate for the day. EndOfDayRate money not null Final [...]
wikibot
Table Sales.CustomerAddress Description Cross-reference table mapping customers to their address(es). Columns Column Data Type Nullable Default Description CustomerID int not null Primary key. Foreign key to Customer.CustomerID. AddressID int not null Primary key. Foreign key to Address.AddressID. AddressTypeID int not null Address type. Foreign key to AddressType.AddressTypeID. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime [...]
wikibot
Table Sales.SpecialOfferProduct Description Cross-reference table mapping products to special offer discounts. Columns Column Data Type Nullable Default Description SpecialOfferID int not null Primary key for SpecialOfferProduct records. ProductID int not null Product identification number. Foreign key to Product.ProductID. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last [...]
wikibot
XML Schema Collection Sales.IndividualSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Individual table. Source
References Dependency Type Object Type Referenced Object [...]
wikibot
Table Sales.CreditCard Description Customer credit card information. Columns Column Data Type Nullable Default Description CreditCardID int not null Primary key for CreditCard records. CardType nvarchar(50) not null Credit card name. CardNumber nvarchar(25) not null Credit card number. ExpMonth tinyint not null Credit card expiration month. ExpYear smallint not null Credit card expiration year. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_CreditCard_CreditCardID [...]
[...] Person.StateProvince StateProvinceID StateProvinceID Detail Tables Detail Table Column Referencing Column Sales.CustomerAddress AddressID AddressID HumanResources.EmployeeAddress AddressID AddressID Sales.SalesOrderHeader AddressID BillToAddressID Sales.SalesOrderHeader AddressID ShipToAddressID Purchasing.VendorAddress AddressID AddressID References Dependency Type Object Type Referenced Object Schema Schema Person Dependencies Reference Type Object Type Referencing Object Select [...]
wikibot
Table Sales.SalesTaxRate Description Tax rate lookup table. Columns Column Data Type Nullable Default Description SalesTaxRateID int not null Primary key for SalesTaxRate records. StateProvinceID int not null State, province, or country/region the sales tax applies to. TaxType tinyint not null 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. TaxRate smallmoney not null ((0.00)) [...]
wikibot
Table Sales.StoreContact Description Cross-reference table mapping stores and their employees. Columns Column Data Type Nullable Default Description CustomerID int not null Store identification number. Foreign key to Customer.CustomerID. ContactID int not null Contact (store employee) identification number. Foreign key to Contact.ContactID. ContactTypeID int not null Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying [...]