dbo.uspGetBillOfMaterials
dbo.uspGetEmployeeManagers
dbo.uspGetManagerEmployees
dbo.uspGetWhereUsedProductID
HumanResources.uspUpdateEmployeeHireInfo
HumanResources.uspUpdateEmployeeLogin
HumanResources.uspUpdateEmployeePersonalInfo

dbo.uAWBuildVersion
ddlDatabaseTriggerLog
HumanResources.dEmployee
HumanResources.uDepartment
HumanResources.uEmployee
HumanResources.uEmployeeAddress
HumanResources.uEmployeeDepartmentHistory
HumanResources.uEmployeePayHistory
HumanResources.uJobCandidate
HumanResources.uShift
Person.uAddress
Person.uAddressType
Person.uContact
Person.uContactType
Person.uCountryRegion
Person.uStateProvince
Production.iWorkOrder
Production.uBillOfMaterials
Production.uCulture
Production.uDocument
Production.uIllustration
Production.uLocation
Production.uProduct
Production.uProductCategory
Production.uProductCostHistory
Production.uProductDescription
Production.uProductDocument
Production.uProductInventory
Production.uProductListPriceHistory
Production.uProductModel
Production.uProductModelIllustration
Production.uProductModelProductDescriptionCulture
Production.uProductPhoto
Production.uProductProductPhoto
Production.uProductReview
Production.uProductSubcategory
Production.uScrapReason
Production.uTransactionHistory
Production.uTransactionHistoryArchive
Production.uUnitMeasure
Production.uWorkOrder
Production.uWorkOrderRouting
Purchasing.dVendor
Purchasing.iPurchaseOrderDetail
Purchasing.uProductVendor
Purchasing.uPurchaseOrderDetail
Purchasing.uPurchaseOrderHeader
Purchasing.uShipMethod
Purchasing.uVendor
Purchasing.uVendorAddress
Purchasing.uVendorContact
Sales.iduSalesOrderDetail
Sales.iStore
Sales.iuIndividual
Sales.uContactCreditCard
Sales.uCountryRegionCurrency
Sales.uCreditCard
Sales.uCurrency
Sales.uCurrencyRate
Sales.uCustomer
Sales.uCustomerAddress
Sales.uSalesOrderHeader
Sales.uSalesOrderHeaderSalesReason
Sales.uSalesPerson
Sales.uSalesPersonQuotaHistory
Sales.uSalesReason
Sales.uSalesTaxRate
Sales.uSalesTerritory
Sales.uSalesTerritoryHistory
Sales.uShoppingCartItem
Sales.uSpecialOffer
Sales.uSpecialOfferProduct
Sales.uStore
Sales.uStoreContact

BOM_cte used in procedure: dbo.uspGetBillOfMaterials
BOM_cte used in procedure: dbo.uspGetWhereUsedProductID
EMP_cte used in procedure: dbo.uspGetEmployeeManagers
EMP_cte used in procedure: dbo.uspGetManagerEmployees
HumanResources.vEmployee
HumanResources.vEmployeeDepartment
HumanResources.vEmployeeDepartmentHistory
HumanResources.vJobCandidate
HumanResources.vJobCandidateEducation
HumanResources.vJobCandidateEmployment
Person.vAdditionalContactInfo
Person.vStateProvinceCountryRegion
Production.vProductAndDescription
Production.vProductModelCatalogDescription
Production.vProductModelInstructions
Purchasing.vVendor
Sales.vIndividual
Sales.vIndividualDemographics
Sales.vSalesPerson
Sales.vSalesPersonSalesByFiscalYears
Sales.vStoreWithDemographics

