invantive documentation
Invantive SupportforenAnmelden / Eintragen

ADM_LIST: AccountView Administrations

read only

  • Katalog: AccountView
  • Label: Administrations

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle ADM_LIST sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
ADM_ARCH char Archived
ADM_CODE varchar2(10) Administration code
ADM_COMM varchar2(4) Administration note
ADM_DESC varchar2(40) Administration name
ADM_DIR varchar2(200) Administration folder name
ADM_HOLD varchar2(10) Holding administration name
ADM_HOLD2 varchar2(10) Holding administration name (internal)
ADM_MODEL char Sample administration
ADM_PREV varchar2(10) Previous year administration
ADM_REMOTE char Administration at other branch
ADV_ORG char Advice: reorganise administration
ALL_TBL char Do not restrict administration files
ATS_CODE varchar2(20) Client code
ATS_DESC varchar2(40) Description
ATS_EXTRA varchar2(10) Extra field
ATS_LOC varchar2(10) Branch code
ATS_YEAR varchar2(10) Financial year
BLCK_DATE datetime Blocked on date/time
BLCK_USER varchar2(20) Blocked by user
BLCK_USRV varchar2(10) Blocked (icon)
BOOK_DATE datetime Date of last posting
CICO_DATE datetime Carried over on date/time
CICO_USR varchar2(20) Carried over by user
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
CNL_PCT decimal Holding participation percentage
CNL_PCT2 decimal Holding participation percentage (internal)
DBC_NAME varchar2(8) Administration database name
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
INST_CODE varchar2(5) Installation
LIC_CNG char Licence changed
MC_BLOCK char Blocked for multi-client electronic banking
MSG_DEST varchar2(40) Message destination
MSG_STGY varchar2(25) Message class
NET_USE char Administration network usage
ORG_ADM char Administration must be reorganised
SCHED_BLK char Blocked for alerts
SYNC_LOG char Exchange master data