swo_prtmfg_certificate_dtl
Holds detailed records of manufacturing certificates for parts. It is used to validate part authenticity, track compliance with regulatory standards, and maintain quality assurance for all components used in maintenance tasks
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Part Manufacturing Certificate Details
This table is the canonical store for the MfgCertificate entity.
Primary key
swo_mfgcer_trackid
Columns (11)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swo_mfgcer_auth | varchar | Authority for manufacturing certificate |
| 2 | swo_mfgcer_cso_lineno | int | Customer service order line number |
| 3 | swo_mfgcer_cso_no | varchar | Customer service order number |
| 4 | swo_mfgcer_cso_revno | Int | Customer service order revision number |
| 5 | swo_mfgcer_isscer | varchar | Manufacturing issue certificate flag |
| 6 | swo_mfgcer_ouinstance | int | Organizational unit instance for certificate |
| 7 | swo_mfgcer_prtno | varchar | Part number for manufacturing certificate |
| 8 | Swo_mfgcer_refdocno | varchar | Reference document number for certificate |
| 9 | swo_mfgcer_remarks | varchar | Remarks for manufacturing certificate |
| 10 | swo_mfgcer_req | varchar | Request information for manufacturing certificate |
| 11 | swo_mfgcer_type | varchar | Type of manufacturing certificate |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_MFG_CERT(this table is target) (no automatic join)- SWO has manufacturing certificate
Sample rows (from live DB)
swo_mfgcer_auth | swo_mfgcer_cso_lineno | swo_mfgcer_cso_no | swo_mfgcer_cso_revno | swo_mfgcer_isscer | swo_mfgcer_ouinstance |
|---|---|---|---|---|---|
| — | — | — | — | 2 | |
| FAA | — | — | — | — | 2 |
| FAA | — | — | — | — | 2 |
Showing 3 of 25,091 rows.