Getting list of columns for all tables in current database using XPATH

SELECT TABLE_NAME,
STUFF((SELECT ', ' + T2.COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS AS T2 WHERE T2.TABLE_NAME = T1.TABLE_NAME FOR XML PATH ('')), 1, 2,'') AS COL_NAMES
FROM INFORMATION_SCHEMA.COLUMNS AS T1
--WHERE T1.TABLE_NAME = 'PIX001'
ORDER BY T1.ORDINAL_POSITION

# AdventureWorks, size: 219072
ProductProductPhoto ProductID, ProductPhotoID, Primary, ModifiedDate
StoreContact CustomerID, ContactID, ContactTypeID, rowguid, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
AddressType AddressTypeID, Name, rowguid, ModifiedDate
ProductSubcategory ProductSubcategoryID, ProductCategoryID, Name, rowguid, ModifiedDate
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
AWBuildVersion SystemInformationID, Database Version, VersionDate, ModifiedDate
vProductAndDescription ProductID, Name, ProductModel, CultureID, Description
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPersonSalesByFiscalYears SalesPersonID, FullName, Title, SalesTerritory, 2002, 2003, 2004
VendorAddress VendorID, AddressID, AddressTypeID, ModifiedDate
vStateProvinceCountryRegion StateProvinceID, StateProvinceCode, IsOnlyStateProvinceFlag, StateProvinceName, TerritoryID, CountryRegionCode, CountryRegionName
VendorContact VendorID, ContactID, ContactTypeID, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
UnitMeasure UnitMeasureCode, Name, ModifiedDate
ContactCreditCard ContactID, CreditCardID, ModifiedDate
ContactType ContactTypeID, Name, ModifiedDate
CountryRegionCurrency CountryRegionCode, CurrencyCode, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
CreditCard CreditCardID, CardType, CardNumber, ExpMonth, ExpYear, ModifiedDate
CountryRegion CountryRegionCode, Name, ModifiedDate
Culture CultureID, Name, ModifiedDate
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
CurrencyRate CurrencyRateID, CurrencyRateDate, FromCurrencyCode, ToCurrencyCode, AverageRate, EndOfDayRate, ModifiedDate
Customer CustomerID, TerritoryID, AccountNumber, CustomerType, rowguid, ModifiedDate
CustomerAddress CustomerID, AddressID, AddressTypeID, rowguid, ModifiedDate
Department DepartmentID, Name, GroupName, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
Currency CurrencyCode, Name, ModifiedDate
SalesOrderHeaderSalesReason SalesOrderID, SalesReasonID, ModifiedDate
EmployeeAddress EmployeeID, AddressID, rowguid, ModifiedDate
EmployeeDepartmentHistory EmployeeID, DepartmentID, ShiftID, StartDate, EndDate, ModifiedDate
EmployeePayHistory EmployeeID, RateChangeDate, Rate, PayFrequency, ModifiedDate
SalesPersonQuotaHistory SalesPersonID, QuotaDate, SalesQuota, rowguid, ModifiedDate
SalesReason SalesReasonID, Name, ReasonType, ModifiedDate
Individual CustomerID, ContactID, Demographics, ModifiedDate
SalesTaxRate SalesTaxRateID, StateProvinceID, TaxType, TaxRate, Name, rowguid, ModifiedDate
JobCandidate JobCandidateID, EmployeeID, Resume, ModifiedDate
Location LocationID, Name, CostRate, Availability, ModifiedDate
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritoryHistory SalesPersonID, TerritoryID, StartDate, EndDate, rowguid, ModifiedDate
Illustration IllustrationID, Diagram, ModifiedDate
ScrapReason ScrapReasonID, Name, ModifiedDate
Shift ShiftID, Name, StartTime, EndTime, ModifiedDate
ProductCategory ProductCategoryID, Name, rowguid, ModifiedDate
ShipMethod ShipMethodID, Name, ShipBase, ShipRate, rowguid, ModifiedDate
ProductCostHistory ProductID, StartDate, EndDate, StandardCost, ModifiedDate
ProductDescription ProductDescriptionID, Description, rowguid, ModifiedDate
ShoppingCartItem ShoppingCartItemID, ShoppingCartID, Quantity, ProductID, DateCreated, ModifiedDate
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ProductInventory ProductID, LocationID, Shelf, Bin, Quantity, rowguid, ModifiedDate
ProductListPriceHistory ProductID, StartDate, EndDate, ListPrice, ModifiedDate
SpecialOfferProduct SpecialOfferID, ProductID, rowguid, ModifiedDate
ProductModel ProductModelID, Name, CatalogDescription, Instructions, rowguid, ModifiedDate
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
ProductDocument ProductID, DocumentID, ModifiedDate
ProductModelIllustration ProductModelID, IllustrationID, ModifiedDate
ProductModelProductDescriptionCulture ProductModelID, ProductDescriptionID, CultureID, ModifiedDate
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
Store CustomerID, Name, SalesPersonID, Demographics, rowguid, ModifiedDate
ProductPhoto ProductPhotoID, ThumbNailPhoto, ThumbnailPhotoFileName, LargePhoto, LargePhotoFileName, ModifiedDate
ProductPhoto ProductPhotoID, ThumbNailPhoto, ThumbnailPhotoFileName, LargePhoto, LargePhotoFileName, ModifiedDate
Store CustomerID, Name, SalesPersonID, Demographics, rowguid, ModifiedDate
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
ProductModelProductDescriptionCulture ProductModelID, ProductDescriptionID, CultureID, ModifiedDate
ProductModelIllustration ProductModelID, IllustrationID, ModifiedDate
ProductDocument ProductID, DocumentID, ModifiedDate
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
ProductModel ProductModelID, Name, CatalogDescription, Instructions, rowguid, ModifiedDate
SpecialOfferProduct SpecialOfferID, ProductID, rowguid, ModifiedDate
ProductListPriceHistory ProductID, StartDate, EndDate, ListPrice, ModifiedDate
ProductInventory ProductID, LocationID, Shelf, Bin, Quantity, rowguid, ModifiedDate
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ShoppingCartItem ShoppingCartItemID, ShoppingCartID, Quantity, ProductID, DateCreated, ModifiedDate
ProductDescription ProductDescriptionID, Description, rowguid, ModifiedDate
ProductCostHistory ProductID, StartDate, EndDate, StandardCost, ModifiedDate
ShipMethod ShipMethodID, Name, ShipBase, ShipRate, rowguid, ModifiedDate
ProductCategory ProductCategoryID, Name, rowguid, ModifiedDate
Shift ShiftID, Name, StartTime, EndTime, ModifiedDate
ScrapReason ScrapReasonID, Name, ModifiedDate
Illustration IllustrationID, Diagram, ModifiedDate
SalesTerritoryHistory SalesPersonID, TerritoryID, StartDate, EndDate, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Location LocationID, Name, CostRate, Availability, ModifiedDate
JobCandidate JobCandidateID, EmployeeID, Resume, ModifiedDate
SalesTaxRate SalesTaxRateID, StateProvinceID, TaxType, TaxRate, Name, rowguid, ModifiedDate
Individual CustomerID, ContactID, Demographics, ModifiedDate
SalesReason SalesReasonID, Name, ReasonType, ModifiedDate
SalesPersonQuotaHistory SalesPersonID, QuotaDate, SalesQuota, rowguid, ModifiedDate
EmployeePayHistory EmployeeID, RateChangeDate, Rate, PayFrequency, ModifiedDate
EmployeeDepartmentHistory EmployeeID, DepartmentID, ShiftID, StartDate, EndDate, ModifiedDate
EmployeeAddress EmployeeID, AddressID, rowguid, ModifiedDate
SalesOrderHeaderSalesReason SalesOrderID, SalesReasonID, ModifiedDate
Currency CurrencyCode, Name, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Department DepartmentID, Name, GroupName, ModifiedDate
CustomerAddress CustomerID, AddressID, AddressTypeID, rowguid, ModifiedDate
Customer CustomerID, TerritoryID, AccountNumber, CustomerType, rowguid, ModifiedDate
CurrencyRate CurrencyRateID, CurrencyRateDate, FromCurrencyCode, ToCurrencyCode, AverageRate, EndOfDayRate, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
Culture CultureID, Name, ModifiedDate
CountryRegion CountryRegionCode, Name, ModifiedDate
CreditCard CreditCardID, CardType, CardNumber, ExpMonth, ExpYear, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
CountryRegionCurrency CountryRegionCode, CurrencyCode, ModifiedDate
ContactType ContactTypeID, Name, ModifiedDate
ContactCreditCard ContactID, CreditCardID, ModifiedDate
UnitMeasure UnitMeasureCode, Name, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
VendorContact VendorID, ContactID, ContactTypeID, ModifiedDate
vStateProvinceCountryRegion StateProvinceID, StateProvinceCode, IsOnlyStateProvinceFlag, StateProvinceName, TerritoryID, CountryRegionCode, CountryRegionName
VendorAddress VendorID, AddressID, AddressTypeID, ModifiedDate
vSalesPersonSalesByFiscalYears SalesPersonID, FullName, Title, SalesTerritory, 2002, 2003, 2004
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
vProductAndDescription ProductID, Name, ProductModel, CultureID, Description
AWBuildVersion SystemInformationID, Database Version, VersionDate, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
ProductSubcategory ProductSubcategoryID, ProductCategoryID, Name, rowguid, ModifiedDate
AddressType AddressTypeID, Name, rowguid, ModifiedDate
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
StoreContact CustomerID, ContactID, ContactTypeID, rowguid, ModifiedDate
ProductProductPhoto ProductID, ProductPhotoID, Primary, ModifiedDate
ProductProductPhoto ProductID, ProductPhotoID, Primary, ModifiedDate
StoreContact CustomerID, ContactID, ContactTypeID, rowguid, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
AddressType AddressTypeID, Name, rowguid, ModifiedDate
ProductSubcategory ProductSubcategoryID, ProductCategoryID, Name, rowguid, ModifiedDate
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
AWBuildVersion SystemInformationID, Database Version, VersionDate, ModifiedDate
vProductAndDescription ProductID, Name, ProductModel, CultureID, Description
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPersonSalesByFiscalYears SalesPersonID, FullName, Title, SalesTerritory, 2002, 2003, 2004
VendorAddress VendorID, AddressID, AddressTypeID, ModifiedDate
vStateProvinceCountryRegion StateProvinceID, StateProvinceCode, IsOnlyStateProvinceFlag, StateProvinceName, TerritoryID, CountryRegionCode, CountryRegionName
VendorContact VendorID, ContactID, ContactTypeID, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
UnitMeasure UnitMeasureCode, Name, ModifiedDate
ContactCreditCard ContactID, CreditCardID, ModifiedDate
ContactType ContactTypeID, Name, ModifiedDate
CountryRegionCurrency CountryRegionCode, CurrencyCode, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
CreditCard CreditCardID, CardType, CardNumber, ExpMonth, ExpYear, ModifiedDate
CountryRegion CountryRegionCode, Name, ModifiedDate
Culture CultureID, Name, ModifiedDate
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
CurrencyRate CurrencyRateID, CurrencyRateDate, FromCurrencyCode, ToCurrencyCode, AverageRate, EndOfDayRate, ModifiedDate
Customer CustomerID, TerritoryID, AccountNumber, CustomerType, rowguid, ModifiedDate
CustomerAddress CustomerID, AddressID, AddressTypeID, rowguid, ModifiedDate
Department DepartmentID, Name, GroupName, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
Currency CurrencyCode, Name, ModifiedDate
SalesOrderHeaderSalesReason SalesOrderID, SalesReasonID, ModifiedDate
EmployeeAddress EmployeeID, AddressID, rowguid, ModifiedDate
EmployeeDepartmentHistory EmployeeID, DepartmentID, ShiftID, StartDate, EndDate, ModifiedDate
EmployeePayHistory EmployeeID, RateChangeDate, Rate, PayFrequency, ModifiedDate
SalesPersonQuotaHistory SalesPersonID, QuotaDate, SalesQuota, rowguid, ModifiedDate
SalesReason SalesReasonID, Name, ReasonType, ModifiedDate
Individual CustomerID, ContactID, Demographics, ModifiedDate
SalesTaxRate SalesTaxRateID, StateProvinceID, TaxType, TaxRate, Name, rowguid, ModifiedDate
JobCandidate JobCandidateID, EmployeeID, Resume, ModifiedDate
Location LocationID, Name, CostRate, Availability, ModifiedDate
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritoryHistory SalesPersonID, TerritoryID, StartDate, EndDate, rowguid, ModifiedDate
Illustration IllustrationID, Diagram, ModifiedDate
ScrapReason ScrapReasonID, Name, ModifiedDate
Shift ShiftID, Name, StartTime, EndTime, ModifiedDate
ProductCategory ProductCategoryID, Name, rowguid, ModifiedDate
ShipMethod ShipMethodID, Name, ShipBase, ShipRate, rowguid, ModifiedDate
ProductCostHistory ProductID, StartDate, EndDate, StandardCost, ModifiedDate
ProductDescription ProductDescriptionID, Description, rowguid, ModifiedDate
ShoppingCartItem ShoppingCartItemID, ShoppingCartID, Quantity, ProductID, DateCreated, ModifiedDate
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ProductInventory ProductID, LocationID, Shelf, Bin, Quantity, rowguid, ModifiedDate
ProductListPriceHistory ProductID, StartDate, EndDate, ListPrice, ModifiedDate
SpecialOfferProduct SpecialOfferID, ProductID, rowguid, ModifiedDate
ProductModel ProductModelID, Name, CatalogDescription, Instructions, rowguid, ModifiedDate
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
ProductDocument ProductID, DocumentID, ModifiedDate
ProductModelIllustration ProductModelID, IllustrationID, ModifiedDate
ProductModelProductDescriptionCulture ProductModelID, ProductDescriptionID, CultureID, ModifiedDate
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
Store CustomerID, Name, SalesPersonID, Demographics, rowguid, ModifiedDate
ProductPhoto ProductPhotoID, ThumbNailPhoto, ThumbnailPhotoFileName, LargePhoto, LargePhotoFileName, ModifiedDate
ProductPhoto ProductPhotoID, ThumbNailPhoto, ThumbnailPhotoFileName, LargePhoto, LargePhotoFileName, ModifiedDate
Store CustomerID, Name, SalesPersonID, Demographics, rowguid, ModifiedDate
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
ProductModelProductDescriptionCulture ProductModelID, ProductDescriptionID, CultureID, ModifiedDate
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
ProductModel ProductModelID, Name, CatalogDescription, Instructions, rowguid, ModifiedDate
SpecialOfferProduct SpecialOfferID, ProductID, rowguid, ModifiedDate
ProductListPriceHistory ProductID, StartDate, EndDate, ListPrice, ModifiedDate
ProductInventory ProductID, LocationID, Shelf, Bin, Quantity, rowguid, ModifiedDate
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ShoppingCartItem ShoppingCartItemID, ShoppingCartID, Quantity, ProductID, DateCreated, ModifiedDate
ProductDescription ProductDescriptionID, Description, rowguid, ModifiedDate
ProductCostHistory ProductID, StartDate, EndDate, StandardCost, ModifiedDate
ShipMethod ShipMethodID, Name, ShipBase, ShipRate, rowguid, ModifiedDate
ProductCategory ProductCategoryID, Name, rowguid, ModifiedDate
Shift ShiftID, Name, StartTime, EndTime, ModifiedDate
SalesTerritoryHistory SalesPersonID, TerritoryID, StartDate, EndDate, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Location LocationID, Name, CostRate, Availability, ModifiedDate
JobCandidate JobCandidateID, EmployeeID, Resume, ModifiedDate
SalesTaxRate SalesTaxRateID, StateProvinceID, TaxType, TaxRate, Name, rowguid, ModifiedDate
Individual CustomerID, ContactID, Demographics, ModifiedDate
SalesReason SalesReasonID, Name, ReasonType, ModifiedDate
SalesPersonQuotaHistory SalesPersonID, QuotaDate, SalesQuota, rowguid, ModifiedDate
EmployeePayHistory EmployeeID, RateChangeDate, Rate, PayFrequency, ModifiedDate
EmployeeDepartmentHistory EmployeeID, DepartmentID, ShiftID, StartDate, EndDate, ModifiedDate
EmployeeAddress EmployeeID, AddressID, rowguid, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Department DepartmentID, Name, GroupName, ModifiedDate
CustomerAddress CustomerID, AddressID, AddressTypeID, rowguid, ModifiedDate
Customer CustomerID, TerritoryID, AccountNumber, CustomerType, rowguid, ModifiedDate
CurrencyRate CurrencyRateID, CurrencyRateDate, FromCurrencyCode, ToCurrencyCode, AverageRate, EndOfDayRate, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
CreditCard CreditCardID, CardType, CardNumber, ExpMonth, ExpYear, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
VendorContact VendorID, ContactID, ContactTypeID, ModifiedDate
vStateProvinceCountryRegion StateProvinceID, StateProvinceCode, IsOnlyStateProvinceFlag, StateProvinceName, TerritoryID, CountryRegionCode, CountryRegionName
VendorAddress VendorID, AddressID, AddressTypeID, ModifiedDate
vSalesPersonSalesByFiscalYears SalesPersonID, FullName, Title, SalesTerritory, 2002, 2003, 2004
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
vProductAndDescription ProductID, Name, ProductModel, CultureID, Description
AWBuildVersion SystemInformationID, Database Version, VersionDate, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
ProductSubcategory ProductSubcategoryID, ProductCategoryID, Name, rowguid, ModifiedDate
AddressType AddressTypeID, Name, rowguid, ModifiedDate
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
StoreContact CustomerID, ContactID, ContactTypeID, rowguid, ModifiedDate
ProductProductPhoto ProductID, ProductPhotoID, Primary, ModifiedDate
StoreContact CustomerID, ContactID, ContactTypeID, rowguid, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
ProductSubcategory ProductSubcategoryID, ProductCategoryID, Name, rowguid, ModifiedDate
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vProductAndDescription ProductID, Name, ProductModel, CultureID, Description
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPersonSalesByFiscalYears SalesPersonID, FullName, Title, SalesTerritory, 2002, 2003, 2004
vStateProvinceCountryRegion StateProvinceID, StateProvinceCode, IsOnlyStateProvinceFlag, StateProvinceName, TerritoryID, CountryRegionCode, CountryRegionName
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
CreditCard CreditCardID, CardType, CardNumber, ExpMonth, ExpYear, ModifiedDate
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
CurrencyRate CurrencyRateID, CurrencyRateDate, FromCurrencyCode, ToCurrencyCode, AverageRate, EndOfDayRate, ModifiedDate
Customer CustomerID, TerritoryID, AccountNumber, CustomerType, rowguid, ModifiedDate
CustomerAddress CustomerID, AddressID, AddressTypeID, rowguid, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
EmployeeDepartmentHistory EmployeeID, DepartmentID, ShiftID, StartDate, EndDate, ModifiedDate
EmployeePayHistory EmployeeID, RateChangeDate, Rate, PayFrequency, ModifiedDate
SalesPersonQuotaHistory SalesPersonID, QuotaDate, SalesQuota, rowguid, ModifiedDate
SalesTaxRate SalesTaxRateID, StateProvinceID, TaxType, TaxRate, Name, rowguid, ModifiedDate
Location LocationID, Name, CostRate, Availability, ModifiedDate
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritoryHistory SalesPersonID, TerritoryID, StartDate, EndDate, rowguid, ModifiedDate
Shift ShiftID, Name, StartTime, EndTime, ModifiedDate
ShipMethod ShipMethodID, Name, ShipBase, ShipRate, rowguid, ModifiedDate
ProductCostHistory ProductID, StartDate, EndDate, StandardCost, ModifiedDate
ShoppingCartItem ShoppingCartItemID, ShoppingCartID, Quantity, ProductID, DateCreated, ModifiedDate
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ProductInventory ProductID, LocationID, Shelf, Bin, Quantity, rowguid, ModifiedDate
ProductListPriceHistory ProductID, StartDate, EndDate, ListPrice, ModifiedDate
ProductModel ProductModelID, Name, CatalogDescription, Instructions, rowguid, ModifiedDate
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
Store CustomerID, Name, SalesPersonID, Demographics, rowguid, ModifiedDate
ProductPhoto ProductPhotoID, ThumbNailPhoto, ThumbnailPhotoFileName, LargePhoto, LargePhotoFileName, ModifiedDate
ProductPhoto ProductPhotoID, ThumbNailPhoto, ThumbnailPhotoFileName, LargePhoto, LargePhotoFileName, ModifiedDate
Store CustomerID, Name, SalesPersonID, Demographics, rowguid, ModifiedDate
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
ProductModel ProductModelID, Name, CatalogDescription, Instructions, rowguid, ModifiedDate
ProductInventory ProductID, LocationID, Shelf, Bin, Quantity, rowguid, ModifiedDate
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ShoppingCartItem ShoppingCartItemID, ShoppingCartID, Quantity, ProductID, DateCreated, ModifiedDate
ShipMethod ShipMethodID, Name, ShipBase, ShipRate, rowguid, ModifiedDate
SalesTerritoryHistory SalesPersonID, TerritoryID, StartDate, EndDate, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
SalesTaxRate SalesTaxRateID, StateProvinceID, TaxType, TaxRate, Name, rowguid, ModifiedDate
EmployeeDepartmentHistory EmployeeID, DepartmentID, ShiftID, StartDate, EndDate, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Customer CustomerID, TerritoryID, AccountNumber, CustomerType, rowguid, ModifiedDate
CurrencyRate CurrencyRateID, CurrencyRateDate, FromCurrencyCode, ToCurrencyCode, AverageRate, EndOfDayRate, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
CreditCard CreditCardID, CardType, CardNumber, ExpMonth, ExpYear, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
vStateProvinceCountryRegion StateProvinceID, StateProvinceCode, IsOnlyStateProvinceFlag, StateProvinceName, TerritoryID, CountryRegionCode, CountryRegionName
vSalesPersonSalesByFiscalYears SalesPersonID, FullName, Title, SalesTerritory, 2002, 2003, 2004
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPersonSalesByFiscalYears SalesPersonID, FullName, Title, SalesTerritory, 2002, 2003, 2004
vStateProvinceCountryRegion StateProvinceID, StateProvinceCode, IsOnlyStateProvinceFlag, StateProvinceName, TerritoryID, CountryRegionCode, CountryRegionName
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
CurrencyRate CurrencyRateID, CurrencyRateDate, FromCurrencyCode, ToCurrencyCode, AverageRate, EndOfDayRate, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
SalesTaxRate SalesTaxRateID, StateProvinceID, TaxType, TaxRate, Name, rowguid, ModifiedDate
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ProductInventory ProductID, LocationID, Shelf, Bin, Quantity, rowguid, ModifiedDate
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
DatabaseLog DatabaseLogID, PostTime, DatabaseUser, Event, Schema, Object, TSQL, XmlEvent
StateProvince StateProvinceID, StateProvinceCode, CountryRegionCode, IsOnlyStateProvinceFlag, Name, TerritoryID, rowguid, ModifiedDate
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
Vendor VendorID, AccountNumber, Name, CreditRating, PreferredVendorStatus, ActiveFlag, PurchasingWebServiceURL, ModifiedDate
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
ProductReview ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate
Address AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, rowguid, ModifiedDate
TransactionHistory TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
TransactionHistoryArchive TransactionID, ProductID, ReferenceOrderID, ReferenceOrderLineID, TransactionDate, TransactionType, Quantity, ActualCost, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
BillOfMaterials BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate, EndDate, UnitMeasureCode, BOMLevel, PerAssemblyQty, ModifiedDate
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
SalesPerson SalesPersonID, TerritoryID, SalesQuota, Bonus, CommissionPct, SalesYTD, SalesLastYear, rowguid, ModifiedDate
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
ErrorLog ErrorLogID, ErrorTime, UserName, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesTerritory TerritoryID, Name, CountryRegionCode, Group, SalesYTD, SalesLastYear, CostYTD, CostLastYear, rowguid, ModifiedDate
Document DocumentID, Title, FileName, FileExtension, Revision, ChangeNumber, Status, DocumentSummary, Document, ModifiedDate
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
WorkOrder WorkOrderID, ProductID, OrderQty, StockedQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, ModifiedDate
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
vEmployeeDepartment EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Department, GroupName, StartDate
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
ProductVendor ProductID, VendorID, AverageLeadTime, StandardPrice, LastReceiptCost, LastReceiptDate, MinOrderQty, MaxOrderQty, OnOrderQty, UnitMeasureCode, ModifiedDate
vEmployeeDepartmentHistory EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, Shift, Department, GroupName, StartDate, EndDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidateEmployment JobCandidateID, Emp.StartDate, Emp.EndDate, Emp.OrgName, Emp.JobTitle, Emp.Responsibility, Emp.FunctionCategory, Emp.IndustryCategory, Emp.Loc.CountryRegion, Emp.Loc.State, Emp.Loc.City
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
PurchaseOrderDetail PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelInstructions ProductModelID, Name, Instructions, LocationID, SetupHours, MachineHours, LaborHours, LotSize, Step, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
SalesOrderDetail SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount, LineTotal, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SpecialOffer SpecialOfferID, Description, DiscountPct, Type, Category, StartDate, EndDate, MinQty, MaxQty, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
WorkOrderRouting WorkOrderID, ProductID, OperationSequence, LocationID, ScheduledStartDate, ScheduledEndDate, ActualStartDate, ActualEndDate, ActualResourceHrs, PlannedCost, ActualCost, ModifiedDate
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualDemographics CustomerID, TotalPurchaseYTD, DateFirstPurchase, BirthDate, MaritalStatus, YearlyIncome, Gender, TotalChildren, NumberChildrenAtHome, Education, Occupation, HomeOwnerFlag, NumberCarsOwned
vJobCandidateEducation JobCandidateID, Edu.Level, Edu.StartDate, Edu.EndDate, Edu.Degree, Edu.Major, Edu.Minor, Edu.GPA, Edu.GPAScale, Edu.School, Edu.Loc.CountryRegion, Edu.Loc.State, Edu.Loc.City
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
PurchaseOrderHeader PurchaseOrderID, RevisionNumber, Status, EmployeeID, VendorID, ShipMethodID, OrderDate, ShipDate, SubTotal, TaxAmt, Freight, TotalDue, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
Contact ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Employee EmployeeID, NationalIDNumber, ContactID, LoginID, ManagerID, Title, BirthDate, MaritalStatus, Gender, HireDate, SalariedFlag, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vJobCandidate JobCandidateID, EmployeeID, Name.Prefix, Name.First, Name.Middle, Name.Last, Name.Suffix, Skills, Addr.Type, Addr.Loc.CountryRegion, Addr.Loc.State, Addr.Loc.City, Addr.PostalCode, EMail, WebSite, ModifiedDate
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vAdditionalContactInfo ContactID, FirstName, MiddleName, LastName, TelephoneNumber, TelephoneSpecialInstructions, Street, City, StateProvince, PostalCode, CountryRegion, HomeAddressSpecialInstructions, EMailAddress, EMailSpecialInstructions, EMailTelephoneNumber, rowguid, Modifi
vEmployee EmployeeID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AdditionalContactInfo
vIndividualCustomer CustomerID, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, Demographics
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vVendor VendorID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vSalesPerson SalesPersonID, Title, FirstName, MiddleName, LastName, Suffix, JobTitle, Phone, EmailAddress, EmailPromotion, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, TerritoryName, TerritoryGroup, SalesQuota, SalesYTD, SalesLast
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vProductModelCatalogDescription ProductModelID, Name, Summary, Manufacturer, Copyright, ProductURL, WarrantyPeriod, WarrantyDescription, NoOfYears, MaintenanceDescription, Wheel, Saddle, Pedal, BikeFrame, Crankset, PictureAngle, PictureSize, ProductPhotoID, Material, Color, ProductLine,
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
Product ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, Produ
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin
SalesOrderHeader SalesOrderID, RevisionNumber, OrderDate, DueDate, ShipDate, Status, OnlineOrderFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerID, ContactID, SalesPersonID, TerritoryID, BillToAddressID, ShipToAddressID, ShipMethodID, CreditCardID, Cred
vStoreWithDemographics CustomerID, Name, ContactType, Title, FirstName, MiddleName, LastName, Suffix, Phone, EmailAddress, EmailPromotion, AddressType, AddressLine1, AddressLine2, City, StateProvinceName, PostalCode, CountryRegionName, AnnualSales, AnnualRevenue, BankName, Busin