This problem also appears to be in SO_InvoiceTracking. The field size is 15 characters, however more data is being stored in the field than what the File Layouts state.

This could cause problems. Alnoor is the one person who could tell you what will happen.

I'm not sure what you mean by "this could cause problems"? There's more data in the field than what ODBC pulls. It's been this way for years. The issue is that the ODBC definition doesn't seem to be pulling enough characters in either of those tables.

No, BigLouie is right.  The problem is not the ODBC return, since that uses the table's data dictionary.  The real issue is how the bad data (larger than the data dictionary field size) is getting into the table.  That should be technically impossible.

The field is "StarshipShipVia". The data is being written by Starship.

The field is "StarshipShipVia". The data is being written by Starship.

Yes, but that doesn't mean the data is being written with proper error checking.  If they need more than 15 characters, the field should be made larger (by them / Sage).  The fact they are writing data beyond the character limit is a problem for Starship / Sage to solve.

Since it sounds like this is recurring for you, opening a case with Sage might be a good idea.

It sounds like this is a Starship issue for not writing data within the confines of Sage's data dictionary, or  a Sage issue for not having a field size large enough to accommodate the data coming from Starship. I foresee finger pointing from both parties!