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

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.