WORK ORDER FUNC LOC HIER Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FUNCTIONAL_LOCATION_KEY |
XXX |
VARCHAR2 |
30 |
HIERARCHY_TYPE |
XXX |
VARCHAR2 |
4 |
LEVEL_1_CODE |
XXX |
VARCHAR2 |
40 |
LEVEL_1_NAME |
XXX |
VARCHAR2 |
40 |
LEVEL_2_CODE |
XXX |
VARCHAR2 |
40 |
LEVEL_2_NAME |
XXX |
VARCHAR2 |
40 |
LEVEL_3_CODE |
XXX |
VARCHAR2 |
40 |
LEVEL_3_NAME |
XXX |
VARCHAR2 |
40 |
LEVEL_4_CODE |
XXX |
VARCHAR2 |
40 |
LEVEL_4_NAME |
XXX |
VARCHAR2 |
40 |
LEVEL_5_CODE |
XXX |
VARCHAR2 |
40 |
LEVEL_5_NAME |
XXX |
VARCHAR2 |
40 |
LEVEL_6_CODE |
XXX |
VARCHAR2 |
40 |
LEVEL_6_NAME |
XXX |
VARCHAR2 |
40 |
LEVEL_7_CODE |
XXX |
VARCHAR2 |
40 |
LEVEL_7_NAME |
XXX |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WORK_ORDER_KEY |
XXX |
VARCHAR2 |
12 |