LEAD: AccountView Categories
read only per partition
- Catalogus:
AccountView - Label: Categories
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel LEAD worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | 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 |
Datum van wijziging | |||
CNG_NR |
int32 |
Nummer wijzigen | |||
CNG_ |
varchar2 |
Employee last modified | |||
HINT_ |
varchar2 |
Recognition codes | |||
HINT_ |
decimal |
Recognition order of application | |||
INP_ |
datetime |
Datum van inschrijving | |||
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 |