swo_swoerr_rout_message_dtl
Contains actual timesheet details for employees working on SWO tasks. This table records actual time spent by employees on specific maintenance tasks, providing data for labor cost calculation and productivity analysis.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Routing information, metadata and message details
This table is the canonical store for the SWORoutMessage entity.
Primary key
replication_key
Columns (8)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | REPLICATION_KEY | Bigint | Replication key. |
| 2 | swoerr_message | varchar | Error message description. |
| 3 | swoerr_message_type | varchar | Message type. |
| 4 | swoerr_set_option | varchar | Set option. |
| 5 | REPLICATION_KEY | Bigint | Flag indicating SWO generated with MR coverage from AME. |
| 6 | swoerr_message | varchar | Link identifier for associate or assemble-disassemble table. |
| 7 | swoerr_message_type | varchar | BER flag. |
| 8 | swoerr_set_option | varchar | Source flag. |
Sample rows (from live DB)
REPLICATION_KEY | swoerr_message | swoerr_message_type | swoerr_set_option | REPLICATION_KEY | swoerr_message |
|---|---|---|---|---|---|
| — | Part # "<%S1>" is already r… | 1 | 0 | — | Part # "<%S1>" is already r… |
| — | Mfr.Part # "<%S2>" is alrea… | 1 | 1 | — | Mfr.Part # "<%S2>" is alrea… |
| — | Part # "<%S1>" received suc… | 2 | 0 | — | Part # "<%S1>" received suc… |
Showing 3 of 20 rows.