# MCTB_HDR: Multi-client e-banking pages - Name: `MCTB_HDR` - Catalog: `AccountView` - Label: Multi-client e-banking pages - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `MCTB_HDR` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ADM_CODE` | `string(10)` | Administration code | ☐ | | | `ADM_DESC` | `string(40)` | Administration name | ☐ | | | `BATCH_ID` | `string(10)` | Batch | ☐ | | | `BNK_ACCT` | `string(34)` | Bank account statement (short) | ☐ | | | `BNK_ACCTV` | `string(42)` | Bank account statement | ☐ | | | `CNG_DATE` | `datetime` | Date last modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CONV_DESC` | `string(40)` | Statement format | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `CUR_AMT` | `int64` | Total currency | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `CUR_VAT` | `int64` | VAT currency total | ☐ | | | `DJ_CODE` | `string(3)` | Journal code | ☐ | | | `DJL_RATE` | `decimal` | Exchange rate foreign currency journal | ☐ | | | `EXCH_RATE` | `decimal` | Exchange rate | ☐ | | | `EXP_DJP` | `boolean` | Exported journal pages | ☐ | | | `EXP_SYS` | `boolean` | Old value of sys_gen | ☐ | | | `EXT_DESC` | `string(40)` | Payment reference | ☐ | | | `HDR_DESC` | `string(40)` | Page description | ☐ | | | `IMP_DATE` | `datetime` | Import date | ☐ | | | `IMP_TIME` | `int32` | Import time | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INST_CODE` | `string(5)` | Installation | ☐ | | | `INV_NR` | `string(12)` | Document/invoice number | ☐ | | | `NO_POST` | `boolean` | Blocked FY periods | ☐ | | | `PAGE_AMT` | `int64` | Page balance | ☐ | | | `PAGE_NR` | `string(10)` | Page number (sign) | ☐ | | | `PAGE_VAT` | `int64` | VAT amount page | ☐ | | | `PREV_AMT` | `int64` | Opening balance page | ☐ | | | `PREV_BAL` | `int64` | Previous balance | ☐ | | | `PREV_DATE` | `datetime` | Previous statement date | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `STMT_ADDR` | `string(20)` | Account holder address | ☐ | | | `STMT_BAL` | `int64` | Statement balance | ☐ | | | `STMT_CITY` | `string(25)` | Account holder city | ☐ | | | `STMT_CNT` | `int32` | Number of transactions | ☐ | | | `STMT_CUR` | `string(3)` | Statement currency | ☐ | | | `STMT_DATE` | `datetime` | Statement date | ☐ | | | `STMT_FILE` | `string(60)` | Statement file name | ☐ | | | `STMT_KEY` | `string(10)` | Unique statement key | ☐ | | | `STMT_NR` | `int32` | Bank statement | ☐ | | | `STMT_OWNR` | `string(30)` | Account holder | ☐ | | | `SUB_NR` | `string(10)` | Customer/Supplier | ☐ | | | `SYS_GEN` | `boolean` | Page generated by system | ☐ | | | `SYS_VAL` | `boolean` | System validations | ☐ | | | `TGT_BAL` | `int64` | Control balance | ☐ | | | `TRN_DATE` | `datetime` | Change date | ☐ | | | `USR_NAME` | `string(20)` | Last changed by | ☐ | |