This is the FA dimension table for Fixed asset Category details
Module: Assets
CATEGORY_ID
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 | This column is for Oracle Internal use only. 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, 2024, Oracle and/or its affiliates.