Hi,

I am trying to integrate Sage 100 UDFs with our application's UI. I was going to read UDF caption and data type. Our end users are supposed to search Sage 100 orders using a UDF field; so we wanted to show the title properly, and adjust search conditions available to the user based on UDF data type.

How can I get access to CM_UDF table to read UDF's data?

The maximum I was able to do is to create a CM_Customizer_SVC object and get its fields with sFetchTableCols("CM_UDF").

I saw somebody on this forum using ODBC to get CM_UDF data, but wanted to avoid adding that dependency to our app.