Field Report

AccountNumber

• AccountNumber (Purchasing.Vendor)
• AccountNumber (Sales.SalesOrderHeader)

bit

• FolderFlag (Production.Document)

date

• BirthDate (HumanResources.Employee)
• HireDate (HumanResources.Employee)
• StartDate (HumanResources.EmployeeDepartmentHistory)
• EndDate (HumanResources.EmployeeDepartmentHistory)

datetime

• VersionDate (AWBuildVersion)
• ModifiedDate (AWBuildVersion)
• PostTime (DatabaseLog)
• ErrorTime (ErrorLog)
• ModifiedDate (HumanResources.Department)
• ModifiedDate (HumanResources.Employee)
• ModifiedDate (HumanResources.EmployeeDepartmentHistory)
• RateChangeDate (HumanResources.EmployeePayHistory)
• ModifiedDate (HumanResources.EmployeePayHistory)
• ModifiedDate (HumanResources.JobCandidate)
• ModifiedDate (HumanResources.Shift)
• ModifiedDate (Person.Address)
• ModifiedDate (Person.AddressType)
• ModifiedDate (Person.BusinessEntity)
• ModifiedDate (Person.BusinessEntityAddress)
• ModifiedDate (Person.BusinessEntityContact)
• ModifiedDate (Person.ContactType)
• ModifiedDate (Person.CountryRegion)
• ModifiedDate (Person.EmailAddress)
• ModifiedDate (Person.Password)
• ModifiedDate (Person.Person)
• ModifiedDate (Person.PersonPhone)
• ModifiedDate (Person.PhoneNumberType)
• ModifiedDate (Person.StateProvince)
• StartDate (Production.BillOfMaterials)
• EndDate (Production.BillOfMaterials)
• ModifiedDate (Production.BillOfMaterials)
• ModifiedDate (Production.Culture)
• ModifiedDate (Production.Document)
• ModifiedDate (Production.Illustration)
• ModifiedDate (Production.Location)
• SellStartDate (Production.Product)
• SellEndDate (Production.Product)
• DiscontinuedDate (Production.Product)
• ModifiedDate (Production.Product)
• ModifiedDate (Production.ProductCategory)
• StartDate (Production.ProductCostHistory)
• EndDate (Production.ProductCostHistory)
• ModifiedDate (Production.ProductCostHistory)
• ModifiedDate (Production.ProductDescription)
• ModifiedDate (Production.ProductDocument)
• ModifiedDate (Production.ProductInventory)
• StartDate (Production.ProductListPriceHistory)
• EndDate (Production.ProductListPriceHistory)
• ModifiedDate (Production.ProductListPriceHistory)
• ModifiedDate (Production.ProductModel)
• ModifiedDate (Production.ProductModelIllustration)
• ModifiedDate (Production.ProductModelProductDescriptionCulture)
• ModifiedDate (Production.ProductPhoto)
• ModifiedDate (Production.ProductProductPhoto)
• ReviewDate (Production.ProductReview)
• ModifiedDate (Production.ProductReview)
• ModifiedDate (Production.ProductSubcategory)
• ModifiedDate (Production.ScrapReason)
• TransactionDate (Production.TransactionHistory)
• ModifiedDate (Production.TransactionHistory)
• TransactionDate (Production.TransactionHistoryArchive)
• ModifiedDate (Production.TransactionHistoryArchive)
• ModifiedDate (Production.UnitMeasure)
• StartDate (Production.WorkOrder)
• EndDate (Production.WorkOrder)
• DueDate (Production.WorkOrder)
• ModifiedDate (Production.WorkOrder)
• ScheduledStartDate (Production.WorkOrderRouting)
• ScheduledEndDate (Production.WorkOrderRouting)
• ActualStartDate (Production.WorkOrderRouting)
• ActualEndDate (Production.WorkOrderRouting)
• ModifiedDate (Production.WorkOrderRouting)
• LastReceiptDate (Purchasing.ProductVendor)
• ModifiedDate (Purchasing.ProductVendor)
• DueDate (Purchasing.PurchaseOrderDetail)
• ModifiedDate (Purchasing.PurchaseOrderDetail)
• OrderDate (Purchasing.PurchaseOrderHeader)
• ShipDate (Purchasing.PurchaseOrderHeader)
• ModifiedDate (Purchasing.PurchaseOrderHeader)
• ModifiedDate (Purchasing.ShipMethod)
• ModifiedDate (Purchasing.Vendor)
• ModifiedDate (Sales.CountryRegionCurrency)
• ModifiedDate (Sales.CreditCard)
• ModifiedDate (Sales.Currency)
• CurrencyRateDate (Sales.CurrencyRate)
• ModifiedDate (Sales.CurrencyRate)
• ModifiedDate (Sales.Customer)
• ModifiedDate (Sales.PersonCreditCard)
• ModifiedDate (Sales.SalesOrderDetail)
• OrderDate (Sales.SalesOrderHeader)
• DueDate (Sales.SalesOrderHeader)
• ShipDate (Sales.SalesOrderHeader)
• ModifiedDate (Sales.SalesOrderHeader)
• ModifiedDate (Sales.SalesOrderHeaderSalesReason)
• ModifiedDate (Sales.SalesPerson)
• QuotaDate (Sales.SalesPersonQuotaHistory)
• ModifiedDate (Sales.SalesPersonQuotaHistory)
• ModifiedDate (Sales.SalesReason)
• ModifiedDate (Sales.SalesTaxRate)
• ModifiedDate (Sales.SalesTerritory)
• StartDate (Sales.SalesTerritoryHistory)
• EndDate (Sales.SalesTerritoryHistory)
• ModifiedDate (Sales.SalesTerritoryHistory)
• DateCreated (Sales.ShoppingCartItem)
• ModifiedDate (Sales.ShoppingCartItem)
• StartDate (Sales.SpecialOffer)
• EndDate (Sales.SpecialOffer)
• ModifiedDate (Sales.SpecialOffer)
• ModifiedDate (Sales.SpecialOfferProduct)
• ModifiedDate (Sales.Store)

