swo_swocst_cost_summary
Cost summary information for SWO operations used for financial postings. This table aggregates all costs associated with a work order including labor, materials, overhead, and other expenses for integration with financial systems and reporting.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Financial charges, cost details and summaries
This table is the canonical store for the CostSummary entity.
Primary key
swocst_unique_id
Columns (44)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swocst_ats_flag | varchar | Comments related to the Shop Work Order component task. |
| 2 | swocst_charges_cost | numeric | Contract number linked to the Shop Work Order component task. |
| 3 | swocst_comments | varchar | Cost flag for the Shop Work Order component task. |
| 4 | swocst_contract_no | varchar | Cost level for the Shop Work Order component task. |
| 5 | swocst_cost_flag | varchar | Change order number linked to the Shop Work Order component task. |
| 6 | swocst_cost_level | varchar | Revision number of the change order for the Shop Work Order component task. |
| 7 | swocst_co_no | varchar | User who created the Shop Work Order component task. |
| 8 | swocst_co_rev_no | varchar | Creation date of the Shop Work Order component task. |
| 9 | swocst_created_by | varchar | Facility cost associated with the Shop Work Order component task. |
| 10 | swocst_created_date | datetime | Instance ID for the Shop Work Order component task. |
| 11 | swocst_facility_cost | numeric | Issue cost for the Shop Work Order component task. |
| 12 | swocst_instance_id | varchar | Issue overhead cost for the Shop Work Order component task. |
| 13 | swocst_issue_cost | numeric | JV material or other costs associated with the Shop Work Order component task. |
| 14 | swocst_isu_ohcost | numeric | Labor overhead cost for the Shop Work Order component task. |
| 15 | swocst_jvmat_other_cost | numeric | JV material other cost for the Shop Work Order component task |
| 16 | swocst_labor_ohcost | numeric | Labor overhead cost for the Shop Work Order component task |
| 17 | swocst_modified_by | varchar | Modified by for the Shop Work Order component task |
| 18 | swocst_modified_date | datetime | Modified date for the Shop Work Order component task |
| 19 | swocst_nrtn_ohcost | numeric | Narrative overhead cost for the Shop Work Order component task |
| 20 | swocst_other_cost | numeric | Other cost for the Shop Work Order component task |
| 21 | swocst_ouinstance | int | Organization instance for the Shop Work Order component task |
| 22 | swocst_posted_facility_cost | numeric | Posted facility cost for the Shop Work Order component task |
| 23 | swocst_posted_flag | varchar | Posted flag for the Shop Work Order component task |
| 24 | swocst_posted_other_cost | numeric | Posted other cost for the Shop Work Order component task |
| 25 | swocst_posted_skill_cost | numeric | Posted skill cost for the Shop Work Order component task |
| 26 | swocst_posted_tool_cost | numeric | Posted tool cost for the Shop Work Order component task |
| 27 | swocst_posted_tot_mat_cost | numeric | Posted total material cost for the Shop Work Order component task |
| 28 | swocst_posting_event | varchar | Posting event for the Shop Work Order component task |
| 29 | swocst_ref_doc_date | datetime | Reference document date for the Shop Work Order component task |
| 30 | swocst_ref_doc_no | varchar | Reference document number for the Shop Work Order component task |
| 31 | swocst_ref_doc_type | varchar | Reference document type for the Shop Work Order component task |
| 32 | swocst_return_cost_conf | numeric | Return cost confirmed for the Shop Work Order component task |
| 33 | swocst_return_cost_nconf | numeric | Return cost not confirmed for the Shop Work Order component task |
| 34 | swocst_root_swo_no | varchar | Root Shop Work Order number for the Shop Work Order component task |
| 35 | swocst_rtn_ohcost | numeric | Return overhead cost for the Shop Work Order component task |
| 36 | swocst_skill_cost | numeric | Skill cost for the Shop Work Order component task |
| 37 | swocst_swo_no | varchar | Shop Work Order number for the Shop Work Order component task |
| 38 | swocst_task_code | varchar | Task code for the Shop Work Order component task |
| 39 | swocst_task_track_id | int | Tool cost for the Shop Work Order component task |
| 40 | swocst_tool_cost | numeric | Total material cost for the Shop Work Order component task |
| 41 | swocst_tot_mat_cost | numeric | Total resource cost for the Shop Work Order component task |
| 42 | swocst_tot_res_cost | numeric | Unique ID for the Shop Work Order component task |
| 43 | swocst_unique_id 🔑 | int | Service for the Shop Work Order component task |
| 44 | swosct_service | varchar | Discrepancy number for the Shop Work Order component task |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_COST_SUMMARY(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocst_cost_summary.swocst_swo_no - SWO has cost summary
- Join:
Sample rows (from live DB)
swocst_ats_flag | swocst_charges_cost | swocst_comments | swocst_contract_no | swocst_cost_flag | swocst_cost_level |
|---|---|---|---|---|---|
| — | 0.0 | — | — | MC-UnconfRetn | T |
| — | 0.0 | — | — | RefCost-IssRetVar | T |
| — | 0.0 | — | — | WOCost | T |
Showing 3 of 19,365 rows.