---
title: "SEC_USR (AccountView)"
description: "Users"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..SEC_USR
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..SEC_USR
updated: 2026-11-16T21:14:55Z
license: https://documentation.invantive.eu/en/
---

# 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(36)` | API key (user) AutoInvoice | [ ] |  |  |
| `ALL_ADM` | `char` | Show all administrations | [ ] |  |  |
| `AUTH_CODE` | `varchar2(10)` | Approval profile | [ ] |  |  |
| `BOS_IMP` | `char` | Backoffice Server impersonation | [ ] |  |  |
| `CANNOT_CNG` | `char` | User cannot change password | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date modified | [ ] |  |  |
| `CNG_NR` | `int32` | Change number | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `D_USR_NAME` | `varchar2(30)` | Network user name | [ ] |  |  |
| `EM2_SYS` | `char` | Changing system hours pages allowed | [ ] |  |  |
| `EMAIL` | `varchar2(50)` | Email address | [ ] |  |  |
| `FST_NAME` | `varchar2(20)` | First Name | [ ] |  |  |
| `FVW_NOSTD` | `char` | Suppress AccountView views | [ ] |  |  |
| `IGN_CPER` | `char` | Posting in blocked periods allowed | [ ] |  |  |
| `IMP_AVAIL` | `char` | Temporary login allowed | [ ] |  |  |
| `INP_DATE` | `datetime` | Entry date | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `LAST_PWD` | `varchar2(4)` | Last used password | [ ] |  |  |
| `LST_NAME` | `varchar2(40)` | Last Name | [ ] |  |  |
| `MUST_CNG` | `char` | User must change password on login | [ ] |  |  |
| `NO_EXP` | `char` | Password does not expire | [ ] |  |  |
| `ODP_ID` | `int32` | Visma ID user | [ ] |  |  |
| `PW_HASH` | `varchar2(16)` | Password hash | [ ] |  |  |
| `PWD_CNGD` | `datetime` | Date of last password change | [ ] |  |  |
| `REC_BLK` | `char` | Blocked | [ ] |  |  |
| `RJT_BOSIMP` | `char` | Do not allow BOS impersonation of this user | [ ] |  |  |
| `SOA_NOMSG` | `char` | Suppress sales advice notifications | [ ] |  |  |
| `USR_ID` | `varchar2(20)` | User name | [ ] |  |  |
| `USR_NAME` | `varchar2(70)` | Full user name | [ ] |  |  |
| `WF_ACCESS` | `int32` | IFA role | [ ] |  |  |

