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.
+9
Hi
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,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
