invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

USR_RPT: AccountView User reports

read only per partition

  • Catálogo: AccountView
  • Label: User reports

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla USR_RPT. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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