Table "Job Task"

ID 1001

Namespace: Microsoft.Projects.Project.Job

Properties

Name	Value
Caption	Project Task
DrillDownPageID	Microsoft.Projects.Project.Job."Job Task Lines"
LookupPageID	Microsoft.Projects.Project.Job."Job Task Lines"
DataClassification	CustomerContent

Fields

Name	Type	Description
"Job No."	Code[20]
"Job Task No."	Code[20]
Description	Text[100]
"Job Task Type"	Microsoft.Projects.Project.Job."Job Task Type"
"WIP-Total"	Option
"Job Posting Group"	Code[20]
"WIP Method"	Code[20]
"Schedule (Total Cost)"	Decimal
"Schedule (Total Price)"	Decimal
"Usage (Total Cost)"	Decimal
"Usage (Total Price)"	Decimal
"Contract (Total Cost)"	Decimal
"Contract (Total Price)"	Decimal
"Contract (Invoiced Price)"	Decimal
"Contract (Invoiced Cost)"	Decimal
"Posting Date Filter"	Date
"Planning Date Filter"	Date
Totaling	Text[250]
"New Page"	Boolean
"No. of Blank Lines"	Integer
Indentation	Integer
"Location Code"	Code[10]
"Bin Code"	Code[20]
"Recognized Sales Amount"	Decimal
"Recognized Costs Amount"	Decimal
"Language Code"	Code[10]
"Recognized Sales G/L Amount"	Decimal
"Recognized Costs G/L Amount"	Decimal
"Global Dimension 1 Code"	Code[20]
"Global Dimension 2 Code"	Code[20]
"Outstanding Orders"	Decimal
"Amt. Rcd. Not Invoiced"	Decimal
"Remaining (Total Cost)"	Decimal
"Remaining (Total Price)"	Decimal
"Start Date"	Date
"End Date"	Date
"Bill-to Customer No."	Code[20]
"Bill-to Name"	Text[100]
"Bill-to Address"	Text[100]
"Bill-to Address 2"	Text[50]
"Bill-to City"	Text[30]
"Bill-to County"	Text[30]
"Bill-to Post Code"	Code[20]
"Bill-to Country/Region Code"	Code[10]
"Bill-to Name 2"	Text[50]
"Bill-to Contact No."	Code[20]
"Bill-to Contact"	Text[100]
"Sell-to Customer No."	Code[20]
"Sell-to Customer Name"	Text[100]
"Sell-to Customer Name 2"	Text[50]
"Sell-to Address"	Text[100]
"Sell-to Address 2"	Text[50]
"Sell-to City"	Text[30]
"Sell-to Contact"	Text[100]
"Sell-to Post Code"	Code[20]
"Sell-to County"	Text[30]
"Sell-to Country/Region Code"	Code[10]
"Sell-to Contact No."	Code[20]
"Ship-to Code"	Code[10]
"Ship-to Name"	Text[100]
"Ship-to Name 2"	Text[50]
"Ship-to Address"	Text[100]
"Ship-to Address 2"	Text[50]
"Ship-to City"	Text[30]
"Ship-to Contact"	Text[100]
"Ship-to Post Code"	Code[20]
"Ship-to County"	Text[30]
"Ship-to Country/Region Code"	Code[10]
"External Document No."	Code[35]
"Payment Method Code"	Code[10]
"Payment Terms Code"	Code[10]
"Your Reference"	Text[35]
"Price Calculation Method"	Microsoft.Pricing.Calculation."Price Calculation Method"
"Invoice Currency Code"	Code[10]
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

CalcEACTotalCost

procedure CalcEACTotalCost(): Decimal

Returns

Type	Description
Decimal

CalcEACTotalPrice

procedure CalcEACTotalPrice(): Decimal

Returns

Type	Description
Decimal

Caption

procedure Caption(): Text

Returns

Type	Description
Text

InitWIPFields

procedure InitWIPFields()

ToPriceSource

procedure ToPriceSource(var PriceSource: Record "Price Source" temporary, PriceType: Enum "Price Type")

Parameters

Name	Type	Description
PriceSource	Record "Price Source" temporary
PriceType	Microsoft.Pricing.PriceList."Price Type"

ValidateShortcutDimCode

procedure ValidateShortcutDimCode(FieldNumber: Integer, var ShortcutDimCode: Code[20])

Parameters

Name	Type	Description
FieldNumber	Integer
ShortcutDimCode	Code[20]

ClearTempDim

procedure ClearTempDim()

ApplyPurchaseLineFilters

procedure ApplyPurchaseLineFilters(var PurchLine: Record "Purchase Line", JobNo: Code[20], JobTaskNo: Code[20])

Parameters

Name	Type	Description
PurchLine	Record "Purchase Line"
JobNo	Code[20]
JobTaskNo	Code[20]

JobPlanningLineExist

procedure JobPlanningLineExist(): Boolean

Returns

Type	Description
Boolean

SalesJobLedgEntryExist

procedure SalesJobLedgEntryExist(): Boolean

Returns

Type	Description
Boolean

ShouldSearchForCustomerByName

procedure ShouldSearchForCustomerByName(CustomerNo: Code[20]): Boolean

Parameters

Name	Type	Description
CustomerNo	Code[20]

Returns

Type	Description
Boolean

BilltoContactLookup

procedure BilltoContactLookup(): Boolean

Returns

Type	Description
Boolean

LookupSellToCustomerName

procedure LookupSellToCustomerName(var CustomerName: Text): Boolean

Parameters

Name	Type	Description
CustomerName	Text

Returns

Type	Description
Boolean

