Wikiยทschemaยทschema/swo-swoah-shop-wo-addl-hdr.md

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)

#ColumnTypeDescription
1shoad_cust_warr_notesvarcharNotes regarding customer warranty
2swoad_cancel_commentsvarcharComments on work order cancellation
3swoad_cust_work_requestvarcharAdditional comments on work requested by customer
4swoad_disc_refvarcharReference to the reported discrepancy
5swoad_disposition_remarksvarcharRemarks on the disposition of the work order
6swoad_est_remarksvarcharRemarks on work estimation
7swoad_final_mov_remarksvarcharFinal movement remarks
8swoad_finding_summaryvarcharSummary of findings in the report
9swoad_job_card_refvarcharReference number of job card
10swoad_mfg_addrmksvarcharAdditional remarks from manufacturing
11swoad_mfg_usrden1varcharUser-defined field 1 in manufacturing
12swoad_mfg_usrden2varcharUser-defined field 2 in manufacturing
13swoad_mod_instvarcharInstructions for modification
14swoad_progress_notesvarcharProgress notes in Review Part Readiness log
15swoad_unique_id ๐Ÿ”‘bigintUnique identifier for the record
16swoad_work_requestvarcharWork requested description
17swoad_wrk_scp_commentsvarcharComments on work scope
18swoad_wsrev_commentsvarcharWork 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

Sample rows (from live DB)

shoad_cust_warr_notesswoad_cancel_commentsswoad_cust_work_requestswoad_disc_refswoad_disposition_remarksswoad_est_remarks
โ€”โ€”โ€”โ€”โ€”โ€”
โ€”โ€”โ€”โ€”โ€”โ€”
โ€”โ€”โ€”โ€”โ€”โ€”

Showing 3 of 25,075 rows.

See also