swo_swortng_routing_dtl
Records resource consumption details including tools, equipment, and facility usage during maintenance operations. This table tracks resource utilization for cost allocation and capacity planning purposes.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Routing information for SWO task execution
This table is the canonical store for the RoutingDetail entity.
Primary key
swortng_routing_id
Columns (45)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swortng_core_lot_no | varchar | Lot number assigned to the component or part for tracking and identification purposes |
| 2 | swortng_created_by | varchar | Name of the person who created the record or entry |
| 3 | swortng_created_date | datetime | Date and time when the record was created |
| 4 | swortng_cr_no | varchar | Change request number associated with the component or part |
| 5 | swortng_current_Loc | varchar | Current location of the component or part within the system or facility |
| 6 | swortng_Disposition | varchar | Disposition code indicating the status or action to be taken on the component |
| 7 | swortng_event | varchar | Event associated with the routing or process of the component |
| 8 | swortng_flag | varchar | Flag used to identify the latest routing details for the component |
| 9 | swortng_from_repagency | varchar | Name of the repair agency from which the component is routed |
| 10 | swortng_from_wc | varchar | Work center from which the component is routed |
| 11 | swortng_from_wcarea | varchar | Area of the work center from which the component originates |
| 12 | swortng_from_WH | varchar | Warehouse from which the component is routed |
| 13 | swortng_genrtd_swo | varchar | Shop work order number corresponding to the routed part |
| 14 | swortng_kitdmdcovtrkid | bigint | Tracking number for kitting demand coverage |
| 15 | swortng_kitentity | varchar | Entity responsible for kitting activities |
| 16 | swortng_mfrNo | varchar | Manufacturer identification number of the component |
| 17 | swortng_mfrPrtNo | varchar | Part number issued by the manufacturer |
| 18 | swortng_modified_by | varchar | Name of the person who last modified the record |
| 19 | swortng_modified_date | datetime | Date and time when the record was last modified |
| 20 | swortng_MR_doc_no | varchar | Material request number related to the component |
| 21 | swortng_ou_instance | int | Operating unit instance associated with the record |
| 22 | swortng_parent_prtno | varchar | Parent part number associated with the current component |
| 23 | swortng_parent_srlno | varchar | Parent serial number associated with the current component |
| 24 | swortng_part_no | varchar | Unique part number of the component |
| 25 | swortng_print_status | varchar | Status indicating whether the part has been printed |
| 26 | swortng_ReasonFrRmvl | varchar | Reason for removal of the component from the system or assembly |
| 27 | swortng_refdoc_no | varchar | Reference document number associated with the component or task |
| 28 | swortng_refdoc_typ | varchar | Type of reference document linked to the component |
| 29 | swortng_rem_from_ac | varchar | Information regarding part or aircraft removal |
| 30 | swortng_Rep_Ctgry | varchar | Category specifying the type of repair performed |
| 31 | swortng_rep_shopno | varchar | Number identifying the repair shop for external routing |
| 32 | swortng_ReqDate | datetime | Required date for the task or component to be completed or delivered |
| 33 | swortng_return_WC | varchar | Work center to which the component is returned after routing |
| 34 | swortng_return_WH | varchar | Warehouse to which the component is returned after routing |
| 35 | swortng_Routing_dtl | varchar | Detailed routing instructions for the component |
| 36 | swortng_routing_id 🔑 | int | Unique identifier used as the primary key for the routing record |
| 37 | swortng_routing_qty | numeric | Quantity of components involved in the routing process |
| 38 | swortng_routing_status | varchar | Status of the routing indicating progress or completion |
| 39 | swortng_ro_no | varchar | Repair order number associated with the component |
| 40 | swortng_serial_no | varchar | Serial number of the component |
| 41 | swortng_task_track_id | bigint | Task tracking identification number associated with the record |
| 42 | swortng_timestamp | int | Date and time when the record was created or updated in the system |
| 43 | swortng_to_wc | varchar | Work center to which the component is routed |
| 44 | swortng_to_wcarea | varchar | Area of the work center to which the component is routed |
| 45 | swortng_wrk_req | varchar | Description of the work requested on the component |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_ROUTING(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_ro_no = swo_swortng_routing_dtl.swortng_ro_no - SWO has routing details
- Join:
Sample rows (from live DB)
swortng_core_lot_no | swortng_created_by | swortng_created_date | swortng_cr_no | swortng_current_Loc | swortng_Disposition |
|---|---|---|---|---|---|
| — | DMUSER | 2013-03-22 17:06:42.553 | — | — | 1-REPAIR |
| — | DMUSER | 2013-04-01 11:40:22.490 | — | — | 2-RETURN AS IS |
| — | DMUSER | 2013-04-01 11:51:33.787 | — | — | 2-RETURN AS IS |
Showing 3 of 23,412 rows.