Table RETRO
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| RETRO | RET | Back-pay file | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| RET0 | RETNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| COMMENTAIRE | Comment | AC0 | 1 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[RET]CREUSR | Block | ||||
| DATAVTEFF | Amendments until | D | ||||||
| DATEFF | Effective date | D | ||||||
| DATMININT | Integration date | D | ||||||
| ENAFLG | Active | M | 4 | 1 | ||||
| INTITULE | Title | DES | ||||||
| MOTIF | Reason for back-pay | ADI | [ADI]CODE=443;MOTIF | Block | ||||
| RETNUM | File number | VCR | ||||||
| RETTYP | Back-pay type | M | 20 | 644 | ||||
| STATUT | Status | M | 4 | 645 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[RET]UPDUSR | Block |