Powered by InfoCaptor


Previous Page   Next Page

Flow Routings
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_FLOW_ROUTINGSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Routing Code Flow Routings.Alternate Routing CodeALTERNATE_ROUTING_CODEALTERNATE_ROUTING_CODE115790
Assembly Item IdInventory item identifier of manufactured assemblyFlow Routings.Assembly Item IdASSEMBLY_ITEM_IDASSEMBLY_ITEM_ID116528
Bin Flow Routings.BinBINBIN265741
Capable To Promise Flag Flow Routings.Capable To Promise FlagCAPABLE_TO_PROMISE_FLAGCAPABLE_TO_PROMISE_FLAG265735
Comment Flow Routings.CommentCOMMENTCOMMENT265732
Common Alternate Routing CodeAlternative routing code for common routingFlow Routings.Common Alternate Routing CodeCOMMON_ALTERNATE_ROUTING_CODECOMMON_ALTERNATE_ROUTING_CODE122686
Common Assembly Item IdInventory item identifier of common assemblyFlow Routings.Common Assembly Item IdCOMMON_ASSEMBLY_ITEM_IDCOMMON_ASSEMBLY_ITEM_ID122691
Common Routing Name Flow Routings.Common Routing NameCOMMON_ROUTING_NAMECOMMON_ROUTING_NAME265736
Common Routing Sequence IdRouting identifier of common routingFlow Routings.Common Routing Sequence IdCOMMON_ROUTING_SEQUENCE_IDCOMMON_ROUTING_SEQUENCE_ID122711
Completion Locator Code Flow Routings.Completion Locator CodeCOMPLETION_LOCATOR_CODECOMPLETION_LOCATOR_CODE265738
Completion Locator IdCompletion locator identifierFlow Routings.Completion Locator IdCOMPLETION_LOCATOR_IDCOMPLETION_LOCATOR_ID122896
Completion Subinventory Flow Routings.Completion SubinventoryCOMPLETION_SUBINVENTORYCOMPLETION_SUBINVENTORY122901
Created By Flow Routings.Created ByCREATED_BYCREATED_BY124301
Created On Flow Routings.Created OnCREATED_ONCREATED_ON125448
Created On - Day Flow Routings.Created On CREATED_ON_DAY171769
Created On - Month Flow Routings.Created On CREATED_ON_MONTH171845
Created On - Quarter Flow Routings.Created On CREATED_ON_QUARTER171921
Created On - Year Flow Routings.Created On CREATED_ON_YEAR171997
Engineering Routing Flag Flow Routings.Engineering Routing FlagENGINEERING_ROUTING_FLAGENGINEERING_ROUTING_FLAG265733
Item Flow Routings.ItemITEMITEM265731
Item 1 Flow Routings.Item 1ITEM_1ITEM_1265737
Item Name Flow Routings.Item NameITEM_NAMEITEM_NAME265730
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Flow Routings.Line IdLINE_IDLINE_ID144620
Line NameLine name for flow manufacturingFlow Routings.Line NameLINE_NAMELINE_NAME144689
Mixed Model Map Flag Flow Routings.Mixed Model Map FlagMIXED_MODEL_MAP_FLAGMIXED_MODEL_MAP_FLAG265734
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Flow Routings.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150029
Organization Id Flow Routings.Organization IdORGANIZATION_IDORGANIZATION_ID150230
Organization Name Flow Routings.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150522
Pallet Position Flow Routings.Pallet PositionPALLET_POSITIONPALLET_POSITION265740
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Flow Routings.Project IdPROJECT_IDPROJECT_ID156412
Project NameProject name for project manufacturingFlow Routings.Project NamePROJECT_NAMEPROJECT_NAME156523
Routing Priority Flow Routings.Routing PriorityROUTING_PRIORITYROUTING_PRIORITY159838
Routing Sequence IdRouting unique identifierFlow Routings.Routing Sequence IdROUTING_SEQUENCE_IDROUTING_SEQUENCE_ID159848
Row Flow Routings.RowROWROW265739
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.Flow Routings.Task IdTASK_IDTASK_ID164558
Task NameTask name for project manufacturingFlow Routings.Task NameTASK_NAMETASK_NAME164617
Total Cycle TimeTotal time that an assembly takes along the primary path in the operation network calculated by Flow ManufacturingFlow Routings.Total Cycle TimeTOTAL_CYCLE_TIMETOTAL_CYCLE_TIME165237
Updated By Flow Routings.Updated ByUPDATED_BYUPDATED_BY166455
Updated OnDate on which the rwo was last updatedFlow Routings.Updated OnUPDATED_ONUPDATED_ON166544
Updated On - Day Flow Routings.Updated On UPDATED_ON_DAY192763
Updated On - Month Flow Routings.Updated On UPDATED_ON_MONTH192839
Updated On - Quarter Flow Routings.Updated On UPDATED_ON_QUARTER192915
Updated On - Year Flow Routings.Updated On UPDATED_ON_YEAR192991
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Flow Routings -> Alternate Bill of Materials/Routing CodesFlow Routings.Alternate Routing Code = Alternate Bill of Materials / Routing Codes.Alternate Designator Code Flow Routings.Organization Id = Alternate Bill of Materials / Routing Codes.Organization IdAlways exist in master folderOuter join on detail No
Flow Routings -> Inventory LocatorsFlow Routings.Completion Locator Id = Inventory Locators.Inventory Locator IdAlways exist in master folderOuter join on detail No
Flow Routings -> Organization ItemsFlow Routings.Organization Id = Organization Items.Organization Id Flow Routings.Assembly Item Id = Organization Items.Inventory Item IdAlways exist in master folderNoneNo
Flow Routings -> Organization Items 1Flow Routings.Organization Id = Organization Items.Organization Id Flow Routings.Common Assembly Item Id = Organization Items.Inventory Item IdAlways exist in master folderOuter join on detail No
Flow Routings -> SubinventoriesFlow Routings.Organization Id = Subinventories.Organization Id Flow Routings.Completion Subinventory = Subinventories.Subinventory NameAlways exist in master folderOuter join on detail No