Source of the ID that connects vendors, customers, and employees with address and contact information.

Package Physical datamodel example
Author Bert Dingemans
Alias --
Stereotypes table


Name Type Cardinality Description
BusinessEntityID int 1 - 1Primary key for all customers, vendors, and employees.
rowguid uniqueidentifier 1 - 1ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime 1 - 1Date and time the record was last updated.


NameSourceSource attributeTargetTarget attribute
BusinessEntityID BusinessEntityBusinessEntityIDBusinessEntityBusinessEntityID
rowguid BusinessEntityrowguidBusinessEntityrowguid
ModifiedDate BusinessEntityModifiedDateBusinessEntityModifiedDate


Physical example project

Data Mapping

Linked elements