decimal

• PerAssemblyQty (Production.BillOfMaterials)
• Availability (Production.Location)
• Weight (Production.Product)
• ActualResourceHrs (Production.WorkOrderRouting)
• ReceivedQty (Purchasing.PurchaseOrderDetail)
• RejectedQty (Purchasing.PurchaseOrderDetail)
• StockedQty (Purchasing.PurchaseOrderDetail)

Flag

• SalariedFlag (HumanResources.Employee)
• CurrentFlag (HumanResources.Employee)
• IsOnlyStateProvinceFlag (Person.StateProvince)
• MakeFlag (Production.Product)
• FinishedGoodsFlag (Production.Product)
• Primary (Production.ProductProductPhoto)
• PreferredVendorStatus (Purchasing.Vendor)
• ActiveFlag (Purchasing.Vendor)
• OnlineOrderFlag (Sales.SalesOrderHeader)

geography

• SpatialLocation (Person.Address)

hierarchyid

• OrganizationNode (HumanResources.Employee)
• DocumentNode (Production.Document)
• DocumentNode (Production.ProductDocument)

int

• DatabaseLogID (DatabaseLog)
• ErrorLogID (ErrorLog)
• ErrorNumber (ErrorLog)
• ErrorSeverity (ErrorLog)
• ErrorState (ErrorLog)
• ErrorLine (ErrorLog)
• BusinessEntityID (HumanResources.Employee)
• BusinessEntityID (HumanResources.EmployeeDepartmentHistory)
• BusinessEntityID (HumanResources.EmployeePayHistory)
• JobCandidateID (HumanResources.JobCandidate)
• BusinessEntityID (HumanResources.JobCandidate)
• AddressID (Person.Address)
• StateProvinceID (Person.Address)
• AddressTypeID (Person.AddressType)
• BusinessEntityID (Person.BusinessEntity)
• BusinessEntityID (Person.BusinessEntityAddress)
• AddressID (Person.BusinessEntityAddress)
• AddressTypeID (Person.BusinessEntityAddress)
• BusinessEntityID (Person.BusinessEntityContact)
• PersonID (Person.BusinessEntityContact)
• ContactTypeID (Person.BusinessEntityContact)
• ContactTypeID (Person.ContactType)
• BusinessEntityID (Person.EmailAddress)
• EmailAddressID (Person.EmailAddress)
• BusinessEntityID (Person.Password)
• BusinessEntityID (Person.Person)
• EmailPromotion (Person.Person)
• BusinessEntityID (Person.PersonPhone)
• PhoneNumberTypeID (Person.PersonPhone)
• PhoneNumberTypeID (Person.PhoneNumberType)
• StateProvinceID (Person.StateProvince)
• TerritoryID (Person.StateProvince)
• BillOfMaterialsID (Production.BillOfMaterials)
• ProductAssemblyID (Production.BillOfMaterials)
• ComponentID (Production.BillOfMaterials)
• Owner (Production.Document)
• ChangeNumber (Production.Document)
• IllustrationID (Production.Illustration)
• ProductID (Production.Product)
• DaysToManufacture (Production.Product)
• ProductSubcategoryID (Production.Product)
• ProductModelID (Production.Product)
• ProductCategoryID (Production.ProductCategory)
• ProductID (Production.ProductCostHistory)
• ProductDescriptionID (Production.ProductDescription)
• ProductID (Production.ProductDocument)
• ProductID (Production.ProductInventory)
• ProductID (Production.ProductListPriceHistory)
• ProductModelID (Production.ProductModel)
• ProductModelID (Production.ProductModelIllustration)
• IllustrationID (Production.ProductModelIllustration)
• ProductModelID (Production.ProductModelProductDescriptionCulture)
• ProductDescriptionID (Production.ProductModelProductDescriptionCulture)
• ProductPhotoID (Production.ProductPhoto)
• ProductID (Production.ProductProductPhoto)
• ProductPhotoID (Production.ProductProductPhoto)
• ProductReviewID (Production.ProductReview)
• ProductID (Production.ProductReview)
• Rating (Production.ProductReview)
• ProductSubcategoryID (Production.ProductSubcategory)
• ProductCategoryID (Production.ProductSubcategory)
• TransactionID (Production.TransactionHistory)
• ProductID (Production.TransactionHistory)
• ReferenceOrderID (Production.TransactionHistory)
• ReferenceOrderLineID (Production.TransactionHistory)
• Quantity (Production.TransactionHistory)
• TransactionID (Production.TransactionHistoryArchive)
• ProductID (Production.TransactionHistoryArchive)
• ReferenceOrderID (Production.TransactionHistoryArchive)
• ReferenceOrderLineID (Production.TransactionHistoryArchive)
• Quantity (Production.TransactionHistoryArchive)
• WorkOrderID (Production.WorkOrder)
• ProductID (Production.WorkOrder)
• OrderQty (Production.WorkOrder)
• StockedQty (Production.WorkOrder)
• WorkOrderID (Production.WorkOrderRouting)
• ProductID (Production.WorkOrderRouting)
• ProductID (Purchasing.ProductVendor)
• BusinessEntityID (Purchasing.ProductVendor)
• AverageLeadTime (Purchasing.ProductVendor)
• MinOrderQty (Purchasing.ProductVendor)
• MaxOrderQty (Purchasing.ProductVendor)
• OnOrderQty (Purchasing.ProductVendor)
• PurchaseOrderID (Purchasing.PurchaseOrderDetail)
• PurchaseOrderDetailID (Purchasing.PurchaseOrderDetail)
• ProductID (Purchasing.PurchaseOrderDetail)
• PurchaseOrderID (Purchasing.PurchaseOrderHeader)
• EmployeeID (Purchasing.PurchaseOrderHeader)
• VendorID (Purchasing.PurchaseOrderHeader)
• ShipMethodID (Purchasing.PurchaseOrderHeader)
• ShipMethodID (Purchasing.ShipMethod)
• BusinessEntityID (Purchasing.Vendor)
• CreditCardID (Sales.CreditCard)
• CurrencyRateID (Sales.CurrencyRate)
• CustomerID (Sales.Customer)
• PersonID (Sales.Customer)
• StoreID (Sales.Customer)
• TerritoryID (Sales.Customer)
• BusinessEntityID (Sales.PersonCreditCard)
• CreditCardID (Sales.PersonCreditCard)
• SalesOrderID (Sales.SalesOrderDetail)
• SalesOrderDetailID (Sales.SalesOrderDetail)
• ProductID (Sales.SalesOrderDetail)
• SpecialOfferID (Sales.SalesOrderDetail)
• SalesOrderID (Sales.SalesOrderHeader)
• CustomerID (Sales.SalesOrderHeader)
• SalesPersonID (Sales.SalesOrderHeader)
• TerritoryID (Sales.SalesOrderHeader)
• BillToAddressID (Sales.SalesOrderHeader)
• ShipToAddressID (Sales.SalesOrderHeader)
• ShipMethodID (Sales.SalesOrderHeader)
• CreditCardID (Sales.SalesOrderHeader)
• CurrencyRateID (Sales.SalesOrderHeader)
• SalesOrderID (Sales.SalesOrderHeaderSalesReason)
• SalesReasonID (Sales.SalesOrderHeaderSalesReason)
• BusinessEntityID (Sales.SalesPerson)
• TerritoryID (Sales.SalesPerson)
• BusinessEntityID (Sales.SalesPersonQuotaHistory)
• SalesReasonID (Sales.SalesReason)
• SalesTaxRateID (Sales.SalesTaxRate)
• StateProvinceID (Sales.SalesTaxRate)
• TerritoryID (Sales.SalesTerritory)
• BusinessEntityID (Sales.SalesTerritoryHistory)
• TerritoryID (Sales.SalesTerritoryHistory)
• ShoppingCartItemID (Sales.ShoppingCartItem)
• Quantity (Sales.ShoppingCartItem)
• ProductID (Sales.ShoppingCartItem)
• SpecialOfferID (Sales.SpecialOffer)
• MinQty (Sales.SpecialOffer)
• MaxQty (Sales.SpecialOffer)
• SpecialOfferID (Sales.SpecialOfferProduct)
• ProductID (Sales.SpecialOfferProduct)
• BusinessEntityID (Sales.Store)
• SalesPersonID (Sales.Store)

money

• Rate (HumanResources.EmployeePayHistory)
• StandardCost (Production.Product)
• ListPrice (Production.Product)
• StandardCost (Production.ProductCostHistory)
• ListPrice (Production.ProductListPriceHistory)
• ActualCost (Production.TransactionHistory)
• ActualCost (Production.TransactionHistoryArchive)
• PlannedCost (Production.WorkOrderRouting)
• ActualCost (Production.WorkOrderRouting)
• StandardPrice (Purchasing.ProductVendor)
• LastReceiptCost (Purchasing.ProductVendor)
• UnitPrice (Purchasing.PurchaseOrderDetail)
• LineTotal (Purchasing.PurchaseOrderDetail)
• SubTotal (Purchasing.PurchaseOrderHeader)
• TaxAmt (Purchasing.PurchaseOrderHeader)
• Freight (Purchasing.PurchaseOrderHeader)
• TotalDue (Purchasing.PurchaseOrderHeader)
• ShipBase (Purchasing.ShipMethod)
• ShipRate (Purchasing.ShipMethod)
• AverageRate (Sales.CurrencyRate)
• EndOfDayRate (Sales.CurrencyRate)
• UnitPrice (Sales.SalesOrderDetail)
• UnitPriceDiscount (Sales.SalesOrderDetail)
• SubTotal (Sales.SalesOrderHeader)
• TaxAmt (Sales.SalesOrderHeader)
• Freight (Sales.SalesOrderHeader)
• TotalDue (Sales.SalesOrderHeader)
• SalesQuota (Sales.SalesPerson)
• Bonus (Sales.SalesPerson)
• SalesYTD (Sales.SalesPerson)
• SalesLastYear (Sales.SalesPerson)
• SalesQuota (Sales.SalesPersonQuotaHistory)
• SalesYTD (Sales.SalesTerritory)
• SalesLastYear (Sales.SalesTerritory)
• CostYTD (Sales.SalesTerritory)
• CostLastYear (Sales.SalesTerritory)

