swo_wsaref_reference_dtl
Workscope : Reference details
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Holds reference information linked to shop work orders, such as external references, document links, or supporting identifiers that provide contextual details
Primary key
wsaref_uniqueid
Columns (17)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wsaref_amend_uniqueid | varchar | Unique identifier for the amendment reference |
| 2 | wsaref_execdocno | varchar | Shop work order number used as reference |
| 3 | wsaref_filename | varchar | File name associated with the reference |
| 4 | wsaref_modifiedby | datetime | User who last modified the reference |
| 5 | wsaref_modifieddate | int | Date when the reference was modified |
| 6 | wsaref_ouinstance | varchar | Organization unit instance associated with the reference |
| 7 | wsaref_refdesc | varchar | Description of the reference |
| 8 | wsaref_refno | varchar | Reference document number |
| 9 | wsaref_refnotes | Bigint | Notes related to the reference |
| 10 | wsaref_reftrackid | varchar | Reference track ID for tracking the reference |
| 11 | wsaref_reftype | varchar | Type of reference, e.g., task, data point, or others |
| 12 | wsaref_reportedby | datetime | Reported by user who created the reference |
| 13 | wsaref_reporteddate | bigint | Date when the reference was reported |
| 14 | wsaref_uniqueid 🔑 | varchar | Unique identifier for the reference record |
| 15 | wsaref_userdefined1 | varchar | User defined field one for custom data |
| 16 | wsaref_userdefined2 | varchar | User defined field two for custom data |
| 17 | wsaref_userdefined3 | Bigint | User defined field three for custom data |
Sample rows (from live DB)
wsaref_amend_uniqueid | wsaref_execdocno | wsaref_filename | wsaref_modifiedby | wsaref_modifieddate | wsaref_ouinstance |
|---|---|---|---|---|---|
| -2147483366 | EWO-001155-2023 | — | DMUSER | 2023-03-20 11:23:39.590 | 2 |
| -2147483350 | EWO-001161-2023 | — | DMUSER | 2023-03-20 18:16:00.000 | 2 |
| -2147483336 | EWO-001161-2023 | — | DMUSER | 2023-03-21 13:49:00.000 | 2 |
Showing 3 of 15 rows.