wc_wccap_capacity
This is a work center master table that stores work center capacity details. It provides reference data used by transaction tables to allocate resources, assign capacity, and map facilities or certificates to operations.
Process: MAINTPLANNING · Component: BASWc · Table type: Master table Category: Defines master setup of work centers, facilities, capacity, and certifications that transactions reference for planning and execution.
Primary key
wccap_uniqueid
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wccap_uniqueid 🔑 | int | Unique identification for work center capability |
| 2 | wccap_ou | varchar | Organization Unit instance |
| 3 | wccap_wc | varchar | Work Center code |
| 4 | wccap_mntobjtyp | varchar | Maintenance object type |
| 5 | wccap_model | varchar | Model associated with capability |
| 6 | wccap_prt | numeric | Part associated with capability |
| 7 | wccap_qty | int | Quantity of the capability |
| 8 | wccap_timestamp | varchar | Timestamp of the capability record |
| 9 | wccap_createdby | Datetime | Created by user |
| 10 | wccap_createddate | varchar | Creation date of the capability |
| 11 | wccap_modifiedby | Datetime | Modified by user |
| 12 | wccap_modifieddate | #N/A | Modification date of the capability |
Sample rows (from live DB)
wccap_uniqueid | wccap_ou | wccap_wc | wccap_mntobjtyp | wccap_model | wccap_prt |
|---|---|---|---|---|---|
| -2147483648 | 2 | 10 | AM | 008-200 | — |
| -2147483647 | 2 | 10 | P | — | :35895 |
| -2147483646 | 2 | 100-02 | AM | 0612 | — |
Showing 3 of 21 rows.