swo_wsa_amend_hdr
Workscope : Amendment Header
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Provides header-level information for amendments applied to shop work orders, serving as a control and summary layer for detailed amendment records
Primary key
wsa_uniqueid
Columns (18)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wsa_amend_no | varchar | Recommendation notes |
| 2 | wsa_amend_notes | varchar | Reason for amendment |
| 3 | wsa_amend_reason | varchar | Amendment status |
| 4 | wsa_amend_status | varchar | Amendment shop work order number |
| 5 | wsa_amend_swono | varchar | User who created the record |
| 6 | wsa_createdby | datetime | Date when the record was created |
| 7 | wsa_createddate | varchar | User who modified the record |
| 8 | wsa_modifiedby | datetime | Date when the record was modified |
| 9 | wsa_modifieddate | int | Organization unit instance |
| 10 | wsa_ouinstance | int | Timestamp of the record |
| 11 | wsa_timestamp | bigint | Unique identifier for the record |
| 12 | wsa_uniqueid 🔑 | varchar | User who updated the record |
| 13 | wsa_updatedby | datetime | Date when the record was updated |
| 14 | wsa_updateddate | varchar | Custom user defined field one |
| 15 | wsa_userdefined1 | varchar | Custom user defined field two |
| 16 | wsa_userdefined2 | varchar | Custom user defined field three |
| 17 | wsa_userdefined3 | varchar | Custom user defined field four |
| 18 | wsa_userdefined4 | varchar | User defined 4 |
Sample rows (from live DB)
wsa_amend_no | wsa_amend_notes | wsa_amend_reason | wsa_amend_status | wsa_amend_swono | wsa_createdby |
|---|---|---|---|---|---|
| AMD000098-2023 | — | reson for amend gen | UPD | EWO-001155-2023 | DMUSER |
| AMD000099-2023 | — | — | CNCL | EWO-001155-2023 | DMUSER |
| AMD000100-2023 | — | — | PND | EWO-001155-2023 | DMUSER |
Showing 3 of 388 rows.