invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

EFS_RPTD: AccountView Reporting segments

read only per partition

  • Catalogue : AccountView
  • Label: Reporting segments

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

Colonnes de table

Les colonnes de la table EFS_RPTD 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
BOTM_ROWS int32 Number of bottom rows
CLS_NAME varchar2(25) Reporting segment type
CLS_PROP varchar2(4) Reporting segment settings
CNG_DATE datetime Date de modification
CNG_NR int32 Modifier le numéro
CNG_USR varchar2(20) Employee last modified
COL_TYPE int32 Columns
DSP_COL_H int32 Table header print column
DSP_FMT int32 Formatting
EXTR_ROWS int32 Extra number of blank lines
FNT_ALGN_H int32 Table header alignment
FNT_BOLD_H char Table header bold
FNT_ITAL_H char Table header italic
FNT_NAME_H varchar2(40) Table header font
FNT_SIZE_H int32 Table header font size
FNT_UNDR_H char Table header underline
HDR_DESC varchar2(4) Table header descriptions
HDR_LST varchar2(250) Table header columns to print
HDR_STYLE int32 Title style
HDR_TXT varchar2(240) Title
INP_DATE datetime Date d'inscription
INP_USR varchar2(20) Entered by employee
ITEM_DESC varchar2(40) Reporting segment description
LEAD_CODE varchar2(35) Taxonomy element
MACRO_NAME varchar2(100) Macro
MAX_LEVELS int32 Maximum depth
NEW_PAGE int32 Start on new page
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PRINT_WHEN varchar2(4) Print as
REC_BLK char Reporting segment blocked
REC_DEACT char Do not print
REC_ORD int32 Sequence
REC_PRTCT char Do not overwrite on import
ROUND_TO int32 Round to
RPT_ID varchar2(10) Report code
RPTD_ID varchar2(10) Reporting segment code
RTF_STYLE varchar2(25) Title style
RTF_TXT varchar2(4) Text
XBRL_SPEC varchar2(10) XBRL specification