LEAD: AccountView Categories
read only per partition
- Catálogo:
AccountView - Label: Categories
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla LEAD. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |