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
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.