Purchasing.VendorContact (table)

wikibot

Table

Purchasing.VendorContact

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())

Relation	Column	Referenced Column
Person.Contact	ContactID	ContactID
Person.ContactType	ContactTypeID	ContactTypeID
Purchasing.Vendor	VendorID	VendorID

automatically generated

Table	Purchasing.VendorContact
Description	Cross-reference table mapping vendors and their employees.

Column	Data Type	Nullable	Default	Description	PK / Index
VendorID	int	not null		Primary key.	PK_VendorContact_VendorID_ContactID
ContactID	int	not null		Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.	PK_VendorContact_VendorID_ContactIDIX_VendorContact_ContactID
ContactTypeID	int	not null		Contact type such as sales manager, or sales agent.	IX_VendorContact_ContactTypeID
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Person.Contact	ContactID	ContactID
Person.ContactType	ContactTypeID	ContactTypeID
Purchasing.Vendor	VendorID	VendorID