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

# AV_SMQ: AccountView System messages

`read only`

- Catalog: `AccountView`
- Label: System messages

Can only retrieve data.

## Table Columns

The columns of the table `AV_SMQ` 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 |
|---|---|---|:---:|---|---|
| `ADMIN_TO` | `varchar2(10)` | Administration | [ ] |  |  |
| `MACH_TO` | `varchar2(25)` | Workstation | [ ] |  |  |
| `MSG_BODY` | `varchar2(4)` | Message | [ ] |  |  |
| `MSG_DATE` | `datetime` | Message date | [ ] |  |  |
| `MSG_TYPE` | `varchar2(25)` | Message type | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unique code | [ ] |  |  |
| `USER_FROM` | `varchar2(20)` | Sender | [ ] |  |  |
| `USER_TO` | `varchar2(20)` | User | [ ] |  |  |
| `VALID_FROM` | `datetime` | Time | [ ] |  |  |

