BAS_WC_WCWHM_WH_MAP
This is a work center master table that maps work centers to warehouses. 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
WCWHM_WORK_CENTER, WCWHM_PART_TYPE, WCWHM_OUINSTANCE
Columns (58)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | WCWHM_OUINSTANCE 馃攽 | varchar | Work center warehouse mapping organization unit instance |
| 2 | WCWHM_WORK_CENTER 馃攽 | varchar | Work center identifier |
| 3 | WCWHM_PART_TYPE 馃攽 | varchar | Part type managed in the warehouse |
| 4 | WCWHM_ISSUE_WH_CODE | decimal | Issue warehouse code |
| 5 | WCWHM_ISSUE_WH_OU | varchar | Issue warehouse organization unit |
| 6 | WCWHM_RETURN_WH_CODE | decimal | Return warehouse code |
| 7 | WCWHM_RETURN_WH_OU | varchar | Return warehouse organization unit |
| 8 | WCWHM_RET_CORES_WH_CODE | decimal | Return cores warehouse code |
| 9 | WCWHM_RET_CORES_WH_OU | varchar | Return cores warehouse organization unit |
| 10 | WCWHM_BACKFLUSH_FLAG | varchar | Flag for backflush applicability |
| 11 | WCWHM_AUTORETURN | varchar | Flag indicating automatic return |
| 12 | WCWHM_CustServShipping_WH_code | int | Customer service shipping warehouse code |
| 13 | WCWHM_CustServShipping_WH_OU | varchar | Customer service shipping warehouse organization unit |
| 14 | WCWHM_CustUSShipping_WH_code | int | Customer US shipping warehouse code |
| 15 | WCWHM_CustUSShipping_WH_OU | varchar | Customer US shipping warehouse organization unit |
| 16 | WCWHM_ExtRepair_WH_code | int | External repair warehouse code |
| 17 | WCWHM_ExtRepair_WH_OU | varchar | External repair warehouse organization unit |
| 18 | WCWHM_Scrap_WH_code | int | Scrap warehouse code |
| 19 | WCWHM_Scrap_WH_OU | varchar | Scrap warehouse organization unit |
| 20 | WCWHM_USReceiving_WH_code | int | US receiving warehouse code |
| 21 | WCWHM_USReceiving_WH_OU | varchar | US receiving warehouse organization unit |
| 22 | WCWHM_ExServ_ReturnWH_code | int | Ex-service return warehouse code |
| 23 | WCWHM_ExServ_ReturnWH_OU | varchar | Ex-service return warehouse organization unit |
| 24 | WCWHM_ExcReturn_Policy | varchar | Excess return policy |
| 25 | WCWHM_RepRcpt_WH_code | int | Repair receipt warehouse code |
| 26 | WCWHM_RepRcpt_WH_OU | varchar | Repair receipt warehouse organization unit |
| 27 | WCWHM_Serv_RemretWH_code | varchar | Service removal or return warehouse code |
| 28 | WCWHM_Serv_return_policy | varchar | Service return policy |
| 29 | WCWHM_Cust_RemretWH_code | decimal | Customer removal or return warehouse code |
| 30 | WCWHM_OUINSTANCE 馃攽 | varchar | Revision number of the task |
| 31 | WCWHM_WORK_CENTER 馃攽 | varchar | Flag indicating if the code is a work area or a zone (W for Work Area, Z for Zone) |
| 32 | WCWHM_PART_TYPE 馃攽 | varchar | Work area or zone code |
| 33 | WCWHM_ISSUE_WH_CODE | decimal | Model number due to touch point addition |
| 34 | WCWHM_ISSUE_WH_OU | varchar | Model created Organization Unit instance in Aircraft Component |
| 35 | WCWHM_RETURN_WH_CODE | decimal | Model number |
| 36 | WCWHM_RETURN_WH_OU | varchar | Universal Task Identifier |
| 37 | WCWHM_RET_CORES_WH_CODE | decimal | Task card key |
| 38 | WCWHM_RET_CORES_WH_OU | varchar | Unique identification |
| 39 | WCWHM_BACKFLUSH_FLAG | varchar | Task number |
| 40 | WCWHM_AUTORETURN | varchar | Revision number of the task |
| 41 | WCWHM_CustServShipping_WH_code | int | Non-routine task name based on which routine task is created |
| 42 | WCWHM_CustServShipping_WH_OU | varchar | Dependent system number for the task |
| 43 | WCWHM_CustUSShipping_WH_code | int | Description of the task |
| 44 | WCWHM_CustUSShipping_WH_OU | varchar | Task description in uppercase |
| 45 | WCWHM_ExtRepair_WH_code | int | Status of the task (Fresh, Active, Inactive, Cancel, or Return) |
| 46 | WCWHM_ExtRepair_WH_OU | varchar | Date of task revision |
| 47 | WCWHM_Scrap_WH_code | int | Type of revision (Internal or External) |
| 48 | WCWHM_Scrap_WH_OU | varchar | Latest revision flag |
| 49 | WCWHM_USReceiving_WH_code | int | Type of the task (user-defined, defaulted from quick code master) |
| 50 | WCWHM_USReceiving_WH_OU | varchar | Category of the task (MPD, CMM, MOD, Non Routine, or Others) |
| 51 | WCWHM_ExServ_ReturnWH_code | int | Applicability of the task (Aircraft, Engine, or Component) |
| 52 | WCWHM_ExServ_ReturnWH_OU | varchar | Related task number for the main task |
| 53 | WCWHM_ExcReturn_Policy | varchar | Item referenced in Aircraft Maintenance Manual or Component Maintenance Manual |
| 54 | WCWHM_RepRcpt_WH_code | int | Source document name (such as Engineering Order, Discrepancy Processing, Hangar Work Order, Technical Log, or Component Work Order) |
| 55 | WCWHM_RepRcpt_WH_OU | varchar | Original Equipment Manufacturer name |
| 56 | WCWHM_Serv_RemretWH_code | varchar | ATA chapter number |
| 57 | WCWHM_Serv_return_policy | varchar | ATA Organization Unit |
| 58 | WCWHM_Cust_RemretWH_code | #N/A | Estimated duration of task in minutes |
Sample rows (from live DB)
WCWHM_OUINSTANCE | WCWHM_WORK_CENTER | WCWHM_PART_TYPE | WCWHM_ISSUE_WH_CODE | WCWHM_ISSUE_WH_OU | WCWHM_RETURN_WH_CODE |
|---|---|---|---|---|---|
| 2.0 | 10 | CM | 0121 | 2.0 | 0123 |
| 2.0 | 10 | CNSMB | 123-WH | 2.0 | 0123 |
| 2.0 | 10 | KIT | 123-WH | 2.0 | 0123 |
Showing 3 of 1,585 rows.