Enterprise Resource Outline Code3 SQL question

[Colin]

I've got a custom outline code, OBS, added as an enterprise field. I've
edited the lookup table to add the appropriate data, but now I'd like to
know how to extract it from the DB by using T-SQL. I'm trying to create a
reporting services report, but I don't know where the lookup table data is
stored?

Colin

 

[Guidho]

Outline code information is stored in two tables:
- MSP_OUTLINE_CODES: this table stores the outline code definition
- MSP_CODE_FIELDS: this table stores which value is filled in for your
project.

So you need to join MSP_PROJECTS with MSP_CODE_FIELDS and with
MSP_OUTLINE_CODES.

Hope this helps,
Guidho