SEC_USR: AccountView Users
read only
- Catalog:
AccountView - Label: Users
Can only retrieve data.
Table Columns
The columns of the table SEC_USR are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AI_API |
varchar2 |
API key (user) AutoInvoice | |||
ALL_ |
char |
Show all administrations | |||
AUTH_ |
varchar2 |
Approval profile | |||
BOS_ |
char |
Backoffice Server impersonation | |||
CANNOT_ |
char |
User cannot change password | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
D_ |
varchar2 |
Network user name | |||
EM2_ |
char |
Changing system hours pages allowed | |||
EMAIL |
varchar2 |
Email address | |||
FST_ |
varchar2 |
First Name | |||
FVW_ |
char |
Suppress AccountView views | |||
IGN_ |
char |
Posting in blocked periods allowed | |||
IMP_ |
char |
Temporary login allowed | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LAST_ |
varchar2 |
Last used password | |||
LST_ |
varchar2 |
Last Name | |||
MUST_ |
char |
User must change password on login | |||
NO_EXP |
char |
Password does not expire | |||
ODP_ID |
int32 |
Visma ID user | |||
PW_ |
varchar2 |
Password hash | |||
PWD_ |
datetime |
Date of last password change | |||
REC_ |
char |
Blocked | |||
RJT_ |
char |
Do not allow BOS impersonation of this user | |||
SOA_ |
char |
Suppress sales advice notifications | |||
USR_ID |
varchar2 |
User name | |||
USR_ |
varchar2 |
Full user name | |||
WF_ |
int32 |
IFA role |