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

# fbsubscription_fbsubscriptionlines: AFAS Profit itgen_aoe_fbsubscription_fbsubscriptionlines

`insert` `REST`

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

Abonnement: FbSubscriptionLines

Can retrieve data and change data using `insert`.

## 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_fbsubscriptionlines` 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 |
|---|---|---|:---:|---|---|
| `crfr` | `datetime` | Crediteren vanaf | [ ] | fetched only when named, `CrFr` |  |
| `crsi` | `char` | Verkoop crediteren | [ ] | fetched only when named, `CrSi` |  |
| `daen` | `datetime` | Einddatum | [ ] | fetched only when named, `DaEn` |  |
| `dapu` | `datetime` | Aanschafdatum | [ ] | fetched only when named, `DaPu` |  |
| `dast` | `datetime` | Begindatum | [ ] | fetched only when named, `DaSt` |  |
| `dcpr` | `number` | Kortingspercentage | [ ] | fetched only when named, `DcPr` |  |
| `dipr` | `number` | % Korting verkoop | [ ] | fetched only when named, `DiPr` |  |
| `disc` | `number` | Korting basisvaluta | [ ] | fetched only when named, `Disc` |  |
| `id` | `int32` | Regelnummer | [ ] | fetched only when named, `Id` |  |
| `infr` | `datetime` | Factureren vanaf | [ ] | fetched only when named, `InFr` |  |
| `ispc` | `char` | Korting op basis van % | [ ] | fetched only when named, `IsPc` |  |
| `isps` | `char` | Verkoopkorting op basis van % | [ ] | fetched only when named, `IsPS` |  |
| `itcd` | `varchar2(40)` | Itemcode | [ ] | fetched only when named, `ItCd` |  |
| `nfdi` | `varchar2(15)` | Korting vreemde valuta | [ ] | fetched only when named, `NFDi` |  |
| `nfpr` | `varchar2(15)` | Afwijkende prijs vreemde valuta | [ ] | fetched only when named, `NFPr` |  |
| `pric` | `number` | Afwijkende prijs basisvaluta | [ ] | fetched only when named, `Pric` |  |
| `qu` | `number` | Aantal | [ ] | fetched only when named, `Qu` |  |
| `sadi` | `number` | Kortingsbedrag verkoop basisvaluta | [ ] | fetched only when named, `SaDi` |  |
| `sapr` | `number` | Afw. verkoopprijs basisvaluta | [ ] | fetched only when named, `SaPr` |  |
| `sfdi` | `varchar2(15)` | Kortingsbedrag verkoop vreemde valuta | [ ] | fetched only when named, `SFDi` |  |
| `sfpr` | `varchar2(15)` | Afw. verkoop prijs vreemde valuta | [ ] | fetched only when named, `SFPr` |  |
| `sucr` | `char` | Abonnement crediteren | [ ] | fetched only when named, `SuCr` |  |
| `u900377e747f3e088a7452c99a82a5427` | `varchar2` | Opmerking | [ ] | fetched only when named, `U900377E747F3E088A7452C99A82A5427` |  |
| `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` |  |
| `vait` | `varchar2(10)` | Type item | [ ] | fetched only when named, `VaIt` |  |
| `vars` | `varchar2(20)` | Reden beëindiging | [ ] | fetched only when named, `VaRs` |  |

