TableExtension 167 Job

TableExtension 5312701 M365 MEB Job

Fields

M365 No. of Job Structures (5130110)

Integer

FieldClass: FlowField

CalcFormula: count("M365 Job Structure Header" where("Job No." = field("No.")))

M365 Sell-to Customer No. (5130111)

Code[20]

TableRelation: Customer

M365 Sell-to Contact No. (5130112)

Code[20]

TableRelation: Contact

M365 Sell-to Contact (5130113)

Text[100]

M365 Sell-to Cust Templat Code (5130114)

Code[10]

TableRelation: "Customer Templ."

M365 Sell-to Customer Name (5130115)

Text[100]

M365 Sell-to Customer Name 2 (5130116)

Text[50]

M365 Sell-to Address (5130117)

Text[100]

M365 Sell-to Address 2 (5130118)

Text[50]

M365 Sell-to City (5130119)

Text[30]

TableRelation: "Post Code".City

M365 Sell-to Post Code (5130120)

Code[20]

TableRelation: "Post Code"

M365 Sell-to County (5130121)

Text[30]

M365 Sell-to Country/RegionCod (5130122)

Code[10]

TableRelation: "Country/Region"

M365 Scheduling Direction (5130126)

Option

Forward (0) , Backward (1)

M365 Ship-to Code (5130127)

Code[10]

TableRelation: "Ship-to Address".Code where("Customer No." = field("Sell-to Customer No."))

M365 Ship-to Name (5130131)

Text[100]

M365 Ship-to City (5130135)

Text[30]

TableRelation: "Post Code".City

M365 Ship-to Contact (5130136)

Text[100]

M365 Ship-to County (5130138)

Text[30]

M365 Ship-to Country/RegionCod (5130139)

Code[10]

TableRelation: "Country/Region"

M365 No. of Interactions (5130140)

Integer

FieldClass: FlowField

CalcFormula: count("Interaction Log Entry" where("M365 Job No." = field("No.")))

M365 Ship-to Name 2 (5130141)

Text[50]

M365 Ship-to Address (5130142)

Text[100]

M365 Ship-to Address 2 (5130245)

Text[50]

M365 Ship-to Post Code (5130246)

Code[20]

TableRelation: "Post Code"

M365 Sched. Job Struc. Res.Qty (5137840)

Decimal

FieldClass: FlowField

CalcFormula: sum("M365 Job Structure Res. Cap."."Quantity (Base)" where("Planning Date" = field("Planning Date Filter"), "Job No." = field("No."), "Resource No." = field("Resource Filter")))

M365 Sched JobStruc Res.Gr.Qty (5137841)

Decimal

FieldClass: FlowField

CalcFormula: sum("M365 Job Structure Res. Cap."."Quantity (Base)" where("Planning Date" = field("Planning Date Filter"), "Job No." = field("No."), "Resource Group" = field("Resource Gr. Filter")))

M365 No. of Sales Quotes (5137842)

Integer

FieldClass: FlowField

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

M365 No. of Sales Orders (5137843)

Integer

FieldClass: FlowField

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

M365 No. of Sales Shipments (5137844)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Shipment Header" where("M365 Job No." = field("No.")))

M365 No. of Sales Invoices (5312710)

Integer

FieldClass: FlowField

CalcFormula: count("Sales Invoice Header" where("M365 Job No." = field("No.")))

M365 No. of Purch. Quotes (5312711)

Integer

FieldClass: FlowField

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

M365 No. of Purch. Orders (5312712)

Integer

FieldClass: FlowField

CalcFormula: count("Purchase Header" where("Document Type" = const(Order), "M365 Job No." = field("No.")))

M365 No. of Purch. Receipts (5312713)

Integer

FieldClass: FlowField

CalcFormula: count("Purch. Rcpt. Header" where("M365 Job No." = field("No.")))

M365 No. of Purch. Invoices (5312714)

Integer

FieldClass: FlowField

CalcFormula: count("Purch. Inv. Header" where("M365 Job No." = field("No.")))

M365 Job Update (5312715)

Boolean

M365 Dimension Set ID (5312716)

Integer

TableRelation: "Dimension Set Entry"

M365 Assigned to (5312717)

Code[50]

TableRelation: User."User Name"

M365 Job Location (5312718)

Code[10]

TableRelation: "Location".Code where("M365 Location Type" = const(1))

Methods

M365ShowDimensions

procedure M365ShowDimensions()

M365UpdateSellToCont

procedure M365UpdateSellToCont(customerNo: Code[20])

Parameters / Return Value

  • customerNo Code[20]

M365UpdateSellToCust

procedure M365UpdateSellToCust(contactNo: Code[20])

Parameters / Return Value

  • contactNo Code[20]

M365InsertProjectContacts

procedure M365InsertProjectContacts(contactNo: Code[20])

Parameters / Return Value

  • contactNo Code[20]

M365SetJobStructStatus

procedure M365SetJobStructStatus()

M365CreateInteraction

procedure M365CreateInteraction()

M365CreateNewProjectDimValueForJobStructLine

procedure M365CreateNewProjectDimValueForJobStructLine()

Events

M365OnBeforeShowDimensions

local procedure M365OnBeforeShowDimensions(var Job: Record Job; xRec: Record Job; var IsHandled: Boolean)

This event is raised before invoke “M365 Dimension Set ID” := dimMgt.EditDimensionSet

Parameters / Return Value

  • Job Record "Job"

    Current “Job” Record

  • xRec Record "Job"

    Current “xrec” Record

  • IsHandled Boolean

    Returning true will exit M365ShowDimensions procedure without updating anything.

M365OnAfterShowDimensions

local procedure M365OnAfterShowDimensions(var Job: Record Job; xJob: Record Job)

This event is raised after invoke “M365 Dimension Set ID” := dimMgt.EditDimensionSet (so after opening standard dimension edit page)

Parameters / Return Value

  • Job Record "Job"

    Current “Job” Record

  • xJob Record "Job"

    Current “xrec” Record


EOS Labs -