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

# fiinvoice: AFAS Profit itgen_aoe_fiinvoice

`insert` `update` `delete` `REST`

- Catalog: `AfasOnline`
- Schema: `UpdateConnector`
- Label: itgen_aoe_fiinvoice

Financiële factuur

Can retrieve data and change data using `insert`, `update` and `delete`.

## API Source

- Endpoint: `/connectors/FiInvoice`
- Metadata: `metainfo/update/FiInvoice`

## 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 `fiinvoice` 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 |
|---|---|---|:---:|---|---|
| `accr` | `number` | Kredietbeperking (valuta) | [ ] | fetched only when named, `AcCr` |  |
| `acpa` | `number` | Betalingskorting (valuta) | [ ] | fetched only when named, `AcPa` |  |
| `amcr` | `number` | Kredietbeperking | [ ] | fetched only when named, `AmCr` |  |
| `amfo` | `number` | Bedrag FOD | [ ] | fetched only when named, `AmFO` |  |
| `ampa` | `number` | Betalingskorting | [ ] | fetched only when named, `AmPa` |  |
| `amrs` | `number` | Bedrag RSZ/RSVZ | [ ] | fetched only when named, `AmRS` |  |
| `aupa` | `char` | Automatisch betalen/incasso | [ ] | fetched only when named, `AuPa` |  |
| `bankaccount` | `varchar2(40)` | Afwijkende betaalrekeningnr. | [ ] | fetched only when named, `BankAccount` |  |
| `blpa` | `char` | Geblokkeerd voor betaling/incasso | [ ] | fetched only when named, `BlPa` |  |
| `dacl` | `int32` | Dagen kredietbeperking | [ ] | fetched only when named, `DaCl` |  |
| `dadp` | `int32` | Dagen betalingskorting | [ ] | fetched only when named, `DaDp` |  |
| `dcnr` | `varchar2(16)` | Subnummer | [ ] | fetched only when named, `DcNr` |  |
| `ddid` | `varchar2(35)` | Kenmerk machtiging | [ ] | fetched only when named, `DdId` |  |
| `dedu` | `varchar2(20)` | Inhoudingsplicht | [ ] | fetched only when named, `DeDu` |  |
| `ds` | `varchar2(255)` | Omschrijving factuur | [ ] | fetched only when named, `Ds` |  |
| `dule` | `char` | Aanmanen | [ ] | fetched only when named, `DuLe` |  |
| `exda` | `datetime` | Vervaldatum | [ ] | fetched only when named, `ExDa` |  |
| `fref` | `varchar2(32)` | Factuurreferentie | [ ] | fetched only when named, `Fref` |  |
| `inac` | `number` | Bedrag rente (valuta) | [ ] | fetched only when named, `InAc` |  |
| `inam` | `number` | Bedrag rente | [ ] | fetched only when named, `InAm` |  |
| `inid` | `varchar2(12)` | Factuurnummer | [ ] | fetched only when named, `InId` |  |
| `ldda` | `datetime` | Datum laatste aanmaning | [ ] | fetched only when named, `LdDa` |  |
| `nrdu` | `int32` | Aantal aanmaningen | [ ] | fetched only when named, `NrDu` |  |
| `paba` | `char` | Terugbetalen | [ ] | fetched only when named, `PaBa` |  |
| `pacd` | `varchar2(5)` | Betaalvoorwaarde | [ ] | fetched only when named, `PaCd` |  |
| `paid` | `varchar2(32)` | Betalingskenmerk | [ ] | fetched only when named, `PaId` |  |
| `pars` | `varchar2(35)` | Kenmerk betaling RSZ/RSVZ | [ ] | fetched only when named, `PaRS` |  |
| `poco` | `varchar2(50)` | POP-code | [ ] | fetched only when named, `PoCo` |  |
| `unid` | `int32` | Administratie | [ ] | fetched only when named, `UnId` |  |
| `vaad` | `varchar2(10)` | Type rekening | [ ] | fetched only when named, `VaAd` |  |
| `vapa` | `char` | Betalingskorting incl. btw | [ ] | fetched only when named, `VaPa` |  |

