TableExtension 5409 Prod. Order Routing Line

TableExtension 70623870 EOS070Tableext70623870

Fields

EOS Line Description (18122703)

Text[100]

FieldClass: FlowField

CalcFormula: lookup("Prod. Order Line".Description where(Status = const(Released), "Prod. Order No." = field("Prod. Order No."), "Line No." = field("Routing Reference No.")))

EOS Line Description 2 (18122704)

Text[50]

FieldClass: FlowField

CalcFormula: lookup("Prod. Order Line"."Description 2" where(Status = const(Released), "Prod. Order No." = field("Prod. Order No."), "Line No." = field("Routing Reference No.")))

EOS Panel ID Filter (18122705)

Guid

FieldClass: FlowFilter

EOS Stapling No. (18122706)

Text[50]

FieldClass: FlowField

CalcFormula: lookup("EOS 070 MES Employee Entry"."Stapling No." where("Entry Type" = filter(Stapling), Status = filter(Open), "Prod. Order No." = field("Prod. Order No."), "Prod. Order Line No." = field("Routing Reference No."), "Operation No." = field("Operation No.")))

EOS Prod. Order Source Type (18122707)

Enum "Prod. Order Source Type"

FieldClass: FlowField

CalcFormula: lookup("Production Order"."Source Type" where("Status" = field(Status), "No." = field("Prod. Order No.")))

EOS Expected Output Quantity (18122708)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS 070 MES Employee Entry"."Output Quantity" where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Entry Type" = filter(Capacity), Status = filter(Closed | Posted), "Ending Date" = field("EOS Posting Date Filter")))

EOS Expected Scrap Quantity (18122709)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS 070 MES Employee Entry"."Scrap Quantity" where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Entry Type" = filter(Capacity), Status = filter(Closed | Posted), "Ending Date" = field("EOS Posting Date Filter")))

EOS Prod. Order Quantity (18122710)

Decimal

FieldClass: FlowField

CalcFormula: lookup("Production Order".Quantity where("Status" = field("Status"), "No." = field("Prod. Order No.")))

EOS Expected Run Time (18122712)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS 070 MES Employee Entry"."Duration Ms." where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Type" = field("Type"), "No." = field("No."), "Entry Type" = filter(Capacity), Status = filter(Closed | Posted), "Ending Date" = field("EOS Posting Date Filter")))

EOS Prod. Line Quantity (18122713)

Decimal

FieldClass: FlowField

CalcFormula: sum("Prod. Order Line"."Quantity (Base)" where(Status = const(Released), "Prod. Order No." = field("Prod. Order No."), "Line No." = field("Routing Reference No.")))

EOS Prod. Line Rem. Quantity (18122714)

Decimal

FieldClass: FlowField

CalcFormula: sum("Prod. Order Line"."Remaining Qty. (Base)" where(Status = const(Released), "Prod. Order No." = field("Prod. Order No."), "Line No." = field("Routing Reference No.")))

EOS Actual Entries Exists (18122715)

Boolean

FieldClass: FlowField

CalcFormula: exist("Capacity Ledger Entry" where("Order No." = FIELD("Prod. Order No."), "Order Type" = filter(Production), "Order Line No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Posting Date" = field("EOS Posting Date Filter")))

EOS Expected Entries Exists (18122716)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS 070 MES Employee Entry" where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Entry Type" = filter(Capacity), "Ending Date" = field("EOS Posting Date Filter")))

EOS Needed Time (ms) (18122717)

Decimal

FieldClass: FlowField

CalcFormula: sum("Prod. Order Capacity Need"."Needed Time (ms)" where("Prod. Order No." = field("Prod. Order No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), Type = field(Type), "No." = field("No."), Status = field(Status), "Time Type" = filter("Run Time")))

EOS Resource Run Time (18122718)

Decimal

FieldClass: FlowField

CalcFormula: sum("Capacity Ledger Entry"."Run Time" where("Order No." = FIELD("Prod. Order No."), "Order Type" = filter(Production), "Order Line No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Type" = field("Type"), "No." = field("No."), "Posting Date" = field("EOS Posting Date Filter")))

EOS Panel Setup Id Filter (70623870)

Guid

FieldClass: FlowFilter

EOS PowerMES Custom Filter 1 (70623871)

Text[2048]

FieldClass: FlowFilter

EOS PowerMES Custom Filter 2 (70623872)

Text[2048]

FieldClass: FlowFilter

EOS PowerMES Custom Filter 3 (70623873)

Text[2048]

FieldClass: FlowFilter

EOS PowerMES Custom Filter 4 (70623874)

Text[2048]

FieldClass: FlowFilter

EOS PowerMES Custom Filter 5 (70623875)

Text[2048]

FieldClass: FlowFilter

EOS Total Exp. Output Quantity (70623876)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS 070 MES Employee Entry"."Output Quantity" where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Entry Type" = filter(Capacity), Status = filter(Closed | Posted)))

EOS Total Exp. Scrap Quantity (70623877)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS 070 MES Employee Entry"."Scrap Quantity" where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Entry Type" = filter(Capacity), Status = filter(Closed | Posted)))

EOS Total Exp. Run Time (70623878)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS 070 MES Employee Entry"."Duration Ms." where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Type" = field("Type"), "No." = field("No."), "Entry Type" = filter(Capacity), Status = filter(Closed | Posted)))

EOS Total Act. Res. Run Time (70623879)

Decimal

FieldClass: FlowField

CalcFormula: sum("Capacity Ledger Entry"."Run Time" where("Order No." = FIELD("Prod. Order No."), "Order Type" = filter(Production), "Order Line No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Type" = field("Type"), "No." = field("No.")))

EOS Total Act. Output Quantity (70623880)

Decimal

FieldClass: FlowField

CalcFormula: sum("Capacity Ledger Entry"."Output Quantity" where("Order No." = field("Prod. Order No."), "Order Type" = const(Production), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No.")))

EOS Total Act. Scrap Quantity (70623881)

Decimal

FieldClass: FlowField

CalcFormula: sum("Capacity Ledger Entry"."Scrap Quantity" where("Order No." = FIELD("Prod. Order No."), "Order Type" = filter(Production), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No.")))

EOS Total Act. Run Time (70623882)

Decimal

FieldClass: FlowField

CalcFormula: sum("Capacity Ledger Entry"."Run Time" where("Order No." = FIELD("Prod. Order No."), "Order Type" = filter(Production), "Order Line No." = field("Routing Reference No."), "Operation No." = field("Operation No.")))

EOS Total Act. Entries Exists (70623883)

Boolean

FieldClass: FlowField

CalcFormula: exist("Capacity Ledger Entry" where("Order No." = FIELD("Prod. Order No."), "Order Type" = filter(Production), "Order Line No." = field("Routing Reference No."), "Operation No." = field("Operation No.")))

EOS Total Exp. Entries Exists (70623884)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS 070 MES Employee Entry" where("Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Entry Type" = filter(Capacity), Status = filter(Closed | Posted)))

EOS Emp. Entry Activity Type (70623885)

Enum "EOS 070 MES Posting Type"

FieldClass: FlowField

CalcFormula: lookup("EOS 070 MES Employee Entry"."Activity Type" where("Entry Type" = filter(Capacity), Status = filter(Open), "Prod. Order No." = field("Prod. Order No."), "Prod. Order Line No." = field("Routing Reference No."), "Operation No." = field("Operation No.")))

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.