# FS_LINE: Report model lines - Name: `FS_LINE` - Catalog: `AccountView` - Label: Report model lines - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `FS_LINE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | 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` | `string(100)` | Report formula | ☐ | | | `DSP_COL` | `decimal` | Print column | ☐ | | | `DSP_FMT` | `string(1)` | Line formatting | ☐ | | | `FNT_ALGN_C` | `int32` | Text alignment | ☐ | | | `FNT_ALGN_Y` | `int32` | Amount alignment | ☐ | | | `FNT_BOLD_C` | `boolean` | Bold text | ☐ | | | `FNT_BOLD_Y` | `boolean` | Bold amounts | ☐ | | | `FNT_FORE_C` | `int32` | Text foreground colour | ☐ | | | `FNT_FORE_Y` | `int32` | Amount foreground colour | ☐ | | | `FNT_ITAL_C` | `boolean` | Italic text | ☐ | | | `FNT_ITAL_Y` | `boolean` | Italic amounts | ☐ | | | `FNT_NAME_C` | `string(20)` | Text font | ☐ | | | `FNT_NAME_Y` | `string(20)` | Amount font | ☐ | | | `FNT_SIZE_C` | `int32` | Text font size | ☐ | | | `FNT_SIZE_Y` | `int32` | Amount font size | ☐ | | | `FNT_UNDR_C` | `boolean` | Underlined text | ☐ | | | `FNT_UNDR_Y` | `boolean` | Underlined amounts | ☐ | | | `FS_CODE` | `string(3)` | Report code | ☐ | | | `FSC_LINK` | `string(3)` | Report model link | ☐ | | | `FSL_BOLD` | `boolean` | Bold | ☐ | | | `FSL_DESC` | `string(80)` | Report line description | ☐ | | | `FSL_FNTNM` | `string(50)` | Font | ☐ | | | `FSL_FNTSZ` | `int32` | Font size | ☐ | | | `FSL_ITALIC` | `boolean` | Italic | ☐ | | | `FSL_SUP` | `boolean` | Suppress line | ☐ | | | `FSL_ULINE` | `boolean` | Underline | ☐ | | | `LEAD_CODE` | `string(10)` | Category code | ☐ | | | `LEAD_LINK` | `string(10)` | Category link | ☐ | | | `LINK_STAT` | `decimal` | Link status | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `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` | `string(10)` | Unique code | ☐ | | | `REC_ORD` | `int32` | Line sequence | ☐ | | | `RSLT_1` | `string(25)` | Report formula result | ☐ | | | `TOT_TO1` | `string(10)` | Count column 1 | ☐ | | | `TOT_TO2` | `string(10)` | Count column 2 | ☐ | |