How can i save login data (user id or user name) into SQL table of NAV.

flesenne

Hello,
Which data are used to store login data. I want to use these data to save login information into article ledger.
As my customer used SQL server and Nav5.0, is it a good idea to write trigger and stored procedure ?
Thanks for your help

4388331

Hi,
Actually, user logins are stores in following tables:

Database logins in the table 2000000002 "User".
Windows logins in the table 2000000054 "Windows Login".

But I don't understood, in what "article ledger" you want to save them?

JohnHunter

Take a look: Codeunit 1 ApplicationManagement, procedure LogInEnd

UserTimeRegister."User ID" := USERID;

flesenne

Thanks for your reponses.
I give you more informations about my need because i would like only modify table (no codeunit modif. as you suggest).
I want to add User ID in the Capacity Ledger Entry table. To do that i try to get User ID from Item Register table where Capacity Ledger Entry.Entry No >= Item Register.From Capacity Entry No. and Capacity Ledger Entry.Entry No <= Item Register.To Capacity Entry No.

To do that i added User ID into Capacity Ledger Entry table with Data type = Code and Calc formula using lookup but the following formula is not working.

lookup("Item Register"."User ID" WHERE (From Capacity Entry No.<=FIELD(Entry No) AND (To Capacity Entry No.>=FIELD(Entry No))

Could you give me some informations to help me ?

Thanks