invantive documentation
Invantive Support ForumsLog In / Sign Up

EFS_RPTD: AccountView Reporting segments

read only per partition

  • Catalog: AccountView
  • Label: Reporting segments

Can only retrieve data.

Table Columns

The columns of the table EFS_RPTD 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
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 modified
CNG_NR int32 Change number
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 Entry date
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