---
title: "USR_RPT (AccountView)"
description: "User reports"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/vismaaccountview/AccountView..USR_RPT
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..USR_RPT
updated: 2026-11-16T21:15:22Z
license: https://documentation.invantive.eu/fr/
---

# USR_RPT: AccountView User reports

`read only` `per partition`

- Catalogue : `AccountView`
- Label: User reports

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

## Colonnes de table

Les colonnes de la table `USR_RPT` 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 |
|---|---|---|:---:|---|---|
| `BUS_FILT` | `char` | Use Business selection | [ ] |  |  |
| `BUS_SORT` | `char` | Use Business sorting | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date de modification | [ ] |  |  |
| `CNG_NR` | `int32` | Modifier le numéro | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `COMMENT` | `varchar2(4)` | Note | [ ] |  |  |
| `DYN_QRY` | `char` | Interactive report (?) | [ ] |  |  |
| `EXPFIL_CNG` | `char` | Fixed export file name | [ ] |  |  |
| `EXPORT_FIL` | `varchar2(80)` | Export file name | [ ] |  |  |
| `EXPORT_RPT` | `char` | Export report only | [ ] |  |  |
| `EXPORT_TYP` | `varchar2(254)` | File type | [ ] |  |  |
| `FLD_VERT` | `varchar2(4)` | SQL Fields | [ ] |  |  |
| `INP_DATE` | `datetime` | Date d'inscription | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `MENU_TYPE` | `decimal` | Menu type | [ ] |  |  |
| `OBJ_CODE` | `varchar2(4)` | Code objet | [ ] |  |  |
| `OBJ_NAME` | `varchar2(40)` | Object name | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `QRY_CNG` | `char` | Query definition changed | [ ] |  |  |
| `QRY_CODE` | `varchar2(10)` | Query Code | [ ] |  |  |
| `QRY_FILES` | `varchar2(4)` | SQL Tables | [ ] |  |  |
| `QRY_FROM` | `varchar2(4)` | SQL From | [ ] |  |  |
| `QRY_GROUP` | `varchar2(4)` | SQL Group By | [ ] |  |  |
| `QRY_JOIN1` | `varchar2(4)` | SQL Join | [ ] |  |  |
| `QRY_ORDER` | `varchar2(4)` | SQL Order By | [ ] |  |  |
| `QRY_RPT` | `varchar2(50)` | Layout file | [ ] |  |  |
| `QRY_WHER1` | `varchar2(4)` | SQL Where | [ ] |  |  |
| `REC_BLK` | `char` | Hide | [ ] |  |  |
| `RPT_CNG` | `char` | Report definition changed | [ ] |  |  |
| `RPT_DESC` | `varchar2(60)` | Query description | [ ] |  |  |
| `SEL_DESC` | `char` | Show descriptions instead of numbers | [ ] |  |  |
| `SEL_DIST` | `char` | Unique selection | [ ] |  |  |
| `SEL_TOP` | `int32` | Top selection value | [ ] |  |  |
| `SUMM_TYPE` | `int32` | Report view | [ ] |  |  |
| `TOP_PCT` | `char` | Top selection | [ ] |  |  |
| `TXT_ID` | `varchar2(10)` | Text identification | [ ] |  |  |
| `VCNG_DATE` | `varchar2(10)` | Date de la dernière modification | [ ] |  |  |
| `WIZ_DATA` | `varchar2(4)` | User report data | [ ] |  |  |
