Powered by InfoCaptor


Previous Page   Next Page

Plan Supplies
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.MRPFG_PLAN_SUPPLIESUnknown
NoneNone.MRPFG_PLAN_SUPPLIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate BOMAlternate bom designator of the planned orderPlan Supplies.Alternate BOMALTERNATE_BOMALTERNATE_BOM115762
Alternate RoutingAlternate routing designator of the planned orderPlan Supplies.Alternate RoutingALTERNATE_ROUTINGALTERNATE_ROUTING115786
Build SequenceBuild Sequence for the Planned OrderPlan Supplies.Build SequenceBUILD_SEQUENCEBUILD_SEQUENCE120502
Compression DaysOrder Schedule Compression DaysPlan Supplies.Compression DaysCOMPRESSION_DAYSCOMPRESSION_DAYS122975
Created By Plan Supplies.Created ByCREATED_BYCREATED_BY124715
Creation Date Plan Supplies.Creation DateCREATION_DATECREATION_DATE126141
Creation Date - Day Plan Supplies.Creation Date CREATION_DATE_DAY172311
Creation Date - Month Plan Supplies.Creation Date CREATION_DATE_MONTH172765
Creation Date - Quarter Plan Supplies.Creation Date CREATION_DATE_QUARTER173219
Creation Date - Year Plan Supplies.Creation Date CREATION_DATE_YEAR173673
Days From TodayDays from today to Order DatePlan Supplies.Days From TodayDAYS_FROM_TODAYDAYS_FROM_TODAY128665
Firm DateFirm date of planned orderPlan Supplies.Firm DateFIRM_DATEFIRM_DATE134336
Firm Date - Day Plan Supplies.Firm Date FIRM_DATE_DAY179460
Firm Date - Month Plan Supplies.Firm Date FIRM_DATE_MONTH179462
Firm Date - Quarter Plan Supplies.Firm Date FIRM_DATE_QUARTER179464
Firm Date - Year Plan Supplies.Firm Date FIRM_DATE_YEAR179466
Firm Flag Plan Supplies.Firm FlagFIRM_FLAGFIRM_FLAG273105
Firm QuantityQuantity of firmed planned orderPlan Supplies.Firm QuantityFIRM_QUANTITYFIRM_QUANTITY134337
First Unit Start DateFirst Unit Start Date for Repetitive SchedulesPlan Supplies.First Unit Start DateFIRST_UNIT_START_DATEFIRST_UNIT_START_DATE134391
First Unit Start Date - Day Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_DAY179607
First Unit Start Date - Month Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_MONTH179611
First Unit Start Date - Quarter Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_QUARTER179615
First Unit Start Date - Year Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_YEAR179619
Implement Alternate BomAlternate bom designator of the planned order to be implementedPlan Supplies.Implement Alternate BomIMPLEMENT_ALTERNATE_BOMIMPLEMENT_ALTERNATE_BOM136140
Implement Alternate RoutingAlternate routing designator of the planned order to be implementedPlan Supplies.Implement Alternate RoutingIMPLEMENT_ALTERNATE_ROUTINGIMPLEMENT_ALTERNATE_ROUTING136141
Implement As Plan Supplies.Implement AsIMPLEMENT_ASIMPLEMENT_AS273107
Implement Build SequenceBuild Sequence for the Planned Order to be implemented as a discrete jobPlan Supplies.Implement Build SequenceIMPLEMENT_BUILD_SEQUENCEIMPLEMENT_BUILD_SEQUENCE136142
Implement DateImplement due datePlan Supplies.Implement DateIMPLEMENT_DATEIMPLEMENT_DATE136143
Implement Date - Day Plan Supplies.Implement Date IMPLEMENT_DATE_DAY181121
Implement Date - Month Plan Supplies.Implement Date IMPLEMENT_DATE_MONTH181123
Implement Date - Quarter Plan Supplies.Implement Date IMPLEMENT_DATE_QUARTER181125
Implement Date - Year Plan Supplies.Implement Date IMPLEMENT_DATE_YEAR181127
Implement Demand ClassDemand class of the planned order to be implementedPlan Supplies.Implement Demand ClassIMPLEMENT_DEMAND_CLASSIMPLEMENT_DEMAND_CLASS136144
Implement Firm Flag Plan Supplies.Implement Firm FlagIMPLEMENT_FIRM_FLAGIMPLEMENT_FIRM_FLAG273110
Implement Line NameManufacturing line of the planned order to be implementedPlan Supplies.Implement Line NameIMPLEMENT_LINE_NAMEIMPLEMENT_LINE_NAME136145
Implement Mfg Line IdImplement Repetitive Line IdentifierPlan Supplies.Implement Mfg Line IdIMPLEMENT_MFG_LINE_IDIMPLEMENT_MFG_LINE_ID136146
Implement Organization CodeOrganization code of the planned order to be implementedPlan Supplies.Implement Organization CodeIMPLEMENT_ORGANIZATION_CODEIMPLEMENT_ORGANIZATION_CODE136147
Implement Organization NameOrganization name of the planned order to be implementedPlan Supplies.Implement Organization NameIMPLEMENT_ORGANIZATION_NAMEIMPLEMENT_ORGANIZATION_NAME136148
Implement Project IdImplement project identifierPlan Supplies.Implement Project IdIMPLEMENT_PROJECT_IDIMPLEMENT_PROJECT_ID136149
Implement Project NumberProject number of the planned order to be implementedPlan Supplies.Implement Project NumberIMPLEMENT_PROJECT_NUMBERIMPLEMENT_PROJECT_NUMBER136150
Implement Quantity Rate Plan Supplies.Implement Quantity RateIMPLEMENT_QUANTITY_RATEIMPLEMENT_QUANTITY_RATE136151
Implement Schedule Group IdImplement schedule group identifierPlan Supplies.Implement Schedule Group IdIMPLEMENT_SCHEDULE_GROUP_IDIMPLEMENT_SCHEDULE_GROUP_ID136152
Implement Schedule Group Name Plan Supplies.Implement Schedule Group NameIMPLEMENT_SCHEDULE_GROUP_NAMEIMPLEMENT_SCHEDULE_GROUP_NAME136153
Implement Source Org IdSource organizaton identifier for the planned order to be implementedPlan Supplies.Implement Source Org IdIMPLEMENT_SOURCE_ORG_IDIMPLEMENT_SOURCE_ORG_ID136154
Implement Status Code Plan Supplies.Implement Status CodeIMPLEMENT_STATUS_CODEIMPLEMENT_STATUS_CODE273108
Implement Supplier IdSupplier identifier for the Planned Order being implementedPlan Supplies.Implement Supplier IdIMPLEMENT_SUPPLIER_IDIMPLEMENT_SUPPLIER_ID136155
Implement Supplier NameSupplier name of the planned order to be implementedPlan Supplies.Implement Supplier NameIMPLEMENT_SUPPLIER_NAMEIMPLEMENT_SUPPLIER_NAME136156
Implement Supplier SiteSupplier site of the planned order to be implementedPlan Supplies.Implement Supplier SiteIMPLEMENT_SUPPLIER_SITEIMPLEMENT_SUPPLIER_SITE136157
Implement Supplier Site IdSupplier site identifier for the Planned Order being implementedPlan Supplies.Implement Supplier Site IdIMPLEMENT_SUPPLIER_SITE_IDIMPLEMENT_SUPPLIER_SITE_ID136158
Implement Task IdImplement task identifierPlan Supplies.Implement Task IdIMPLEMENT_TASK_IDIMPLEMENT_TASK_ID136159
Implement Task NumberTask number of the planned order to be implementedPlan Supplies.Implement Task NumberIMPLEMENT_TASK_NUMBERIMPLEMENT_TASK_NUMBER136160
Implement Unit NumberEnd item unit number of the planned order to be implementedPlan Supplies.Implement Unit NumberIMPLEMENT_UNIT_NUMBERIMPLEMENT_UNIT_NUMBER136161
Implement WIP Class CodeJob class code of the planned order to be implementedPlan Supplies.Implement WIP Class CodeIMPLEMENT_WIP_CLASS_CODEIMPLEMENT_WIP_CLASS_CODE136162
Implemented QuantityPlanned order implemented quantityPlan Supplies.Implemented QuantityIMPLEMENTED_QUANTITYIMPLEMENTED_QUANTITY136139
Inventory Item IdInventory item identifierPlan Supplies.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137234
Item Plan Supplies.ItemITEMITEM273104
Item Number Plan Supplies.Item NumberITEM_NUMBERITEM_NUMBER273103
Last Unit Completion DateLast Unit Completion Date for recommended repetitive schedulesPlan Supplies.Last Unit Completion DateLAST_UNIT_COMPLETION_DATELAST_UNIT_COMPLETION_DATE138656
Last Unit Completion Date - Day Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_DAY182772
Last Unit Completion Date - Month Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_MONTH182778
Last Unit Completion Date - Quarter Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_QUARTER182784
Last Unit Completion Date - Year Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_YEAR182790
Last Unit Start DateLast Unit Start Date for Repetitive SchedulesPlan Supplies.Last Unit Start DateLAST_UNIT_START_DATELAST_UNIT_START_DATE138658
Last Unit Start Date - Day Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_DAY182794
Last Unit Start Date - Month Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_MONTH182798
Last Unit Start Date - Quarter Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_QUARTER182802
Last Unit Start Date - Year Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_YEAR182806
Last Update Date Plan Supplies.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140677
Last Update Date - Day Plan Supplies.Last Update Date LAST_UPDATE_DATE_DAY183714
Last Update Date - Month Plan Supplies.Last Update Date LAST_UPDATE_DATE_MONTH184142
Last Update Date - Quarter Plan Supplies.Last Update Date LAST_UPDATE_DATE_QUARTER184570
Last Update Date - Year Plan Supplies.Last Update Date LAST_UPDATE_DATE_YEAR184998
Last Updated By Plan Supplies.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139340
Line NameManufacturing line namePlan Supplies.Line NameLINE_NAMELINE_NAME144698
Mfg Line IdManufacturing line identifierPlan Supplies.Mfg Line IdMFG_LINE_IDMFG_LINE_ID147055
Mfg Order IdManufacturing order identifierPlan Supplies.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147058
Old Due Date Plan Supplies.Old Due DateOLD_DUE_DATEOLD_DUE_DATE149386
Old Due Date - Day Plan Supplies.Old Due Date OLD_DUE_DATE_DAY187096
Old Due Date - Month Plan Supplies.Old Due Date OLD_DUE_DATE_MONTH187100
Old Due Date - Quarter Plan Supplies.Old Due Date OLD_DUE_DATE_QUARTER187104
Old Due Date - Year Plan Supplies.Old Due Date OLD_DUE_DATE_YEAR187108
Order Number Plan Supplies.Order NumberORDER_NUMBERORDER_NUMBER149875
Order TypeIndicate type of supplyPlan Supplies.Order TypeORDER_TYPEORDER_TYPE149904
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Supplies.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150098
Organization Id Plan Supplies.Organization IdORGANIZATION_IDORGANIZATION_ID150354
Organization Name Plan Supplies.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150652
Original Quantity RateOriginal quantity rate of planned orderPlan Supplies.Original Quantity RateORIGINAL_QUANTITY_RATEORIGINAL_QUANTITY_RATE151218
Plan NameName of MRP, MPS, or DRP planPlan Supplies.Plan NamePLAN_NAMEPLAN_NAME154318
Plan Supply IdPlan supply identifierPlan Supplies.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154341
PlannerPlanner codePlan Supplies.PlannerPLANNERPLANNER154224
Planning GroupProject planning groupPlan Supplies.Planning GroupPLANNING_GROUPPLANNING_GROUP154247
Po Line IdPurchase order line identifierPlan Supplies.Po Line IdPO_LINE_IDPO_LINE_ID155040
Process DaysRepetitive Schedule Processing DaysPlan Supplies.Process DaysPROCESS_DAYSPROCESS_DAYS155809
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Supplies.Project IdPROJECT_IDPROJECT_ID156471
Project Number Plan Supplies.Project NumberPROJECT_NUMBERPROJECT_NUMBER156642
Quantity In ProcessQuantity being processed by the WIP/PO interface processesPlan Supplies.Quantity In ProcessQUANTITY_IN_PROCESSQUANTITY_IN_PROCESS157295
Quantity RateOrder quantityPlan Supplies.Quantity RateQUANTITY_RATEQUANTITY_RATE157316
Requisition Line IdRequisition line identifierPlan Supplies.Requisition Line IdREQUISITION_LINE_IDREQUISITION_LINE_ID158840
Rescheduled Flag Plan Supplies.Rescheduled FlagRESCHEDULED_FLAGRESCHEDULED_FLAG273109
Schedule GroupSchedule group for discrete jobsPlan Supplies.Schedule GroupSCHEDULE_GROUPSCHEDULE_GROUP160802
Schedule Group IdSchedule group identifierPlan Supplies.Schedule Group IdSCHEDULE_GROUP_IDSCHEDULE_GROUP_ID160804
Select For Release Flag Plan Supplies.Select For Release FlagSELECT_FOR_RELEASE_FLAGSELECT_FOR_RELEASE_FLAG273106
Shipment Line IdShipment line identifierPlan Supplies.Shipment Line IdSHIPMENT_LINE_IDSHIPMENT_LINE_ID161668
Source Organization Code Plan Supplies.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162473
Source Organization IdSource rganization identifierPlan Supplies.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162490
Source Organization Name Plan Supplies.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162509
Source Supplier IdSource supplier identifierPlan Supplies.Source Supplier IdSOURCE_SUPPLIER_IDSOURCE_SUPPLIER_ID162541
Source Supplier Name Plan Supplies.Source Supplier NameSOURCE_SUPPLIER_NAMESOURCE_SUPPLIER_NAME162542
Source Supplier Site Plan Supplies.Source Supplier SiteSOURCE_SUPPLIER_SITESOURCE_SUPPLIER_SITE162543
Source Supplier Site IdSource supplier site identifierPlan Supplies.Source Supplier Site IdSOURCE_SUPPLIER_SITE_IDSOURCE_SUPPLIER_SITE_ID162544
Suggested Dock Date Plan Supplies.Suggested Dock DateSUGGESTED_DOCK_DATESUGGESTED_DOCK_DATE163995
Suggested Dock Date - Day Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_DAY191668
Suggested Dock Date - Month Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_MONTH191670
Suggested Dock Date - Quarter Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_QUARTER191672
Suggested Dock Date - Year Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_YEAR191674
Suggested Due Date Plan Supplies.Suggested Due DateSUGGESTED_DUE_DATESUGGESTED_DUE_DATE163997
Suggested Due Date - Day Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_DAY191678
Suggested Due Date - Month Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_MONTH191682
Suggested Due Date - Quarter Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_QUARTER191686
Suggested Due Date - Year Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_YEAR191690
Suggested Order Date Plan Supplies.Suggested Order DateSUGGESTED_ORDER_DATESUGGESTED_ORDER_DATE163998
Suggested Order Date - Day Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_DAY191692
Suggested Order Date - Month Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_MONTH191694
Suggested Order Date - Quarter Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_QUARTER191696
Suggested Order Date - Year Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_YEAR191698
Suggested Start Date Plan Supplies.Suggested Start DateSUGGESTED_START_DATESUGGESTED_START_DATE163999
Suggested Start Date - Day Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_DAY191700
Suggested Start Date - Month Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_MONTH191702
Suggested Start Date - Quarter Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_QUARTER191704
Suggested Start Date - Year Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_YEAR191706
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 Supplies.Task IdTASK_IDTASK_ID164594
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 Supplies.Task NumberTASK_NUMBERTASK_NUMBER164669
Unit NumberEnd item unit numberPlan Supplies.Unit NumberUNIT_NUMBERUNIT_NUMBER166257
Alternate BOMAlternate bom designator of the planned orderPlan Supplies.Alternate BOMALTERNATE_BOMALTERNATE_BOM115762
Alternate RoutingAlternate routing designator of the planned orderPlan Supplies.Alternate RoutingALTERNATE_ROUTINGALTERNATE_ROUTING115786
Build SequenceBuild Sequence for the Planned OrderPlan Supplies.Build SequenceBUILD_SEQUENCEBUILD_SEQUENCE120502
Compression DaysOrder Schedule Compression DaysPlan Supplies.Compression DaysCOMPRESSION_DAYSCOMPRESSION_DAYS122975
Created By Plan Supplies.Created ByCREATED_BYCREATED_BY124715
Creation Date Plan Supplies.Creation DateCREATION_DATECREATION_DATE126141
Creation Date - Day Plan Supplies.Creation Date CREATION_DATE_DAY172311
Creation Date - Month Plan Supplies.Creation Date CREATION_DATE_MONTH172765
Creation Date - Quarter Plan Supplies.Creation Date CREATION_DATE_QUARTER173219
Creation Date - Year Plan Supplies.Creation Date CREATION_DATE_YEAR173673
Days From TodayDays from today to Order DatePlan Supplies.Days From TodayDAYS_FROM_TODAYDAYS_FROM_TODAY128665
Firm DateFirm date of planned orderPlan Supplies.Firm DateFIRM_DATEFIRM_DATE134336
Firm Date - Day Plan Supplies.Firm Date FIRM_DATE_DAY179460
Firm Date - Month Plan Supplies.Firm Date FIRM_DATE_MONTH179462
Firm Date - Quarter Plan Supplies.Firm Date FIRM_DATE_QUARTER179464
Firm Date - Year Plan Supplies.Firm Date FIRM_DATE_YEAR179466
Firm Flag Plan Supplies.Firm FlagFIRM_FLAGFIRM_FLAG273105
Firm QuantityQuantity of firmed planned orderPlan Supplies.Firm QuantityFIRM_QUANTITYFIRM_QUANTITY134337
First Unit Start DateFirst Unit Start Date for Repetitive SchedulesPlan Supplies.First Unit Start DateFIRST_UNIT_START_DATEFIRST_UNIT_START_DATE134391
First Unit Start Date - Day Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_DAY179607
First Unit Start Date - Month Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_MONTH179611
First Unit Start Date - Quarter Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_QUARTER179615
First Unit Start Date - Year Plan Supplies.First Unit Start Date FIRST_UNIT_START_DATE_YEAR179619
Implement Alternate BomAlternate bom designator of the planned order to be implementedPlan Supplies.Implement Alternate BomIMPLEMENT_ALTERNATE_BOMIMPLEMENT_ALTERNATE_BOM136140
Implement Alternate RoutingAlternate routing designator of the planned order to be implementedPlan Supplies.Implement Alternate RoutingIMPLEMENT_ALTERNATE_ROUTINGIMPLEMENT_ALTERNATE_ROUTING136141
Implement As Plan Supplies.Implement AsIMPLEMENT_ASIMPLEMENT_AS273107
Implement Build SequenceBuild Sequence for the Planned Order to be implemented as a discrete jobPlan Supplies.Implement Build SequenceIMPLEMENT_BUILD_SEQUENCEIMPLEMENT_BUILD_SEQUENCE136142
Implement DateImplement due datePlan Supplies.Implement DateIMPLEMENT_DATEIMPLEMENT_DATE136143
Implement Date - Day Plan Supplies.Implement Date IMPLEMENT_DATE_DAY181121
Implement Date - Month Plan Supplies.Implement Date IMPLEMENT_DATE_MONTH181123
Implement Date - Quarter Plan Supplies.Implement Date IMPLEMENT_DATE_QUARTER181125
Implement Date - Year Plan Supplies.Implement Date IMPLEMENT_DATE_YEAR181127
Implement Demand ClassDemand class of the planned order to be implementedPlan Supplies.Implement Demand ClassIMPLEMENT_DEMAND_CLASSIMPLEMENT_DEMAND_CLASS136144
Implement Firm Flag Plan Supplies.Implement Firm FlagIMPLEMENT_FIRM_FLAGIMPLEMENT_FIRM_FLAG273110
Implement Line NameManufacturing line of the planned order to be implementedPlan Supplies.Implement Line NameIMPLEMENT_LINE_NAMEIMPLEMENT_LINE_NAME136145
Implement Mfg Line IdImplement Repetitive Line IdentifierPlan Supplies.Implement Mfg Line IdIMPLEMENT_MFG_LINE_IDIMPLEMENT_MFG_LINE_ID136146
Implement Organization CodeOrganization code of the planned order to be implementedPlan Supplies.Implement Organization CodeIMPLEMENT_ORGANIZATION_CODEIMPLEMENT_ORGANIZATION_CODE136147
Implement Organization NameOrganization name of the planned order to be implementedPlan Supplies.Implement Organization NameIMPLEMENT_ORGANIZATION_NAMEIMPLEMENT_ORGANIZATION_NAME136148
Implement Project IdImplement project identifierPlan Supplies.Implement Project IdIMPLEMENT_PROJECT_IDIMPLEMENT_PROJECT_ID136149
Implement Project NumberProject number of the planned order to be implementedPlan Supplies.Implement Project NumberIMPLEMENT_PROJECT_NUMBERIMPLEMENT_PROJECT_NUMBER136150
Implement Quantity Rate Plan Supplies.Implement Quantity RateIMPLEMENT_QUANTITY_RATEIMPLEMENT_QUANTITY_RATE136151
Implement Schedule Group IdImplement schedule group identifierPlan Supplies.Implement Schedule Group IdIMPLEMENT_SCHEDULE_GROUP_IDIMPLEMENT_SCHEDULE_GROUP_ID136152
Implement Schedule Group Name Plan Supplies.Implement Schedule Group NameIMPLEMENT_SCHEDULE_GROUP_NAMEIMPLEMENT_SCHEDULE_GROUP_NAME136153
Implement Source Org IdSource organizaton identifier for the planned order to be implementedPlan Supplies.Implement Source Org IdIMPLEMENT_SOURCE_ORG_IDIMPLEMENT_SOURCE_ORG_ID136154
Implement Status Code Plan Supplies.Implement Status CodeIMPLEMENT_STATUS_CODEIMPLEMENT_STATUS_CODE273108
Implement Supplier IdSupplier identifier for the Planned Order being implementedPlan Supplies.Implement Supplier IdIMPLEMENT_SUPPLIER_IDIMPLEMENT_SUPPLIER_ID136155
Implement Supplier NameSupplier name of the planned order to be implementedPlan Supplies.Implement Supplier NameIMPLEMENT_SUPPLIER_NAMEIMPLEMENT_SUPPLIER_NAME136156
Implement Supplier SiteSupplier site of the planned order to be implementedPlan Supplies.Implement Supplier SiteIMPLEMENT_SUPPLIER_SITEIMPLEMENT_SUPPLIER_SITE136157
Implement Supplier Site IdSupplier site identifier for the Planned Order being implementedPlan Supplies.Implement Supplier Site IdIMPLEMENT_SUPPLIER_SITE_IDIMPLEMENT_SUPPLIER_SITE_ID136158
Implement Task IdImplement task identifierPlan Supplies.Implement Task IdIMPLEMENT_TASK_IDIMPLEMENT_TASK_ID136159
Implement Task NumberTask number of the planned order to be implementedPlan Supplies.Implement Task NumberIMPLEMENT_TASK_NUMBERIMPLEMENT_TASK_NUMBER136160
Implement Unit NumberEnd item unit number of the planned order to be implementedPlan Supplies.Implement Unit NumberIMPLEMENT_UNIT_NUMBERIMPLEMENT_UNIT_NUMBER136161
Implement WIP Class CodeJob class code of the planned order to be implementedPlan Supplies.Implement WIP Class CodeIMPLEMENT_WIP_CLASS_CODEIMPLEMENT_WIP_CLASS_CODE136162
Implemented QuantityPlanned order implemented quantityPlan Supplies.Implemented QuantityIMPLEMENTED_QUANTITYIMPLEMENTED_QUANTITY136139
Inventory Item IdInventory item identifierPlan Supplies.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137234
Item Plan Supplies.ItemITEMITEM273104
Item Number Plan Supplies.Item NumberITEM_NUMBERITEM_NUMBER273103
Last Unit Completion DateLast Unit Completion Date for recommended repetitive schedulesPlan Supplies.Last Unit Completion DateLAST_UNIT_COMPLETION_DATELAST_UNIT_COMPLETION_DATE138656
Last Unit Completion Date - Day Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_DAY182772
Last Unit Completion Date - Month Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_MONTH182778
Last Unit Completion Date - Quarter Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_QUARTER182784
Last Unit Completion Date - Year Plan Supplies.Last Unit Completion Date LAST_UNIT_COMPLETION_DATE_YEAR182790
Last Unit Start DateLast Unit Start Date for Repetitive SchedulesPlan Supplies.Last Unit Start DateLAST_UNIT_START_DATELAST_UNIT_START_DATE138658
Last Unit Start Date - Day Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_DAY182794
Last Unit Start Date - Month Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_MONTH182798
Last Unit Start Date - Quarter Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_QUARTER182802
Last Unit Start Date - Year Plan Supplies.Last Unit Start Date LAST_UNIT_START_DATE_YEAR182806
Last Update Date Plan Supplies.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140677
Last Update Date - Day Plan Supplies.Last Update Date LAST_UPDATE_DATE_DAY183714
Last Update Date - Month Plan Supplies.Last Update Date LAST_UPDATE_DATE_MONTH184142
Last Update Date - Quarter Plan Supplies.Last Update Date LAST_UPDATE_DATE_QUARTER184570
Last Update Date - Year Plan Supplies.Last Update Date LAST_UPDATE_DATE_YEAR184998
Last Updated By Plan Supplies.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139340
Line NameManufacturing line namePlan Supplies.Line NameLINE_NAMELINE_NAME144698
Mfg Line IdManufacturing line identifierPlan Supplies.Mfg Line IdMFG_LINE_IDMFG_LINE_ID147055
Mfg Order IdManufacturing order identifierPlan Supplies.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147058
Old Due Date Plan Supplies.Old Due DateOLD_DUE_DATEOLD_DUE_DATE149386
Old Due Date - Day Plan Supplies.Old Due Date OLD_DUE_DATE_DAY187096
Old Due Date - Month Plan Supplies.Old Due Date OLD_DUE_DATE_MONTH187100
Old Due Date - Quarter Plan Supplies.Old Due Date OLD_DUE_DATE_QUARTER187104
Old Due Date - Year Plan Supplies.Old Due Date OLD_DUE_DATE_YEAR187108
Order Number Plan Supplies.Order NumberORDER_NUMBERORDER_NUMBER149875
Order TypeIndicate type of supplyPlan Supplies.Order TypeORDER_TYPEORDER_TYPE149904
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Plan Supplies.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150098
Organization Id Plan Supplies.Organization IdORGANIZATION_IDORGANIZATION_ID150354
Organization Name Plan Supplies.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150652
Original Quantity RateOriginal quantity rate of planned orderPlan Supplies.Original Quantity RateORIGINAL_QUANTITY_RATEORIGINAL_QUANTITY_RATE151218
Plan NameName of MRP, MPS, or DRP planPlan Supplies.Plan NamePLAN_NAMEPLAN_NAME154318
Plan Supply IdPlan supply identifierPlan Supplies.Plan Supply IdPLAN_SUPPLY_IDPLAN_SUPPLY_ID154341
PlannerPlanner codePlan Supplies.PlannerPLANNERPLANNER154224
Planning GroupProject planning groupPlan Supplies.Planning GroupPLANNING_GROUPPLANNING_GROUP154247
Po Line IdPurchase order line identifierPlan Supplies.Po Line IdPO_LINE_IDPO_LINE_ID155040
Process DaysRepetitive Schedule Processing DaysPlan Supplies.Process DaysPROCESS_DAYSPROCESS_DAYS155809
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Plan Supplies.Project IdPROJECT_IDPROJECT_ID156471
Project Number Plan Supplies.Project NumberPROJECT_NUMBERPROJECT_NUMBER156642
Quantity In ProcessQuantity being processed by the WIP/PO interface processesPlan Supplies.Quantity In ProcessQUANTITY_IN_PROCESSQUANTITY_IN_PROCESS157295
Quantity RateOrder quantityPlan Supplies.Quantity RateQUANTITY_RATEQUANTITY_RATE157316
Requisition Line IdRequisition line identifierPlan Supplies.Requisition Line IdREQUISITION_LINE_IDREQUISITION_LINE_ID158840
Rescheduled Flag Plan Supplies.Rescheduled FlagRESCHEDULED_FLAGRESCHEDULED_FLAG273109
Schedule GroupSchedule group for discrete jobsPlan Supplies.Schedule GroupSCHEDULE_GROUPSCHEDULE_GROUP160802
Schedule Group IdSchedule group identifierPlan Supplies.Schedule Group IdSCHEDULE_GROUP_IDSCHEDULE_GROUP_ID160804
Select For Release Flag Plan Supplies.Select For Release FlagSELECT_FOR_RELEASE_FLAGSELECT_FOR_RELEASE_FLAG273106
Shipment Line IdShipment line identifierPlan Supplies.Shipment Line IdSHIPMENT_LINE_IDSHIPMENT_LINE_ID161668
Source Organization Code Plan Supplies.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162473
Source Organization IdSource rganization identifierPlan Supplies.Source Organization IdSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162490
Source Organization Name Plan Supplies.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162509
Source Supplier IdSource supplier identifierPlan Supplies.Source Supplier IdSOURCE_SUPPLIER_IDSOURCE_SUPPLIER_ID162541
Source Supplier Name Plan Supplies.Source Supplier NameSOURCE_SUPPLIER_NAMESOURCE_SUPPLIER_NAME162542
Source Supplier Site Plan Supplies.Source Supplier SiteSOURCE_SUPPLIER_SITESOURCE_SUPPLIER_SITE162543
Source Supplier Site IdSource supplier site identifierPlan Supplies.Source Supplier Site IdSOURCE_SUPPLIER_SITE_IDSOURCE_SUPPLIER_SITE_ID162544
Suggested Dock Date Plan Supplies.Suggested Dock DateSUGGESTED_DOCK_DATESUGGESTED_DOCK_DATE163995
Suggested Dock Date - Day Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_DAY191668
Suggested Dock Date - Month Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_MONTH191670
Suggested Dock Date - Quarter Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_QUARTER191672
Suggested Dock Date - Year Plan Supplies.Suggested Dock Date SUGGESTED_DOCK_DATE_YEAR191674
Suggested Due Date Plan Supplies.Suggested Due DateSUGGESTED_DUE_DATESUGGESTED_DUE_DATE163997
Suggested Due Date - Day Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_DAY191678
Suggested Due Date - Month Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_MONTH191682
Suggested Due Date - Quarter Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_QUARTER191686
Suggested Due Date - Year Plan Supplies.Suggested Due Date SUGGESTED_DUE_DATE_YEAR191690
Suggested Order Date Plan Supplies.Suggested Order DateSUGGESTED_ORDER_DATESUGGESTED_ORDER_DATE163998
Suggested Order Date - Day Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_DAY191692
Suggested Order Date - Month Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_MONTH191694
Suggested Order Date - Quarter Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_QUARTER191696
Suggested Order Date - Year Plan Supplies.Suggested Order Date SUGGESTED_ORDER_DATE_YEAR191698
Suggested Start Date Plan Supplies.Suggested Start DateSUGGESTED_START_DATESUGGESTED_START_DATE163999
Suggested Start Date - Day Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_DAY191700
Suggested Start Date - Month Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_MONTH191702
Suggested Start Date - Quarter Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_QUARTER191704
Suggested Start Date - Year Plan Supplies.Suggested Start Date SUGGESTED_START_DATE_YEAR191706
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 Supplies.Task IdTASK_IDTASK_ID164594
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 Supplies.Task NumberTASK_NUMBERTASK_NUMBER164669
Unit NumberEnd item unit numberPlan Supplies.Unit NumberUNIT_NUMBERUNIT_NUMBER166257
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Plan Supplies -> Master Production Schedule EntriesPlan Supplies.Plan Supply Id = Master Production Schedule Entries.Plan Supply IdMight not exist in master folderOuter join on master No
Plan Supplies -> Plan DemandsPlan Supplies.Plan Supply Id = Plan Demands.Plan Supply IdMight not exist in master folderOuter join on master No
Plan Supplies -> Plan Exception DetailsPlan Supplies.Plan Supply Id = Plan Exception Details.Plan Supply IdMight not exist in master folderOuter join on master No
Plan Supplies -> Plan Exception Details 1Plan Supplies.Plan Supply Id = Plan Exception Details.Plan Supply IdAlways exist in master folderNoneNo
Plan Supplies -> Plan PegsPlan Supplies.Plan Supply Id = Plan Pegging.Plan Supply IdAlways exist in master folderNoneNo