Unique field for integration

[Former Member]

Hi all,

I want to create an interface from C4C to external ERP system.

in the ERP system, address name is a primary key. since this is not the situation in C4C, I want to create a new field "ERP Address ID" which will have a unique id for this address in a specfic account.

Is there any way to make a field unique? (=won't allow duplicates value)

Thanks,

Dror

[Former Member]

Hi Dror,

this is possible, however somewhat complicated.

The prefered way using the studio is to declare an element as "AlternativeKey".

However this is not possible for extension fields.

So to use this feature, you need to create a second custom Business Object with your ERP Address ID as alternative key and have an association to reference the standard C4C business object.

Secondly, you need to make sure (using custom logic) that no two of your custom business objects references the same standard business object.

Best regards,

Ludger

--

Custom Development with All4Cloud.de

[HorstSchaude]

Hello,

You can also create an AfterModify ABSL snippet which does check for duplicate values.

Bye,

   Horst