Table of Contents

Table "Job Task"

ID 1001
Namespace: Microsoft.Projects.Project.Job

Properties

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

Fields

Name Type Description
"Job No." Code[20]

Specifies the number of the related project.
"Job Task No." Code[20]

Specifies the number of the related project task.
Description Text[100]

Specifies a description of the project task. You can enter anything that is meaningful in describing the task. The description is copied and used in descriptions on the project planning line.
"Job Task Type" Enum Microsoft.Projects.Project.Job."Job Task Type"

Specifies the purpose of the account. Newly created accounts are automatically assigned the Posting account type, but you can change this. Choose the field to select one of the following five options:
"WIP-Total" Option

Specifies the project tasks you want to group together when calculating Work In Process (WIP) and Recognition.
"Job Posting Group" Code[20]

Specifies the project posting group of the task.
"WIP Method" Code[20]

Specifies the name of the Work in Process calculation method that is associated with a project. The value in this field comes from the WIP method specified on the project card.
"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]

Specifies an interval or a list of project task numbers.
"New Page" Boolean

Specifies whether you want a new page to start immediately after this project task when you print the project tasks. To start a new page after this project task, select the New Page check box.
"No. of Blank Lines" Integer

Specifies the number of blank lines that you want inserted before this project task in reports that shows project tasks.
Indentation Integer
"Location Code" Code[10]

Specifies the location code of the task.
"Bin Code" Code[20]

Specifies a bin code for specific location of the task.
"Recognized Sales Amount" Decimal
"Recognized Costs Amount" Decimal
"Language Code" Code[10]

Specifies the language to be used on printouts for this project.
"Recognized Sales G/L Amount" Decimal
"Recognized Costs G/L Amount" Decimal
"Global Dimension 1 Code" Code[20]

Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists.
"Global Dimension 2 Code" Code[20]

Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists.
"Outstanding Orders" Decimal

Specifies the sum of outstanding orders, in local currency, for this project task. The value of the Outstanding Amount (LCY) field is used for entries in the Purchase Line table of document type Order to calculate and update the contents of this field.
"Amt. Rcd. Not Invoiced" Decimal

Specifies the sum for items that have been received but have not yet been invoiced. The value in the Amt. Rcd. Not Invoiced (LCY) field is used for entries in the Purchase Line table of document type Order to calculate and update the contents of this field.
"Remaining (Total Cost)" Decimal
"Remaining (Total Price)" Decimal
"Start Date" Date

Specifies the start date for the project task. The date is based on the date on the related project planning line.
"End Date" Date

Specifies the end date for the project task. The date is based on the date on the related project planning line.
"Bill-to Customer No." Code[20]

Specifies the number of the customer who pays for the project.
"Bill-to Name" Text[100]

Specifies the name of the customer who pays for the project.
"Bill-to Address" Text[100]

Specifies the address of the customer to whom you will send the invoice.
"Bill-to Address 2" Text[50]

Specifies an additional line of the address.
"Bill-to City" Text[30]

Specifies the city of the address.
"Bill-to County" Text[30]

Specifies the county code of the customer's billing address.
"Bill-to Post Code" Code[20]

Specifies the postal code of the customer who pays for the project.
"Bill-to Country/Region Code" Code[10]

Specifies the country/region code of the customer's billing address.
"Bill-to Name 2" Text[50]

Specifies an additional part of the name of the customer who pays for the project.
"Bill-to Contact No." Code[20]

Specifies the number of the contact person at the customer's billing address.
"Bill-to Contact" Text[100]

Specifies the name of the contact person at the customer who pays for the project.
"Sell-to Customer No." Code[20]

Specifies the number of the customer who will receive the products and be billed by default for the project task.
"Sell-to Customer Name" Text[100]

Specifies the name of the customer who will receive the products and be billed by default.
"Sell-to Customer Name 2" Text[50]

Specifies an additional part of the name of the customer who will receive the products and be billed by default.
"Sell-to Address" Text[100]

Specifies the address where the customer is located.
"Sell-to Address 2" Text[50]

Specifies additional address information.
"Sell-to City" Text[30]

Specifies the city of the customer on the sales document.
"Sell-to Contact" Text[100]

Specifies the name of the person to contact at the customer.
"Sell-to Post Code" Code[20]

Specifies the postal code.
"Sell-to County" Text[30]

Specifies the state, province or county of the address.
"Sell-to Country/Region Code" Code[10]

Specifies the country or region of the address.
"Sell-to Contact No." Code[20]

Specifies the number of the contact person that the sales document will be sent to.
"Ship-to Code" Code[10]

Specifies the code for another shipment address than the customer's own address, which is entered by default.
"Ship-to Name" Text[100]

Specifies the name that products on the sales document will be shipped to.
"Ship-to Name 2" Text[50]

Specifies an additional part of the name that products on the sales document will be shipped to.
"Ship-to Address" Text[100]

Specifies the address that products on the sales document will be shipped to.
"Ship-to Address 2" Text[50]

Specifies additional address information.
"Ship-to City" Text[30]

