swo_swocds_core_disassm_assemble_det
Contains Change Request (CR) details for Shop Work Orders. This table tracks all change requests related to core disassembly and assembly operations, maintaining a complete audit trail of modifications and approvals throughout the maintenance lifecycle.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Core disassembly and assembly operations and details
This table is the canonical store for the CoreDisassembly entity.
Primary key
swocds_seq_no
Columns (107)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swocds_acceptance_ref | varchar | Reference for acceptance of the component. |
| 2 | swocds_adj_act_cost | varchar | Adjusted actual cost of the component. |
| 3 | swocds_ata_no | varchar | ATA chapter number or classification code. |
| 4 | swocds_attach_pending | int | Indicates if attachments are pending (Y/N). |
| 5 | swocds_auto_attach_flag | varchar | Flag indicating automatic attachment (Yes or No). |
| 6 | swocds_basrem_for_reason | varchar | Reason for basis remark. |
| 7 | swocds_cert_reqd_flag | varchar | Indicates if certificate is required (Yes or No). |
| 8 | swocds_cfg_ou | int | Organizational unit configuration. |
| 9 | swocds_createdby | varchar | User who created the record. |
| 10 | swocds_createddt | datetime | Timestamp when the record was created. |
| 11 | swocds_cr_no | varchar | Change request number associated with the component. |
| 12 | swocds_cr_ou | int | Organizational unit for the change request. |
| 13 | swocds_DonorRecFlag | varchar | Indicates donor component status (Yes or No). |
| 14 | swocds_expense_type | varchar | Type of expense associated with the component. |
| 15 | swocds_expensing_policy | varchar | Policy followed for component expenses. |
| 16 | swocds_filename | varchar | Name of the file attached or referenced. |
| 17 | swocds_generated_swo_no | varchar | Generated shop work order number. |
| 18 | swocds_group_id | int | Group identifier for batch processing. |
| 19 | swocds_init_disposition | varchar | Initial disposition of the component. |
| 20 | swocds_in_comp_id | varchar | Incoming component ID. |
| 21 | swocds_in_comp_ou | int | Organizational unit of incoming component. |
| 22 | swocds_in_mfr_part_no | varchar | Manufacturer part number of incoming component. |
| 23 | swocds_in_part_mfr | varchar | Manufacturer of incoming component. |
| 24 | swocds_in_part_no | varchar | Part number of incoming component. |
| 25 | swocds_in_part_ou | int | Organizational unit of incoming part. |
| 26 | swocds_in_part_serialno | varchar | Serial number of incoming part. |
| 27 | swocds_issue_basis | varchar | Basis for issuing the component. |
| 28 | swocds_kit_status | varchar | Status of the kit or assembly. |
| 29 | swocds_latest_flag | varchar | Flag indicating latest record (Yes or No). |
| 30 | swocds_latest_return_no | varchar | Latest return number if applicable. |
| 31 | swocds_level_code | varchar | Code indicating hierarchy level. |
| 32 | swocds_level_no | numeric | Numeric level in hierarchy. |
| 33 | swocds_lot_no_type_no | varchar | Type and number of the lot. |
| 34 | swocds_mkdemcovtrkid | Bigint | Tracking ID for demonstration or coverage. |
| 35 | swocds_modifiedby | varchar | User who last modified the record. |
| 36 | swocds_modifieddt | datetime | Timestamp of last modification. |
| 37 | swocds_modmfrno | varchar | Modified manufacturer number. |
| 38 | swocds_modmfrpartno | varchar | Modified manufacturer part number. |
| 39 | swocds_modpartno | varchar | Modified part number after change. |
| 40 | swocds_mod_serial_no | varchar | Modified serial number of the part. |
| 41 | swocds_mr_docno | varchar | Maintenance request or document number. |
| 42 | swocds_nha_comp_id | varchar | Non-historical assembly component ID. |
| 43 | swocds_nha_comp_ou | int | Organizational unit of the NHA component. |
| 44 | swocds_nha_mfr_part_no | varchar | Manufacturer part number for NHA component. |
| 45 | swocds_nha_part_mfr | varchar | Manufacturer of the NHA part. |
| 46 | swocds_nha_part_no | varchar | Part number of the NHA component. |
| 47 | swocds_nha_part_serialno | varchar | Serial number of the NHA component. |
| 48 | swocds_nonstockable_flag | varchar | Indicates if the component is non-stockable (Yes or No). |
| 49 | swocds_ouinstance | int | Organizational unit instance. |
| 50 | swocds_out_comp_id | varchar | Outgoing component ID. |
| 51 | swocds_out_comp_ou | int | Organizational unit of outgoing component. |
| 52 | swocds_out_mfr_part_no | varchar | Manufacturer part number of outgoing component. |
| 53 | swocds_out_msn | varchar | Manufacturer serial number of outgoing component. |
| 54 | swocds_out_new_lotno | varchar | New lot number after modification. |
| 55 | swocds_out_new_mfg_lotno | varchar | New manufacturing lot number for outgoing part. |
| 56 | swocds_out_part_cond | varchar | Condition of outgoing part. |
| 57 | swocds_out_part_mfr | varchar | Manufacturer of outgoing part. |
| 58 | swocds_out_part_no | varchar | Part number of outgoing component. |
| 59 | swocds_out_part_ou | int | Work scoping revision comments. |
| 60 | swocds_out_part_serialno | varchar | Unique serial number of outgoing part. |
| 61 | swocds_out_qty | numeric | Quantity of outgoing parts. |
| 62 | swocds_out_root_comp_id | varchar | Root component ID for outgoing part. |
| 63 | swocds_part_acc_grp | varchar | Part accounting group. |
| 64 | swocds_part_control_type | varchar | Type of part control. |
| 65 | swocds_part_type | varchar | Part type or category. |
| 66 | swocds_pend_qty | numeric | Pending quantity of parts. |
| 67 | swocds_pos_code | varchar | Position code of the component. |
| 68 | swocds_ppcmkysq | int | Work order or component sequence key. |
| 69 | swocds_prog_notes | varchar | Progress notes for the part or work order. |
| 70 | swocds_reason_for_rmvl | varchar | Reason for removal of part. |
| 71 | swocds_Recon_qty | numeric | Reconciled quantity. |
| 72 | swocds_Recon_remarks | varchar | Reconciliation remarks. |
| 73 | swocds_ref_cr_no | varchar | Reference change request number. |
| 74 | swocds_remarks | varchar | General remarks. |
| 75 | swocds_removal_datetime | datetime | Timestamp of part removal. |
| 76 | swocds_remtype_for_reason | varchar | Reason type for removal. |
| 77 | swocds_repair_agency | varchar | Repair agency responsible. |
| 78 | swocds_repair_no | varchar | Repair reference number. |
| 79 | swocds_repl_obj_type | varchar | Replacement object type. |
| 80 | swocds_Rep_Ctgry | varchar | Replacement category related to the shop work oreder |
| 81 | swocds_request_part | varchar | Requested part for work order. |
| 82 | swocds_required_datetime | datetime | Required date and time for action. |
| 83 | swocds_res_task_code | varchar | Responsible task code. |
| 84 | swocds_res_task_track_id | bigint | Task tracking ID. |
| 85 | swocds_retbin | varchar | Represents what is the return bin for the component. |
| 86 | swocds_retclass | varchar | Return classification. |
| 87 | swocds_retstatus | varchar | Return status. |
| 88 | swocds_returned_qty | numeric | Quantity returned. |
| 89 | swocds_Return_remarks | varchar | Remarks on returned parts. |
| 90 | swocds_return_wh | varchar | Return warehouse location. |
| 91 | swocds_retzone | varchar | Return zone code. |
| 92 | swocds_ret_flag | varchar | Return flag indicator. |
| 93 | swocds_rout_details | varchar | Routing details. |
| 94 | swocds_rout_id | int | Stores the Routing ID |
| 95 | swocds_rout_location | varchar | Routing location |
| 96 | swocds_scrapnote | varchar | Represents the Scrap notes |
| 97 | swocds_scrapnote_lineno | int | Scrap note line number. |
| 98 | swocds_seq_no 🔑 | int | Sequence number for the record. |
| 99 | swocds_serialno_type | varchar | Serial number type. |
| 100 | swocds_sl_no_logic | varchar | Serial number logic. |
| 101 | swocds_sl_no_type_no | varchar | Serial number type number. |
| 102 | swocds_source | varchar | Source of component or part. |
| 103 | swocds_swo_no | varchar | Shop work order number. |
| 104 | swocds_timestamp | int | Record timestamp. |
| 105 | swocds_usr_status | varchar | User status for the part. |
| 106 | swocds_valuation_method | varchar | Valuation method for accounting. |
| 107 | swocds_workcenter | varchar | Workcenter code for the operation. |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_CORE_DISASSY(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocds_core_disassm_assemble_det.swocds_swo_no - SWO has core disassembly
- Join:
Sample rows (from live DB)
swocds_acceptance_ref | swocds_adj_act_cost | swocds_ata_no | swocds_attach_pending | swocds_auto_attach_flag | swocds_basrem_for_reason |
|---|---|---|---|---|---|
| — | — | — | 1.0 | — | — |
| — | — | — | 1.0 | — | Y |
| — | — | — | 1.0 | — | Y |
Showing 3 of 5,033 rows.