---
title: "visionplanner_outstanding_payables (AFAS Profit)"
description: "itgen_aoe_visionplanner_outstanding_payables"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.GetConnector.visionplanner_outstanding_payables
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.GetConnector.visionplanner_outstanding_payables
updated: 2026-11-07T09:24:19Z
license: https://documentation.invantive.eu/en/
---

# 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` |  |

