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

# SEC_USR: AccountView Users

`read only`

- Catalogue : `AccountView`
- Label: Users

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `SEC_USR` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AI_API` | `varchar2(36)` | API key (user) AutoInvoice | [ ] |  |  |
| `ALL_ADM` | `char` | Show all administrations | [ ] |  |  |
| `AUTH_CODE` | `varchar2(10)` | Profil d'autorisation | [ ] |  |  |
| `BOS_IMP` | `char` | Backoffice Server impersonation | [ ] |  |  |
| `CANNOT_CNG` | `char` | User cannot change password | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date de modification | [ ] |  |  |
| `CNG_NR` | `int32` | Modifier le numéro | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `D_USR_NAME` | `varchar2(30)` | Nom d'utilisateur réseau | [ ] |  |  |
| `EM2_SYS` | `char` | Changing system hours pages allowed | [ ] |  |  |
| `EMAIL` | `varchar2(50)` | Adresse e-mail | [ ] |  |  |
| `FST_NAME` | `varchar2(20)` | Prénom | [ ] |  |  |
| `FVW_NOSTD` | `char` | Suppress AccountView views | [ ] |  |  |
| `IGN_CPER` | `char` | Posting in blocked periods allowed | [ ] |  |  |
| `IMP_AVAIL` | `char` | Temporary login allowed | [ ] |  |  |
| `INP_DATE` | `datetime` | Date d'inscription | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `LAST_PWD` | `varchar2(4)` | Last used password | [ ] |  |  |
| `LST_NAME` | `varchar2(40)` | Nom | [ ] |  |  |
| `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)` | Code d'ouverture de session | [ ] |  |  |
| `USR_NAME` | `varchar2(70)` | Full user name | [ ] |  |  |
| `WF_ACCESS` | `int32` | IFA role | [ ] |  |  |
