Table AYTLINES
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| AYTLINES | AYN | Lines by types | Supervisor | AYT |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| AYN0 | FCYCOD+LINCODTYP+LINCOD+LINTYP+LINNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALLSTAR | Char. * for all | M | 4 | 1 | ||||
| ANDOR | Operator | M | 15 | 56 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BRKLFT | No. left bracket | C | 4 | |||||
| BRKRGT | No. right bracket | C | 4 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[AYN]CREUSR | Other | ||||
| CRIOBY | Mandatory criteria | M | 4 | 1 | ||||
| DLKCOD | Dynamic link | AYL | [AYL]AYL0=FCYCOD;DLKCOD | Block | ||||
| ENTCOD | Entity | AYE | [AYE]AYE0=FCYCOD;ENTCOD | Block | ||||
| FCYCOD | Site | AYS | [AYS]AYS0=[AYN]FCYCOD | Block | ||||
| FIECOD | Field | AYF | [AYF]AYF0=FCYCOD;FIECOD | Block | ||||
| FIELNKENT | Linked entity | AYE | [AYE]AYE0=FCYCOD;FIELNKENT | Block | ||||
| INTFLD | Interface field | A | 12 | |||||
| INTFLDGRP | Interface group | APU | ||||||
| INTFLDIND | Interf. field occ | C | 4 | |||||
| INTTYPMLT | Multiple type rel. | M | 4 | 1 | ||||
| LINCOD | Code in capital letters | AYN | ||||||
| LINCODSTD | Code | AYN | ||||||
| LINCODTYP | Code type | C | 4 | |||||
| LINNUM | Number | C | 4 | |||||
| LINTYP | Line type | C | 4 | |||||
| MENADI | Misc table code | ADI | [ADI]CODE=MENADV;MENADI | Block | ||||
| MENADISHO | Short description | M | 4 | 1 | ||||
| MENADV | Miscellaneous table | ADV | [ADV]CODE=[AYN]MENADV | Block | ||||
| MENCHP | Chapter | C | 4 | |||||
| MENCHPNUM | Number | C | 4 | |||||
| MENCOD | Code | L | 8 | |||||
| MENCODPAR | Parent code | L | 8 | |||||
| MENLIBORI | Description | M | 15 | 7934 | ||||
| MENTYP | Key type | C | 2 | |||||
| OPE | Operator | M | 15 | 7926 | ||||
| PARCOD | Parameter | AYF | [AYF]AYF0=FCYCOD;PARCOD | Block | ||||
| SRTORD | Sort order | M | 10 | 90 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[AYN]UPDUSR | Other | ||||
| VA2BLCCOD | Block | AYB | [AYB]AYB0=FCYCOD;VA2BLCCOD | Block | ||||
| VA2FIECOD | Field | AYF | [AYF]AYF0=FCYCOD;VA2FIECOD | Block | ||||
| VA2FIELNKE | Entity | AYE | [AYE]AYE0=FCYCOD;VA2FIELNKE | Block | ||||
| VALBLCCOD | Block | AYB | [AYB]AYB0=FCYCOD;VALBLCCOD | Block | ||||
| VALENTCOD | Entity | AYE | [AYE]AYE0=FCYCOD;VALENTCOD | Block | ||||
| VALEUR | Value | AYR | ||||||
| VALFIECOD | Field | AYF | [AYF]AYF0=FCYCOD;VALFIECOD | Block | ||||
| VALFIELNKE | Linked entity | AYE | [AYE]AYE0=FCYCOD;VALFIELNKE | Block | ||||
| VALTYP | Value type | M | 15 | 7925 |