---
title: "FS_LINE (AccountView)"
description: "Report model lines"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/vismaaccountview/AccountView..FS_LINE
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..FS_LINE
updated: 2026-11-16T21:13:46Z
license: https://documentation.invantive.eu/nl/
---

# FS_LINE: AccountView Report model lines

`read only` `per partition`

- Catalogus: `AccountView`
- Label: Report model lines

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `FS_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 |
|---|---|---|:---:|---|---|
| `A_CY` | `int64` | Actual current year | [ ] |  |  |
| `A_CY1` | `int64` | Actual current year (range) | [ ] |  |  |
| `A_CY2` | `int64` | Actual current year (up to period) | [ ] |  |  |
| `A_CY3` | `int64` | Actual current year (year-end) | [ ] |  |  |
| `A_PY` | `int64` | Actual prior year | [ ] |  |  |
| `A_PY1` | `int64` | Actual prior year (range) | [ ] |  |  |
| `A_PY2` | `int64` | Actual prior year (up to period) | [ ] |  |  |
| `A_PY3` | `int64` | Actual prior year (year-end) | [ ] |  |  |
| `AA_DIF` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFA` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFAP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFB` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFBP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFC` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFCP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFD` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFDP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFE` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFEP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFF` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFFP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFG` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFGP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFH` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFHP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFI` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFIP` | `int64` | Actual CY - PY | [ ] |  |  |
| `AA_DIFP` | `int64` | Actual CY - PY (%) | [ ] |  |  |
| `AB_DIF_CY` | `int64` | Actual CY - budget CY | [ ] |  |  |
| `AB_DIF_PY` | `int64` | Actual PY - budget PY | [ ] |  |  |
| `AB_DIFP_CY` | `int64` | Actual CY - budget CY (%) | [ ] |  |  |
| `AB_DIFP_PY` | `int64` | Actual PY - budget PY (%) | [ ] |  |  |
| `B_CY` | `int64` | Budget current year | [ ] |  |  |
| `B_CY1` | `int64` | Budget current year | [ ] |  |  |
| `B_PY` | `int64` | Budget prior year | [ ] |  |  |
| `B_PY1` | `int64` | Budget prior year | [ ] |  |  |
| `BAL_CY` | `decimal` | Balance current year | [ ] |  |  |
| `BAL_PY` | `decimal` | Balance prior year | [ ] |  |  |
| `BB_DIF` | `int64` | Budget CY - PY | [ ] |  |  |
| `BB_DIFP` | `int64` | Budget CY - PY (%) | [ ] |  |  |
| `BUD_CY` | `decimal` | Budget current year | [ ] |  |  |
| `BUD_CY_0` | `decimal` | Budget period 0 current year | [ ] |  |  |
| `BUD_CY_1` | `decimal` | Budget period 1 current year | [ ] |  |  |
| `BUD_CY_10` | `decimal` | Budget period 10 current year | [ ] |  |  |
| `BUD_CY_11` | `decimal` | Budget period 11 current year | [ ] |  |  |
| `BUD_CY_12` | `decimal` | Budget period 12 current year | [ ] |  |  |
| `BUD_CY_13` | `decimal` | Budget period 13 current year | [ ] |  |  |
| `BUD_CY_14` | `decimal` | Budget period 14 current year | [ ] |  |  |
| `BUD_CY_2` | `decimal` | Budget period 2 current year | [ ] |  |  |
| `BUD_CY_3` | `decimal` | Budget period 3 current year | [ ] |  |  |
| `BUD_CY_4` | `decimal` | Budget period 4 current year | [ ] |  |  |
| `BUD_CY_5` | `decimal` | Budget period 5 current year | [ ] |  |  |
| `BUD_CY_6` | `decimal` | Budget period 6 current year | [ ] |  |  |
| `BUD_CY_7` | `decimal` | Budget period 7 current year | [ ] |  |  |
| `BUD_CY_8` | `decimal` | Budget period 8 current year | [ ] |  |  |
| `BUD_CY_9` | `decimal` | Budget period 9 current year | [ ] |  |  |
| `BUD_CY_RNG` | `decimal` | Budget range current year | [ ] |  |  |
| `BUD_CY_YTP` | `decimal` | Up to period budget current year | [ ] |  |  |
| `BUD_PY` | `decimal` | Budget prior year | [ ] |  |  |
| `BUD_PY_0` | `decimal` | Budget period 0 prior year | [ ] |  |  |
| `BUD_PY_1` | `decimal` | Budget period 1 prior year | [ ] |  |  |
| `BUD_PY_10` | `decimal` | Budget period 10 prior year | [ ] |  |  |
| `BUD_PY_11` | `decimal` | Budget period 11 prior year | [ ] |  |  |
| `BUD_PY_12` | `decimal` | Budget period 12 prior year | [ ] |  |  |
| `BUD_PY_13` | `decimal` | Budget period 13 prior year | [ ] |  |  |
| `BUD_PY_14` | `decimal` | Budget period 14 prior year | [ ] |  |  |
| `BUD_PY_2` | `decimal` | Budget period 2 prior year | [ ] |  |  |
| `BUD_PY_3` | `decimal` | Budget period 3 prior year | [ ] |  |  |
| `BUD_PY_4` | `decimal` | Budget period 4 prior year | [ ] |  |  |
| `BUD_PY_5` | `decimal` | Budget period 5 prior year | [ ] |  |  |
| `BUD_PY_6` | `decimal` | Budget period 6 prior year | [ ] |  |  |
| `BUD_PY_7` | `decimal` | Budget period 7 prior year | [ ] |  |  |
| `BUD_PY_8` | `decimal` | Budget period 8 prior year | [ ] |  |  |
| `BUD_PY_9` | `decimal` | Budget period 9 prior year | [ ] |  |  |
| `BUD_PY_RNG` | `decimal` | Budget range prior year | [ ] |  |  |
| `BUD_PY_YTP` | `decimal` | Up to period budget prior year | [ ] |  |  |
| `CALC_1` | `varchar2(100)` | Report formula | [ ] |  |  |
| `DSP_COL` | `decimal` | Print column | [ ] |  |  |
| `DSP_FMT` | `varchar2(1)` | Line formatting | [ ] |  |  |
| `FNT_ALGN_C` | `int32` | Text alignment | [ ] |  |  |
| `FNT_ALGN_Y` | `int32` | Amount alignment | [ ] |  |  |
| `FNT_BOLD_C` | `char` | Bold text | [ ] |  |  |
| `FNT_BOLD_Y` | `char` | Bold amounts | [ ] |  |  |
| `FNT_FORE_C` | `int32` | Text foreground colour | [ ] |  |  |
| `FNT_FORE_Y` | `int32` | Amount foreground colour | [ ] |  |  |
| `FNT_ITAL_C` | `char` | Italic text | [ ] |  |  |
| `FNT_ITAL_Y` | `char` | Italic amounts | [ ] |  |  |
| `FNT_NAME_C` | `varchar2(20)` | Text font | [ ] |  |  |
| `FNT_NAME_Y` | `varchar2(20)` | Amount font | [ ] |  |  |
| `FNT_SIZE_C` | `int32` | Text font size | [ ] |  |  |
| `FNT_SIZE_Y` | `int32` | Amount font size | [ ] |  |  |
| `FNT_UNDR_C` | `char` | Underlined text | [ ] |  |  |
| `FNT_UNDR_Y` | `char` | Underlined amounts | [ ] |  |  |
| `FS_CODE` | `varchar2(3)` | Report code | [ ] |  |  |
| `FSC_LINK` | `varchar2(3)` | Report model link | [ ] |  |  |
| `FSL_BOLD` | `char` | Bold | [ ] |  |  |
| `FSL_DESC` | `varchar2(80)` | Report line description | [ ] |  |  |
| `FSL_FNTNM` | `varchar2(50)` | Font | [ ] |  |  |
| `FSL_FNTSZ` | `int32` | Font size | [ ] |  |  |
| `FSL_ITALIC` | `char` | Italic | [ ] |  |  |
| `FSL_SUP` | `char` | Suppress line | [ ] |  |  |
| `FSL_ULINE` | `char` | Underline | [ ] |  |  |
| `LEAD_CODE` | `varchar2(10)` | Category code | [ ] |  |  |
| `LEAD_LINK` | `varchar2(10)` | Category link | [ ] |  |  |
| `LINK_STAT` | `decimal` | Link status | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PER_CY_0` | `decimal` | Period 0 current financial year | [ ] |  |  |
| `PER_CY_1` | `decimal` | Period 1 current financial year | [ ] |  |  |
| `PER_CY_10` | `decimal` | Period 10 current financial year | [ ] |  |  |
| `PER_CY_11` | `decimal` | Period 11 current financial year | [ ] |  |  |
| `PER_CY_12` | `decimal` | Period 12 current financial year | [ ] |  |  |
| `PER_CY_13` | `decimal` | Period 13 current financial year | [ ] |  |  |
| `PER_CY_14` | `decimal` | Period 14 current financial year | [ ] |  |  |
| `PER_CY_2` | `decimal` | Period 2 current financial year | [ ] |  |  |
| `PER_CY_3` | `decimal` | Period 3 current financial year | [ ] |  |  |
| `PER_CY_4` | `decimal` | Period 4 current financial year | [ ] |  |  |
| `PER_CY_5` | `decimal` | Period 5 current financial year | [ ] |  |  |
| `PER_CY_6` | `decimal` | Period 6 current financial year | [ ] |  |  |
| `PER_CY_7` | `decimal` | Period 7 current financial year | [ ] |  |  |
| `PER_CY_8` | `decimal` | Period 8 current financial year | [ ] |  |  |
| `PER_CY_9` | `decimal` | Period 9 current financial year | [ ] |  |  |
| `PER_CY_RNG` | `decimal` | Range of periods current financial year | [ ] |  |  |
| `PER_CY_YTP` | `decimal` | Up to period current financial year | [ ] |  |  |
| `PER_PY_0` | `decimal` | Period 0 prior year | [ ] |  |  |
| `PER_PY_1` | `decimal` | Period 1 prior financial year | [ ] |  |  |
| `PER_PY_10` | `decimal` | Period 10 prior financial year | [ ] |  |  |
| `PER_PY_11` | `decimal` | Period 11 prior financial year | [ ] |  |  |
| `PER_PY_12` | `decimal` | Period 12 prior financial year | [ ] |  |  |
| `PER_PY_13` | `decimal` | Period 13 prior financial year | [ ] |  |  |
| `PER_PY_14` | `decimal` | Period 14 prior financial year | [ ] |  |  |
| `PER_PY_2` | `decimal` | Period 2 prior financial year | [ ] |  |  |
| `PER_PY_3` | `decimal` | Period 3 prior financial year | [ ] |  |  |
| `PER_PY_4` | `decimal` | Period 4 prior financial year | [ ] |  |  |
| `PER_PY_5` | `decimal` | Period 5 prior financial year | [ ] |  |  |
| `PER_PY_6` | `decimal` | Period 6 prior financial year | [ ] |  |  |
| `PER_PY_7` | `decimal` | Period 7 prior financial year | [ ] |  |  |
| `PER_PY_8` | `decimal` | Period 8 prior financial year | [ ] |  |  |
| `PER_PY_9` | `decimal` | Period 9 prior financial year | [ ] |  |  |
| `PER_PY_RNG` | `decimal` | Range of periods prior financial year | [ ] |  |  |
| `PER_PY_YTP` | `decimal` | Up to period prior financial year | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unieke code | [ ] |  |  |
| `REC_ORD` | `int32` | Regelvolgorde | [ ] |  |  |
| `RSLT_1` | `varchar2(25)` | Report formula result | [ ] |  |  |
| `TOT_TO1` | `varchar2(10)` | Count column 1 | [ ] |  |  |
| `TOT_TO2` | `varchar2(10)` | Count column 2 | [ ] |  |  |
