# AV_MQ: Messages - Name: `AV_MQ` - Catalog: `AccountView` - Label: Messages - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `AV_MQ` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CNG_DATE` | `datetime` | Date last modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `DATE_INP` | `datetime` | Entry date | ☐ | | | `DATE_PROC` | `datetime` | Date processed | ☐ | | | `DATE_RECD` | `datetime` | Receipt date | ☐ | | | `DATE_SENT` | `datetime` | Dispatch date | ☐ | | | `ERROR_CODE` | `int32` | Error code | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `MSG_BODY` | `string(4)` | Message | ☐ | | | `MSG_FROM` | `string(10)` | Sender administration code | ☐ | | | `MSG_ID` | `string(20)` | Message identification code | ☐ | | | `MSG_PICS` | `decimal` | Message status (icon) | ☐ | | | `MSG_RETURN` | `string(4)` | Reply message | ☐ | | | `MSG_STAT` | `decimal` | Message status | ☐ | | | `MSG_TO` | `string(10)` | Recipient administration code | ☐ | | | `MSG_TYPE` | `decimal` | Message type | ☐ | | | `MSGTO_ALL` | `boolean` | Message to all administrations | ☐ | | | `PR_TRY_NR` | `int32` | Processing attempt | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | |