---
title: "XBRL_VL (AccountView)"
description: "XBRL values"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..XBRL_VL
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..XBRL_VL
updated: 2026-11-16T21:15:32Z
license: https://documentation.invantive.eu/en/
---

# XBRL_VL: AccountView XBRL values

`read only` `per partition`

- Catalog: `AccountView`
- Label: XBRL values

Can only retrieve data.

## Table Columns

The columns of the table `XBRL_VL` 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_LIST` | `varchar2(4)` | General Ledger Accounts | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date modified | [ ] |  |  |
| `CNG_NR` | `int32` | Change number | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `CY_BOOL` | `char` | Yes/No current year | [ ] |  |  |
| `CY_CUR` | `int64` | Amount current year | [ ] |  |  |
| `CY_DATE` | `datetime` | Date current year | [ ] |  |  |
| `CY_MEMO` | `varchar2(4)` | Text current year | [ ] |  |  |
| `CY_NR` | `decimal` | Quantity current year | [ ] |  |  |
| `CY_UPD` | `char` | Current year entered | [ ] |  |  |
| `FIELD_TYPE` | `varchar2(10)` | Field type | [ ] |  |  |
| `FLD_MAND` | `char` | Mandatory | [ ] |  |  |
| `FROM_STGY` | `char` | With fill method | [ ] |  |  |
| `INP_DATE` | `datetime` | Entry date | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `IS_ENUM` | `char` | Mandatory value from list (Yes/No) | [ ] |  |  |
| `LINK_ACCT` | `char` | Linked acc. | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PER_FROM` | `int32` | From period | [ ] |  |  |
| `PKEY_FLD` | `char` | Key field | [ ] |  |  |
| `PY_BOOL` | `char` | Yes/No previous year | [ ] |  |  |
| `PY_CUR` | `int64` | Amount previous year | [ ] |  |  |
| `PY_DATE` | `datetime` | Date previous year | [ ] |  |  |
| `PY_MEMO` | `varchar2(4)` | Text previous year | [ ] |  |  |
| `PY_NR` | `decimal` | Quantity previous year | [ ] |  |  |
| `PY_UPD` | `char` | Previous year entered | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Primary Key | [ ] |  |  |
| `REC_ORD` | `int32` | Line sequence | [ ] |  |  |
| `TEXT_ID` | `varchar2(10)` | XBRL default text | [ ] |  |  |
| `TEXT_RECOM` | `char` | Recommended text | [ ] |  |  |
| `TUPLE` | `varchar2(10)` | XBRL specification | [ ] |  |  |
| `XBRL_CODE` | `varchar2(240)` | XBRL code | [ ] |  |  |
| `XBRL_DESC` | `varchar2(240)` | Element description | [ ] |  |  |
| `XBRL_NMSP` | `varchar2(240)` | Namespace | [ ] |  |  |
| `XML_DATA` | `varchar2(4)` | XML data | [ ] |  |  |

