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_ |
char |
Invoices via print service AutoInvoice possible | |||
AI_API |
varchar2 |
Enterprise API key AutoInvoice | |||
C_ |
datetime |
Start moment of synchronisation with Visma.net | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
COMP_ |
varchar2 |
Enterprise description | |||
COMP_ |
varchar2 |
Enterprise code | |||
DIM_FO |
varchar2 |
Dimensions for Financial Overview | |||
DJIS_ |
varchar2 |
Journal message notifications | |||
DJIS_ |
datetime |
Last processing of journal messages | |||
EA_VAR |
decimal |
eAccounting edition | |||
EV_ |
varchar2 |
Customer key (eVerbinding) | |||
EV_ |
varchar2 |
Customer secret (eVerbinding) | |||
EV_ |
varchar2 |
Company ID (eVerbinding) | |||
EV_ |
varchar2 |
Access request code | |||
EV_ |
varchar2 |
Email address (eVerbinding) | |||
EXP_ |
datetime |
Data di scadenza | |||
FO_ID |
varchar2 |
ID of the administration in Visma Online | |||
GOCOMP_ |
int32 |
Enterprise change number for AV Go | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
IS_ |
char |
AutoInvoice enterprise | |||
IS_ |
char |
AccountView Contact (read-only) | |||
IS_ |
char |
eVerbinding enterprise | |||
IS_FO |
char |
Financial Overview enterprise | |||
IS_GO |
char |
AccountView Go | |||
IS_ |
char |
Scanbooks enterprise | |||
IS_VDC |
char |
Available in IFA | |||
KVK_NR |
varchar2 |
Numero di registrazione presso la Camera di Commercio | |||
L_ |
datetime |
Last successful synchronisation with Visma.net | |||
LIC_ |
varchar2 |
Client licence check number | |||
LIC_ |
varchar2 |
Client licence module data | |||
LIC_ |
varchar2 |
Client licence name | |||
LIC_ |
varchar2 |
Client licence serial number | |||
NMBRS_ |
varchar2 |
Nmbrs company code | |||
ODP_ID |
int32 |
Enterprise Visma ID | |||
RES_ |
char |
Restore master data in MDM at next sync | |||
SB_ |
varchar2 |
Branch code | |||
SB_ |
varchar2 |
YSB number | |||
SB_ |
varchar2 |
Specification | |||
SYNC_ |
datetime |
End of last synchronisation | |||
SYNC_ |
varchar2 |
Message of last synchronisation | |||
SYNC_ |
int32 |
Status of last synchronisation | |||
SYNC_ |
datetime |
Start of last synchronisation | |||
VAT_NR |
varchar2 |
Fiscal VAT no. |