swo_swocom_certtype_apr_att
Maps certificate types to attribute codes for SWO operations. This configuration table establishes relationships between different certificate types and their associated attributes, enabling proper certificate classification and processing.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Certificates including conformity, calibration, and maintenance certifications
Primary key
swocom_certificate_id
Columns (5)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swocom_att_code | varchar | Attribute code linked to the Shop Work Order. |
| 2 | swocom_att_value | varchar | Value corresponding to the certificate or attribute for the Shop Work Order. |
| 3 | swocom_certificate_id 🔑 | varchar | Unique identifier of the certificate for the Shop Work Order. |
| 4 | swocom_certificate_type | varchar | Type or category of the certificate issued. |
| 5 | swocom_ou | int | Organizational unit responsible for the certificate. |
Sample rows (from live DB)
swocom_att_code | swocom_att_value | swocom_certificate_id | swocom_certificate_type | swocom_ou |
|---|---|---|---|---|
| B10SL | 1 | 2878C8A8-D83A-4C1B-9F34-8100B9 | — | 2 |
| B10SL | 1 | 2937BE6E-CEF3-4624-BB9A-8DDAEC | — | 2 |
| B10SL | 1 | 684F7ABA-77A0-4D7D-9A51-692D48 | — | 2 |
Showing 3 of 100 rows.