I need to make a SQL-query with BaaN-tables. When I use table tfgld410 I see the columns t_tror and t_fitr. These columns don't have text of our company, but of BaaN itself.
In a query I only see a number, in a BaaN-screen I see also the name. Is there an other table where I can find the list for combination number and name?

these are enums. have a look at ttadv401 and ttadv402 of company 000

In table adv402 I can find what I was looking for.

Thanks.