swo_swp_parameter_dtl
This is a discrepancy parameter master table that stores shop work order parameter details. It standardizes how discrepancies and related parameters are classified so transactional discrepancy records remain consistent.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Master table Category: Provides master definitions for discrepancy categories and parameterization to ensure consistency in discrepancy recording.
Primary key
replication_key
Columns (8)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swp_componentname | varchar | Component name |
| 2 | swp_paramcategory | varchar | Parameter category |
| 3 | swp_paramtype | varchar | Parameter type |
| 4 | swp_paramcode | varchar | Parameter code |
| 5 | swp_paramdesc | int | Parameter description |
| 6 | swp_displayorder | int | Display order for the parameter |
| 7 | swp_langid | datetime | Language ID |
| 8 | swp_creationdate | bigint | Creation date of the parameter |
Sample rows (from live DB)
swp_componentname | swp_paramcategory | swp_paramtype | swp_paramcode | swp_paramdesc | swp_displayorder |
|---|---|---|---|---|---|
| BASSWO | COMBO | MCACTION | REQ | Request | 1.0 |
| BASSWO | COMBO | MCACTION | RET | Return | 2.0 |
| BASSWO | COMBO | COMREQ | N | No | 1.0 |
Showing 3 of 1,341 rows.