swo_swocom_com_list
Certificate of Maintenance header table containing reference and authorization details. This table stores the main certificate information including reference numbers, authorization details, issuing authority, and validity periods for maintenance certificates.
Process: COMPMAINTENANCE Β· Component: BasSWO Β· Table type: Transaction Table Category: Certificates including conformity, calibration, and maintenance certifications
This table is the canonical store for the COMList entity.
Primary key
swocom_unique_no
Columns (48)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | sowcom_no_Copies | int | Number of certificate copies issued. |
| 2 | swocom_add_remarks | varchar | Additional remarks or notes related to the certificate or Shop Work Order. |
| 3 | swocom_approved_By | varchar | Name or ID of the person who approved the certificate. |
| 4 | swocom_approved_date | datetime | Date on which the certificate was approved. |
| 5 | swocom_auth_emp_code | varchar | Employee code of the individual performing authentication. |
| 6 | swocom_auth_license_no | varchar | License number used during authentication. |
| 7 | swocom_auth_no | varchar | Unique authentication number assigned. |
| 8 | swocom_auth_ref_no | varchar | Reference number associated with authentication. |
| 9 | swocom_auth_skill_code | varchar | Skill code of the employee performing authentication. |
| 10 | swocom_auth_wc_code | varchar | Work center code where authentication was conducted. |
| 11 | swocom_certificate_id | varchar | Current status of the certificate for the Shop Work Order. |
| 12 | swocom_certificate_status | varchar | Remarks noted during the certification process. |
| 13 | swocom_certifying_remarks | varchar | Type of component or certification activity. |
| 14 | swocom_com_type | varchar | Unique identifier for the core component. |
| 15 | swocom_coreid | bigint | User who created the record. |
| 16 | swocom_created_by | varchar | Date the record was created. |
| 17 | swocom_created_date | datetime | Indicator showing if the record is current or historical. |
| 18 | swocom_current_flag | varchar | Eligibility flag for certification or Shop Work Order processing. |
| 19 | swocom_eligibility | varchar | Filename linked to the certificate or Shop Work Order document. |
| 20 | swocom_filename | varchar | Final status or resolution of the certificate or Shop Work Order. |
| 21 | swocom_final_disposition | varchar | Flag indicating whether inspection was completed. |
| 22 | swocom_Insp_flag | varchar | Date the certificate or document was issued. |
| 23 | swocom_issue_date | datetime | Last date the certificate or document was printed. |
| 24 | swocom_last_printed_on | datetime | Checkbox indicating if maintenance is new. |
| 25 | swocom_maint_chkbx_new | varchar | Checkbox indicating if the component is a prototype. |
| 26 | swocom_maint_chkbx_prototype | varchar | Flag indicating whether the component is a prototype. |
| 27 | swocom_modified_by | varchar | User who last modified the record. |
| 28 | swocom_modified_date | datetime | Date when the record was last modified. |
| 29 | swocom_modified_flag | varchar | Indicator showing whether the record has been modified. |
| 30 | swocom_ouinstance | int | Organizational unit instance associated with the record. |
| 31 | swocom_overhaul_flag | varchar | Flag indicating if an overhaul was performed. |
| 32 | swocom_paper_doc_no | varchar | Paper document number linked to the Shop Work Order. |
| 33 | swocom_ref_doc_date | datetime | Date of the reference document. |
| 34 | swocom_ref_doc_no | varchar | Reference document number. |
| 35 | swocom_ref_doc_rev | varchar | Revision number of the reference document. |
| 36 | swocom_repair_flag | varchar | Flag indicating whether a repair was performed. |
| 37 | swocom_rep_certificate | varchar | Certificate associated with a repair or component replacement. |
| 38 | swocom_shelf_life_exp_date | datetime | Expiry date of the component or certificate. |
| 39 | swocom_swo_event_id | varchar | Event ID linked to the Shop Work Order. |
| 40 | swocom_swo_no | varchar | Shop Work Order number. |
| 41 | swocom_swo_part | varchar | Part number associated with the Shop Work Order. |
| 42 | swocom_swo_serial | varchar | Serial number of the Shop Work Order part. |
| 43 | swocom_tested_flag | varchar | Flag indicating if the component has been tested. |
| 44 | swocom_timestamp | int | Timestamp of record creation or update. |
| 45 | swocom_unique_no π | int | Unique identifier for the record. |
| 46 | swocom_wccert_no | varchar | Work center certificate number. |
| 47 | swocom_work_status | varchar | Current status of the Shop Work Order (e.g., In Progress, Completed). |
| 48 | swo_maint_chkbx_tested | varchar | Number of copies printed for planning documents. |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) β
SWO_HAS_COMLIST(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocom_com_list.swocom_swo_no - SWO has COM list
- Join:
Sample rows (from live DB)
sowcom_no_Copies | swocom_add_remarks | swocom_approved_By | swocom_approved_date | swocom_auth_emp_code | swocom_auth_license_no |
|---|---|---|---|---|---|
| β | test | β | β | 00000011 | β |
| 5.0 | ζ΅θ― δΈΊδΊ θ‘₯ε θ―΄ζ | Aug 26 2022 11:28AM | 2022-08-26 11:28:16.547 | 00000011 | β |
| 1.0 | β | Jul 28 2022 8:32PM | 2022-07-28 20:32:05.010 | 00000011 | β |
Showing 3 of 939 rows.