---
title: "MCTB_LNE (AccountView)"
description: "Multi-client e-banking lines"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/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/it/
---

# MCTB_LNE: AccountView Multi-client e-banking lines

`read only`

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

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `MCTB_LNE`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ADDRESS` | `varchar2(30)` | Address | [ ] |  |  |
| `ADM_CODE` | `varchar2(10)` | Administration code | [ ] |  |  |
| `AMOUNT` | `int64` | Transaction amount | [ ] |  |  |
| `BANK_ACCT` | `varchar2(34)` | Bank account number | [ ] |  |  |
| `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)` | Nome della ditta | [ ] |  |  |
| `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)` | Journal code | [ ] |  |  |
| `DJL_RATE` | `decimal` | Journal line exchange rate | [ ] |  |  |
| `END_PER` | `decimal` | End of period | [ ] |  |  |
| `EXCH_RATE` | `decimal` | Exchange rate | [ ] |  |  |
| `INV_NR` | `varchar2(12)` | Document/invoice number | [ ] |  |  |
| `PAGE_NR` | `varchar2(10)` | Page number (sign) | [ ] |  |  |
| `PD_AMT` | `int64` | Payment discount amount | [ ] |  |  |
| `PD_PCT` | `decimal` | Payment discount percentage | [ ] |  |  |
| `PDIF_VAT` | `int64` | VAT amount payment discount | [ ] |  |  |
| `POST_CODE` | `varchar2(7)` | Postcode | [ ] |  |  |
| `PREF` | `varchar2(35)` | ID lotto | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unique code | [ ] |  |  |
| `REC_ORD` | `int32` | Line sequence | [ ] |  |  |
| `REMI_INFO` | `varchar2(140)` | Posting information | [ ] |  |  |
| `RTRN_CODE` | `varchar2(4)` | Direct debit rejection reason | [ ] |  |  |
| `SRC_ID` | `varchar2(10)` | Source identification | [ ] |  |  |
| `SRC_TYPE` | `decimal` | Source type | [ ] |  |  |
| `STMT_KEY` | `varchar2(10)` | Unique statement key | [ ] |  |  |
| `TRAN_CODE` | `varchar2(5)` | Transaction code | [ ] |  |  |
| `TRN_DATE` | `datetime` | Change date | [ ] |  |  |
| `TRN_DESC` | `varchar2(40)` | Line description | [ ] |  |  |
