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

# TransactionLines: XAF 3.2

`read only` `per partition` `XML`

- Katalog: `XAF`

Es können nur Daten abgerufen werden.

## API-Quelle

- XML-Thema: `auditfile`
- XML-Pfad: `/xaf:journal/xaf:transaction/xaf:trLine`

## Tabellenspalten

Die Spalten der Tabelle `TransactionLines` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCID` | `varchar2(240)` |  | [ ] |  |  |
| `AMNT` | `decimal` |  | [ ] |  |  |
| `AMNTTP` | `varchar2(240)` |  | [ ] |  |  |
| `ARTGRPID` | `varchar2(240)` |  | [ ] |  |  |
| `AUDIT_FILE_VERSION` | `varchar2(240)` |  | [ ] |  |  |
| `BALANCE` | `decimal` |  | [ ] |  |  |
| `BANKACCNR` | `varchar2(240)` |  | [ ] |  |  |
| `BANKIDCD` | `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)` |  | [ ] |  |  |
| `COSTID` | `varchar2(240)` |  | [ ] |  |  |
| `CURRENCY_CURAMNT` | `decimal` | Währungsbetrag | [ ] |  |  |
| `CURRENCY_CURCODE` | `varchar2(240)` | Währung Währungscode | [ ] |  |  |
| `CUSTSUPID` | `varchar2(240)` |  | [ ] |  |  |
| `DESCRIPTION` | `varchar2` |  | [ ] |  |  |
| `DOCREF` | `varchar2(999)` |  | [ ] |  |  |
| `EFFDATE` | `datetime` |  | [ ] |  |  |
| `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] |  |  |
| `INVREF` | `varchar2(999)` |  | [ ] |  |  |
| `MATCHKEYID` | `varchar2(240)` |  | [ ] |  |  |
| `NR` | `varchar2(240)` |  | [ ] |  |  |
| `ORDERREF` | `varchar2(999)` |  | [ ] |  |  |
| `PRODID` | `varchar2(240)` |  | [ ] |  |  |
| `PRODUCT_ID` | `varchar2(240)` |  | [ ] |  |  |
| `PRODUCT_VERSION` | `varchar2(240)` |  | [ ] |  |  |
| `PROJID` | `varchar2(240)` |  | [ ] |  |  |
| `QNTITY` | `int64` |  | [ ] |  |  |
| `QNTITYID` | `varchar2(240)` |  | [ ] |  |  |
| `RECEIVINGDOCREF` | `varchar2(999)` |  | [ ] |  |  |
| `RECREF` | `varchar2(999)` |  | [ ] |  |  |
| `SHIPDOCREF` | `varchar2(999)` |  | [ ] |  |  |
| `TRANSACTION_AMNT` | `decimal` | Transaktionsbetrag | [ ] |  |  |
| `TRANSACTION_AMNTTP` | `varchar2(240)` | Art des Transaktionsbetrags | [ ] |  |  |
| `TRANSACTION_DESC` | `varchar2` | Beschreibung Transaktion | [ ] |  |  |
| `TRANSACTION_JOURNAL_BANKACCNR` | `varchar2(240)` | Bankkontonummer Journal | [ ] |  |  |
| `TRANSACTION_JOURNAL_DESCRIPTION` | `varchar2` | Journal Beschreibung | [ ] |  |  |
| `TRANSACTION_JOURNAL_JRNID` | `varchar2(240)` | Journal-ID | [ ] |  |  |
| `TRANSACTION_JOURNAL_JRNTP` | `varchar2(240)` | Journaltyp | [ ] |  |  |
| `TRANSACTION_JOURNAL_OFFSETACCID` | `varchar2(240)` | Gegenkonto-ID Journal | [ ] |  |  |
| `TRANSACTION_JOURNAL_TRANSACTIONS_LINESCOUNT` | `int64` | Anzahl Transaktionszeilen | [ ] |  |  |
| `TRANSACTION_JOURNAL_TRANSACTIONS_TOTALCREDIT` | `decimal` | Transaktion Haben gesamt | [ ] |  |  |
| `TRANSACTION_JOURNAL_TRANSACTIONS_TOTALDEBIT` | `decimal` | Transaktion Soll gesamt | [ ] |  |  |
| `TRANSACTION_NR` | `varchar2(240)` | Transaktionsnummer | [ ] |  |  |
| `TRANSACTION_PERIODNUMBER` | `int64` | Periodennummer der Transaktion | [ ] |  |  |
| `TRANSACTION_SOURCEID` | `varchar2(240)` | Transaktionsquelle-ID | [ ] |  |  |
| `TRANSACTION_TRDT` | `datetime` | Verhandlung-Datum | [ ] |  |  |
| `TRANSACTION_USERID` | `varchar2(240)` | Benutzer-ID Transaktion | [ ] |  |  |
| `WORKCOSTARRREF` | `varchar2(999)` |  | [ ] |  |  |
