swo_eo_reltsk_dtl
This table is designed to track Engineering Order (EO) tasks and related activities across multiple work orders. It ensures that EO-mandated tasks are properly assigned, executed, and monitored within the SWO process.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: designed to comprehensively track all Engineering Order (EO) tasks and associated activities across multiple Shop Work Orders (SWO)
This table is the canonical store for the EORelatedTask entity.
Primary key
(NEXT VALUE FOR [swo_eo_reltsk_dtl_seq])
Columns (24)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swo_eort_createdby | varchar | User who created the engineering order record |
| 2 | swo_eort_createddate | datetime | Date and time when the engineering order record was created |
| 3 | swo_eort_emptypos_flag | varchar | Flag indicating whether the position is empty |
| 4 | swo_eort_eono | varchar | Number assigned to the engineering order |
| 5 | swo_eort_eorevno | int | Revision number of the engineering order |
| 6 | swo_eort_eotsk_flag | varchar | Flag indicating task or related task in the engineering order |
| 7 | swo_eort_jobtype | varchar | Type of job associated with the engineering order |
| 8 | swo_eort_kitdocid | Bigint | Reference to the engineering order’s kitting document |
| 9 | swo_eort_lotno | varchar | Lot number of the part in the engineering order |
| 10 | swo_eort_modifiedby | varchar | User who modified the engineering order record |
| 11 | swo_eort_modifieddate | datetime | Date when the engineering order record was modified |
| 12 | swo_eort_nhapartno | varchar | Next higher assembly part number linked to the engineering order |
| 13 | swo_eort_nhaserialno | varchar | Next higher assembly serial number linked to the engineering order |
| 14 | swo_eort_ouinstance | int | Organizational unit linked with the engineering order |
| 15 | swo_eort_partno | varchar | Part number associated with the engineering order |
| 16 | swo_eort_positioncode | varchar | Position code linked with the part in the engineering order |
| 17 | swo_eort_rootcmpid | varchar | Root component number associated with the engineering order |
| 18 | swo_eort_rootwo | varchar | Root Shop Work Order associated with the engineering order |
| 19 | swo_eort_serialno | varchar | Serial number of the part linked to the engineering order |
| 20 | swo_eort_swono | varchar | Shop Work Order number associated with the engineering order |
| 21 | swo_eort_swotype | varchar | Type of Shop Work Order linked to the engineering order |
| 22 | swo_eort_taskno | varchar | Task number related to the engineering order |
| 23 | swo_eort_trackid | bigint | Tracking ID for the engineering order task |
| 24 | swo_eort_uniqueid | Bigint | Tracking number for the engineering order record |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_EO_RELATED(this table is target) (no automatic join)- SWO task has EO related tasks
Sample rows (from live DB)
swo_eort_createdby | swo_eort_createddate | swo_eort_emptypos_flag | swo_eort_eono | swo_eort_eorevno | swo_eort_eotsk_flag |
|---|---|---|---|---|---|
| DMUSER | 2023-10-27 12:14:23.437 | — | EO-001516-2023 | 0.0 | EO |
| DMUSER | 2023-10-27 12:14:23.437 | — | EO-001512-2023 | 1.0 | EO |
| DMUSER | 2023-10-27 12:14:23.437 | — | EO-001516-2023 | 0.0 | EOREL |
Showing 3 of 1,982 rows.