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

# MCTB_LNE: AccountView Multi-client e-banking lines

`read only`

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

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `MCTB_LNE` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ADDRESS` | `varchar2(30)` | Address | [ ] |  |  |
| `ADM_CODE` | `varchar2(10)` | Code d'administration | [ ] |  |  |
| `AMOUNT` | `int64` | Transaction amount | [ ] |  |  |
| `BANK_ACCT` | `varchar2(34)` | Numéro de compte bancaire | [ ] |  |  |
| `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)` | Nom de l'entreprise | [ ] |  |  |
| `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)` | Code de la revue | [ ] |  |  |
| `DJL_RATE` | `decimal` | Journal line exchange rate | [ ] |  |  |
| `END_PER` | `decimal` | End of period | [ ] |  |  |
| `EXCH_RATE` | `decimal` | Taux de change | [ ] |  |  |
| `INV_NR` | `varchar2(12)` | Numéro du document/de la facture | [ ] |  |  |
| `PAGE_NR` | `varchar2(10)` | Page number (sign) | [ ] |  |  |
| `PD_AMT` | `int64` | Montant de la remise sur paiement | [ ] |  |  |
| `PD_PCT` | `decimal` | Pourcentage de remise sur le paiement | [ ] |  |  |
| `PDIF_VAT` | `int64` | VAT amount payment discount | [ ] |  |  |
| `POST_CODE` | `varchar2(7)` | Postcode | [ ] |  |  |
| `PREF` | `varchar2(35)` | Identifiant du lot | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Code unique | [ ] |  |  |
| `REC_ORD` | `int32` | Séquence de lignes | [ ] |  |  |
| `REMI_INFO` | `varchar2(140)` | Posting information | [ ] |  |  |
| `RTRN_CODE` | `varchar2(4)` | Direct debit rejection reason | [ ] |  |  |
| `SRC_ID` | `varchar2(10)` | Identification de la source | [ ] |  |  |
| `SRC_TYPE` | `decimal` | Type de source | [ ] |  |  |
| `STMT_KEY` | `varchar2(10)` | Unique statement key | [ ] |  |  |
| `TRAN_CODE` | `varchar2(5)` | Transaction code | [ ] |  |  |
| `TRN_DATE` | `datetime` | Change date | [ ] |  |  |
| `TRN_DESC` | `varchar2(40)` | Line description | [ ] |  |  |
