Module: Work Asset Analytics
Type: Dimension
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| LOCATION_DPOS_FLG | VARCHAR2 | 4 | Location Disposition | ||||
| NODE_TYPE_CD | VARCHAR2 | 30 | Location/Organization Type | ||||
| STOREROOM | VARCHAR2 | 12 | Storeroom | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 48 | Source Record Id | ||||
| ADDRESS2 | VARCHAR2 | 254 | Address 2 | ||||
| ADDRESS3 | VARCHAR2 | 254 | Address 3 | ||||
| ADDRESS4 | VARCHAR2 | 254 | Address 4 | ||||
| BUYER_CD | VARCHAR2 | 38 | Buyer | ||||
| LOCATION_CLASS_FLG | VARCHAR2 | 38 | Location Class | ||||
| PARENT_NODE_ID | VARCHAR2 | 38 | Parent Location/Organization | ||||
| POSTAL | VARCHAR2 | 38 | Postal | ||||
| STATE | VARCHAR2 | 38 | State | ||||
| STOREROOM_ADDRESS | VARCHAR2 | 254 | Storeroom Address | ||||
| STOREROOM_CITY | VARCHAR2 | 90 | Storeroom City | ||||
| STOREROOM_COUNTRY | VARCHAR2 | 38 | Storeroom Country | ||||
| STOREROOM_DESCR100 | VARCHAR2 | 100 | Storeroom Description | ||||
| SUPERVISOR_ID | VARCHAR2 | 38 | Supervisor | ||||
| W1_MAIN_CONTACT_ID | VARCHAR2 | 38 | Main Contact | ||||
| W1_SUBURB | VARCHAR2 | 64 | Suburb | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |