What are some of the limitations of the Sage 100 UDF (User Defined Fields)
Resolution:
- Maximum number of fields per table = 1,000 fields
- Maximum number of UDF’s per table = 1,000 minus the number of fields already defined in table
- Example, if table already contains 19 fields, then we can create 981 UDFs (1,000-19=981)
- Maximum number of bytes per table = 20,000 Bytes
- Maximum length of UDF = 8,000 Bytes
- The total number of bytes, or characters, for all existing fields and UDF’s for a table cannot exceed 20,000 Bytes