Difference between revisions of "Person.ContactType (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Person.ContactType |- |} {| border="1" cellpadding="5" cellspacing="0" style...)
 
Line 57: Line 57:
 
| ContactTypeID
 
| ContactTypeID
 
| ContactTypeID
 
| ContactTypeID
 +
|}
 +
 +
== wikivalues ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table Values
 +
| Person.ContactType
 +
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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
 
|}
 
|}

Revision as of 15:53, 3 January 2009

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Person.ContactType_(table)&oldid=298"