Table PROFIL
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| PROFIL | PRF | Employee profile | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PRF0 | PRFCOD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=3;ACCCOD;[V]GSUPCLE | Block | PAY | |||
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| DIE | Dim type code | DIE | [DIE]DIE0=[PRF]DIE | Block | ANA | |||
| EMPMDL | Employee ID | MAT | [ID]ID0=[PRF]EMPMDL | Block | PAY | |||
| ENAFLG | Active | M | 4 | 1 | ||||
| FLGPRN | Slip in days | M | 4 | 1 | ||||
| FLGSUP | Supplement | M | 4 | 1 | ||||
| PRFCMT | Comment | 3 | A | 80 | ||||
| PRFCOD | Profile code | PRF | [PRF]PRF0=[PRF]PRFCOD | Delete | ||||
| PRFDES | Title | DES | ||||||
| PRFSHO | Short title | SHO | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PRF]UPDUSR | Other |