invantive documentation
Invantive Support ForumsLog In / Sign Up

EFS_RPTL: AccountView Reporting segment lines

read only per partition

  • Catalog: AccountView
  • Label: Reporting segment lines

Can only retrieve data.

Table Columns

The columns of the table EFS_RPTL 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
AMT_FMT int32 Amount display
AMT_SHOW int32 Debit/credit display
CRS_DESC varchar2(80) Description
CRS_KEY varchar2(35) Line code
DBF_NAME varchar2(8) Source table
DESC_HIDE char Suppress description
DSP_COL decimal Print column
FNT_ALGN_C int32 Text alignment
FNT_ALGN_Y int32 Amount alignment
FNT_BOLD_C char Bold text
FNT_BOLD_Y char Bold amounts
FNT_ITAL_C char Italic text
FNT_ITAL_Y char Italic amounts
FNT_NAME varchar2(50) Font
FNT_SIZE int32 Font size
FNT_UNDR_C char Underlined text
FNT_UNDR_D char Double underline
FNT_UNDR_Y char Summation line
GRP_ID varchar2(10) Group
HDR_ID varchar2(10) Unique code of header record
LIC_HASH varchar2(16) Licence check
partition_code varchar2 Partition code
partition_name varchar2 Partition name
REC_ID varchar2(10) Unique code
REC_ORD int32 Sequence
ROW_KEEP char Keep with next line