Powered by InfoCaptor


Previous Page   Next Page

Master Production Schedule Entries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_MPS_ENTRIESUnknown
NoneNone.MRPFG_MPS_ENTRIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
CommentsFreeform text/comments.Master Production Schedule Entries.CommentsCOMMENTSCOMMENTS122532
Created By Master Production Schedule Entries.Created ByCREATED_BYCREATED_BY124697
Creation Date Master Production Schedule Entries.Creation DateCREATION_DATECREATION_DATE126123
Creation Date - Day Master Production Schedule Entries.Creation Date CREATION_DATE_DAY172275
Creation Date - Month Master Production Schedule Entries.Creation Date CREATION_DATE_MONTH172729
Creation Date - Quarter Master Production Schedule Entries.Creation Date CREATION_DATE_QUARTER173183
Creation Date - Year Master Production Schedule Entries.Creation Date CREATION_DATE_YEAR173637
Current QuantitySupply schedule quantityMaster Production Schedule Entries.Current QuantityCURRENT_QUANTITYCURRENT_QUANTITY127363
End DateEnd effective date for the accounting cost.Master Production Schedule Entries.End DateEND_DATEEND_DATE132835
End Date - Day Master Production Schedule Entries.End Date END_DATE_DAY178461
End Date - Month Master Production Schedule Entries.End Date END_DATE_MONTH178487
End Date - Quarter Master Production Schedule Entries.End Date END_DATE_QUARTER178513
End Date - Year Master Production Schedule Entries.End Date END_DATE_YEAR178539
Forecast Entry IdForecast entry identifierMaster Production Schedule Entries.Forecast Entry IdFORECAST_ENTRY_IDFORECAST_ENTRY_ID134490
Inventory Item IdInventory item identifier of the entryMaster Production Schedule Entries.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137226
Last Update Date Master Production Schedule Entries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140659
Last Update Date - Day Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_DAY183678
Last Update Date - Month Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_MONTH184106
Last Update Date - Quarter Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_QUARTER184534
Last Update Date - Year Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_YEAR184962
Last Updated By Master Production Schedule Entries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139322
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Master Production Schedule Entries.Line IdLINE_IDLINE_ID144638
Line NameName of manufacturing lineMaster Production Schedule Entries.Line NameLINE_NAMELINE_NAME144693
Mps Entry IdMaster production schedule entry identifierMaster Production Schedule Entries.Mps Entry IdMPS_ENTRY_IDMPS_ENTRY_ID147482
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Master Production Schedule Entries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150081
Organization Id Master Production Schedule Entries.Organization IdORGANIZATION_IDORGANIZATION_ID150337
Organization Name Master Production Schedule Entries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150635
Original QuantitySchedule quantity prior to reliefMaster Production Schedule Entries.Original QuantityORIGINAL_QUANTITYORIGINAL_QUANTITY151216
Origination TypeSource of schedule entryMaster Production Schedule Entries.Origination TypeORIGINATION_TYPEORIGINATION_TYPE151265
Plan Supply IdPlan supply identifierMaster Production Schedule Entries.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154337
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Master Production Schedule Entries.Project IdPROJECT_IDPROJECT_ID156466
Project Number Master Production Schedule Entries.Project NumberPROJECT_NUMBERPROJECT_NUMBER156637
Repetitive Item Daily RateDaily rate for repetitive itemMaster Production Schedule Entries.Repetitive Item Daily RateREPETITIVE_ITEM_DAILY_RATEREPETITIVE_ITEM_DAILY_RATE158565
Schedule DateDate associated with schedule entryMaster Production Schedule Entries.Schedule DateSCHEDULE_DATESCHEDULE_DATE160797
Schedule Date - Day Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_DAY190156
Schedule Date - Month Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_MONTH190160
Schedule Date - Quarter Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_QUARTER190164
Schedule Date - Year Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_YEAR190168
Schedule NameName of master production scheduleMaster Production Schedule Entries.Schedule NameSCHEDULE_NAMESCHEDULE_NAME160813
Source Forecast NameForecast name of forecast entry from which the entry was loadedMaster Production Schedule Entries.Source Forecast NameSOURCE_FORECAST_NAMESOURCE_FORECAST_NAME162407
Source Organization CodeThe organization code from which the entry was loadedMaster Production Schedule Entries.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162471
Source Organization IdOrganization identifier from which the entry was loadedMaster Production Schedule Entries.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162488
Source Organization NameThe organization name from which the entry was loadedMaster Production Schedule Entries.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162507
Source Schedule NameThe schedule name from which the entry was loadedMaster Production Schedule Entries.Source Schedule NameSOURCE_SCHEDULE_NAMESOURCE_SCHEDULE_NAME162532
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 Production Schedule Entries.Task IdTASK_IDTASK_ID164589
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 Production Schedule Entries.Task NumberTASK_NUMBERTASK_NUMBER164664
Unit NumberEnd item unit numberMaster Production Schedule Entries.Unit NumberUNIT_NUMBERUNIT_NUMBER166255
CommentsFreeform text/comments.Master Production Schedule Entries.CommentsCOMMENTSCOMMENTS122532
Created By Master Production Schedule Entries.Created ByCREATED_BYCREATED_BY124697
Creation Date Master Production Schedule Entries.Creation DateCREATION_DATECREATION_DATE126123
Creation Date - Day Master Production Schedule Entries.Creation Date CREATION_DATE_DAY172275
Creation Date - Month Master Production Schedule Entries.Creation Date CREATION_DATE_MONTH172729
Creation Date - Quarter Master Production Schedule Entries.Creation Date CREATION_DATE_QUARTER173183
Creation Date - Year Master Production Schedule Entries.Creation Date CREATION_DATE_YEAR173637
Current QuantitySupply schedule quantityMaster Production Schedule Entries.Current QuantityCURRENT_QUANTITYCURRENT_QUANTITY127363
End DateEnd effective date for the accounting cost.Master Production Schedule Entries.End DateEND_DATEEND_DATE132835
End Date - Day Master Production Schedule Entries.End Date END_DATE_DAY178461
End Date - Month Master Production Schedule Entries.End Date END_DATE_MONTH178487
End Date - Quarter Master Production Schedule Entries.End Date END_DATE_QUARTER178513
End Date - Year Master Production Schedule Entries.End Date END_DATE_YEAR178539
Forecast Entry IdForecast entry identifierMaster Production Schedule Entries.Forecast Entry IdFORECAST_ENTRY_IDFORECAST_ENTRY_ID134490
Inventory Item IdInventory item identifier of the entryMaster Production Schedule Entries.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137226
Last Update Date Master Production Schedule Entries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140659
Last Update Date - Day Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_DAY183678
Last Update Date - Month Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_MONTH184106
Last Update Date - Quarter Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_QUARTER184534
Last Update Date - Year Master Production Schedule Entries.Last Update Date LAST_UPDATE_DATE_YEAR184962
Last Updated By Master Production Schedule Entries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139322
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Master Production Schedule Entries.Line IdLINE_IDLINE_ID144638
Line NameName of manufacturing lineMaster Production Schedule Entries.Line NameLINE_NAMELINE_NAME144693
Mps Entry IdMaster production schedule entry identifierMaster Production Schedule Entries.Mps Entry IdMPS_ENTRY_IDMPS_ENTRY_ID147482
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Master Production Schedule Entries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150081
Organization Id Master Production Schedule Entries.Organization IdORGANIZATION_IDORGANIZATION_ID150337
Organization Name Master Production Schedule Entries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150635
Original QuantitySchedule quantity prior to reliefMaster Production Schedule Entries.Original QuantityORIGINAL_QUANTITYORIGINAL_QUANTITY151216
Origination TypeSource of schedule entryMaster Production Schedule Entries.Origination TypeORIGINATION_TYPEORIGINATION_TYPE151265
Plan Supply IdPlan supply identifierMaster Production Schedule Entries.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154337
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Master Production Schedule Entries.Project IdPROJECT_IDPROJECT_ID156466
Project Number Master Production Schedule Entries.Project NumberPROJECT_NUMBERPROJECT_NUMBER156637
Repetitive Item Daily RateDaily rate for repetitive itemMaster Production Schedule Entries.Repetitive Item Daily RateREPETITIVE_ITEM_DAILY_RATEREPETITIVE_ITEM_DAILY_RATE158565
Schedule DateDate associated with schedule entryMaster Production Schedule Entries.Schedule DateSCHEDULE_DATESCHEDULE_DATE160797
Schedule Date - Day Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_DAY190156
Schedule Date - Month Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_MONTH190160
Schedule Date - Quarter Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_QUARTER190164
Schedule Date - Year Master Production Schedule Entries.Schedule Date SCHEDULE_DATE_YEAR190168
Schedule NameName of master production scheduleMaster Production Schedule Entries.Schedule NameSCHEDULE_NAMESCHEDULE_NAME160813
Source Forecast NameForecast name of forecast entry from which the entry was loadedMaster Production Schedule Entries.Source Forecast NameSOURCE_FORECAST_NAMESOURCE_FORECAST_NAME162407
Source Organization CodeThe organization code from which the entry was loadedMaster Production Schedule Entries.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162471
Source Organization IdOrganization identifier from which the entry was loadedMaster Production Schedule Entries.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162488
Source Organization NameThe organization name from which the entry was loadedMaster Production Schedule Entries.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162507
Source Schedule NameThe schedule name from which the entry was loadedMaster Production Schedule Entries.Source Schedule NameSOURCE_SCHEDULE_NAMESOURCE_SCHEDULE_NAME162532
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 Production Schedule Entries.Task IdTASK_IDTASK_ID164589
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 Production Schedule Entries.Task NumberTASK_NUMBERTASK_NUMBER164664
Unit NumberEnd item unit numberMaster Production Schedule Entries.Unit NumberUNIT_NUMBERUNIT_NUMBER166255
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto