swo_swocrgh_charge_details_his
Current estimation details for charges associated with maintenance work orders. This table stores labor costs, material costs, overhead charges, and other financial details related to shop work orders for accurate billing and cost management.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Financial charges, cost details and summaries
Primary key
replication_key
Columns (17)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | REPLICATION_KEY | Bigint | Flag indicating if the charge is billable. |
| 2 | swocrgh_baseline_rev_no | int | Code assigned to the charge. |
| 3 | swocrgh_billable_flag | varchar | Sequence number for the charge. |
| 4 | swocrgh_charge_code | varchar | User who created the charge record. |
| 5 | swocrgh_charge_seq_no | bigint | Date when the charge record was created. |
| 6 | swocrgh_created_by | varchar | Remarks related to charge estimation. |
| 7 | swocrgh_created_date | datetime | Class or category of the charge report. |
| 8 | swocrgh_estimation_remarks | varchar | Task tracking ID associated with the charge. |
| 9 | swocrgh_modified_by | varchar | Total Charge Detail (TCD) amount. |
| 10 | swocrgh_modified_date | datetime | Currency of the TCD amount. |
| 11 | swocrgh_rep_class | varchar | Variant code for the charge. |
| 12 | swocrgh_task_track_id | bigint | Organizational unit instance linked to the cost. |
| 13 | swocrgh_tcd_amount | numeric | Account usage code for the cost. |
| 14 | swocrgh_tcd_currency | varchar | Amount linked to the cost entry. |
| 15 | swocrgh_timestamp | int | Baseline revision number for the cost. |
| 16 | swocrgh_variant_code | varchar | Flag indicating if the cost is billable. |
| 17 | swocrg_ouinstance | int | Charge code associated with the cost. |