---
title: "AV_MQ (AccountView)"
description: "Messages"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..AV_MQ
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..AV_MQ
updated: 2026-11-16T21:12:56Z
license: https://documentation.invantive.eu/en/
---

# AV_MQ: AccountView Messages

`read only`

- Catalog: `AccountView`
- Label: Messages

Can only retrieve data.

## Table Columns

The columns of the table `AV_MQ` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | 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` | `varchar2(4)` | Message | [ ] |  |  |
| `MSG_FROM` | `varchar2(10)` | Sender administration code | [ ] |  |  |
| `MSG_ID` | `varchar2(20)` | Message identification code | [ ] |  |  |
| `MSG_PICS` | `decimal` | Message status (icon) | [ ] |  |  |
| `MSG_RETURN` | `varchar2(4)` | Reply message | [ ] |  |  |
| `MSG_STAT` | `decimal` | Message status | [ ] |  |  |
| `MSG_TO` | `varchar2(10)` | Recipient administration code | [ ] |  |  |
| `MSG_TYPE` | `decimal` | Message type | [ ] |  |  |
| `MSGTO_ALL` | `char` | Message to all administrations | [ ] |  |  |
| `PR_TRY_NR` | `int32` | Processing attempt | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unique code | [ ] |  |  |

