Sytem Table for LoginID Alpha Name

AndrewCrouse

Member
Does anyone know which JDE system tables stores the JDE Login Name that you can cross reference to the actual alpha name or address book number.

There is a Business Function that does this (GetUserIDAlphaName - B98220D), However I don't know what system table its using to return the Alpha name.

Pass in USER -> Returns AN8 and ALPH.


Thanks
 
Nevermind, I figured it out.

The F0092 Table contains the ULUSER (Login ID) and ULAN8 (Address Book Number) fields. The AN8 field can then be used to lookup the Alpha Name in F0101.
 
Back
Top