swo_swomt_Rout_metadata_dtl
Contains SWO Material Request details for parts and materials needed for maintenance work. This table manages material requisitions, quantities required, availability status, and procurement information for work order completion.
Process: COMPMAINTENANCE 路 Component: BasSWO 路 Table type: Transaction Table Category: Metadata of routing steps for SWO tasks
Primary key
swomt_unique_id
Columns (10)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swomt_ack_receipt | varchar | Acknowledge receipt |
| 2 | swomt_action | varchar | Action metrics for validating route/acknowledge parts |
| 3 | swomt_allow_diff_wc_code | varchar | Allow different work center code |
| 4 | swomt_current_loc | varchar | Current location for validation |
| 5 | swomt_exist_rout_sts | varchar | Existing route status |
| 6 | swomt_final_result | varchar | Final result for route validation |
| 7 | swomt_message_type | varchar | Message type for validation |
| 8 | swomt_new_rout_sts | varchar | New route status |
| 9 | swomt_service | varchar | Routing event |
| 10 | swomt_unique_id 馃攽 | int | Unique ID, primary key |
Sample rows (from live DB)
swomt_ack_receipt | swomt_action | swomt_allow_diff_wc_code | swomt_current_loc | swomt_exist_rout_sts | swomt_final_result |
|---|---|---|---|---|---|
| M | NA | Y | S | P | E |
| M | NO | Y | S | M | S |
| M | NA | Y | S | FR | E |
Showing 3 of 44 rows.