Powered by InfoCaptor


Previous Page   Next Page

Forecast Items
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_FORECAST_ITEMSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate BillAlternate bill codeForecast Items.Alternate BillALTERNATE_BILLALTERNATE_BILL115760
Bill Type Forecast Items.Bill TypeBILL_TYPEBILL_TYPE272932
Created By Forecast Items.Created ByCREATED_BYCREATED_BY124689
Creation Date Forecast Items.Creation DateCREATION_DATECREATION_DATE126115
Creation Date - Day Forecast Items.Creation Date CREATION_DATE_DAY172259
Creation Date - Month Forecast Items.Creation Date CREATION_DATE_MONTH172713
Creation Date - Quarter Forecast Items.Creation Date CREATION_DATE_QUARTER173167
Creation Date - Year Forecast Items.Creation Date CREATION_DATE_YEAR173621
DescriptionThe accounting period description.Forecast Items.DescriptionDESCRIPTIONDESCRIPTION129607
Forecast Control Forecast Items.Forecast ControlFORECAST_CONTROLFORECAST_CONTROL272933
Forecast NameThe name of the forecast to which this 'cell' belongs.Forecast Items.Forecast NameFORECAST_NAMEFORECAST_NAME134514
Inventory Item IdInventory item identifierForecast Items.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137223
Item Forecast Items.ItemITEMITEM272931
Item Number Forecast Items.Item NumberITEM_NUMBERITEM_NUMBER272930
Last Update Date Forecast Items.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140651
Last Update Date - Day Forecast Items.Last Update Date LAST_UPDATE_DATE_DAY183662
Last Update Date - Month Forecast Items.Last Update Date LAST_UPDATE_DATE_MONTH184090
Last Update Date - Quarter Forecast Items.Last Update Date LAST_UPDATE_DATE_QUARTER184518
Last Update Date - Year Forecast Items.Last Update Date LAST_UPDATE_DATE_YEAR184946
Last Updated By Forecast Items.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139314
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Forecast Items.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150074
Organization Id Forecast Items.Organization IdORGANIZATION_IDORGANIZATION_ID150330
Organization Name Forecast Items.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150628
Planning Method Forecast Items.Planning MethodPLANNING_METHODPLANNING_METHOD272934
Unit of MeasureUnit of measure of the item forecastForecast Items.Unit of MeasureUNIT_OF_MEASUREUNIT_OF_MEASURE166273
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Forecast Items -> Forecast EntriesForecast Items.Organization Id = Forecast Entries.Organization Id Forecast Items.Forecast Name = Forecast Entries.Forecast Name Forecast Items.Inventory Item Id = Forecast Entries.Inventory Item IdAlways exist in master folderNoneNo
Forecast Items -> Forecast Entries 1Forecast Items.Organization Id = Forecast Entries.Organization Id Forecast Items.Forecast Name = Forecast Entries.Forecast Name Forecast Items.Inventory Item Id = Forecast Entries.End Item IdAlways exist in master folderNoneNo