# fbsubscription Abonnement - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## 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 | Documentation | |---|:---:|---|:---:|---| | `altsre` | `char` | Factuur naar afwijkende verkooprelatie | | | | `atin` | `char` | Incasseren | | | | `auin` | `char` | Automatisch factureren | | | | `bankaccount` | `varchar2(40)` | Banknummer afwijkend | | | | `bcid` | `varchar2(15)` | Organisatie/persoon | | | | `cti1` | `int32` | Afwijkende contactpersoon | | | | `ctpe` | `int32` | Contactpersoon | | | | `cuid` | `varchar2(3)` | Valuta | | | | `daam` | `int32` | Aantal dagen vooraf | | | | `dare` | `datetime` | Datum verlenging | | | | `dast` | `datetime` | Begindatum factuurcyclus | | | | `dbid` | `varchar2(16)` | Verkooprelatie | | | | `inad` | `char` | Voorschotfactuur | | | | `indi` | `char` | Verkoop direct factureren | | | | `inva` | `char` | Prijzen inclusief btw | | | | `lafr` | `datetime` | Verlaging toegestaan vanaf | | | | `lina` | `varchar2(50)` | Naam licentie | | | | `noct` | `char` | Uitsluiten van verzamelfactuur | | | | `noin` | `char` | Niet factureren | | | | `nosi` | `char` | Verkoop niet factureren | | | | `pacd` | `varchar2(5)` | Betaalvoorwaarde | | | | `prid` | `varchar2(15)` | Project | | | | `prst` | `varchar2(15)` | Projectfase | | | | `rate` | `number` | Valutakoers | | | | `rfcs` | `varchar2(100)` | Opdrachtnummer/referentie | | | | `suen` | `datetime` | Einddatum abonnement | | | | `sunr` | `int32` | Nummer abonnement | | | | `sust` | `datetime` | Begindatum abonnement | | | | `u137e13404fec8c95375ad79c52a0ab69` | `varchar2` | Opmerking abonnement | | | | `unfi` | `int32` | Administratie | | | | `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 | | | | `vadu` | `varchar2(3)` | Btw-plicht | | | | `vain` | `varchar2(20)` | Cyclus facturering | | | | `vals` | `varchar2(20)` | Type licentie | | | | `vapc` | `varchar2(20)` | Programmatuurcode | | | | `vare` | `varchar2(20)` | Cyclusverlenging | | | | `vars` | `varchar2(20)` | Reden beëindiging | | | | `vasu` | `varchar2(20)` | Type abonnement | | | | `vave` | `varchar2(20)` | Versie | | |