Swo_exedw_engg_drawing
This table stores engineering drawing information required for maintenance and execution. It includes drawing identifiers, revisions, and references used for carrying out specific tasks.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: stores comprehensive information about engineering drawings that are essential for maintenance and work order execution
This table is the canonical store for the SWOEngDrawing entity.
Primary key
exedw_trackid
Columns (33)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | exedw_createdby | varchar | User who created the document. |
| 2 | exedw_createddt | datetime | Date and time when the document was created. |
| 3 | exedw_doccategory | varchar | Category of the document (e.g., maintenance, technical). |
| 4 | exedw_docrefno | varchar | Reference number of the document. |
| 5 | exedw_docrevno | int | Revision number of the document. |
| 6 | exedw_docstatus | varchar | Current status of the document (e.g., draft, approved). |
| 7 | exedw_docsubject | varchar | Subject or title of the document. |
| 8 | exedw_doctitle | varchar | Full title of the document. |
| 9 | exedw_doctype | varchar | Type of document (e.g., PDF, Word). |
| 10 | exedw_documentno | varchar | Unique document number. |
| 11 | exedw_drwlocation | varchar | Drawing or file location path. |
| 12 | exedw_efffrom | datetime | Effective start date of the document. |
| 13 | exedw_effto | datetime | Effective end date of the document. |
| 14 | exedw_filename | varchar | File name of the document. |
| 15 | exedw_modifiedby | varchar | User who last modified the document. |
| 16 | exedw_modifydt | datetime | Date and time of last modification. |
| 17 | exedw_noofsheets | int | Number of sheets/pages in the document. |
| 18 | exedw_ouinstance | int | Organizational unit instance associated with the document. |
| 19 | exedw_pubdate | datetime | Publication date of the document. |
| 20 | exedw_publisher | varchar | Publisher of the document. |
| 21 | exedw_recdfrom | varchar | Source from which the document was received. |
| 22 | exedw_receiptdt | datetime | Date when the document was received. |
| 23 | exedw_refdocno | varchar | Reference document number. |
| 24 | exedw_refdocou | int | Reference document organizational unit. |
| 25 | exedw_refdoctype | varchar | Reference document type. |
| 26 | exedw_remarks | varchar | Remarks or comments about the document. |
| 27 | exedw_revdate | datetime | Document revision date. |
| 28 | exedw_srcclass | varchar | Source class/type of the document. |
| 29 | exedw_srcno | varchar | Source number associated with the document. |
| 30 | exedw_srcrevno | int | Source revision number. |
| 31 | exedw_srctype | varchar | Type of source. |
| 32 | exedw_timestamp | int | Timestamp of document record. |
| 33 | exedw_webrefno | varchar | Web reference number. |
Sample rows (from live DB)
exedw_createdby | exedw_createddt | exedw_doccategory | exedw_docrefno | exedw_docrevno | exedw_docstatus |
|---|---|---|---|---|---|
| DMUSER | 2017-07-04 11:19:50.373 | InfBull | DR | 1 | A |
| DMUSER | 2017-07-04 11:19:50.373 | InfBull | — | 1 | A |
| DMUSER | 2017-10-10 15:09:31.053 | InfBull | — | 3 | A |
Showing 3 of 40 rows.