Powered by InfoCaptor


Previous Page   Next Page

Plan Exception Sets
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_PLAN_EXCEPTION_SETSUnknown
NoneNone.MRPFG_PLAN_EXCEPTION_SETSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created By Plan Exception Sets.Created ByCREATED_BYCREATED_BY124705
Creation Date Plan Exception Sets.Creation DateCREATION_DATECREATION_DATE126131
Creation Date - Day Plan Exception Sets.Creation Date CREATION_DATE_DAY172291
Creation Date - Month Plan Exception Sets.Creation Date CREATION_DATE_MONTH172745
Creation Date - Quarter Plan Exception Sets.Creation Date CREATION_DATE_QUARTER173199
Creation Date - Year Plan Exception Sets.Creation Date CREATION_DATE_YEAR173653
Exception Set NameException set identifierPlan Exception Sets.Exception Set NameEXCEPTION_SET_NAMEEXCEPTION_SET_NAME133769
Excess Exception Plan Exception Sets.Excess ExceptionEXCESS_EXCEPTIONEXCESS_EXCEPTION272984
Excess QuantityQuantity above which planning will generate an exception messagePlan Exception Sets.Excess QuantityEXCESS_QUANTITYEXCESS_QUANTITY133774
Last Update Date Plan Exception Sets.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140667
Last Update Date - Day Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_DAY183694
Last Update Date - Month Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_MONTH184122
Last Update Date - Quarter Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_QUARTER184550
Last Update Date - Year Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_YEAR184978
Last Updated By Plan Exception Sets.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139330
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Exception Sets.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150089
Organization Id Plan Exception Sets.Organization IdORGANIZATION_IDORGANIZATION_ID150345
Organization Name Plan Exception Sets.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150643
Overload ToleranceOver utilized percentPlan Exception Sets.Overload ToleranceOVERLOAD_TOLERANCEOVERLOAD_TOLERANCE151706
Overpromised Exception Plan Exception Sets.Overpromised ExceptionOVERPROMISED_EXCEPTIONOVERPROMISED_EXCEPTION272987
Rep Variance Exception Plan Exception Sets.Rep Variance ExceptionREP_VARIANCE_EXCEPTIONREP_VARIANCE_EXCEPTION272988
Repetitive VarianceCummulative variance between the suggested and current repetitive schedulesPlan Exception Sets.Repetitive VarianceREPETITIVE_VARIANCEREPETITIVE_VARIANCE158579
Resource Over Utilized Plan Exception Sets.Resource Over UtilizedRESOURCE_OVER_UTILIZEDRESOURCE_OVER_UTILIZED272986
Resource Under Utilized Plan Exception Sets.Resource Under UtilizedRESOURCE_UNDER_UTILIZEDRESOURCE_UNDER_UTILIZED272985
Shortage Exception Plan Exception Sets.Shortage ExceptionSHORTAGE_EXCEPTIONSHORTAGE_EXCEPTION272983
Underload ToleranceUnder utilized percentPlan Exception Sets.Underload ToleranceUNDERLOAD_TOLERANCEUNDERLOAD_TOLERANCE166215
User Defined Time FenceNumber of days within which planning will generate an exception messagePlan Exception Sets.User Defined Time FenceUSER_DEFINED_TIME_FENCEUSER_DEFINED_TIME_FENCE166676
Created By Plan Exception Sets.Created ByCREATED_BYCREATED_BY124705
Creation Date Plan Exception Sets.Creation DateCREATION_DATECREATION_DATE126131
Creation Date - Day Plan Exception Sets.Creation Date CREATION_DATE_DAY172291
Creation Date - Month Plan Exception Sets.Creation Date CREATION_DATE_MONTH172745
Creation Date - Quarter Plan Exception Sets.Creation Date CREATION_DATE_QUARTER173199
Creation Date - Year Plan Exception Sets.Creation Date CREATION_DATE_YEAR173653
Exception Set NameException set identifierPlan Exception Sets.Exception Set NameEXCEPTION_SET_NAMEEXCEPTION_SET_NAME133769
Excess Exception Plan Exception Sets.Excess ExceptionEXCESS_EXCEPTIONEXCESS_EXCEPTION272984
Excess QuantityQuantity above which planning will generate an exception messagePlan Exception Sets.Excess QuantityEXCESS_QUANTITYEXCESS_QUANTITY133774
Last Update Date Plan Exception Sets.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140667
Last Update Date - Day Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_DAY183694
Last Update Date - Month Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_MONTH184122
Last Update Date - Quarter Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_QUARTER184550
Last Update Date - Year Plan Exception Sets.Last Update Date LAST_UPDATE_DATE_YEAR184978
Last Updated By Plan Exception Sets.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139330
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Exception Sets.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150089
Organization Id Plan Exception Sets.Organization IdORGANIZATION_IDORGANIZATION_ID150345
Organization Name Plan Exception Sets.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150643
Overload ToleranceOver utilized percentPlan Exception Sets.Overload ToleranceOVERLOAD_TOLERANCEOVERLOAD_TOLERANCE151706
Overpromised Exception Plan Exception Sets.Overpromised ExceptionOVERPROMISED_EXCEPTIONOVERPROMISED_EXCEPTION272987
Rep Variance Exception Plan Exception Sets.Rep Variance ExceptionREP_VARIANCE_EXCEPTIONREP_VARIANCE_EXCEPTION272988
Repetitive VarianceCummulative variance between the suggested and current repetitive schedulesPlan Exception Sets.Repetitive VarianceREPETITIVE_VARIANCEREPETITIVE_VARIANCE158579
Resource Over Utilized Plan Exception Sets.Resource Over UtilizedRESOURCE_OVER_UTILIZEDRESOURCE_OVER_UTILIZED272986
Resource Under Utilized Plan Exception Sets.Resource Under UtilizedRESOURCE_UNDER_UTILIZEDRESOURCE_UNDER_UTILIZED272985
Shortage Exception Plan Exception Sets.Shortage ExceptionSHORTAGE_EXCEPTIONSHORTAGE_EXCEPTION272983
Underload ToleranceUnder utilized percentPlan Exception Sets.Underload ToleranceUNDERLOAD_TOLERANCEUNDERLOAD_TOLERANCE166215
User Defined Time FenceNumber of days within which planning will generate an exception messagePlan Exception Sets.User Defined Time FenceUSER_DEFINED_TIME_FENCEUSER_DEFINED_TIME_FENCE166676
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Plan Exception Sets -> Organization ItemsPlan Exception Sets.Exception Set Name = Organization Items.Planning Exception Set Plan Exception Sets.Organization Id = Organization Items.Organization IdMight not exist in master folderOuter join on master No
Plan Exception Sets -> Plan Organization ItemsPlan Exception Sets.Organization Id = Plan Organization Items.Organization Id Plan Exception Sets.Exception Set Name = Plan Organization Items.Planning Exception SetAlways exist in master folderNoneNo