EFS_LINE: AccountView Taxonomy elements
read only per partition
- Catalogue :
AccountView - Label: Taxonomy elements
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table EFS_LINE sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Numéro de compte | |||
AMT_Y0 |
int64 |
Current year | |||
AMT_Y1 |
int64 |
Prior year | |||
CALC_ |
varchar2 |
Element data | |||
CALC_ |
varchar2 |
Formula | |||
CALC_ |
int32 |
Element type | |||
CNG_ |
datetime |
Date de modification | |||
CNG_NR |
int32 |
Modifier le numéro | |||
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 |
Code taxonomique | |||
INCL_ |
int32 |
Count as | |||
INP_ |
datetime |
Date d'inscription | |||
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 |
Ne pas exporter | |||
REC_ID |
varchar2 |
Code unique | |||
SALD_ |
char |
XBRL specification | |||
SORT_ |
int32 |
Ordre de tri | |||
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 |