Name

• Name (HumanResources.Department)
• GroupName (HumanResources.Department)
• Name (HumanResources.Shift)
• Name (Person.AddressType)
• Name (Person.ContactType)
• Name (Person.CountryRegion)
• FirstName (Person.Person)
• MiddleName (Person.Person)
• LastName (Person.Person)
• Name (Person.PhoneNumberType)
• Name (Person.StateProvince)
• Name (Production.Culture)
• Name (Production.Location)
• Name (Production.Product)
• Name (Production.ProductCategory)
• Name (Production.ProductModel)
• ReviewerName (Production.ProductReview)
• Name (Production.ProductSubcategory)
• Name (Production.ScrapReason)
• Name (Production.UnitMeasure)
• Name (Purchasing.ShipMethod)
• Name (Purchasing.Vendor)
• Name (Sales.Currency)
• Name (Sales.SalesReason)
• ReasonType (Sales.SalesReason)
• Name (Sales.SalesTaxRate)
• Name (Sales.SalesTerritory)
• Name (Sales.Store)

NameStyle

• NameStyle (Person.Person)

nchar

• MaritalStatus (HumanResources.Employee)
• Gender (HumanResources.Employee)
• PersonType (Person.Person)
• StateProvinceCode (Person.StateProvince)
• UnitMeasureCode (Production.BillOfMaterials)
• CultureID (Production.Culture)
• Revision (Production.Document)
• SizeUnitMeasureCode (Production.Product)
• WeightUnitMeasureCode (Production.Product)
• ProductLine (Production.Product)
• Class (Production.Product)
• Style (Production.Product)
• CultureID (Production.ProductModelProductDescriptionCulture)
• TransactionType (Production.TransactionHistory)
• TransactionType (Production.TransactionHistoryArchive)
• UnitMeasureCode (Production.UnitMeasure)
• UnitMeasureCode (Purchasing.ProductVendor)
• CurrencyCode (Sales.CountryRegionCurrency)
• CurrencyCode (Sales.Currency)
• FromCurrencyCode (Sales.CurrencyRate)
• ToCurrencyCode (Sales.CurrencyRate)

