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_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY | |||
AA_ |
int64 |
Actual CY - PY (%) | |||
AB_ |
int64 |
Actual CY - budget CY | |||
AB_ |
int64 |
Actual PY - budget PY | |||
AB_ |
int64 |
Actual CY - budget CY (%) | |||
AB_ |
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_ |
int64 |
Budget CY - PY (%) | |||
BUD_CY |
decimal |
Budget current year | |||
BUD_ |
decimal |
Budget period 0 current year | |||
BUD_ |
decimal |
Budget period 1 current year | |||
BUD_ |
decimal |
Budget period 10 current year | |||
BUD_ |
decimal |
Budget period 11 current year | |||
BUD_ |
decimal |
Budget period 12 current year | |||
BUD_ |
decimal |
Budget period 13 current year | |||
BUD_ |
decimal |
Budget period 14 current year | |||
BUD_ |
decimal |
Budget period 2 current year | |||
BUD_ |
decimal |
Budget period 3 current year | |||
BUD_ |
decimal |
Budget period 4 current year | |||
BUD_ |
decimal |
Budget period 5 current year | |||
BUD_ |
decimal |
Budget period 6 current year | |||
BUD_ |
decimal |
Budget period 7 current year | |||
BUD_ |
decimal |
Budget period 8 current year | |||
BUD_ |
decimal |
Budget period 9 current year | |||
BUD_ |
decimal |
Budget range current year | |||
BUD_ |
decimal |
Up to period budget current year | |||
BUD_PY |
decimal |
Budget prior year | |||
BUD_ |
decimal |
Budget period 0 prior year | |||
BUD_ |
decimal |
Budget period 1 prior year | |||
BUD_ |
decimal |
Budget period 10 prior year | |||
BUD_ |
decimal |
Budget period 11 prior year | |||
BUD_ |
decimal |
Budget period 12 prior year | |||
BUD_ |
decimal |
Budget period 13 prior year | |||
BUD_ |
decimal |
Budget period 14 prior year | |||
BUD_ |
decimal |
Budget period 2 prior year | |||
BUD_ |
decimal |
Budget period 3 prior year | |||
BUD_ |
decimal |
Budget period 4 prior year | |||
BUD_ |
decimal |
Budget period 5 prior year | |||
BUD_ |
decimal |
Budget period 6 prior year | |||
BUD_ |
decimal |
Budget period 7 prior year | |||
BUD_ |
decimal |
Budget period 8 prior year | |||
BUD_ |
decimal |
Budget period 9 prior year | |||
BUD_ |
decimal |
Budget range prior year | |||
BUD_ |
decimal |
Up to period budget prior year | |||
CALC_1 |
varchar2 |
Report formula | |||
DSP_ |
decimal |
Print column | |||
DSP_ |
varchar2 |
Line formatting | |||
FNT_ |
int32 |
Text alignment | |||
FNT_ |
int32 |
Amount alignment | |||
FNT_ |
char |
Bold text | |||
FNT_ |
char |
Bold amounts | |||
FNT_ |
int32 |
Text foreground colour | |||
FNT_ |
int32 |
Amount foreground colour | |||
FNT_ |
char |
Italic text | |||
FNT_ |
char |
Italic amounts | |||
FNT_ |
varchar2 |
Text font | |||
FNT_ |
varchar2 |
Amount font | |||
FNT_ |
int32 |
Text font size | |||
FNT_ |
int32 |
Amount font size | |||
FNT_ |
char |
Underlined text | |||
FNT_ |
char |
Underlined amounts | |||
FS_ |
varchar2 |
Report code | |||
FSC_ |
varchar2 |
Report model link | |||
FSL_ |
char |
Bold | |||
FSL_ |
varchar2 |
Report line description | |||
FSL_ |
varchar2 |
Font | |||
FSL_ |
int32 |
Font size | |||
FSL_ |
char |
Italic | |||
FSL_ |
char |
Suppress line | |||
FSL_ |
char |
Underline | |||
LEAD_ |
varchar2 |
Category code | |||
LEAD_ |
varchar2 |
Category link | |||
LINK_ |
decimal |
Link status | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PER_ |
decimal |
Period 0 current financial year | |||
PER_ |
decimal |
Period 1 current financial year | |||
PER_ |
decimal |
Period 10 current financial year | |||
PER_ |
decimal |
Period 11 current financial year | |||
PER_ |
decimal |
Period 12 current financial year | |||
PER_ |
decimal |
Period 13 current financial year | |||
PER_ |
decimal |
Period 14 current financial year | |||
PER_ |
decimal |
Period 2 current financial year | |||
PER_ |
decimal |
Period 3 current financial year | |||
PER_ |
decimal |
Period 4 current financial year | |||
PER_ |
decimal |
Period 5 current financial year | |||
PER_ |
decimal |
Period 6 current financial year | |||
PER_ |
decimal |
Period 7 current financial year | |||
PER_ |
decimal |
Period 8 current financial year | |||
PER_ |
decimal |
Period 9 current financial year | |||
PER_ |
decimal |
Range of periods current financial year | |||
PER_ |
decimal |
Up to period current financial year | |||
PER_ |
decimal |
Period 0 prior year | |||
PER_ |
decimal |
Period 1 prior financial year | |||
PER_ |
decimal |
Period 10 prior financial year | |||
PER_ |
decimal |
Period 11 prior financial year | |||
PER_ |
decimal |
Period 12 prior financial year | |||
PER_ |
decimal |
Period 13 prior financial year | |||
PER_ |
decimal |
Period 14 prior financial year | |||
PER_ |
decimal |
Period 2 prior financial year | |||
PER_ |
decimal |
Period 3 prior financial year | |||
PER_ |
decimal |
Period 4 prior financial year | |||
PER_ |
decimal |
Period 5 prior financial year | |||
PER_ |
decimal |
Period 6 prior financial year | |||
PER_ |
decimal |
Period 7 prior financial year | |||
PER_ |
decimal |
Period 8 prior financial year | |||
PER_ |
decimal |
Period 9 prior financial year | |||
PER_ |
decimal |
Range of periods prior financial year | |||
PER_ |
decimal |
Up to period prior financial year | |||
REC_ID |
varchar2 |
Unique code | |||
REC_ |
int32 |
Line sequence | |||
RSLT_1 |
varchar2 |
Report formula result | |||
TOT_ |
varchar2 |
Count column 1 | |||
TOT_ |
varchar2 |
Count column 2 |