Sage 100

Sage 100 2013 Premium. I want to add rows to the SY_ZipCode table from an external source. Normally, I would use VI to do this but I can't see any conflicts working directly with this simple table. I can't see any downside to inserting rows directly through SQL to this table as there don't seem to be any directly related tables, no surrogate keys, and no values assigned from another table. Someone with more knowledge step in here and tell me if I'm about to walk into a dragon's den!

Personally I think you are safe. I believe it does validate the country code but it is a very basic table. I would do it especially in SQL.

There is the Sy_ZipCodeEdit table but I don't think you need to worry about that. Yes it validates the country code like Jim said. Yeah go for it.

@JimWoodhead and @AlnoorCassim, thank you for the input. I'm going to go forward and see if anything shakes out. I currently have the country code hard-coded to USA but will be sure to add validation logic to the process to ensure the zip code is 5 or 9 characters long, thus watching for foreign postal codes.