User Access Log - SAP B1 SDK Help

Table Name: USR5

Table Description: User Access Log

Field	Description	Type	Size	Related	Default Value	Constraints
UserCode	User Code	nVarChar	25	OUSR
Action	Performed Action	VarChar	1	-		I	Logon Succeeded
						F	Logon Failed
						O	Logoff
						C	Created
						S	Superuser Selected
						D	Superuser Deselected
						L	Locked
						U	Unlocked
						P	Password Changed
						N	Screen Unlock Failed
						T	Temporary User Change
						R	Removed
ActionBy	User Who Performed the Action	nVarChar	25	-
ClientIP	IP Address of Client Computer	nVarChar	200	-
Date	Date	Date	8	-
Time	Time	Int	11	-	0
ClientName	Hostname of Client Computer	nVarChar	200	-
ProcessID	Process ID of B1 Application	Int	11	-	-1
SessionID	Connection Session ID	Int	11	-	-1
ReasonID	Reason ID	Int	11	-		1	Planned: Initial System Configuration
						2	Planned: System Configuration Change
						3	Planned: System Maintenance
						4	Planned: Knowledge Transfer to End-User
						11	Unplanned: Root Cause Analysis
						12	Unplanned: Knowledge Transfer to End-User
						13	Unplanned: System Maintenance
						14	Unplanned: System Configuration Change
						51	System Maintenance
						52	Root Cause Analysis
						53	Consulting / Support
						54	Other
ReasonDesc	Reason Description	nVarChar	250	-
WinSessnID	Client Windows Session ID	Int	11	-	-1
WinUsrName	User Name of Windows User	nVarChar	100	-
ProcName	Process Name of Logged-On App.	nVarChar	80	-
AliveDurtn	Time Logged-On User Keep Alive	Int	11	-	0
LogoutTime	User Logout Time	Int	11	-
Source	Login Terminal	nVarChar	100	-
UserID	User ID	Int	6	-