Powered by InfoCaptor


Previous Page   Next Page

Master Demand Schedule Entries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_MDS_ENTRIESUnknown
NoneNone.MRPFG_MDS_ENTRIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
CommentsFreeform text/comments.Master Demand Schedule Entries.CommentsCOMMENTSCOMMENTS122531
Created By Master Demand Schedule Entries.Created ByCREATED_BYCREATED_BY124694
Creation Date Master Demand Schedule Entries.Creation DateCREATION_DATECREATION_DATE126120
Creation Date - Day Master Demand Schedule Entries.Creation Date CREATION_DATE_DAY172269
Creation Date - Month Master Demand Schedule Entries.Creation Date CREATION_DATE_MONTH172723
Creation Date - Quarter Master Demand Schedule Entries.Creation Date CREATION_DATE_QUARTER173177
Creation Date - Year Master Demand Schedule Entries.Creation Date CREATION_DATE_YEAR173631
Current QuantityDemand schedule quantityMaster Demand Schedule Entries.Current QuantityCURRENT_QUANTITYCURRENT_QUANTITY127362
End DateEnd effective date for the accounting cost.Master Demand Schedule Entries.End DateEND_DATEEND_DATE132834
End Date - Day Master Demand Schedule Entries.End Date END_DATE_DAY178459
End Date - Month Master Demand Schedule Entries.End Date END_DATE_MONTH178485
End Date - Quarter Master Demand Schedule Entries.End Date END_DATE_QUARTER178511
End Date - Year Master Demand Schedule Entries.End Date END_DATE_YEAR178537
Forecast Entry IdForecast entry identiferMaster Demand Schedule Entries.Forecast Entry IdFORECAST_ENTRY_IDFORECAST_ENTRY_ID134489
Inventory Item IdInventory item identifier of the entryMaster Demand Schedule Entries.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137224
Last Update Date Master Demand Schedule Entries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140656
Last Update Date - Day Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_DAY183672
Last Update Date - Month Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_MONTH184100
Last Update Date - Quarter Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_QUARTER184528
Last Update Date - Year Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_YEAR184956
Last Updated By Master Demand Schedule Entries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139319
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Master Demand Schedule Entries.Line IdLINE_IDLINE_ID144637
Line NameName of manufacturing lineMaster Demand Schedule Entries.Line NameLINE_NAMELINE_NAME144692
Mds Entry IdMaster demand schedule entry identifierMaster Demand Schedule Entries.Mds Entry IdMDS_ENTRY_IDMDS_ENTRY_ID146513
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Master Demand Schedule Entries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150078
Organization Id Master Demand Schedule Entries.Organization IdORGANIZATION_IDORGANIZATION_ID150334
Organization Name Master Demand Schedule Entries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150632
Original QuantitySchedule quantity before reliefMaster Demand Schedule Entries.Original QuantityORIGINAL_QUANTITYORIGINAL_QUANTITY151215
Origination TypeOrigin of schedule entryMaster Demand Schedule Entries.Origination TypeORIGINATION_TYPEORIGINATION_TYPE151264
Plan Supply IdPlan supply identifierMaster Demand Schedule Entries.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154336
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Master Demand Schedule Entries.Project IdPROJECT_IDPROJECT_ID156465
Project Number Master Demand Schedule Entries.Project NumberPROJECT_NUMBERPROJECT_NUMBER156636
Repetitive Item Daily RateSchedule rate for repetitive itemMaster Demand Schedule Entries.Repetitive Item Daily RateREPETITIVE_ITEM_DAILY_RATEREPETITIVE_ITEM_DAILY_RATE158564
Sales Order Line IdSales order line identifierMaster Demand Schedule Entries.Sales Order Line IdSALES_ORDER_LINE_IDSALES_ORDER_LINE_ID160674
Sales Order Line NumberIndicate which sales order line was loadedMaster Demand Schedule Entries.Sales Order Line NumberSALES_ORDER_LINE_NUMBERSALES_ORDER_LINE_NUMBER160675
Sales Order NumberSpecify which sales order was loadedMaster Demand Schedule Entries.Sales Order NumberSALES_ORDER_NUMBERSALES_ORDER_NUMBER160684
Schedule DateDate associated which schedule entryMaster Demand Schedule Entries.Schedule DateSCHEDULE_DATESCHEDULE_DATE160796
Schedule Date - Day Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_DAY190154
Schedule Date - Month Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_MONTH190158
Schedule Date - Quarter Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_QUARTER190162
Schedule Date - Year Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_YEAR190166
Schedule NameName of master demand scheduleMaster Demand Schedule Entries.Schedule NameSCHEDULE_NAMESCHEDULE_NAME160810
Source Forecast NameForecast name of forecast entry from which the MDS entry was loadedMaster Demand Schedule Entries.Source Forecast NameSOURCE_FORECAST_NAMESOURCE_FORECAST_NAME162406
Source Organization CodeThe organization code from which the entry was loadedMaster Demand Schedule Entries.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162470
Source Organization IdOrganization identifier from which the entry was loadedMaster Demand Schedule Entries.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162487
Source Organization NameThe organization name from which the entry was loadedMaster Demand Schedule Entries.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162506
Source Schedule NameThe schedule name from which the entry was loadedMaster Demand Schedule Entries.Source Schedule NameSOURCE_SCHEDULE_NAMESOURCE_SCHEDULE_NAME162531
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.Master Demand Schedule Entries.Task IdTASK_IDTASK_ID164588
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.Master Demand Schedule Entries.Task NumberTASK_NUMBERTASK_NUMBER164663
Unit NumberEnd item unit numberMaster Demand Schedule Entries.Unit NumberUNIT_NUMBERUNIT_NUMBER166254
CommentsFreeform text/comments.Master Demand Schedule Entries.CommentsCOMMENTSCOMMENTS122531
Created By Master Demand Schedule Entries.Created ByCREATED_BYCREATED_BY124694
Creation Date Master Demand Schedule Entries.Creation DateCREATION_DATECREATION_DATE126120
Creation Date - Day Master Demand Schedule Entries.Creation Date CREATION_DATE_DAY172269
Creation Date - Month Master Demand Schedule Entries.Creation Date CREATION_DATE_MONTH172723
Creation Date - Quarter Master Demand Schedule Entries.Creation Date CREATION_DATE_QUARTER173177
Creation Date - Year Master Demand Schedule Entries.Creation Date CREATION_DATE_YEAR173631
Current QuantityDemand schedule quantityMaster Demand Schedule Entries.Current QuantityCURRENT_QUANTITYCURRENT_QUANTITY127362
End DateEnd effective date for the accounting cost.Master Demand Schedule Entries.End DateEND_DATEEND_DATE132834
End Date - Day Master Demand Schedule Entries.End Date END_DATE_DAY178459
End Date - Month Master Demand Schedule Entries.End Date END_DATE_MONTH178485
End Date - Quarter Master Demand Schedule Entries.End Date END_DATE_QUARTER178511
End Date - Year Master Demand Schedule Entries.End Date END_DATE_YEAR178537
Forecast Entry IdForecast entry identiferMaster Demand Schedule Entries.Forecast Entry IdFORECAST_ENTRY_IDFORECAST_ENTRY_ID134489
Inventory Item IdInventory item identifier of the entryMaster Demand Schedule Entries.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137224
Last Update Date Master Demand Schedule Entries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140656
Last Update Date - Day Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_DAY183672
Last Update Date - Month Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_MONTH184100
Last Update Date - Quarter Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_QUARTER184528
Last Update Date - Year Master Demand Schedule Entries.Last Update Date LAST_UPDATE_DATE_YEAR184956
Last Updated By Master Demand Schedule Entries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139319
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Master Demand Schedule Entries.Line IdLINE_IDLINE_ID144637
Line NameName of manufacturing lineMaster Demand Schedule Entries.Line NameLINE_NAMELINE_NAME144692
Mds Entry IdMaster demand schedule entry identifierMaster Demand Schedule Entries.Mds Entry IdMDS_ENTRY_IDMDS_ENTRY_ID146513
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Master Demand Schedule Entries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150078
Organization Id Master Demand Schedule Entries.Organization IdORGANIZATION_IDORGANIZATION_ID150334
Organization Name Master Demand Schedule Entries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150632
Original QuantitySchedule quantity before reliefMaster Demand Schedule Entries.Original QuantityORIGINAL_QUANTITYORIGINAL_QUANTITY151215
Origination TypeOrigin of schedule entryMaster Demand Schedule Entries.Origination TypeORIGINATION_TYPEORIGINATION_TYPE151264
Plan Supply IdPlan supply identifierMaster Demand Schedule Entries.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154336
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Master Demand Schedule Entries.Project IdPROJECT_IDPROJECT_ID156465
Project Number Master Demand Schedule Entries.Project NumberPROJECT_NUMBERPROJECT_NUMBER156636
Repetitive Item Daily RateSchedule rate for repetitive itemMaster Demand Schedule Entries.Repetitive Item Daily RateREPETITIVE_ITEM_DAILY_RATEREPETITIVE_ITEM_DAILY_RATE158564
Sales Order Line IdSales order line identifierMaster Demand Schedule Entries.Sales Order Line IdSALES_ORDER_LINE_IDSALES_ORDER_LINE_ID160674
Sales Order Line NumberIndicate which sales order line was loadedMaster Demand Schedule Entries.Sales Order Line NumberSALES_ORDER_LINE_NUMBERSALES_ORDER_LINE_NUMBER160675
Sales Order NumberSpecify which sales order was loadedMaster Demand Schedule Entries.Sales Order NumberSALES_ORDER_NUMBERSALES_ORDER_NUMBER160684
Schedule DateDate associated which schedule entryMaster Demand Schedule Entries.Schedule DateSCHEDULE_DATESCHEDULE_DATE160796
Schedule Date - Day Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_DAY190154
Schedule Date - Month Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_MONTH190158
Schedule Date - Quarter Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_QUARTER190162
Schedule Date - Year Master Demand Schedule Entries.Schedule Date SCHEDULE_DATE_YEAR190166
Schedule NameName of master demand scheduleMaster Demand Schedule Entries.Schedule NameSCHEDULE_NAMESCHEDULE_NAME160810
Source Forecast NameForecast name of forecast entry from which the MDS entry was loadedMaster Demand Schedule Entries.Source Forecast NameSOURCE_FORECAST_NAMESOURCE_FORECAST_NAME162406
Source Organization CodeThe organization code from which the entry was loadedMaster Demand Schedule Entries.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162470
Source Organization IdOrganization identifier from which the entry was loadedMaster Demand Schedule Entries.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162487
Source Organization NameThe organization name from which the entry was loadedMaster Demand Schedule Entries.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162506
Source Schedule NameThe schedule name from which the entry was loadedMaster Demand Schedule Entries.Source Schedule NameSOURCE_SCHEDULE_NAMESOURCE_SCHEDULE_NAME162531
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.Master Demand Schedule Entries.Task IdTASK_IDTASK_ID164588
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.Master Demand Schedule Entries.Task NumberTASK_NUMBERTASK_NUMBER164663
Unit NumberEnd item unit numberMaster Demand Schedule Entries.Unit NumberUNIT_NUMBERUNIT_NUMBER166254
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Master Demand Schedule Entries -> Plan DemandsMaster Demand Schedule Entries.Mds Entry Id = Plan Demands.Mds Entry IdMight not exist in master folderOuter join on master No