Powered by InfoCaptor


Previous Page   Next Page

Plan Item Exceptions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_PLAN_ITEM_EXCEPTIONSUnknown
NoneNone.MRPFG_PLAN_ITEM_EXCEPTIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Broadband Characterestics Plan Item Exceptions.Broadband CharacteresticsBROADBAND_CHARACTERESTIC_50229BROADBAND_CHARACTERESTIC_50229273011
Business Uni Plan Item Exceptions.Business UniBUSINESS_UNIT_50250BUSINESS_UNIT_50250273018
Buyer NameName of the buyer associated with the itemPlan Item Exceptions.Buyer NameBUYER_NAMEBUYER_NAME121249
Carton Group Plan Item Exceptions.Carton GroupCARTON_GROUP_50185CARTON_GROUP_50185272999
Category Plan Item Exceptions.CategoryCATEGORYCATEGORY272991
Category IdItem category identifierPlan Item Exceptions.Category IdCATEGORY_IDCATEGORY_ID121690
Class Plan Item Exceptions.ClassCLASS_50205CLASS_50205273000
Classification Plan Item Exceptions.ClassificationCLASSIFICATION_50220CLASSIFICATION_50220273004
Commodity Plan Item Exceptions.CommodityCOMMODITY_201COMMODITY_201272994
Commodity 1 Plan Item Exceptions.Commodity 1COMMODITY_50220COMMODITY_50220273005
Contract Category Plan Item Exceptions.Contract CategoryCONTRACT_CATEGORY_50206CONTRACT_CATEGORY_50206273002
Country Plan Item Exceptions.CountryCOUNTRY_50220COUNTRY_50220273006
Created By Plan Item Exceptions.Created ByCREATED_BYCREATED_BY124706
Creation Date Plan Item Exceptions.Creation DateCREATION_DATECREATION_DATE126132
Creation Date - Day Plan Item Exceptions.Creation Date CREATION_DATE_DAY172293
Creation Date - Month Plan Item Exceptions.Creation Date CREATION_DATE_MONTH172747
Creation Date - Quarter Plan Item Exceptions.Creation Date CREATION_DATE_QUARTER173201
Creation Date - Year Plan Item Exceptions.Creation Date CREATION_DATE_YEAR173655
Default Category Plan Item Exceptions.Default CategoryDEFAULT_CATEGORY_50220DEFAULT_CATEGORY_50220273007
Department Code Plan Item Exceptions.Department CodeDEPARTMENT_CODEDEPARTMENT_CODE129152
Department IdDepartment identifierPlan Item Exceptions.Department IdDEPARTMENT_IDDEPARTMENT_ID129172
Dominant Features Plan Item Exceptions.Dominant FeaturesDOMINANT_FEATURES_50229DOMINANT_FEATURES_50229273015
Dummy Plan Item Exceptions.DummyPRODUCT_GROUP_50184PRODUCT_GROUP_50184272998
Exception CountNumber of exceptions for the exception typePlan Item Exceptions.Exception CountEXCEPTION_COUNTEXCEPTION_COUNT133765
Exception TypeIndicates type of exception messagePlan Item Exceptions.Exception TypeEXCEPTION_TYPEEXCEPTION_TYPE133771
Interest Type Plan Item Exceptions.Interest TypeINTEREST_TYPE_50136INTEREST_TYPE_50136272995
Inventory Item IdInventory item identifierPlan Item Exceptions.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137230
Item Plan Item Exceptions.ItemITEMITEM272990
Item Category Plan Item Exceptions.Item CategoryTYPE_201TYPE_201272993
Item Number Plan Item Exceptions.Item NumberITEM_NUMBERITEM_NUMBER272989
Last Update Date Plan Item Exceptions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140668
Last Update Date - Day Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_DAY183696
Last Update Date - Month Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_MONTH184124
Last Update Date - Quarter Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_QUARTER184552
Last Update Date - Year Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_YEAR184980
Last Updated By Plan Item Exceptions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139331
Level-1 Plan Item Exceptions.Level-1LEVEL_1_50271LEVEL_1_50271273020
Level-1 1 Plan Item Exceptions.Level-1 1LEVEL_1_50272LEVEL_1_50272273023
Level-2 Plan Item Exceptions.Level-2LEVEL_2_50271LEVEL_2_50271273021
Level-2 1 Plan Item Exceptions.Level-2 1LEVEL_2_50272LEVEL_2_50272273024
Level-3 Plan Item Exceptions.Level-3LEVEL_3_50271LEVEL_3_50271273022
Level-3 1 Plan Item Exceptions.Level-3 1LEVEL_3_50272LEVEL_3_50272273025
Level-4 Plan Item Exceptions.Level-4LEVEL_4_50272LEVEL_4_50272273026
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Plan Item Exceptions.Line IdLINE_IDLINE_ID144640
Line NameName of manufacturing linePlan Item Exceptions.Line NameLINE_NAMELINE_NAME144695
Media Characterestics Plan Item Exceptions.Media CharacteresticsMEDIA_CHARACTERESTICS_50229MEDIA_CHARACTERESTICS_50229273014
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Item Exceptions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150090
Organization Id Plan Item Exceptions.Organization IdORGANIZATION_IDORGANIZATION_ID150346
Organization Name Plan Item Exceptions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150644
PC Interface Plan Item Exceptions.PC InterfacePC_INTERFACE_50229PC_INTERFACE_50229273009
Plan NameName of MPS, MRP, or DRP planPlan Item Exceptions.Plan NamePLAN_NAMEPLAN_NAME154310
Planner NameName of the plannerPlan Item Exceptions.Planner NamePLANNER_NAMEPLANNER_NAME154227
Planning Category Plan Item Exceptions.Planning CategoryPLANNING_CATEGORY_50270PLANNING_CATEGORY_50270273019
Planning GroupPlanning group namePlan Item Exceptions.Planning GroupPLANNING_GROUPPLANNING_GROUP154246
Port Count Plan Item Exceptions.Port CountPORT_COUNT_50229PORT_COUNT_50229273016
Primary Code Plan Item Exceptions.Primary CodePRIMARY_CODE_50136PRIMARY_CODE_50136272996
Product Plan Item Exceptions.ProductPRODUCT_50217PRODUCT_50217273003
Product 1 Plan Item Exceptions.Product 1PRODUCT_50323PRODUCT_50323273027
Product Group Plan Item Exceptions.Product GroupPRODUCT_GROUP_101PRODUCT_GROUP_101272992
Product Type Plan Item Exceptions.Product TypePRODUCT_TYPE_50229PRODUCT_TYPE_50229273008
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Item Exceptions.Project IdPROJECT_IDPROJECT_ID156469
Project Number Plan Item Exceptions.Project NumberPROJECT_NUMBERPROJECT_NUMBER156640
Resource Code Plan Item Exceptions.Resource CodeRESOURCE_CODERESOURCE_CODE158957
Resource IdThe unique identifier of the resource.Plan Item Exceptions.Resource IdRESOURCE_IDRESOURCE_ID159022
Resource TypeIndicate type of the resourcePlan Item Exceptions.Resource TypeRESOURCE_TYPERESOURCE_TYPE159195
Secondary Code Plan Item Exceptions.Secondary CodeSECONDARY_CODE_50136SECONDARY_CODE_50136272997
SubClass Plan Item Exceptions.SubClassSUBCLASS_50205SUBCLASS_50205273001
Task IdIdentifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.Plan Item Exceptions.Task IdTASK_IDTASK_ID164592
Task NumberUser-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports.Plan Item Exceptions.Task NumberTASK_NUMBERTASK_NUMBER164667
VersionIndicate the version number of the planPlan Item Exceptions.VersionVERSIONVERSION167490
VoIP Service Provider Plan Item Exceptions.VoIP Service ProviderVOIP_SERVICE_PROVIDER_50249VOIP_SERVICE_PROVIDER_50249273017
Voice Characterestics Plan Item Exceptions.Voice CharacteresticsVOICE_CHARACTERESTICS_50229VOICE_CHARACTERESTICS_50229273013
Wired Characterestics Plan Item Exceptions.Wired CharacteresticsWIRED_CHARACTERESTICS_50229WIRED_CHARACTERESTICS_50229273010
Wireless Characterestics Plan Item Exceptions.Wireless CharacteresticsWIRELESS_CHARACTERESTICS_50229WIRELESS_CHARACTERESTICS_50229273012
Broadband Characterestics Plan Item Exceptions.Broadband CharacteresticsBROADBAND_CHARACTERESTIC_50229BROADBAND_CHARACTERESTIC_50229273011
Business Uni Plan Item Exceptions.Business UniBUSINESS_UNIT_50250BUSINESS_UNIT_50250273018
Buyer NameName of the buyer associated with the itemPlan Item Exceptions.Buyer NameBUYER_NAMEBUYER_NAME121249
Carton Group Plan Item Exceptions.Carton GroupCARTON_GROUP_50185CARTON_GROUP_50185272999
Category Plan Item Exceptions.CategoryCATEGORYCATEGORY272991
Category IdItem category identifierPlan Item Exceptions.Category IdCATEGORY_IDCATEGORY_ID121690
Class Plan Item Exceptions.ClassCLASS_50205CLASS_50205273000
Classification Plan Item Exceptions.ClassificationCLASSIFICATION_50220CLASSIFICATION_50220273004
Commodity Plan Item Exceptions.CommodityCOMMODITY_201COMMODITY_201272994
Commodity 1 Plan Item Exceptions.Commodity 1COMMODITY_50220COMMODITY_50220273005
Contract Category Plan Item Exceptions.Contract CategoryCONTRACT_CATEGORY_50206CONTRACT_CATEGORY_50206273002
Country Plan Item Exceptions.CountryCOUNTRY_50220COUNTRY_50220273006
Created By Plan Item Exceptions.Created ByCREATED_BYCREATED_BY124706
Creation Date Plan Item Exceptions.Creation DateCREATION_DATECREATION_DATE126132
Creation Date - Day Plan Item Exceptions.Creation Date CREATION_DATE_DAY172293
Creation Date - Month Plan Item Exceptions.Creation Date CREATION_DATE_MONTH172747
Creation Date - Quarter Plan Item Exceptions.Creation Date CREATION_DATE_QUARTER173201
Creation Date - Year Plan Item Exceptions.Creation Date CREATION_DATE_YEAR173655
Default Category Plan Item Exceptions.Default CategoryDEFAULT_CATEGORY_50220DEFAULT_CATEGORY_50220273007
Department Code Plan Item Exceptions.Department CodeDEPARTMENT_CODEDEPARTMENT_CODE129152
Department IdDepartment identifierPlan Item Exceptions.Department IdDEPARTMENT_IDDEPARTMENT_ID129172
Dominant Features Plan Item Exceptions.Dominant FeaturesDOMINANT_FEATURES_50229DOMINANT_FEATURES_50229273015
Dummy Plan Item Exceptions.DummyPRODUCT_GROUP_50184PRODUCT_GROUP_50184272998
Exception CountNumber of exceptions for the exception typePlan Item Exceptions.Exception CountEXCEPTION_COUNTEXCEPTION_COUNT133765
Exception TypeIndicates type of exception messagePlan Item Exceptions.Exception TypeEXCEPTION_TYPEEXCEPTION_TYPE133771
Interest Type Plan Item Exceptions.Interest TypeINTEREST_TYPE_50136INTEREST_TYPE_50136272995
Inventory Item IdInventory item identifierPlan Item Exceptions.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137230
Item Plan Item Exceptions.ItemITEMITEM272990
Item Category Plan Item Exceptions.Item CategoryTYPE_201TYPE_201272993
Item Number Plan Item Exceptions.Item NumberITEM_NUMBERITEM_NUMBER272989
Last Update Date Plan Item Exceptions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140668
Last Update Date - Day Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_DAY183696
Last Update Date - Month Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_MONTH184124
Last Update Date - Quarter Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_QUARTER184552
Last Update Date - Year Plan Item Exceptions.Last Update Date LAST_UPDATE_DATE_YEAR184980
Last Updated By Plan Item Exceptions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139331
Level-1 Plan Item Exceptions.Level-1LEVEL_1_50271LEVEL_1_50271273020
Level-1 1 Plan Item Exceptions.Level-1 1LEVEL_1_50272LEVEL_1_50272273023
Level-2 Plan Item Exceptions.Level-2LEVEL_2_50271LEVEL_2_50271273021
Level-2 1 Plan Item Exceptions.Level-2 1LEVEL_2_50272LEVEL_2_50272273024
Level-3 Plan Item Exceptions.Level-3LEVEL_3_50271LEVEL_3_50271273022
Level-3 1 Plan Item Exceptions.Level-3 1LEVEL_3_50272LEVEL_3_50272273025
Level-4 Plan Item Exceptions.Level-4LEVEL_4_50272LEVEL_4_50272273026
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Plan Item Exceptions.Line IdLINE_IDLINE_ID144640
Line NameName of manufacturing linePlan Item Exceptions.Line NameLINE_NAMELINE_NAME144695
Media Characterestics Plan Item Exceptions.Media CharacteresticsMEDIA_CHARACTERESTICS_50229MEDIA_CHARACTERESTICS_50229273014
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Item Exceptions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150090
Organization Id Plan Item Exceptions.Organization IdORGANIZATION_IDORGANIZATION_ID150346
Organization Name Plan Item Exceptions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150644
PC Interface Plan Item Exceptions.PC InterfacePC_INTERFACE_50229PC_INTERFACE_50229273009
Plan NameName of MPS, MRP, or DRP planPlan Item Exceptions.Plan NamePLAN_NAMEPLAN_NAME154310
Planner NameName of the plannerPlan Item Exceptions.Planner NamePLANNER_NAMEPLANNER_NAME154227
Planning Category Plan Item Exceptions.Planning CategoryPLANNING_CATEGORY_50270PLANNING_CATEGORY_50270273019
Planning GroupPlanning group namePlan Item Exceptions.Planning GroupPLANNING_GROUPPLANNING_GROUP154246
Port Count Plan Item Exceptions.Port CountPORT_COUNT_50229PORT_COUNT_50229273016
Primary Code Plan Item Exceptions.Primary CodePRIMARY_CODE_50136PRIMARY_CODE_50136272996
Product Plan Item Exceptions.ProductPRODUCT_50217PRODUCT_50217273003
Product 1 Plan Item Exceptions.Product 1PRODUCT_50323PRODUCT_50323273027
Product Group Plan Item Exceptions.Product GroupPRODUCT_GROUP_101PRODUCT_GROUP_101272992
Product Type Plan Item Exceptions.Product TypePRODUCT_TYPE_50229PRODUCT_TYPE_50229273008
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Item Exceptions.Project IdPROJECT_IDPROJECT_ID156469
Project Number Plan Item Exceptions.Project NumberPROJECT_NUMBERPROJECT_NUMBER156640
Resource Code Plan Item Exceptions.Resource CodeRESOURCE_CODERESOURCE_CODE158957
Resource IdThe unique identifier of the resource.Plan Item Exceptions.Resource IdRESOURCE_IDRESOURCE_ID159022
Resource TypeIndicate type of the resourcePlan Item Exceptions.Resource TypeRESOURCE_TYPERESOURCE_TYPE159195
Secondary Code Plan Item Exceptions.Secondary CodeSECONDARY_CODE_50136SECONDARY_CODE_50136272997
SubClass Plan Item Exceptions.SubClassSUBCLASS_50205SUBCLASS_50205273001
Task IdIdentifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.Plan Item Exceptions.Task IdTASK_IDTASK_ID164592
Task NumberUser-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports.Plan Item Exceptions.Task NumberTASK_NUMBERTASK_NUMBER164667
VersionIndicate the version number of the planPlan Item Exceptions.VersionVERSIONVERSION167490
VoIP Service Provider Plan Item Exceptions.VoIP Service ProviderVOIP_SERVICE_PROVIDER_50249VOIP_SERVICE_PROVIDER_50249273017
Voice Characterestics Plan Item Exceptions.Voice CharacteresticsVOICE_CHARACTERESTICS_50229VOICE_CHARACTERESTICS_50229273013
Wired Characterestics Plan Item Exceptions.Wired CharacteresticsWIRED_CHARACTERESTICS_50229WIRED_CHARACTERESTICS_50229273010
Wireless Characterestics Plan Item Exceptions.Wireless CharacteresticsWIRELESS_CHARACTERESTICS_50229WIRELESS_CHARACTERESTICS_50229273012
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Plan Item Exceptions -> Plan Exception Details. ? .Might not exist in master folderOuter join on master No