FS_LINE: AccountView Report model lines
read only per partition
- Catalogue :
AccountView - Label: Report model lines
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table FS_LINE sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | 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 |
Code unique | |||
REC_ |
int32 |
Séquence de lignes | |||
RSLT_1 |
varchar2 |
Report formula result | |||
TOT_ |
varchar2 |
Count column 1 | |||
TOT_ |
varchar2 |
Count column 2 |