What is the maximum number of UDF's you can create for the Sales Order Detail table?

SOLVED

In general is there a maximum number of UDF's per table.

And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium (SQL).

Parents
  • 0
    SUGGESTED

    It's not the max number of UDFs it is the total size. There is a limit on the total size of all UDFs you can create. So if all the UDFs are just 4-5 bytes then you can create a lot but if they are 100-200 then you can create less. When you create a UDF on the upper right hand corner it shows how many in size you have left.

    This from the Help files:

    You can create any number of user-defined fields (UDFs) for a given entity; however, the total number of characters for all UDFs cannot exceed 20,000. When a new UDF is created or a change is made to an existing UDF, the ODBC Dictionary file and other system files are updated automatically to reflect the changes.

  • 0 in reply to BigLouie

    So if I create a UDF that has 10 characters, I can create 1000 UDF's? By characters, do you mean the field characters. So if I had a numeric field with 10 characters, that would be 10 characters? And I assume that it does not include the label?

  • +1 in reply to saacks
    verified answer

Reply Children