swo_swoprt_part_details
Stores SWO task parameter details including task specifications, requirements, tolerances, and acceptance criteria. This table defines the technical parameters and standards that must be met for each maintenance task.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Details of parts associated with SWO tasks
This table is the canonical store for the SWOPart entity.
Primary key
swoprt_part_seq_no, swoprt_task_track_id
Columns (77)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoepd_plan_unplan_flag | varchar | Flag to identify part requirement added in estimation or execution |
| 2 | swoprt_alt_mfrno | varchar | Manufacturer for alternate part number |
| 3 | swoprt_alt_mfrpart_no | varchar | Manufacturer part number for alternate |
| 4 | swoprt_alt_part_no | varchar | Alternate part number |
| 5 | swoprt_alt_type | varchar | Alternate part type |
| 6 | swoprt_baseline_rev_no | int | Baseline revision number incremented on confirmation |
| 7 | swoprt_billable_flag | varchar | Billable flag |
| 8 | swoprt_bin | varchar | Indicates the storage or location bin assigned for the part or component in the system |
| 9 | swoprt_coa_flag | varchar | Flag indicating whether a Certificate of Authenticity (COA) is required or associated with the part |
| 10 | swoprt_confirmed_qty | numeric | Confirmed quantity during confirmation |
| 11 | swoprt_core_cr_id | bigint | Unique link to associate core details |
| 12 | swoprt_core_cr_type | varchar | Flag identifying core type |
| 13 | swoprt_created_by | varchar | Created by |
| 14 | swoprt_created_date | datetime | Created date |
| 15 | swoprt_curr_rev_no | int | Current revision number |
| 16 | swoprt_dem_id | Bigint | Material demand tracking number |
| 17 | swoprt_effect_flag | varchar | Indicates whether the part or component is effective or applicable for a specific configuration, model, or system |
| 18 | swoprt_effect_notes | varchar | Provides detailed notes or comments about the effectivity of the part, such as conditions, limitations, or special instructions for its use |
| 19 | swoprt_est_cost | numeric | Represents the estimated cost associated with the part, component, or work order |
| 20 | swoprt_est_done | varchar | Flag indicating estimation completion |
| 21 | swoprt_est_qty | numeric | Estimated quantity |
| 22 | swoprt_est_remarks | varchar | Estimation remarks |
| 23 | swoprt_exchange_flag | varchar | Flag for exchange order creation |
| 24 | swoprt_iss_qty | numeric | Total issue quantity |
| 25 | swoprt_kitdmdcovtrkid | bigint | Kitting demand coverage tracking number |
| 26 | swoprt_latest_return_no | varchar | Latest return document number |
| 27 | swoprt_mat_type | varchar | Material type (Regular/Main Core) |
| 28 | swoprt_Mcore_ret_remarks | varchar | Return remarks for main core |
| 29 | swoprt_mfr_no | varchar | Manufacturer code |
| 30 | swoprt_mfr_part_no | varchar | Manufacturer part number |
| 31 | swoprt_modified_by | varchar | Modified by |
| 32 | swoprt_modified_date | datetime | Modified date |
| 33 | swoprt_mod_mfrno | varchar | Manufacturer for modified part number |
| 34 | swoprt_mod_mfrpart_no | varchar | Modified manufacturer part number |
| 35 | swoprt_mod_part_no | varchar | Modified part number |
| 36 | swoprt_mrpriority | varchar | MR priority |
| 37 | swoprt_Mr_needdate | datetime | MR need date |
| 38 | swoprt_mr_qty | numeric | Total MR quantity |
| 39 | swoprt_need_frequency | varchar | Need frequency |
| 40 | swoprt_new_part_flag | varchar | Flag identifying new or existing part request |
| 41 | swoprt_ouinstance | int | SWO instance |
| 42 | swoprt_part_condition | Varchar | Part condition |
| 43 | swoprt_part_desc | varchar | Part description |
| 44 | swoprt_part_no | varchar | Part number |
| 45 | swoprt_part_seq_no 🔑 | bigint | Unique ID, primary key |
| 46 | swoprt_Pend_qty | numeric | Pending return quantity |
| 47 | swoprt_PMA_flag | varchar | Flag for PMA part |
| 48 | swoprt_probability | numeric | Probability of part requirement |
| 49 | swoprt_proc_action | varchar | Processing action |
| 50 | swoprt_proc_remarks | varchar | Processing remarks |
| 51 | swoprt_proc_status | varchar | Processing status |
| 52 | swoprt_prtchng_flag | varchar | Flag for part serial change |
| 53 | swoprt_ps_source | varchar | Product structure source |
| 54 | swoprt_ref_doc_lineno | int | Reference document line number |
| 55 | swoprt_ref_doc_no | varchar | Reference document number |
| 56 | swoprt_ref_doc_type | varchar | Reference document type |
| 57 | swoprt_rep_class | varchar | Repair classification |
| 58 | swoprt_request_comments | varchar | Request comments |
| 59 | swoprt_req_mode | varchar | Requested mode |
| 60 | swoprt_req_qty | numeric | Required quantity copied during confirmation |
| 61 | swoprt_return_wh | varchar | Return warehouse |
| 62 | swoprt_ret_flag | varchar | Pending return flag |
| 63 | swoprt_ret_qty | numeric | Total return quantity |
| 64 | swoprt_srcdocno | varchar | Source document number |
| 65 | swoprt_std_qty | numeric | Standard quantity copied during task addition |
| 66 | swoprt_std_rate | numeric | Standard cost of part |
| 67 | swoprt_stock_status | varchar | Stock status |
| 68 | swoprt_task_track_id 🔑 | bigint | Task track ID for part requirement/estimation |
| 69 | swoprt_timestamp | int | Timestamp |
| 70 | swoprt_uom | varchar | Unit of measure |
| 71 | swoprt_used_qty | numeric | Total used quantity |
| 72 | swoprt_warranty_flag | varchar | Warranty flag |
| 73 | swoprt_wh_no | varchar | Warehouse for issue |
| 74 | swoprt_zone | varchar | Specifies the geographical, operational, or functional zone where the part, component, or work order is applicable or assigned |
| 75 | swo_prt_ownagency | varchar | Identifies the unique number or code of the agency or entity that owns the part. Used for tracking ownership and accountability |
| 76 | swo_prt_ownership | varchar | Describes the type or category of ownership for the part, such as company-owned, leased, or customer-provided |
| 77 | swo_prt_ssderflg | varchar | Stock status derivation flag |
Relationships (2)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_PART(this table is target)- Join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swoprt_part_details.swoprt_task_track_id - SWO task has part details
- Join:
SWO_PART_CONSUMPTION→ Part (PRT_PRCRL_CENTRALREFLIST_INFO)- Join:
swo_swoprt_part_details.swoprt_part_no = PRT_PRCRL_CENTRALREFLIST_INFO.PRCRL_PART_NO - SWO part detail for specific part
- Join:
Sample rows (from live DB)
swoepd_plan_unplan_flag | swoprt_alt_mfrno | swoprt_alt_mfrpart_no | swoprt_alt_part_no | swoprt_alt_type | swoprt_baseline_rev_no |
|---|---|---|---|---|---|
| — | — | — | — | — | — |
| — | — | — | — | — | — |
| E | — | — | — | — | 1.0 |
Showing 3 of 64,659 rows.