Sage 100

When adding UDF's to a table such as AP_Vendor, what is the maximum number of characters allowed in a row? I think I saw that discussed in an earlier string but want to avoid an issue. A customer wants to add a note in vendor maintenance that is included on all PO's issued for that vendor. We will add a text UDF to the AP_Vendor column. I want to stay under the maximum allowed and leave room for additional columns should they be needed.

Each table has a limit around 13,000 characters, that includes the standard Sage fields. I posted something earlier about the work table that I thought it had less characters available than the other tables, because I did not realize that the limit included the standard fields. if you are adding these to the vendor master table and want to print them on the PO, you can link in the vendor master or you can add the UDFto the PO_PurchaseOrderWrk table. if you want to add it to the work table, check the available limit there first (and leave some extra for future fields :) )

@DavidOverholt that helps. We intend to link the UDF to the work table. It find it makes things smoother on the back end.

If there are common notes among the vendors, you might consider using a user defined table, linking the key to the vendor and the work file.