Skip to Content
0
Former Member
Feb 16, 2009 at 05:15 PM

Validation Expression: Unique record by non-qualified value

66 Views

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