AK_Address_rowguid on Person.Address
AK_AddressType_Name on Person.AddressType
AK_AddressType_rowguid on Person.AddressType
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate on Production.BillOfMaterials
AK_Contact_rowguid on Person.Contact
AK_ContactType_Name on Person.ContactType
AK_CountryRegion_Name on Person.CountryRegion
AK_CreditCard_CardNumber on Sales.CreditCard
AK_Culture_Name on Production.Culture
AK_Currency_Name on Sales.Currency
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode on Sales.CurrencyRate
AK_Customer_AccountNumber on Sales.Customer
AK_Customer_rowguid on Sales.Customer
AK_CustomerAddress_rowguid on Sales.CustomerAddress
AK_Department_Name on HumanResources.Department
AK_Document_FileName_Revision on Production.Document
AK_Employee_LoginID on HumanResources.Employee
AK_Employee_NationalIDNumber on HumanResources.Employee
AK_Employee_rowguid on HumanResources.Employee
AK_EmployeeAddress_rowguid on HumanResources.EmployeeAddress
AK_Location_Name on Production.Location
AK_Product_Name on Production.Product
AK_Product_ProductNumber on Production.Product
AK_Product_rowguid on Production.Product
AK_ProductCategory_Name on Production.ProductCategory
AK_ProductCategory_rowguid on Production.ProductCategory
AK_ProductDescription_rowguid on Production.ProductDescription
AK_ProductInventory_rowguid on Production.ProductInventory
AK_ProductModel_Name on Production.ProductModel
AK_ProductModel_rowguid on Production.ProductModel
AK_ProductProductPhoto_ProductID_ProductPhotoID on Production.ProductProductPhoto
AK_ProductSubcategory_Name on Production.ProductSubcategory
AK_ProductSubcategory_rowguid on Production.ProductSubcategory
AK_SalesOrderDetail_rowguid on Sales.SalesOrderDetail
AK_SalesOrderHeader_rowguid on Sales.SalesOrderHeader
AK_SalesOrderHeader_SalesOrderNumber on Sales.SalesOrderHeader
AK_SalesPerson_rowguid on Sales.SalesPerson
AK_SalesPersonQuotaHistory_rowguid on Sales.SalesPersonQuotaHistory
AK_SalesTaxRate_rowguid on Sales.SalesTaxRate
AK_SalesTaxRate_StateProvinceID_TaxType on Sales.SalesTaxRate
AK_SalesTerritory_Name on Sales.SalesTerritory
AK_SalesTerritory_rowguid on Sales.SalesTerritory
AK_SalesTerritoryHistory_rowguid on Sales.SalesTerritoryHistory
AK_ScrapReason_Name on Production.ScrapReason
AK_Shift_Name on HumanResources.Shift
AK_Shift_StartTime_EndTime on HumanResources.Shift
AK_ShipMethod_Name on Purchasing.ShipMethod
AK_ShipMethod_rowguid on Purchasing.ShipMethod
AK_SpecialOffer_rowguid on Sales.SpecialOffer
AK_SpecialOfferProduct_rowguid on Sales.SpecialOfferProduct
AK_StateProvince_Name on Person.StateProvince
AK_StateProvince_rowguid on Person.StateProvince
AK_StateProvince_StateProvinceCode_CountryRegionCode on Person.StateProvince
AK_Store_rowguid on Sales.Store
AK_StoreContact_rowguid on Sales.StoreContact
AK_UnitMeasure_Name on Production.UnitMeasure
AK_Vendor_AccountNumber on Purchasing.Vendor
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode on Person.Address
IX_Address_StateProvinceID on Person.Address
IX_BillOfMaterials_UnitMeasureCode on Production.BillOfMaterials
IX_Contact_EmailAddress on Person.Contact
IX_CountryRegionCurrency_CurrencyCode on Sales.CountryRegionCurrency
IX_Customer_TerritoryID on Sales.Customer
IX_Employee_ManagerID on HumanResources.Employee
IX_EmployeeDepartmentHistory_DepartmentID on HumanResources.EmployeeDepartmentHistory
IX_EmployeeDepartmentHistory_ShiftID on HumanResources.EmployeeDepartmentHistory
IX_JobCandidate_EmployeeID on HumanResources.JobCandidate
IX_ProductInventory_ProductID on Production.ProductInventory
IX_ProductReview_ProductID_Name on Production.ProductReview
IX_ProductVendor_UnitMeasureCode on Purchasing.ProductVendor
IX_ProductVendor_VendorID on Purchasing.ProductVendor
IX_PurchaseOrderDetail_ProductID on Purchasing.PurchaseOrderDetail
IX_PurchaseOrderHeader_EmployeeID on Purchasing.PurchaseOrderHeader
IX_PurchaseOrderHeader_VendorID on Purchasing.PurchaseOrderHeader
IX_SalesOrderDetail_ProductID on Sales.SalesOrderDetail
IX_SalesOrderHeader_CustomerID on Sales.SalesOrderHeader
IX_SalesOrderHeader_SalesPersonID on Sales.SalesOrderHeader
IX_ShoppingCartItem_ShoppingCartID_ProductID on Sales.ShoppingCartItem
IX_SpecialOfferProduct_ProductID on Sales.SpecialOfferProduct
IX_Store_SalesPersonID on Sales.Store
IX_StoreContact_ContactID on Sales.StoreContact
IX_StoreContact_ContactTypeID on Sales.StoreContact
IX_TransactionHistory_ProductID on Production.TransactionHistory
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID on Production.TransactionHistory
IX_TransactionHistoryArchive_ProductID on Production.TransactionHistoryArchive
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID on Production.TransactionHistoryArchive
IX_VendorAddress_AddressID on Purchasing.VendorAddress
IX_VendorContact_ContactID on Purchasing.VendorContact
IX_VendorContact_ContactTypeID on Purchasing.VendorContact
IX_vProductAndDescription on Production.vProductAndDescription
IX_vStateProvinceCountryRegion on Person.vStateProvinceCountryRegion
IX_WorkOrder_ProductID on Production.WorkOrder
IX_WorkOrder_ScrapReasonID on Production.WorkOrder
IX_WorkOrderRouting_ProductID on Production.WorkOrderRouting
PXML_Contact_AddContact on Person.Contact
PXML_Individual_Demographics on Sales.Individual
PXML_ProductModel_CatalogDescription on Production.ProductModel
PXML_ProductModel_Instructions on Production.ProductModel
PXML_Store_Demographics on Sales.Store
XMLPATH_Individual_Demographics on Sales.Individual
XMLPROPERTY_Individual_Demographics on Sales.Individual
XMLVALUE_Individual_Demographics on Sales.Individual

