BAS_WCLOG_WC_LOGICAL_WC_DTL
This is a work center master table that stores logical work center 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.
This table is the canonical store for the LogicalWorkCenter entity.
Primary key
WCLOG_WORK_CENTER, WCLOG_OUINSTANCE
Columns (13)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | WCLOG_OUINSTANCE 🔑 | varchar | Work center organization unit instance |
| 2 | WCLOG_WORK_CENTER 🔑 | varchar | Work center identifier |
| 3 | WCLOG_DESCRIPTION | varchar | Description of the work center |
| 4 | WCLOG_DESCRIPTION_UP | varchar | Uppercase version of work center description |
| 5 | WCLOG_CATEGORY | varchar | Category of the work center |
| 6 | WCLOG_WC_TYPE | varchar | Type of work center |
| 7 | WCLOG_STATUS | varchar | Current status of the work center |
| 8 | WCLOG_USERID | varchar | User ID associated with work center log |
| 9 | WCLOG_CREATIONDATE | varchar | Work center record creation date |
| 10 | WCLOG_MODIFIEDDATE | varchar | Work center record modified date |
| 11 | WCLOG_MODIFIED_BY | decimal | User who last modified the work center record |
| 12 | WCLOG_TIMESTAMP | varchar | Timestamp of the work center record |
| 13 | wclog_wc_class | varchar | Class of the work center |
Relationships (2)
- AMEPackage (FLOG_TLGMN_TECH_LOG_HDR) →
AT_WORK_CENTER(this table is target)- Join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_WORK_CENTER = BAS_WCLOG_WC_LOGICAL_WC_DTL.WCLOG_WORK_CENTER - AME Package executed at workcenter
- Join:
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
AT_WORK_CENTER(this table is target) (no automatic join)- SWO executed at work center
Sample rows (from live DB)
WCLOG_OUINSTANCE | WCLOG_WORK_CENTER | WCLOG_DESCRIPTION | WCLOG_DESCRIPTION_UP | WCLOG_CATEGORY | WCLOG_WC_TYPE |
|---|---|---|---|---|---|
| 2.0 | 09809 | 09809 | 09809 | — | SHP |
| 2.0 | 10 | WORK CENTER | WORK CENTER | COMPONENT | SHP |
| 2.0 | 100-00 | Reference Work Center for 1… | REFERENCE WORK CENTER FOR 1… | CMC | OTH |
Showing 3 of 1,352 rows.