invantive documentation
Invantive Support ForumsLog In / Sign Up

FS_LINE: AccountView Report model lines

read only per partition

  • Catalog: AccountView
  • Label: Report model lines

Can only retrieve data.

Table Columns

The columns of the table FS_LINE 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
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
partition_name varchar2 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 varchar2(10) Unique code
REC_ORD int32 Line sequence
RSLT_1 varchar2(25) Report formula result
TOT_TO1 varchar2(10) Count column 1
TOT_TO2 varchar2(10) Count column 2