Table PJMBUDTRQ
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PJMBUDTRQ | PJQ | Financial overview queries | Common Data | PJM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PTQ0 | PBTGRP+PBTCOD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTIVE | Active | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| CODDES | Query name | AX3 | ||||||
| CONTXT | Context | M | 15 | 2269 | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PJQ]CREUSR | Other | ||||
| CUMRTCO | Remain. budget calc. | M | 4 | 1 | ||||
| CUMSCOL | Subcol1. calculation | M | 4 | 1 | ||||
| DEFCTYPE | Default cost type | PJCC | [PJCC]PCC0=[PJQ]DEFCTYPE | Block | ||||
| FREECOL | Working table free column no. | L | 8 | |||||
| LABEL | Label | AX3 | ||||||
| PBTCOD | Query no. | PJQ | [PJQ]PTQ0=[PJQ]PBTCOD | BSRA | ||||
| PBTGRP | Financial view | ADI | [ADI]CODE=388;PBTGRP | Block | ||||
| PBTOBJ | Object | AOB | [AOB]ABREV=[PJQ]PBTOBJ | Block | ||||
| PJMPBTCOD | Structure link | PJS | [PJS]PTS0=PBTGRP;PJMPBTCOD | Block | ||||
| POSVAL | Positive valuation | M | 4 | 1 | ||||
| SQLQRY | SQL query to run | ALH | [ALH]ALH0=[PJQ]SQLQRY | Block | ||||
| SQLQRYFRE | SQL query to run | ALH | [ALH]ALH0=[PJQ]SQLQRYFRE | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PJQ]UPDUSR | Other |