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