# ADM_LIST: Administrations - Name: `ADM_LIST` - Catalog: `AccountView` - Label: Administrations - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `ADM_LIST` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ADM_ARCH` | `boolean` | Archived | ☐ | | | `ADM_CODE` | `string(10)` | Administration code | ☐ | | | `ADM_COMM` | `string(4)` | Administration note | ☐ | | | `ADM_DESC` | `string(40)` | Administration name | ☐ | | | `ADM_DIR` | `string(200)` | Administration folder name | ☐ | | | `ADM_HOLD` | `string(10)` | Holding administration name | ☐ | | | `ADM_HOLD2` | `string(10)` | Holding administration name (internal) | ☐ | | | `ADM_MODEL` | `boolean` | Sample administration | ☐ | | | `ADM_PREV` | `string(10)` | Previous year administration | ☐ | | | `ADM_REMOTE` | `boolean` | Administration at other branch | ☐ | | | `ADV_ORG` | `boolean` | Advice: reorganise administration | ☐ | | | `ALL_TBL` | `boolean` | Do not restrict administration files | ☐ | | | `ATS_CODE` | `string(20)` | Client code | ☐ | | | `ATS_DESC` | `string(40)` | Description | ☐ | | | `ATS_EXTRA` | `string(10)` | Extra field | ☐ | | | `ATS_LOC` | `string(10)` | Branch code | ☐ | | | `ATS_YEAR` | `string(10)` | Financial year | ☐ | | | `BLCK_DATE` | `datetime` | Blocked on date/time | ☐ | | | `BLCK_USER` | `string(20)` | Blocked by user | ☐ | | | `BLCK_USRV` | `string(10)` | Blocked (icon) | ☐ | | | `BOOK_DATE` | `datetime` | Date of last posting | ☐ | | | `CICO_DATE` | `datetime` | Carried over on date/time | ☐ | | | `CICO_USR` | `string(20)` | Carried over by user | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `CNL_PCT` | `decimal` | Holding participation percentage | ☐ | | | `CNL_PCT2` | `decimal` | Holding participation percentage (internal) | ☐ | | | `DBC_NAME` | `string(8)` | Administration database name | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `INST_CODE` | `string(5)` | Installation | ☐ | | | `LIC_CNG` | `boolean` | Licence changed | ☐ | | | `MC_BLOCK` | `boolean` | Blocked for multi-client electronic banking | ☐ | | | `MSG_DEST` | `string(40)` | Message destination | ☐ | | | `MSG_STGY` | `string(25)` | Message class | ☐ | | | `NET_USE` | `boolean` | Administration network usage | ☐ | | | `ORG_ADM` | `boolean` | Administration must be reorganised | ☐ | | | `SCHED_BLK` | `boolean` | Blocked for alerts | ☐ | | | `SYNC_LOG` | `boolean` | Exchange master data | ☐ | |