invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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_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 Datum van wijziging
CNG_NR int32 Nummer wijzigen
CNG_USR varchar2(20) Employee last modified
HINT_LIST varchar2(4) Recognition codes
HINT_ORDER decimal Recognition order of application
INP_DATE datetime Datum van inschrijving
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