Table HRLHEADER
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| HRLHEADER | HRLHEA | Loan header | Common Data | LOA |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| HRLHEA0 | LOACOD | No | |
| HRLHEA1 | LOACOD+REQNBR+REFNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTFLG | Active | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[HRLHEA]CREUSR | Other | ||||
| CTRDAT | Contract date | D | ||||||
| CTRNUM | Contract | CTR | ||||||
| LOACOD | Loan code | HRLLA | [HRLHEA]HRLHEA0=[HRLHEA]LOACOD | Delete | ||||
| REFNUM | Requester | MAT | [ID]ID0=REFNUM | Delete | ||||
| REQDAT | Request date | D | ||||||
| REQNBR | Request no. | HRLRS | [HRLLR]HRLLR0=[HRLHEA]REQNBR | Delete | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[HRLHEA]UPDUSR | Other | ||||
| VLYDAT | Validation date | D |