---
title: "MCTB_LNE (AccountView)"
description: "Multi-client e-banking lines"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/vismaaccountview/AccountView..MCTB_LNE
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..MCTB_LNE
updated: 2026-11-16T21:14:16Z
license: https://documentation.invantive.eu/nl/
---

# MCTB_LNE: AccountView Multi-client e-banking lines

`read only`

- Catalogus: `AccountView`
- Label: Multi-client e-banking lines

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `MCTB_LNE` 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 |
|---|---|---|:---:|---|---|
| `ADDRESS` | `varchar2(30)` | Address | [ ] |  |  |
| `ADM_CODE` | `varchar2(10)` | Beheercode | [ ] |  |  |
| `AMOUNT` | `int64` | Transaction amount | [ ] |  |  |
| `BANK_ACCT` | `varchar2(34)` | Bankrekeningnummer | [ ] |  |  |
| `BANK_AMT` | `int64` | Bank transaction amount | [ ] |  |  |
| `BANK_DATE` | `datetime` | Bank statement date | [ ] |  |  |
| `BANK_DESC` | `varchar2(4)` | Bank transaction description | [ ] |  |  |
| `BANK_ID` | `varchar2(10)` | E-banking line identification | [ ] |  |  |
| `BANK_REF` | `varchar2(20)` | Bank reference | [ ] |  |  |
| `BASE_AMT` | `int64` | VAT base amount | [ ] |  |  |
| `BEG_PER` | `decimal` | Start of period | [ ] |  |  |
| `CN_ID` | `varchar2(10)` | Unique consolidation code | [ ] |  |  |
| `COMP_NAME` | `varchar2(100)` | Bedrijfsnaam | [ ] |  |  |
| `CUR_AMT` | `int64` | Currency amount | [ ] |  |  |
| `CUR_CODE` | `varchar2(3)` | Currency code | [ ] |  |  |
| `CUR_VAT` | `int64` | VAT amount foreign currency | [ ] |  |  |
| `DIF_CUR` | `int64` | Currency difference | [ ] |  |  |
| `DIST_QTY` | `decimal` | Quantity (allocation key) | [ ] |  |  |
| `DJ_CODE` | `varchar2(3)` | Tijdschriftcode | [ ] |  |  |
| `DJL_RATE` | `decimal` | Journal line exchange rate | [ ] |  |  |
| `END_PER` | `decimal` | End of period | [ ] |  |  |
| `EXCH_RATE` | `decimal` | Wisselkoers | [ ] |  |  |
| `INV_NR` | `varchar2(12)` | Document-/factuurnummer | [ ] |  |  |
| `PAGE_NR` | `varchar2(10)` | Page number (sign) | [ ] |  |  |
| `PD_AMT` | `int64` | Bedrag van de betalingskorting | [ ] |  |  |
| `PD_PCT` | `decimal` | Kortingspercentage bij betaling | [ ] |  |  |
| `PDIF_VAT` | `int64` | VAT amount payment discount | [ ] |  |  |
| `POST_CODE` | `varchar2(7)` | Postcode | [ ] |  |  |
| `PREF` | `varchar2(35)` | Batch ID | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unieke code | [ ] |  |  |
| `REC_ORD` | `int32` | Regelvolgorde | [ ] |  |  |
| `REMI_INFO` | `varchar2(140)` | Posting information | [ ] |  |  |
| `RTRN_CODE` | `varchar2(4)` | Direct debit rejection reason | [ ] |  |  |
| `SRC_ID` | `varchar2(10)` | Identificatie van de bron | [ ] |  |  |
| `SRC_TYPE` | `decimal` | Bronsoort | [ ] |  |  |
| `STMT_KEY` | `varchar2(10)` | Unique statement key | [ ] |  |  |
| `TRAN_CODE` | `varchar2(5)` | Transaction code | [ ] |  |  |
| `TRN_DATE` | `datetime` | Change date | [ ] |  |  |
| `TRN_DESC` | `varchar2(40)` | Line description | [ ] |  |  |
