Table MSHISTO
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| MSHISTO | MHS | TP history | Total Payroll | MAS |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MHS0 | COD+LIGHYP+EMP+CTR+MSEMP+DAT+RUB+TYP+SIM | No | |
| MHS2 | EMP+MSEMP+CTR+DAT | Yes | |
| MHS3 | COD+DAT | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMT | Amount | DCB | 11.2 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BAS | Basis | DCB | 11.2 | |||||
| BUD | Budget code | ADI | [ADI]CODE=652;BUD | Block | ||||
| CAT | Group category | ADI | [ADI]CODE=655;CAT | Block | ||||
| COD | Scenario | MCH | [MCH]MCH0=[MHS]COD | Delete | MAS | |||
| CODHYP | Hypothesis | A | 20 | |||||
| CPY | Company | CPY | [CPY]CPY0=[MHS]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[MHS]CREUSR | Other | ||||
| CTR | Contract | CTR | ||||||
| DAT | Date | D | ||||||
| EMP | Employee | MAT | [ID]ID0=[MHS]EMP | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=[MHS]FCY | Block | ||||
| GRP | Group | ADI | [ADI]CODE=654;GRP | Block | ||||
| LIGHYP | Line number | C | 4 | |||||
| MSEMP | Employee chrono | A | 15 | |||||
| PRF | Profile | PRF | [PRF]PRF0=[MHS]PRF | Block | ||||
| RAT | Rate | DCB | 11.2 | |||||
| REA | Real | DCB | 11.2 | |||||
| RUB | Heading | A | 10 | |||||
| SIM | Simulation | M | 4 | 1 | ||||
| SRV | Department | SRV | [SRV]SRV0=[MHS]SRV | Block | ||||
| TOUTEE | ADI | [ADI]CODE=656;TOUTEE | Block | |||||
| TYP | Type of amount | C | 2 | |||||
| TYPHYP | Type | M | 15 | 485 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[MHS]UPDUSR | Other |