Table ACONSULT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| ACONSULT | ACN | Inquiries | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ACN0 | COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| COD | Code | ACN | [ACN]ACN0=[ACN]COD | Delete | ||||
| CODACT | Activity code | ACV | [ACV]CODACT=[ACN]CODACT | Block | ||||
| CPNKEY | Key component | 8 | AVA | |||||
| CPNSCR | Header fields | 8 | AVA | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[ACN]CREUSR | Other | ||||
| DSYCRI | Display | 50 | M | 4 | 1 | |||
| FILABB | Abbreviation | ABR | ||||||
| FILCND | Condition | 3 | AFR | 30 | ||||
| FILKEY | Key | ANX | ||||||
| FILNAM | Main table | ATB | [ATB]CODFIC=[ACN]FILNAM | Block | ||||
| FILOPN | Table | 50 | ATB | [ATB]CODFIC=[ACN]FILOPN | Block | |||
| FLD0 | Criteria fields | 50 | AVA | |||||
| FLD1 | Header fields | 50 | AVA | |||||
| LIBEL | Description | ATX | ||||||
| MAGNETO | Radio buttons | M | 4 | 1 | ||||
| MODULE | Module | M | 15 | 14 | ||||
| NBRCPNKEY | Number of components | C | 1 | |||||
| NBRCRI | Numbers of criteria | C | 2 | |||||
| NBRFIL | Number of tables | C | 2 | |||||
| OBJET | Object | AOB | [AOB]ABREV=[ACN]OBJET | Block | ||||
| PRGSPE | Specific processing | ADC | ||||||
| PRGSTD | Standard processing | ADC | ||||||
| SCRCOD | Screen code | GTC | [GTC]GTC0=COD;SCRCOD | RTZ | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDFLG | Validated flag | M | 15 | 1 | ||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[ACN]UPDUSR | Other | ||||
| WND0 | Criteria window | FEN | [AWI]AWI0=[ACN]WND0 | Block | ||||
| WND1 | Main window | FEN | [AWI]AWI0=[ACN]WND1 | Block | ||||
| ZACC | Access code field | AVA | ||||||
| ZSITE | Site field | AVA |