About This Guide > usr_mstr
  
usr_mstr
User Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_usr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
usr__qad01
 
 
x(8)
 
 
usr__qad02
 
 
x(8)
 
 
usr__qadc01
QAD Character Field
 
X(8)
 
 
usr__qadc02
QAD Character Field
 
X(8)
 
 
usr__qadc03
QAD Character Field
 
x(8)
 
 
usr__qadc04
QAD Character Field
 
X(8)
 
 
usr__qadc05
 
 
x(24)
 
 
usr__qadi01
QAD Integer Field
 
>>>9
 
 
usr__qadi02
QAD Integer Field
 
>>9
 
 
usr__qadl01
QAD Logical Field
 
yes/no
 
 
usr__qadl02
QAD Logical Field
 
yes/no
 
 
usr__qadl03
 
 
yes/no
 
 
usr_access_loc
Access Location
 
x(8)
 
 
usr_access_type
Access Type
 
x(8)
 
 
usr_active
Active
Active
yes/no
 
 
usr_active_by
Active By
Active Changed By!User ID
x(8)
 
 
usr_active_date
Active Date
Active!Chg Date
99/99/99
 
 
usr_active_dir_enabled
Active Directory Enabled
 
yes/no
 
 
usr_active_dir_userid
Active Directory Userid
 
x(64)
 
 
usr_active_reason
Active Reason
Reason!Code
x(8)
 
 
usr_addr
Address
 
x(8)
 
 
usr_ctry_code
Country Code
Ctry
x(3)
 
 
usr_enabled
User Enabled
 
yes/no
 
 
usr_failed_attempts
Password Failed Attempts
Passwd Failed!Attempts
>>9
 
 
usr_force_change
Password Force Change
Passwd!Force!Change
yes/no
 
 
usr_initials
Initials
Init
x(20)
 
 
usr_lang
Language
Lang
x(2)
 
 
usr_last_date
Date Password Last Changed
Changed
99/99/99
 
 
usr_last_time
 
 
>>>>9
 
 
usr_ldap_dn
Ldap Username
 
x(256)
 
 
usr_ldap_instance
LDAP Instance Name
 
x(36)
 
 
usr_logon_date
Last Logon Date
Logon Date
99/99/99
 
 
usr_logon_time
Last Logon Time
Logon Time
>>>>9
 
 
usr_logon_timezone
Last Logon Time Zone
Server!Time!Zone
x(8)
 
 
usr_mail_address
E-mail Address
E-mail
x(60)
 
 
usr_mail_address_login
E-mail address login
 
yes/no
 
 
usr_name
User Name
 
x(35)
 
 
usr_passwd
Password
 
x(78)
 
 
usr_remark
Remark
 
x(60)
 
 
usr_restrict
Restricted
 
yes/no
 
 
usr_site
Site
 
x(8)
 
 
usr_timezone
Time Zone
 
x(8)
 
 
usr_type
User Type
 
x(8)
 
 
usr_tzdb
Time Zone DB
 
x(16)
 
 
usr_user1
Ufld1
 
x(8)
 
 
usr_user2
Ufld2
 
x(8)
 
 
usr_userid
User ID
 
x(8)
 
 
usr_variant_code
Variant
 
x(6)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_usr_mstr
yes
oid_usr_mstr
yes
no
 
usr_ad_userid
no
usr_active_dir_userid
yes
no
 
usr_mail_address
no
usr_mail_address
yes
no
usr_userid
yes
usr_userid
yes
no