Project Custom Fields

[Augie]

I created some custom fields in the global template that is required
for each project. I would like to include these custom codes on some
external manager reports but cannot locate them in the database. Does
any one know where MS PROJECT stores the information on PRoject custom
codes. The field most interested in is "Enterprise PRoject Cost1". I
created this custom field by selecting Custom code tab => Project =>
Cost.

 

[RT Kaushik]

U should be able to get the data from this link. Very extensive data...

http://www.mvps.org/project/projdb.htm

 

[DJ]

First, you'l need to look up the name of the desired
field, in this case, "Enterprise PRoject Cost1" in the
MSP_CONVERSION table. Take the value from the CONV_VALUE
column and cross reference the value against the
appropriate table (MSP_TEXT_FIELDS I believe). Some SQL
knowledge would be helpful to put together the correct
SELECT statement.