Powered by InfoCaptor


Previous Page   Next Page

Plan Demands
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_PLAN_DEMANDSUnknown
NoneNone.MRPFG_PLAN_DEMANDSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created By Plan Demands.Created ByCREATED_BYCREATED_BY124702
Creation Date Plan Demands.Creation DateCREATION_DATECREATION_DATE126128
Creation Date - Day Plan Demands.Creation Date CREATION_DATE_DAY172285
Creation Date - Month Plan Demands.Creation Date CREATION_DATE_MONTH172739
Creation Date - Quarter Plan Demands.Creation Date CREATION_DATE_QUARTER173193
Creation Date - Year Plan Demands.Creation Date CREATION_DATE_YEAR173647
Days From TodayDays from today to Order DatePlan Demands.Days From TodayDAYS_FROM_TODAYDAYS_FROM_TODAY128664
Inventory Item IdInventory item identifierPlan Demands.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137228
Item Plan Demands.ItemITEMITEM272979
Item Number Plan Demands.Item NumberITEM_NUMBERITEM_NUMBER272978
Last Unit Completion DateLast Unit Completion Date for recommended repetitive schedulesPlan Demands.Last Unit Completion DateLAST_UNIT_COMPLETION_DATELAST_UNIT_COMPLETION_DATE138655
Last Unit Completion Date - Day Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_DAY182770
Last Unit Completion Date - Month Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_MONTH182776
Last Unit Completion Date - Quarter Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_QUARTER182782
Last Unit Completion Date - Year Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_YEAR182788
Last Update Date Plan Demands.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140664
Last Update Date - Day Plan Demands.Last Update Date LAST_UPDATE_DATE_DAY183688
Last Update Date - Month Plan Demands.Last Update Date LAST_UPDATE_DATE_MONTH184116
Last Update Date - Quarter Plan Demands.Last Update Date LAST_UPDATE_DATE_QUARTER184544
Last Update Date - Year Plan Demands.Last Update Date LAST_UPDATE_DATE_YEAR184972
Last Updated By Plan Demands.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139327
Lending Project IdLending project identifierPlan Demands.Lending Project IdLENDING_PROJECT_IDLENDING_PROJECT_ID141944
Lending Project Number Plan Demands.Lending Project NumberLENDING_PROJECT_NUMBERLENDING_PROJECT_NUMBER141945
Lending Task IdLending task identifierPlan Demands.Lending Task IdLENDING_TASK_IDLENDING_TASK_ID141946
Lending Task Number Plan Demands.Lending Task NumberLENDING_TASK_NUMBERLENDING_TASK_NUMBER141947
Mds Entry IdMaster demand schedule entry identifierPlan Demands.Mds Entry IdMDS_ENTRY_IDMDS_ENTRY_ID146514
Mfg Order IdManufacturing order identifierPlan Demands.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147057
New DateFirm datePlan Demands.New DateNEW_DATENEW_DATE148032
New Date - Day Plan Demands.New Date NEW_DATE_DAY186607
New Date - Month Plan Demands.New Date NEW_DATE_MONTH186609
New Date - Quarter Plan Demands.New Date NEW_DATE_QUARTER186611
New Date - Year Plan Demands.New Date NEW_DATE_YEAR186613
New QuantityFirm quantityPlan Demands.New QuantityNEW_QUANTITYNEW_QUANTITY148042
Old Due DateOld order due datePlan Demands.Old Due DateOLD_DUE_DATEOLD_DUE_DATE149385
Old Due Date - Day Plan Demands.Old Due Date OLD_DUE_DATE_DAY187094
Old Due Date - Month Plan Demands.Old Due Date OLD_DUE_DATE_MONTH187098
Old Due Date - Quarter Plan Demands.Old Due Date OLD_DUE_DATE_QUARTER187102
Old Due Date - Year Plan Demands.Old Due Date OLD_DUE_DATE_YEAR187106
Order NumberOrder number which identifies the specific entity that generated the demandPlan Demands.Order NumberORDER_NUMBERORDER_NUMBER149873
Order TypeCode uses to identify the type of demandPlan Demands.Order TypeORDER_TYPEORDER_TYPE149903
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Demands.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150086
Organization Id Plan Demands.Organization IdORGANIZATION_IDORGANIZATION_ID150342
Organization Name Plan Demands.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150640
Original Quantity RateOld demand quantityPlan Demands.Original Quantity RateORIGINAL_QUANTITY_RATEORIGINAL_QUANTITY_RATE151217
Plan Demand IdPlan demand unique identifierPlan Demands.Plan Demand IdPLAN_DEMAND_IDPLAN_DEMAND_ID154275
Plan NameName of MPS, MRP, or DRP planPlan Demands.Plan NamePLAN_NAMEPLAN_NAME154307
Plan Supply IdPlan supply identifierPlan Demands.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154338
Planning GroupPlanning group codePlan Demands.Planning GroupPLANNING_GROUPPLANNING_GROUP154244
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Demands.Project IdPROJECT_IDPROJECT_ID156467
Project Number Plan Demands.Project NumberPROJECT_NUMBERPROJECT_NUMBER156638
Quantity RateOrder quantityPlan Demands.Quantity RateQUANTITY_RATEQUANTITY_RATE157315
Source Organization CodeSource organization code which generated the demandPlan Demands.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162472
Source Organization IdSource organization identitfierPlan Demands.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162489
Source Organization NameSource organization name which generated the demandPlan Demands.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162508
Suggested Due DateOrder suggested due datePlan Demands.Suggested Due DateSUGGESTED_DUE_DATESUGGESTED_DUE_DATE163996
Suggested Due Date - Day Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_DAY191676
Suggested Due Date - Month Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_MONTH191680
Suggested Due Date - Quarter Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_QUARTER191684
Suggested Due Date - Year Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_YEAR191688
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 Demands.Task IdTASK_IDTASK_ID164590
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 Demands.Task NumberTASK_NUMBERTASK_NUMBER164665
Unit NumberEnd item unit numberPlan Demands.Unit NumberUNIT_NUMBERUNIT_NUMBER166256
Created By Plan Demands.Created ByCREATED_BYCREATED_BY124702
Creation Date Plan Demands.Creation DateCREATION_DATECREATION_DATE126128
Creation Date - Day Plan Demands.Creation Date CREATION_DATE_DAY172285
Creation Date - Month Plan Demands.Creation Date CREATION_DATE_MONTH172739
Creation Date - Quarter Plan Demands.Creation Date CREATION_DATE_QUARTER173193
Creation Date - Year Plan Demands.Creation Date CREATION_DATE_YEAR173647
Days From TodayDays from today to Order DatePlan Demands.Days From TodayDAYS_FROM_TODAYDAYS_FROM_TODAY128664
Inventory Item IdInventory item identifierPlan Demands.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137228
Item Plan Demands.ItemITEMITEM272979
Item Number Plan Demands.Item NumberITEM_NUMBERITEM_NUMBER272978
Last Unit Completion DateLast Unit Completion Date for recommended repetitive schedulesPlan Demands.Last Unit Completion DateLAST_UNIT_COMPLETION_DATELAST_UNIT_COMPLETION_DATE138655
Last Unit Completion Date - Day Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_DAY182770
Last Unit Completion Date - Month Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_MONTH182776
Last Unit Completion Date - Quarter Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_QUARTER182782
Last Unit Completion Date - Year Plan Demands.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_YEAR182788
Last Update Date Plan Demands.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140664
Last Update Date - Day Plan Demands.Last Update Date LAST_UPDATE_DATE_DAY183688
Last Update Date - Month Plan Demands.Last Update Date LAST_UPDATE_DATE_MONTH184116
Last Update Date - Quarter Plan Demands.Last Update Date LAST_UPDATE_DATE_QUARTER184544
Last Update Date - Year Plan Demands.Last Update Date LAST_UPDATE_DATE_YEAR184972
Last Updated By Plan Demands.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139327
Lending Project IdLending project identifierPlan Demands.Lending Project IdLENDING_PROJECT_IDLENDING_PROJECT_ID141944
Lending Project Number Plan Demands.Lending Project NumberLENDING_PROJECT_NUMBERLENDING_PROJECT_NUMBER141945
Lending Task IdLending task identifierPlan Demands.Lending Task IdLENDING_TASK_IDLENDING_TASK_ID141946
Lending Task Number Plan Demands.Lending Task NumberLENDING_TASK_NUMBERLENDING_TASK_NUMBER141947
Mds Entry IdMaster demand schedule entry identifierPlan Demands.Mds Entry IdMDS_ENTRY_IDMDS_ENTRY_ID146514
Mfg Order IdManufacturing order identifierPlan Demands.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147057
New DateFirm datePlan Demands.New DateNEW_DATENEW_DATE148032
New Date - Day Plan Demands.New Date NEW_DATE_DAY186607
New Date - Month Plan Demands.New Date NEW_DATE_MONTH186609
New Date - Quarter Plan Demands.New Date NEW_DATE_QUARTER186611
New Date - Year Plan Demands.New Date NEW_DATE_YEAR186613
New QuantityFirm quantityPlan Demands.New QuantityNEW_QUANTITYNEW_QUANTITY148042
Old Due DateOld order due datePlan Demands.Old Due DateOLD_DUE_DATEOLD_DUE_DATE149385
Old Due Date - Day Plan Demands.Old Due Date OLD_DUE_DATE_DAY187094
Old Due Date - Month Plan Demands.Old Due Date OLD_DUE_DATE_MONTH187098
Old Due Date - Quarter Plan Demands.Old Due Date OLD_DUE_DATE_QUARTER187102
Old Due Date - Year Plan Demands.Old Due Date OLD_DUE_DATE_YEAR187106
Order NumberOrder number which identifies the specific entity that generated the demandPlan Demands.Order NumberORDER_NUMBERORDER_NUMBER149873
Order TypeCode uses to identify the type of demandPlan Demands.Order TypeORDER_TYPEORDER_TYPE149903
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Demands.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150086
Organization Id Plan Demands.Organization IdORGANIZATION_IDORGANIZATION_ID150342
Organization Name Plan Demands.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150640
Original Quantity RateOld demand quantityPlan Demands.Original Quantity RateORIGINAL_QUANTITY_RATEORIGINAL_QUANTITY_RATE151217
Plan Demand IdPlan demand unique identifierPlan Demands.Plan Demand IdPLAN_DEMAND_IDPLAN_DEMAND_ID154275
Plan NameName of MPS, MRP, or DRP planPlan Demands.Plan NamePLAN_NAMEPLAN_NAME154307
Plan Supply IdPlan supply identifierPlan Demands.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154338
Planning GroupPlanning group codePlan Demands.Planning GroupPLANNING_GROUPPLANNING_GROUP154244
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Demands.Project IdPROJECT_IDPROJECT_ID156467
Project Number Plan Demands.Project NumberPROJECT_NUMBERPROJECT_NUMBER156638
Quantity RateOrder quantityPlan Demands.Quantity RateQUANTITY_RATEQUANTITY_RATE157315
Source Organization CodeSource organization code which generated the demandPlan Demands.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162472
Source Organization IdSource organization identitfierPlan Demands.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162489
Source Organization NameSource organization name which generated the demandPlan Demands.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162508
Suggested Due DateOrder suggested due datePlan Demands.Suggested Due DateSUGGESTED_DUE_DATESUGGESTED_DUE_DATE163996
Suggested Due Date - Day Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_DAY191676
Suggested Due Date - Month Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_MONTH191680
Suggested Due Date - Quarter Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_QUARTER191684
Suggested Due Date - Year Plan Demands.Suggested Due Date SUGGESTED_DUE_DATE_YEAR191688
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 Demands.Task IdTASK_IDTASK_ID164590
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 Demands.Task NumberTASK_NUMBERTASK_NUMBER164665
Unit NumberEnd item unit numberPlan Demands.Unit NumberUNIT_NUMBERUNIT_NUMBER166256
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Plan Demands -> Plan Exception DetailsPlan Demands.Plan Demand Id = Plan Exception Details.Plan Demand IdMight not exist in master folderOuter join on master No
Plan Demands -> Plan Exception Details 1Plan Demands.Plan Demand Id = Plan Exception Details.Plan Demand IdAlways exist in master folderNoneNo
Plan Demands -> Plan PegsPlan Demands.Plan Demand Id = Plan Pegging.Plan Demand IdAlways exist in master folderNoneNo