DW_FA_CATEGORIES_D

This is the FA dimension table for Fixed asset Category details

Details

Module: Assets

Key Columns

CATEGORY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CATEGORY_ID NUMBER 38 0 True Unique identification number for each asset category you defined.    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier. Value is derived from a combination of Category identifier.    
CATEGORY_TYPE VARCHAR2 32     Indicates the category type Oracle Assets uses to classify assets in this asset category    
DESCRIPTION VARCHAR2 64     Category Description    
ENABLED_FLAG VARCHAR2 16     Indicates whether this category is still valid    
START_DATE_ACTIVE DATE       Date that you can begin using this asset category    
END_DATE_ACTIVE DATE       Last date you can add assets to this asset category    
CAPITALIZE_FLAG VARCHAR2 16     YES if assets in this category are capitalized assets    
STRUCTURE_INSTANCE_NUMBER NUMBER 38 0        
CONCAT_SEGMENTS VARCHAR2 999          
CAT_SEGMENT1 VARCHAR2 32     Key Flexfield: segment of the key flexfield.    
CAT_SEGMENT1_VALUESET_CODE VARCHAR2 64          
CAT_SEGMENT2 VARCHAR2 32     Key Flexfield: segment of the key flexfield.    
CAT_SEGMENT2_VALUESET_CODE VARCHAR2 64          
CAT_SEGMENT3 VARCHAR2 32     Key Flexfield: segment of the key flexfield.    
CAT_SEGMENT3_VALUESET_CODE VARCHAR2 64          
CAT_SEGMENT4 VARCHAR2 32     Key Flexfield: segment of the key flexfield.    
CAT_SEGMENT4_VALUESET_CODE VARCHAR2 64          
CAT_SEGMENT5 VARCHAR2 32     Key Flexfield: segment of the key flexfield.    
CAT_SEGMENT5_VALUESET_CODE VARCHAR2 64          
CAT_SEGMENT6 VARCHAR2 32     Key Flexfield: segment of the key flexfield.    
CAT_SEGMENT6_VALUESET_CODE VARCHAR2 64          
CAT_SEGMENT7 VARCHAR2 32     Key Flexfield: segment of the key flexfield.    
CAT_SEGMENT7_VALUESET_CODE VARCHAR2 64          

Copyright © 2019, 2022, Oracle and/or its affiliates.