FA_CATEGORIES_B

FA_CATEGORIES_B stores information about your asset categories. This table provides default information when you add an asset. The depreciation program does not use this information to calculate depreciation. . The Asset Categories form inserts one row in this table for each asset category you define. . The Application Object Library table FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment. .

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FA_CATEGORIES_B_PK

CATEGORY_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
CATEGORY_ID NUMBER 18 Yes Unique identification number for each asset category you defined.
STRUCTURE_INSTANCE_NUMBER NUMBER 18 Yes Structure Instance for a particular Flex Structure.
SUMMARY_FLAG VARCHAR2 1 Yes Used by Application Object Library for flexfield definition
ENABLED_FLAG VARCHAR2 1 Yes Indicates whether this category is still valid
SEGMENT1 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
SEGMENT2 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
SEGMENT3 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
SEGMENT4 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
SEGMENT5 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
SEGMENT6 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
SEGMENT7 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
OWNED_LEASED VARCHAR2 6 Yes Indicates whether the assets in this category are owned or leased
CATEGORY_TYPE VARCHAR2 30 Yes Indicates the category type Oracle Assets uses to classify assets in this asset category
START_DATE_ACTIVE DATE Date that you can begin using this asset category
CAPITALIZE_FLAG VARCHAR2 3 Yes YES if assets in this category are capitalized assets
END_DATE_ACTIVE DATE Last date you can add assets to this asset category
PROPERTY_TYPE_CODE VARCHAR2 30 Indicates the property type you assigned to an asset category
PROPERTY_1245_1250_CODE VARCHAR2 4 Indicates whether assets in this category are 1245 property class or 1250 property class
DATE_INEFFECTIVE DATE Not currently used
INVENTORIAL VARCHAR2 3 Indicates whether the asset should be included in physical inventory
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Categories (FA_CATEGORIES)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 30 Descriptive flexfield structure defining column Categories (FA_CATEGORIES)
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
INTANGIBLE_ASSET_FLAG VARCHAR2 1 Indicates whether the asset is an intangible asset.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
CONCATENATED_SEGMENTS VARCHAR2 4000 Concatenated segment values representing an asset category combination with a segment order that is aligned with the asset category flexfield definition sequence.

Foreign Keys

Table Foreign Table Foreign Key Column
fa_asset_history fa_categories_b CATEGORY_ID
fa_additions_b fa_categories_b ASSET_CATEGORY_ID
fa_category_book_defaults fa_categories_b CATEGORY_ID
fa_mass_retirements fa_categories_b CATEGORY_ID
pjc_prj_asset_lns_all fa_categories_b ASSET_CATEGORY_ID
fa_itf_impairments fa_categories_b CATEGORY_ID
ap_invoice_lines_all fa_categories_b ASSET_CATEGORY_ID
fa_categories_tl fa_categories_b CATEGORY_ID
pjc_prj_assets_all fa_categories_b ASSET_CATEGORY_ID
fa_adjustments_t fa_categories_b CATEGORY_ID
fa_mass_changes fa_categories_b CATEGORY_ID
pjc_standard_unit_costs fa_categories_b ASSET_CATEGORY_ID
fa_mass_additions fa_categories_b ASSET_CATEGORY_ID
fa_category_books fa_categories_b CATEGORY_ID
ap_invoice_distributions_all fa_categories_b ASSET_CATEGORY_ID
fa_mass_transfers fa_categories_b CATEGORY_ID
fa_mass_reclass fa_categories_b FROM_CATEGORY_ID
fa_mass_reclass fa_categories_b TO_CATEGORY_ID

Indexes

Index Uniqueness Tablespace Columns
FA_CATEGORIES_B_N1 Non Unique Default SEGMENT1
FA_CATEGORIES_B_N2 Non Unique Default SEGMENT2
FA_CATEGORIES_B_N3 Non Unique Default SEGMENT3
FA_CATEGORIES_B_N4 Non Unique Default SEGMENT4
FA_CATEGORIES_B_N5 Non Unique Default SEGMENT5
FA_CATEGORIES_B_N6 Non Unique Default SEGMENT6
FA_CATEGORIES_B_N7 Non Unique Default SEGMENT7
FA_CATEGORIES_B_N8 Non Unique Default LAST_UPDATE_DATE
FA_CATEGORIES_B_N9 Non Unique FA_CATEGORIES_B_N9 STRUCTURE_INSTANCE_NUMBER, CONCATENATED_SEGMENTS
FA_CATEGORIES_B_U1 Unique Default CATEGORY_ID