AccountNumber | AccountNumber | 15 | NOT NULL | Vendor, SalesOrderHeader
AccountNumber | varchar | 10 | NOT NULL | Customer
ActiveFlag | Flag | 1 | NOT NULL | Vendor
ActualCost | money | 8 | NOT NULL | TransactionHistory, TransactionHistoryArchive, WorkOrderRouting
ActualEndDate | datetime | 8 | NULL | WorkOrderRouting
ActualResourceHrs | decimal | 5 | NULL | WorkOrderRouting
ActualStartDate | datetime | 8 | NULL | WorkOrderRouting
AdditionalContactInfo | AdditionalContactInfoSchemaCollection | -1 | NULL | Contact
AddressID | int | 4 | NOT NULL | EmployeeAddress, Address, VendorAddress, CustomerAddress
AddressLine1 | nvarchar | 60 | NOT NULL | Address
AddressLine2 | nvarchar | 60 | NULL | Address
AddressTypeID | int | 4 | NOT NULL | VendorAddress, CustomerAddress, AddressType
Availability | decimal | 5 | NOT NULL | Location
AverageLeadTime | int | 4 | NOT NULL | ProductVendor
AverageRate | money | 8 | NOT NULL | CurrencyRate
BillOfMaterialsID | int | 4 | NOT NULL | BillOfMaterials
BillToAddressID | int | 4 | NOT NULL | SalesOrderHeader
Bin | tinyint | 1 | NOT NULL | ProductInventory
BirthDate | datetime | 8 | NOT NULL | Employee
BOMLevel | smallint | 2 | NOT NULL | BillOfMaterials
Bonus | money | 8 | NOT NULL | SalesPerson
CardNumber | nvarchar | 25 | NOT NULL | CreditCard
CardType | nvarchar | 50 | NOT NULL | CreditCard
CarrierTrackingNumber | nvarchar | 25 | NULL | SalesOrderDetail
CatalogDescription | ProductDescriptionSchemaCollection | -1 | NULL | ProductModel
Category | nvarchar | 50 | NOT NULL | SpecialOffer
ChangeNumber | int | 4 | NOT NULL | Document
City | nvarchar | 30 | NOT NULL | Address
Class | nchar | 2 | NULL | Product
Color | nvarchar | 15 | NULL | Product
Comment | nvarchar | 128 | NULL | SalesOrderHeader
Comments | nvarchar | 3850 | NULL | ProductReview
CommissionPct | smallmoney | 4 | NOT NULL | SalesPerson
ComponentID | int | 4 | NOT NULL | BillOfMaterials
ContactID | int | 4 | NOT NULL | SalesOrderHeader, ContactCreditCard, VendorContact, StoreContact, Individual, Contact, Employee
ContactTypeID | int | 4 | NOT NULL | ContactType, VendorContact, StoreContact
CostLastYear | money | 8 | NOT NULL | SalesTerritory
CostRate | smallmoney | 4 | NOT NULL | Location
CostYTD | money | 8 | NOT NULL | SalesTerritory
CountryRegionCode | nvarchar | 3 | NOT NULL | CountryRegion, StateProvince, CountryRegionCurrency, SalesTerritory
CreditCardApprovalCode | varchar | 15 | NULL | SalesOrderHeader
CreditCardID | int | 4 | NULL | SalesOrderHeader, ContactCreditCard, CreditCard
CreditRating | tinyint | 1 | NOT NULL | Vendor
CultureID | nchar | 6 | NOT NULL | ProductModelProductDescriptionCulture, Culture
CurrencyCode | nchar | 3 | NOT NULL | Currency, CountryRegionCurrency
CurrencyRateDate | datetime | 8 | NOT NULL | CurrencyRate
CurrencyRateID | int | 4 | NULL | SalesOrderHeader, CurrencyRate
CurrentFlag | Flag | 1 | NOT NULL | Employee
CustomerID | int | 4 | NOT NULL | SalesOrderHeader, Individual, CustomerAddress, Customer, StoreContact, Store
CustomerType | nchar | 1 | NOT NULL | Customer
Database Version | nvarchar | 25 | NOT NULL | AWBuildVersion
DatabaseLogID | int | 4 | NOT NULL | DatabaseLog
DatabaseUser | sysname | 128 | NOT NULL | DatabaseLog
DateCreated | datetime | 8 | NOT NULL | ShoppingCartItem
DaysToManufacture | int | 4 | NOT NULL | Product
Demographics | IndividualSurveySchemaCollection | -1 | NULL | Individual
Demographics | StoreSurveySchemaCollection | -1 | NULL | Store
DepartmentID | smallint | 2 | NOT NULL | Department, EmployeeDepartmentHistory
Description | nvarchar | 255 | NOT NULL | SpecialOffer
Description | nvarchar | 400 | NOT NULL | ProductDescription
Diagram |  | -1 | NULL | Illustration
DiscontinuedDate | datetime | 8 | NULL | Product
DiscountPct | smallmoney | 4 | NOT NULL | SpecialOffer
Document | varbinary | -1 | NULL | Document
DocumentID | int | 4 | NOT NULL | Document, ProductDocument
DocumentSummary | nvarchar | -1 | NULL | Document
DueDate | datetime | 8 | NOT NULL | SalesOrderHeader, WorkOrder, PurchaseOrderDetail
EmailAddress | nvarchar | 50 | NULL | Contact, ProductReview
EmailPromotion | int | 4 | NOT NULL | Contact
EmployeeID | int | 4 | NOT NULL | EmployeeAddress, EmployeeDepartmentHistory, JobCandidate, PurchaseOrderHeader, EmployeePayHistory, Employee
EndDate | datetime | 8 | NULL | ProductListPriceHistory, SalesTerritoryHistory, ProductCostHistory, SpecialOffer, EmployeeDepartmentHistory, BillOfMaterials, WorkOrder
EndOfDayRate | money | 8 | NOT NULL | CurrencyRate
EndTime | datetime | 8 | NOT NULL | Shift
ErrorLine | int | 4 | NULL | ErrorLog
ErrorLogID | int | 4 | NOT NULL | ErrorLog
ErrorMessage | nvarchar | 4000 | NOT NULL | ErrorLog
ErrorNumber | int | 4 | NOT NULL | ErrorLog
ErrorProcedure | nvarchar | 126 | NULL | ErrorLog
ErrorSeverity | int | 4 | NULL | ErrorLog
ErrorState | int | 4 | NULL | ErrorLog
ErrorTime | datetime | 8 | NOT NULL | ErrorLog
Event | sysname | 128 | NOT NULL | DatabaseLog
ExpMonth | tinyint | 1 | NOT NULL | CreditCard
ExpYear | smallint | 2 | NOT NULL | CreditCard
FileExtension | nvarchar | 8 | NOT NULL | Document
FileName | nvarchar | 400 | NOT NULL | Document
FinishedGoodsFlag | Flag | 1 | NOT NULL | Product
FirstName | Name | 50 | NOT NULL | Contact
Freight | money | 8 | NOT NULL | PurchaseOrderHeader, SalesOrderHeader
FromCurrencyCode | nchar | 3 | NOT NULL | CurrencyRate
Gender | nchar | 1 | NOT NULL | Employee
Group | nvarchar | 50 | NOT NULL | SalesTerritory
GroupName | Name | 50 | NOT NULL | Department
HireDate | datetime | 8 | NOT NULL | Employee
IllustrationID | int | 4 | NOT NULL | ProductModelIllustration, Illustration
Instructions | ManuInstructionsSchemaCollection | -1 | NULL | ProductModel
IsOnlyStateProvinceFlag | Flag | 1 | NOT NULL | StateProvince
JobCandidateID | int | 4 | NOT NULL | JobCandidate
LargePhoto | varbinary | -1 | NULL | ProductPhoto
LargePhotoFileName | nvarchar | 50 | NULL | ProductPhoto
LastName | Name | 50 | NOT NULL | Contact
LastReceiptCost | money | 8 | NULL | ProductVendor
LastReceiptDate | datetime | 8 | NULL | ProductVendor
LineTotal | money | 8 | NOT NULL | PurchaseOrderDetail
LineTotal | numeric | 17 | NOT NULL | SalesOrderDetail
ListPrice | money | 8 | NOT NULL | ProductListPriceHistory, Product
LocationID | smallint | 2 | NOT NULL | ProductInventory, WorkOrderRouting, Location
LoginID | nvarchar | 256 | NOT NULL | Employee
MakeFlag | Flag | 1 | NOT NULL | Product
ManagerID | int | 4 | NULL | Employee
MaritalStatus | nchar | 1 | NOT NULL | Employee
MaxOrderQty | int | 4 | NOT NULL | ProductVendor
MaxQty | int | 4 | NULL | SpecialOffer
MiddleName | Name | 50 | NULL | Contact
MinOrderQty | int | 4 | NOT NULL | ProductVendor
MinQty | int | 4 | NOT NULL | SpecialOffer
ModifiedDate | datetime | 8 | NOT NULL | UnitMeasure, Individual, ScrapReason, ProductSubcategory, Shift, ProductProductPhoto, ProductReview, SalesOrderDetail, Address, Store, TransactionHistory, CustomerAddress, Document, Customer, ShoppingCartItem, Culture, TransactionHistoryArchive, JobCandidate, ContactCreditCard, PurchaseOrderHeader, VendorContact, PurchaseOrderDetail, SpecialOfferProduct, CountryRegionCurrency, Vendor, VendorAddress, StoreContact, ShipMethod, Department, AWBuildVersion, SalesTaxRate, SalesReason, EmployeeDepartmentHistory, WorkOrderRouting, CurrencyRate, EmployeePayHistory, WorkOrder, Employee, SpecialOffer, CreditCard, EmployeeAddress, Currency, ProductVendor, ProductDescription, ProductDocument, ProductCostHistory, ContactType, Contact, SalesTerritoryHistory, ProductModel, ProductModelIllustration, ProductListPriceHistory, ProductInventory, BillOfMaterials, SalesPerson, StateProvince, SalesPersonQuotaHistory, Illustration, Location, SalesOrderHeaderSalesReason, Product, ProductCategory, CountryRegion, SalesOrderHeader, SalesTerritory, ProductModelProductDescriptionCulture, ProductPhoto, AddressType
Name | Name | 50 | NOT NULL | ContactType, Product, UnitMeasure, ShipMethod, SalesReason, SalesTaxRate, ProductSubcategory, Shift, ScrapReason, CountryRegion, ProductCategory, SalesTerritory, Department, Store, Location, AddressType, Vendor, Culture, ProductModel, StateProvince, Currency
NameStyle | NameStyle | 1 | NOT NULL | Contact
NationalIDNumber | nvarchar | 15 | NOT NULL | Employee
Object | sysname | 128 | NULL | DatabaseLog
OnlineOrderFlag | Flag | 1 | NOT NULL | SalesOrderHeader
OnOrderQty | int | 4 | NULL | ProductVendor
OperationSequence | smallint | 2 | NOT NULL | WorkOrderRouting
OrderDate | datetime | 8 | NOT NULL | SalesOrderHeader, PurchaseOrderHeader
OrderQty | int | 4 | NOT NULL | WorkOrder
OrderQty | smallint | 2 | NOT NULL | PurchaseOrderDetail, SalesOrderDetail
PasswordHash | varchar | 40 | NOT NULL | Contact
PasswordSalt | varchar | 10 | NOT NULL | Contact
PayFrequency | tinyint | 1 | NOT NULL | EmployeePayHistory
PerAssemblyQty | decimal | 5 | NOT NULL | BillOfMaterials
Phone | Phone | 25 | NULL | Contact
PlannedCost | money | 8 | NOT NULL | WorkOrderRouting
PostalCode | nvarchar | 15 | NOT NULL | Address
PostTime | datetime | 8 | NOT NULL | DatabaseLog
PreferredVendorStatus | Flag | 1 | NOT NULL | Vendor
Primary | Flag | 1 | NOT NULL | ProductProductPhoto
ProductAssemblyID | int | 4 | NULL | BillOfMaterials
ProductCategoryID | int | 4 | NOT NULL | ProductCategory, ProductSubcategory
ProductDescriptionID | int | 4 | NOT NULL | ProductModelProductDescriptionCulture, ProductDescription
ProductID | int | 4 | NOT NULL | SpecialOfferProduct, Product, ProductReview, ProductProductPhoto, ShoppingCartItem, PurchaseOrderDetail, ProductDocument, ProductListPriceHistory, ProductVendor, WorkOrderRouting, ProductInventory, SalesOrderDetail, WorkOrder, TransactionHistory, ProductCostHistory, TransactionHistoryArchive
ProductLine | nchar | 2 | NULL | Product
ProductModelID | int | 4 | NOT NULL | ProductModelProductDescriptionCulture, ProductModelIllustration, ProductModel, Product
ProductNumber | nvarchar | 25 | NOT NULL | Product
ProductPhotoID | int | 4 | NOT NULL | ProductProductPhoto, ProductPhoto
ProductReviewID | int | 4 | NOT NULL | ProductReview
ProductSubcategoryID | int | 4 | NULL | Product, ProductSubcategory
PurchaseOrderDetailID | int | 4 | NOT NULL | PurchaseOrderDetail
PurchaseOrderID | int | 4 | NOT NULL | PurchaseOrderHeader, PurchaseOrderDetail
PurchaseOrderNumber | OrderNumber | 25 | NULL | SalesOrderHeader
PurchasingWebServiceURL | nvarchar | 1024 | NULL | Vendor
Quantity | int | 4 | NOT NULL | TransactionHistory, ShoppingCartItem, TransactionHistoryArchive
Quantity | smallint | 2 | NOT NULL | ProductInventory
QuotaDate | datetime | 8 | NOT NULL | SalesPersonQuotaHistory
Rate | money | 8 | NOT NULL | EmployeePayHistory
RateChangeDate | datetime | 8 | NOT NULL | EmployeePayHistory
Rating | int | 4 | NOT NULL | ProductReview
ReasonType | Name | 50 | NOT NULL | SalesReason
ReceivedQty | decimal | 5 | NOT NULL | PurchaseOrderDetail
ReferenceOrderID | int | 4 | NOT NULL | TransactionHistoryArchive, TransactionHistory
ReferenceOrderLineID | int | 4 | NOT NULL | TransactionHistoryArchive, TransactionHistory
RejectedQty | decimal | 5 | NOT NULL | PurchaseOrderDetail
ReorderPoint | smallint | 2 | NOT NULL | Product
Resume | HRResumeSchemaCollection | -1 | NULL | JobCandidate
ReviewDate | datetime | 8 | NOT NULL | ProductReview
ReviewerName | Name | 50 | NOT NULL | ProductReview
Revision | nchar | 5 | NOT NULL | Document
RevisionNumber | tinyint | 1 | NOT NULL | PurchaseOrderHeader, SalesOrderHeader
rowguid | uniqueidentifier | 16 | NOT NULL | Product, Address, Customer, SalesTaxRate, AddressType, EmployeeAddress, SalesTerritory, CustomerAddress, SalesPerson, StoreContact, Contact, SalesOrderHeader, ShipMethod, ProductSubcategory, ProductCategory, SpecialOfferProduct, ProductModel, SalesPersonQuotaHistory, ProductDescription, ProductInventory, SalesOrderDetail, Employee, SpecialOffer, StateProvince, SalesTerritoryHistory, Store
SafetyStockLevel | smallint | 2 | NOT NULL | Product
SalariedFlag | Flag | 1 | NOT NULL | Employee
SalesLastYear | money | 8 | NOT NULL | SalesPerson, SalesTerritory
SalesOrderDetailID | int | 4 | NOT NULL | SalesOrderDetail
SalesOrderID | int | 4 | NOT NULL | SalesOrderHeader, SalesOrderHeaderSalesReason, SalesOrderDetail
SalesOrderNumber | nvarchar | 25 | NOT NULL | SalesOrderHeader
SalesPersonID | int | 4 | NOT NULL | SalesPersonQuotaHistory, SalesTerritoryHistory, Store, SalesPerson, SalesOrderHeader
SalesQuota | money | 8 | NULL | SalesPerson, SalesPersonQuotaHistory
SalesReasonID | int | 4 | NOT NULL | SalesReason, SalesOrderHeaderSalesReason
SalesTaxRateID | int | 4 | NOT NULL | SalesTaxRate
SalesYTD | money | 8 | NOT NULL | SalesPerson, SalesTerritory
ScheduledEndDate | datetime | 8 | NOT NULL | WorkOrderRouting
ScheduledStartDate | datetime | 8 | NOT NULL | WorkOrderRouting
Schema | sysname | 128 | NULL | DatabaseLog
ScrappedQty | smallint | 2 | NOT NULL | WorkOrder
ScrapReasonID | smallint | 2 | NULL | WorkOrder, ScrapReason
SellEndDate | datetime | 8 | NULL | Product
SellStartDate | datetime | 8 | NOT NULL | Product
Shelf | nvarchar | 10 | NOT NULL | ProductInventory
ShiftID | tinyint | 1 | NOT NULL | EmployeeDepartmentHistory, Shift
ShipBase | money | 8 | NOT NULL | ShipMethod
ShipDate | datetime | 8 | NULL | PurchaseOrderHeader, SalesOrderHeader
ShipMethodID | int | 4 | NOT NULL | ShipMethod, SalesOrderHeader, PurchaseOrderHeader
ShipRate | money | 8 | NOT NULL | ShipMethod
ShipToAddressID | int | 4 | NOT NULL | SalesOrderHeader
ShoppingCartID | nvarchar | 50 | NOT NULL | ShoppingCartItem
ShoppingCartItemID | int | 4 | NOT NULL | ShoppingCartItem
SickLeaveHours | smallint | 2 | NOT NULL | Employee
Size | nvarchar | 5 | NULL | Product
SizeUnitMeasureCode | nchar | 3 | NULL | Product
SpecialOfferID | int | 4 | NOT NULL | SpecialOfferProduct, SalesOrderDetail, SpecialOffer
StandardCost | money | 8 | NOT NULL | Product, ProductCostHistory
StandardPrice | money | 8 | NOT NULL | ProductVendor
StartDate | datetime | 8 | NOT NULL | BillOfMaterials, ProductCostHistory, EmployeeDepartmentHistory, ProductListPriceHistory, WorkOrder, SpecialOffer, SalesTerritoryHistory
StartTime | datetime | 8 | NOT NULL | Shift
StateProvinceCode | nchar | 3 | NOT NULL | StateProvince
StateProvinceID | int | 4 | NOT NULL | SalesTaxRate, StateProvince, Address
Status | tinyint | 1 | NOT NULL | PurchaseOrderHeader, SalesOrderHeader, Document
StockedQty | decimal | 5 | NOT NULL | PurchaseOrderDetail
StockedQty | int | 4 | NOT NULL | WorkOrder
Style | nchar | 2 | NULL | Product
SubTotal | money | 8 | NOT NULL | PurchaseOrderHeader, SalesOrderHeader
Suffix | nvarchar | 10 | NULL | Contact
SystemInformationID | tinyint | 1 | NOT NULL | AWBuildVersion
TaxAmt | money | 8 | NOT NULL | PurchaseOrderHeader, SalesOrderHeader
TaxRate | smallmoney | 4 | NOT NULL | SalesTaxRate
TaxType | tinyint | 1 | NOT NULL | SalesTaxRate
TerritoryID | int | 4 | NOT NULL | SalesTerritoryHistory, SalesPerson, Customer, SalesTerritory, StateProvince, SalesOrderHeader
ThumbNailPhoto | varbinary | -1 | NULL | ProductPhoto
ThumbnailPhotoFileName | nvarchar | 50 | NULL | ProductPhoto
Title | nvarchar | 8 | NULL | Contact
Title | nvarchar | 50 | NOT NULL | Document, Employee
ToCurrencyCode | nchar | 3 | NOT NULL | CurrencyRate
TotalDue | money | 8 | NOT NULL | SalesOrderHeader, PurchaseOrderHeader
TransactionDate | datetime | 8 | NOT NULL | TransactionHistory, TransactionHistoryArchive
TransactionID | int | 4 | NOT NULL | TransactionHistoryArchive, TransactionHistory
TransactionType | nchar | 1 | NOT NULL | TransactionHistoryArchive, TransactionHistory
TSQL | nvarchar | -1 | NOT NULL | DatabaseLog
Type | nvarchar | 50 | NOT NULL | SpecialOffer
UnitMeasureCode | nchar | 3 | NOT NULL | ProductVendor, UnitMeasure, BillOfMaterials
UnitPrice | money | 8 | NOT NULL | PurchaseOrderDetail, SalesOrderDetail
UnitPriceDiscount | money | 8 | NOT NULL | SalesOrderDetail
UserName | sysname | 128 | NOT NULL | ErrorLog
VacationHours | smallint | 2 | NOT NULL | Employee
VendorID | int | 4 | NOT NULL | VendorAddress, VendorContact, Vendor, PurchaseOrderHeader, ProductVendor
VersionDate | datetime | 8 | NOT NULL | AWBuildVersion
Weight | decimal | 5 | NULL | Product
WeightUnitMeasureCode | nchar | 3 | NULL | Product
WorkOrderID | int | 4 | NOT NULL | WorkOrder, WorkOrderRouting
XmlEvent |  | -1 | NOT NULL | DatabaseLog