TableExtension 27 Item
TableExtension 5130102 M365 MEB Item
Fields
M365 Exchange Type (5130102)
Option
" " (0) , Ersatzteil (1) , "Verschleißteil" (2)
M365 Job No. Filter (5130110)
Code[20]
FieldClass: FlowFilter
TableRelation: Job."No."
M365 Job Item (5130112)
Boolean
M365 Job Location (5130113)
Code[10]
TableRelation: Location.Code where("M365 Location Type" = const("Job Location"))
Obsolete
Removed: No use, please use the project location in engineering setup (210621)M365 Qty. on Purch. Quote (5130115)
Decimal
FieldClass: FlowField
CalcFormula: sum("Purchase Line"."Outstanding Qty. (Base)" where("Document Type" = const(Quote), Type = const(Item), "No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Drop Shipment" = field("Drop Shipment Filter"), "Variant Code" = field("Variant Filter"), "Expected Receipt Date" = field("Date Filter"), "Job No." = field("M365 Job No. Filter")))
M365 Qty. on Job Structur Line (5130116)
Decimal
FieldClass: FlowField
CalcFormula: sum("M365 Job Structure Line"."Outstanding Neg. Qty. (Base)" where(Type = const(Item), "No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Location Code" = field("Location Filter"), "Variant Code" = field("Variant Filter"), "Ending Date" = field("Date Filter"), "Job No." = field("M365 Job No. Filter")))
M365 Outstanding Qty. Project (5130117)
Decimal
FieldClass: FlowField
CalcFormula: sum("M365 Job Structure Line"."Outstanding Neg. Qty. (Base)" where("No." = field("No.")))
M365 Last Unit Cost Calc. From (5130118)
Code[50]
TableRelation: User."User Name"
M365 Last Unit Cost Calc. At (5130119)
DateTime
M365 No Disposition (5130120)
Boolean
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.