invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_FROM varchar2(2) Account number from
ACCT_NR1 varchar2(10) Account number from
ACCT_NR2 varchar2(10) Account number up to and including
ACCT_TO varchar2(2) Account number up to and including
ACCT_TYPE int32 Account type
BAL_CY int64 Current financial year
BAL_PY int64 Previous financial year
BUD_CY int64 Total budget current financial year
BUD_CY_0 int64 Budget period 0 current year
BUD_CY_1 int64 Budget period 1 current year
BUD_CY_10 int64 Budget period 10 current year
BUD_CY_11 int64 Budget period 11 current year
BUD_CY_12 int64 Budget period 12 current year
BUD_CY_13 int64 Budget period 13 current year
BUD_CY_14 int64 Budget period 14 current year
BUD_CY_2 int64 Budget period 2 current year
BUD_CY_3 int64 Budget period 3 current year
BUD_CY_4 int64 Budget period 4 current year
BUD_CY_5 int64 Budget period 5 current year
BUD_CY_6 int64 Budget period 6 current year
BUD_CY_7 int64 Budget period 7 current year
BUD_CY_8 int64 Budget period 8 current year
BUD_CY_9 int64 Budget period 9 current year
BUD_PY int64 Total budget previous financial year
BUD_PY_0 int64 Budget period 0 prior year
BUD_PY_1 int64 Budget period 1 prior year
BUD_PY_10 int64 Budget period 10 prior year
BUD_PY_11 int64 Budget period 11 prior year
BUD_PY_12 int64 Budget period 12 prior year
BUD_PY_13 int64 Budget period 13 prior year
BUD_PY_14 int64 Budget period 14 prior year
BUD_PY_2 int64 Budget period 2 prior year
BUD_PY_3 int64 Budget period 3 prior year
BUD_PY_4 int64 Budget period 4 prior year
BUD_PY_5 int64 Budget period 5 prior year
BUD_PY_6 int64 Budget period 6 prior year
BUD_PY_7 int64 Budget period 7 prior year
BUD_PY_8 int64 Budget period 8 prior year
BUD_PY_9 int64 Budget period 9 prior year
CHK_ABAL decimal Linked account check
CHK_ATYP decimal Check account type
CHK_LBAL decimal Check category balance
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
HINT_LIST varchar2(4) Recognition codes
HINT_ORDER decimal Recognition order of application
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
LEAD_CODE varchar2(10) Category code
LEAD_DESC varchar2(40) Category description
LEAD_FO varchar2(10) Category code Financial Overview
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PER_CY_0 int64 Period 0 current financial year
PER_CY_1 int64 Period 1 current financial year
PER_CY_10 int64 Period 10 current financial year
PER_CY_11 int64 Period 11 current financial year
PER_CY_12 int64 Period 12 current financial year
PER_CY_13 int64 Period 13 current financial year
PER_CY_14 int64 Period 14 current financial year
PER_CY_2 int64 Period 2 current financial year
PER_CY_3 int64 Period 3 current financial year
PER_CY_4 int64 Period 4 current financial year
PER_CY_5 int64 Period 5 current financial year
PER_CY_6 int64 Period 6 current financial year
PER_CY_7 int64 Period 7 current financial year
PER_CY_8 int64 Period 8 current financial year
PER_CY_9 int64 Period 9 current financial year
PER_PY_0 int64 Period 0 prior year
PER_PY_1 int64 Period 1 prior financial year
PER_PY_10 int64 Period 10 prior financial year
PER_PY_11 int64 Period 11 prior financial year
PER_PY_12 int64 Period 12 prior financial year
PER_PY_13 int64 Period 13 prior financial year
PER_PY_14 int64 Period 14 prior financial year
PER_PY_2 int64 Period 2 prior financial year
PER_PY_3 int64 Period 3 prior financial year
PER_PY_4 int64 Period 4 prior financial year
PER_PY_5 int64 Period 5 prior financial year
PER_PY_6 int64 Period 6 prior financial year
PER_PY_7 int64 Period 7 prior financial year
PER_PY_8 int64 Period 8 prior financial year
PER_PY_9 int64 Period 9 prior financial year
RAT_GRP varchar2(5) Ratio group
USE_HINT char Use recognition codes