What are you trying to do and what version of Sage 100 are you on?

I am using sage 100 ERP 2013(v 5.00).

There is a third party application for which I am developing new feature. I want the users of that application to create/update records in Sage 100 ERP. I will be using BOI to post data to Sage 100. Now, the users of Sage 100 ERP do create custom fields a lot of time and there is also an option to make these custom fields mandatory. Hence, I want to fetch the details of all custom fields created for a particular entity, say "customer"(AR_Customer) and generate controls on the fly in my form based on the details fetched from Sage 100. 

The detail about the custom fields exists in table "CM_UDF". But this file seems to shared by various companies created in Sage 100 ERP. To sum it up, I am trying to find out a way to use BOI to query this file "CM_UDF" so that I can get the detail of custom fields created for "AR_Customer", in the context of a company, say "ABC".

I am using sage 100 ERP 2013(v 5.00).

There is a third party application for which I am developing new feature. I want the users of that application to create/update records in Sage 100 ERP. I will be using BOI to post data to Sage 100. Now, the users of Sage 100 ERP do create custom fields a lot of time and there is also an option to make these custom fields mandatory. Hence, I want to fetch the details of all custom fields created for a particular entity, say "customer"(AR_Customer) and generate controls on the fly in my form based on the details fetched from Sage 100. 

The detail about the custom fields exists in table "CM_UDF". But this file seems to shared by various companies created in Sage 100 ERP. To sum it up, I am trying to find out a way to use BOI to query this file "CM_UDF" so that I can get the detail of custom fields created for "AR_Customer", in the context of a company, say "ABC".

Your answer is Elliot.

Thanks for your help BigLouie!

Look for jepritch  on here. That's Elliot with Sage who gives the BOI sessions at the Sage Summit. He should be able to help on this.

Hi Sneha Pathak ,

Let me see if I understand what you need.  Are you looking for the UI component properties?  So you can recreate the same type of control?  Or are you looking for the properties of the database element, such as Type, Length, any dictionary validations?

Elliott

Hi Elliott,

Sorry for a very late reply. I was looking for properties for both UI components(so as to build the controls) as well as database properties to perform validations. I made an arrangement to read these properties from the table "CM_UDF" through the linked server rather than BOI. If there is any better way then please do let me know.

Thanks,

Sneha