invantive documentation
Invantive Support ForumsLog In / Sign Up

visionplanner_outstanding_payables: AFAS Profit itgen_aoe_visionplanner_outstanding_payables

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_visionplanner_outstanding_payables

Can only retrieve data.

Summary

Visionplanner outstanding payables

API Source

  • Endpoint: /connectors/Visionplanner_outstanding_payables
  • Metadata: metainfo/get/Visionplanner_outstanding_payables

Performance Characteristics

Characteristic Value
Average access latency (ms) 353
Full scan rows per minute 65,100
Point query rows per minute 169

The result can be cached on the client.

Table Columns

The columns of the table visionplanner_outstanding_payables are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
administrationid int32 Administratie fetched only when named, AdministrationId
amountpaid number Afgelost fetched only when named, Amountpaid
creditorid varchar2(16) Subnummer fetched only when named, CreditorId
duedate datetime Vervaldatum fetched only when named, DueDate
invoice_dc varchar2(1) Factuurbedrag D/C fetched only when named, Invoice_DC
invoiceamount number Totaal factuurbedrag fetched only when named, InvoiceAmount
invoicedescription varchar2(255) Omschrijving factuur fetched only when named, InvoiceDescription
invoiceid varchar2(12) Factuurnummer fetched only when named, InvoiceId
journaldate datetime Boekstukdatum fetched only when named, JournalDate
name varchar2(255) Naam fetched only when named, Name
outstandingamount number Saldo fetched only when named, OutstandingAmount
outstandingamount_dc varchar2(1) Saldo D/C fetched only when named, OutstandingAmount_DC