Powered by InfoCaptor


Previous Page   Next Page

Forecast Entries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_FORECAST_ENTRIESUnknown
NoneNone.MRPFG_FORECAST_ENTRIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bucket Type Forecast Entries.Bucket TypeBUCKET_TYPEBUCKET_TYPE272926
CommentsFreeform text/comments.Forecast Entries.CommentsCOMMENTSCOMMENTS122530
Confidence PercentForecast confidence percentageForecast Entries.Confidence PercentCONFIDENCE_PERCENTCONFIDENCE_PERCENT123078
Created By Forecast Entries.Created ByCREATED_BYCREATED_BY124688
Creation Date Forecast Entries.Creation DateCREATION_DATECREATION_DATE126114
Creation Date - Day Forecast Entries.Creation Date CREATION_DATE_DAY172257
Creation Date - Month Forecast Entries.Creation Date CREATION_DATE_MONTH172711
Creation Date - Quarter Forecast Entries.Creation Date CREATION_DATE_QUARTER173165
Creation Date - Year Forecast Entries.Creation Date CREATION_DATE_YEAR173619
Current Forecast QuantityConsumed forecast quantityForecast Entries.Current Forecast QuantityCURRENT_FORECAST_QUANTITYCURRENT_FORECAST_QUANTITY127356
Demand ClassDemand class codeForecast Entries.Demand ClassDEMAND_CLASSDEMAND_CLASS129080
End DateEnd effective date for the accounting cost.Forecast Entries.End DateEND_DATEEND_DATE132833
End Date - Day Forecast Entries.End Date END_DATE_DAY178457
End Date - Month Forecast Entries.End Date END_DATE_MONTH178483
End Date - Quarter Forecast Entries.End Date END_DATE_QUARTER178509
End Date - Year Forecast Entries.End Date END_DATE_YEAR178535
End Item IdEnd item idenfier for entry exploded from another itemForecast Entries.End Item IdEND_ITEM_IDEND_ITEM_ID133153
End Item Number Forecast Entries.End Item NumberEND_ITEM_NUMBEREND_ITEM_NUMBER272928
End Planning BOM PercentEnd planning percent for entries exploded from another itemForecast Entries.End Planning BOM PercentEND_PLANNING_BOM_PERCENTEND_PLANNING_BOM_PERCENT133168
Forecast DateThe date for a forecast entry for an itemForecast Entries.Forecast DateFORECAST_DATEFORECAST_DATE134485
Forecast Date - Day Forecast Entries.Forecast Date FORECAST_DATE_DAY179657
Forecast Date - Month Forecast Entries.Forecast Date FORECAST_DATE_MONTH179665
Forecast Date - Quarter Forecast Entries.Forecast Date FORECAST_DATE_QUARTER179671
Forecast Date - Year Forecast Entries.Forecast Date FORECAST_DATE_YEAR179677
Forecast Entry IdForecast entry identifierForecast Entries.Forecast Entry IdFORECAST_ENTRY_IDFORECAST_ENTRY_ID134488
Forecast NameThe name of the forecast to which this 'cell' belongs.Forecast Entries.Forecast NameFORECAST_NAMEFORECAST_NAME134513
Forecast Rule IdForecast rule identifierForecast Entries.Forecast Rule IdFORECAST_RULE_IDFORECAST_RULE_ID134520
Forecast Rule NameName of forecast ruleForecast Entries.Forecast Rule NameFORECAST_RULE_NAMEFORECAST_RULE_NAME134522
Inventory Item IdInventory item identifierForecast Entries.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137222
Item Forecast Entries.ItemITEMITEM272925
Item 1 Forecast Entries.Item 1ITEM_1ITEM_1272929
Item Number Forecast Entries.Item NumberITEM_NUMBERITEM_NUMBER272924
Last Update Date Forecast Entries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140650
Last Update Date - Day Forecast Entries.Last Update Date LAST_UPDATE_DATE_DAY183660
Last Update Date - Month Forecast Entries.Last Update Date LAST_UPDATE_DATE_MONTH184088
Last Update Date - Quarter Forecast Entries.Last Update Date LAST_UPDATE_DATE_QUARTER184516
Last Update Date - Year Forecast Entries.Last Update Date LAST_UPDATE_DATE_YEAR184944
Last Updated By Forecast Entries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139313
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Forecast Entries.Line IdLINE_IDLINE_ID144636
Line NameManufacturing LineForecast Entries.Line NameLINE_NAMELINE_NAME144691
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Forecast Entries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150073
Organization Id Forecast Entries.Organization IdORGANIZATION_IDORGANIZATION_ID150329
Organization Name Forecast Entries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150627
Original Forecast QuantityUnconsumed forecast quantityForecast Entries.Original Forecast QuantityORIGINAL_FORECAST_QUANTITYORIGINAL_FORECAST_QUANTITY151202
Origination Type Forecast Entries.Origination TypeORIGINATION_TYPEORIGINATION_TYPE272927
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Forecast Entries.Project IdPROJECT_IDPROJECT_ID156464
Project Number Forecast Entries.Project NumberPROJECT_NUMBERPROJECT_NUMBER156635
Source Forecast NameSource forecast that generated the forecast entryForecast Entries.Source Forecast NameSOURCE_FORECAST_NAMESOURCE_FORECAST_NAME162405
Source Organization CodeSource organization code from which the forecast entry was loadedForecast Entries.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162469
Source Organization IdSource organization identifier that generated the entryForecast Entries.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162486
Source Organization NameSource organization name from which the forecast entry was loadedForecast Entries.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162505
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.Forecast Entries.Task IdTASK_IDTASK_ID164587
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.Forecast Entries.Task NumberTASK_NUMBERTASK_NUMBER164662
Bucket Type Forecast Entries.Bucket TypeBUCKET_TYPEBUCKET_TYPE272926
CommentsFreeform text/comments.Forecast Entries.CommentsCOMMENTSCOMMENTS122530
Confidence PercentForecast confidence percentageForecast Entries.Confidence PercentCONFIDENCE_PERCENTCONFIDENCE_PERCENT123078
Created By Forecast Entries.Created ByCREATED_BYCREATED_BY124688
Creation Date Forecast Entries.Creation DateCREATION_DATECREATION_DATE126114
Creation Date - Day Forecast Entries.Creation Date CREATION_DATE_DAY172257
Creation Date - Month Forecast Entries.Creation Date CREATION_DATE_MONTH172711
Creation Date - Quarter Forecast Entries.Creation Date CREATION_DATE_QUARTER173165
Creation Date - Year Forecast Entries.Creation Date CREATION_DATE_YEAR173619
Current Forecast QuantityConsumed forecast quantityForecast Entries.Current Forecast QuantityCURRENT_FORECAST_QUANTITYCURRENT_FORECAST_QUANTITY127356
Demand ClassDemand class codeForecast Entries.Demand ClassDEMAND_CLASSDEMAND_CLASS129080
End DateEnd effective date for the accounting cost.Forecast Entries.End DateEND_DATEEND_DATE132833
End Date - Day Forecast Entries.End Date END_DATE_DAY178457
End Date - Month Forecast Entries.End Date END_DATE_MONTH178483
End Date - Quarter Forecast Entries.End Date END_DATE_QUARTER178509
End Date - Year Forecast Entries.End Date END_DATE_YEAR178535
End Item IdEnd item idenfier for entry exploded from another itemForecast Entries.End Item IdEND_ITEM_IDEND_ITEM_ID133153
End Item Number Forecast Entries.End Item NumberEND_ITEM_NUMBEREND_ITEM_NUMBER272928
End Planning BOM PercentEnd planning percent for entries exploded from another itemForecast Entries.End Planning BOM PercentEND_PLANNING_BOM_PERCENTEND_PLANNING_BOM_PERCENT133168
Forecast DateThe date for a forecast entry for an itemForecast Entries.Forecast DateFORECAST_DATEFORECAST_DATE134485
Forecast Date - Day Forecast Entries.Forecast Date FORECAST_DATE_DAY179657
Forecast Date - Month Forecast Entries.Forecast Date FORECAST_DATE_MONTH179665
Forecast Date - Quarter Forecast Entries.Forecast Date FORECAST_DATE_QUARTER179671
Forecast Date - Year Forecast Entries.Forecast Date FORECAST_DATE_YEAR179677
Forecast Entry IdForecast entry identifierForecast Entries.Forecast Entry IdFORECAST_ENTRY_IDFORECAST_ENTRY_ID134488
Forecast NameThe name of the forecast to which this 'cell' belongs.Forecast Entries.Forecast NameFORECAST_NAMEFORECAST_NAME134513
Forecast Rule IdForecast rule identifierForecast Entries.Forecast Rule IdFORECAST_RULE_IDFORECAST_RULE_ID134520
Forecast Rule NameName of forecast ruleForecast Entries.Forecast Rule NameFORECAST_RULE_NAMEFORECAST_RULE_NAME134522
Inventory Item IdInventory item identifierForecast Entries.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137222
Item Forecast Entries.ItemITEMITEM272925
Item 1 Forecast Entries.Item 1ITEM_1ITEM_1272929
Item Number Forecast Entries.Item NumberITEM_NUMBERITEM_NUMBER272924
Last Update Date Forecast Entries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140650
Last Update Date - Day Forecast Entries.Last Update Date LAST_UPDATE_DATE_DAY183660
Last Update Date - Month Forecast Entries.Last Update Date LAST_UPDATE_DATE_MONTH184088
Last Update Date - Quarter Forecast Entries.Last Update Date LAST_UPDATE_DATE_QUARTER184516
Last Update Date - Year Forecast Entries.Last Update Date LAST_UPDATE_DATE_YEAR184944
Last Updated By Forecast Entries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139313
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Forecast Entries.Line IdLINE_IDLINE_ID144636
Line NameManufacturing LineForecast Entries.Line NameLINE_NAMELINE_NAME144691
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Forecast Entries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150073
Organization Id Forecast Entries.Organization IdORGANIZATION_IDORGANIZATION_ID150329
Organization Name Forecast Entries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150627
Original Forecast QuantityUnconsumed forecast quantityForecast Entries.Original Forecast QuantityORIGINAL_FORECAST_QUANTITYORIGINAL_FORECAST_QUANTITY151202
Origination Type Forecast Entries.Origination TypeORIGINATION_TYPEORIGINATION_TYPE272927
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Forecast Entries.Project IdPROJECT_IDPROJECT_ID156464
Project Number Forecast Entries.Project NumberPROJECT_NUMBERPROJECT_NUMBER156635
Source Forecast NameSource forecast that generated the forecast entryForecast Entries.Source Forecast NameSOURCE_FORECAST_NAMESOURCE_FORECAST_NAME162405
Source Organization CodeSource organization code from which the forecast entry was loadedForecast Entries.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162469
Source Organization IdSource organization identifier that generated the entryForecast Entries.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162486
Source Organization NameSource organization name from which the forecast entry was loadedForecast Entries.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162505
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.Forecast Entries.Task IdTASK_IDTASK_ID164587
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.Forecast Entries.Task NumberTASK_NUMBERTASK_NUMBER164662
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Forecast Entries -> Master Demand Schedule EntriesForecast Entries.Forecast Entry Id = Master Demand Schedule Entries.Forecast Entry IdAlways exist in master folderNoneNo
Forecast Entries -> Master Demand Schedule Entries 1Forecast Entries.Forecast Entry Id = Master Demand Schedule Entries.Forecast Entry IdMight not exist in master folderOuter join on master No
Forecast Entries -> Master Production Schedule EntriesForecast Entries.Forecast Entry Id = Master Production Schedule Entries.Forecast Entry IdMight not exist in master folderOuter join on master No