DW_FA_LOCATIONS_D

This is the FA dimention table for Fixed asset Location details

Details

Module: Assets

Key Columns

LOCATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LOCATION_ID NUMBER 38 0 True Location identifier.    
SOURCE_RECORD_ID VARCHAR2 64     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, 2022, Oracle and/or its affiliates.