Person.ContactType (table) - Revision history

Bot at 08:55, 27 August 2011

2011-08-27T08:55:03Z

Bot at 22:18, 23 June 2010

2010-06-23T22:18:23Z

Bot at 22:16, 23 June 2010

2010-06-23T22:16:20Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:41Z

Bot at 21:36, 2 February 2010

2010-02-02T21:36:49Z

Bot at 22:27, 28 December 2009

2009-12-28T22:27:48Z

Bot at 22:24, 28 December 2009

2009-12-28T22:24:35Z

Bot at 22:12, 28 December 2009

2009-12-28T22:12:59Z

Show changes

Bot at 21:57, 28 December 2009

2009-12-28T21:57:30Z

Show changes

Bot at 21:54, 28 December 2009

2009-12-28T21:54:09Z

← Older revision		Revision as of 08:55, 27 August 2011
Line 121:		Line 121:

	\|}		\|}
		+
		+
	== wikivalues ==		== wikivalues ==

@@ Line 121: / Line 121: @@
 |}
 == wikivalues ==
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table Values
 | Person.ContactType
 |}
 | '''ContactTypeID
 | '''Name
-|-
+|- valign="top"
 |	1
-|	Accounting Manager
+| 1
-|-
+| Accounting Manager
-|	2
+|- valign="top"
 |	Assistant Sales Agent
-|-
+| 2
-|	3
+| Assistant Sales Agent
-|	Assistant Sales Representative
+|- valign="top"
 |-
-|	4
+| 3
-|	Coordinator Foreign Markets
+| Assistant Sales Representative
-|-
+|- valign="top"
 |	5
-|	Export Administrator
+| 4
-|-
+| Coordinator Foreign Markets
-|	6
+|- valign="top"
 |	International Marketing Manager
-|-
+| 5
-|	7
+| Export Administrator
-|	Marketing Assistant
+|- valign="top"
 |-
-|	8
+| 6
-|	Marketing Manager
+| International Marketing Manager
-|-
+|- valign="top"
 |	9
-|	Marketing Representative
+| 7
-|-
+| Marketing Assistant
-|	10
+|- valign="top"
 |	Order Administrator
-|-
+| 8
-|	11
+| Marketing Manager
-|	Owner
+|- valign="top"
 |-
-|	12
+| 9
-|	Owner/Marketing Assistant
+| Marketing Representative
-|-
+|- valign="top"
 |	13
-|	Product Manager
+| 10
-|-
+| Order Administrator
-|	14
+|- valign="top"
 |	Purchasing Agent
-|-
+| 11
-|	15
+| Owner
-|	Purchasing Manager
+|- valign="top"
 |-
-|	16
+| 12
-|	Regional Account Representative
+| Owner/Marketing Assistant
-|-
+|- valign="top"
 |	17
-|	Sales Agent
+| 13
-|-
+| Product Manager
-|	18
+|- valign="top"
 |	Sales Associate
-|-
+| 14
-|	19
+| Purchasing Agent
-|	Sales Manager
+|- valign="top"
 |-
-|	20
+| 15
-|	Sales Representative
+| Purchasing Manager
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Person.ContactType
@@ Line 8: / Line 8: @@
 | '''Description
 | Lookup table containing the types of contacts stored in Contact.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ContactTypeID
@@ Line 46: / Line 44: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ContactType_ContactTypeID
 | ContactTypeID
@@ Line 57: / Line 55: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_ContactType_Name
 | Unique
@@ Line 70: / Line 68: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.StoreContact_(table)|Sales.StoreContact]]
 | ContactTypeID
 | ContactTypeID
-|-
+|- valign="top"
 | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
 | ContactTypeID
@@ Line 88: / Line 86: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Data Type
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 107: / Line 105: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
-|-
+|- valign="top"
 | Select
 | View
 | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
-|-
+|- valign="top"
 | Select
 | SQL table-valued-function

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 40: / Line 41: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 49: / Line 51: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 61: / Line 64: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 77: / Line 81: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 88: / Line 92: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 114: / Line 123: @@
 |}

@@ Line 18: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 25: @@
 | not null
+|
-| Primary key for ContactType records.<br />PK_ContactType_ContactTypeID
+| Primary key for ContactType records.
 |- valign="top"
 | Name
@@ Line 31: / Line 31: @@
 | not null
+|
-| Contact type description.<br />AK_ContactType_Name
+| Contact type description.
 |- valign="top"
 | ModifiedDate
@@ Line 37: / Line 37: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
@@ Line 95: / Line 114: @@
 |}
 == wikivalues ==

← Older revision		Revision as of 22:27, 28 December 2009
Line 95:		Line 95:

	\|}		\|}
−
−
−
	== wikivalues ==		== wikivalues ==

← Older revision		Revision as of 22:24, 28 December 2009
Line 95:		Line 95:

	\|}		\|}
		+
		+
		+
	== wikivalues ==		== wikivalues ==