swo_swocpl_certficate_print_log
Contains print log details for certificates. Records are inserted when Approve and Print or Reprint buttons are clicked, maintaining a complete audit trail of certificate printing activities including timestamps, user information, and print counts.
Process: COMPMAINTENANCE 路 Component: BasSWO 路 Table type: Transaction Table Category: Financial charges, cost details and summaries
This table is the canonical store for the SWOCertPrintLog entity.
Primary key
swocpl_unique_id
Columns (11)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swocpl_no_of_copies | int | User who printed the planning document. |
| 2 | swocpl_printed_by | varchar | Date when the planning document was printed. |
| 3 | swocpl_printed_on | datetime | Event ID associated with the planning document. |
| 4 | swocpl_swo_event_id | varchar | Shop Work Order number for planning. |
| 5 | swocpl_swo_no | varchar | Part number linked to the planning document. |
| 6 | swocpl_swo_part | varchar | Serial number associated with the planning. |
| 7 | swocpl_swo_serial | varchar | Certificate ID linked to Shop Work Order planning. |
| 8 | swocpl_tag_Cert_id | varchar | Type of certificate linked to planning. |
| 9 | swocpl_tag_Cert_type | varchar | Organizational unit linked to certificate or planning. |
| 10 | swocpl_tag_OU | int | Unique identifier for the planning record. |
| 11 | swocpl_unique_id 馃攽 | int | Baseline revision number for the charge. |
Sample rows (from live DB)
swocpl_no_of_copies | swocpl_printed_by | swocpl_printed_on | swocpl_swo_event_id | swocpl_swo_no | swocpl_swo_part |
|---|---|---|---|---|---|
| 1 | DMUSER | 2013-04-19 11:56:00.623 | JK5T | EWO-000055-2011 | 6078T27G01:07482 |
| 1 | DMUSER | 2013-06-04 10:19:15.440 | CO-007077-2013 | CWO-007707-2013 | 11404-005:2D671 |
| 1 | DMUSER | 2013-06-07 17:58:02.790 | CO-007103-2013 | CWO-007744-2013 | 11404-005:2D671 |
Showing 3 of 957 rows.