How to know the data types of the fields of the different modules?

The information is stored in the Vardefs

 https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_9.3/Data_Framework/Vardefs/ 

and can be accessed via the Metadata API

3 Tips for using the Sugar Metadata API 

FrancescaS

Im working with 6.5.22 this works for me?

No, the API is for v7.x and higher so it will not work in 6.5

But 6.5.x still has metadata for each of the modules, and that metadata describes your fields, including "name" and "type".

It's been a while since I worked in 6.x but each module should have vardefs in its directory:

modules/<module_name>/vardefs.php

and custom fields will be in:

custom/Extension/modules/<module_name>/Ext/vardefs.php

To get a list of fields for a given module programmatically, this should work in 6.x

        $bean = BeanFactory::getBean($module_name);
        $field_defs[$module_name] = $bean->getFieldDefinitions();

Each of those definitions should include the field "name" and "type".

Let me know if this helps.

Francesca

Yeah now i got the datatypes that i need, thank you a lot.

Yeah now i got the datatypes that i need, thank you a lot.