Table AHISTO
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
AHISTO | AHI | History/purge | Supervisor |
Key | Description | Duplicates | Activity code |
---|---|---|---|
AHI0 | COD | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
COD | Code | AHI | [AHI]AHI0=[AHI]COD | Delete | ||||
CODACT | Activity code | ACV | [ACV]CODACT=[AHI]CODACT | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | AUS | [AUS]CODUSR=[AHI]CREUSR | Other | ||||
CTLTRT | Processing | ADC | ||||||
DAT1 | Date | D | ||||||
DAT2 | Date | D | ||||||
DES | Description | ATX | ||||||
DESSHO | Short description | ATX | ||||||
ENAFLG | Active | M | 4 | 1 | ||||
FLG1 | Archive | M | 4 | 1 | ||||
FLG2 | Purge | M | 4 | 1 | ||||
FRQ1 | Frequency | C | 4 | |||||
FRQ2 | Frequency | C | 4 | |||||
MODULE | Module | M | 15 | 14 | ||||
NBRTBL | Number of tables | C | 2 | |||||
SPETRT | Processing | ADC | ||||||
TIM1 | Data retention days | C | 4 | |||||
TIM2 | Purge time | C | 4 | |||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | AUS | [AUS]CODUSR=[AHI]UPDUSR | Other |