invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

DCT_FILE: AccountView Data Dictionary

read only

  • Catalogus: AccountView
  • Label: Data Dictionary

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel DCT_FILE 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
ADD_BASE char Add real fields and indexes to base table
CNG_DATE datetime Datum van wijziging
CNG_NR int32 Nummer wijzigen
CNG_USR varchar2(20) Employee last modified
DBF_BASE varchar2(8) Reference to base table
DBF_CATEG int32 Category
DBF_CATEGD varchar2(25) Category description
DBF_DESC varchar2(40) Table description
DBF_DESCT varchar2(40) Table description (translated)
DBF_EXTRA varchar2(4) Note
DBF_NAME varchar2(8) Table name
DBF_TYPE int32 Table type
DBF_TYPED varchar2(25) Table type description
DBF_VIRT char Virtual table
DESC_EXPN varchar2(40) Key field description expression
FILE_EXTRA varchar2(4) Additional table information
INP_DATE datetime Datum van inschrijving
INP_USR varchar2(20) Entered by employee
LOG_DEL char Log deletions
LOG_INS char Log additions
LOG_UPD char Log changes
NO_COPY char Copying not possible
NO_DELETE char Deleting not possible
NO_INSERT char Adding not possible
NO_UPDATE char Changing not possible
NO_XML_UPD char Changes not via Web API
OBJ_ACTIVE char Object active
OBJ_CODE varchar2(4) Objectcode
OBJ_GRP varchar2(40) Explorer subgroups
OBJ_IMP char Object usable for import
OBJ_LIST char Object in query list
OBJ_TASK char Object suitable for task-oriented interface
OBJ_TYPE decimal Object type
OBJ_WHEN varchar2(100) Object visible as
REC_BLK char Blocked
REC_CUST char Customised
REC_DESC varchar2(40) Record description
SETUP_DATA char Carry over to new year
SORT_EXPN varchar2(70) Sort expression
STD_VIEW char Use standard object
TBL_ACTIVE char Table active
TBL_CHILD varchar2(8) Line table
TBL_HDR varchar2(8) Header table
TXT_ID varchar2(10) Text identification
WHEN_EXPN varchar2(100) When expression