Table AVIEW
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| AVIEW | AVW | Dictionary of views | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| AVW0 | CODVUE | No | |
| AVW1 | ABRVUE | Yes | |
| AVW2 | GRUCFM+CODVUE | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ABRVUE | Abbreviation | ABR | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CODACT | Activity code | ACV | [ACV]CODACT=[AVW]CODACT | Block | ||||
| CODVUE | View code | AVW | [AVW]AVW0=[AVW]CODVUE | Delete | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[AVW]CREUSR | Other | ||||
| ENAFLG | Active | M | 4 | 1 | ||||
| GRUCFM | Validation group | C | 4 | |||||
| INTIT | View title | ATX | ||||||
| MODULE | Module | M | 15 | 14 | ||||
| SECURE | Open access | M | 20 | 1 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDFLG | Validated flag | M | 15 | 1 | ||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[AVW]UPDUSR | Other |