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
type dbo.Name Source
CREATE TYPE dbo.[Name] FROM nvarchar(100) NULL
Dependencies Reference Type Object Type Referencing Object Data Type Table HumanResources.Department Data Type [...]
[...] 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 was shipped to the customer. Status tinyint not null ((1)) Order current status. 1 = In process; 2 = [...]
[...] 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. 1 = Preferred over other vendors supplying the [...]
[...] 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 store type. rowguid uniqueidentifier not null (newid()) [...]
[...] Description Names of each employee, customer contact, and vendor contact. Columns Column Data Type Nullable Default Description ContactID int not null Primary key for Contact records. NameStyle dbo.NameStyle not null ((0)) 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. Title nvarchar(8) null A courtesy title. For example, Mr. or Ms. FirstName dbo.Name not null First name of the person. MiddleName dbo.Name null Middle name or middle initial of the [...]
wikibot
type dbo.Flag Source
CREATE TYPE dbo.Flag FROM bit NOT NULL
Dependencies Reference Type [...]
wikibot
Type OE.XDBPO_TYPE Source
CREATE OR REPLACE TYPE "XDBPO_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","Reference" VARCHAR2(30 CHAR),"ACTIONS" "XDBPO_ACTIONS_TYPE","REJECTION" [...]
[...] Table Person.StateProvince Description State and province lookup table. Columns Column Data Type Nullable Default Description StateProvinceID int not null Primary key for StateProvince records. StateProvinceCode nchar(3) not null ISO standard state or province code. CountryRegionCode nvarchar(3) not null ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. IsOnlyStateProvinceFlag dbo.Flag not null ((1)) 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. Name dbo.Name not null [...]
[...] Description Products sold or used in the manfacturing of sold products. Columns Column Data Type Nullable Default Description ProductID int not null Primary key for Product records. Name dbo.Name not null Name of the product. ProductNumber nvarchar(25) not null Unique product identification number. MakeFlag dbo.Flag not null ((1)) 0 = Product is purchased, 1 = Product is manufactured in-house. FinishedGoodsFlag dbo.Flag not null ((1)) 0 = Product is not a salable item. 1 = Product is salable. Color nvarchar(15) null Product color. SafetyStockLevel [...]
[...] 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 datetime not null (getdate()) Date and time the record was last updated. Primary [...]
[...] Table Production.ProductModel Description Product model classification. Columns Column Data Type Nullable Default Description ProductModelID int not null Primary key for ProductModel records. Name dbo.Name not null Product model description. CatalogDescription xml null Detailed product catalog information in xml format. Instructions xml null Manufacturing instructions in xml format. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime [...]
[...] Person.AddressType Description Types of addresses stored in the Address table. Columns Column Data Type Nullable Default Description AddressTypeID int not null Primary key for AddressType records. Name dbo.Name not null Address type description. For example, Billing, Home, or Shipping. 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 updated. Primary Key Primary [...]
[...] 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 money not null ((0.00)) Sales in the territory year to date. SalesLastYear money not null [...]
[...] Description Employee information such as salary, department, and title. Columns Column Data Type Nullable Default Description EmployeeID int not null Primary key for Employee records. NationalIDNumber nvarchar(15) not null Unique national identification number such as a social security number. ContactID int not null Identifies the employee in the Contact table. Foreign key to Contact.ContactID. LoginID nvarchar(256) not null Network login. ManagerID int null Manager to whom the employee is assigned. Foreign Key to Employee.M Title nvarchar(50) [...]
[...] 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 int not null Product sold to customer. Foreign key to Product.ProductID. SpecialOfferID [...]
[...] 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 number. Foreign key to Product.ProductID. UnitPrice money not null Vendor's [...]
[...] 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 Vendor with whom the purchase order is placed. [...]
[...] Description Lookup table containing the types of contacts stored in Contact. Columns Column Data Type Nullable Default Description ContactTypeID int not null Primary key for ContactType records. Name dbo.Name not null Contact type description. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ContactType_ContactTypeID ContactTypeID Indexes Index Type Columns AK_ContactType_Name Unique Name Detail Tables Detail [...]
[...] Lookup table containing the ISO standard codes for countries and regions. Columns Column Data Type Nullable Default Description CountryRegionCode nvarchar(3) not null ISO standard code for countries and regions. Name dbo.Name not null Country or region name. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_CountryRegion_CountryRegionCode CountryRegionCode Indexes Index Type Columns AK_CountryRegion_Name Unique Name Detail Tables Detail [...]
[...] (PM)
TEXTDOC_TYP (PM)
WAREHOUSE_TYP (OE)
XDBPO_ACTION_COLLECTION (OE)
XDBPO_ACTION_TYPE (OE)
XDBPO_ACTIONS_TYPE (OE)
XDBPO_LINEITEM_COLLECTION [...]
wikibot
type dbo.AccountNumber Source
CREATE TYPE dbo.AccountNumber FROM nvarchar(30) [...]
[...] wikibot
Table HumanResources.Shift Description Work shift lookup table. Columns Column Data Type Nullable Default Description ShiftID tinyint not null Primary key for Shift records. Name dbo.Name not null Shift description. StartTime datetime not null Shift start time. EndTime datetime not null Shift end time. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Shift_ShiftID ShiftID Indexes Index Type Columns AK_Shift_Name Unique [...]
[...] table containing the departments within the Adventure Works Cycles company. Columns Column Data Type Nullable Default Description DepartmentID smallint not null Primary key for Department records. Name dbo.Name not null Name of the department. GroupName dbo.Name not null Name of the group to which the department belongs. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Department_DepartmentID DepartmentID Indexes Index Type Columns AK_Department_Name [...]
wikibot
type dbo.NameStyle Source
CREATE TYPE dbo.NameStyle [...]
[...] HumanResources.JobCandidate Description Résumés submitted to Human Resources by job applicants. Columns Column Data Type Nullable Default Description JobCandidateID int not null Primary key for JobCandidate records. EmployeeID int null Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. Resume xml null Résumé in XML format. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_JobCandidate_JobCandidateID JobCandidateID Indexes Index Type [...]
wikibot
Type OE.XDBPO_LINEITEM_TYPE Source
CREATE OR REPLACE TYPE "XDBPO_LINEITEM_
[...] each purchase order, sales order, or work order transaction year to date. Columns Column Data Type Nullable Default Description TransactionID int not null Primary key for TransactionHistory records. ProductID int not null Product identification number. Foreign key to Product.ProductID. ReferenceOrderID int not null Purchase order, sales order, or work order identification number. ReferenceOrderLineID int not null ((0)) Line number associated with the purchase order, sales order, or work order. TransactionDate datetime not null (getdate()) Date and [...]
[...] 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 the [...]
wikibot
type dbo.Phone Source
CREATE TYPE dbo.Phone [...]
[...] 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. SalesYTD money not null ((0.00)) Sales total year to date. SalesLastYear [...]