swo_swopsl_prefserlno_dtl
Current SWO part requirement details including part numbers, quantities, specifications, and availability status. This table manages all parts needed for maintenance work orders and tracks their procurement and usage.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Preferred serial numbers details for SWO parts
This table is the canonical store for the PrefSerialNo entity.
Primary key
swopsl_unique_id
Columns (29)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swopsl_created_by | varchar | Created by |
| 2 | swopsl_created_date | datetime | Created date |
| 3 | swopsl_dem_id | Bigint | Material demand tracking number |
| 4 | swopsl_latest_return_no | varchar | Latest return document number |
| 5 | swopsl_lot_no | varchar | Lot number |
| 6 | swopsl_mat_type | varchar | Material type (Main Core/Regular) |
| 7 | swopsl_Mcore_ret_remarks | varchar | Return remarks |
| 8 | swopsl_mfg_lot_no | varchar | Manufacturing lot number |
| 9 | swopsl_mfg_serial_no | varchar | Manufacturing serial number |
| 10 | swopsl_mfrpart_no | varchar | Manufacturer code |
| 11 | swopsl_mfr_no | varchar | Manufacturer number |
| 12 | swopsl_modified_by | varchar | Modified by |
| 13 | swopsl_modified_date | datetime | Modified date |
| 14 | swopsl_mod_lotno | varchar | Modified lot number |
| 15 | swopsl_mod_mfrno | varchar | Modified manufacturer number |
| 16 | swopsl_mod_mfrpart_no | varchar | Modified manufacturer part number |
| 17 | swopsl_mod_part_no | varchar | Modified part number |
| 18 | swopsl_mod_serial_no | varchar | Modified serial number |
| 19 | swopsl_ouinstance | int | SWO instance |
| 20 | swopsl_part_no | varchar | Part number |
| 21 | swopsl_part_seq_no | bigint | Link to part requirement/estimation record |
| 22 | swopsl_quantity | numeric | Required quantity |
| 23 | swopsl_return_wh | varchar | Return warehouse |
| 24 | swopsl_ret_flag | varchar | Flag to identify if part needs return |
| 25 | swopsl_ret_quantity | numeric | Pending return quantity |
| 26 | swopsl_seq_no | bigint | Sequence number |
| 27 | swopsl_serial_no | varchar | Serial number |
| 28 | swopsl_task_track_id | bigint | Task track ID for serial/lot requirements |
| 29 | swopsl_unique_id 🔑 | bigint | Unique ID, primary key |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_PREF_SERIAL(this table is target)- Join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swopsl_prefserlno_dtl.swopsl_task_track_id - Task has preferred serial numbers
- Join:
Sample rows (from live DB)
swopsl_created_by | swopsl_created_date | swopsl_dem_id | swopsl_latest_return_no | swopsl_lot_no | swopsl_mat_type |
|---|---|---|---|---|---|
| DMUSER | 2013-03-27 17:51:16.860 | — | — | LOT-010117-2023 | MC |
| DMUSER | 2013-03-27 17:51:16.860 | — | — | LOT-010840-2024 | MC |
| DMUSER | 2013-03-27 18:36:32.233 | — | — | LOT-010117-2023 | MC |
Showing 3 of 19,091 rows.