Specifies the city of the customer on the sales document.
"Ship-to Contact" Text[100]

Specifies the name of the contact person at the address that products on the sales document will be shipped to.
"Ship-to Post Code" Code[20]

Specifies the postal code.
"Ship-to County" Text[30]

Specifies the state, province or county of the address.
"Ship-to Country/Region Code" Code[10]

Specifies the customer's country/region.
"External Document No." Code[35]
"Payment Method Code" Code[10]
"Payment Terms Code" Code[10]
"Your Reference" Text[35]
"Price Calculation Method" Enum Microsoft.Pricing.Calculation."Price Calculation Method"

Specifies the default method of the unit price calculation.
"Invoice Currency Code" Code[10]

Specifies the currency code you want to apply when creating invoices for a project. By default, the invoice currency code for a project is based on what currency code is defined on the customer card.
"Coupled to Dataverse" Boolean
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemCreatedByUserName Text[50]
SystemCreatedByFullName Text[80]
SystemModifiedByUserName Text[50]
SystemModifiedByFullName Text[80]
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"; PriceType: Enum "Price Type")

Parameters

Name Type Description
PriceSource Table Microsoft.Pricing.Source."Price Source"
PriceType Enum 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 Table Microsoft.Purchases.Document."Purchase Line"
JobNo Code[20]
JobTaskNo Code[20]

JobPlanningLineExist

procedure JobPlanningLineExist(): Boolean

Returns

Type Description
Boolean

SalesJobLedgEntryExist

procedure SalesJobLedgEntryExist(): Boolean

Returns

Type Description
Boolean

SalesLineExist

procedure SalesLineExist(): 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 Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."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 Table Microsoft.Foundation.Reporting."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 Table Microsoft.Projects.Project.Job."Job Task"
PurchaseLine Table Microsoft.Purchases.Document."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 Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."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 Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"

OnBeforeOnInsert

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

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."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 Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."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 Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."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 Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."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 Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
FieldNumber Integer
ShortcutDimCode Code[20]
JobTask2 Table Microsoft.Projects.Project.Job."Job Task"
IsHandled Boolean

OnInitWIPFieldsOnBeforeModify

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

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."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 Table Microsoft.Projects.Project.Job."Job Task"
JobLedgerEntry Table Microsoft.Projects.Project.Ledger."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 Table Microsoft.Projects.Project.Job."Job Task"
IsHandled Boolean
Result Text

OnAfterShipToAddressEqualsSellToAddress

[IntegrationEvent(False,False)]
local procedure OnAfterShipToAddressEqualsSellToAddress(var JobTask: Record "Job Task"; var Result: Boolean)

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
Result Boolean

OnAfterSyncShipToWithSellTo

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

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"

OnUpdateCostPricesOnRelatedJobPlanningLinesOnBeforeConfirmUpdate

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

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
ConfirmResult Boolean
IsHandled Boolean

OnBeforeCheckSellToCustomerAssosEntriesExist

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

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
IsHandled Boolean

OnBeforeCheckBillToCustomerAssosEntriesExist

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

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
IsHandled Boolean

OnBeforeSellToCustomerNoUpdated

[IntegrationEvent(False,False)]
local procedure OnBeforeSellToCustomerNoUpdated(var JobTask: Record "Job Task"; var xJobTask: Record "Job Task"; CallingFieldNo: Integer)

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
CallingFieldNo Integer

OnAfterSellToCustomerNoUpdated

[IntegrationEvent(False,False)]
local procedure OnAfterSellToCustomerNoUpdated(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var SellToCustomer: Record Customer)

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
SellToCustomer Table Microsoft.Sales.Customer.Customer

OnAfterShipToCodeValidate

[IntegrationEvent(False,False)]
local procedure OnAfterShipToCodeValidate(var JobTask: Record "Job Task"; var ShipToAddress: Record "Ship-to Address")

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
ShipToAddress Table Microsoft.Sales.Customer."Ship-to Address"

OnBeforeBillToCustomerNoUpdated

[IntegrationEvent(False,False)]
local procedure OnBeforeBillToCustomerNoUpdated(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; CallingFieldNo: Integer)

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
CallingFieldNo Integer

OnBillToCustomerNoUpdatedOnAfterCopyFieldsFromBillToCustomer

[IntegrationEvent(False,False)]
local procedure OnBillToCustomerNoUpdatedOnAfterCopyFieldsFromBillToCustomer(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var Job: Record Job; var BillToCustomer: Record Customer)

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
Job Table Microsoft.Projects.Project.Job.Job
BillToCustomer Table Microsoft.Sales.Customer.Customer

OnAfterBillToCustomerNoUpdated

[IntegrationEvent(False,False)]
local procedure OnAfterBillToCustomerNoUpdated(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var BillToCustomer: Record Customer; CallingFieldNo: Integer)

Parameters

Name Type Description
JobTask Table Microsoft.Projects.Project.Job."Job Task"
xJobTask Table Microsoft.Projects.Project.Job."Job Task"
BillToCustomer Table Microsoft.Sales.Customer.Customer
CallingFieldNo Integer

See also