TableExtension 5130131 M365 Job Structure Disposition

TableExtension 18126660 EOS04606 TableExt18126660

Fields

EOS Job Structure Entry No. (18126661)

Integer

FieldClass: FlowField

CalcFormula: lookup("M365 Job Structure Line"."Entry No." where("No." = field("No.")))

EOS Purchase Request Quantity (18126662)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS Purch. Request Line"."EOS Quantity" where("EOS Job Structure Entry No." = field("Job Structure Entry No.")))

EOS Open PRQ Quantity (18126663)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS Purch. Request Line"."EOS Quantity" where("EOS Job Structure Entry No." = field("Job Structure Entry No."), "Status" = filter(Open | Approved | Closed)))

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.