swo_wsatsk_task_amend_dtl
Workscope : Amendment details
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Maintains detailed information about amendments made directly to tasks, including modified task attributes, updated requirements, and execution changes
This table is the canonical store for the TaskAmendDetail entity.
Primary key
wsatsk_wstasktrackid
Columns (31)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wsatsk_amend_no | bigint | Amendment unique identifier |
| 2 | wsatsk_amend_uniqueid | varchar | Change type indicating addition or removal of work scoping or engineering orders |
| 3 | wsatsk_changetype | varchar | User who created the task |
| 4 | wsatsk_created_by | datetime | Date when the task was created |
| 5 | wsatsk_created_date | varchar | Engineering document number |
| 6 | wsatsk_engdocno | varchar | Engineering document revision number |
| 7 | wsatsk_engdocrev | varchar | Not applicable field to be removed |
| 8 | wsatsk_execaction | varchar | Level code for the task |
| 9 | wsatsk_levelcode | varchar | User who modified the task |
| 10 | wsatsk_modified_by | datetime | Date when the task was modified |
| 11 | wsatsk_modified_date | int | Organization unit instance |
| 12 | wsatsk_ouinstance | varchar | Part number |
| 13 | wsatsk_partno | varchar | Piece part flag |
| 14 | wsatsk_piecepartflag | varchar | Position code |
| 15 | wsatsk_poscode | varchar | Remarks |
| 16 | wsatsk_remarks | varchar | Repair agency |
| 17 | wsatsk_repagency | varchar | Reason for non-execution |
| 18 | wsatsk_rsnnonexec | int | Screen row number |
| 19 | wsatsk_scr_row_no | int | Existing work scoping task repeat sequence number |
| 20 | wsatsk_seqno | varchar | Serial number |
| 21 | wsatsk_serialno | varchar | Source of the task when coming from a visit |
| 22 | wsatsk_source | varchar | Context shop work order |
| 23 | wsatsk_swono | varchar | Context shop work order type |
| 24 | wsatsk_swotype | varchar | Task number |
| 25 | wsatsk_task | bigint | Line level unique identifier |
| 26 | wsatsk_uniqueid | bigint | Visit reference ID |
| 27 | wsatsk_visit_line_keyid | varchar | Work center |
| 28 | wsatsk_workcenter | varchar | Flag indicating work order specificity |
| 29 | wsatsk_wo_specific | varchar | Existing work scoping task number |
| 30 | wsatsk_wstask | Bigint | Existing work scoping task track ID |
| 31 | wsatsk_wstasktrackid 🔑 | varchar | Amendment number |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
TASK_HAS_AMEND_DETAIL(this table is target) (no automatic join)- SWO task has amendment detail
Sample rows (from live DB)
wsatsk_amend_no | wsatsk_amend_uniqueid | wsatsk_changetype | wsatsk_created_by | wsatsk_created_date | wsatsk_engdocno |
|---|---|---|---|---|---|
| AMD001092-2023 | -2147483328 | UPG | DMUSER | 2023-03-21 18:24:49.820 | — |
Showing 1 of 1 rows.