invantive documentation
Forum di supporto InvantiveAccedi / Registrati

profit_transactions_allocated: AFAS Profit itgen_aoe_profit_transactions_allocated

read only REST

  • Catalogo: AfasOnline
  • Schema: GetConnector
  • Etichetta: itgen_aoe_profit_transactions_allocated

È possibile solo recuperare i dati.

Profit_Transactions_Allocated

Codice sorgente dell'API

  • Punto finale: /connectors/Profit_Transactions_Allocated
  • Metadati: metainfo/get/Profit_Transactions_Allocated

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 353
Righe di scansione completa al minuto 65,100
Numero di righe di Query al minuto 169

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella profit_transactions_allocated. 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
accountno varchar2(16) Rekeningnummer fetched only when named, AccountNo
amtcredit number Bedrag credit fetched only when named, AmtCredit
amtdebit number Bedrag debet fetched only when named, AmtDebit
collect_on varchar2(100) Type verzamelrekening fetched only when named, Collect_On
created datetime Datum toegevoegd fetched only when named, Created
description varchar2(255) Omschrijving boeking fetched only when named, Description
dimax1 varchar2(16) Code verbijzonderingsas 1 fetched only when named, DimAx1
dimax2 varchar2(16) Code verbijzonderingsas 2 fetched only when named, DimAx2
dimax3 varchar2(16) Code verbijzonderingsas 3 fetched only when named, DimAx3
dimax4 varchar2(16) Code verbijzonderingsas 4 fetched only when named, DimAx4
dimax5 varchar2(16) Code verbijzonderingsas 5 fetched only when named, DimAx5
entrydate datetime Datum boeking fetched only when named, EntryDate
entryno int32 Nummer journaalpost fetched only when named, EntryNo
invoiceid varchar2(12) Factuurnummer fetched only when named, InvoiceId
journalid varchar2(6) Code dagboek fetched only when named, JournalId
modified datetime Datum gewijzigd fetched only when named, Modified
omschrijving varchar2(50) Omschrijving fetched only when named, Omschrijving
period int32 Periodenummer fetched only when named, Period
seqno int32 Volgnummer journaalpost fetched only when named, SeqNo
type varchar2(100) Type rekening fetched only when named, Type
unitid int32 Administratie fetched only when named, UnitId
vatamt number Btw-bedrag fetched only when named, VatAmt
vatcode varchar2(3) Btw-code fetched only when named, VatCode
voucherdate datetime Boekstukdatum fetched only when named, VoucherDate
voucherno varchar2(32) Boekstuknummer fetched only when named, VoucherNo
year int32 Jaar fetched only when named, Year