Product identifiers in our industry are commonly longer than 20 characters. id and id-ne fields are defined as 20 character fields for all the databases I have looked at, and there seems to be some tight binding to the 20 character length in forms and screen templates. We are wondering how much work we would need to do, in order to change Product id's to id-longs. That sounds pretty big at first glance, since there is so much going on with Product in so many applications. Another option would be to standardize some kind of SKU and cross reference that to a domain-specific product ID but that would be much less convenient for the users.
Please advise. -- James McGill Phoenix AZ
