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("Entry Type" = filter(Capacity), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Ending Date" = field("EOS Posting Date Filter"), Status = filter(Closed | Posted)))

EOS Expected Scrap Quantity (18122709)

Decimal

FieldClass: FlowField

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

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("Entry Type" = filter(Capacity), "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."), "Ending Date" = field("EOS Posting Date Filter"), Status = filter(Closed | Posted)))

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 Type" = filter(Production), "Order No." = FIELD("Prod. Order No."), "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("Entry Type" = filter(Capacity), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No."), "Routing Reference No." = field("Routing Reference No."), "Operation No." = field("Operation No."), "Ending Date" = field("EOS Posting Date Filter"), Status = filter(Closed | Posted)))

EOS Needed Time (ms) (18122717)

Decimal

FieldClass: FlowField

CalcFormula: sum("Prod. Order Capacity Need"."Needed Time (ms)" where(Status = field(Status), "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."), "Time Type" = filter("Run Time")))

EOS Resource Run Time (18122718)

Decimal

FieldClass: FlowField

CalcFormula: sum("Capacity Ledger Entry"."Run Time" where("Order Type" = filter(Production), "Order No." = FIELD("Prod. Order No."), "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 Labs -