# XBRL_VL: XBRL values - Name: `XBRL_VL` - Catalog: `AccountView` - Label: XBRL values - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `XBRL_VL` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_LIST` | `string(4)` | General Ledger Accounts | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `CY_BOOL` | `boolean` | Yes/No current year | ☐ | | | `CY_CUR` | `int64` | Amount current year | ☐ | | | `CY_DATE` | `datetime` | Date current year | ☐ | | | `CY_MEMO` | `string(4)` | Text current year | ☐ | | | `CY_NR` | `decimal` | Quantity current year | ☐ | | | `CY_UPD` | `boolean` | Current year entered | ☐ | | | `FIELD_TYPE` | `string(10)` | Field type | ☐ | | | `FLD_MAND` | `boolean` | Mandatory | ☐ | | | `FROM_STGY` | `boolean` | With fill method | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `IS_ENUM` | `boolean` | Mandatory value from list (Yes/No) | ☐ | | | `LINK_ACCT` | `boolean` | Linked acc. | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PER_FROM` | `int32` | From period | ☐ | | | `PKEY_FLD` | `boolean` | Key field | ☐ | | | `PY_BOOL` | `boolean` | Yes/No previous year | ☐ | | | `PY_CUR` | `int64` | Amount previous year | ☐ | | | `PY_DATE` | `datetime` | Date previous year | ☐ | | | `PY_MEMO` | `string(4)` | Text previous year | ☐ | | | `PY_NR` | `decimal` | Quantity previous year | ☐ | | | `PY_UPD` | `boolean` | Previous year entered | ☐ | | | `REC_ID` | `string(10)` | Primary Key | ☐ | | | `REC_ORD` | `int32` | Line sequence | ☐ | | | `TEXT_ID` | `string(10)` | XBRL default text | ☐ | | | `TEXT_RECOM` | `boolean` | Recommended text | ☐ | | | `TUPLE` | `string(10)` | XBRL specification | ☐ | | | `XBRL_CODE` | `string(240)` | XBRL code | ☐ | | | `XBRL_DESC` | `string(240)` | Element description | ☐ | | | `XBRL_NMSP` | `string(240)` | Namespace | ☐ | | | `XML_DATA` | `string(4)` | XML data | ☐ | |