Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Search the wiki
»

Search in all Namespaces and all Categories
Search Files and Attachments

Filter by Category

This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.2 seconds and yielded 30 results.

Sales (schema) — 7.9%

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 [...]

Sales SalesOrderHeader (table) — 6.0%

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 [...]

Production (schema) — 4.1%

[...] Description Contains objects related to products, inventory, and manufacturing. Source CREATE SCHEMA Production AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table Production.BillOfMaterials Schema Table Production.Culture Schema Table Production.Document Schema Table Production.Illustration Schema Table Production.Location Schema [...]

Sales SalesOrderDetail (table) — 3.8%

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 [...]

Database Objects AdventureWorks — 3.4%

[...] 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) [...]

Sales Individual (table) — 2.9%

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 [...]

HumanResources (schema) — 2.5%

wikibot Schema HumanResources Description Contains objects related to employees and departments. Source CREATE SCHEMA HumanResources AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table HumanResources.Department Schema Table HumanResources.Employee Schema Table HumanResources.EmployeeAddress Schema Table HumanResources.EmployeeDepartmentHistory [...]

Sales Store (table) — 2.3%

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 [...]

Sales SalesTerritory (table) — 2.1%

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 [...]

Sales SalesPerson (table) — 2.0%

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. [...]

Sales vStoreWithDemographics (view) — 1.9%

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] [...]

Person (schema) — 1.6%

wikibot Schema Person Description Contains objects related to names and addresses of customers, vendors, and employees Source CREATE SCHEMA Person AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object [...]

Sales vIndividualCustomer (view) — 1.6%

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] [...]

Sales vSalesPersonSalesByFiscalYears (view) — 1.6%

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] [...]

Sales IndividualSurveySchemaCollection (xml schema collection) — 1.6%

wikibot XML Schema Collection Sales.IndividualSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Individual table. Source [...]

Sales StoreSurveySchemaCollection (xml schema collection) — 1.6%

wikibot XML Schema Collection Sales.StoreSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Store table. Source [...]

Sales Customer (table) — 1.4%

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 [...]

Sales vSalesPerson (view) — 1.4%

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] [...]

Person Contact (table) — 1.3%

[...] 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 [...]

Sales SalesTerritoryHistory (table) — 1.3%

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 [...]

Purchasing (schema) — 1.3%

[...] Purchasing Description Contains objects related to vendors and purchase orders. Source CREATE SCHEMA Purchasing AUTHORIZATION dbo Dependencies Reference Type Object Type Referencing Object Schema Table Purchasing.ProductVendor Schema [...]

Sales SalesPersonQuotaHistory (table) — 1.2%

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. [...]

Sales Currency (table) — 1.1%

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 [...]

Sales vIndividualDemographics (view) — 1.1%

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 [...]

Sales SalesOrderHeaderSalesReason (table) — 1.1%

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 [...]

Sales SalesReason (table) — 1.1%

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 [...]

Person ContactType (table) — 1.1%

[...] 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 [...]

Sales CustomerAddress (table) — 1.0%

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 [...]

Production ProductDescriptionSchemaCollection (xml schema collection) — 1.0%

wikibot XML Schema Collection Production.ProductDescriptionSchemaCollection Description Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table. Source [...]

Person AdditionalContactInfoSchemaCollection (xml schema collection) — 1.0%

wikibot XML Schema Collection Person.AdditionalContactInfoSchemaCollection Description Collection of XML schemas for the AdditionalContactInfo column in the Person.Contact table. Source [...]