LEAD: AccountView Categories
read only per partition
- Catalogo:
AccountView - Label: Categories
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella LEAD. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Account number from | |||
ACCT_ |
varchar2 |
Account number from | |||
ACCT_ |
varchar2 |
Account number up to and including | |||
ACCT_ |
varchar2 |
Account number up to and including | |||
ACCT_ |
int32 |
Account type | |||
BAL_CY |
int64 |
Current financial year | |||
BAL_PY |
int64 |
Previous financial year | |||
BUD_CY |
int64 |
Total budget current financial year | |||
BUD_ |
int64 |
Budget period 0 current year | |||
BUD_ |
int64 |
Budget period 1 current year | |||
BUD_ |
int64 |
Budget period 10 current year | |||
BUD_ |
int64 |
Budget period 11 current year | |||
BUD_ |
int64 |
Budget period 12 current year | |||
BUD_ |
int64 |
Budget period 13 current year | |||
BUD_ |
int64 |
Budget period 14 current year | |||
BUD_ |
int64 |
Budget period 2 current year | |||
BUD_ |
int64 |
Budget period 3 current year | |||
BUD_ |
int64 |
Budget period 4 current year | |||
BUD_ |
int64 |
Budget period 5 current year | |||
BUD_ |
int64 |
Budget period 6 current year | |||
BUD_ |
int64 |
Budget period 7 current year | |||
BUD_ |
int64 |
Budget period 8 current year | |||
BUD_ |
int64 |
Budget period 9 current year | |||
BUD_PY |
int64 |
Total budget previous financial year | |||
BUD_ |
int64 |
Budget period 0 prior year | |||
BUD_ |
int64 |
Budget period 1 prior year | |||
BUD_ |
int64 |
Budget period 10 prior year | |||
BUD_ |
int64 |
Budget period 11 prior year | |||
BUD_ |
int64 |
Budget period 12 prior year | |||
BUD_ |
int64 |
Budget period 13 prior year | |||
BUD_ |
int64 |
Budget period 14 prior year | |||
BUD_ |
int64 |
Budget period 2 prior year | |||
BUD_ |
int64 |
Budget period 3 prior year | |||
BUD_ |
int64 |
Budget period 4 prior year | |||
BUD_ |
int64 |
Budget period 5 prior year | |||
BUD_ |
int64 |
Budget period 6 prior year | |||
BUD_ |
int64 |
Budget period 7 prior year | |||
BUD_ |
int64 |
Budget period 8 prior year | |||
BUD_ |
int64 |
Budget period 9 prior year | |||
CHK_ |
decimal |
Linked account check | |||
CHK_ |
decimal |
Check account type | |||
CHK_ |
decimal |
Check category balance | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
HINT_ |
varchar2 |
Recognition codes | |||
HINT_ |
decimal |
Recognition order of application | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LEAD_ |
varchar2 |
Category code | |||
LEAD_ |
varchar2 |
Category description | |||
LEAD_ |
varchar2 |
Category code Financial Overview | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PER_ |
int64 |
Period 0 current financial year | |||
PER_ |
int64 |
Period 1 current financial year | |||
PER_ |
int64 |
Period 10 current financial year | |||
PER_ |
int64 |
Period 11 current financial year | |||
PER_ |
int64 |
Period 12 current financial year | |||
PER_ |
int64 |
Period 13 current financial year | |||
PER_ |
int64 |
Period 14 current financial year | |||
PER_ |
int64 |
Period 2 current financial year | |||
PER_ |
int64 |
Period 3 current financial year | |||
PER_ |
int64 |
Period 4 current financial year | |||
PER_ |
int64 |
Period 5 current financial year | |||
PER_ |
int64 |
Period 6 current financial year | |||
PER_ |
int64 |
Period 7 current financial year | |||
PER_ |
int64 |
Period 8 current financial year | |||
PER_ |
int64 |
Period 9 current financial year | |||
PER_ |
int64 |
Period 0 prior year | |||
PER_ |
int64 |
Period 1 prior financial year | |||
PER_ |
int64 |
Period 10 prior financial year | |||
PER_ |
int64 |
Period 11 prior financial year | |||
PER_ |
int64 |
Period 12 prior financial year | |||
PER_ |
int64 |
Period 13 prior financial year | |||
PER_ |
int64 |
Period 14 prior financial year | |||
PER_ |
int64 |
Period 2 prior financial year | |||
PER_ |
int64 |
Period 3 prior financial year | |||
PER_ |
int64 |
Period 4 prior financial year | |||
PER_ |
int64 |
Period 5 prior financial year | |||
PER_ |
int64 |
Period 6 prior financial year | |||
PER_ |
int64 |
Period 7 prior financial year | |||
PER_ |
int64 |
Period 8 prior financial year | |||
PER_ |
int64 |
Period 9 prior financial year | |||
RAT_ |
varchar2 |
Ratio group | |||
USE_ |
char |
Use recognition codes |