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.0 seconds and yielded 28 results.

Purchasing PurchaseOrderDetail (table) — 25.2%

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

Purchasing PurchaseOrderHeader (table) — 11.3%

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

Purchasing (schema) — 7.5%

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

Purchasing vVendor (view) — 6.9%

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

Purchasing Vendor (table) — 6.9%

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

Database Objects AdventureWorks — 5.7%

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

Purchasing VendorContact (table) — 3.8%

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

Purchasing ShipMethod (table) — 3.8%

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

Purchasing VendorAddress (table) — 3.8%

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

Purchasing ProductVendor (table) — 3.1%

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

dbo uspPrintError (procedure) — 2.5%

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

dbo uspLogError (procedure) — 2.5%

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

Person ContactType (table) — 2.5%

[...] 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 Table Values Person.ContactType ContactTypeID [...]

dbo ufnGetContactInformation (function) — 2.5%

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

Production TransactionHistory (table) — 1.3%

[...] Production.WorkOrder Trigger iWorkOrder Insert Table Production.WorkOrder Trigger uWorkOrder Insert Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Insert Table Purchasing.PurchaseOrderDetail [...]

Person Address (table) — 1.3%

[...] 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 View HumanResources.vEmployee Select View Purchasing.vVendor [...]

Person Contact (table) — 1.3%

[...] 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 Select View HumanResources.vEmployeeDepartment Select View HumanResources.vEmployeeDepartmentHistory [...]

dbo Name (type) — 1.3%

[...] Data Type Table Production.ScrapReason Data Type Table Production.UnitMeasure Data Type Table Purchasing.ShipMethod Data Type Table Purchasing.Vendor [...]

Production Product (table) — 1.3%

[...] Production.ProductProductPhoto ProductID ProductID Production.ProductReview ProductID ProductID Purchasing.ProductVendor ProductID ProductID Purchasing.PurchaseOrderDetail [...]

Sales SalesOrderHeader (table) — 0.6%

[...] Sales.SalesPerson SalesPersonID SalesPersonID Sales.SalesTerritory TerritoryID TerritoryID Purchasing.ShipMethod ShipMethodID ShipMethodID Detail [...]

Sales StoreContact (table) — 0.6%

[...] number. Foreign key to Contact.ContactID. ContactTypeID int not null Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID. [...]

HumanResources Employee (table) — 0.6%

[...] HumanResources.EmployeePayHistory EmployeeID EmployeeID HumanResources.JobCandidate EmployeeID EmployeeID Purchasing.PurchaseOrderHeader EmployeeID EmployeeID [...]

dbo Flag (type) — 0.6%

[...] Type Table Production.Product Data Type Table Production.ProductProductPhoto Data Type Table Purchasing.Vendor Data Type Table Sales.SalesOrderHeader [...]

dbo AccountNumber (type) — 0.6%

[...] nvarchar(30) NULL Dependencies Reference Type Object Type Referencing Object Data Type Table Purchasing.Vendor Data Type Table Sales.SalesOrderHeader [...]

Person AddressType (table) — 0.6%

[...] Tables Detail Table Column Referencing Column Sales.CustomerAddress AddressTypeID AddressTypeID Purchasing.VendorAddress AddressTypeID AddressTypeID [...]

Production UnitMeasure (table) — 0.6%

[...] UnitMeasureCode SizeUnitMeasureCode Production.Product UnitMeasureCode WeightUnitMeasureCode Purchasing.ProductVendor UnitMeasureCode UnitMeasureCode [...]

Person StateProvince (table) — 0.6%

[...] Select View HumanResources.vEmployee Select View Person.vStateProvinceCountryRegion Select View Purchasing.vVendor Select View Sales.vIndividualCustomer [...]

Person CountryRegion (table) — 0.6%

[...] Select View HumanResources.vEmployee Select View Person.vStateProvinceCountryRegion Select View Purchasing.vVendor Select View Sales.vIndividualCustomer [...]