invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

ADM_LIST: AccountView Administrations

read only

  • Catálogo: AccountView
  • Label: Administrations

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla ADM_LIST. 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
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