Tables and Columns
Report generated by Toad for SQL Server
Table Name Address
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
AddressID int Primary key for Address
records.
AddressLine1 nvarchar First street address line.
AddressLine1 nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
AddressLine1 nvarchar Contact Info
AddressLine1 nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
AddressLine1 nvarchar Confidential - GDPR
AddressLine2 nvarchar Second street address
line.
AddressLine2 nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
AddressLine2 nvarchar Contact Info
AddressLine2 nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
AddressLine2 nvarchar Confidential - GDPR
City nvarchar Name of the city.
City nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
City nvarchar Contact Info
City nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
City nvarchar Confidential - GDPR
StateProvinceID int Unique identification
number for the state or
province. Foreign key to
StateProvince table.
PostalCode nvarchar Postal code for the
street address.
PostalCode nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
PostalCode nvarchar Contact Info
PostalCode nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
PostalCode nvarchar Confidential - GDPR
SpatialLocation sys.geography Latitude and longitude of
this address.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name AddressType
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
AddressTypeID int Primary key for
AddressType records.
Name dbo.Name Address type
description. For
example, Billing, Home,
or Shipping.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name AWBuildVersion
Schema Name dbo
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:14
Column Name Data Type Default Not Null Extended Properties
SystemInformationID tinyint Primary key for
AWBuildVersion records.
Database Version nvarchar Version number of the
database in
9.yy.mm.dd.00 format.
VersionDate datetime Date and time the record
was last updated.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BillOfMaterials
Schema Name Production
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BillOfMaterialsID int Primary key for
BillOfMaterials records.
ProductAssemblyID int Parent product
identification number.
Foreign key to
Product.ProductID.
ComponentID int Component identification
number. Foreign key to
Product.ProductID.
StartDate datetime (getdate()) Date the component
started being used in the
assembly item.
EndDate datetime Date the component
stopped being used in
the assembly item.
UnitMeasureCode nchar Standard code
identifying the unit of
measure for the quantity.
BOMLevel smallint Indicates the depth the
component is from its
parent (AssemblyID).
PerAssemblyQty decimal ((1.00)) Quantity of the
component needed to
create the assembly.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BusinessEntity
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key for all
customers, vendors, and
employees.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BusinessEntityAddress
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. Foreign key
to
BusinessEntity.Business
EntityID.
AddressID int Primary key. Foreign key
to Address.AddressID.
AddressTypeID int Primary key. Foreign key
to
AddressType.AddressTy
peID.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name BusinessEntityContact
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. Foreign key
to
BusinessEntity.Business
EntityID.
PersonID int Primary key. Foreign key
to
Person.BusinessEntityID
.
ContactTypeID int Primary key.  Foreign
key to
ContactType.ContactTyp
eID.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ContactType
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
ContactTypeID int Primary key for
ContactType records.
Name dbo.Name Contact type description.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CountryRegion
Schema Name Person
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:20
Column Name Data Type Default Not Null Extended Properties
CountryRegionCode nvarchar ISO standard code for
countries and regions.
Name dbo.Name Country or region name.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CountryRegionCurrency
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
CountryRegionCode nvarchar ISO code for countries
and regions. Foreign key
to
CountryRegion.Country
RegionCode.
CurrencyCode nchar ISO standard currency
code. Foreign key to
Currency.CurrencyCode.
CurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyCode nchar Financial
CurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyCode nchar Confidential
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CreditCard
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CreditCardID int Primary key for
CreditCard records.
CreditCardID int D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CreditCardID int Credit Card
CreditCardID int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CreditCardID int Confidential
CardType nvarchar Credit card name.
CardType nvarchar D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CardType nvarchar Credit Card
CardType nvarchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CardType nvarchar Confidential
CardNumber nvarchar Credit card number.
CardNumber nvarchar D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CardNumber nvarchar Credit Card
CardNumber nvarchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CardNumber nvarchar Confidential
ExpMonth tinyint Credit card expiration
month.
ExpMonth tinyint D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
ExpMonth tinyint Credit Card
ExpMonth tinyint 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ExpMonth tinyint Confidential
ExpYear smallint Credit card expiration
year.
ExpYear smallint D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
ExpYear smallint Credit Card
ExpYear smallint 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ExpYear smallint Confidential
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Culture
Schema Name Production
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CultureID nchar Primary key for Culture
records.
Name dbo.Name Culture description.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Currency
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
CurrencyCode nchar The ISO code for the
Currency.
CurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyCode nchar Financial
CurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyCode nchar Confidential
Name dbo.Name Currency name.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name CurrencyRate
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CurrencyRateID int Primary key for
CurrencyRate records.
CurrencyRateID int C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyRateID int Financial
CurrencyRateID int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyRateID int Confidential
CurrencyRateDate datetime Date and time the
exchange rate was
obtained.
CurrencyRateDate datetime C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyRateDate datetime Financial
CurrencyRateDate datetime 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyRateDate datetime Confidential
FromCurrencyCode nchar Exchange rate was
converted from this
currency code.
FromCurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
FromCurrencyCode nchar Financial
FromCurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
FromCurrencyCode nchar Confidential
ToCurrencyCode nchar Exchange rate was
converted to this
currency code.
ToCurrencyCode nchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
ToCurrencyCode nchar Financial
ToCurrencyCode nchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ToCurrencyCode nchar Confidential
AverageRate money Average exchange rate
for the day.
EndOfDayRate money Final exchange rate for
the day.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Customer
Schema Name Sales
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
CustomerID int Primary key.
PersonID int Foreign key to
Person.BusinessEntityID
StoreID int Foreign key to
Store.BusinessEntityID
TerritoryID int ID of the territory in
which the customer is
located. Foreign key to
SalesTerritory.SalesTerri
toryID.
AccountNumber varchar Unique number
identifying the customer
assigned by the
accounting system.
AccountNumber varchar C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
AccountNumber varchar Financial
AccountNumber varchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
AccountNumber varchar Confidential
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name DatabaseLog
Schema Name dbo
Create Date 11.06.2018 13:42:51
Modified Date 11.06.2018 13:43:16
Column Name Data Type Default Not Null Extended Properties
DatabaseLogID int Primary key for
DatabaseLog records.
PostTime datetime The date and time the
DDL change occurred.
DatabaseUser sysname The user who
implemented the DDL
change.
Event sysname The type of DDL
statement that was
executed.
Schema sysname The schema to which
the changed object
belongs.
Object sysname The object that was
changed by the DDL
statment.
TSQL nvarchar The exact Transact-SQL
statement that was
executed.
TSQL nvarchar
TSQL nvarchar ajjjjj
TSQL nvarchar 684a0db2-d514-49d8-
8c0c-df84a7b083eb
TSQL nvarchar ojjjjj
XmlEvent xml The raw XML data
generated by database
trigger.
XmlEvent xml C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
XmlEvent xml Credentials
XmlEvent xml 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
XmlEvent xml Confidential
Table Name dataedo_interfacing_tables
Schema Name dbo
Create Date 30.11.2018 17:57:21
Modified Date 30.11.2018 17:57:21
Column Name Data Type Default Not Null Extended Properties
procedure_name sysname
procedure_schema nvarchar
name nvarchar
position int
parameter_mode nvarchar
datatype nvarchar
data_length int
description sql_variant
Table Name Department
Schema Name HumanResources
Create Date 11.06.2018 13:42:59
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
DepartmentID smallint Primary key for
Department records.
DepartmentID smallint 9C5B4809-0CCC-0637-
6547-91A6F8BB609D
DepartmentID smallint Other
DepartmentID smallint 1866ca45-1973-4c28-
9d12-04d407f147ad
DepartmentID smallint Public
Name dbo.Name Name of the department.
GroupName dbo.Name Name of the group to
which the department
belongs.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Document
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
DocumentNode sys.hierarchyid Primary key for
Document records.
DocumentLevel smallint Depth in the document
hierarchy.
Title nvarchar Title of the document.
Owner int Employee who controls
the document.  Foreign
key to
Employee.BusinessEntit
yID
FolderFlag bit ((0)) 0 = This is a folder, 1 =
This is a document.
FileName nvarchar File name of the
document
FileExtension nvarchar File extension indicating
the document type. For
example, .doc or .txt.
Revision nchar Revision number of the
document.
ChangeNumber int ((0)) Engineering change
approval number.
Status tinyint 1 = Pending approval, 2
= Approved, 3 =
Obsolete
DocumentSummary nvarchar Document abstract.
Document varbinary Complete document.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Required for
FileStream.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name EmailAddress
Schema Name Person
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. Person
associated with this
email address.  Foreign
key to
Person.BusinessEntityID
EmailAddressID int Primary key. ID of this
email address.
EmailAddress nvarchar E-mail address for the
person.
EmailAddress nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
EmailAddress nvarchar Contact Info
EmailAddress nvarchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
EmailAddress nvarchar Confidential
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Employee
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key for
Employee records.
Foreign key to
BusinessEntity.Business
EntityID.
NationalIDNumber nvarchar Unique national
identification number
such as a social security
number.
NationalIDNumber nvarchar 6F5A11A7-08B1-19C3-
59E5-8C89CF4F8444
NationalIDNumber nvarchar National ID
NationalIDNumber nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
NationalIDNumber nvarchar Confidential - GDPR
LoginID nvarchar Network login. Test2
OrganizationNode sys.hierarchyid Where the employee is
located in corporate
hierarchy.
OrganizationLevel smallint The depth of the
employee in the
corporate hierarchy.
JobTitle nvarchar Work title such as Buyer
or Sales Representative.
BirthDate date Date of birth.
MaritalStatus nchar M = Married, S = Single
Gender nchar M = Male, F = Female
HireDate date Employee hired on this
date.
SalariedFlag dbo.Flag ((1)) Job classification. 0 =
Hourly, not exempt from
collective bargaining. 1 =
Salaried, exempt from
collective bargaining.
VacationHours smallint ((0)) Number of available
vacation hours.
SickLeaveHours smallint ((0)) Number of available sick
leave hours.
CurrentFlag dbo.Flag ((1)) 0 = Inactive, 1 = Active
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name EmployeeDepartmentHistory
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Employee identification
number. Foreign key to
Employee.BusinessEntit
yID.
DepartmentID smallint Department in which the
employee worked
including currently.
Foreign key to
Department.DepartmentI
D.
ShiftID tinyint Identifies which 8-hour
shift the employee
works. Foreign key to
Shift.Shift.ID.
StartDate date Date the employee
started work in the
department.
EndDate date Date the employee left
the department. NULL =
Current department.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name EmployeePayHistory
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Employee identification
number. Foreign key to
Employee.BusinessEntit
yID.
RateChangeDate datetime Date the change in pay
is effective
Rate money Salary hourly rate.
PayFrequency tinyint 1 = Salary received
monthly, 2 = Salary
received biweekly
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ErrorLog
Schema Name dbo
Create Date 11.06.2018 13:42:53
Modified Date 11.06.2018 13:42:55
Column Name Data Type Default Not Null Extended Properties
ErrorLogID int Primary key for ErrorLog
records.
ErrorTime datetime (getdate()) The date and time at
which the error occurred.
UserName sysname The user who executed
the batch in which the
error occurred.
UserName sysname C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
UserName sysname Credentials
UserName sysname 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
UserName sysname Confidential
ErrorNumber int The error number of the
error that occurred.
ErrorNumber int C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
ErrorNumber int Credentials
ErrorNumber int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ErrorNumber int Confidential
ErrorSeverity int The severity of the error
that occurred.
ErrorState int The state number of the
error that occurred.
ErrorProcedure nvarchar The name of the stored
procedure or trigger
where the error
occurred.
ErrorProcedure nvarchar D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
ErrorProcedure nvarchar Credit Card
ErrorProcedure nvarchar 1866ca45-1973-4c28-
9d12-04d407f147ad
ErrorProcedure nvarchar Public
ErrorLine int The line number at
which the error occurred.
ErrorLine int C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
ErrorLine int Credentials
ErrorLine int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
ErrorLine int Confidential
ErrorMessage nvarchar The message text of the
error that occurred.
ErrorMessage nvarchar
ErrorMessage nvarchar CredCredWutWut
ErrorMessage nvarchar
ErrorMessage nvarchar ConfConfWutWut
Table Name Illustration
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
IllustrationID int Primary key for
Illustration records.
Diagram xml Illustrations used in
manufacturing
instructions. Stored as
XML.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name JobCandidate
Schema Name HumanResources
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
JobCandidateID int Primary key for
JobCandidate records.
BusinessEntityID int Employee identification
number if applicant was
hired. Foreign key to
Employee.BusinessEntit
yID.
Resume xml Résumé in XML format.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Location
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
LocationID smallint Primary key for Location
records.
Name dbo.Name Location description.
CostRate smallmoney ((0.00)) Standard hourly cost of
the manufacturing
location.
Availability decimal ((0.00)) Work capacity (in hours)
of the manufacturing
location.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Password
Schema Name Person
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int
PasswordHash varchar Password for the e-mail
account.
PasswordHash varchar C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
PasswordHash varchar Credentials
PasswordHash varchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
PasswordHash varchar Confidential
PasswordSalt varchar Random value
concatenated with the
password string before
the password is hashed.
PasswordSalt varchar C64ABA7B-3A3E-95B6-
535D-3BC535DA5A59
PasswordSalt varchar Credentials
PasswordSalt varchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
PasswordSalt varchar Confidential
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Person
Schema Name Person
Create Date 11.06.2018 13:43:11
Modified Date 31.01.2019 16:42:42
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key for Person
records.
PersonType nchar Primary type of person:
SC = Store Contact, IN =
Individual (retail)
customer, SP = Sales
person, EM = Employee
(non-sales), VC =
Vendor contact, GC =
General contact
NameStyle dbo.NameStyle ((0)) 0 = The data in
FirstName and
LastName are stored in
western style (first
name, last name) order.
1 = Eastern style (last
name, first name) order.
Title nvarchar A courtesy title. For
example, Mr. or Ms.
FirstName dbo.Name First name of the
person.
FirstName dbo.Name 57845286-7598-22F5-
9659-15B24AEB125E
FirstName dbo.Name Name
FirstName dbo.Name 989ADC05-3F3F-0588-
A635-F475B994915B
FirstName dbo.Name Confidential - GDPR
MiddleName dbo.Name Middle name or middle
initial of the person.
LastName dbo.Name Last name of the person.
LastName dbo.Name 57845286-7598-22F5-
9659-15B24AEB125E
LastName dbo.Name Name
LastName dbo.Name 989ADC05-3F3F-0588-
A635-F475B994915B
LastName dbo.Name Confidential - GDPR
Suffix nvarchar Surname suffix. For
example, Sr. or Jr.
EmailPromotion int ((0)) 0 = Contact does not
wish to receive e-mail
promotions, 1 = Contact
does wish to receive e-
mail promotions from
AdventureWorks, 2 =
Contact does wish to
receive e-mail
promotions from
AdventureWorks and
selected partners.
AdditionalContactInfo xml Additional contact
information about the
person stored in xml
format.
Demographics xml Personal information
such as hobbies, and
income collected from
online shoppers. Used
for sales analysis.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name PersonCreditCard
Schema Name Sales
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Business entity
identification number.
Foreign key to
Person.BusinessEntityID
.
CreditCardID int Credit card identification
number. Foreign key to
CreditCard.CreditCardID
.
CreditCardID int D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CreditCardID int Credit Card
CreditCardID int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CreditCardID int Confidential
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name PersonPhone
Schema Name Person
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Business entity
identification number.
Foreign key to
Person.BusinessEntityID
.
PhoneNumber dbo.Phone Telephone number
identification number.
PhoneNumber dbo.Phone 5C503E21-22C6-81FA-
620B-F369B8EC38D1
PhoneNumber dbo.Phone Contact Info
PhoneNumber dbo.Phone 989ADC05-3F3F-0588-
A635-F475B994915B
PhoneNumber dbo.Phone Confidential - GDPR
PhoneNumberTypeID int Kind of phone number.
Foreign key to
PhoneNumberType.Pho
neNumberTypeID.
PhoneNumberTypeID int 5C503E21-22C6-81FA-
620B-F369B8EC38D1
PhoneNumberTypeID int Contact Info
PhoneNumberTypeID int 989ADC05-3F3F-0588-
A635-F475B994915B
PhoneNumberTypeID int Confidential - GDPR
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name PhoneNumberType
Schema Name Person
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
PhoneNumberTypeID int Primary key for
telephone number type
records.
PhoneNumberTypeID int 5C503E21-22C6-81FA-
620B-F369B8EC38D1
PhoneNumberTypeID int Contact Info
PhoneNumberTypeID int 989ADC05-3F3F-0588-
A635-F475B994915B
PhoneNumberTypeID int Confidential - GDPR
Name dbo.Name Name of the telephone
number type
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Product
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductID int Primary key for Product
records.
Name dbo.Name Name of the product.
ProductNumber nvarchar Unique product
identification number.
MakeFlag dbo.Flag ((1)) 0 = Product is
purchased, 1 = Product
is manufactured in-
house.
FinishedGoodsFlag dbo.Flag ((1)) 0 = Product is not a
salable item. 1 = Product
is salable.
Color nvarchar Product color.
SafetyStockLevel smallint Minimum inventory
quantity.
ReorderPoint smallint Inventory level that
triggers a purchase
order or work order.
StandardCost money Standard cost of the
product.
ListPrice money Selling price.
Size nvarchar Product size.
SizeUnitMeasureCode nchar Unit of measure for Size
column.
WeightUnitMeasureCode nchar Unit of measure for
Weight column.
Weight decimal Product weight.
DaysToManufacture int Number of days required
to manufacture the
product.
ProductLine nchar R = Road, M =
Mountain, T = Touring, S
= Standard
Class nchar H = High, M = Medium,
L = Low
Style nchar W = Womens, M =
Mens, U = Universal
ProductSubcategoryID int Product is a member of
this product
subcategory. Foreign
key to
ProductSubCategory.Pr
oductSubCategoryID.
ProductModelID int Product is a member of
this product model.
Foreign key to
ProductModel.ProductM
odelID.
SellStartDate datetime Date the product was
available for sale.
SellEndDate datetime Date the product was no
longer available for sale.
DiscontinuedDate datetime Date the product was
discontinued.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductCategory
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductCategoryID int Primary key for
ProductCategory
records.
Name dbo.Name Category description.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductCostHistory
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
ProductID int Product identification
number. Foreign key to
Product.ProductID
StartDate datetime Product cost start date.
EndDate datetime Product cost end date.
StandardCost money Standard cost of the
product.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductDescription
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductDescriptionID int Primary key for
ProductDescription
records.
Description nvarchar Description of the
product.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductDocument
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductID int Product identification
number. Foreign key to
Product.ProductID.
DocumentNode sys.hierarchyid Document identification
number. Foreign key to
Document.DocumentNo
de.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductInventory
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductID int Product identification
number. Foreign key to
Product.ProductID.
LocationID smallint Inventory location
identification number.
Foreign key to
Location.LocationID.
Shelf nvarchar Storage compartment
within an inventory
location.
Bin tinyint Storage container on a
shelf in an inventory
location.
Quantity smallint ((0)) Quantity of products in
the inventory location.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductListPriceHistory
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductID int Product identification
number. Foreign key to
Product.ProductID
StartDate datetime List price start date.
EndDate datetime List price end date
ListPrice money Product list price.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductModel
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductModelID int Primary key for
ProductModel records.
Name dbo.Name Product model
description.
CatalogDescription xml Detailed product catalog
information in xml
format.
Instructions xml Manufacturing
instructions in xml
format.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductModelIllustration
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductModelID int Primary key. Foreign key
to
ProductModel.ProductM
odelID.
IllustrationID int Primary key. Foreign key
to
Illustration.IllustrationID.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductModelProductDescriptionCulture
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductModelID int Primary key. Foreign key
to
ProductModel.ProductM
odelID.
ProductDescriptionID int Primary key. Foreign key
to
ProductDescription.Prod
uctDescriptionID.
CultureID nchar Culture identification
number. Foreign key to
Culture.CultureID.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductPhoto
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductPhotoID int Primary key for
ProductPhoto records.
ThumbNailPhoto varbinary Small image of the
product.
ThumbnailPhotoFileName nvarchar Small image file name.
LargePhoto varbinary Large image of the
product.
LargePhotoFileName nvarchar Large image file name.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductProductPhoto
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductID int Product identification
number. Foreign key to
Product.ProductID.
ProductPhotoID int Product photo
identification number.
Foreign key to
ProductPhoto.ProductPh
otoID.
Primary dbo.Flag ((0)) 0 = Photo is not the
principal image. 1 =
Photo is the principal
image.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductReview
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductReviewID int Primary key for
ProductReview records.
ProductID int Product identification
number. Foreign key to
Product.ProductID.
ReviewerName dbo.Name Name of the reviewer.
ReviewDate datetime (getdate()) Date review was
submitted.
EmailAddress nvarchar Reviewer's e-mail
address.
EmailAddress nvarchar 5C503E21-22C6-81FA-
620B-F369B8EC38D1
EmailAddress nvarchar Contact Info
EmailAddress nvarchar 989ADC05-3F3F-0588-
A635-F475B994915B
EmailAddress nvarchar Confidential - GDPR
Rating int Product rating given by
the reviewer. Scale is 1
to 5 with 5 as the highest
rating.
Comments nvarchar Reviewer's comments
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductSubcategory
Schema Name Production
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductSubcategoryID int Primary key for
ProductSubcategory
records.
ProductCategoryID int Product category
identification number.
Foreign key to
ProductCategory.Produc
tCategoryID.
Name dbo.Name Subcategory description.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ProductVendor
Schema Name Purchasing
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ProductID int Primary key. Foreign key
to Product.ProductID.
BusinessEntityID int Primary key. Foreign key
to
Vendor.BusinessEntityID
.
AverageLeadTime int The average span of
time (in days) between
placing an order with the
vendor and receiving the
purchased product.
StandardPrice money The vendor's usual
selling price.
LastReceiptCost money The selling price when
last purchased.
LastReceiptDate datetime Date the product was
last received by the
vendor.
MinOrderQty int The maximum quantity
that should be ordered.
MaxOrderQty int The minimum quantity
that should be ordered.
OnOrderQty int The quantity currently on
order.
UnitMeasureCode nchar The product's unit of
measure.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name PurchaseOrderDetail
Schema Name Purchasing
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
PurchaseOrderID int Primary key. Foreign key
to
PurchaseOrderHeader.P
urchaseOrderID.
PurchaseOrderDetailID int Primary key. One line
number per purchased
product.
DueDate datetime Date the product is
expected to be received.
OrderQty smallint Quantity ordered.
ProductID int Product identification
number. Foreign key to
Product.ProductID.
UnitPrice money Vendor's selling price of
a single product.
LineTotal money Per product subtotal.
Computed as OrderQty *
UnitPrice.
ReceivedQty decimal Quantity actually
received from the
vendor.
RejectedQty decimal Quantity rejected during
inspection.
StockedQty decimal Quantity accepted into
inventory. Computed as
ReceivedQty -
RejectedQty.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name PurchaseOrderHeader
Schema Name Purchasing
Create Date 11.06.2018 13:43:11
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
PurchaseOrderID int Primary key.
RevisionNumber tinyint ((0)) Incremental number to
track changes to the
purchase order over
time.
Status tinyint ((1)) Order current status. 1 =
Pending; 2 = Approved;
3 = Rejected; 4 =
Complete
EmployeeID int Employee who created
the purchase order.
Foreign key to
Employee.BusinessEntit
yID.
VendorID int Vendor with whom the
purchase order is
placed. Foreign key to
Vendor.BusinessEntityID
.
ShipMethodID int Shipping method.
Foreign key to
ShipMethod.ShipMethod
ID.
OrderDate datetime (getdate()) Purchase order creation
date.
ShipDate datetime Estimated shipment date
from the vendor.
SubTotal money ((0.00)) Purchase order subtotal.
Computed as SUM
(PurchaseOrderDetail.Li
neTotal)for the
appropriate
PurchaseOrderID.
TaxAmt money ((0.00)) Tax amount.
TaxAmt money ((0.00)) C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
TaxAmt money ((0.00)) Financial
TaxAmt money ((0.00)) 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
TaxAmt money ((0.00)) Confidential
Freight money ((0.00)) Shipping cost.
TotalDue money Total due to vendor.
Computed as Subtotal +
TaxAmt + Freight.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesOrderDetail
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 28.08.2018 13:08:19
Column Name Data Type Default Not Null Extended Properties
SalesOrderID int Primary key. Foreign key
to
SalesOrderHeader.Sale
sOrderID.
SalesOrderDetailID int Primary key. One
incremental unique
number per product
sold.
CarrierTrackingNumber nvarchar Shipment tracking
number supplied by the
shipper.
OrderQty smallint Quantity ordered per
product.
ProductID int Product sold to
customer. Foreign key to
Product.ProductID.
SpecialOfferID int Promotional code.
Foreign key to
SpecialOffer.SpecialOffe
rID.
UnitPrice money Selling price of a single
product.
UnitPriceDiscount money ((0.0)) Discount amount.
LineTotal numeric Per product subtotal.
Computed as UnitPrice *
(1 - UnitPriceDiscount) *
OrderQty.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesOrderHeader
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 28.08.2018 13:08:19
Column Name Data Type Default Not Null Extended Properties
SalesOrderID int Primary key.
RevisionNumber tinyint ((0)) Incremental number to
track changes to the
sales order over time.
OrderDate datetime (getdate()) Dates the sales order
was created.
DueDate datetime Date the order is due to
the customer.
ShipDate datetime Date the order was
shipped to the customer.
Status tinyint ((1)) Order current status. 1 =
In process; 2 =
Approved; 3 =
Backordered; 4 =
Rejected; 5 = Shipped; 6
= Cancelled
OnlineOrderFlag dbo.Flag ((1)) 0 = Order placed by
sales person. 1 = Order
placed online by
customer.
SalesOrderNumber nvarchar Unique sales order
identification number.
PurchaseOrderNumber dbo.OrderNumber Customer purchase
order number reference.
AccountNumber dbo.AccountNumb
er		 Financial accounting
number reference.
AccountNumber dbo.AccountNumb
er		 C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
AccountNumber dbo.AccountNumb
er		 Financial
AccountNumber dbo.AccountNumb
er		 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
AccountNumber dbo.AccountNumb
er		 Confidential
CustomerID int Customer identification
number. Foreign key to
Customer.BusinessEntit
yID.
SalesPersonID int Sales person who
created the sales order.
Foreign key to
SalesPerson.BusinessE
ntityID.
TerritoryID int Territory in which the
sale was made. Foreign
key to
SalesTerritory.SalesTerri
toryID.
BillToAddressID int Customer billing
address. Foreign key to
Address.AddressID.
ShipToAddressID int Customer shipping
address. Foreign key to
Address.AddressID.
ShipMethodID int Shipping method.
Foreign key to
ShipMethod.ShipMethod
ID.
CreditCardID int Credit card identification
number. Foreign key to
CreditCard.CreditCardID
.
CreditCardID int D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CreditCardID int Credit Card
CreditCardID int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CreditCardID int Confidential
CreditCardApprovalCode varchar Approval code provided
by the credit card
company.
CreditCardApprovalCode varchar D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CreditCardApprovalCode varchar Credit Card
CreditCardApprovalCode varchar 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CreditCardApprovalCode varchar Confidential
CurrencyRateID int Currency exchange rate
used. Foreign key to
CurrencyRate.Currency
RateID.
CurrencyRateID int C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
CurrencyRateID int Financial
CurrencyRateID int 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CurrencyRateID int Confidential
SubTotal money ((0.00)) Sales subtotal.
Computed as SUM
(SalesOrderDetail.LineT
otal)for the appropriate
SalesOrderID.
TaxAmt money ((0.00)) Tax amount.
TaxAmt money ((0.00)) C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
TaxAmt money ((0.00)) Financial
TaxAmt money ((0.00)) 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
TaxAmt money ((0.00)) Confidential
Freight money ((0.00)) Shipping cost.
TotalDue money Total due from customer.
Computed as Subtotal +
TaxAmt + Freight.
Comment nvarchar Sales representative
comments.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesOrderHeaderSalesReason
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
SalesOrderID int Primary key. Foreign key
to
SalesOrderHeader.Sale
sOrderID.
SalesReasonID int Primary key. Foreign key
to
SalesReason.SalesReas
onID.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesPerson
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key for
SalesPerson records.
Foreign key to
Employee.BusinessEntit
yID
TerritoryID int Territory currently
assigned to. Foreign key
to
SalesTerritory.SalesTerri
toryID.
SalesQuota money Projected yearly sales.
Bonus money ((0.00)) Bonus due if quota is
met.
CommissionPct smallmoney ((0.00)) Commision percent
received per sale.
SalesYTD money ((0.00)) Sales total year to date.
SalesLastYear money ((0.00)) Sales total of previous
year.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesPersonQuotaHistory
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Sales person
identification number.
Foreign key to
SalesPerson.BusinessE
ntityID.
QuotaDate datetime Sales quota date.
SalesQuota money Sales quota amount.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesReason
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
SalesReasonID int Primary key for
SalesReason records.
Name dbo.Name Sales reason
description.
ReasonType dbo.Name Category the sales
reason belongs to.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesTaxRate
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
SalesTaxRateID int Primary key for
SalesTaxRate records.
SalesTaxRateID int 6F5A11A7-08B1-19C3-
59E5-8C89CF4F8444
SalesTaxRateID int National ID
SalesTaxRateID int 989ADC05-3F3F-0588-
A635-F475B994915B
SalesTaxRateID int Confidential - GDPR
StateProvinceID int State, province, or
country/region the sales
tax applies to.
TaxType tinyint 1 = Tax applied to retail
transactions, 2 = Tax
applied to wholesale
transactions, 3 = Tax
applied to all sales (retail
and wholesale)
transactions.
TaxType tinyint C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
TaxType tinyint Financial
TaxType tinyint 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
TaxType tinyint Confidential
TaxRate smallmoney ((0.00)) Tax rate amount.
TaxRate smallmoney ((0.00)) C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
TaxRate smallmoney ((0.00)) Financial
TaxRate smallmoney ((0.00)) 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
TaxRate smallmoney ((0.00)) Confidential
Name dbo.Name Tax rate description.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesTerritory
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
TerritoryID int Primary key for
SalesTerritory records.
Name dbo.Name Sales territory
description
CountryRegionCode nvarchar ISO standard country or
region code. Foreign key
to
CountryRegion.Country
RegionCode.
Group nvarchar Geographic area to
which the sales territory
belong.
SalesYTD money ((0.00)) Sales in the territory
year to date.
SalesLastYear money ((0.00)) Sales in the territory the
previous year.
CostYTD money ((0.00)) Business costs in the
territory year to date.
CostLastYear money ((0.00)) Business costs in the
territory the previous
year.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SalesTerritoryHistory
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. The sales
rep.  Foreign key to
SalesPerson.BusinessE
ntityID.
TerritoryID int Primary key. Territory
identification number.
Foreign key to
SalesTerritory.SalesTerri
toryID.
StartDate datetime Primary key. Date the
sales representive
started work in the
territory.
EndDate datetime Date the sales
representative left work
in the territory.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ScrapReason
Schema Name Production
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ScrapReasonID smallint Primary key for
ScrapReason records.
Name dbo.Name Failure description.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Shift
Schema Name HumanResources
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:18
Column Name Data Type Default Not Null Extended Properties
ShiftID tinyint Primary key for Shift
records.
Name dbo.Name Shift description.
StartTime time Shift start time.
EndTime time Shift end time.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ShipMethod
Schema Name Purchasing
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ShipMethodID int Primary key for
ShipMethod records.
Name dbo.Name Shipping company
name.
ShipBase money ((0.00)) Minimum shipping
charge.
ShipRate money ((0.00)) Shipping charge per
pound.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name ShoppingCartItem
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
ShoppingCartItemID int Primary key for
ShoppingCartItem
records.
ShoppingCartID nvarchar Shopping cart
identification number.
Quantity int ((1)) Product quantity
ordered.
ProductID int Product ordered.
Foreign key to
Product.ProductID.
DateCreated datetime (getdate()) Date the time the record
was created.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SpecialOffer
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
SpecialOfferID int Primary key for
SpecialOffer records.
Description nvarchar Discount description.
DiscountPct smallmoney ((0.00)) Discount precentage.
Type nvarchar Discount type category.
Category nvarchar Group the discount
applies to such as
Reseller or Customer.
StartDate datetime Discount start date.
EndDate datetime Discount end date.
MinQty int ((0)) Minimum discount
percent allowed.
MaxQty int Maximum discount
percent allowed.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name SpecialOfferProduct
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
SpecialOfferID int Primary key for
SpecialOfferProduct
records.
ProductID int Product identification
number. Foreign key to
Product.ProductID.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name StateProvince
Schema Name Person
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:20
Column Name Data Type Default Not Null Extended Properties
StateProvinceID int Primary key for
StateProvince records.
StateProvinceCode nchar ISO standard state or
province code.
CountryRegionCode nvarchar ISO standard country or
region code. Foreign key
to
CountryRegion.Country
RegionCode.
IsOnlyStateProvinceFlag dbo.Flag ((1)) 0 = StateProvinceCode
exists. 1 =
StateProvinceCode
unavailable, using
CountryRegionCode.
Name dbo.Name State or province
description.
TerritoryID int ID of the territory in
which the state or
province is located.
Foreign key to
SalesTerritory.SalesTerri
toryID.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Store
Schema Name Sales
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key. Foreign key
to
Customer.BusinessEntit
yID.
Name dbo.Name Name of the store.
SalesPersonID int ID of the sales person
assigned to the
customer. Foreign key to
SalesPerson.BusinessE
ntityID.
Demographics xml Demographic
informationg about the
store such as the
number of employees,
annual sales and store
type.
rowguid uniqueidentifier (newid()) ROWGUIDCOL number
uniquely identifying the
record. Used to support
a merge replication
sample.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name sysdiagrams
Schema Name dbo
Create Date 09.10.2018 12:32:03
Modified Date 09.10.2018 12:32:03
Column Name Data Type Default Not Null Extended Properties
name sysname
principal_id int
diagram_id int
version int
definition varbinary
Table Name TransactionHistory
Schema Name Production
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
TransactionID int Primary key for
TransactionHistory
records.
ProductID int Product identification
number. Foreign key to
Product.ProductID.
ReferenceOrderID int Purchase order, sales
order, or work order
identification number.
ReferenceOrderLineID int ((0)) Line number associated
with the purchase order,
sales order, or work
order.
TransactionDate datetime (getdate()) Date and time of the
transaction.
TransactionType nchar W = WorkOrder, S =
SalesOrder, P =
PurchaseOrder
Quantity int Product quantity.
ActualCost money Product cost.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name TransactionHistoryArchive
Schema Name Production
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:17
Column Name Data Type Default Not Null Extended Properties
TransactionID int Primary key for
TransactionHistoryArchi
ve records.
ProductID int Product identification
number. Foreign key to
Product.ProductID.
ReferenceOrderID int Purchase order, sales
order, or work order
identification number.
ReferenceOrderLineID int ((0)) Line number associated
with the purchase order,
sales order, or work
order.
TransactionDate datetime (getdate()) Date and time of the
transaction.
TransactionType nchar W = Work Order, S =
Sales Order, P =
Purchase Order
Quantity int Product quantity.
ActualCost money Product cost.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name UnitMeasure
Schema Name Production
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
UnitMeasureCode nchar Primary key.
Name dbo.Name Unit of measure
description.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name Vendor
Schema Name Purchasing
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
BusinessEntityID int Primary key for Vendor
records.  Foreign key to
BusinessEntity.Business
EntityID
AccountNumber dbo.AccountNumb
er		 Vendor account
(identification) number.
AccountNumber dbo.AccountNumb
er		 C44193E1-0E58-4B2A-
9001-F7D6E7BC1373
AccountNumber dbo.AccountNumb
er		 Financial
AccountNumber dbo.AccountNumb
er		 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
AccountNumber dbo.AccountNumb
er		 Confidential
Name dbo.Name Company name.
CreditRating tinyint 1 = Superior, 2 =
Excellent, 3 = Above
average, 4 = Average, 5
= Below average
CreditRating tinyint D22FA6E9-5EE4-3BDE-
4C2B-A409604C4646
CreditRating tinyint Credit Card
CreditRating tinyint 331F0B13-76B5-2F1B-
A77B-DEF5A73C73C2
CreditRating tinyint Confidential
PreferredVendorStatus dbo.Flag ((1)) 0 = Do not use if another
vendor is available. 1 =
Preferred over other
vendors supplying the
same product.
ActiveFlag dbo.Flag ((1)) 0 = Vendor no longer
used. 1 = Vendor is
actively used.
PurchasingWebServiceUR
L		 nvarchar Vendor URL.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name WorkOrder
Schema Name Production
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
WorkOrderID int Primary key for
WorkOrder records.
ProductID int Product identification
number. Foreign key to
Product.ProductID.
OrderQty int Product quantity to build.
StockedQty int Quantity built and put in
inventory.
ScrappedQty smallint Quantity that failed
inspection.
StartDate datetime Work order start date.
EndDate datetime Work order end date.
DueDate datetime Work order due date.
ScrapReasonID smallint Reason for inspection
failure.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
Table Name WorkOrderRouting
Schema Name Production
Create Date 11.06.2018 13:43:12
Modified Date 11.06.2018 13:43:19
Column Name Data Type Default Not Null Extended Properties
WorkOrderID int Primary key. Foreign key
to
WorkOrder.WorkOrderID
.
ProductID int Primary key. Foreign key
to Product.ProductID.
OperationSequence smallint Primary key. Indicates
the manufacturing
process sequence.
LocationID smallint Manufacturing location
where the part is
processed. Foreign key
to Location.LocationID.
ScheduledStartDate datetime Planned manufacturing
start date.
ScheduledEndDate datetime Planned manufacturing
end date.
ActualStartDate datetime Actual start date.
ActualEndDate datetime Actual end date.
ActualResourceHrs decimal Number of
manufacturing hours
used.
PlannedCost money Estimated manufacturing
cost.
ActualCost money Actual manufacturing
cost.
ModifiedDate datetime (getdate()) Date and time the record
was last updated.
wtorek, 23 kwietnia 2019 Page 1 of 1