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_ |
varchar2 |
Account number | |||
AMT_Y0 |
int64 |
Current year | |||
AMT_Y1 |
int64 |
Prior year | |||
CALC_ |
varchar2 |
Element data | |||
CALC_ |
varchar2 |
Formula | |||
CALC_ |
int32 |
Element type | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
COPY_ |
varchar2 |
Copy element | |||
CR_AMT |
int64 |
Credit amount excluding opening balance | |||
DATA_ |
int32 |
Data element type | |||
DCT_ |
varchar2 |
SQL Dictionary Query | |||
DR_AMT |
int64 |
Debit amount excluding opening balance | |||
EFS_ |
varchar2 |
Taxonomy code | |||
INCL_ |
int32 |
Count as | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
ITEM_ |
int32 |
Node type | |||
LEAD_ |
varchar2 |
Taxonomy element | |||
LEAD_ |
varchar2 |
Taxonomy element description | |||
NFD_ID |
varchar2 |
Non-financial data | |||
NM_ |
varchar2 |
Namespace prefix | |||
NM_ |
varchar2 |
Namespace | |||
NORM_ |
int32 |
Normal balance | |||
OPEN_ |
int64 |
Opening balance current year | |||
OPEN_ |
int64 |
Opening balance prior year | |||
PARENT_ |
varchar2 |
Parent taxonomy element | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PREV_ |
varchar2 |
Versioned XML code | |||
PREV_ |
varchar2 |
Versioned XML namespace | |||
REC_ |
char |
Customised | |||
REC_ |
char |
Do not export | |||
REC_ID |
varchar2 |
Unique code | |||
SALD_ |
char |
XBRL specification | |||
SORT_ |
int32 |
Sort order | |||
SPEC_ |
int32 |
Account totals | |||
SPLIT_ |
varchar2 |
Taxonomy element to be split | |||
TXT_ |
varchar2 |
Text data | |||
USR_ |
varchar2 |
User report | |||
WEIGHT |
decimal |
Taxonomy element weight | |||
XBRL_ |
char |
XBRL presentation element | |||
XBRL_ |
varchar2 |
XBRL context | |||
XBRL_ |
decimal |
XBRL decimals | |||
XBRL_ |
varchar2 |
XBRL data type | |||
XBRL_ |
char |
From external source | |||
XBRL_ |
varchar2 |
XBRL information | |||
XBRL_ |
char |
XBRL field required | |||
XBRL_ |
varchar2 |
Mapping notes | |||
XBRL_ |
char |
XBRL tuple | |||
XBRL_ |
varchar2 |
XBRL unit | |||
XML_ |
varchar2 |
XML code | |||
XML_ |
varchar2 |
XML data | |||
XML_ |
varchar2 |
XML namespace |