Table ACTIV
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| ACTIV | ACV | Activity codes | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CODACT | CODACT | No | |
| ACV1 | MODULE+CODACT | No | |
| ACV2 | ORDRE+CODACT | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTDEP | Activity code | ACV | [ACV]CODACT=[ACV]ACTDEP | Block | ||||
| ACTFOR | Formula | AFR | 80 | |||||
| AUUID | Single identifier | AUUID | ||||||
| CODACT | Activity code | ACV | [ACV]CODACT=[ACV]CODACT | Delete | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[ACV]CREUSR | Other | ||||
| DEP | Dependency | M | 15 | 74 | ||||
| DIME | Screen dimension | L | 5 | |||||
| DIMFIL | Minimum dimension | L | 5 | |||||
| DIMMAX | Maximum dimension | L | 5 | |||||
| FLACT | Active flag | M | 6 | 1 | ||||
| INTIT | Title | DES | ||||||
| LIBACT | Title | ATX | ||||||
| MODULE | Module | M | 15 | 14 | ||||
| ORDRE | Order | L | 8 | |||||
| RANG | Sequence | C | 4 | |||||
| TYP | Type | M | 15 | 93 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDFLG | Validated flag | M | 15 | 1 | ||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[ACV]UPDUSR | Other |