| DB | Areas | X-idx | Tables | Sequences | <- sal-typealloc | scl-log-plan -> | HtmlDict 11 |
Support Logs
| Area | ProdData |
|---|---|
| Dumpname | log |
| Label | Support Logs |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 240 | action-date | X | Action Date | date | 99/99/9999 | ? | ||
| 250 | action-time | X | Action Time | integer | 99999 | 0 | ||
| 230 | action-user | X | Action User | character | x(12) | |||
| 130 | alloc-date | X | Alloc Date | date | 99/99/9999 | ? | ||
| 140 | alloc-time | X | Alloc Time | integer | 99999 | 0 | ||
| 90 | branch-no | X | Branch No | integer | 999 | 0 | ||
| 200 | close-date | X | Close Date | date | 99/99/9999 | ? | ||
| 210 | close-time | X | Close Time | integer | 99999 | 0 | ||
| 190 | close-user | X | Close User | character | x(12) | |||
| 110 | esc-ind | X | Escalated | logical | Yes/No | FALSE | ||
| 10 | log-no | X | Log No | integer | 99999999 | 0 | ||
| 30 | log-type | X | Log Type | character | x(3) | |||
| 100 | region-no | X | Region | integer | 99 | 0 | ||
| 160 | reply-date | X | Reply Date | date | 99/99/9999 | ? | ||
| 180 | reply-desc | X | Short Reply | character | x(30) | |||
| 170 | reply-time | X | Reply Time | integer | 99999 | 0 | ||
| 150 | reply-user | X | Reply User | character | x(12) | |||
| 120 | req-count | X | Count | integer | >>>9 | 0 | ||
| 50 | req-date | X | Request Date | date | 99/99/9999 | ? | ||
| 70 | req-desc | X | Description | character | x(8) | |||
| 80 | req-stat | X | Status | integer | 9 | 0 | ||
| 60 | req-time | X | Request Time | integer | 99999 | 0 | ||
| 220 | resp-stat | X | Response Status | character | x | |||
| 40 | tech-id | X | Tech Id | character | x(12) | |||
| 20 | user-id | X | User ID | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| log-no | P U | log-no (+) | integer |
| tech-id | tech-id (+) | character | |
| log-no (+) | integer | ||
| user-id | user-id (+) | character | |
| log-no (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| scl-log-type scl-technician sys-acchist sys-branchctrl sys-user-log |
| generated 18-9-2026 10:04 |