Where is the data in custom fields stored in SQL ?

[Vivek S]

Hi,
I created a custom filed in enterprise template and team filled in the
data.The filed is inthe Resource Sheet.
I want to extract the data from that field from SQL server but not able to
see that field in MSP_RSOURCES table.

Are custom fields stored somewhere else?? Where?

Thanks,

 

[Ed Morrison]

They are stored in tables such as msp_text_fields, msp_flag_fields, etc.
Use msp_conversion to get the appropriate code.

On the views side, they are stored in MSP_VIEW_PROJ_RES_ENT and
MSP_VIEW_PROJ_RES_STD.