swo_swocrg_charge_details
Historical records for estimation details of charges. This table maintains a complete history of all charge modifications and updates, providing audit trails for financial transactions and cost estimations throughout the maintenance process.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Financial charges, cost details and summaries
This table is the canonical store for the ChargeDetail entity.
Primary key
swocrg_charge_seq_no, swocrg_task_track_id
Columns (19)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swocrg_acct_usage | varchar | Sequence number for the cost charge. |
| 2 | swocrg_amount | numeric | Cost center responsible for the accounting entry. |
| 3 | swocrg_baseline_rev_no | int | User who created the cost record. |
| 4 | swocrg_billable_flag | varchar | Date the cost record was created. |
| 5 | swocrg_charge_code | varchar | Currency of the cost. |
| 6 | swocrg_charge_seq_no 🔑 | bigint | Current revision number of the cost record. |
| 7 | swocrg_cost_center | varchar | Remarks related to cost estimation. |
| 8 | swocrg_created_by | varchar | User who last modified the cost record. |
| 9 | swocrg_created_date | datetime | Date of modification. |
| 10 | swocrg_currency | varchar | Organizational unit instance associated with the cost record. |
| 11 | swocrg_curr_rev_no | int | Report class for the cost record. |
| 12 | swocrg_est_remarks | varchar | Task tracking ID linked to the cost record. |
| 13 | swocrg_modified_by | varchar | Timestamp of the cost record. |
| 14 | swocrg_modified_date | datetime | Variant code associated with the cost. |
| 15 | swocrg_ouinstance | int | Task tracking ID for the Shop Work Order component task. |
| 16 | swocrg_rep_class | varchar | Timestamp of the Shop Work Order component task entry. |
| 17 | swocrg_task_track_id 🔑 | bigint | Variant code for the Shop Work Order component task. |
| 18 | swocrg_timestamp | int | ATS (Authorization to Ship) flag for the Shop Work Order component task. |
| 19 | swocrg_variant_code | varchar | Cost charges associated with the Shop Work Order component task. |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_CHARGE(this table is target)- Join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swocrg_charge_details.swocrg_task_track_id - SWO task has charge details
- Join:
Sample rows (from live DB)
swocrg_acct_usage | swocrg_amount | swocrg_baseline_rev_no | swocrg_billable_flag | swocrg_charge_code | swocrg_charge_seq_no |
|---|---|---|---|---|---|
| — | 150.0 | 1 | — | 01 | 4 |
| — | 100.0 | 1 | — | UNRECOV | 5 |
| — | 10.0 | 1 | — | UNRECOV | 7 |
Showing 3 of 4 rows.