| DB | Areas | X-idx | Tables | Sequences | <- lve-control | lve-form -> | HtmlDict 11 |
Leave entries
| Area | FinData |
|---|---|
| Dumpname | lve-entr |
| Label | Leave entries |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 20 | date-from | X | Date From | date | 99/99/9999 | ? | ||
| 25 | date-to | X | Date To | date | 99/99/9999 | ? | ||
| 10 | emp-no | X | Employee No | character | x(8) | |||
| 5 | form-no | X | Form Number | integer | 99999999 | 0 | ||
| 160 | leave-amt | X | Leave Amount | decimal-2 | >>>,>>9.99 | 0 | ||
| 30 | leave-type | X | Leave Type | character | x(2) | |||
| 70 | no-days-appr | X | No Days Approved | decimal-2 | >>9.99 | 0 | ||
| 80 | no-days-unpaid | X | No Days Unpaid | decimal-2 | >>9.99 | 0 | ||
| 180 | post-ind | X | Post Ind | logical | Yes/No | NO | ||
| 40 | trn-type | X | Transaction Type | character | x(2) | |||
| 200 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| form-no | P | form-no (+) | integer |
| date-from | date-from (+) | date | |
| emp-no | emp-no (+) | character | |
| leave-type | leave-type (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| lve-form prs-employee sys-trntype |
| generated 24-6-2026 08:26 |