WORK ORDER FUNC LOCATION Table
View exposing functional location reference data associated with facilities work orders and maintenance reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
FUNCTIONAL_LOCATION |
Functional location associated with the record. |
VARCHAR2 |
40 |
FUNCTIONAL_LOCATION_CODE |
Code identifying functional location. |
VARCHAR2 |
30 |
FUNCTIONAL_LOCATION_ZONE |
Functional location zone associated with the record. |
VARCHAR2 |
40 |
FUNC_LOCATION_SYSTEM_STATUS |
Func location system status associated with the record. |
VARCHAR2 |
40 |
FUNC_LOC_COST_CENTER_ID |
Business identifier for the func loc cost center. |
VARCHAR2 |
8 |
FUNC_LOC_COST_CENTER_NAME |
Func loc cost center name associated with the record. |
VARCHAR2 |
40 |
PLANT_CODE |
Code identifying plant. |
VARCHAR2 |
4 |
SUPERIOR_FUNC_LOCATION |
Superior func location associated with the record. |
VARCHAR2 |
40 |
SUPERIOR_FUNC_LOCATION_CODE |
Code identifying superior func location. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_ORDER_FUNC_LOCATION_KEY |
Surrogate key identifying the work order func location. |
VARCHAR2 |
30 |