| DB | Areas | X-idx | Tables | Sequences | <- pur-history | sys-history -> | HtmlDict 11 |
Generic SAL History
| Area | Data |
|---|---|
| Dumpname | salhist |
| Label | Generic SAL History |
| Val.exp | |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 120 | act-cde | X | Activity Code | character | x(8) | |||
| 140 | action-date | X | Action Date | date | 99/99/9999 | ? | ||
| 130 | action-taken | X | Action Taken | character | x | |||
| 150 | action-time | X | Action Time | integer | >>,>>9 | 0 | ||
| 135 | action-user | X | Action User | character | x(12) | |||
| 110 | branch-no | X | Branch | integer | 99 | 0 | ||
| 160 | ent-name | X | Entity Name | character | x(15) | |||
| 180 | fld-list | X | Field List | character | x(30) | |||
| 170 | key | X | Key | character | x(20) | |||
| 200 | new-value | X | New Value | character | x(30) | |||
| 190 | old-value | X | Old Value | character | x(30) | |||
| 155 | seq-no | X | Sequence Number | integer | >>9 | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| P-branch-act | P | branch-no (+) | integer |
| act-cde (+) | character | ||
| action-date (+) | date | ||
| action-user (+) | character | ||
| action-time (+) | integer | ||
| seq-no (+) | integer | ||
| MA-History | ent-name (+) | character | |
| key (+) | character | ||
| action-date (-) | date | ||
| action-time (-) | integer | ||
| seq-no (-) | integer | ||
| MA-TableHist | ent-name (+) | character | |
| action-date (+) | date | ||
| action-time (+) | integer | ||
| seq-no (+) | integer | ||
| MA-UserHist | action-user (+) | character | |
| action-date (+) | date | ||
| action-time (+) | integer | ||
| seq-no (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| generated 3-3-2025 10:52 |