swo_swococ_conformity_cert_list
Stores Certificate of Conformity details. This table maintains records of conformity certificates issued for completed maintenance work, ensuring that all repairs and modifications meet specified requirements and industry standards.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Employee time tracking and clock-in/clock-out records
This table is the canonical store for the SWOCertConformity entity.
Primary key
swococ_unique_no
Columns (41)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swococ_approved_By | varchar | User who approved. |
| 2 | swococ_approved_date | datetime | Approval date. |
| 3 | swococ_auth_emp_code | varchar | Employee code for authorization. |
| 4 | swococ_auth_license_no | varchar | License number of authorized person. |
| 5 | swococ_auth_no | varchar | Authorization number. |
| 6 | swococ_auth_ref_no | varchar | Authorization reference number. |
| 7 | swococ_auth_skill_code | varchar | Skill code of authorized employee. |
| 8 | swococ_auth_wc_code | varchar | Workcenter code for authorization. |
| 9 | swococ_certificate_id | varchar | Certificate ID. |
| 10 | swococ_certificate_status | varchar | Status of certificate. |
| 11 | swococ_cert_remarks | varchar | Remarks on certificate. |
| 12 | swococ_chkbx_fabricated | varchar | Checkbox: fabricated (Yes or No). |
| 13 | swococ_chkbx_modified | varchar | Checkbox modified (Yes or No). |
| 14 | swococ_chkbx_new | varchar | Checkbox new (Yes or No). |
| 15 | swococ_chkbx_prototype | varchar | Checkbox prototype (Yes or No). |
| 16 | swococ_created_by | varchar | Record created by. |
| 17 | swococ_created_date | datetime | Record creation date. |
| 18 | swococ_current_flag | varchar | Current flag indicator. |
| 19 | swococ_filename | varchar | Certificate or attachment filename. |
| 20 | swococ_final_disposition | varchar | Final disposition of part. |
| 21 | swococ_issued_doc | varchar | Issued document reference. |
| 22 | swococ_issued_to | varchar | Issued to employee or department. |
| 23 | swococ_issue_date | datetime | Issue date of document or certificate. |
| 24 | swococ_last_printed_on | datetime | Last printed timestamp. |
| 25 | swococ_modified_by | varchar | User who last modified. |
| 26 | swococ_modified_date | datetime | Last modification date. |
| 27 | swococ_no_Copies | int | Number of copies issued. |
| 28 | swococ_ouinstance | int | Organizational unit instance. |
| 29 | swococ_prntcofc | varchar | Print code of certificate. |
| 30 | swococ_prntoptn | varchar | Print option selected. |
| 31 | swococ_ref_doc_date | datetime | Reference document date. |
| 32 | swococ_ref_doc_no | varchar | Reference document number. |
| 33 | swococ_ref_doc_rev | varchar | Reference document revision. |
| 34 | swococ_rep_certificate | varchar | Replacement certificate ID. |
| 35 | swococ_swo_event_id | varchar | Shop work order event ID. |
| 36 | swococ_swo_no | varchar | Shop work order number. |
| 37 | swococ_swo_part | varchar | Part number in work order. |
| 38 | swococ_swo_serial | varchar | Serial number in work order. |
| 39 | swococ_timestamp | int | Record timestamp. |
| 40 | swococ_type_of_work | varchar | Type of work performed. |
| 41 | swococ_unique_no 🔑 | int | Unique record number. |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_CONFORMITY_CERT(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swococ_conformity_cert_list.swococ_swo_no - SWO has conformity certificate
- Join:
Sample rows (from live DB)
swococ_approved_By | swococ_approved_date | swococ_auth_emp_code | swococ_auth_license_no | swococ_auth_no | swococ_auth_ref_no |
|---|---|---|---|---|---|
| ajankovic | 2011-11-30 15:57:37.080 | 00019454 | Z000000 | — | — |
| mdasilva | 2011-12-01 15:48:30.090 | 00067714 | Z000000 | 00067714 | — |
| DMUSER | 2013-07-01 14:38:40.940 | 00000011 | CFM | — | — |
Showing 3 of 22 rows.