Person.ContactType (table)

wikibot

Table

Person.ContactType

Column	Data Type	Nullable	Default	PK	Index
ContactTypeID	int	not null		PK_ContactType_ContactTypeID
Name	dbo.Name	not null			AK_ContactType_Name
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Sales.StoreContact	ContactTypeID	ContactTypeID
Purchasing.VendorContact	ContactTypeID	ContactTypeID

wikivalues

Table Values

Person.ContactType

ContactTypeID	Name
1	Accounting Manager
2	Assistant Sales Agent
3	Assistant Sales Representative
4	Coordinator Foreign Markets
5	Export Administrator
6	International Marketing Manager
7	Marketing Assistant
8	Marketing Manager
9	Marketing Representative
10	Order Administrator
11	Owner
12	Owner/Marketing Assistant
13	Product Manager
14	Purchasing Agent
15	Purchasing Manager
16	Regional Account Representative
17	Sales Agent
18	Sales Associate
19	Sales Manager
20	Sales Representative