Domain Attributes:Across entity

Category: sql server masterdata


Sunil Samanth on Tue, 04 Dec 2012 10:15:24

Hi All,

We have a Customer Entity with attributes Code,Name,CustomerNumber,CustomerName,FirstName,LastName

Account Entity with attributes Code,Name,AccountNumber,AccountStartDate,AccountEndDate,AccountMaturityDate

Account-Customer_Relation Entity : Code,Name,CustomerCode,AccountCode

We need other attributes of customer and account as well in the Account-Customer_Relation entity.For ex: We need CustomerName,FirstName,LastName,AccountStartDate,AccountEnddate.

Is there any way to model this in MDS