invantive documentation
Invantive SupportforenAnmelden / Eintragen

COMP_HDR: AccountView Enterprises

read only

  • Katalog: AccountView
  • Label: Enterprises

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle COMP_HDR 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
AI_ALLOWPR char Invoices via print service AutoInvoice possible
AI_API varchar2(36) Enterprise API key AutoInvoice
C_MDM_STRT datetime Start moment of synchronisation with Visma.net
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
COMP_DESC varchar2(40) Enterprise description
COMP_ID varchar2(10) Enterprise code
DIM_FO varchar2(4) Dimensions for Financial Overview
DJIS_MSG varchar2(4) Journal message notifications
DJIS_PROCD datetime Last processing of journal messages
EA_VAR decimal eAccounting edition
EV_CKEY varchar2(40) Customer key (eVerbinding)
EV_CSEC varchar2(40) Customer secret (eVerbinding)
EV_ENTITY varchar2(20) Company ID (eVerbinding)
EV_INTREQ varchar2(40) Access request code
EV_REQID varchar2(50) Email address (eVerbinding)
EXP_DATE datetime Ablaufdatum
FO_ID varchar2(36) ID of the administration in Visma Online
GOCOMP_CNG int32 Enterprise change number for AV Go
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
IS_AUTOI char AutoInvoice enterprise
IS_CON_APP char AccountView Contact (read-only)
IS_EVERB char eVerbinding enterprise
IS_FO char Financial Overview enterprise
IS_GO char AccountView Go
IS_SCAN char Scanbooks enterprise
IS_VDC char Available in IFA
KVK_NR varchar2(10) Handelsregisternummer
L_MDM_STRT datetime Last successful synchronisation with Visma.net
LIC_CHECK varchar2(10) Client licence check number
LIC_CODE varchar2(51) Client licence module data
LIC_NAME varchar2(50) Client licence name
LIC_SER varchar2(10) Client licence serial number
NMBRS_ID varchar2(20) Nmbrs company code
ODP_ID int32 Enterprise Visma ID
RES_MDM char Restore master data in MDM at next sync
SB_DEPTCD varchar2(12) Branch code
SB_SBSNR varchar2(16) YSB number
SB_SPECS varchar2(10) Specification
SYNC_END datetime End of last synchronisation
SYNC_MSG varchar2(4) Message of last synchronisation
SYNC_STAT int32 Status of last synchronisation
SYNC_STRT datetime Start of last synchronisation
VAT_NR varchar2(14) Fiscal VAT no.