Field Report

bit

• Discontinued (Products)

datetime

• BirthDate (Employees)
• HireDate (Employees)
• OrderDate (Orders)
• RequiredDate (Orders)
• ShippedDate (Orders)

image

• Picture (Categories)
• Photo (Employees)

int

• CategoryID (Categories)
• EmployeeID (Employees)
• ReportsTo (Employees)
• EmployeeID (EmployeeTerritories)
• OrderID (Order Details)
• ProductID (Order Details)
• OrderID (Orders)
• EmployeeID (Orders)
• ShipVia (Orders)
• ProductID (Products)
• SupplierID (Products)
• CategoryID (Products)
• RegionID (Region)
• ShipperID (Shippers)
• SupplierID (Suppliers)
• RegionID (Territories)

money

• UnitPrice (Order Details)
• Freight (Orders)
• UnitPrice (Products)

nchar

• CustomerID (CustomerCustomerDemo)
• CustomerTypeID (CustomerCustomerDemo)
• CustomerTypeID (CustomerDemographics)
• CustomerID (Customers)
• CustomerID (Orders)
• RegionDescription (Region)
• TerritoryDescription (Territories)

ntext

• Description (Categories)
• CustomerDesc (CustomerDemographics)
• Notes (Employees)
• HomePage (Suppliers)

nvarchar

• CategoryName (Categories)
• CompanyName (Customers)
• ContactName (Customers)
• ContactTitle (Customers)
• Address (Customers)
• City (Customers)
• Region (Customers)
• PostalCode (Customers)
• Country (Customers)
• Phone (Customers)
• Fax (Customers)
• LastName (Employees)
• FirstName (Employees)
• Title (Employees)
• TitleOfCourtesy (Employees)
• Address (Employees)
• City (Employees)
• Region (Employees)
• PostalCode (Employees)
• Country (Employees)
• HomePhone (Employees)
• Extension (Employees)
• PhotoPath (Employees)
• TerritoryID (EmployeeTerritories)
• ShipName (Orders)
• ShipAddress (Orders)
• ShipCity (Orders)
• ShipRegion (Orders)
• ShipPostalCode (Orders)
• ShipCountry (Orders)
• ProductName (Products)
• QuantityPerUnit (Products)
• CompanyName (Shippers)
• Phone (Shippers)
• CompanyName (Suppliers)
• ContactName (Suppliers)
• ContactTitle (Suppliers)
• Address (Suppliers)
• City (Suppliers)
• Region (Suppliers)
• PostalCode (Suppliers)
• Country (Suppliers)
• Phone (Suppliers)
• Fax (Suppliers)
• TerritoryID (Territories)

real

• Discount (Order Details)

smallint

• Quantity (Order Details)
• UnitsInStock (Products)
• UnitsOnOrder (Products)
• ReorderLevel (Products)