---
id: object/table/5136
type: object
title: Table 5136 "Job Task Archive"
summary: Table 5136 "Job Task Archive" in Base Application (Microsoft.Projects.Project.Archive). 75 fields. Introduced in BC24, still in BC30, changed in BC27-28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: "24"
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 7bc5229f000cfe631170fc953d530ad01e75a9e572002d7b8f2f597d086ab17a
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Projects/Project/Archive/JobTaskArchive.Table.al
    title: src/Layers/W1/BaseApp/Projects/Project/Archive/JobTaskArchive.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 5136
name: Job Task Archive
caption: Project Task
namespace: Microsoft.Projects.Project.Archive
app: Base Application
extends: null
first_version: "24"
last_version: "30"
present_in:
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "27"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 75
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 35
  referenced_by: 5
  pages: 2
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 5136 "Job Task Archive"

> Table 5136 "Job Task Archive" in Base Application (Microsoft.Projects.Project.Archive). 75 fields. Introduced in BC24, still in BC30, changed in BC27-28.

Base Application · Microsoft.Projects.Project.Archive · captioned "Project Task" · BC24-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Projects/Project/Archive/JobTaskArchive.Table.al) · facts from BC29

## 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. | Code[20] | Specifies the number of the related project. | TableRelation [Table 5135 "Job Archive"](../table/5135.md) (Job Archive); not editable; NotBlank |
| 2 | Job Task No. | Code[20] | Specifies the number of the related project task. | NotBlank |
| 3 | 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. |  |
| 4 | Job Task Type | 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"](../enum/1001.md) |
| 6 | WIP-Total | 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 | Code[20] | Specifies the project posting group of the task. | TableRelation [Table 208 "Job Posting Group"](../table/208.md) (Job Posting Group) |
| 9 | 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. | TableRelation [Table 1006 "Job WIP Method"](../table/1006.md) ("Job WIP Method".Code where(Valid = const(true))) |
| 10 | Schedule (Total Cost) | Decimal | Specifies, in the local currency, the total budgeted cost for the project task during the time period in the Planning Date Filter field. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> | FlowField: sum("Job Planning Line Archive"."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"), "Version No." = field("Version No."))); not editable |
| 11 | Schedule (Total Price) | Decimal | Specifies, in local currency, the total budgeted price for the project task during the time period in the Planning Date Filter field. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> | FlowField: sum("Job Planning Line Archive"."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"), "Version No." = field("Version No."))); not editable |
| 12 | Usage (Total Cost) | 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. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> |  |
| 13 | Usage (Total Price) | 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. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> |  |
| 14 | Contract (Total Cost) | Decimal | Specifies, in local currency, the total billable cost for the project task during the time period in the Planning Date Filter field. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> | FlowField: sum("Job Planning Line Archive"."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"), "Version No." = field("Version No."))); not editable |
| 15 | Contract (Total Price) | Decimal | Specifies, in the local currency, the total billable price for the project task during the time period in the Planning Date Filter field. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> | FlowField: sum("Job Planning Line Archive"."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"), "Version No." = field("Version No."))); not editable |
| 16 | Contract (Invoiced Price) | 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. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> |  |
| 17 | Contract (Invoiced Cost) | 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. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> |  |
| 19 | Posting Date Filter | Date | — | FlowFilter |
| 20 | Planning Date Filter | Date | — | FlowFilter |
| 21 | Totaling | Text[250] | Specifies an interval or a list of project task numbers. | TableRelation [Table 1001 "Job Task"](../table/1001.md) ("Job Task"."Job Task No." where("Job No." = field("Job No."))) |
| 22 | New Page | Boolean | — |  |
| 23 | No. of Blank Lines | Integer | — |  |
| 24 | Indentation | Integer | — |  |
| 30 | Location Code | Code[10] | Specifies the location code of the task. | TableRelation [Table 14 "Location"](../table/14.md) (Location where("Use As In-Transit" = const(false))) |
| 31 | Bin Code | Code[20] | Specifies a bin code for specific location of the task. | TableRelation [Table 7354 "Bin"](../table/7354.md) (Bin.Code where("Location Code" = field("Location Code"))) |
| 34 | Recognized Sales Amount | Decimal | — | not editable |
| 37 | Recognized Costs Amount | Decimal | — | not editable |
| 41 | Language Code | Code[10] | — | TableRelation [Table 8 "Language"](../table/8.md) |
| 56 | Recognized Sales G/L Amount | Decimal | — | not editable |
| 57 | Recognized Costs G/L Amount | Decimal | — | not editable |
| 60 | 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. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false))) |
| 61 | 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. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false))) |
| 62 | Outstanding Orders | Decimal | — |  |
| 63 | Amt. Rcd. Not Invoiced | Decimal | — |  |
| 64 | Remaining (Total Cost) | 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. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> | FlowField: sum("Job Planning Line Archive"."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"), "Version No." = field("Version No."))); not editable |
| 65 | Remaining (Total Price) | 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. <small>via [Page 5178 "Job Task Archive Lines"](../page/5178.md)</small> | FlowField: sum("Job Planning Line Archive"."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"), "Version No." = field("Version No."))); not editable |
| 66 | Start Date | 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 Archive"."Planning Date" where("Job No." = field("Job No."), "Job Task No." = field("Job Task No."), "Version No." = field("Version No."))); not editable |
| 67 | End Date | 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 Archive"."Planning Date" where("Job No." = field("Job No."), "Job Task No." = field("Job Task No."), "Version No." = field("Version No."))); not editable |
| 70 | Bill-to Customer No. | Code[20] | Specifies the number of the customer who pays for the project task. | TableRelation [Table 18 "Customer"](../table/18.md) |
| 71 | Bill-to Name | Text[100] | — | TableRelation Customer.Name |
| 72 | Bill-to Address | Text[100] | — |  |
| 73 | Bill-to Address 2 | Text[50] | — |  |
| 74 | Bill-to City | Text[30] | — | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Text[30] | — |  |
| 76 | Bill-to Post Code | Code[20] | — | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Code[10] | — | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 78 | Bill-to Name 2 | Text[50] | Specifies an additional part of the name of the customer who pays for the project. |  |
| 79 | Bill-to Contact No. | Code[20] | — |  |
| 80 | Bill-to Contact | Text[100] | — |  |
| 90 | 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. | TableRelation [Table 18 "Customer"](../table/18.md) |
| 91 | Sell-to Customer Name | Text[100] | — | TableRelation Customer.Name |
| 92 | 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. |  |
| 93 | Sell-to Address | Text[100] | — |  |
| 94 | Sell-to Address 2 | Text[50] | — |  |
| 95 | Sell-to City | Text[30] | — | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Text[100] | — |  |
| 97 | Sell-to Post Code | Code[20] | — | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Text[30] | — |  |
| 99 | Sell-to Country/Region Code | Code[10] | — | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 100 | Sell-to Contact No. | Code[20] | — | TableRelation [Table 5050 "Contact"](../table/5050.md) |
| 110 | Ship-to Code | Code[10] | — | TableRelation [Table 222 "Ship-to Address"](../table/222.md) ("Ship-to Address".Code where("Customer No." = field("Sell-to Customer No."))) |
| 111 | Ship-to Name | Text[100] | — |  |
| 112 | Ship-to Name 2 | Text[50] | — |  |
| 113 | Ship-to Address | Text[100] | — |  |
| 114 | Ship-to Address 2 | Text[50] | — |  |
| 115 | Ship-to City | Text[30] | — | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Text[100] | — |  |
| 117 | Ship-to Post Code | Code[20] | — | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Text[30] | — |  |
| 119 | Ship-to Country/Region Code | Code[10] | — | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 130 | External Document No. | Code[35] | Specifies a document number that refers to the customer's or vendor's numbering system. <small>via [Page 5181 "Job Task Archive Lines Subform"](../page/5181.md)</small> |  |
| 131 | Payment Method Code | Code[10] | — | TableRelation [Table 289 "Payment Method"](../table/289.md) (Payment Method) |
| 132 | Payment Terms Code | Code[10] | — | TableRelation [Table 3 "Payment Terms"](../table/3.md) (Payment Terms) |
| 133 | Your Reference | Text[35] | Specifies the customer's reference. The content will be printed on sales documents. <small>via [Page 5181 "Job Task Archive Lines Subform"](../page/5181.md)</small> |  |
| 134 | Price Calculation Method | Enum "Price Calculation Method" | — | enum [Enum 7000 "Price Calculation Method"](../enum/7000.md) |
| 140 | Invoice Currency Code | Code[10] | — | TableRelation [Table 4 "Currency"](../table/4.md) |
| 5047 | Version No. | Integer | — |  |

