EFS_LINE: AccountView Taxonomy elements
read only per partition
- Catalogus:
AccountView - Label: Taxonomy elements
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel EFS_LINE worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Rekeningnummer | |||
AMT_Y0 |
int64 |
Current year | |||
AMT_Y1 |
int64 |
Prior year | |||
CALC_ |
varchar2 |
Element data | |||
CALC_ |
varchar2 |
Formula | |||
CALC_ |
int32 |
Element type | |||
CNG_ |
datetime |
Datum van wijziging | |||
CNG_NR |
int32 |
Nummer wijzigen | |||
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 |
Taxonomiecode | |||
INCL_ |
int32 |
Count as | |||
INP_ |
datetime |
Datum van inschrijving | |||
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 |
Niet exporteren | |||
REC_ID |
varchar2 |
Unieke code | |||
SALD_ |
char |
XBRL specification | |||
SORT_ |
int32 |
Sorteer volgorde | |||
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 |