numeric

• LineTotal (Sales.SalesOrderDetail)

nvarchar

• Database Version (AWBuildVersion)
• ErrorProcedure (ErrorLog)
• ErrorMessage (ErrorLog)
• NationalIDNumber (HumanResources.Employee)
• LoginID (HumanResources.Employee)
• JobTitle (HumanResources.Employee)
• AddressLine1 (Person.Address)
• AddressLine2 (Person.Address)
• City (Person.Address)
• PostalCode (Person.Address)
• CountryRegionCode (Person.CountryRegion)
• EmailAddress (Person.EmailAddress)
• Title (Person.Person)
• Suffix (Person.Person)
• CountryRegionCode (Person.StateProvince)
• Title (Production.Document)
• FileName (Production.Document)
• FileExtension (Production.Document)
• ProductNumber (Production.Product)
• Color (Production.Product)
• Size (Production.Product)
• Description (Production.ProductDescription)
• Shelf (Production.ProductInventory)
• ThumbnailPhotoFileName (Production.ProductPhoto)
• LargePhotoFileName (Production.ProductPhoto)
• EmailAddress (Production.ProductReview)
• Comments (Production.ProductReview)
• PurchasingWebServiceURL (Purchasing.Vendor)
• CountryRegionCode (Sales.CountryRegionCurrency)
• CardType (Sales.CreditCard)
• CardNumber (Sales.CreditCard)
• CarrierTrackingNumber (Sales.SalesOrderDetail)
• SalesOrderNumber (Sales.SalesOrderHeader)
• Comment (Sales.SalesOrderHeader)
• CountryRegionCode (Sales.SalesTerritory)
• Group (Sales.SalesTerritory)
• ShoppingCartID (Sales.ShoppingCartItem)
• Description (Sales.SpecialOffer)
• Type (Sales.SpecialOffer)
• Category (Sales.SpecialOffer)

nvarchar (MAX)

• TSQL (DatabaseLog)
• DocumentSummary (Production.Document)

OrderNumber

• PurchaseOrderNumber (Sales.SalesOrderHeader)

Phone

• PhoneNumber (Person.PersonPhone)

smallint

