# fiinvoice Financiële factuur - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## 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 | Documentation | |---|:---:|---|:---:|---| | `accr` | `number` | Kredietbeperking (valuta) | | | | `acpa` | `number` | Betalingskorting (valuta) | | | | `amcr` | `number` | Kredietbeperking | | | | `amfo` | `number` | Bedrag FOD | | | | `ampa` | `number` | Betalingskorting | | | | `amrs` | `number` | Bedrag RSZ/RSVZ | | | | `aupa` | `char` | Automatisch betalen/incasso | | | | `bankaccount` | `varchar2(40)` | Afwijkende betaalrekeningnr. | | | | `blpa` | `char` | Geblokkeerd voor betaling/incasso | | | | `dacl` | `int32` | Dagen kredietbeperking | | | | `dadp` | `int32` | Dagen betalingskorting | | | | `dcnr` | `varchar2(16)` | Subnummer | | | | `ddid` | `varchar2(35)` | Kenmerk machtiging | | | | `dedu` | `varchar2(20)` | Inhoudingsplicht | | | | `ds` | `varchar2(255)` | Omschrijving factuur | | | | `dule` | `char` | Aanmanen | | | | `exda` | `datetime` | Vervaldatum | | | | `fref` | `varchar2(32)` | Factuurreferentie | | | | `inac` | `number` | Bedrag rente (valuta) | | | | `inam` | `number` | Bedrag rente | | | | `inid` | `varchar2(12)` | Factuurnummer | | | | `ldda` | `datetime` | Datum laatste aanmaning | | | | `nrdu` | `int32` | Aantal aanmaningen | | | | `paba` | `char` | Terugbetalen | | | | `pacd` | `varchar2(5)` | Betaalvoorwaarde | | | | `paid` | `varchar2(32)` | Betalingskenmerk | | | | `pars` | `varchar2(35)` | Kenmerk betaling RSZ/RSVZ | | | | `poco` | `varchar2(50)` | POP-code | | | | `unid` | `int32` | Administratie | | | | `vaad` | `varchar2(10)` | Type rekening | | | | `vapa` | `char` | Betalingskorting incl. btw | | |