---
title: "Transactions (XAF 3.2)"
language: nl
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/nl/datamodels/xaf/XAF..Transactions
original: https://documentation.invantive.eu/en/datamodels/xaf/XAF..Transactions
updated: 2026-11-18T23:29:06Z
license: https://documentation.invantive.eu/nl/
---

# Transacties: XAF 3.2

`read only` `per partition` `XML`

- Catalogus: `XAF`

Kan alleen gegevens ophalen.

## API-bron

- XML-onderwerp: `auditfile`
- XML-pad: `/xaf:journal/xaf:transaction`

## Tabelkolommen

De kolommen van de tabel `Transactions` 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 |
|---|---|---|:---:|---|---|
| `AMNT` | `decimal` |  | [ ] |  |  |
| `AMNTTP` | `varchar2(240)` |  | [ ] |  |  |
| `AUDIT_FILE_VERSION` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_ADDRESS` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_CITY` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_ID` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_NAME` | `varchar2(1000)` |  | [ ] |  |  |
| `COMPANY_POSTAL_CODE` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_TAX_REG_IDENT` | `varchar2(240)` |  | [ ] |  |  |
| `DESC` | `varchar2` |  | [ ] |  |  |
| `FILE_CURRENCY_CODE` | `varchar2(240)` |  | [ ] |  |  |
| `FILE_DATE_CREATED` | `varchar2(240)` |  | [ ] |  |  |
| `FISCAL_YEAR_END_DATE` | `datetime` |  | [ ] |  |  |
| `FISCAL_YEAR_NUMBER` | `varchar2(240)` |  | [x] |  |  |
| `FISCAL_YEAR_START_DATE` | `datetime` |  | [ ] |  |  |
| `INTERFACE_URL` | `varchar2(4000)` |  | [x] |  |  |
| `JOURNAL_BANKACCNR` | `varchar2(240)` | Bankrekeningnummer journaal | [ ] |  |  |
| `JOURNAL_DESCRIPTION` | `varchar2` | Dagboekomschrijving | [ ] |  |  |
| `JOURNAL_JRNID` | `varchar2(240)` | ID journaal | [ ] |  |  |
| `JOURNAL_JRNTP` | `varchar2(240)` | Journaaltype | [ ] |  |  |
| `JOURNAL_OFFSETACCID` | `varchar2(240)` | ID tegenrekening journaal | [ ] |  |  |
| `JOURNAL_TRANSACTIONS_LINESCOUNT` | `int64` | Aantal transactieregels | [ ] |  |  |
| `JOURNAL_TRANSACTIONS_TOTALCREDIT` | `decimal` | Totaal credit transactie | [ ] |  |  |
| `JOURNAL_TRANSACTIONS_TOTALDEBIT` | `decimal` | Totaal debet transactie | [ ] |  |  |
| `NR` | `varchar2(240)` |  | [ ] |  |  |
| `PERIODNUMBER` | `int64` |  | [ ] |  |  |
| `PRODUCT_ID` | `varchar2(240)` |  | [ ] |  |  |
| `PRODUCT_VERSION` | `varchar2(240)` |  | [ ] |  |  |
| `SOURCEID` | `varchar2(240)` |  | [ ] |  |  |
| `TRDT` | `datetime` |  | [ ] |  |  |
| `USERID` | `varchar2(240)` |  | [ ] |  |  |
