---
title: "FixedAssets (Twinfield)"
description: "Fixed Assets"
language: nl
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/nl/datamodels/twinfield/Twinfield.Twinfield.FixedAssets
original: https://documentation.invantive.eu/en/datamodels/twinfield/Twinfield.Twinfield.FixedAssets
updated: 2026-11-18T23:59:00Z
license: https://documentation.invantive.eu/nl/
---

# FixedAssets: Twinfield-vaste activa

`read only` `per partition` `XML`

- Catalogus: `Twinfield`
- Schema: `Twinfield`
- Label: Vaste activa

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom `COMPANY_CODE`.

Kan alleen gegevens ophalen.

## Samenvatting

De volgende filters, opgegeven met SQL-where-clausules, worden doorgestuurd naar Twinfield:
* FIN_TRS_HEAD_CODE (gelijk)
* FIN_TRS_HEAD_STATUS (gelijk)
* FIN_TRS_HEAD_YEAR (tussen)
* FIN_TRS_HEAD_YEARPERIOD (tussen)
* FIN_TRS_LINE_DIM3 (tussen)

## API-bron

- XML-service: `webservices/processxml.asmx`
- XML-onderwerp: `302_1`

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 54 |
| Aantal rijen per minuut bij volledige scan | 1,690 |
| Aantal rijen per minuut in een Query | 1,111 |
| Aantal rijen per minuut schrijven | 378 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Tabelkolommen

