Table ATABTAB
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| ATABTAB | ADV | Miscellaneous table set-up | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CODE | NUMTAB | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACS | Access code | ACS | [ACS]ACS0=[ADV]ACS | Block | ||||
| ALPDES1 | Alpha 1 | AX1 | ||||||
| ALPDES2 | Alpha 2 | AX1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CODACT | Activity code | ACV | [ACV]CODACT=[ADV]CODACT | Block | ||||
| CODTYP1 | Type | ATY | [ATY]CODTYP=[ADV]CODTYP1 | Block | ||||
| CODTYP2 | Type | ATY | [ATY]CODTYP=[ADV]CODTYP2 | Block | ||||
| CODTYP3 | Type | ATY | [ATY]CODTYP=[ADV]CODTYP3 | Block | ||||
| CODTYP4 | Type | ATY | [ATY]CODTYP=[ADV]CODTYP4 | Block | ||||
| COLALPDES | Description | 15 | AX1 | |||||
| COLALPSUP | Option | 15 | A | 10 | ||||
| COLALPTYP | Data type | 15 | ATY | [ATY]CODTYP=[ADV]COLALPTYP | Block | |||
| COLDES | Description | 15 | AX1 | |||||
| COLNUMDES | Description | 15 | AX1 | |||||
| COLNUMSUP | Option | 15 | A | 10 | ||||
| COLNUMTYP | Data type | 15 | ATY | [ATY]CODTYP=[ADV]COLNUMTYP | Block | |||
| COLSUP | Option | 15 | A | 10 | ||||
| COLTYP | Data type | 15 | ATY | [ATY]CODTYP=[ADV]COLTYP | Block | |||
| COLTYPTYP | Column type | 15 | M | 15 | 46 | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[ADV]CREUSR | Other | ||||
| DEPNUM | Dependency | ADV | [ADV]CODE=[ADV]DEPNUM | Block | ||||
| FLGENA | Active flag | M | 4 | 1 | ||||
| FLGLEG | Filter legislation | M | 4 | 1 | ||||
| FLGSOC | Company filter | M | 4 | 1 | ||||
| LNG | Length | C | 3 | |||||
| LNGDES | Description | AX3 | ||||||
| LNGFLG | Modifiable length | M | 4 | 1 | ||||
| MODULE | Module | M | 15 | 14 | ||||
| NBCOL | Number | C | 4 | |||||
| NUMCAR | Table number | A | 5 | |||||
| NUMDES1 | Numeric 1 | AX1 | ||||||
| NUMDES2 | Numeric 2 | AX1 | ||||||
| NUMTAB | Table number | ADV | [ADV]CODE=[ADV]NUMTAB | Delete | ||||
| OBLLEG | Legislation entry | M | 4 | 1 | ||||
| SHODES | Short description | AX1 | ||||||
| SUP1 | Option | A | 10 | |||||
| SUP2 | Option | A | 10 | |||||
| SUP3 | Option | A | 10 | |||||
| SUP4 | Option | A | 10 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDFLG | Modifiable flag | M | 4 | 1 | ||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[ADV]UPDUSR | Other |