invantive documentation
Forum di supporto InvantiveAccedi / Registrati

COMP_HDR: AccountView Enterprises

read only

  • Catalogo: AccountView
  • Label: Enterprises

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella COMP_HDR. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 Data di scadenza
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) Numero di registrazione presso la Camera di Commercio
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.