swo_swoah_shop_wo_addl_hdr
Contains additional header-level comments for SWO shop work orders. It provides context, special instructions, or notes required for execution and review of work orders
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: SWO Associated Main Core Details
This table is the canonical store for the SWOAdditionalHeader entity.
Primary key
swoad_unique_id
Columns (18)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | shoad_cust_warr_notes | varchar | Notes regarding customer warranty |
| 2 | swoad_cancel_comments | varchar | Comments on work order cancellation |
| 3 | swoad_cust_work_request | varchar | Additional comments on work requested by customer |
| 4 | swoad_disc_ref | varchar | Reference to the reported discrepancy |
| 5 | swoad_disposition_remarks | varchar | Remarks on the disposition of the work order |
| 6 | swoad_est_remarks | varchar | Remarks on work estimation |
| 7 | swoad_final_mov_remarks | varchar | Final movement remarks |
| 8 | swoad_finding_summary | varchar | Summary of findings in the report |
| 9 | swoad_job_card_ref | varchar | Reference number of job card |
| 10 | swoad_mfg_addrmks | varchar | Additional remarks from manufacturing |
| 11 | swoad_mfg_usrden1 | varchar | User-defined field 1 in manufacturing |
| 12 | swoad_mfg_usrden2 | varchar | User-defined field 2 in manufacturing |
| 13 | swoad_mod_inst | varchar | Instructions for modification |
| 14 | swoad_progress_notes | varchar | Progress notes in Review Part Readiness log |
| 15 | swoad_unique_id 🔑 | bigint | Unique identifier for the record |
| 16 | swoad_work_request | varchar | Work requested description |
| 17 | swoad_wrk_scp_comments | varchar | Comments on work scope |
| 18 | swoad_wsrev_comments | varchar | Work scoping revision comments |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_ADDITIONAL_HDR(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_unique_id = swo_swoah_shop_wo_addl_hdr.swoad_unique_id - SWO has additional header info
- Join:
Sample rows (from live DB)
shoad_cust_warr_notes | swoad_cancel_comments | swoad_cust_work_request | swoad_disc_ref | swoad_disposition_remarks | swoad_est_remarks |
|---|---|---|---|---|---|
| — | — | — | — | — | — |
| — | — | — | — | — | — |
| — | — | — | — | — | — |
Showing 3 of 25,075 rows.