How can I add a field to the SY_Country table?

We are being forced to integrate with two other systems that don't allow 3 character country codes.  Therefore, I have been forced to add 2 char country codes to our country table.  Using the alt-country code field was not an option for these integrations.   Due to the relationship between country code and country description on decades worth of history, the 3 char code can't be removed.  I want to add a field so that I can filter the country lookup lists to not show the 3 char country codes.  I'm open to any and all suggestions.

Thanks,

Kevin

  • 0

    Since you can't add UDFs to SY_Country, you are going to have to use an alternate method to map the country codes.

    What kind of integration is it?  Do you export data from Sage 100?  If yes, do you use VI Export or ODBC?  If ODBC, one way to do this would be to create a UDT under the SY/SYS/System Module and have the key field 3 characters and another UDF that is 2 characters.  Then populate it with the mappings for the company codes.