invantive documentation
Invantive Support ForumsLog In / Sign Up

EFS_LINE: AccountView Taxonomy elements

read only per partition

  • Catalog: AccountView
  • Label: Taxonomy elements

Can only retrieve data.

Table Columns

The columns of the table EFS_LINE 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
ACCT_NR varchar2(10) Account number
AMT_Y0 int64 Current year
AMT_Y1 int64 Prior year
CALC_DATA varchar2(4) Element data
CALC_EXPN varchar2(4) Formula
CALC_TYPE int32 Element type
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
COPY_ID varchar2(35) Copy element
CR_AMT int64 Credit amount excluding opening balance
DATA_TYPE int32 Data element type
DCT_SQL varchar2(10) SQL Dictionary Query
DR_AMT int64 Debit amount excluding opening balance
EFS_CODE varchar2(10) Taxonomy code
INCL_WHEN int32 Count as
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
ITEM_TYPE int32 Node type
LEAD_CODE varchar2(25) Taxonomy element
LEAD_DESC varchar2(80) Taxonomy element description
NFD_ID varchar2(10) Non-financial data
NM_PREF varchar2(15) Namespace prefix
NM_SPACE varchar2(240) Namespace
NORM_STAT int32 Normal balance
OPEN_AMT int64 Opening balance current year
OPEN_AMTY1 int64 Opening balance prior year
PARENT_ID varchar2(35) Parent taxonomy element
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PREV_CODE varchar2(240) Versioned XML code
PREV_NMSP varchar2(240) Versioned XML namespace
REC_CUST char Customised
REC_DEACT char Do not export
REC_ID varchar2(10) Unique code
SALD_EXPL char XBRL specification
SORT_ORDER int32 Sort order
SPEC_TYPE int32 Account totals
SPLIT_ID varchar2(35) Taxonomy element to be split
TXT_DATA varchar2(4) Text data
USR_RPT varchar2(10) User report
WEIGHT decimal Taxonomy element weight
XBRL_ABST char XBRL presentation element
XBRL_CONT varchar2(10) XBRL context
XBRL_DEC decimal XBRL decimals
XBRL_DTTP varchar2(30) XBRL data type
XBRL_EXT char From external source
XBRL_INFO varchar2(4) XBRL information
XBRL_MAND char XBRL field required
XBRL_MAP varchar2(4) Mapping notes
XBRL_TUPL char XBRL tuple
XBRL_UNIT varchar2(10) XBRL unit
XML_CODE varchar2(240) XML code
XML_DATA varchar2(4) XML data
XML_NMSP varchar2(240) XML namespace