# MCTB_LNE: Multi-client e-banking lines - Name: `MCTB_LNE` - Catalog: `AccountView` - Label: Multi-client e-banking lines - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `MCTB_LNE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ADDRESS` | `string(30)` | Address | ☐ | | | `ADM_CODE` | `string(10)` | Administration code | ☐ | | | `AMOUNT` | `int64` | Transaction amount | ☐ | | | `BANK_ACCT` | `string(34)` | Bank account number | ☐ | | | `BANK_AMT` | `int64` | Bank transaction amount | ☐ | | | `BANK_DATE` | `datetime` | Bank statement date | ☐ | | | `BANK_DESC` | `string(4)` | Bank transaction description | ☐ | | | `BANK_ID` | `string(10)` | E-banking line identification | ☐ | | | `BANK_REF` | `string(20)` | Bank reference | ☐ | | | `BASE_AMT` | `int64` | VAT base amount | ☐ | | | `BEG_PER` | `decimal` | Start of period | ☐ | | | `CN_ID` | `string(10)` | Unique consolidation code | ☐ | | | `COMP_NAME` | `string(100)` | Company name | ☐ | | | `CUR_AMT` | `int64` | Currency amount | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `CUR_VAT` | `int64` | VAT amount foreign currency | ☐ | | | `DIF_CUR` | `int64` | Currency difference | ☐ | | | `DIST_QTY` | `decimal` | Quantity (allocation key) | ☐ | | | `DJ_CODE` | `string(3)` | Journal code | ☐ | | | `DJL_RATE` | `decimal` | Journal line exchange rate | ☐ | | | `END_PER` | `decimal` | End of period | ☐ | | | `EXCH_RATE` | `decimal` | Exchange rate | ☐ | | | `INV_NR` | `string(12)` | Document/invoice number | ☐ | | | `PAGE_NR` | `string(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` | `string(7)` | Postcode | ☐ | | | `PREF` | `string(35)` | Batch ID | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REC_ORD` | `int32` | Line sequence | ☐ | | | `REMI_INFO` | `string(140)` | Posting information | ☐ | | | `RTRN_CODE` | `string(4)` | Direct debit rejection reason | ☐ | | | `SRC_ID` | `string(10)` | Source identification | ☐ | | | `SRC_TYPE` | `decimal` | Source type | ☐ | | | `STMT_KEY` | `string(10)` | Unique statement key | ☐ | | | `TRAN_CODE` | `string(5)` | Transaction code | ☐ | | | `TRN_DATE` | `datetime` | Change date | ☐ | | | `TRN_DESC` | `string(40)` | Line description | ☐ | |