Table 5130099 M365 Job Struct. Line Addition

Table 5130099 M365 Job Struct. Line Addition

Fields

Entry No. (1)

Integer

TableRelation: "M365 Job Structure Line"."Entry No."

AmtSalesQuoteLines (10)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Line" where("M365 Job Structure Entry No." = field("Entry No."), "Document Type" = const(Quote)))

AmtSalesOrderLines (20)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Line" where("M365 Job Structure Entry No." = field("Entry No."), "Document Type" = const(Order)))

AmtSalesRetOrderLines (30)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Line" where("M365 Job Structure Entry No." = field("Entry No."), "Document Type" = const("Return Order")))

AmtSalesShptLines (40)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Shipment Line" where("M365 Job Structure Entry No." = field("Entry No."), Quantity = filter(<> 0), Correction = const(false)))

AmtSalesInvLines (50)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Invoice Line" where("M365 Job Structure Entry No." = field("Entry No.")))

AmtSalesCrMemoLines (60)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Cr.Memo Line" where("M365 Job Structure Entry No." = field("Entry No.")))

AmtPurchBlanketOrderLines (70)

Integer

FieldClass: FlowField

CalcFormula: count("Purchase Line" where("M365 Job Structure Entry No." = field("Entry No."), "Document Type" = const("Blanket Order")))

AmtRequisitionLines (80)

Integer

FieldClass: FlowField

CalcFormula: count("Requisition Line" where("M365 Job Struct. Entry No." = field("Entry No.")))

AmtPurchQuoteLines (90)

Integer

FieldClass: FlowField

CalcFormula: count("Purchase Line" where("M365 Job Structure Entry No." = field("Entry No."), "Document Type" = const(Quote)))

AmtPurchBatchQuoteLines (100)

Integer

FieldClass: FlowField

CalcFormula: count("M365 Batch Quote Item Line" where("M365 MEB JobStructureEntryNo" = field("Entry No.")))

AmtPurchOrderLines (110)

Integer

FieldClass: FlowField

CalcFormula: count("Purchase Line" where("M365 Job Structure Entry No." = field("Entry No."), "Document Type" = const(Order), "Expected Receipt Date" = field("Date Filter")))

AmtPurchRcptLines (120)

Integer

FieldClass: FlowField

CalcFormula: count("Purch. Rcpt. Line" where("M365 Job Structure Entry No." = field("Entry No."), Quantity = filter(<> 0), Correction = const(false)))

AmtPurchInvLines (130)

Integer

FieldClass: FlowField

CalcFormula: count("Purch. Inv. Line" where("M365 Job Structure Entry No." = field("Entry No.")))

AmtProdOrderFirmLines (140)

Integer

FieldClass: FlowField

CalcFormula: count("Prod. Order Line" where("M365 Job Structure Entry No." = field("Entry No."), Status = const("Firm Planned"), "Ending Date" = field("Date Filter")))

AmtProdOrderRelLines (150)

Integer

FieldClass: FlowField

CalcFormula: count("Prod. Order Line" where("M365 Job Structure Entry No." = field("Entry No."), Status = const(Released), "Ending Date" = field("Date Filter")))

AmtProdOrderFinLines (160)

Integer

FieldClass: FlowField

CalcFormula: count("Prod. Order Line" where("M365 Job Structure Entry No." = field("Entry No."), Status = const(Finished)))

Date Filter (200)

Date

FieldClass: FlowFilter


EOS Labs -