# fientries_fientries Financiële mutatie: FiEntries - Catalog: `AfasOnline` - Schema: `UpdateConnector` - Retrieve: False - Insert: True - Update: False - Delete: False ## Table Columns The columns of the table `fientries_fientries` 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 | |---|:---:|---|:---:|---| | `acnr` | `varchar2(16)` | Rekeningnummer | | | | `acpa` | `number` | Betalingskorting in valuta | | | | `amcc` | `number` | Valutabedrag credit | | | | `amcr` | `number` | Bedrag credit | | | | `amdc` | `number` | Valutabedrag debet | | | | `amde` | `number` | Bedrag debet | | | | `amdp` | `number` | Betalingskorting | | | | `amga` | `number` | Bedrag G-rekening | | | | `aupa` | `char` | Automatisch betalen/incasso | | | | `bankaccount` | `varchar2(40)` | Afwijkende betaalrekeningnr. | | | | `blpa` | `char` | Blokkeren voor betaling | | | | `bpda` | `datetime` | Boekstukdatum | | | | `bpnr` | `varchar2(32)` | Boekstuknummer | | | | `caid` | `int32` | Campagne | | | | `cmno` | `int32` | Nummer verplichting | | | | `covc` | `varchar2(16)` | Btw-terugvordering | | | | `cuid` | `varchar2(3)` | Valuta | | | | `dacl` | `int32` | Dagen kredietbeperking | | | | `dadp` | `int32` | Dagen betalingskorting | | | | `daex` | `datetime` | Vervaldatum | | | | `ddid` | `varchar2(35)` | Afwijkend kenmerk machtiging | | | | `ds` | `varchar2(255)` | Omschrijving boeking | | | | `dsid` | `int32` | Afwijkende aanmaningsset | | | | `enda` | `datetime` | Datum boeking | | | | `enno` | `int32` | Nummer journaalpost | | | | `fref` | `varchar2(32)` | Factuurreferentie | | | | `ib47` | `char` | UBD - Uitbetaalde Bedragen aan Derden | | | | `idba` | `int32` | Afwijkende betaalrekening | | | | `ini2` | `varchar2(12)` | Factuurnr. (intern) | | | | `inid` | `varchar2(12)` | Factuurnummer | | | | `judg` | `varchar2(15)` | Beoordelaar | | | | `mref` | `varchar2(32)` | Afletterreferentie | | | | `ornu` | `varchar2(12)` | Verkoopordernummer | | | | `paba` | `char` | Terugbetalen | | | | `pacd` | `varchar2(5)` | Betaalvoorwaarde | | | | `paid` | `varchar2(32)` | Betalingskenmerk | | | | `poco` | `varchar2(50)` | POP-code | | | | `prid` | `varchar2(15)` | Project | | | | `rate` | `number` | Koers | | | | `rsno` | `int32` | Nummer reservering | | | | `vaas` | `varchar2(10)` | Kenmerk rekening | | | | `vaid` | `varchar2(3)` | Btw-code | | | | `vapa` | `char` | Betalingskorting incl. btw | | |