# fbsubscription_fbsubscriptionlines Abonnement: FbSubscriptionLines - Catalog: `AfasOnline` - Schema: `UpdateConnector` - Retrieve: False - Insert: True - Update: False - Delete: False ## 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `crfr` | `datetime` | Crediteren vanaf | | | | `crsi` | `char` | Verkoop crediteren | | | | `daen` | `datetime` | Einddatum | | | | `dapu` | `datetime` | Aanschafdatum | | | | `dast` | `datetime` | Begindatum | | | | `dcpr` | `number` | Kortingspercentage | | | | `dipr` | `number` | % Korting verkoop | | | | `disc` | `number` | Korting basisvaluta | | | | `id` | `int32` | Regelnummer | | | | `infr` | `datetime` | Factureren vanaf | | | | `ispc` | `char` | Korting op basis van % | | | | `isps` | `char` | Verkoopkorting op basis van % | | | | `itcd` | `varchar2(40)` | Itemcode | | | | `nfdi` | `varchar2(15)` | Korting vreemde valuta | | | | `nfpr` | `varchar2(15)` | Afwijkende prijs vreemde valuta | | | | `pric` | `number` | Afwijkende prijs basisvaluta | | | | `qu` | `number` | Aantal | | | | `sadi` | `number` | Kortingsbedrag verkoop basisvaluta | | | | `sapr` | `number` | Afw. verkoopprijs basisvaluta | | | | `sfdi` | `varchar2(15)` | Kortingsbedrag verkoop vreemde valuta | | | | `sfpr` | `varchar2(15)` | Afw. verkoop prijs vreemde valuta | | | | `sucr` | `char` | Abonnement crediteren | | | | `u900377e747f3e088a7452c99a82a5427` | `varchar2` | Opmerking | | | | `v1cd` | `varchar2(16)` | Code verbijzonderingsas 1 | | | | `v2cd` | `varchar2(16)` | Code verbijzonderingsas 2 | | | | `v3cd` | `varchar2(16)` | Code verbijzonderingsas 3 | | | | `v4cd` | `varchar2(16)` | Code verbijzonderingsas 4 | | | | `v5cd` | `varchar2(16)` | Code verbijzonderingsas 5 | | | | `vait` | `varchar2(10)` | Type item | | | | `vars` | `varchar2(20)` | Reden beëindiging | | |