Powered by InfoCaptor


Previous Page   Next Page

Item Catalog Groups
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_ITEM_CATALOG_GROUPSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Catalog Item Catalog Groups.CatalogCATALOGCATALOG265897
Catalog Group Name Item Catalog Groups.Catalog Group NameCATALOG_GROUP_NAMECATALOG_GROUP_NAME265896
Created By Item Catalog Groups.Created ByCREATED_BYCREATED_BY124340
Created Date Item Catalog Groups.Created DateCREATED_DATECREATED_DATE125353
Created Date - Day Item Catalog Groups.Created Date CREATED_DATE_DAY171153
Created Date - Month Item Catalog Groups.Created Date CREATED_DATE_MONTH171307
Created Date - Quarter Item Catalog Groups.Created Date CREATED_DATE_QUARTER171461
Created Date - Year Item Catalog Groups.Created Date CREATED_DATE_YEAR171615
DescriptionThe accounting period description.Item Catalog Groups.DescriptionDESCRIPTIONDESCRIPTION129381
End Effective DateThe date after which an account becomes inactive.Item Catalog Groups.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133088
End Effective Date - Day Item Catalog Groups.End Effective Date END_EFFECTIVE_DATE_DAY178563
End Effective Date - Month Item Catalog Groups.End Effective Date END_EFFECTIVE_DATE_MONTH178659
End Effective Date - Quarter Item Catalog Groups.End Effective Date END_EFFECTIVE_DATE_QUARTER178755
End Effective Date - Year Item Catalog Groups.End Effective Date END_EFFECTIVE_DATE_YEAR178851
Item Catalog Group IdItem catalog group identifierItem Catalog Groups.Item Catalog Group IdITEM_CATALOG_GROUP_IDITEM_CATALOG_GROUP_ID137701
Last Updated By Item Catalog Groups.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY138964
Last Updated Date Item Catalog Groups.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139930
Last Updated Date - Day Item Catalog Groups.Last Updated Date LAST_UPDATED_DATE_DAY182826
Last Updated Date - Month Item Catalog Groups.Last Updated Date LAST_UPDATED_DATE_MONTH182988
Last Updated Date - Quarter Item Catalog Groups.Last Updated Date LAST_UPDATED_DATE_QUARTER183150
Last Updated Date - Year Item Catalog Groups.Last Updated Date LAST_UPDATED_DATE_YEAR183312
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Item Catalog Groups -> Descriptive ElementsItem Catalog Groups.Item Catalog Group Id = Descriptive Elements.Item Catalog Group IdAlways exist in master folderNoneNo
Item Catalog Groups -> Organization ItemsItem Catalog Groups.Item Catalog Group Id = Organization Items.Item Catalog Group IdMight not exist in master folderOuter join on master No