qbfdecn.sys-acchist

User access history

Table details

Area	SysData
Dumpname	sec-acch
Label	User access history
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
70	acc-limit	X	Access Limit	integer	>>>,>>>,>>9	0
60	acc-lvl	X	Access Level	character	X
50	act-cde	X	Activity Code	character	x(8)
10	action-date	X	Action Date	date	99/99/9999	?
40	action-taken	X	Action Taken	character	X
20	action-time	X	Action Time	integer	>>,>>9	0
30	action-user	X	Action User	character	x(12)
47	func-no	X	Function No	integer	>>9	0
80	inter-branch-ind	X	Inter Branch	logical	Yes/No	No
45	user-id	X	User ID	character	x(12)

Indexes

Index name	Flags	Fields	Datatype
user-id	P	user-id (+)	character
date-time		action-date (+)	date
		action-time (+)	integer

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
sys-user-log sys-useract

Child tables

acr-web-user cbk-atmclerk cbk-bankclerk cbk-clerk cbk-pcclerk cbk-tiptrn cbk-venduser glr-expauth glr-reconacct ins-admin ins-claim-desc ins-claims ins-commission ins-company ins-crop-area ins-crop-link ins-crop-type ins-doc-hdr ins-policy inv-negrel inv-plnrel lsc-feedback prn-spoolfile prn-user prs-acting prs-clerk prs-displ-acc prs-displ-mng prs-employee prs-repopt prt-prtfile pur-buyer pur-buyerrel pur-cal-appaud pur-cal-appoint pur-cal-vendor pur-schedhdr sal-clerk sal-empclerk scl-log sys-actlog sys-actmsg sys-actroute sys-brnacc sys-jobschedule sys-lastkey sys-scratch sys-user sys-user-lock sys-user-menu sys-useract sys-usercomp sys-userconn sys-userfunc sys-usergrp-mem sys-userhist

generated 24-6-2026 08:28