swo_sworc_res_consump_dtl
Contains SWO part tag details for physical identification and tracking. This table manages part tagging information including tag numbers, locations, and status for parts throughout the maintenance process.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Resource consumption tracking for SWO execution
This table is the canonical store for the SWOResource entity.
Primary key
sworc_res_act_seq_no
Columns (22)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | sworc_actual_hrs | numeric | Actual hours spent on the task or resource |
| 2 | sworc_comments | varchar | Comments related to task execution or resource usage |
| 3 | sworc_cost_center | varchar | Identifies the cost center associated with the resource or task |
| 4 | sworc_created_by | varchar | Records the user who created the resource entry |
| 5 | sworc_created_date | datetime | Captures the creation date for the resource entry |
| 6 | sworc_fac_obj_code | varchar | Code for the facility or object associated with the resource |
| 7 | sworc_fin_postingDone | varchar | Flag indicating whether finance posting has been completed |
| 8 | sworc_from_date_time | datetime | Start date and time for the resource usage or task |
| 9 | sworc_modified_by | varchar | Records the user who modified the resource entry |
| 10 | sworc_modified_date | datetime | Captures the modification date for the resource entry |
| 11 | sworc_rep_class | varchar | Classification of the repair performed |
| 12 | sworc_res_act_seq_no 🔑 | bigint | Unique identifier for resource estimation details |
| 13 | sworc_res_code | varchar | Code identifying the resource |
| 14 | sworc_res_cost | numeric | Cost associated with the resource |
| 15 | sworc_res_ouinstance | int | Organizational unit instance for the resource |
| 16 | sworc_res_seq_no | bigint | Sequence number linking to resource estimation details |
| 17 | sworc_res_type | varchar | Type of the resource |
| 18 | sworc_task_track_id | bigint | Task track ID for discrepancies or observations |
| 19 | sworc_timestamp | int | Timestamp for resource record tracking |
| 20 | sworc_to_date_time | datetime | End date and time for the resource usage or task |
| 21 | sworc_used_nos | numeric | Number of resources used |
| 22 | sworc_used_uom | varchar | Unit of measure for the resources used |
Sample rows (from live DB)
sworc_actual_hrs | sworc_comments | sworc_cost_center | sworc_created_by | sworc_created_date | sworc_fac_obj_code |
|---|---|---|---|---|---|
| 3.0 | — | 7910 | DMUSER | 2013-04-05 10:25:59.977 | C7219 |
| 8.0 | — | 2220 | DMUSER | 2013-04-05 10:26:12.380 | TFAB-000004-2012 |
| 12.0 | — | 7410 | DMUSER | 2013-04-05 10:26:12.970 | A5349 |
Showing 3 of 2,646 rows.