---
title: "vplan_salesorder (AFAS Profit)"
description: "itgen_aoe_vplan_salesorder"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/afas/AfasOnline.GetConnector.vplan_salesorder
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.GetConnector.vplan_salesorder
updated: 2026-11-17T12:40:54Z
license: https://documentation.invantive.eu/nl/
---

# vplan_salesorder: AFAS Profit itgen_aoe_vplan_salesorder

`read only` `REST`

- Catalogus: `AfasOnline`
- Schema: `GetConnector`
- Label: itgen_aoe_vplan_salesorder

Kan alleen gegevens ophalen.

## Samenvatting

VPLAN_SalesOrder

## API-bron

- Eindpunt: `/connectors/VPLAN_SalesOrder`
- Metagegevens: `metainfo/get/VPLAN_SalesOrder`

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 353 |
| Aantal rijen per minuut bij volledige scan | 65,100 |
| Aantal rijen per minuut in een Query | 169 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Tabelkolommen

De kolommen van de tabel `vplan_salesorder` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `afas_created_at` | `datetime` | Aangemaakt op | [ ] | fetched only when named, `afas_created_at` |  |
| `afas_updated_at` | `datetime` | Gewijzigd op | [ ] | fetched only when named, `afas_updated_at` |  |
| `city` | `varchar2(50)` | Woonplaats | [ ] | fetched only when named, `city` |  |
| `contact` | `varchar2(80)` | Vertegenwoordiger | [ ] | fetched only when named, `contact` |  |
| `country` | `varchar2(3)` | Land | [ ] | fetched only when named, `country` |  |
| `date` | `datetime` | Datum | [ ] | fetched only when named, `date` |  |
| `delivered_date` | `datetime` | Werkelijke datum aflevering | [ ] | fetched only when named, `delivered_date` |  |
| `desired_date` | `datetime` | Gewenste leverdatum | [ ] | fetched only when named, `desired_date` |  |
| `external_ref` | `varchar2(12)` | Nummer | [ ] | fetched only when named, `external_ref` |  |
| `houseadd` | `varchar2(30)` | Toev. aan huisnr. | [ ] | fetched only when named, `houseadd` |  |
| `houseno` | `int32` | Huisnummer | [ ] | fetched only when named, `houseno` |  |
| `note` | `varchar2` | Opmerking extern | [ ] | fetched only when named, `note` |  |
| `postcode` | `varchar2(15)` | Postcode | [ ] | fetched only when named, `postcode` |  |
| `project` | `varchar2(15)` | Project | [ ] | fetched only when named, `project` |  |
| `promised_date` | `datetime` | Datum levering (toegezegd) | [ ] | fetched only when named, `promised_date` |  |
| `relation` | `varchar2(16)` | Verkooprelatie | [ ] | fetched only when named, `relation` |  |
| `relation_ref` | `varchar2(100)` | Opdrachtnummer/referentie | [ ] | fetched only when named, `relation_ref` |  |
| `status` | `varchar2(100)` | Status | [ ] | fetched only when named, `status` |  |
| `street` | `varchar2(60)` | Straat | [ ] | fetched only when named, `street` |  |
| `warehouse` | `varchar2(15)` | Magazijn | [ ] | fetched only when named, `warehouse` |  |
