vtiger

[joebordes]

Hi,

I would like to know exactly what these fields are used for:

vtiger_field.generatedtype
vtiger_field.displaytype
vtiger_field.typeofdata
vtiger_field.infotype (BASIC/ADVANCED)

thank you, Joe
TSolucio

[ahmed]

Dear Joe,

Thanks for your interest in vtigerCRM.

Regarding your query about the fields, here is the answer to each of them:


1. vtiger_field.generatedtype - It specifies the type of field in the module, whether 'Existing CRM Field' or 'User Defined Custom Field'

It takes two values :
generatedtype = 1 (Existing Field)
generatedtype = 2 (Custom Field)

2. vtiger_field.displaytype - This column specifies the fields to be displayed in Create/Edit & Detail View of each module.

if displaytype = 1 for a particular field, this will be displayed in all views.
if displaytype = 2 then it will be displayed only in detail view of modules.

3. vtiger_field.typeofdata - As the name suggests, it gives the datatype of particular columnname.

For example - AccountName is a mandatory field in Accounts module of type varchar, hence typeofdata = 'V~M' where V stands for 'varchar' and M stands for Mandatory.

Similarly if typeofdata is 'I-O' it means it is of Integer type and its an Optional Field.

4. vtiger_field.infotype - In some of the modules' Create View like 'Leads/Accounts/Contacts/Products' we have segregated data into 'Basic' & 'More' Information Tabs.

If info_type = 'BAS' the fieldnames are displayed in Basic Information and
info_type = 'ADV' the fieldnames are displayed in More Information


Hope this helps you ...

Do revert for further clarifications..

[joebordes]

Thank you very much, I'm sure the information will be helpful.

Regards, Joe
TSolucio