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 Purchasing.PurchaseOrderDetail Description Individual products associated with a specific purchase order. See PurchaseOrderHeader. Columns Column Data Type Nullable Default Description PurchaseOrderID int not null Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. PurchaseOrderDetailID int not null Primary key. One line number per purchased product. DueDate datetime not null Date the product is expected to be received. OrderQty smallint not null Quantity ordered. ProductID int not null Product identification [...]
[...] 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 [...]
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 Schema [...]
wikibot
Schema Purchasing Description Contains objects [...]
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 [...]
wikibot
Table Purchasing.PurchaseOrderHeader Description General purchase order information. See PurchaseOrderDetail. Columns Column Data Type Nullable Default Description PurchaseOrderID int not null Primary key. RevisionNumber tinyint not null ((0)) Incremental number to track changes to the purchase order over time. Status tinyint not null ((1)) Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete EmployeeID int not null Employee who created the purchase order. Foreign key to Employee.EmployeeID. VendorID int not null [...]
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 Schema [...]
wikibot
View Purchasing.vVendor Description Vendor (company) names and addresses and the names of vendor employees to contact. Source
CREATE VIEW [Purchasing].[vVendor] AS
SELECT
v.[VendorID]
,v.[Name]
,ct.[Name] AS [ContactType]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,[StateProvinceName] = sp.[Name]
,a.[PostalCode]
,[CountryRegionName] = cr.[Name]
FROM [...]
wikibot
Table Purchasing.Vendor Description Companies from whom Adventure Works Cycles purchases parts or other goods. Columns Column Data Type Nullable Default Description VendorID int not null Primary key for Vendor records. AccountNumber dbo.AccountNumber not null Vendor account (identification) number. Name dbo.Name not null Company name. CreditRating tinyint not null 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average PreferredVendorStatus dbo.Flag not null ((1)) 0 = Do not use if another vendor is available. [...]
[...] (Production)
ProductReview (Production)
ProductSubcategory (Production)
ProductVendor (Purchasing)
PurchaseOrderDetail (Purchasing)
PurchaseOrderHeader (Purchasing)
SalesOrderDetail (Sales)
SalesOrderHeader (Sales)
SalesOrderHeaderSalesReason (Sales)
SalesPerson (Sales)
SalesPersonQuotaHistory (Sales)
SalesReason (Sales)
SalesTaxRate (Sales)
SalesTerritory (Sales)
SalesTerritoryHistory (Sales)
ScrapReason (Production)
Shift (HumanResources) [...]
wikibot
Table Purchasing.VendorAddress Description Cross-reference mapping vendors and addresses. Columns Column Data Type Nullable Default Description VendorID int not null Primary key. Foreign key to Vendor.VendorID. AddressID int not null Primary key. Foreign key to Address.AddressID. AddressTypeID int not null Address type. Foreign key to AddressType.AddressTypeID. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_VendorAddress_VendorID_AddressID VendorID, AddressID [...]
wikibot
Table Purchasing.VendorContact Description Cross-reference table mapping vendors and their employees. Columns Column Data Type Nullable Default Description VendorID int not null Primary key. ContactID int not null Contact (Vendor employee) identification number. Foreign key to Contact.ContactID. ContactTypeID int not null Contact type such as sales manager, or sales agent. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_VendorContact_VendorID_ContactID [...]
wikibot
Table Purchasing.ShipMethod Description Shipping company lookup table. Columns Column Data Type Nullable Default Description ShipMethodID int not null Primary key for ShipMethod records. Name dbo.Name not null Shipping company name. ShipBase money not null ((0.00)) Minimum shipping charge. ShipRate money not null ((0.00)) Shipping charge per pound. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date [...]
wikibot
Table Purchasing.ProductVendor Description Cross-reference table mapping vendors with the products they supply. Columns Column Data Type Nullable Default Description ProductID int not null Primary key. Foreign key to Product.ProductID. VendorID int not null Primary key. Foreign key to Vendor.VendorID. AverageLeadTime int not null The average span of time (in days) between placing an order with the vendor and receiving the purchased product. StandardPrice money not null The vendor's usual selling price. LastReceiptCost money null [...]
[...] DATABASE
FOR DDL_DATABASE_LEVEL_EVENTS AS
BEGIN
SET NOCOUNT ON;
DECLARE @data XML;
DECLARE @schema sysname;
DECLARE @object sysname;
DECLARE @eventType sysname;
SET @data = EVENTDATA();
SET @eventType = @data.value('(/EVENT_INSTANCE/EventType)[1]', 'sysname');
SET @schema = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'sysname');
SET @object = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'sysname')
IF @object IS NOT NULL
PRINT ' ' + @eventType + ' - ' + @schema + '.' [...]
[...] 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 [...]
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
XML Schema Collection Production.ProductDescriptionSchemaCollection Description Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table. Source
References Dependency Type Object Type Referenced Object [...]
wikibot
XML Schema Collection Person.AdditionalContactInfoSchemaCollection Description Collection of XML schemas for the AdditionalContactInfo column in the Person.Contact table. Source
References Dependency Type Object Type Referenced Object [...]
wikibot
XML Schema Collection Sales.StoreSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Store table. Source
References [...]
wikibot
XML Schema Collection HumanResources.HRResumeSchemaCollection Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. Source
[...]
wikibot
XML Schema Collection Production.ManuInstructionsSchemaCollection Description Collection of XML schemas for the Instructions column in the Production.ProductModel table. Source
References Dependency Type [...]
[...] 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 Data Type Type dbo.Phone Schema Schema Person Data Type XML Schema Collection Person.AdditionalContactInfoSchemaCollection Dependencies Reference Type Object Type Referencing Object Select View HumanResources.vEmployee [...]
[...] Production.ProductProductPhoto ProductID ProductID Production.ProductReview ProductID ProductID Purchasing.ProductVendor ProductID ProductID Purchasing.PurchaseOrderDetail ProductID ProductID Sales.ShoppingCartItem ProductID ProductID Sales.SpecialOfferProduct ProductID ProductID Production.TransactionHistory ProductID ProductID Production.WorkOrder ProductID ProductID References Dependency Type Object Type Referenced Object [...]
[...] ProductModelID References Dependency Type Object Type Referenced Object Data Type Type dbo.Name Schema Schema Production Data Type XML Schema [...]
[...] Production.Product ProductID ProductID References Dependency Type Object Type Referenced Object Schema Schema Production Dependencies Reference Type Object Type Referencing Object Child Type Child Object Insert Table Production.WorkOrder Trigger iWorkOrder Insert Table Production.WorkOrder Trigger uWorkOrder Insert Table Purchasing.PurchaseOrderDetail [...]
[...] Production.WorkOrder Trigger iWorkOrder Execute Table Production.WorkOrder Trigger uWorkOrder Execute Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderDetail Trigger uPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderHeader [...]
[...] Production.WorkOrder Trigger iWorkOrder Execute Table Production.WorkOrder Trigger uWorkOrder Execute Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderDetail Trigger uPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderHeader [...]
[...] 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 [...]
[...] WHERE [ContactID] = @ContactID)
-- Check for vendor
WHEN EXISTS(SELECT * FROM [Purchasing].[VendorContact] vc
INNER JOIN [Person].[ContactType] ct
ON vc.[ContactTypeID] = ct.[ContactTypeID]
WHERE vc.[ContactID] = @ContactID)
THEN (SELECT ct.[Name]
FROM [Purchasing].[VendorContact] vc
INNER JOIN [Person].[ContactType] ct
ON vc.[ContactTypeID] = ct.[ContactTypeID]
WHERE vc.[ContactID] = @ContactID)
-- Check for store
[...]