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

# fbsubscription: AFAS Profit itgen_aoe_fbsubscription

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

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

Abonnement

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

## API Source

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

## 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 `fbsubscription` 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 |
|---|---|---|:---:|---|---|
| `altsre` | `char` | Factuur naar afwijkende verkooprelatie | [ ] | fetched only when named, `AltSRe` |  |
| `atin` | `char` | Incasseren | [ ] | fetched only when named, `AtIn` |  |
| `auin` | `char` | Automatisch factureren | [ ] | fetched only when named, `AuIn` |  |
| `bankaccount` | `varchar2(40)` | Banknummer afwijkend | [ ] | fetched only when named, `Bankaccount` |  |
| `bcid` | `varchar2(15)` | Organisatie/persoon | [ ] | fetched only when named, `BcId` |  |
| `cti1` | `int32` | Afwijkende contactpersoon | [ ] | fetched only when named, `CtI1` |  |
| `ctpe` | `int32` | Contactpersoon | [ ] | fetched only when named, `CtPe` |  |
| `cuid` | `varchar2(3)` | Valuta | [ ] | fetched only when named, `CuId` |  |
| `daam` | `int32` | Aantal dagen vooraf | [ ] | fetched only when named, `DaAm` |  |
| `dare` | `datetime` | Datum verlenging | [ ] | fetched only when named, `DaRe` |  |
| `dast` | `datetime` | Begindatum factuurcyclus | [ ] | fetched only when named, `DaSt` |  |
| `dbid` | `varchar2(16)` | Verkooprelatie | [ ] | fetched only when named, `DbId` |  |
| `inad` | `char` | Voorschotfactuur | [ ] | fetched only when named, `InAd` |  |
| `indi` | `char` | Verkoop direct factureren | [ ] | fetched only when named, `InDi` |  |
| `inva` | `char` | Prijzen inclusief btw | [ ] | fetched only when named, `InVa` |  |
| `lafr` | `datetime` | Verlaging toegestaan vanaf | [ ] | fetched only when named, `LaFr` |  |
| `lina` | `varchar2(50)` | Naam licentie | [ ] | fetched only when named, `LiNa` |  |
| `noct` | `char` | Uitsluiten van verzamelfactuur | [ ] | fetched only when named, `NoCt` |  |
| `noin` | `char` | Niet factureren | [ ] | fetched only when named, `NoIn` |  |
| `nosi` | `char` | Verkoop niet factureren | [ ] | fetched only when named, `NoSi` |  |
| `pacd` | `varchar2(5)` | Betaalvoorwaarde | [ ] | fetched only when named, `PaCd` |  |
| `prid` | `varchar2(15)` | Project | [ ] | fetched only when named, `PrId` |  |
| `prst` | `varchar2(15)` | Projectfase | [ ] | fetched only when named, `PrSt` |  |
| `rate` | `number` | Valutakoers | [ ] | fetched only when named, `Rate` |  |
| `rfcs` | `varchar2(100)` | Opdrachtnummer/referentie | [ ] | fetched only when named, `RfCs` |  |
| `suen` | `datetime` | Einddatum abonnement | [ ] | fetched only when named, `SuEn` |  |
| `sunr` | `int32` | Nummer abonnement | [ ] | fetched only when named, `SuNr` |  |
| `sust` | `datetime` | Begindatum abonnement | [ ] | fetched only when named, `SuSt` |  |
| `u137e13404fec8c95375ad79c52a0ab69` | `varchar2` | Opmerking abonnement | [ ] | fetched only when named, `U137E13404FEC8C95375AD79C52A0AB69` |  |
| `unfi` | `int32` | Administratie | [ ] | fetched only when named, `UnFi` |  |
| `v1cd` | `varchar2(16)` | Code verbijzonderingsas 1 | [ ] | fetched only when named, `V1Cd` |  |
| `v2cd` | `varchar2(16)` | Code verbijzonderingsas 2 | [ ] | fetched only when named, `V2Cd` |  |
| `v3cd` | `varchar2(16)` | Code verbijzonderingsas 3 | [ ] | fetched only when named, `V3Cd` |  |
| `v4cd` | `varchar2(16)` | Code verbijzonderingsas 4 | [ ] | fetched only when named, `V4Cd` |  |
| `v5cd` | `varchar2(16)` | Code verbijzonderingsas 5 | [ ] | fetched only when named, `V5Cd` |  |
| `vadu` | `varchar2(3)` | Btw-plicht | [ ] | fetched only when named, `VaDu` |  |
| `vain` | `varchar2(20)` | Cyclus facturering | [ ] | fetched only when named, `VaIn` |  |
| `vals` | `varchar2(20)` | Type licentie | [ ] | fetched only when named, `VaLs` |  |
| `vapc` | `varchar2(20)` | Programmatuurcode | [ ] | fetched only when named, `VaPc` |  |
| `vare` | `varchar2(20)` | Cyclusverlenging | [ ] | fetched only when named, `VaRe` |  |
| `vars` | `varchar2(20)` | Reden beëindiging | [ ] | fetched only when named, `VaRs` |  |
| `vasu` | `varchar2(20)` | Type abonnement | [ ] | fetched only when named, `VaSu` |  |
| `vave` | `varchar2(20)` | Versie | [ ] | fetched only when named, `VaVe` |  |

