Powered by InfoCaptor


Previous Page   Next Page

Forecast Sets
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_FORECAST_SETSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Backward Consumption DaysNumber of days backward from current date used for consuming and loading forecastsForecast Sets.Backward Consumption DaysBACKWARD_CONSUMPTION_DAYSBACKWARD_CONSUMPTION_DAYS118786
Bucket Type Forecast Sets.Bucket TypeBUCKET_TYPEBUCKET_TYPE272943
Consume Flag Forecast Sets.Consume FlagCONSUME_FLAGCONSUME_FLAG272945
Created By Forecast Sets.Created ByCREATED_BYCREATED_BY124691
Creation Date Forecast Sets.Creation DateCREATION_DATECREATION_DATE126117
Creation Date - Day Forecast Sets.Creation Date CREATION_DATE_DAY172263
Creation Date - Month Forecast Sets.Creation Date CREATION_DATE_MONTH172717
Creation Date - Quarter Forecast Sets.Creation Date CREATION_DATE_QUARTER173171
Creation Date - Year Forecast Sets.Creation Date CREATION_DATE_YEAR173625
Forecast Level Forecast Sets.Forecast LevelFORECAST_LEVELFORECAST_LEVEL272944
Forecast Set DescriptionDescribes the forecast setForecast Sets.Forecast Set DescriptionFORECAST_SET_DESCRIPTIONFORECAST_SET_DESCRIPTION134525
Forecast Set NameName of forecast setForecast Sets.Forecast Set NameFORECAST_SET_NAMEFORECAST_SET_NAME134527
Forward Consumption DaysNumber of days forward from current date used for consuming and loading forecastsForecast Sets.Forward Consumption DaysFORWARD_CONSUMPTION_DAYSFORWARD_CONSUMPTION_DAYS134642
Inactive DateDate on which bank account becomes inactive.Forecast Sets.Inactive DateINACTIVE_DATEINACTIVE_DATE136191
Inactive Date - Day Forecast Sets.Inactive Date INACTIVE_DATE_DAY181165
Inactive Date - Month Forecast Sets.Inactive Date INACTIVE_DATE_MONTH181235
Inactive Date - Quarter Forecast Sets.Inactive Date INACTIVE_DATE_QUARTER181305
Inactive Date - Year Forecast Sets.Inactive Date INACTIVE_DATE_YEAR181375
Last Update Date Forecast Sets.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140653
Last Update Date - Day Forecast Sets.Last Update Date LAST_UPDATE_DATE_DAY183666
Last Update Date - Month Forecast Sets.Last Update Date LAST_UPDATE_DATE_MONTH184094
Last Update Date - Quarter Forecast Sets.Last Update Date LAST_UPDATE_DATE_QUARTER184522
Last Update Date - Year Forecast Sets.Last Update Date LAST_UPDATE_DATE_YEAR184950
Last Updated By Forecast Sets.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139316
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Forecast Sets.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150075
Organization Id Forecast Sets.Organization IdORGANIZATION_IDORGANIZATION_ID150331
Organization Name Forecast Sets.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150629
Outlier PercentageThe maximum percent of original quantity forecast that a sales order consumesForecast Sets.Outlier PercentageOUTLIER_PERCENTAGEOUTLIER_PERCENTAGE151628
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Forecast Sets -> ForecastsForecast Sets.Organization Id = Forecasts.Organization Id Forecast Sets.Forecast Set Name = Forecasts.Forecast Set NameAlways exist in master folderNoneNo