I link to BaaN tables a lot with MS Access using an ODBC connection to SQL.
Is there a session in BaaN which gives the meaning for the fields?
I have noticed that an audit report for customers shows all the field comments when a new customer is entered and wondered where I can get that info for other tables.

Thanks

ttadv140.desc

Field description can be found in the session "Labels" (ttadv1140m000). It is the description as entered in field ttadv140.desc.

There are two possibilities for an used label code. That is determined in the table definition. In session "Table Fields" (ttadv4522m000) it is possible to enter a Label Description, or a Related Label/Description.

If the label description is used, the label code is equal to the table field code. Example: the label of whinh220.prio = whwhinh220.prio (Order Priority).
If a Related Label is used (field ttadv422.clab is filled), then the description of another label is used. Example: the related label of whinh220.pono = whtcgen.pono (Position Number).

Kees

Hi,
You can download help file for free with description of all fields in all tables on:
http://tatla.net/scout/

Edin