Powered by InfoCaptor


Previous Page   Next Page

Asset Category
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.FAFG_ASSET_CATSUnknown
NoneNone.FAFG_ASSET_CATSUnknown
NoneNone.FAFG_ASSET_CATSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Asset Category IdUnique identification number for each asset category you definedAsset Category.Asset Category IdASSET_CATEGORY_IDASSET_CATEGORY_ID116558
Capitalize FlagYES if assets in this category are capitalized assetsAsset Category.Capitalize FlagCAPITALIZE_FLAGCAPITALIZE_FLAG121554
Category Name Asset Category.Category NameCATEGORY_NAMECATEGORY_NAME268229
Category TypeIndicates the category type Oracle Assets uses to classify assets in this asset categoryAsset Category.Category TypeCATEGORY_TYPECATEGORY_TYPE121747
Created ByStandard WHO column.Asset Category.Created ByCREATED_BYCREATED_BY124575
Creation DateStandard WHO column.Asset Category.Creation DateCREATION_DATECREATION_DATE126000
DescriptionThe accounting period description.Asset Category.DescriptionDESCRIPTIONDESCRIPTION129524
Enabled FlagIndicates whether this category is still validAsset Category.Enabled FlagENABLED_FLAGENABLED_FLAG132429
End Date ActiveLast date you can add assets to this asset categoryAsset Category.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132907
Last Update DateStandard WHO column.Asset Category.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140535
Last Updated ByStandard WHO column.Asset Category.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139203
Major Asset Category.MajorMAJORMAJOR268230
Minor Asset Category.MinorMINORMINOR268231
Owned LeasedIndicates whether the assets in this category are owned or leasedAsset Category.Owned LeasedOWNED_LEASEDOWNED_LEASED151741
Start Date ActiveDate that you can begin using this asset categoryAsset Category.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163067
Asset Category IdUnique identification number for each asset category you definedAsset Category.Asset Category IdASSET_CATEGORY_IDASSET_CATEGORY_ID116558
Capitalize FlagYES if assets in this category are capitalized assetsAsset Category.Capitalize FlagCAPITALIZE_FLAGCAPITALIZE_FLAG121554
Category Name Asset Category.Category NameCATEGORY_NAMECATEGORY_NAME268229
Category TypeIndicates the category type Oracle Assets uses to classify assets in this asset categoryAsset Category.Category TypeCATEGORY_TYPECATEGORY_TYPE121747
Created ByStandard WHO column.Asset Category.Created ByCREATED_BYCREATED_BY124575
Creation DateStandard WHO column.Asset Category.Creation DateCREATION_DATECREATION_DATE126000
DescriptionThe accounting period description.Asset Category.DescriptionDESCRIPTIONDESCRIPTION129524
Enabled FlagIndicates whether this category is still validAsset Category.Enabled FlagENABLED_FLAGENABLED_FLAG132429
End Date ActiveLast date you can add assets to this asset categoryAsset Category.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132907
Last Update DateStandard WHO column.Asset Category.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140535
Last Updated ByStandard WHO column.Asset Category.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139203
Major Asset Category.MajorMAJORMAJOR268230
Minor Asset Category.MinorMINORMINOR268231
Owned LeasedIndicates whether the assets in this category are owned or leasedAsset Category.Owned LeasedOWNED_LEASEDOWNED_LEASED151741
Start Date ActiveDate that you can begin using this asset categoryAsset Category.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163067
Asset Category IdUnique identification number for each asset category you definedAsset Category.Asset Category IdASSET_CATEGORY_IDASSET_CATEGORY_ID116558
Capitalize FlagYES if assets in this category are capitalized assetsAsset Category.Capitalize FlagCAPITALIZE_FLAGCAPITALIZE_FLAG121554
Category Name Asset Category.Category NameCATEGORY_NAMECATEGORY_NAME268229
Category TypeIndicates the category type Oracle Assets uses to classify assets in this asset categoryAsset Category.Category TypeCATEGORY_TYPECATEGORY_TYPE121747
Created ByStandard WHO column.Asset Category.Created ByCREATED_BYCREATED_BY124575
Creation DateStandard WHO column.Asset Category.Creation DateCREATION_DATECREATION_DATE126000
DescriptionThe accounting period description.Asset Category.DescriptionDESCRIPTIONDESCRIPTION129524
Enabled FlagIndicates whether this category is still validAsset Category.Enabled FlagENABLED_FLAGENABLED_FLAG132429
End Date ActiveLast date you can add assets to this asset categoryAsset Category.End Date ActiveEND_DATE_ACTIVEEND_DATE_ACTIVE132907
Last Update DateStandard WHO column.Asset Category.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140535
Last Updated ByStandard WHO column.Asset Category.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139203
Major Asset Category.MajorMAJORMAJOR268230
Minor Asset Category.MinorMINORMINOR268231
Owned LeasedIndicates whether the assets in this category are owned or leasedAsset Category.Owned LeasedOWNED_LEASEDOWNED_LEASED151741
Start Date ActiveDate that you can begin using this asset categoryAsset Category.Start Date ActiveSTART_DATE_ACTIVESTART_DATE_ACTIVE163067
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Asset Category -> AssetAsset Category.Asset Category Id = Asset.Asset Category IdAlways exist in master folderNoneNo
Asset Category -> Organization ItemsAsset Category.Asset Category Id = Organization Items.Asset Category IdMight not exist in master folderOuter join on master No
Asset Category -> PA Asset LinesAsset Category.Asset Category Id = PA Asset Lines.Asset Category IdAlways exist in master folderNoneNo
Asset Category -> PA Asset Lines 1Asset Category.Asset Category Id = PA Asset Lines.Asset Category IdAlways exist in master folderNoneNo
Asset Category -> PA AssetsAsset Category.Asset Category Id = PA Assets.Asset Category IdAlways exist in master folderNoneNo
Asset Category -> PA Assets 1Asset Category.Asset Category Id = PA Assets.Asset Category IdAlways exist in master folderNoneNo