LEAD: AccountView Categories
read only per partition
- Catalogue :
AccountView - Label: Categories
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table LEAD 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 |
|---|---|---|---|---|---|
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 de modification | |||
CNG_NR |
int32 |
Modifier le numéro | |||
CNG_ |
varchar2 |
Employee last modified | |||
HINT_ |
varchar2 |
Recognition codes | |||
HINT_ |
decimal |
Recognition order of application | |||
INP_ |
datetime |
Date d'inscription | |||
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 |