invantive documentation
Invantive Support ForumsLog In / Sign Up

USR_RPT: AccountView User reports

read only per partition

  • Catalog: AccountView
  • Label: User reports

Can only retrieve data.

Table Columns

The columns of the table USR_RPT 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
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
partition_name varchar2 Partition name
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