Wiki·schema·schema/swo-des-error.md

SWO_DES_ERROR

This table stores detailed error information encountered during work order execution. It may include error codes, messages, timestamps, and references to affected tasks or components.

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Captures comprehensive details of errors encountered during the execution of Shop Work Orders (SWO). It includes error codes, descriptive messages, timestamps, and references to the specific tasks, components, or processes affected by each error

Primary key

replication_key

Columns (9)

#ColumnTypeDescription
1REPLICATION_KEYBigintKey generated for replication
2SWO_defaultseverityintSeverity level of the work order error
3SWO_erroridintIdentifier of the error encountered
4SWO_errormessagevarcharDescription of the error message
5SWO_errorsourcevarcharScreen or task where the error originated
6SWO_languageintLanguage code used for the record
7SWO_RefBRcharBusiness rule referred in the error
8SWO_SPnamevarcharName of the stored procedure that triggered the error
9SWO_tasknamevarcharName of the task linked to the record

Sample rows (from live DB)

REPLICATION_KEYSWO_defaultseveritySWO_erroridSWO_errormessageSWO_errorsourceSWO_language
18200010Description/ATA # cannot be…TSK1
18200011Description/ATA # cannot be…TSK1
18200012Description/ATA # cannot be…TSK1

Showing 3 of 2,842 rows.

See also