SelltoCustomerNoOnAfterValidate

procedure SelltoCustomerNoOnAfterValidate(var JobTask: Record "Job Task", var xJobTask: Record "Job Task")

Parameters

Name	Type	Description
JobTask	Record "Job Task"
xJobTask	Record "Job Task"

SelltoContactLookup

procedure SelltoContactLookup(): Boolean

Returns

Type	Description
Boolean

ShipToNameEqualsSellToName

procedure ShipToNameEqualsSellToName(): Boolean

Returns

Type	Description
Boolean

BillToAddressEqualsSellToAddress

procedure BillToAddressEqualsSellToAddress(): Boolean

Returns

Type	Description
Boolean

ShipToAddressEqualsSellToAddress

procedure ShipToAddressEqualsSellToAddress(): Boolean

Returns

Type	Description
Boolean

SyncShipToWithSellTo

procedure SyncShipToWithSellTo()

JobLedgEntryExist

procedure JobLedgEntryExist(): Boolean

Returns

Type	Description
Boolean

JobPlanLineExist

procedure JobPlanLineExist(): Boolean

Returns

Type	Description
Boolean

SendProfile

procedure SendProfile(var DocumentSendingProfile: Record "Document Sending Profile")

Parameters

Name	Type	Description
DocumentSendingProfile	Record "Document Sending Profile"

SetHideValidationDialog

procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)

Parameters

Name	Type	Description
NewHideValidationDialog	Boolean

GetHideValidationDialog

procedure GetHideValidationDialog(): Boolean

Returns

Type	Description
Boolean

SuspendDeletionCheck

procedure SuspendDeletionCheck(Suspend: Boolean)

Parameters

Name	Type	Description
Suspend	Boolean

Events

OnAfterApplyPurchaseLineFilters

[IntegrationEvent(False,False)]
local procedure OnAfterApplyPurchaseLineFilters(var JobTask: Record "Job Task", var PurchaseLine: Record "Purchase Line")

Parameters

Name	Type	Description
JobTask	Record "Job Task"
PurchaseLine	Record "Purchase Line"

OnAfterValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnAfterValidateShortcutDimCode(var JobTask: Record "Job Task", var xJobTask: Record "Job Task", FieldNumber: Integer, var ShortcutDimCode: Code[20])

Parameters

Name	Type	Description
JobTask	Record "Job Task"
xJobTask	Record "Job Task"
FieldNumber	Integer
ShortcutDimCode	Code[20]

OnAfterOnInsert

[IntegrationEvent(False,False)]
local procedure OnAfterOnInsert(var JobTask: Record "Job Task", var xJobTask: Record "Job Task")

Parameters

Name	Type	Description
JobTask	Record "Job Task"
xJobTask	Record "Job Task"

OnBeforeOnInsert

[IntegrationEvent(False,False)]
local procedure OnBeforeOnInsert(var JobTask: Record "Job Task", var IsHandled: Boolean)

Parameters

Name	Type	Description
JobTask	Record "Job Task"
IsHandled	Boolean

OnBeforeOnModify

[IntegrationEvent(False,False)]
local procedure OnBeforeOnModify(var JobTask: Record "Job Task", xJobTask: Record "Job Task", var IsHandled: Boolean)

Parameters

Name	Type	Description
JobTask	Record "Job Task"
xJobTask	Record "Job Task"
IsHandled	Boolean

OnBeforeValidateJobTaskNo

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateJobTaskNo(var JobTask: Record "Job Task", var xJobTask: Record "Job Task", FieldNumber: Integer, var IsHandled: Boolean)

Parameters

Name	Type	Description
JobTask	Record "Job Task"
xJobTask	Record "Job Task"
FieldNumber	Integer
IsHandled	Boolean

OnBeforeValidateJobPostingGroup

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateJobPostingGroup(var JobTask: Record "Job Task", xJobTask: Record "Job Task", CallingFieldNo: Integer, var IsHandled: Boolean)

Parameters

Name	Type	Description
JobTask	Record "Job Task"
xJobTask	Record "Job Task"
CallingFieldNo	Integer
IsHandled	Boolean

OnBeforeValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateShortcutDimCode(var JobTask: Record "Job Task", var xJobTask: Record "Job Task", FieldNumber: Integer, var ShortcutDimCode: Code[20], JobTask2: Record "Job Task", var IsHandled: Boolean)

Parameters

Name	Type	Description
JobTask	Record "Job Task"
xJobTask	Record "Job Task"
FieldNumber	Integer
ShortcutDimCode	Code[20]
JobTask2	Record "Job Task"
IsHandled	Boolean

OnInitWIPFieldsOnBeforeModify

[IntegrationEvent(False,False)]
local procedure OnInitWIPFieldsOnBeforeModify(var JobTask: Record "Job Task")

Parameters

Name	Type	Description
JobTask	Record "Job Task"

OnJobLedgEntriesExistOnAfterSetFilter

[IntegrationEvent(False,False)]
local procedure OnJobLedgEntriesExistOnAfterSetFilter(var JobTask: Record "Job Task", var JobLedgerEntry: Record "Job Ledger Entry")

Parameters

Name	Type	Description
JobTask	Record "Job Task"
JobLedgerEntry	Record "Job Ledger Entry"

OnBeforeCaption

[IntegrationEvent(False,False)]
local procedure OnBeforeCaption(JobTask: Record "Job Task", var IsHandled: Boolean, var Result: Text)

Parameters

Name	Type	Description
JobTask	Record "Job Task"
IsHandled	Boolean
Result	Text

See also

• Table