Powered by InfoCaptor


Previous Page   Next Page

Plan Pegging
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_PLAN_PEGSUnknown
NoneNone.MRPFG_PLAN_PEGSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created By Plan Pegging.Created ByCREATED_BYCREATED_BY124710
Creation Date Plan Pegging.Creation DateCREATION_DATECREATION_DATE126136
Creation Date - Day Plan Pegging.Creation Date CREATION_DATE_DAY172301
Creation Date - Month Plan Pegging.Creation Date CREATION_DATE_MONTH172755
Creation Date - Quarter Plan Pegging.Creation Date CREATION_DATE_QUARTER173209
Creation Date - Year Plan Pegging.Creation Date CREATION_DATE_YEAR173663
Demand Date Plan Pegging.Demand DateDEMAND_DATEDEMAND_DATE129090
Demand Date - Day Plan Pegging.Demand Date DEMAND_DATE_DAY176069
Demand Date - Month Plan Pegging.Demand Date DEMAND_DATE_MONTH176073
Demand Date - Quarter Plan Pegging.Demand Date DEMAND_DATE_QUARTER176077
Demand Date - Year Plan Pegging.Demand Date DEMAND_DATE_YEAR176081
Demand QuantityDemand quantiyPlan Pegging.Demand QuantityDEMAND_QUANTITYDEMAND_QUANTITY129093
Demand Type Of End DemandOrigination type of the end demandPlan Pegging.Demand Type Of End DemandDEMAND_TYPE_OF_END_DEMANDDEMAND_TYPE_OF_END_DEMAND129113
End Item UsageUsage of current item in end assemblyPlan Pegging.End Item UsageEND_ITEM_USAGEEND_ITEM_USAGE133157
End Pegging IdEnd plan pegging identifierPlan Pegging.End Pegging IdEND_PEGGING_IDEND_PEGGING_ID133163
Inventory Item IdInventory item identifierPlan Pegging.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137232
Item Plan Pegging.ItemITEMITEM273100
Item Number Plan Pegging.Item NumberITEM_NUMBERITEM_NUMBER273099
Last Update Date Plan Pegging.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140672
Last Update Date - Day Plan Pegging.Last Update Date LAST_UPDATE_DATE_DAY183704
Last Update Date - Month Plan Pegging.Last Update Date LAST_UPDATE_DATE_MONTH184132
Last Update Date - Quarter Plan Pegging.Last Update Date LAST_UPDATE_DATE_QUARTER184560
Last Update Date - Year Plan Pegging.Last Update Date LAST_UPDATE_DATE_YEAR184988
Last Updated By Plan Pegging.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139335
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Pegging.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150093
Organization Id Plan Pegging.Organization IdORGANIZATION_IDORGANIZATION_ID150349
Organization Name Plan Pegging.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150647
Pegging IdPlan pegging identifierPlan Pegging.Pegging IdPEGGING_IDPEGGING_ID152705
Plan Demand IdPlan demand identifierPlan Pegging.Plan Demand IdPLAN_DEMAND_IDPLAN_DEMAND_ID154277
Plan NameName of MRP, MPS, or DRP planPlan Pegging.Plan NamePLAN_NAMEPLAN_NAME154314
Plan Supply IdPlan supply identifierPlan Pegging.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154340
Prev Pegging IdPrevious plan pegging identifierPlan Pegging.Prev Pegging IdPREV_PEGGING_IDPREV_PEGGING_ID155261
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Pegging.Project IdPROJECT_IDPROJECT_ID156470
Project Number Plan Pegging.Project NumberPROJECT_NUMBERPROJECT_NUMBER156641
Supply Allocated QuantityPortion of supply allocated to demandPlan Pegging.Supply Allocated QuantitySUPPLY_ALLOCATED_QUANTITYSUPPLY_ALLOCATED_QUANTITY164343
Supply Date Plan Pegging.Supply DateSUPPLY_DATESUPPLY_DATE164346
Supply Date - Day Plan Pegging.Supply Date SUPPLY_DATE_DAY191794
Supply Date - Month Plan Pegging.Supply Date SUPPLY_DATE_MONTH191796
Supply Date - Quarter Plan Pegging.Supply Date SUPPLY_DATE_QUARTER191798
Supply Date - Year Plan Pegging.Supply Date SUPPLY_DATE_YEAR191800
Supply Quantity Plan Pegging.Supply QuantitySUPPLY_QUANTITYSUPPLY_QUANTITY164350
Supply TypeIndicate type of supplyPlan Pegging.Supply TypeSUPPLY_TYPESUPPLY_TYPE164356
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 Pegging.Task IdTASK_IDTASK_ID164593
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 Pegging.Task NumberTASK_NUMBERTASK_NUMBER164668
Created By Plan Pegging.Created ByCREATED_BYCREATED_BY124710
Creation Date Plan Pegging.Creation DateCREATION_DATECREATION_DATE126136
Creation Date - Day Plan Pegging.Creation Date CREATION_DATE_DAY172301
Creation Date - Month Plan Pegging.Creation Date CREATION_DATE_MONTH172755
Creation Date - Quarter Plan Pegging.Creation Date CREATION_DATE_QUARTER173209
Creation Date - Year Plan Pegging.Creation Date CREATION_DATE_YEAR173663
Demand Date Plan Pegging.Demand DateDEMAND_DATEDEMAND_DATE129090
Demand Date - Day Plan Pegging.Demand Date DEMAND_DATE_DAY176069
Demand Date - Month Plan Pegging.Demand Date DEMAND_DATE_MONTH176073
Demand Date - Quarter Plan Pegging.Demand Date DEMAND_DATE_QUARTER176077
Demand Date - Year Plan Pegging.Demand Date DEMAND_DATE_YEAR176081
Demand QuantityDemand quantiyPlan Pegging.Demand QuantityDEMAND_QUANTITYDEMAND_QUANTITY129093
Demand Type Of End DemandOrigination type of the end demandPlan Pegging.Demand Type Of End DemandDEMAND_TYPE_OF_END_DEMANDDEMAND_TYPE_OF_END_DEMAND129113
End Item UsageUsage of current item in end assemblyPlan Pegging.End Item UsageEND_ITEM_USAGEEND_ITEM_USAGE133157
End Pegging IdEnd plan pegging identifierPlan Pegging.End Pegging IdEND_PEGGING_IDEND_PEGGING_ID133163
Inventory Item IdInventory item identifierPlan Pegging.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137232
Item Plan Pegging.ItemITEMITEM273100
Item Number Plan Pegging.Item NumberITEM_NUMBERITEM_NUMBER273099
Last Update Date Plan Pegging.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140672
Last Update Date - Day Plan Pegging.Last Update Date LAST_UPDATE_DATE_DAY183704
Last Update Date - Month Plan Pegging.Last Update Date LAST_UPDATE_DATE_MONTH184132
Last Update Date - Quarter Plan Pegging.Last Update Date LAST_UPDATE_DATE_QUARTER184560
Last Update Date - Year Plan Pegging.Last Update Date LAST_UPDATE_DATE_YEAR184988
Last Updated By Plan Pegging.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139335
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Pegging.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150093
Organization Id Plan Pegging.Organization IdORGANIZATION_IDORGANIZATION_ID150349
Organization Name Plan Pegging.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150647
Pegging IdPlan pegging identifierPlan Pegging.Pegging IdPEGGING_IDPEGGING_ID152705
Plan Demand IdPlan demand identifierPlan Pegging.Plan Demand IdPLAN_DEMAND_IDPLAN_DEMAND_ID154277
Plan NameName of MRP, MPS, or DRP planPlan Pegging.Plan NamePLAN_NAMEPLAN_NAME154314
Plan Supply IdPlan supply identifierPlan Pegging.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154340
Prev Pegging IdPrevious plan pegging identifierPlan Pegging.Prev Pegging IdPREV_PEGGING_IDPREV_PEGGING_ID155261
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Pegging.Project IdPROJECT_IDPROJECT_ID156470
Project Number Plan Pegging.Project NumberPROJECT_NUMBERPROJECT_NUMBER156641
Supply Allocated QuantityPortion of supply allocated to demandPlan Pegging.Supply Allocated QuantitySUPPLY_ALLOCATED_QUANTITYSUPPLY_ALLOCATED_QUANTITY164343
Supply Date Plan Pegging.Supply DateSUPPLY_DATESUPPLY_DATE164346
Supply Date - Day Plan Pegging.Supply Date SUPPLY_DATE_DAY191794
Supply Date - Month Plan Pegging.Supply Date SUPPLY_DATE_MONTH191796
Supply Date - Quarter Plan Pegging.Supply Date SUPPLY_DATE_QUARTER191798
Supply Date - Year Plan Pegging.Supply Date SUPPLY_DATE_YEAR191800
Supply Quantity Plan Pegging.Supply QuantitySUPPLY_QUANTITYSUPPLY_QUANTITY164350
Supply TypeIndicate type of supplyPlan Pegging.Supply TypeSUPPLY_TYPESUPPLY_TYPE164356
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 Pegging.Task IdTASK_IDTASK_ID164593
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 Pegging.Task NumberTASK_NUMBERTASK_NUMBER164668
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto