This is the FA dimention table for Fixed asset Location details
Module: Assets
LOCATION_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| LOCATION_ID | NUMBER | 38 | 0 | True | Location identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Location identifier. | ||||
| ENABLED_FLAG | VARCHAR2 | 16 | Option indicating whether the location is active or not. | ||||
| START_DATE_ACTIVE | DATE | Date on which the location became active. | |||||
| END_DATE_ACTIVE | DATE | Date on which the location became inactive. | |||||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 38 | 0 | ||||
| CONCAT_SEGMENTS | VARCHAR2 | 999 | |||||
| LOC_SEGMENT1 | VARCHAR2 | 32 | Key Flexfield: segment of the key flexfield. | ||||
| LOC_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | |||||
| LOC_SEGMENT2 | VARCHAR2 | 32 | Key Flexfield: segment of the key flexfield. | ||||
| LOC_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | |||||
| LOC_SEGMENT3 | VARCHAR2 | 32 | Key Flexfield: segment of the key flexfield. | ||||
| LOC_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | |||||
| LOC_SEGMENT4 | VARCHAR2 | 32 | Key Flexfield: segment of the key flexfield. | ||||
| LOC_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | |||||
| LOC_SEGMENT5 | VARCHAR2 | 32 | Key Flexfield: segment of the key flexfield. | ||||
| LOC_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | |||||
| LOC_SEGMENT6 | VARCHAR2 | 32 | Key Flexfield: segment of the key flexfield. | ||||
| LOC_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | |||||
| LOC_SEGMENT7 | VARCHAR2 | 32 | Key Flexfield: segment of the key flexfield. | ||||
| LOC_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |
Copyright © 2019, 2024, Oracle and/or its affiliates.