---
title: "USR_RPT (AccountView)"
description: "User reports"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/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/de/
---

# USR_RPT: AccountView User reports

`read only` `per partition`

- Katalog: `AccountView`
- Label: User reports

Es können nur Daten abgerufen werden.

## Tabellenspalten

Die Spalten der Tabelle `USR_RPT` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `BUS_FILT` | `char` | Use Business selection | [ ] |  |  |
| `BUS_SORT` | `char` | Use Business sorting | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date modified | [ ] |  |  |
| `CNG_NR` | `int32` | Change number | [ ] |  |  |
| `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` | Entry date | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `MENU_TYPE` | `decimal` | Menu type | [ ] |  |  |
| `OBJ_CODE` | `varchar2(4)` | Object Code | [ ] |  |  |
| `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 last modified | [ ] |  |  |
| `WIZ_DATA` | `varchar2(4)` | User report data | [ ] |  |  |
