Table PJMSCCT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PJMSCCT | PJCCT | Consolidated expenses | Common Data | PJM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PJC0 | PSCSSS+PSCSEQ | No | |
| PJC1 | PSCSSS+OPPNUM+PBUPAE+PBUCOD+PCCGRPSOR+PCCGRP+PCCCOD | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PJCCT]CREUSR | Other | ||||
| OPPNUM | Project number | PIM | [PIM]PIM0=[PJCCT]OPPNUM | Other | ||||
| PBUCOD | Budget code | PBU | ||||||
| PBUPAE | Parent code | PBU | ||||||
| PCCCOD | Cost type | PJCC | [PJCC]PCC0=[PJCCT]PCCCOD | Other | ||||
| PCCGRP | Group | ADI | [ADI]CODE=386;PCCGRP | Other | ||||
| PCCGRPSOR | Sort | L | 8 | |||||
| PSCAMT1 | Amount 1 | MD1 | ||||||
| PSCAMT2 | Amount 2 | MD1 | ||||||
| PSCAMT3 | Amount 3 | MD1 | ||||||
| PSCAMT4 | Amount 4 | MD1 | ||||||
| PSCAMT5 | Amount 5 | MD1 | ||||||
| PSCBUDAMT | Budget amount | MD1 | ||||||
| PSCBUDQTY | Budget quantity | QTY | ||||||
| PSCESTTOTAMT | Total estimation | MD1 | ||||||
| PSCESTTOTQTY | Total estimation | QTY | ||||||
| PSCFREEC10A | QTY | |||||||
| PSCFREEC10B | MD1 | |||||||
| PSCFREEC6A | Quantity | QTY | ||||||
| PSCFREEC6B | Amount | MD1 | ||||||
| PSCFREEC7A | QTY | |||||||
| PSCFREEC7B | MD1 | |||||||
| PSCFREEC8A | QTY | |||||||
| PSCFREEC8B | MD1 | |||||||
| PSCFREEC9A | QTY | |||||||
| PSCFREEC9B | MD1 | |||||||
| PSCIMG | DCB | 14.2 | ||||||
| PSCMARGAMT | Margin amount | MD1 | ||||||
| PSCMARGBUD6 | Ratio on budget | COE | ||||||
| PSCMARGQTY | Margin | QTY | ||||||
| PSCMARGTOT6 | Ratio on total | COE | ||||||
| PSCPCTMAMT | Percentage | MD1 | ||||||
| PSCPCTMBUD6 | Budget percentage | COE | ||||||
| PSCPCTMQTY | Percentage | QTY | ||||||
| PSCPCTMTOT6 | Total percentage | COE | ||||||
| PSCQTY1 | Quantity 1 | QTY | ||||||
| PSCQTY2 | Quantity 2 | QTY | ||||||
| PSCQTY3 | Quantity 3 | QTY | ||||||
| PSCQTY4 | Quantity 4 | QTY | ||||||
| PSCQTY5 | Quantity 5 | QTY | ||||||
| PSCREMAMT | Remaining amount | MD1 | ||||||
| PSCREMQTY | Remaining quantity | QTY | ||||||
| PSCSEQ | Sequence | L | 8 | |||||
| PSCSSS | Session | L | 8 | |||||
| PSCTOTAMT | Total amount | MD1 | ||||||
| PSCTOTQTY | Total quantity | QTY | ||||||
| PSCU | Unit | UOM | [TUN]TUN0=[PJCCT]PSCU | Block | ||||
| PSCWIPAMT | WIP amount | MD1 | ||||||
| PSCWIPQTY | WIP quantity | QTY | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PJCCT]UPDUSR | Other |