I have a Business Partner repository that contain a Qualifier Table "Tax Number Type". In the Main Table, I have a field typed qualified flat called "Tax Numbers".
The "Tax Number Type" table have the folowing fields:
Tax Number Type: Qualifier = NO - the values are: BR1, BR2, BR3, BR4.
Tax Number: Qualifier = YES
I need to verify if there are more than one value of the "Tax Number" in a record. For example:
Record 1 (correct)
-- Tax Numbers:
-
BR1, 123321
-
BR2, 988191
Record 1 (Error: BR1 is duplicated)
-- Tax Numbers:
-
BR1, 123321
-
BR1, 988191
How to do this validation in the MDM?
Thank you,
Evandro