Powered by InfoCaptor


Previous Page   Next Page

Flow Routing Events
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_FLOW_ROUTING_EVENTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Alternate Routing Code Flow Routing Events.Alternate Routing CodeALTERNATE_ROUTING_CODEALTERNATE_ROUTING_CODE115791
Backflush Flag Flow Routing Events.Backflush FlagBACKFLUSH_FLAGBACKFLUSH_FLAG265746
Calculated Elapsed TimeSystem calculated run time attributable to both labor and machinesFlow Routing Events.Calculated Elapsed TimeCALCULATED_ELAPSED_TIMECALCULATED_ELAPSED_TIME121300
Calculated Labor TimeSystem calculated run time attributable to laborFlow Routing Events.Calculated Labor TimeCALCULATED_LABOR_TIMECALCULATED_LABOR_TIME121304
Calculated Machine TimeSystem calculated run time attributable to machinesFlow Routing Events.Calculated Machine TimeCALCULATED_MACHINE_TIMECALCULATED_MACHINE_TIME121308
Count Point Type Flow Routing Events.Count Point TypeCOUNT_POINT_TYPECOUNT_POINT_TYPE265745
Created By Flow Routing Events.Created ByCREATED_BYCREATED_BY124302
Created On Flow Routing Events.Created OnCREATED_ONCREATED_ON125449
Created On - Day Flow Routing Events.Created On CREATED_ON_DAY171771
Created On - Month Flow Routing Events.Created On CREATED_ON_MONTH171847
Created On - Quarter Flow Routing Events.Created On CREATED_ON_QUARTER171923
Created On - Year Flow Routing Events.Created On CREATED_ON_YEAR171999
Department Code Flow Routing Events.Department CodeDEPARTMENT_CODEDEPARTMENT_CODE129138
Department IdDepartment identifierFlow Routing Events.Department IdDEPARTMENT_IDDEPARTMENT_ID129158
DescriptionThe accounting period description.Flow Routing Events.DescriptionDESCRIPTIONDESCRIPTION129360
End Effective DateThe date after which an account becomes inactive.Flow Routing Events.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133082
End Effective Date - Day Flow Routing Events.End Effective Date END_EFFECTIVE_DATE_DAY178551
End Effective Date - Month Flow Routing Events.End Effective Date END_EFFECTIVE_DATE_MONTH178647
End Effective Date - Quarter Flow Routing Events.End Effective Date END_EFFECTIVE_DATE_QUARTER178743
End Effective Date - Year Flow Routing Events.End Effective Date END_EFFECTIVE_DATE_YEAR178839
Entered Labor TimeUser calculated run time attributable to laborFlow Routing Events.Entered Labor TimeENTERED_LABOR_TIMEENTERED_LABOR_TIME133431
Entered Machine TimeUser calculated run time attributable to machineFlow Routing Events.Entered Machine TimeENTERED_MACHINE_TIMEENTERED_MACHINE_TIME133435
Item Flow Routing Events.ItemITEMITEM265744
Item 1 Flow Routing Events.Item 1ITEM_1ITEM_1265750
Item 2 Flow Routing Events.Item 2ITEM_2ITEM_2265752
Line Operation Alternate Routing CodeAlternate routing code of Line operation which the event belongs toFlow Routing Events.Line Operation Alternate Routing CodeLINEOP_ALTERNATE_ROUTING_CODELINEOP_ALTERNATE_ROUTING_CODE144579
Line Operation Name Flow Routing Events.Line Operation NameLINE_OPERATION_NAMELINE_OPERATION_NAME265751
Line Operation Sequence IdOperation unique identifier of line operation which the event belongs toFlow Routing Events.Line Operation Sequence IdLINE_OP_SEQ_IDLINE_OP_SEQ_ID144768
Minimum Transfer QuantityMinimum event transfer quantityFlow Routing Events.Minimum Transfer QuantityMINIMUM_TRANSFER_QUANTITYMINIMUM_TRANSFER_QUANTITY147165
Net Planning PercentCumulative planning percents derived from the operation networkFlow Routing Events.Net Planning PercentNET_PLANNING_PERCENTNET_PLANNING_PERCENT148010
Operation Code Flow Routing Events.Operation CodeOPERATION_CODEOPERATION_CODE149620
Operation Cumulative YieldCumulative process yield from begining of routing to this eventFlow Routing Events.Operation Cumulative YieldOPERATION_CUMULATIVE_YIELDOPERATION_CUMULATIVE_YIELD149633
Operation Lead Time PercentEvent lead time offset percentageFlow Routing Events.Operation Lead Time PercentOPERATION_LEAD_TIME_PERCENTOPERATION_LEAD_TIME_PERCENT149641
Operation Sequence IdRouting event unique identifierFlow Routing Events.Operation Sequence IdOPERATION_SEQUENCE_IDOPERATION_SEQUENCE_ID149652
Operation YieldProcess yield at this eventFlow Routing Events.Operation YieldOPERATION_YIELDOPERATION_YIELD149682
Option Dependent Flag Flow Routing Events.Option Dependent FlagOPTION_DEPENDENT_FLAGOPTION_DEPENDENT_FLAG265747
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Flow Routing Events.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150030
Organization Name Flow Routing Events.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150523
Process Alternate Routing CodeAlternate routing code of process which the event belongs toFlow Routing Events.Process Alternate Routing CodePROCESS_ALTERNATE_RTG_CODEPROCESS_ALTERNATE_RTG_CODE155803
Process Name Flow Routing Events.Process NamePROCESS_NAMEPROCESS_NAME265749
Process Operation Sequence IdOperation unique iIdentifier of process which the event belongs toFlow Routing Events.Process Operation Sequence IdPROCESS_OP_SEQ_IDPROCESS_OP_SEQ_ID155817
Reference Flag Flow Routing Events.Reference FlagREFERENCE_FLAGREFERENCE_FLAG265748
Reverse Cumulative YieldCumulative process yield from end of routing to comparable eventFlow Routing Events.Reverse Cumulative YieldREVERSE_CUMULATIVE_YIELDREVERSE_CUMULATIVE_YIELD159475
Routing Item Name Flow Routing Events.Routing Item NameROUTING_ITEM_NAMEROUTING_ITEM_NAME265743
Routing Sequence IdRouting unique identifierFlow Routing Events.Routing Sequence IdROUTING_SEQUENCE_IDROUTING_SEQUENCE_ID159849
Sequence NumberRouting operation sequence numberFlow Routing Events.Sequence NumberSEQUENCE_NUMBERSEQUENCE_NUMBER161351
Standard Operation IdStandard operation unique identifier which the event is defined fromFlow Routing Events.Standard Operation IdSTANDARD_OPERATION_IDSTANDARD_OPERATION_ID162836
Start Effective DateThe date on which an account becomes active.Flow Routing Events.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163245
Start Effective Date - Day Flow Routing Events.Start Effective Date START_EFFECTIVE_DATE_DAY191087
Start Effective Date - Month Flow Routing Events.Start Effective Date START_EFFECTIVE_DATE_MONTH191173
Start Effective Date - Quarter Flow Routing Events.Start Effective Date START_EFFECTIVE_DATE_QUARTER191259
Start Effective Date - Year Flow Routing Events.Start Effective Date START_EFFECTIVE_DATE_YEAR191345
Updated By Flow Routing Events.Updated ByUPDATED_BYUPDATED_BY166456
Updated On Flow Routing Events.Updated OnUPDATED_ONUPDATED_ON166545
Updated On - Day Flow Routing Events.Updated On UPDATED_ON_DAY192765
Updated On - Month Flow Routing Events.Updated On UPDATED_ON_MONTH192841
Updated On - Quarter Flow Routing Events.Updated On UPDATED_ON_QUARTER192917
Updated On - Year Flow Routing Events.Updated On UPDATED_ON_YEAR192993
User Elapsed TimeUser calculated run time attributable to both labor and machineFlow Routing Events.User Elapsed TimeUSER_ELAPSED_TIMEUSER_ELAPSED_TIME166927
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Flow Routing Events -> Flow Routing Line OperationsFlow Routing Events.Line Operation Sequence Id = Flow Routing Line Operations.Operation Sequence IdAlways exist in master folderOuter join on detail No
Flow Routing Events -> Flow Routing ProcessesFlow Routing Events.Process Operation Sequence Id = Flow Routing Processes.Operation Sequence IdAlways exist in master folderOuter join on detail No
Flow Routing Events -> Flow RoutingsFlow Routing Events.Routing Sequence Id = Flow Routings.Routing Sequence IdAlways exist in master folderNoneNo
Flow Routing Events -> Manufacturing DepartmentsFlow Routing Events.Department Id = Manufacturing Departments.Department idAlways exist in master folderNoneNo
Flow Routing Events -> Standard Flow Routing OperationsFlow Routing Events.Standard Operation Id = Standard Flow Routing Operations.Standard Operation IdAlways exist in master folderOuter join on detail No