Powered by InfoCaptor


Previous Page   Next Page

Item Categories
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_ITEM_CATEGORIESUnknown
NoneNone.INVFG_ITEM_CATEGORIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Broadband Characterestics Item Categories.Broadband CharacteresticsBROADBAND_CHARACTERESTIC_50229BROADBAND_CHARACTERESTIC_50229265918
Business Uni Item Categories.Business UniBUSINESS_UNIT_50250BUSINESS_UNIT_50250265925
Carton Group Item Categories.Carton GroupCARTON_GROUP_50185CARTON_GROUP_50185265906
Category Flex Structure Category flexfield structureItem Categories.Category Flex StructureCATEGORY_FLEX_STRUCTURECATEGORY_FLEX_STRUCTURE121684
Category Id Item category identifierItem Categories.Category IdCATEGORY_IDCATEGORY_ID121687
Category Name Item Categories.Category NameCATEGORY_NAMECATEGORY_NAME265898
Class Item Categories.ClassCLASS_50205CLASS_50205265907
Classification Item Categories.ClassificationCLASSIFICATION_50220CLASSIFICATION_50220265911
Commodity Item Categories.CommodityCOMMODITY_201COMMODITY_201265901
Commodity 1 Item Categories.Commodity 1COMMODITY_50220COMMODITY_50220265912
Contract Category Item Categories.Contract CategoryCONTRACT_CATEGORY_50206CONTRACT_CATEGORY_50206265909
Country Item Categories.CountryCOUNTRY_50220COUNTRY_50220265913
Created By Standard Who columnItem Categories.Created ByCREATED_BYCREATED_BY124341
Created Date Standard Who columnItem Categories.Created DateCREATED_DATECREATED_DATE125354
Created Date Day Item Categories.Created Date CREATED_DATE_DAY171155
Created Date Month Item Categories.Created Date CREATED_DATE_MONTH171309
Created Date Quarter Item Categories.Created Date CREATED_DATE_QUARTER171463
Created Date Year Item Categories.Created Date CREATED_DATE_YEAR171617
Default Category Item Categories.Default CategoryDEFAULT_CATEGORY_50220DEFAULT_CATEGORY_50220265914
Description Item category descriptionItem Categories.DescriptionDESCRIPTIONDESCRIPTION129382
Dominant Features Item Categories.Dominant FeaturesDOMINANT_FEATURES_50229DOMINANT_FEATURES_50229265922
Dummy Item Categories.DummyPRODUCT_GROUP_50184PRODUCT_GROUP_50184265905
End Effective Date Disable dateItem Categories.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133089
End Effective Date Day Item Categories.End Effective Date END_EFFECTIVE_DATE_DAY178565
End Effective Date Month Item Categories.End Effective Date END_EFFECTIVE_DATE_MONTH178661
End Effective Date Quarter Item Categories.End Effective Date END_EFFECTIVE_DATE_QUARTER178757
End Effective Date Year Item Categories.End Effective Date END_EFFECTIVE_DATE_YEAR178853
Interest Type Item Categories.Interest TypeINTEREST_TYPE_50136INTEREST_TYPE_50136265902
Item Category Item Categories.Item CategoryTYPE_201TYPE_201265900
Last Update Date Day Item Categories.Last Updated Date LAST_UPDATE_DATE_DAY183478
Last Update Date Month Item Categories.Last Updated Date LAST_UPDATE_DATE_MONTH183906
Last Update Date Quarter Item Categories.Last Updated Date LAST_UPDATE_DATE_QUARTER184334
Last Update Date Year Item Categories.Last Updated Date LAST_UPDATE_DATE_YEAR184762
Last Updated By Standard Who columnItem Categories.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY138965
Last Updated Date Standard Who columnItem Categories.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139931
Level-1 Item Categories.Level-1LEVEL_1_50271LEVEL_1_50271265927
Level-1 1 Item Categories.Level-1 1LEVEL_1_50272LEVEL_1_50272265930
Level-2 Item Categories.Level-2LEVEL_2_50271LEVEL_2_50271265928
Level-2 1 Item Categories.Level-2 1LEVEL_2_50272LEVEL_2_50272265931
Level-3 Item Categories.Level-3LEVEL_3_50271LEVEL_3_50271265929
Level-3 1 Item Categories.Level-3 1LEVEL_3_50272LEVEL_3_50272265932
Level-4 Item Categories.Level-4LEVEL_4_50272LEVEL_4_50272265933
Media Characterestics Item Categories.Media CharacteresticsMEDIA_CHARACTERESTICS_50229MEDIA_CHARACTERESTICS_50229265921
PC Interface Item Categories.PC InterfacePC_INTERFACE_50229PC_INTERFACE_50229265916
Planning Category Item Categories.Planning CategoryPLANNING_CATEGORY_50270PLANNING_CATEGORY_50270265926
Port Count Item Categories.Port CountPORT_COUNT_50229PORT_COUNT_50229265923
Primary Code Item Categories.Primary CodePRIMARY_CODE_50136PRIMARY_CODE_50136265903
Product Item Categories.ProductPRODUCT_50217PRODUCT_50217265910
Product 1 Item Categories.Product 1PRODUCT_50323PRODUCT_50323265934
Product Group Item Categories.Product GroupPRODUCT_GROUP_101PRODUCT_GROUP_101265899
Product Type Item Categories.Product TypePRODUCT_TYPE_50229PRODUCT_TYPE_50229265915
Secondary Code Item Categories.Secondary CodeSECONDARY_CODE_50136SECONDARY_CODE_50136265904
Structure Id Category flexfield structure identifierItem Categories.Structure IdSTRUCTURE_IDSTRUCTURE_ID163719
SubClass Item Categories.SubClassSUBCLASS_50205SUBCLASS_50205265908
VoIP Service Provider Item Categories.VoIP Service ProviderVOIP_SERVICE_PROVIDER_50249VOIP_SERVICE_PROVIDER_50249265924
Voice Characterestics Item Categories.Voice CharacteresticsVOICE_CHARACTERESTICS_50229VOICE_CHARACTERESTICS_50229265920
Wired Characterestics Item Categories.Wired CharacteresticsWIRED_CHARACTERESTICS_50229WIRED_CHARACTERESTICS_50229265917
Wireless Characterestics Item Categories.Wireless CharacteresticsWIRELESS_CHARACTERESTICS_50229WIRELESS_CHARACTERESTICS_50229265919
Broadband Characterestics Item Categories.Broadband CharacteresticsBROADBAND_CHARACTERESTIC_50229BROADBAND_CHARACTERESTIC_50229265918
Business Uni Item Categories.Business UniBUSINESS_UNIT_50250BUSINESS_UNIT_50250265925
Carton Group Item Categories.Carton GroupCARTON_GROUP_50185CARTON_GROUP_50185265906
Category Flex Structure Category flexfield structureItem Categories.Category Flex StructureCATEGORY_FLEX_STRUCTURECATEGORY_FLEX_STRUCTURE121684
Category Id Item category identifierItem Categories.Category IdCATEGORY_IDCATEGORY_ID121687
Category Name Item Categories.Category NameCATEGORY_NAMECATEGORY_NAME265898
Class Item Categories.ClassCLASS_50205CLASS_50205265907
Classification Item Categories.ClassificationCLASSIFICATION_50220CLASSIFICATION_50220265911
Commodity Item Categories.CommodityCOMMODITY_201COMMODITY_201265901
Commodity 1 Item Categories.Commodity 1COMMODITY_50220COMMODITY_50220265912
Contract Category Item Categories.Contract CategoryCONTRACT_CATEGORY_50206CONTRACT_CATEGORY_50206265909
Country Item Categories.CountryCOUNTRY_50220COUNTRY_50220265913
Created By Standard Who columnItem Categories.Created ByCREATED_BYCREATED_BY124341
Created Date Standard Who columnItem Categories.Created DateCREATED_DATECREATED_DATE125354
Created Date Day Item Categories.Created Date CREATED_DATE_DAY171155
Created Date Month Item Categories.Created Date CREATED_DATE_MONTH171309
Created Date Quarter Item Categories.Created Date CREATED_DATE_QUARTER171463
Created Date Year Item Categories.Created Date CREATED_DATE_YEAR171617
Default Category Item Categories.Default CategoryDEFAULT_CATEGORY_50220DEFAULT_CATEGORY_50220265914
Description Item category descriptionItem Categories.DescriptionDESCRIPTIONDESCRIPTION129382
Dominant Features Item Categories.Dominant FeaturesDOMINANT_FEATURES_50229DOMINANT_FEATURES_50229265922
Dummy Item Categories.DummyPRODUCT_GROUP_50184PRODUCT_GROUP_50184265905
End Effective Date Disable dateItem Categories.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133089
End Effective Date Day Item Categories.End Effective Date END_EFFECTIVE_DATE_DAY178565
End Effective Date Month Item Categories.End Effective Date END_EFFECTIVE_DATE_MONTH178661
End Effective Date Quarter Item Categories.End Effective Date END_EFFECTIVE_DATE_QUARTER178757
End Effective Date Year Item Categories.End Effective Date END_EFFECTIVE_DATE_YEAR178853
Interest Type Item Categories.Interest TypeINTEREST_TYPE_50136INTEREST_TYPE_50136265902
Item Category Item Categories.Item CategoryTYPE_201TYPE_201265900
Last Update Date Day Item Categories.Last Updated Date LAST_UPDATE_DATE_DAY183478
Last Update Date Month Item Categories.Last Updated Date LAST_UPDATE_DATE_MONTH183906
Last Update Date Quarter Item Categories.Last Updated Date LAST_UPDATE_DATE_QUARTER184334
Last Update Date Year Item Categories.Last Updated Date LAST_UPDATE_DATE_YEAR184762
Last Updated By Standard Who columnItem Categories.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY138965
Last Updated Date Standard Who columnItem Categories.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139931
Level-1 Item Categories.Level-1LEVEL_1_50271LEVEL_1_50271265927
Level-1 1 Item Categories.Level-1 1LEVEL_1_50272LEVEL_1_50272265930
Level-2 Item Categories.Level-2LEVEL_2_50271LEVEL_2_50271265928
Level-2 1 Item Categories.Level-2 1LEVEL_2_50272LEVEL_2_50272265931
Level-3 Item Categories.Level-3LEVEL_3_50271LEVEL_3_50271265929
Level-3 1 Item Categories.Level-3 1LEVEL_3_50272LEVEL_3_50272265932
Level-4 Item Categories.Level-4LEVEL_4_50272LEVEL_4_50272265933
Media Characterestics Item Categories.Media CharacteresticsMEDIA_CHARACTERESTICS_50229MEDIA_CHARACTERESTICS_50229265921
PC Interface Item Categories.PC InterfacePC_INTERFACE_50229PC_INTERFACE_50229265916
Planning Category Item Categories.Planning CategoryPLANNING_CATEGORY_50270PLANNING_CATEGORY_50270265926
Port Count Item Categories.Port CountPORT_COUNT_50229PORT_COUNT_50229265923
Primary Code Item Categories.Primary CodePRIMARY_CODE_50136PRIMARY_CODE_50136265903
Product Item Categories.ProductPRODUCT_50217PRODUCT_50217265910
Product 1 Item Categories.Product 1PRODUCT_50323PRODUCT_50323265934
Product Group Item Categories.Product GroupPRODUCT_GROUP_101PRODUCT_GROUP_101265899
Product Type Item Categories.Product TypePRODUCT_TYPE_50229PRODUCT_TYPE_50229265915
Secondary Code Item Categories.Secondary CodeSECONDARY_CODE_50136SECONDARY_CODE_50136265904
Structure Id Category flexfield structure identifierItem Categories.Structure IdSTRUCTURE_IDSTRUCTURE_ID163719
SubClass Item Categories.SubClassSUBCLASS_50205SUBCLASS_50205265908
VoIP Service Provider Item Categories.VoIP Service ProviderVOIP_SERVICE_PROVIDER_50249VOIP_SERVICE_PROVIDER_50249265924
Voice Characterestics Item Categories.Voice CharacteresticsVOICE_CHARACTERESTICS_50229VOICE_CHARACTERESTICS_50229265920
Wired Characterestics Item Categories.Wired CharacteresticsWIRED_CHARACTERESTICS_50229WIRED_CHARACTERESTICS_50229265917
Wireless Characterestics Item Categories.Wireless CharacteresticsWIRELESS_CHARACTERESTICS_50229WIRELESS_CHARACTERESTICS_50229265919
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Item Categories -> Item Category AssignmentsItem Categories.Category Id = Item Category Assignments.Category IdAlways exist in master folderNoneNo