Table | Abbreviation | Title | 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 | Title | 15 | AX1 | |||||
COLALPSUP | Option | 15 | A | 10 | ||||
COLALPTYP | Data type | 15 | ATY | [ATY]CODTYP=[ADV]COLALPTYP | Block | |||
COLDES | Title | 15 | AX1 | |||||
COLNUMDES | Title | 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 | Title | 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 title | 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 |