Export (0) Print
Expand All
Expand Minimize

VendorContact Table (AdventureWorks)

Is a cross-reference table that maps vendors and their employees with whom employees of Adventure Works Cycles do business. For example, a buyer from Adventure Works Cycles would contact a sales representative at the vendor in order to purchase parts or products.

The VendorContact table is contained in the Purchasing schema.

Column

Data type

Nullability

Description

VendorID

int

Not null

Primary key.

ContactID

int

Not null

Identification number of the contact, the vendor employee. Foreign key to Contact.ContactID.

ContactTypeID

int

Not null

Contact type such as sales manager, or sales agent.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

Community Additions

ADD
Show:
© 2014 Microsoft