De kolommen van de tabel `FixedAssets` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CODE` | `varchar2` | Dagboekcode | [ ] | `code` | De code van het journaal waartoe deze transactie behoort, zoals MEMO of INK. |
| `COMPANY_CODE` | `varchar2` | Bedrijf ID | [x] |  |  |
| `COMPANY_NAME` | `varchar2` | Naam bedrijf | [x] |  |  |
| `FIN_BNK_BANKLINKSTATUS` | `varchar2` | Banklinkstatus | [ ] | `fin.bnk.banklinkstatus` | none, pending of active. |
| `FIN_BNK_DIM1` | `varchar2` | Dimensie 1 | [ ] | `fin.bnk.dim1` |  |
| `FIN_BNK_DIM1NAME` | `varchar2` | Dimensie 1 Naam | [ ] | `fin.bnk.dim1name` |  |
| `FIN_BNK_IBAN` | `varchar2` | IBAN | [ ] | `fin.bnk.iban` | De internationale identificatiecode van de bank. |
| `FIN_BNK_TRANSACTIONTYPE` | `varchar2` | Transactiesoort | [ ] | `fin.bnk.transactiontype` |  |
| `FIN_RMD_DETAIL_REMINDCOUNT` | `int64` | Reminders | [ ] | `fin.rmd.detail.remindcount` |  |
| `FIN_RMD_HEAD_CODE` | `varchar2` | Hoofdcode | [ ] | `fin.rmd.head.code` | Dagboekcode. |
| `FIN_RMD_HEAD_ID` | `int64` | Hoofd ID | [ ] | `fin.rmd.head.id` |  |
| `FIN_RMD_TOTAL_DIMENSION` | `varchar2` | Totale Dimensie | [ ] | `fin.rmd.total.dimension` |  |
| `FIN_RMD_TOTAL_DIMTYPE` | `varchar2` | Totaal Dimensiesoort | [ ] | `fin.rmd.total.dimtype` |  |
| `FIN_TRS_COSTCENTER` | `varchar2` | Kostenplaats | [ ] | `fin.trs.costcenter` |  |
| `FIN_TRS_COSTCENTERNAME` | `varchar2` | Kostenplaatsnaam | [ ] | `fin.trs.costcentername` |  |
| `FIN_TRS_HEAD_BALANCEREGIMEPROMPT` | `varchar2` | Balans Regime Prompt | [ ] | `fin.trs.head.balanceregimeprompt` | Waarden: Generic, Commercial, Economic of Fiscal. |
| `FIN_TRS_HEAD_BANKCODE` | `varchar2` | Bankcode | [ ] | `fin.trs.head.bankcode` | Waarden: BNK, KAS of SPAARR. |
| `FIN_TRS_HEAD_BANKTYPE` | `varchar2` | Banksoort | [ ] | `fin.trs.head.banktype` | Waarden: bank of kasboek. |
| `FIN_TRS_HEAD_BROWSEREGIME` | `varchar2` | Blad Regime | [ ] | `fin.trs.head.browseregime` | Waarden: Generic, Commercial, Economic of Fiscal. |
| `FIN_TRS_HEAD_CLOSEVALUE` | `decimal` | Sluitwaarde | [ ] | `fin.trs.head.closevalue` | Eindsaldo. |
| `FIN_TRS_HEAD_CODE` | `varchar2` | Code | [ ] | `fin.trs.head.code` |  |
| `FIN_TRS_HEAD_COUNT` | `int64` | Count | [ ] | `fin.trs.head.count` |  |
| `FIN_TRS_HEAD_CURCODE` | `varchar2` | Valuta Code | [ ] | `fin.trs.head.curcode` |  |
| `FIN_TRS_HEAD_CUSTOMER_CREDITLIMIT` | `decimal` | Klant Credit Limiet | [ ] | `fin.trs.head.customer.creditlimit` |  |
| `FIN_TRS_HEAD_CUSTOMER_RESPUSER` | `varchar2` | Klantverantwoordelijke Gebruiker | [ ] | `fin.trs.head.customer.respuser` |  |
| `FIN_TRS_HEAD_CUSTOMER_RESPUSERNAME` | `varchar2` | Klantverantwoordelijke Gebruikersnaam | [ ] | `fin.trs.head.customer.respusername` |  |
| `FIN_TRS_HEAD_DATE` | `datetime` | Date | [ ] | `fin.trs.head.date` | Transactiedatum. |
| `FIN_TRS_HEAD_INPDATE` | `datetime` | Invoerdatum | [ ] | `fin.trs.head.inpdate` |  |
| `FIN_TRS_HEAD_MODIFIED` | `datetime` | Modified | [ ] | `fin.trs.head.modified` | Datum/tijd waarop de transactie voor het laatst is gewijzigd. |
| `FIN_TRS_HEAD_NAME` | `varchar2` | Name | [ ] | `fin.trs.head.name` |  |
| `FIN_TRS_HEAD_NUMBER` | `decimal` | Number | [ ] | `fin.trs.head.number` | Transactienummer binnen het dagboek. |
| `FIN_TRS_HEAD_OFFICE` | `varchar2` | Administration | [ ] | `fin.trs.head.office` | Kantoorcode. |
| `FIN_TRS_HEAD_OFFICENAME` | `varchar2` | Administratie Naam | [ ] | `fin.trs.head.officename` | Kantoornaam. |
| `FIN_TRS_HEAD_ORIGIN` | `varchar2` | Origin | [ ] | `fin.trs.head.origin` | De oorsprong van de journaaltransactie. |
| `FIN_TRS_HEAD_PERIOD` | `int64` | Period | [ ] | `fin.trs.head.period` | Boekjaar en periode in JJJJ/PP-formaat. |
| `FIN_TRS_HEAD_REGIME` | `varchar2` | Regime | [ ] | `fin.trs.head.regime` | Type regime.Waarden: Generic, Commercial, Economic of Fiscal. |
| `FIN_TRS_HEAD_RELATION` | `varchar2` | Relation | [ ] | `fin.trs.head.relation` |  |
| `FIN_TRS_HEAD_RELATIONNAME` | `varchar2` | Relatienaam | [ ] | `fin.trs.head.relationname` |  |
| `FIN_TRS_HEAD_SHORTNAME` | `varchar2` | Korte Naam | [ ] | `fin.trs.head.shortname` |  |
| `FIN_TRS_HEAD_STARTVALUE` | `decimal` | Startwaarde | [ ] | `fin.trs.head.startvalue` | Beginsaldo. |
| `FIN_TRS_HEAD_STATUS` | `varchar2` | Status | [ ] | `fin.trs.head.status` | Waarden: draft, temporary, final, inuse of normal. |
| `FIN_TRS_HEAD_STMNUMBER` | `int64` | Afschriftnummer | [ ] | `fin.trs.head.stmnumber` | Afschriftnummer. |
| `FIN_TRS_HEAD_USER` | `varchar2` | User | [ ] | `fin.trs.head.user` | De gebruiker die de transactie heeft aangemaakt. |
| `FIN_TRS_HEAD_USERNAME` | `varchar2` | Gebruikersnaam | [ ] | `fin.trs.head.username` | Naam van de gebruiker. |
| `FIN_TRS_HEAD_YEAR` | `int64` | Year | [ ] | `fin.trs.head.year` |  |
| `FIN_TRS_HEAD_YEARPERIOD` | `varchar2` | Jaarperiode | [ ] | `fin.trs.head.yearperiod` |  |
| `FIN_TRS_LINE_ACTIONCODE` | `varchar2` | Actiecode | [ ] | `fin.trs.line.actioncode` |  |
| `FIN_TRS_LINE_ACTIONCREATED` | `datetime` | Aanmaakdatum Actie | [ ] | `fin.trs.line.actioncreated` |  |
| `FIN_TRS_LINE_ACTIONDATE` | `datetime` | Actie Datum | [ ] | `fin.trs.line.actiondate` |  |
| `FIN_TRS_LINE_ACTIONDESCRIPTION` | `varchar2` | Actieomschrijving | [ ] | `fin.trs.line.actiondescription` |  |
| `FIN_TRS_LINE_ACTIONNAME` | `varchar2` | Actienaam | [ ] | `fin.trs.line.actionname` |  |
| `FIN_TRS_LINE_ACTIONREMIND` | `varchar2` | Actie Herinneren? | [ ] | `fin.trs.line.actionremind` |  |
| `FIN_TRS_LINE_ACTIONUSER` | `varchar2` | Actiegebruiker | [ ] | `fin.trs.line.actionuser` |  |
| `FIN_TRS_LINE_ACTIONUSERNAME` | `varchar2` | Actie Gebruikersnaam | [ ] | `fin.trs.line.actionusername` |  |
| `FIN_TRS_LINE_ACTIONVALUE` | `decimal` | Actiewaarde | [ ] | `fin.trs.line.actionvalue` |  |
| `FIN_TRS_LINE_ASSET_BEGINPERIOD` | `int64` | Beginperiode Activum | [ ] | `fin.trs.line.asset.beginperiod` |  |
| `FIN_TRS_LINE_ASSET_BEGINYEAR` | `int64` | Beginjaar Activum | [ ] | `fin.trs.line.asset.beginyear` |  |
| `FIN_TRS_LINE_ASSET_DEPRECIATIONTERM` | `int64` | Activa Afschrijvingstermijn | [ ] | `fin.trs.line.asset.depreciationterm` |  |
| `FIN_TRS_LINE_AVAILABLEFORPAYRUNS` | `varchar2` | Beschikbaar voor Betalingsrun | [ ] | `fin.trs.line.availableforpayruns` |  |
| `FIN_TRS_LINE_BASEVALUE` | `decimal` | Basiswaarde | [ ] | `fin.trs.line.basevalue` | Bedrag in de basisvaluta. |
| `FIN_TRS_LINE_BASEVALUEABS` | `decimal` | Basiswaarde (absoluut) | [ ] | `fin.trs.line.basevalueabs` |  |
| `FIN_TRS_LINE_BASEVALUESIGNED` | `decimal` | Basiswaarde (met teken) | [ ] | `fin.trs.line.basevaluesigned` |  |
| `FIN_TRS_LINE_CHEQUENUMBER` | `varchar2` | Chequenummer | [ ] | `fin.trs.line.chequenumber` |  |
| `FIN_TRS_LINE_COUNT` | `int64` | itgen_twinfield_fin_trs_line_count | [ ] | `fin.trs.line.count` |  |
| `FIN_TRS_LINE_CURRENCYDATE` | `datetime` | Valutadatum | [ ] | `fin.trs.line.currencydate` | Alleen als regeltype detail is.De regeldatum.Alleen toegestaan als de regeldatum in het journaalboek op Toegestaan of Verplicht is ingesteld. |
| `FIN_TRS_LINE_DATEDUE` | `datetime` | Vervaldag | [ ] | `fin.trs.line.datedue` |  |
| `FIN_TRS_LINE_DEBITCREDIT` | `varchar2` | Debit/Credit | [ ] | `fin.trs.line.debitcredit` | Of de regel debet of credit is.Waarden: credit of debet. |
| `FIN_TRS_LINE_DESCRIPTION` | `varchar2` | Description | [ ] | `fin.trs.line.description` | Tekstuele omschrijving van de regel. |
| `FIN_TRS_LINE_DESTINATION_DIM1` | `varchar2` | Doeldimensie 1 | [ ] | `fin.trs.line.destination.dim1` | Als regeltype = detail de journaalbalans- of winst-en-verliesrekening.Als regeltype = btw de btw-balansrekening.Wanneer een lege dim1 wordt ingevoerd, wordt standaard de grootboekrekening gebruikt zoals ingevoerd bij de btw-code in Twinfield. |
| `FIN_TRS_LINE_DESTINATION_DIM1NAME` | `varchar2` | Doeldimensie 1 Naam | [ ] | `fin.trs.line.destination.dim1name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM2` | `varchar2` | Doeldimensie 2 | [ ] | `fin.trs.line.destination.dim2` | Als regeltype = detail, de klant of leverancier, of de kostenplaats, of leeg.Anders null. |
| `FIN_TRS_LINE_DESTINATION_DIM2NAME` | `varchar2` | Doeldimensie 2 Naam | [ ] | `fin.trs.line.destination.dim2name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM3` | `varchar2` | Doeldimensie 3 | [ ] | `fin.trs.line.destination.dim3` | Als regeltype = detail het project of de activa of leeg.Als regeltype = btw leeg. |
| `FIN_TRS_LINE_DESTINATION_DIM3NAME` | `varchar2` | Doeldimensie 3 Naam | [ ] | `fin.trs.line.destination.dim3name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM4` | `varchar2` | Doeldimensie 4 | [ ] | `fin.trs.line.destination.dim4` |  |
| `FIN_TRS_LINE_DESTINATION_DIM4NAME` | `varchar2` | Doeldimensie 4 Naam | [ ] | `fin.trs.line.destination.dim4name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM5` | `varchar2` | Doeldimensie 5 | [ ] | `fin.trs.line.destination.dim5` |  |
| `FIN_TRS_LINE_DESTINATION_DIM5NAME` | `varchar2` | Doeldimensie 5 Naam | [ ] | `fin.trs.line.destination.dim5name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM6` | `varchar2` | Doeldimensie 6 | [ ] | `fin.trs.line.destination.dim6` |  |
| `FIN_TRS_LINE_DESTINATION_DIM6NAME` | `varchar2` | Doeldimensie 6 Naam | [ ] | `fin.trs.line.destination.dim6name` |  |
| `FIN_TRS_LINE_DESTINATION_OFFICE` | `varchar2` | Doeladministratie | [ ] | `fin.trs.line.destination.office` |  |
| `FIN_TRS_LINE_DESTINATION_OFFICENAME` | `varchar2` | Doeladministratienaam | [ ] | `fin.trs.line.destination.officename` |  |
| `FIN_TRS_LINE_DIM1` | `varchar2` | Dimensie 1 | [ ] | `fin.trs.line.dim1` |  |
| `FIN_TRS_LINE_DIM1GROUP` | `varchar2` | Dimensie 1 Groep | [ ] | `fin.trs.line.dim1group` |  |
| `FIN_TRS_LINE_DIM1GROUP1` | `varchar2` | Dimensie 1 Groep 1 | [ ] | `fin.trs.line.dim1group1` |  |
| `FIN_TRS_LINE_DIM1GROUP1NAME` | `varchar2` | Dimensie 1 Groep 1 Naam | [ ] | `fin.trs.line.dim1group1name` |  |
| `FIN_TRS_LINE_DIM1GROUP2` | `varchar2` | Dimensie 1 Groep 2 | [ ] | `fin.trs.line.dim1group2` |  |
| `FIN_TRS_LINE_DIM1GROUP2NAME` | `varchar2` | Dimensie 1 Groep 2 Naam | [ ] | `fin.trs.line.dim1group2name` |  |
| `FIN_TRS_LINE_DIM1GROUP3` | `varchar2` | Dimensie 1 Groep 3 | [ ] | `fin.trs.line.dim1group3` |  |
| `FIN_TRS_LINE_DIM1GROUP3NAME` | `varchar2` | Dimensie 1 Groep 3 Naam | [ ] | `fin.trs.line.dim1group3name` |  |
| `FIN_TRS_LINE_DIM1GROUP4` | `varchar2` | Groep 4 | [ ] | `fin.trs.line.dim1group4` |  |
| `FIN_TRS_LINE_DIM1GROUP4NAME` | `varchar2` | Groepsnaam 4 | [ ] | `fin.trs.line.dim1group4name` |  |
| `FIN_TRS_LINE_DIM1GROUP5` | `varchar2` | Groep 5 | [ ] | `fin.trs.line.dim1group5` |  |
| `FIN_TRS_LINE_DIM1GROUP5NAME` | `varchar2` | Groepsnaam 5 | [ ] | `fin.trs.line.dim1group5name` |  |
| `FIN_TRS_LINE_DIM1NAME` | `varchar2` | Dimensie 1 Naam | [ ] | `fin.trs.line.dim1name` |  |
| `FIN_TRS_LINE_DIM1PAYAVAILABLE` | `varchar2` | Dimensie 1 Betalen Beschikbaar | [ ] | `fin.trs.line.dim1payavailable` |  |
| `FIN_TRS_LINE_DIM1PAYCODE` | `varchar2` | Dimensie 1 Betaalcode | [ ] | `fin.trs.line.dim1paycode` |  |
| `FIN_TRS_LINE_DIM1REMINDERS` | `varchar2` | Dimensie 1 Herinneringen | [ ] | `fin.trs.line.dim1reminders` | Waarden: false, true, e-mail. |
| `FIN_TRS_LINE_DIM1TYPE` | `varchar2` | Dimensie 1 Soort | [ ] | `fin.trs.line.dim1type` |  |
| `FIN_TRS_LINE_DIM2` | `varchar2` | Dimensie 2 | [ ] | `fin.trs.line.dim2` |  |
| `FIN_TRS_LINE_DIM2GROUP` | `varchar2` | Dimensie 2 Groep | [ ] | `fin.trs.line.dim2group` |  |
| `FIN_TRS_LINE_DIM2NAME` | `varchar2` | Dimensie 2 Naam | [ ] | `fin.trs.line.dim2name` |  |
| `FIN_TRS_LINE_DIM2PAYAVAILABLE` | `varchar2` | Dimensie 2 Betalen Beschikbaar | [ ] | `fin.trs.line.dim2payavailable` |  |
| `FIN_TRS_LINE_DIM2PAYCODE` | `varchar2` | Dimensie 2 Betaalcode | [ ] | `fin.trs.line.dim2paycode` |  |
| `FIN_TRS_LINE_DIM2REMINDERS` | `varchar2` | Dimensie 2 Herinneringen | [ ] | `fin.trs.line.dim2reminders` | Waarden: false, true, e-mail. |
| `FIN_TRS_LINE_DIM2TYPE` | `varchar2` | Dimensie 2 Soort | [ ] | `fin.trs.line.dim2type` |  |
| `FIN_TRS_LINE_DIM3` | `varchar2` | Dimensie 3 | [ ] | `fin.trs.line.dim3` |  |
| `FIN_TRS_LINE_DIM3GROUP` | `varchar2` | Dimensie 3 Groep | [ ] | `fin.trs.line.dim3group` |  |
| `FIN_TRS_LINE_DIM3NAME` | `varchar2` | Dimensie 3 Naam | [ ] | `fin.trs.line.dim3name` |  |
| `FIN_TRS_LINE_DIM3PAYAVAILABLE` | `varchar2` | Dimensie 3 Betalen Beschikbaar | [ ] | `fin.trs.line.dim3payavailable` |  |
| `FIN_TRS_LINE_DIM3PAYCODE` | `varchar2` | Dimensie 3 Betaalcode | [ ] | `fin.trs.line.dim3paycode` |  |
| `FIN_TRS_LINE_DIM3REMINDERS` | `varchar2` | Dimensie 3 Herinneringen | [ ] | `fin.trs.line.dim3reminders` | Waarden: false, true, e-mail. |
| `FIN_TRS_LINE_DIM3TYPE` | `varchar2` | Dimensie 3 Soort | [ ] | `fin.trs.line.dim3type` |  |
| `FIN_TRS_LINE_DIM4` | `varchar2` | Dimensie 4 | [ ] | `fin.trs.line.dim4` |  |
| `FIN_TRS_LINE_DIM4GROUP` | `varchar2` | Dimensie 4 Groep | [ ] | `fin.trs.line.dim4group` |  |
| `FIN_TRS_LINE_DIM4NAME` | `varchar2` | Dimensie 4 Naam | [ ] | `fin.trs.line.dim4name` |  |
| `FIN_TRS_LINE_DIM4PAYAVAILABLE` | `varchar2` | Dimensie 4 Betalen Beschikbaar | [ ] | `fin.trs.line.dim4payavailable` |  |
| `FIN_TRS_LINE_DIM4PAYCODE` | `varchar2` | Dimensie 4 Betaalcode | [ ] | `fin.trs.line.dim4paycode` |  |
| `FIN_TRS_LINE_DIM4REMINDERS` | `varchar2` | Dimensie 4 Herinneringen | [ ] | `fin.trs.line.dim4reminders` | Waarden: false, true, e-mail. |
| `FIN_TRS_LINE_DIM4TYPE` | `varchar2` | Dimensie 4 Soort | [ ] | `fin.trs.line.dim4type` |  |
| `FIN_TRS_LINE_DIM5` | `varchar2` | Dimensie 5 | [ ] | `fin.trs.line.dim5` |  |
| `FIN_TRS_LINE_DIM5GROUP` | `varchar2` | Dimensie 5 Groep | [ ] | `fin.trs.line.dim5group` |  |
| `FIN_TRS_LINE_DIM5NAME` | `varchar2` | Dimensie 5 Naam | [ ] | `fin.trs.line.dim5name` |  |
| `FIN_TRS_LINE_DIM5PAYAVAILABLE` | `varchar2` | Dimensie 5 Betalen Beschikbaar | [ ] | `fin.trs.line.dim5payavailable` |  |
| `FIN_TRS_LINE_DIM5PAYCODE` | `varchar2` | Dimensie 5 Betaalcode | [ ] | `fin.trs.line.dim5paycode` |  |
| `FIN_TRS_LINE_DIM5REMINDERS` | `varchar2` | Dimensie 5 Herinneringen | [ ] | `fin.trs.line.dim5reminders` | Waarden: false, true, e-mail. |
| `FIN_TRS_LINE_DIM5TYPE` | `varchar2` | Dimensie 5 Soort | [ ] | `fin.trs.line.dim5type` |  |
| `FIN_TRS_LINE_DIM6` | `varchar2` | Dimensie 6 | [ ] | `fin.trs.line.dim6` |  |
| `FIN_TRS_LINE_DIM6GROUP` | `varchar2` | Dimensie 6 Groep | [ ] | `fin.trs.line.dim6group` |  |
| `FIN_TRS_LINE_DIM6NAME` | `varchar2` | Dimensie 6 Naam | [ ] | `fin.trs.line.dim6name` |  |
| `FIN_TRS_LINE_DIM6PAYAVAILABLE` | `varchar2` | Dimensie 6 Betalen Beschikbaar | [ ] | `fin.trs.line.dim6payavailable` |  |
| `FIN_TRS_LINE_DIM6PAYCODE` | `varchar2` | Dimensie 6 Betaalcode | [ ] | `fin.trs.line.dim6paycode` |  |
| `FIN_TRS_LINE_DIM6REMINDERS` | `varchar2` | Dimensie 6 Herinneringen | [ ] | `fin.trs.line.dim6reminders` | Waarden: false, true, e-mail. |
| `FIN_TRS_LINE_DIM6TYPE` | `varchar2` | Dimensie 6 Soort | [ ] | `fin.trs.line.dim6type` |  |
| `FIN_TRS_LINE_FREETEXT1` | `varchar2` | Vrije Tekst 1 | [ ] | `fin.trs.line.freetext1` | Vrij tekstveld 1 zoals ingevoerd bij het transactietype. |
| `FIN_TRS_LINE_FREETEXT2` | `varchar2` | Vrije Tekst 2 | [ ] | `fin.trs.line.freetext2` | Vrij tekstveld 2 zoals ingevoerd bij het transactietype. |
| `FIN_TRS_LINE_FREETEXT3` | `varchar2` | Vrije Tekst 3 | [ ] | `fin.trs.line.freetext3` | Vrij tekstveld 3 zoals ingevoerd bij het transactietype. |
| `FIN_TRS_LINE_ID` | `int64` | ID | [ ] | `fin.trs.line.id` | Regel-ID. |
| `FIN_TRS_LINE_INVNUMBER` | `varchar2` | Factuurnummer | [ ] | `fin.trs.line.invnumber` | Factuurnummer (voor inkoop- en verkoopfacturen). |
| `FIN_TRS_LINE_INVOICEBATCHID` | `int64` | Factuurbatch ID | [ ] | `fin.trs.line.invoicebatchid` |  |
| `FIN_TRS_LINE_MATCHDATE` | `datetime` | Afletterdatum | [ ] | `fin.trs.line.matchdate` |  |
| `FIN_TRS_LINE_MATCHNUMBER` | `varchar2` | Afletternummer | [ ] | `fin.trs.line.matchnumber` |  |
| `FIN_TRS_LINE_MATCHSTATUS` | `varchar2` | Afletterstatus | [ ] | `fin.trs.line.matchstatus` | Betalingsstatus van de transactie; niet koppelbaar, beschikbaar, gekoppeld of voorgesteld. |
| `FIN_TRS_LINE_MODIFIED` | `datetime` | Modified | [ ] | `fin.trs.line.modified` |  |
| `FIN_TRS_LINE_OPENBASEVALUE` | `decimal` | Openingswaarde (basis) | [ ] | `fin.trs.line.openbasevalue` |  |
| `FIN_TRS_LINE_OPENBASEVALUEABS` | `decimal` | Openingswaarde (basis, absoluut) | [ ] | `fin.trs.line.openbasevalueabs` |  |
| `FIN_TRS_LINE_OPENBASEVALUESIGNED` | `decimal` | Open Bedrag | [ ] | `fin.trs.line.openbasevaluesigned` |  |
| `FIN_TRS_LINE_OPENREPVALUE` | `decimal` | Openingswaarde (rapportage) | [ ] | `fin.trs.line.openrepvalue` |  |
| `FIN_TRS_LINE_OPENREPVALUEABS` | `decimal` | Openingswaarde (rapportage, absoluut) | [ ] | `fin.trs.line.openrepvalueabs` |  |
| `FIN_TRS_LINE_OPENREPVALUESIGNED` | `decimal` | Openingswaarde (rapportage, met teken) | [ ] | `fin.trs.line.openrepvaluesigned` |  |
| `FIN_TRS_LINE_OPENVALUE` | `decimal` | Openingswaarde | [ ] | `fin.trs.line.openvalue` |  |
| `FIN_TRS_LINE_OPENVALUEABS` | `decimal` | Openingswaarde (absoluut) | [ ] | `fin.trs.line.openvalueabs` |  |
| `FIN_TRS_LINE_OPENVALUESIGNED` | `decimal` | Openingswaarde (met teken) | [ ] | `fin.trs.line.openvaluesigned` |  |
| `FIN_TRS_LINE_PAYRUN` | `varchar2` | Payrun | [ ] | `fin.trs.line.payrun` |  |
| `FIN_TRS_LINE_QUANTITY` | `decimal` | Quantity | [ ] | `fin.trs.line.quantity` |  |
| `FIN_TRS_LINE_RELATION` | `int64` | Relation | [ ] | `fin.trs.line.relation` |  |
| `FIN_TRS_LINE_REPVALUE` | `decimal` | Waarde (rapportage) | [ ] | `fin.trs.line.repvalue` | Bedrag in de rapportagevaluta. |
| `FIN_TRS_LINE_REPVALUEABS` | `decimal` | Waarde (rapportage, absoluut) | [ ] | `fin.trs.line.repvalueabs` |  |
| `FIN_TRS_LINE_REPVALUESIGNED` | `decimal` | Waarde (rapportage, met teken) | [ ] | `fin.trs.line.repvaluesigned` |  |
| `FIN_TRS_LINE_VALUE` | `decimal` | Value | [ ] | `fin.trs.line.value` | Als regeltype = detail, bedrag zonder btw.Als regeltype = btw het btw-bedrag. |
| `FIN_TRS_LINE_VALUEABS` | `decimal` | Waarde (absoluut) | [ ] | `fin.trs.line.valueabs` |  |
| `FIN_TRS_LINE_VALUESIGNED` | `decimal` | Waarde (met teken) | [ ] | `fin.trs.line.valuesigned` |  |
| `FIN_TRS_LINE_VATBASEVALUESIGNED` | `decimal` | BTW-waarde (basis, met teken) | [ ] | `fin.trs.line.vatbasevaluesigned` |  |
| `FIN_TRS_LINE_VATCODE` | `varchar2` | BTW-code | [ ] | `fin.trs.line.vatcode` | Btw-code van de transactieregel. |
| `FIN_TRS_MNG_TYPE` | `varchar2` | Transactiesoortgroep | [ ] | `fin.trs.mng.type` |  |
| `FIN_VAT_DECLTYPE` | `varchar2` | Aangiftesoort | [ ] | `fin.vat.decltype` | Waarden: ict, vat, taxgroup, yearlysuppletion of taxgroupyearlysuppletion. |
| `FIN_VAT_DECLYEAR` | `int64` | Declaratie Jaar | [ ] | `fin.vat.declyear` |  |
| `FIN_VAT_GATEWAY` | `varchar2` | Gateway | [ ] | `fin.vat.gateway` |  |
| `FIN_VAT_SENT` | `datetime` | Sent | [ ] | `fin.vat.sent` |  |
| `FIN_VAT_STATUS` | `int64` | Status | [ ] | `fin.vat.status` |  |
| `FIN_VAT_STATUSNAME` | `varchar2` | Statusnaam | [ ] | `fin.vat.statusname` | Waarden: aangemaakt, geautoriseerd, gewijzigd, verzonden, goedgekeurd, verzendtimeout of afgewezen. |
| `FIN_VAT_TIMEFRAME` | `varchar2` | Timeframe | [ ] | `fin.vat.timeframe` | year, halfyear1, halfyear7, fourmonth1, fourmonth5, fourmonth9, quarter1..quarter12, bimonth1, bimonth3, bimonth5, bimonth7, bimonth9, bimonth11 of month1..month12. |
| `HIE_XSS_HIERARCHY` | `varchar2` | Hierarchy | [ ] | `hie.xss.hierarchy` |  |
| `HIE_XSS_HIERARCHYHIDDEN` | `varchar2` | Hiërarchie Verborgen | [ ] | `hie.xss.hierarchyhidden` |  |
| `HIE_XSS_HIERARCHYNAME` | `varchar2` | Hiërarchienaam | [ ] | `hie.xss.hierarchyname` |  |
| `HIE_XSS_ROLE` | `varchar2` | Role | [ ] | `hie.xss.role` |  |
| `HIE_XSS_ROLENAME` | `varchar2` | Rolnaam | [ ] | `hie.xss.rolename` |  |
| `HIE_XSS_TYPE` | `varchar2` | Type | [ ] | `hie.xss.type` | Waarden: none, use, link of edit. |
| `HIE_XSS_USER` | `varchar2` | User | [ ] | `hie.xss.user` | De gebruikerscode waarmee de transactie is geboekt. |
| `HIE_XSS_USERNAME` | `varchar2` | Gebruikersnaam | [ ] | `hie.xss.username` |  |
| `INV_TRS_HEAD_NUMBER` | `int64` | Number | [ ] | `inv.trs.head.number` |  |
| `IVB_TRS_HEAD_DESCRIPTION` | `varchar2` | Description | [ ] | `ivb.trs.head.description` |  |
| `IVB_TRS_HEAD_NUMBER` | `int64` | Schemanummer | [ ] | `ivb.trs.head.number` |  |
| `IVB_TRS_LINE_QUANTITY` | `decimal` | Quantity | [ ] | `ivb.trs.line.quantity` |  |
| `IVB_TRS_LINE_SOURCE` | `varchar2` | Source | [ ] | `ivb.trs.line.source` | Waarden: marge, financieel, tijd, kosten, hoeveelheden of uitgesteld. |
| `IVB_TRS_LINE_VALUE` | `decimal` | Value | [ ] | `ivb.trs.line.value` |  |
| `LINE` | `varchar2` | Regelnummer | [ ] | `line` | Nummer van de transactieregel binnen de transactie. |
| `NUMBER` | `varchar2` | Transactienummer | [ ] | `number` | Het unieke nummer van de transactie binnen het dagboek. |
| `OFFICE` | `varchar2` | Kantoornummer | [ ] | `office` | Het Twinfield-kantoornummer.Per definitie gelijk aan COMPANY_CODE. |
| `TEQ_TRS_HEAD_AUTHORISER` | `varchar2` | Authorizer | [ ] | `teq.trs.head.authoriser` |  |
| `TEQ_TRS_HEAD_AUTHORISERNAME` | `varchar2` | Autorisatiegevernaam | [ ] | `teq.trs.head.authorisername` |  |
| `TEQ_TRS_HEAD_CODE` | `varchar2` | Code | [ ] | `teq.trs.head.code` | Transactietypecode. |
| `TEQ_TRS_HEAD_CURCODE` | `varchar2` | Valuta Code | [ ] | `teq.trs.head.curcode` | Valuta die voor de transactie wordt gebruikt. |
| `TEQ_TRS_HEAD_CUSTOMER` | `varchar2` | Customer | [ ] | `teq.trs.head.customer` |  |
| `TEQ_TRS_HEAD_CUSTOMERNAME` | `varchar2` | Naam Klant | [ ] | `teq.trs.head.customername` |  |
| `TEQ_TRS_HEAD_DATE` | `datetime` | Date | [ ] | `teq.trs.head.date` | Transactiedatum. |
| `TEQ_TRS_HEAD_DIMENSION` | `varchar2` | Dimension | [ ] | `teq.trs.head.dimension` |  |
| `TEQ_TRS_HEAD_PERIOD` | `int64` | Period | [ ] | `teq.trs.head.period` |  |
| `TEQ_TRS_HEAD_PROJECT1` | `varchar2` | Project 1 | [ ] | `teq.trs.head.project1` |  |
| `TEQ_TRS_HEAD_PROJECT1COSTCENTRE` | `varchar2` | Project 1 Kostenplaats | [ ] | `teq.trs.head.project1costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT1COSTCENTRENAME` | `varchar2` | Project 1 Kostenplaatsnaam | [ ] | `teq.trs.head.project1costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT1NAME` | `varchar2` | Project 1 Naam | [ ] | `teq.trs.head.project1name` |  |
| `TEQ_TRS_HEAD_PROJECT2` | `varchar2` | Project 2 | [ ] | `teq.trs.head.project2` |  |
| `TEQ_TRS_HEAD_PROJECT2COSTCENTRE` | `varchar2` | Project 2 Kostenplaats | [ ] | `teq.trs.head.project2costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT2COSTCENTRENAME` | `varchar2` | Project 2 Kostenplaatsnaam | [ ] | `teq.trs.head.project2costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT2NAME` | `varchar2` | Project 2 Naam | [ ] | `teq.trs.head.project2name` |  |
| `TEQ_TRS_HEAD_PROJECT3` | `varchar2` | Project 3 | [ ] | `teq.trs.head.project3` |  |
| `TEQ_TRS_HEAD_PROJECT3COSTCENTRE` | `varchar2` | Project 3 Kostenplaats | [ ] | `teq.trs.head.project3costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT3COSTCENTRENAME` | `varchar2` | Project 3 Kostenplaatsnaam | [ ] | `teq.trs.head.project3costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT3NAME` | `varchar2` | Project 3 Naam | [ ] | `teq.trs.head.project3name` |  |
| `TEQ_TRS_HEAD_PROJECT4` | `varchar2` | Project 4 | [ ] | `teq.trs.head.project4` |  |
| `TEQ_TRS_HEAD_PROJECT4COSTCENTRE` | `varchar2` | Project 4 Kostenplaats | [ ] | `teq.trs.head.project4costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT4COSTCENTRENAME` | `varchar2` | Project 4 Kostenplaatsnaam | [ ] | `teq.trs.head.project4costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT4NAME` | `varchar2` | Project 4 Naam | [ ] | `teq.trs.head.project4name` |  |
| `TEQ_TRS_HEAD_PROJECT5` | `varchar2` | Project 5 | [ ] | `teq.trs.head.project5` |  |
| `TEQ_TRS_HEAD_PROJECT5COSTCENTRE` | `varchar2` | Project 5 Kostenplaats | [ ] | `teq.trs.head.project5costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT5COSTCENTRENAME` | `varchar2` | Project 5 Kostenplaatsnaam | [ ] | `teq.trs.head.project5costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT5NAME` | `varchar2` | Project 5 Naam | [ ] | `teq.trs.head.project5name` |  |
| `TEQ_TRS_HEAD_PROJECT6` | `varchar2` | Project 6 | [ ] | `teq.trs.head.project6` |  |
| `TEQ_TRS_HEAD_PROJECT6COSTCENTRE` | `varchar2` | Project 6 Kostenplaats | [ ] | `teq.trs.head.project6costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT6COSTCENTRENAME` | `varchar2` | Project 6 Kostenplaatsnaam | [ ] | `teq.trs.head.project6costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT6NAME` | `varchar2` | Project 6 Naam | [ ] | `teq.trs.head.project6name` |  |
| `TEQ_TRS_HEAD_STATUS` | `varchar2` | Status | [ ] | `teq.trs.head.status` | Waarden: ingevoerd, voorgesteld, geautoriseerd, afgewezen, in gebruik, gejournaliseerd. |
| `TEQ_TRS_HEAD_TOKEN` | `varchar2` | Token | [ ] | `teq.trs.head.token` |  |
| `TEQ_TRS_HEAD_USER` | `varchar2` | User | [ ] | `teq.trs.head.user` | De gebruikerscode waarmee de transactie is geboekt. |
| `TEQ_TRS_HEAD_USERCOSTCENTRE` | `varchar2` | Gebruikerskostenplaats | [ ] | `teq.trs.head.usercostcentre` |  |
| `TEQ_TRS_HEAD_USERCOSTCENTRENAME` | `varchar2` | Gebruiker Kostenplaatsnaam | [ ] | `teq.trs.head.usercostcentrename` |  |
| `TEQ_TRS_HEAD_USERNAME` | `varchar2` | Gebruikersnaam | [ ] | `teq.trs.head.username` |  |
| `TEQ_TRS_HEAD_WEEK` | `int64` | Week | [ ] | `teq.trs.head.week` |  |
| `TEQ_TRS_HEAD_YEAR` | `int64` | Year | [ ] | `teq.trs.head.year` |  |
| `TEQ_TRS_HEAD_YEARMONTH` | `varchar2` | Jaarmaand | [ ] | `teq.trs.head.yearmonth` |  |
| `TEQ_TRS_HEAD_YEARPERIOD` | `varchar2` | Jaarperiode | [ ] | `teq.trs.head.yearperiod` |  |
| `TEQ_TRS_HEAD_YEARWEEK` | `varchar2` | Jaarweek | [ ] | `teq.trs.head.yearweek` |  |
| `TEQ_TRS_LINE_BILLABLE` | `varchar2` | Billable | [ ] | `teq.trs.line.billable` |  |
| `TEQ_TRS_LINE_DESCRIPTION` | `varchar2` | Description | [ ] | `teq.trs.line.description` |  |
| `TEQ_TRS_LINE_EXPBILLABLE` | `varchar2` | Uitgave Factureerbaar | [ ] | `teq.trs.line.expbillable` |  |
| `TEQ_TRS_LINE_EXPENSE` | `decimal` | Expense | [ ] | `teq.trs.line.expense` |  |
| `TEQ_TRS_LINE_EXPENSE_NB` | `decimal` | Niet-Factureerbare Uitgaven | [ ] | `teq.trs.line.expense_nb` |  |
| `TEQ_TRS_LINE_INVOICEBATCHID` | `int64` | Factuurbatch ID | [ ] | `teq.trs.line.invoicebatchid` |  |
| `TEQ_TRS_LINE_QTYBILLABLE` | `varchar2` | Aantal Factureerbaar | [ ] | `teq.trs.line.qtybillable` |  |
| `TEQ_TRS_LINE_QTYVALUEEXT` | `decimal` | Aantal Waarde Extern | [ ] | `teq.trs.line.qtyvalueext` |  |
| `TEQ_TRS_LINE_QTYVALUEEXT_NB` | `decimal` | Niet-Factureerbare Externe Hoeveelheden | [ ] | `teq.trs.line.qtyvalueext_nb` |  |
| `TEQ_TRS_LINE_QTYVALUEINT` | `decimal` | Aantal Waarde Intern | [ ] | `teq.trs.line.qtyvalueint` |  |
| `TEQ_TRS_LINE_QTYVALUEINT_NB` | `decimal` | Niet-Factureerbare Interne Hoeveelheden | [ ] | `teq.trs.line.qtyvalueint_nb` |  |
| `TEQ_TRS_LINE_QUANTITY` | `decimal` | Quantity | [ ] | `teq.trs.line.quantity` |  |
| `TEQ_TRS_LINE_QUANTITY_NB` | `decimal` | Niet-factureerbare Hoeveelheden | [ ] | `teq.trs.line.quantity_nb` |  |
| `TEQ_TRS_LINE_RATE_CODE` | `varchar2` | Wisselkoerscode | [ ] | `teq.trs.line.rate.code` |  |
| `TEQ_TRS_LINE_RATE_NAME` | `varchar2` | Wisselkoersnaam | [ ] | `teq.trs.line.rate.name` |  |
| `TEQ_TRS_LINE_TIME` | `decimal` | Time | [ ] | `teq.trs.line.time` |  |
| `TEQ_TRS_LINE_TIMEBILLABLE` | `varchar2` | Tijd Factureerbaar | [ ] | `teq.trs.line.timebillable` |  |
| `TEQ_TRS_LINE_TIMEVALUEEXT` | `decimal` | Externe Waarde Tijd | [ ] | `teq.trs.line.timevalueext` |  |
| `TEQ_TRS_LINE_TIMEVALUEEXT_NB` | `decimal` | Niet-facturabele Externe Uren | [ ] | `teq.trs.line.timevalueext_nb` |  |
| `TEQ_TRS_LINE_TIMEVALUEINT` | `decimal` | Interne Waarde Tijd | [ ] | `teq.trs.line.timevalueint` |  |
| `TEQ_TRS_LINE_TIMEVALUEINT_NB` | `decimal` | Niet-facturabele Interne Uren | [ ] | `teq.trs.line.timevalueint_nb` |  |
| `TEQ_TRS_LINE_TIME_NB` | `decimal` | Niet-facturabele Uren | [ ] | `teq.trs.line.time_nb` |  |
| `TEQ_TRS_LINE_TOKEN` | `varchar2` | Token | [ ] | `teq.trs.line.token` |  |
| `TEQ_TRS_LINE_TYPE` | `varchar2` | Type | [ ] | `teq.trs.line.type` | Waarden: time, expense of quantity. |
| `TEQ_TRS_LINE_UNITS` | `int64` | Units | [ ] | `teq.trs.line.units` |  |
| `TEQ_TRS_LINE_VALUEEXT` | `decimal` | Waarde Extern | [ ] | `teq.trs.line.valueext` |  |
| `TEQ_TRS_LINE_VALUEINT` | `decimal` | Interne Waarde | [ ] | `teq.trs.line.valueint` |  |

## Toetsen

| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
| `FixedAssets_COMPANY_CODE_fk` | `COMPANY_CODE` | [Offices](Twinfield.Twinfield.Offices)`.code` | Key |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

- [Twinfield](/nl/release-notes/drivers?driver=twinfield)