## Keys

- Key1: Job No., Job Task No., Version No. (clustered)
- Key2: Job Task No.

## Triggers

OnDelete

## Relations

- drill-down page [Page 5178 "Job Task Archive Lines"](../page/5178.md)
- lookup page [Page 5178 "Job Task Archive Lines"](../page/5178.md)
- Totaling: TableRelation [Table 1001 "Job Task"](../table/1001.md)
- WIP Method: TableRelation [Table 1006 "Job WIP Method"](../table/1006.md)
- Location Code: TableRelation [Table 14 "Location"](../table/14.md)
- Bill-to Customer No.: TableRelation [Table 18 "Customer"](../table/18.md)
- Sell-to Customer No.: TableRelation [Table 18 "Customer"](../table/18.md)
- Job Posting Group: TableRelation [Table 208 "Job Posting Group"](../table/208.md)
- Ship-to Code: TableRelation [Table 222 "Ship-to Address"](../table/222.md)
- Bill-to City: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Bill-to Post Code: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Sell-to City: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Sell-to Post Code: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Ship-to City: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Ship-to Post Code: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Payment Method Code: TableRelation [Table 289 "Payment Method"](../table/289.md)
- Payment Terms Code: TableRelation [Table 3 "Payment Terms"](../table/3.md)
- Global Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Invoice Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- Sell-to Contact No.: TableRelation [Table 5050 "Contact"](../table/5050.md)
- Job No.: TableRelation [Table 5135 "Job Archive"](../table/5135.md)
- Contract (Total Cost): CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- Contract (Total Price): CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- End Date: CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- Remaining (Total Cost): CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- Remaining (Total Price): CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- Schedule (Total Cost): CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- Schedule (Total Price): CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- Start Date: CalcFormula [Table 5137 "Job Planning Line Archive"](../table/5137.md)
- Bin Code: TableRelation [Table 7354 "Bin"](../table/7354.md)
- Language Code: TableRelation [Table 8 "Language"](../table/8.md)
- Bill-to Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)
- Sell-to Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)
- Ship-to Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Referenced by

5 fields in 2 objects relate to this table (TableRelation or CalcFormula).

- [Table 5135 "Job Archive"](../table/5135.md): Calc. Recog. Costs Amount, Calc. Recog. Costs G/L Amount, Calc. Recog. Sales Amount, Calc. Recog. Sales G/L Amount
- [Table 5137 "Job Planning Line Archive"](../table/5137.md): Job Task No.

## Pages and codeunits on this table

- [Page 5178 "Job Task Archive Lines"](../page/5178.md) (source table)
- [Page 5181 "Job Task Archive Lines Subform"](../page/5181.md) (source table)

## Across versions

- Present in: BC24-30
- Changed (declaration) in: BC27-28

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). 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 Archive")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.