Table RETROVAL
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| RETROVAL | RVL | Back-pay - Variables | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| RVL0 | RETNUM+REFNUM+CTRNUM+LIG | No | |
| RVL1 | REFNUM+CTRNUM+CTRDAT+LIG | 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=[RVL]CREUSR | Other | ||||
| CTRDAT | Date | DTR | ||||||
| CTRNUM | Contract | CTR | ||||||
| ENDBUL | Slip | VCR | ||||||
| ENDPAY | End date | D | ||||||
| LIG | Line | L | 8 | |||||
| REFNUM | Employee ID | MAT | [ID]ID0=[RVL]REFNUM | Delete | ||||
| RETNUM | File number | RET | [RET]RET0=[RVL]RETNUM | Delete | ||||
| STRBUL | Slip | VCR | ||||||
| STRPAY | Start date | D | ||||||
| TYP | Level | M | 15 | 339 | ||||
| TYPRVL | Data type | M | 15 | 647 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[RVL]UPDUSR | Other | ||||
| VALDEN | Destination value | VLR | ||||||
| VALORI | Original value | VLR | ||||||
| VARCOD | Code | AVV | 20 |