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 |