• DepartmentID (HumanResources.Department)
• OrganizationLevel (HumanResources.Employee)
• VacationHours (HumanResources.Employee)
• SickLeaveHours (HumanResources.Employee)
• DepartmentID (HumanResources.EmployeeDepartmentHistory)
• BOMLevel (Production.BillOfMaterials)
• DocumentLevel (Production.Document)
• LocationID (Production.Location)
• SafetyStockLevel (Production.Product)
• ReorderPoint (Production.Product)
• LocationID (Production.ProductInventory)
• Quantity (Production.ProductInventory)
• ScrapReasonID (Production.ScrapReason)
• ScrappedQty (Production.WorkOrder)
• ScrapReasonID (Production.WorkOrder)
• OperationSequence (Production.WorkOrderRouting)
• LocationID (Production.WorkOrderRouting)
• OrderQty (Purchasing.PurchaseOrderDetail)
• ExpYear (Sales.CreditCard)
• OrderQty (Sales.SalesOrderDetail)

smallmoney

• CostRate (Production.Location)
• CommissionPct (Sales.SalesPerson)
• TaxRate (Sales.SalesTaxRate)
• DiscountPct (Sales.SpecialOffer)

sysname

• DatabaseUser (DatabaseLog)
• Event (DatabaseLog)
• Schema (DatabaseLog)
• Object (DatabaseLog)
• UserName (ErrorLog)

time

• StartTime (HumanResources.Shift)
• EndTime (HumanResources.Shift)

tinyint

• SystemInformationID (AWBuildVersion)
• ShiftID (HumanResources.EmployeeDepartmentHistory)
• PayFrequency (HumanResources.EmployeePayHistory)
• ShiftID (HumanResources.Shift)
• Status (Production.Document)
• Bin (Production.ProductInventory)
• RevisionNumber (Purchasing.PurchaseOrderHeader)
• Status (Purchasing.PurchaseOrderHeader)
• CreditRating (Purchasing.Vendor)
• ExpMonth (Sales.CreditCard)
• RevisionNumber (Sales.SalesOrderHeader)
• Status (Sales.SalesOrderHeader)
• TaxType (Sales.SalesTaxRate)

uniqueidentifier

• rowguid (HumanResources.Employee)
• rowguid (Person.Address)
• rowguid (Person.AddressType)
• rowguid (Person.BusinessEntity)
• rowguid (Person.BusinessEntityAddress)
• rowguid (Person.BusinessEntityContact)
• rowguid (Person.EmailAddress)
• rowguid (Person.Password)
• rowguid (Person.Person)
• rowguid (Person.StateProvince)
• rowguid (Production.Document)
• rowguid (Production.Product)
• rowguid (Production.ProductCategory)
• rowguid (Production.ProductDescription)
• rowguid (Production.ProductInventory)
• rowguid (Production.ProductModel)
• rowguid (Production.ProductSubcategory)
• rowguid (Purchasing.ShipMethod)
• rowguid (Sales.Customer)
• rowguid (Sales.SalesOrderDetail)
• rowguid (Sales.SalesOrderHeader)
• rowguid (Sales.SalesPerson)
• rowguid (Sales.SalesPersonQuotaHistory)
• rowguid (Sales.SalesTaxRate)
• rowguid (Sales.SalesTerritory)
• rowguid (Sales.SalesTerritoryHistory)
• rowguid (Sales.SpecialOffer)
• rowguid (Sales.SpecialOfferProduct)
• rowguid (Sales.Store)

varbinary (MAX)

• Document (Production.Document)
• ThumbNailPhoto (Production.ProductPhoto)
• LargePhoto (Production.ProductPhoto)

varchar

• PasswordHash (Person.Password)
• PasswordSalt (Person.Password)
• AccountNumber (Sales.Customer)
• CreditCardApprovalCode (Sales.SalesOrderHeader)

xml

• XmlEvent (DatabaseLog)
• Resume (HumanResources.JobCandidate)
• AdditionalContactInfo (Person.Person)
• Demographics (Person.Person)
• Diagram (Production.Illustration)
• CatalogDescription (Production.ProductModel)
• Instructions (Production.ProductModel)
• Demographics (Sales.Store)