dbo.AWBuildVersion
dbo.DatabaseLog
HumanResources.Department
HumanResources.Employee
HumanResources.EmployeeAddress
HumanResources.EmployeeDepartmentHistory
HumanResources.EmployeePayHistory
HumanResources.JobCandidate
HumanResources.Shift
Person.Address
Person.AddressType
Person.Contact
Person.ContactType
Person.CountryRegion
Person.StateProvince
Production.BillOfMaterials
Production.Culture
Production.Document
Production.Illustration
Production.Location
Production.Product
Production.ProductCategory
Production.ProductCostHistory
Production.ProductDescription
Production.ProductDocument
Production.ProductInventory
Production.ProductListPriceHistory
Production.ProductModel
Production.ProductModelIllustration
Production.ProductModelProductDescriptionCulture
Production.ProductPhoto
Production.ProductProductPhoto
Production.ProductReview
Production.ProductSubcategory
Production.ScrapReason
Production.TransactionHistory
Production.TransactionHistoryArchive
Production.UnitMeasure
Production.WorkOrder
Production.WorkOrderRouting
Purchasing.ProductVendor
Purchasing.PurchaseOrderDetail
Purchasing.PurchaseOrderHeader
Purchasing.ShipMethod
Purchasing.Vendor
Purchasing.VendorAddress
Purchasing.VendorContact
Sales.ContactCreditCard
Sales.CountryRegionCurrency
Sales.CreditCard
Sales.Currency
Sales.CurrencyRate
Sales.Customer
Sales.CustomerAddress
Sales.Individual
Sales.SalesOrderDetail
Sales.SalesOrderHeader
Sales.SalesOrderHeaderSalesReason
Sales.SalesPerson
Sales.SalesPersonQuotaHistory
Sales.SalesReason
Sales.SalesTaxRate
Sales.SalesTerritory
Sales.SalesTerritoryHistory
Sales.ShoppingCartItem
Sales.SpecialOffer
Sales.SpecialOfferProduct
Sales.Store
Sales.StoreContact

AccountNumber
Flag
Name
NameStyle
OrderNumber
Phone

dbo.ufnGetAccountingEndDate
dbo.ufnGetAccountingStartDate
dbo.ufnGetContactInformation
dbo.ufnGetDocumentStatusText
dbo.ufnGetProductDealerPrice
dbo.ufnGetProductListPrice
dbo.ufnGetProductStandardCost
dbo.ufnGetPurchaseOrderStatusText
dbo.ufnGetSalesOrderStatusText
dbo.ufnGetStock
dbo.ufnLeadingZeros

Company Sales
Employee Sales Summary
Product Catalog
Product Line Sales
Sales Order Detail
Sales Reason Comparisons
Territory Sales Drilldown