Skip to main content

We need to create a Custom Field for the EORI number and would like to know how to handle the fact that we require the following format:

 

First 2 characters (Alpha)

Next 12 characters (numeric)

 

Would I have to create the field as a text field and then run a custom event to check that the contents meet the format?

Can anyone please advise a better way?

Thank you.

Hi @johnw66 ,

Unfortunately yes since we do not control alphanumeric in custom fields. You have to create a custom field in text and then write an event (PLSQL code) _CFT table to validate the format. 

Thanks,

Kind Regards,