Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Is a cross-reference table that maps vendors and their addresses. Vendors may have more than one address; for example, a vendor may have separate billing and shipping addresses.
VendorAddress Table Definition
The VendorAddress table is contained in the Purchasing schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
VendorID |
int |
Not null |
Primary key. Foreign key to Vendor.VendorID. |
AddressID |
int |
Not null |
Primary key. Foreign key to Address.AddressID. |
AddressTypeID |
int |
Not null |
Address type. Foreign key to AddressType.AddressTypeID. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Address Table (AdventureWorks)
AddressType Table (AdventureWorks)
Vendor Table (AdventureWorks)
VendorContact Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary