Table 1001 "Job Task"
Base Application · Microsoft.Projects.Project.Job
Across versions
- BC23present
- BC2442 fields added, 39 procedures added
- BC258 events added, 1 fields changed
- BC261 fields changed
- BC272 fields changed
- BC2866 fields changed
- BC291 procedures added
- BC30unchanged
Neighbourhood 88 connected objects and pages
Base Application · Microsoft.Projects.Project.Job · captioned “Project Task” · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1002 “Job Task Lines” (4 Learn pages), Page 1001 “Job Task Lines Subform” (2), Page 1003 “Job Task Card” (2), Page 1004 “Job Task List” (2).
Properties
| Property | Value |
|---|---|
| Caption | Project Task |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Job No. Δ BC24 Δ BC28 | Code[20] | Specifies the number of the related project. | TableRelation Table 167 “Job”; not editable; NotBlank |
| 2 | Job Task No. Δ BC24 Δ BC28 | Code[20] | Specifies the number of the related project task. | NotBlank |
| 3 | Description Δ BC28 | 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. | |
| 4 | Job Task Type Δ BC24 Δ BC28 | Enum “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: | enum Enum 1001 “Job Task Type” |
| 6 | WIP-Total Δ BC28 | Option | Specifies the project tasks you want to group together when calculating Work In Process (WIP) and Recognition. | OptionCaption: ,Total,Excluded |
| 7 | Job Posting Group Δ BC24 Δ BC28 | Code[20] | Specifies the project posting group of the task. | TableRelation Table 208 “Job Posting Group” (Job Posting Group) |
| 9 | WIP Method Δ BC28 | 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. | TableRelation Table 1006 “Job WIP Method” (“Job WIP Method”.Code where(Valid = const(true))) |
| 10 | Schedule (Total Cost) Δ BC24 Δ BC28 | Decimal | Specifies, in the local currency, the total budgeted cost for the project task during the time period in the Planning Date Filter field. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Planning Line”.“Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”))); not editable |
| 11 | Schedule (Total Price) Δ BC24 Δ BC28 | Decimal | Specifies, in local currency, the total budgeted price for the project task during the time period in the Planning Date Filter field. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Planning Line”.“Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”))); not editable |
| 12 | Usage (Total Cost) Δ BC24 Δ BC28 | Decimal | Specifies, in local currency, the total cost of the usage of items, resources and general ledger expenses posted on the project task during the time period in the Posting Date Filter field. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Ledger Entry”.“Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Entry Type” = const(Usage), “Posting Date” = field(“Posting Date Filter”))); not editable |
| 13 | Usage (Total Price) Δ BC24 Δ BC28 | Decimal | Specifies, in the local currency, the total price of the usage of items, resources and general ledger expenses posted on the project task during the time period in the Posting Date Filter field. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Ledger Entry”.“Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Entry Type” = const(Usage), “Posting Date” = field(“Posting Date Filter”))); not editable |
| 14 | Contract (Total Cost) Δ BC24 Δ BC28 | Decimal | Specifies, in local currency, the total billable cost for the project task during the time period in the Planning Date Filter field. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Planning Line”.“Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Contract Line” = const(true), “Planning Date” = field(“Planning Date Filter”))); not editable |
| 15 | Contract (Total Price) Δ BC24 Δ BC28 | Decimal | Specifies, in the local currency, the total billable price for the project task during the time period in the Planning Date Filter field. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Planning Line”.“Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Contract Line” = const(true), “Planning Date” = field(“Planning Date Filter”))); not editable |
| 16 | Contract (Invoiced Price) Δ BC24 Δ BC28 | Decimal | Specifies, in the local currency, the total billable price for the project task that has been invoiced during the time period in the Posting Date Filter field. via Page 1002 “Job Task Lines” | FlowField: - sum(“Job Ledger Entry”.“Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Entry Type” = const(Sale), “Posting Date” = field(“Posting Date Filter”))); not editable |
| 17 | Contract (Invoiced Cost) Δ BC24 Δ BC28 | Decimal | Specifies, in the local currency, the total billable cost for the project task that has been invoiced during the time period in the Posting Date Filter field. via Page 1002 “Job Task Lines” | FlowField: - sum(“Job Ledger Entry”.“Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Entry Type” = const(Sale), “Posting Date” = field(“Posting Date Filter”))); not editable |
| 19 | Posting Date Filter | Date | — | FlowFilter |
| 20 | Planning Date Filter | Date | — | FlowFilter |
| 21 | Totaling Δ BC28 | Text[250] | Specifies an interval or a list of project task numbers. | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))) |
| 22 | New Page Δ BC28 | 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. | |
| 23 | No. of Blank Lines Δ BC28 | Integer | Specifies the number of blank lines that you want inserted before this project task in reports that shows project tasks. | |
| 24 | Indentation | Integer | — | |
| 30 | Location Code + BC24 Δ BC28 | Code[10] | Specifies the location code of the task. | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))) |
| 31 | Bin Code + BC24 Δ BC28 | Code[20] | Specifies a bin code for specific location of the task. | TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))) |
| 34 | Recognized Sales Amount Δ BC28 | Decimal | — | not editable |
| 37 | Recognized Costs Amount Δ BC28 | Decimal | — | not editable |
| 41 | Language Code + BC24 Δ BC28 | Code[10] | Specifies the language to be used on printouts for this project. | TableRelation Table 8 “Language” |
| 56 | Recognized Sales G/L Amount Δ BC28 | Decimal | — | not editable |
| 57 | Recognized Costs G/L Amount Δ BC28 | Decimal | — | not editable |
| 60 | Global Dimension 1 Code Δ BC28 | 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. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 61 | Global Dimension 2 Code Δ BC28 | 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. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 62 | Outstanding Orders Δ BC24 Δ BC28 | 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. | FlowField: sum(“Purchase Line”.“Outstanding Amt. Ex. VAT (LCY)” where(“Document Type” = const(Order), “Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)))) |
| 63 | Amt. Rcd. Not Invoiced Δ BC24 Δ BC28 | 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. | FlowField: sum(“Purchase Line”.“A. Rcd. Not Inv. Ex. VAT (LCY)” where(“Document Type” = const(Order), “Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)))) |
| 64 | Remaining (Total Cost) Δ BC24 Δ BC28 | Decimal | Specifies the remaining total cost (LCY) as the sum of costs from project planning lines associated with the project task. The calculation occurs when you have specified that there is a usage link between the project ledger and the project planning lines. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Planning Line”.“Remaining Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”))); not editable |
| 65 | Remaining (Total Price) Δ BC24 Δ BC28 | Decimal | Specifies the remaining total price (LCY) as the sum of prices from project planning lines associated with the project task. The calculation occurs when you have specified that there is a usage link between the project ledger and the project planning lines. via Page 1002 “Job Task Lines” | FlowField: sum(“Job Planning Line”.“Remaining Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”))); not editable |
| 66 | Start Date Δ BC28 | Date | Specifies the start date for the project task. The date is based on the date on the related project planning line. | FlowField: min(“Job Planning Line”.“Planning Date” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”))); not editable |
| 67 | End Date Δ BC28 | Date | Specifies the end date for the project task. The date is based on the date on the related project planning line. | FlowField: max(“Job Planning Line”.“Planning Date” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”))); not editable |
| 70 | Bill-to Customer No. + BC24 Δ BC28 | Code[20] | Specifies the number of the customer who pays for the project. | TableRelation Table 18 “Customer” |
| 71 | Bill-to Name + BC24 Δ BC28 | Text[100] | Specifies the name of the customer who pays for the project. | TableRelation Customer.Name |
| 72 | Bill-to Address + BC24 Δ BC28 | Text[100] | Specifies the address of the customer to whom you will send the invoice. | |
| 73 | Bill-to Address 2 + BC24 Δ BC28 | Text[50] | Specifies an additional line of the address. | |
| 74 | Bill-to City + BC24 Δ BC28 | Text[30] | Specifies the city of the address. | TableRelation Table 225 “Post Code” (if (“Bill-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Bill-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Bill-to Country/Region Code”))) |
| 75 | Bill-to County + BC24 Δ BC28 | Text[30] | Specifies the county code of the customer’s billing address. | |
| 76 | Bill-to Post Code + BC24 Δ BC28 | Code[20] | Specifies the postal code of the customer who pays for the project. | TableRelation Table 225 “Post Code” (if (“Bill-to Country/Region Code” = const(‘’)) “Post Code” else if (“Bill-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Bill-to Country/Region Code”))) |
| 77 | Bill-to Country/Region Code + BC24 Δ BC28 | Code[10] | Specifies the country/region code of the customer’s billing address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 78 | Bill-to Name 2 + BC24 Δ BC27 | Text[50] | Specifies an additional part of the name of the customer who pays for the project. | |
| 79 | Bill-to Contact No. + BC24 Δ BC25 Δ BC28 | Code[20] | Specifies the number of the contact person at the customer’s billing address. | TableRelation Contact.“No.” |
| 80 | Bill-to Contact + BC24 Δ BC28 | Text[100] | Specifies the name of the contact person at the customer who pays for the project. | |
| 90 | Sell-to Customer No. + BC24 Δ BC28 | Code[20] | Specifies the number of the customer who will receive the products and be billed by default for the project task. | TableRelation Table 18 “Customer” |
| 91 | Sell-to Customer Name + BC24 Δ BC28 | Text[100] | Specifies the name of the customer who will receive the products and be billed by default. | TableRelation Customer.Name |
| 92 | Sell-to Customer Name 2 + BC24 Δ BC27 | Text[50] | Specifies an additional part of the name of the customer who will receive the products and be billed by default. | |
| 93 | Sell-to Address + BC24 Δ BC28 | Text[100] | Specifies the address where the customer is located. | |
| 94 | Sell-to Address 2 + BC24 Δ BC28 | Text[50] | Specifies additional address information. | |
| 95 | Sell-to City + BC24 Δ BC28 | Text[30] | Specifies the city of the customer on the sales document. | TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Sell-to Country/Region Code”))) |
| 96 | Sell-to Contact + BC24 Δ BC28 | Text[100] | Specifies the name of the person to contact at the customer. | |
| 97 | Sell-to Post Code + BC24 Δ BC28 | Code[20] | Specifies the postal code. | TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code” else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Sell-to Country/Region Code”))) |
| 98 | Sell-to County + BC24 Δ BC28 | Text[30] | Specifies the state, province or county of the address. | |
| 99 | Sell-to Country/Region Code + BC24 Δ BC28 | Code[10] | Specifies the country or region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 100 | Sell-to Contact No. + BC24 Δ BC28 | Code[20] | Specifies the number of the contact person that the sales document will be sent to. | TableRelation Table 5050 “Contact” |
| 110 | Ship-to Code + BC24 Δ BC28 | Code[10] | Specifies the code for another shipment address than the customer’s own address, which is entered by default. | TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Sell-to Customer No.”))) |
| 111 | Ship-to Name + BC24 Δ BC28 | Text[100] | Specifies the name that products on the sales document will be shipped to. | |
| 112 | Ship-to Name 2 + BC24 Δ BC28 | Text[50] | Specifies an additional part of the name that products on the sales document will be shipped to. | |
| 113 | Ship-to Address + BC24 Δ BC28 | Text[100] | Specifies the address that products on the sales document will be shipped to. | |
| 114 | Ship-to Address 2 + BC24 Δ BC28 | Text[50] | Specifies additional address information. | |
| 115 | Ship-to City + BC24 Δ BC28 | Text[30] | Specifies the city of the customer on the sales document. | TableRelation Table 225 “Post Code” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Ship-to Country/Region Code”))) |
| 116 | Ship-to Contact + BC24 Δ BC28 | Text[100] | Specifies the name of the contact person at the address that products on the sales document will be shipped to. | |
| 117 | Ship-to Post Code + BC24 Δ BC28 | Code[20] | Specifies the postal code. | TableRelation Table 225 “Post Code” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code” else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Ship-to Country/Region Code”))) |
| 118 | Ship-to County + BC24 Δ BC28 | Text[30] | Specifies the state, province or county of the address. | |
| 119 | Ship-to Country/Region Code + BC24 Δ BC28 | Code[10] | Specifies the customer’s country/region. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 130 | External Document No. + BC24 | Code[35] | Specifies a document number that refers to the customer’s or vendor’s numbering system. via Page 1003 “Job Task Card” | |
| 131 | Payment Method Code + BC24 | Code[10] | Specifies how to make payment, such as with bank transfer, cash, or check. via Page 1003 “Job Task Card” | TableRelation Table 289 “Payment Method” (Payment Method) |
| 132 | Payment Terms Code + BC24 | Code[10] | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. via Page 1003 “Job Task Card” | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 133 | Your Reference + BC24 | Text[35] | Specifies the customer’s reference. The content will be printed on sales documents. via Page 1003 “Job Task Card” | |
| 134 | Price Calculation Method + BC24 Δ BC28 | Enum “Price Calculation Method” | Specifies the default method of the unit price calculation. | enum Enum 7000 “Price Calculation Method” |
| 140 | Invoice Currency Code + BC24 Δ BC28 | 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. | TableRelation Table 4 “Currency” |
| 721 | Coupled to Dataverse + BC24 Δ BC26 Δ BC28 | Boolean | Coupled to Field Service caption | obsolete Removed 28.0; #if not CLEANSCHEMA28; FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::“Job Task”))); not editable |
Keys
- Key1: Job No., Job Task No. (clustered)
- Key2: Job Task No.
- Key3: SystemCreatedAt
Events published
OnAfterApplyPurchaseLineFilters(var JobTask: Record "Job Task"; var PurchaseLine: Record "Purchase Line")(integration)OnAfterValidateShortcutDimCode(var JobTask: Record "Job Task"; var xJobTask: Record "Job Task"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnAfterOnInsert(var JobTask: Record "Job Task"; var xJobTask: Record "Job Task")(integration)OnBeforeOnInsert(var JobTask: Record "Job Task"; var IsHandled: Boolean)(integration)OnBeforeOnModify(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var IsHandled: Boolean)(integration)OnBeforeValidateJobTaskNo(var JobTask: Record "Job Task"; var xJobTask: Record "Job Task"; FieldNumber: Integer; var IsHandled: Boolean)(integration)OnBeforeValidateJobPostingGroup(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; CallingFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeValidateShortcutDimCode(var JobTask: Record "Job Task"; var xJobTask: Record "Job Task"; FieldNumber: Integer; var ShortcutDimCode: Code[20]; JobTask2: Record "Job Task"; var IsHandled: Boolean)(integration)OnInitWIPFieldsOnBeforeModify(var JobTask: Record "Job Task")(integration)OnJobLedgEntriesExistOnAfterSetFilter(var JobTask: Record "Job Task"; var JobLedgerEntry: Record "Job Ledger Entry")(integration)OnBeforeCaption(JobTask: Record "Job Task"; var IsHandled: Boolean; var Result: Text)(integration)OnAfterShipToAddressEqualsSellToAddress(var JobTask: Record "Job Task"; var Result: Boolean)+ BC24 (integration)OnAfterSyncShipToWithSellTo(var JobTask: Record "Job Task")+ BC24 (integration)OnUpdateCostPricesOnRelatedJobPlanningLinesOnBeforeConfirmUpdate(var JobTask: Record "Job Task"; var ConfirmResult: Boolean; var IsHandled: Boolean)+ BC24 (integration)OnBeforeCheckSellToCustomerAssosEntriesExist(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var IsHandled: Boolean)+ BC25 (integration)OnBeforeCheckBillToCustomerAssosEntriesExist(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var IsHandled: Boolean)+ BC25 (integration)OnBeforeSellToCustomerNoUpdated(var JobTask: Record "Job Task"; var xJobTask: Record "Job Task"; CallingFieldNo: Integer)+ BC25 (integration)OnAfterSellToCustomerNoUpdated(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var SellToCustomer: Record Customer)+ BC25 (integration)OnAfterShipToCodeValidate(var JobTask: Record "Job Task"; var ShipToAddress: Record "Ship-to Address")+ BC25 (integration)OnBeforeBillToCustomerNoUpdated(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; CallingFieldNo: Integer)+ BC25 (integration)OnBillToCustomerNoUpdatedOnAfterCopyFieldsFromBillToCustomer(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var Job: Record Job; var BillToCustomer: Record Customer)+ BC25 (integration)OnAfterBillToCustomerNoUpdated(var JobTask: Record "Job Task"; xJobTask: Record "Job Task"; var BillToCustomer: Record Customer; CallingFieldNo: Integer)+ BC25 (integration)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 7006 “Price Helper - V16” AfterDeleteJobTask
- OnAfterRenameEvent: Codeunit 7006 “Price Helper - V16” AfterRenameJobTask
- OnBeforeModifyEvent: Codeunit 1000 “Job Calculate WIP” VerifyJobWIPEntryOnBeforeModify
- OnBeforeRenameEvent: Codeunit 1000 “Job Calculate WIP” VerifyJobWIPEntryOnBeforeRename
Procedures
CalcEACTotalCost(): DecimalCalcEACTotalPrice(): DecimalCaption(): TextInitWIPFields()ToPriceSource(var PriceSource: Record "Price Source"; PriceType: Enum "Price Type")ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ClearTempDim()ApplyPurchaseLineFilters(var PurchLine: Record "Purchase Line"; JobNo: Code[20]; JobTaskNo: Code[20])JobPlanningLineExist(): Boolean+ BC24SalesJobLedgEntryExist(): Boolean+ BC24SalesLineExist(): Boolean+ BC24ShouldSearchForCustomerByName(CustomerNo: Code[20]): Boolean+ BC24UpdateSellToContact(CustomerNo: Code[20])+ BC24 (protected)BilltoContactLookup(): Boolean+ BC24LookupSellToCustomerName(var CustomerName: Text): Boolean+ BC24SelltoCustomerNoOnAfterValidate(var JobTask: Record "Job Task"; var xJobTask: Record "Job Task")+ BC24SelltoContactLookup(): Boolean+ BC24ShipToNameEqualsSellToName(): Boolean+ BC24BillToAddressEqualsSellToAddress(): Boolean+ BC24ShipToAddressEqualsSellToAddress(): Boolean+ BC24SyncShipToWithSellTo()+ BC24JobLedgEntryExist(): Boolean+ BC24JobPlanLineExist(): Boolean+ BC24SendProfile(var DocumentSendingProfile: Record "Document Sending Profile")+ BC24SetHideValidationDialog(NewHideValidationDialog: Boolean)+ BC24GetHideValidationDialog(): Boolean+ BC24SuspendDeletionCheck(Suspend: Boolean)+ BC24
Plus 23 local procedures.
Triggers
OnDelete, OnInsert, OnModify
Relations
- drill-down page Page 1002 “Job Task Lines”
- lookup page Page 1002 “Job Task Lines”
- Totaling: TableRelation Table 1001 “Job Task”
- Contract (Total Cost): CalcFormula Table 1003 “Job Planning Line”
- Contract (Total Price): CalcFormula Table 1003 “Job Planning Line”
- End Date: CalcFormula Table 1003 “Job Planning Line”
- Remaining (Total Cost): CalcFormula Table 1003 “Job Planning Line”
- Remaining (Total Price): CalcFormula Table 1003 “Job Planning Line”
- Schedule (Total Cost): CalcFormula Table 1003 “Job Planning Line”
- Schedule (Total Price): CalcFormula Table 1003 “Job Planning Line”
- Start Date: CalcFormula Table 1003 “Job Planning Line”
- WIP Method: TableRelation Table 1006 “Job WIP Method”
- Location Code: TableRelation Table 14 “Location”
- Job No.: TableRelation Table 167 “Job”
- Contract (Invoiced Cost): CalcFormula Table 169 “Job Ledger Entry”
- Contract (Invoiced Price): CalcFormula Table 169 “Job Ledger Entry”
- Usage (Total Cost): CalcFormula Table 169 “Job Ledger Entry”
- Usage (Total Price): CalcFormula Table 169 “Job Ledger Entry”
- Bill-to Customer No.: TableRelation Table 18 “Customer”
- Sell-to Customer No.: TableRelation Table 18 “Customer”
- Job Posting Group: TableRelation Table 208 “Job Posting Group”
- Ship-to Code: TableRelation Table 222 “Ship-to Address”
- Bill-to City: TableRelation Table 225 “Post Code” (conditional)
- Bill-to Post Code: TableRelation Table 225 “Post Code” (conditional)
- Sell-to City: TableRelation Table 225 “Post Code” (conditional)
- Sell-to Post Code: TableRelation Table 225 “Post Code” (conditional)
- Ship-to City: TableRelation Table 225 “Post Code” (conditional)
- Ship-to Post Code: TableRelation Table 225 “Post Code” (conditional)
- Payment Method Code: TableRelation Table 289 “Payment Method”
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Amt. Rcd. Not Invoiced: CalcFormula Table 39 “Purchase Line”
- Outstanding Orders: CalcFormula Table 39 “Purchase Line”
- Invoice Currency Code: TableRelation Table 4 “Currency”
- Sell-to Contact No.: TableRelation Table 5050 “Contact”
- Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”
- Bin Code: TableRelation Table 7354 “Bin”
- Language Code: TableRelation Table 8 “Language”
- Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Sell-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Ship-to Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
55 fields in 51 objects relate to this table (TableRelation or CalcFormula).
- Table 167 “Job”: Calc. Recog. Costs Amount, Calc. Recog. Costs G/L Amount, Calc. Recog. Sales Amount, Calc. Recog. Sales G/L Amount
- Table 1002 “Job Task Dimension”: Job No., Job Task No.
- Table 1001 “Job Task”: Totaling
- Table 1003 “Job Planning Line”: Job Task No.
- Table 1007 “Job WIP Warning”: Job Task No.
- Table 1008 “Job Assigned Resource”: Job Task No.
- Table 1012 “Job Resource Price”: Job Task No.
- Table 1013 “Job Item Price”: Job Task No.
- Table 1014 “Job G/L Account Price”: Job Task No.
- Table 1020 “Job Usage Link”: Job Task No.
- Table 1021 “Job WIP Total”: Job Task No.
- Table 1022 “Job Planning Line Invoice”: Job Task No.
- Table 111 “Sales Shipment Line”: Job Task No.
- Table 113 “Sales Invoice Line”: Job Task No.
- Table 115 “Sales Cr.Memo Line”: Job Task No.
- Table 121 “Purch. Rcpt. Line”: Job Task No.
- Table 123 “Purch. Inv. Line”: Job Task No.
- Table 125 “Purch. Cr. Memo Line”: Job Task No.
- Table 169 “Job Ledger Entry”: Job Task No.
- Table 181 “Posted Gen. Journal Line”: Job Task No.
- Table 210 “Job Journal Line”: Job Task No.
- Table 32 “Item Ledger Entry”: Job Task No.
- Table 37 “Sales Line”: Job Task No.
- Table 39 “Purchase Line”: Job Task No.
- Table 461 “Prepayment Inv. Line Buffer”: Job Task No.
- Table 5108 “Sales Line Archive”: Job Task No.
- Table 5110 “Purchase Line Archive”: Job Task No.
- Table 5136 “Job Task Archive”: Totaling
- Table 5510 “Employee Time Reg Buffer”: Job Task No.
- Table 5771 “Warehouse Source Filter”: Job Task No. Filter
- Table 5802 “Value Entry”: Job Task No.
- Table 5902 “Service Line”: Job Task No.
- Table 5907 “Service Ledger Entry”: Job Task No.
- Table 5991 “Service Shipment Line”: Job Task No.
- Table 5993 “Service Invoice Line”: Job Task No.
- Table 5995 “Service Cr.Memo Line”: Job Task No.
- Table 6012 “Service Line Archive”: Job Task No.
- Table 6227 “Sustainability Value Entry”: Job Task No.
- Table 6651 “Return Shipment Line”: Job Task No.
- Table 6661 “Return Receipt Line”: Job Task No.
- Table 6900 “Expense”: Job Task No.
- Table 6907 “Expense Report Line”: Job Task No.
- Table 6912 “Expense Ledger Entry”: Job Task No.
- Table 6916 “Posted Expense Report Line”: Job Task No.
- Table 81 “Gen. Journal Line”: Job Task No.
- Table 904 “Assemble-to-Order Link”: Job Task No.
- Table 914 “Posted Assemble-to-Order Link”: Job Task No.
- Table 951 “Time Sheet Line”: Job Task No.
- Table 952 “Time Sheet Detail”: Job Task No.
- Table 955 “Time Sheet Line Archive”: Job Task No.
- and 1 more objects (1 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 1001 “Job Task Lines Subform” (source table)
- Page 1002 “Job Task Lines” (source table)
- Page 1003 “Job Task Card” (source table)
- Page 1004 “Job Task List” (source table)
- Page 1024 “Job Task Statistics” (source table)
- Codeunit 1003 “Job Task-Indent” (codeunit runs on it)
- Codeunit 1017 “Job Tasks-Send” (codeunit runs on it)
Extended by
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 408 “DimensionManagement” (6 calls:
ClearTempDim → DeleteJobTaskTempDim,CreateDefaultJobTaskDimensionsFromCustomer → InsertJobTaskDim,OnInsert → InsertJobTaskDim, …) - Codeunit 109 “Lookup State Manager” (1 call:
LookupSellToCustomerName → SaveRecord) - Codeunit 27 “Confirm Management” (1 call:
UpdateCostPricesOnRelatedJobPlanningLines → GetResponseOrDefault) - Codeunit 452 “Report Distribution Management” (1 call:
SendProfile → GetFullDocumentTypeText)
Recent changes
- 2026-07-14 #9315 [Projects] Add Assigned Resources to projects and project tasks (main, BC30, feature)
Deprecations
- field Coupled to Dataverse: Removed 28.0 (#if not CLEANSCHEMA28), “Field Service is moved to Field Service Integration app.”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Job Task"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.