swo_pln_upgrade_ws_dtl
Contains information regarding planned task upgrades within a work order. This table helps in tracking enhancements, scheduling task improvements, and ensuring that work orders meet updated maintenance requirements
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Planned Upgrade Workstep Details
This table is the canonical store for the PlnUpgradeWS entity.
Primary key
swo_unique_id
Columns (15)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swo_createdby | varchar | User who created the shop work order |
| 2 | swo_createddate | datetime | Date and time of SWO creation |
| 3 | swo_modifiedby | varchar | User who modified the SWO |
| 4 | swo_modifieddate | datetime | Date and time of SWO modification |
| 5 | swo_orderno | varchar | Shop work order number |
| 6 | swo_ouinstance | int | Organizational unit instance for SWO |
| 7 | swo_repseqno | int | Report sequence number |
| 8 | swo_taskno | varchar | Task number in SWO |
| 9 | swo_taskrev | varchar | Task revision number |
| 10 | swo_tasktrackid | Bigint | Task tracking ID |
| 11 | swo_unique_id 🔑 | bigint | Unique identifier for SWO record |
| 12 | swo_upg_repseqno | int | Upgraded report sequence number |
| 13 | swo_upg_taskno | varchar | Upgraded task number |
| 14 | swo_upg_taskrev | varchar | Upgraded task revision |
| 15 | swo_upg_tasktrackid | Bigint | Upgraded task tracking ID |
Sample rows (from live DB)
swo_createdby | swo_createddate | swo_modifiedby | swo_modifieddate | swo_orderno | swo_ouinstance |
|---|---|---|---|---|---|
| DMUSER | 2021-11-27 18:41:16.027 | — | — | CWO-002579-2012 | 2 |
| DMUSER | 2021-12-01 01:19:22.597 | — | — | OWO-000912-2021 | 2 |
| DMUSER | 2022-01-06 12:23:50.990 | — | — | MWO000759-2021 | 2 |
Showing 3 of 179 rows.