Purchasing.VendorContact (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:20Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:40Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:50Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:34Z

Bot at 05:38, 30 November 2009

2009-11-30T05:38:45Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:12Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:25Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:37Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:49Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.VendorContact |- |} {| border="1" cellpadding="5" cellspacing="0"...

2009-01-03T12:35:25Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.VendorContact |- |} {| border="1" cellpadding="5" cellspacing="0"...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Purchasing.VendorContact
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| VendorID
| int
| not null
|
| PK_VendorContact_VendorID_ContactID
|
|-
| ContactID
| int
| not null
|
| PK_VendorContact_VendorID_ContactID
| IX_VendorContact_ContactID
|-
| ContactTypeID
| int
| not null
|
|
| IX_VendorContact_ContactTypeID
|-
| ModifiedDate
| datetime
| not null
| (getdate())
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[Person.Contact_(table)|Person.Contact]]
| ContactID
| ContactID
|-
| [[Person.ContactType_(table)|Person.ContactType]]
| ContactTypeID
| ContactTypeID
|-
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| VendorID
| VendorID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Purchasing.VendorContact
@@ Line 8: / Line 8: @@
 | '''Description
 | Cross-reference table mapping vendors and their employees.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | VendorID
@@ Line 52: / Line 50: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_VendorContact_VendorID_ContactID
 | VendorID, ContactID
@@ Line 63: / Line 61: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_VendorContact_ContactID
+|
 | ContactID
-|-
+|- valign="top"
 | IX_VendorContact_ContactTypeID
+|
@@ Line 80: / Line 78: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.Contact_(table)|Person.Contact]]
 | ContactID
 | ContactID
-|-
+|- valign="top"
 | [[Person.ContactType_(table)|Person.ContactType]]
 | ContactTypeID
 | ContactTypeID
-|-
+|- valign="top"
 | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 | VendorID
@@ Line 102: / Line 100: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 116: / Line 114: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
-|-
+|- 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 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key.<br />PK_VendorContact_VendorID_ContactID
+| Primary key.
 |- valign="top"
 | ContactID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.<br />PK_VendorContact_VendorID_ContactIDIX_VendorContact_ContactID
+| Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.
 |- valign="top"
 | ContactTypeID
@@ Line 37: / Line 38: @@
 | not null
+|
-| Contact type such as sales manager, or sales agent.<br />IX_VendorContact_ContactTypeID
+| Contact type such as sales manager, or sales agent.
 |- valign="top"
 | ModifiedDate
@@ Line 43: / Line 44: @@
 | 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"
 |- style="background:silver"
@@ Line 68: / Line 95: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 86: / Line 127: @@
 |}

@@ Line 76: / Line 76: @@
 | Purchasing.VendorContact
 |- valign="top"
 | '''Description
 | Cross-reference table mapping vendors and their employees.
 |-
 |}

@@ Line 143: / Line 143: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}
@@ Line 156: / Line 157: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
-| View
 | Select
-|-
+| SQL table-valued-function
 | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
-| SQL table-valued-function
 |}

@@ Line 138: / Line 138: @@
 | VendorID
 | VendorID
 |}
@@ Line 146: / Line 159: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]