swo_swoqcd_quick_code_dtl
Stores SWO part serial and lot details for traceability. This table maintains serial numbers, lot numbers, and batch information for parts used in maintenance operations, ensuring complete traceability and compliance.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Quick code definitions used in SWO processes
Primary key
replication_key
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | created_area_code | Char | Indicates the area code where the record or task was created |
| 2 | REPLICATION_KEY | Bigint | Key used for replication purposes across systems |
| 3 | swoqcd_createdby | varchar | Records the user who created the entry |
| 4 | swoqcd_createddate | datetime | Captures the date and time when the entry was created |
| 5 | swoqcd_desc | varchar | Description of the quick code or reference entry |
| 6 | swoqcd_modifiedby | varchar | Records the user who last modified the entry |
| 7 | swoqcd_modifieddate | datetime | Captures the date and time of the last modification |
| 8 | swoqcd_ouinstance | int | Identifies the organizational unit instance associated with the entry |
| 9 | swoqcd_qcd_category | varchar | Specifies the category for the quick code |
| 10 | swoqcd_qcd_code | varchar | Code representing the quick reference entry |
| 11 | swoqcd_status | varchar | Indicates the current status of the quick code |
| 12 | swoqcd_timestamp | int | Timestamp for record tracking |
Sample rows (from live DB)
created_area_code | REPLICATION_KEY | swoqcd_createdby | swoqcd_createddate | swoqcd_desc | swoqcd_modifiedby |
|---|---|---|---|---|---|
| — | — | DMUSER | 2020-06-04 15:00:16.437 | Pilot Reported | — |
| — | — | DMUSER | 2020-06-04 15:00:17.373 | Mechanic Reported | — |
| — | — | DMUSER | 2020-06-04 15:00:17.407 | Applicable | — |
Showing 3 of 1,368 rows.