swo_separated_tsk_swoprt_part_details
Contains backup details of separated tasks along with associated parts. It is used for detailed tracking of part usage per task, inventory reconciliation, and maintenance planning
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Separated Task Support Part Details
Primary key
swoprt_part_seq_no, swoprt_task_track_id
Columns (150)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoepd_plan_unplan_flag | varchar | Flag indicating if task is planned or unplanned |
| 2 | swoprt_alt_mfrno | varchar | Alternate manufacturer number |
| 3 | swoprt_alt_mfrpart_no | varchar | Alternate manufacturer part number |
| 4 | swoprt_alt_part_no | varchar | Alternate part number |
| 5 | swoprt_alt_type | varchar | Type of alternate part |
| 6 | swoprt_baseline_rev_no | int | Baseline revision number of the part |
| 7 | swoprt_billable_flag | varchar | Flag indicating if part is billable |
| 8 | swoprt_bin | varchar | Bin location of the part |
| 9 | swoprt_coa_flag | varchar | Certificate of authenticity flag |
| 10 | swoprt_confirmed_qty | numeric | Confirmed quantity for the part |
| 11 | swoprt_core_cr_id | bigint | Core change request ID associated with part |
| 12 | swoprt_core_cr_type | varchar | Core change request type |
| 13 | swoprt_created_by | varchar | User who created the part record |
| 14 | swoprt_created_date | datetime | Date and time of creation |
| 15 | swoprt_curr_rev_no | int | Current revision number of the part |
| 16 | swoprt_dem_id | Bigint | Demand ID for the part |
| 17 | swoprt_effect_flag | varchar | Effective flag indicating part status |
| 18 | swoprt_effect_notes | varchar | Notes related to part effectiveness |
| 19 | swoprt_est_cost | numeric | Estimated cost for the part |
| 20 | swoprt_est_done | varchar | Flag indicating if estimate is done |
| 21 | swoprt_est_qty | numeric | Estimated quantity required |
| 22 | swoprt_est_remarks | varchar | Remarks for estimate |
| 23 | swoprt_exchange_flag | varchar | Flag indicating if exchange is applicable |
| 24 | swoprt_iss_qty | numeric | Quantity issued |
| 25 | swoprt_latest_return_no | varchar | Latest return number for the part |
| 26 | swoprt_mat_type | varchar | Material type (for example RG or MC) |
| 27 | swoprt_Mcore_ret_remarks | varchar | Remarks for MC returned part |
| 28 | swoprt_mfr_no | varchar | Manufacturer number |
| 29 | swoprt_mfr_part_no | varchar | Manufacturer part number |
| 30 | swoprt_modified_by | varchar | User who modified the part record |
| 31 | swoprt_modified_date | datetime | Date and time of last modification |
| 32 | swoprt_mod_mfrno | varchar | Modified manufacturer number |
| 33 | swoprt_mod_mfrpart_no | varchar | Modified manufacturer part number |
| 34 | swoprt_mod_part_no | varchar | Modified part number |
| 35 | swoprt_Mr_needdate | datetime | Material requirement need date |
| 36 | swoprt_mr_qty | numeric | Material requirement quantity |
| 37 | swoprt_need_frequency | varchar | Frequency of material requirement |
| 38 | swoprt_new_part_flag | varchar | Flag indicating if it is a new part (Y/N) |
| 39 | swoprt_ouinstance | int | Organizational unit instance |
| 40 | swoprt_part_condition | Varchar | Condition of the part |
| 41 | swoprt_part_desc | varchar | Description of the part |
| 42 | swoprt_part_no | varchar | Part number |
| 43 | swoprt_part_seq_no 🔑 | bigint | Part sequence number |
| 44 | swoprt_Pend_qty | numeric | Pending quantity |
| 45 | swoprt_PMA_flag | varchar | PMA flag for the part |
| 46 | swoprt_probability | numeric | Probability for processing action |
| 47 | swoprt_proc_action | varchar | Processing action for the part |
| 48 | swoprt_proc_remarks | varchar | Processing remarks for the part |
| 49 | swoprt_proc_status | varchar | Processing status for the part |
| 50 | swoprt_prtchng_flag | varchar | Part change flag |
| 51 | swoprt_ps_source | varchar | Product structure source |
| 52 | swoprt_ref_doc_lineno | int | Reference document line number |
| 53 | swoprt_ref_doc_no | varchar | Reference document number |
| 54 | swoprt_ref_doc_type | varchar | Reference document type |
| 55 | swoprt_rep_class | varchar | Repair classification |
| 56 | swoprt_request_comments | varchar | Request comments for the part |
| 57 | swoprt_req_mode | varchar | Request mode |
| 58 | swoprt_req_qty | numeric | Required quantity |
| 59 | swoprt_return_wh | varchar | Return warehouse |
| 60 | swoprt_ret_flag | varchar | Return flag indicating part return |
| 61 | swoprt_ret_qty | numeric | Quantity returned |
| 62 | swoprt_srcdocno | varchar | Source document number |
| 63 | swoprt_std_qty | numeric | Standard quantity from task master |
| 64 | swoprt_std_rate | numeric | Standard rate for part |
| 65 | swoprt_stock_status | varchar | Stock status of the part |
| 66 | swoprt_task_track_id 🔑 | bigint | Task tracking ID |
| 67 | swoprt_timestamp | int | Timestamp of the part record |
| 68 | swoprt_uom | varchar | Unit of measure for the part quantity |
| 69 | swoprt_used_qty | numeric | Quantity used |
| 70 | swoprt_warranty_flag | varchar | Warranty flag for the part |
| 71 | swoprt_wh_no | varchar | Warehouse number |
| 72 | swoprt_zone | varchar | Warehouse zone |
| 73 | swo_prt_ownagency | varchar | Owning agency responsible for the part |
| 74 | swo_prt_ownership | varchar | Ownership type of the part |
| 75 | swo_prt_ssderflg | varchar | Flag indicating the stock status derivation of the part |
| 76 | swoepd_plan_unplan_flag | varchar | Flag indicating if the task is planned or unplanned |
| 77 | swoprt_alt_mfrno | varchar | Alternate manufacturer number for the part |
| 78 | swoprt_alt_mfrpart_no | varchar | Alternate manufacturer part number |
| 79 | swoprt_alt_part_no | varchar | Alternate part number |
| 80 | swoprt_alt_type | varchar | Type of alternate part |
| 81 | swoprt_baseline_rev_no | int | Baseline revision number of the part |
| 82 | swoprt_billable_flag | varchar | Flag indicating if the part is billable |
| 83 | swoprt_bin | varchar | Bin location where the part is stored |
| 84 | swoprt_coa_flag | varchar | Certificate of authenticity flag for the part |
| 85 | swoprt_confirmed_qty | numeric | Quantity confirmed for the part |
| 86 | swoprt_core_cr_id | bigint | Core change request ID associated with the part |
| 87 | swoprt_core_cr_type | varchar | Core change request type |
| 88 | swoprt_created_by | varchar | User who created the part record |
| 89 | swoprt_created_date | datetime | Date and time when the part record was created |
| 90 | swoprt_curr_rev_no | int | Current revision number of the part |
| 91 | swoprt_dem_id | Bigint | Demand ID associated with the part |
| 92 | swoprt_effect_flag | varchar | Flag indicating if the part is effective |
| 93 | swoprt_effect_notes | varchar | Notes related to part effectiveness |
| 94 | swoprt_est_cost | numeric | Estimated cost of the part |
| 95 | swoprt_est_done | varchar | Flag indicating if the estimate is complete |
| 96 | swoprt_est_qty | numeric | Estimated quantity required for the part |
| 97 | swoprt_est_remarks | varchar | Remarks related to the estimate |
| 98 | swoprt_exchange_flag | varchar | Flag indicating if part exchange is applicable |
| 99 | swoprt_iss_qty | numeric | Quantity of the part issued |
| 100 | swoprt_latest_return_no | varchar | Latest return number for the part |
| 101 | swoprt_mat_type | varchar | Material type of the part, e.g., RG or MC |
| 102 | swoprt_Mcore_ret_remarks | varchar | Remarks for material core returned |
| 103 | swoprt_mfr_no | varchar | Manufacturer number of the part |
| 104 | swoprt_mfr_part_no | varchar | Manufacturer part number |
| 105 | swoprt_modified_by | varchar | User who last modified the part record |
| 106 | swoprt_modified_date | datetime | Date and time of last modification |
| 107 | swoprt_mod_mfrno | varchar | Modified manufacturer number |
| 108 | swoprt_mod_mfrpart_no | varchar | Modified manufacturer part number |
| 109 | swoprt_mod_part_no | varchar | Modified part number |
| 110 | swoprt_Mr_needdate | datetime | Material requirement need date |
| 111 | swoprt_mr_qty | numeric | Material requirement quantity |
| 112 | swoprt_need_frequency | varchar | Frequency of material requirement |
| 113 | swoprt_new_part_flag | varchar | Flag indicating if the part is new (Yes or No) |
| 114 | swoprt_ouinstance | int | Organizational unit instance for the part |
| 115 | swoprt_part_condition | Varchar | Condition of the part |
| 116 | swoprt_part_desc | varchar | Description of the part |
| 117 | swoprt_part_no | varchar | Part number |
| 118 | swoprt_part_seq_no 🔑 | bigint | Sequence number of the part |
| 119 | swoprt_Pend_qty | numeric | Pending quantity of the part |
| 120 | swoprt_PMA_flag | varchar | PMA flag for the part |
| 121 | swoprt_probability | numeric | Probability associated with part processing |
| 122 | swoprt_proc_action | varchar | Processing action for the part |
| 123 | swoprt_proc_remarks | varchar | Remarks for processing the part |
| 124 | swoprt_proc_status | varchar | Status of part processing |
| 125 | swoprt_prtchng_flag | varchar | Flag indicating if part change occurred |
| 126 | swoprt_ps_source | varchar | Product structure source |
| 127 | swoprt_ref_doc_lineno | int | Reference document line number |
| 128 | swoprt_ref_doc_no | varchar | Reference document number |
| 129 | swoprt_ref_doc_type | varchar | Reference document type |
| 130 | swoprt_rep_class | varchar | Repair classification of the part |
| 131 | swoprt_request_comments | varchar | Comments on the request for the part |
| 132 | swoprt_req_mode | varchar | Request mode for the part |
| 133 | swoprt_req_qty | numeric | Required quantity for the part |
| 134 | swoprt_return_wh | varchar | Warehouse for returning the part |
| 135 | swoprt_ret_flag | varchar | Return flag indicating if the part was returned |
| 136 | swoprt_ret_qty | numeric | Quantity returned |
| 137 | swoprt_srcdocno | varchar | Source document number for the part |
| 138 | swoprt_std_qty | numeric | Standard quantity from task master |
| 139 | swoprt_std_rate | numeric | Standard rate for the part |
| 140 | swoprt_stock_status | varchar | Stock status of the part |
| 141 | swoprt_task_track_id 🔑 | bigint | Task tracking ID for the part |
| 142 | swoprt_timestamp | int | Timestamp of the part record |
| 143 | swoprt_uom | varchar | Unit of measure for the part quantity |
| 144 | swoprt_used_qty | numeric | Quantity of the part used |
| 145 | swoprt_warranty_flag | varchar | Flag indicating warranty status |
| 146 | swoprt_wh_no | varchar | Warehouse number where part is stored |
| 147 | swoprt_zone | varchar | Zone within warehouse where part is located |
| 148 | swo_prt_ownagency | varchar | Owning agency for the part |
| 149 | swo_prt_ownership | varchar | Ownership type for the part |
| 150 | swo_prt_ssderflg | varchar | Stock status derivation flag for the part |
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 |
|---|---|---|---|---|---|
| — | — | — | — | — | — |
| — | — | — | — | — | — |
| — | — | — | — | — | — |
Showing 3 of 75 rows.