Address Book field MLNM mailing name what table ?

[david_mallory]

I am looking for the table wherein resides the field/column MLNM mailing
name. So far I have not found it in the F01* Address Book tables. Our Cross
Ref is not working. Does anyone know the table number? Needed for 1099
reporting.

Dave Mallory Denver Water Denver Colorado USA
[email protected]

 

[Christian Audet]

Dave,

This field is stored in F0111 Who's Who Table and the key to get it is the address number and the IDLN field is also part of the key, you normaly use IDLN = 0 for the default one.

Christian Audet

*** SHARED KNOWLEDGE = BETTER KNOWLEDGE ***

Implementing B7333 (Xe) SP16.1, SQL
(Support B732, B7331 and B7332)

 

[Zoltan_Gyimesi]

Hi Dave,

I suppose, you have already got the right abswer from Christian, so I just would like to suggest a general method for similar situations.

Open the F98711 "Table Columns" table with UTB.
Enter the alias into the TBOBND QBE field and hit find.
You will gt the tables which contain this Data Item.
In your case I have got 28 hits for MLNM on XE (by the way you missed to attach your system configurations to your post) but only F0101A and F0111 was really suspicious, so investigating this two tables yo can also find the right one (F0111, as Christian have told already).

Hope, it can be a bit help in the future.

Merry Christmas and Happy New Year!

"Kellemes Karácsonyi Ünnepeket és Boldog Újévet!"

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)