---
id: object/table/5137
type: object
title: Table 5137 "Job Planning Line Archive"
summary: Table 5137 "Job Planning Line Archive" in Base Application (Microsoft.Projects.Project.Archive). 102 fields. Introduced in BC24, still in BC30, changed in BC25, 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: b4a73330aee5bcbd92120ab864e1a4e8579c1a5645b68023733a0e55be6a56fd
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Projects/Project/Archive/JobPlanningLineArchive.Table.al
    title: src/Layers/W1/BaseApp/Projects/Project/Archive/JobPlanningLineArchive.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: 5137
name: Job Planning Line Archive
caption: Project Planning Line
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:
  - "25"
  - "27"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 102
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 26
  referenced_by: 12
  pages: 1
  extended_by: 1
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 5137 "Job Planning Line Archive"

> Table 5137 "Job Planning Line Archive" in Base Application (Microsoft.Projects.Project.Archive). 102 fields. Introduced in BC24, still in BC30, changed in BC25, BC27-28.

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

## Properties

| Property | Value |
|---|---|
| Caption | Project Planning Line |
| 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 | Line No. | Integer | Specifies the planning line's entry number. | not editable |
| 2 | Job No. | Code[20] | Specifies the number of the related project. | TableRelation [Table 5135 "Job Archive"](../table/5135.md) (Job Archive); NotBlank |
| 3 | Planning Date | Date | Specifies the date of the planning line. You can use the planning date for filtering the totals of the project, for example, if you want to see the scheduled usage for a specific month of the year. |  |
| 4 | Document No. | Code[20] | Specifies a document number for the planning line. |  |
| 5 | Type | Enum "Job Planning Line Type" | Specifies the type of account to which the planning line relates. | enum [Enum 1023 "Job Planning Line Type"](../enum/1023.md) |
| 7 | No. | Code[20] | Specifies the number of the account to which the resource, item or general ledger account is posted, depending on your selection in the Type field. | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 156 "Resource"](../table/156.md), [Table 27 "Item"](../table/27.md) (if (Type = const(Resource)) Resource else if (Type = const(Item)) Item where(Blocked = const(false)) else if (Type = const("G/L Account")) "G/L Account" else if (Type = const(Text)) "Standard Text") |
| 8 | Description | Text[100] | Specifies the name of the resource, item, or G/L account to which this entry applies. You can change the description. |  |
| 9 | Quantity | Decimal | Specifies the number of units of the resource, item, or general ledger account that should be specified on the planning line. If you later change the No., the quantity you have entered remains on the line. |  |
| 11 | Direct Unit Cost (LCY) | Decimal | Specifies the cost, in the local currency, of one unit of the selected item or resource. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> |  |
| 12 | Unit Cost (LCY) | Decimal | Specifies the cost, in LCY, of one unit of the item or resource on the line. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 13 | Total Cost (LCY) | Decimal | Specifies the total cost for the planning line. The amount is in the local currency. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 14 | Unit Price (LCY) | Decimal | Specifies the price, in LCY, of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 15 | Total Price (LCY) | Decimal | Specifies the total price on the planning line. The total price is in the local currency. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 16 | Resource Group No. | Code[20] | — | TableRelation [Table 152 "Resource Group"](../table/152.md) (Resource Group); not editable |
| 17 | Unit of Measure Code | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation [Table 204 "Unit of Measure"](../table/204.md), [Table 205 "Resource Unit of Measure"](../table/205.md), [Table 5404 "Item Unit of Measure"](../table/5404.md) (if (Type = const(Item)) "Item Unit of Measure".Code where("Item No." = field("No.")) else if (Type = const(Resource)) "Resource Unit of Measure".Code where("Resource No." = field("No.")) else "Unit of Measure") |
| 18 | Qty. Rounding Precision | Decimal | — | not editable |
| 19 | Qty. Rounding Precision (Base) | Decimal | — | not editable |
| 20 | Location Code | Code[10] | Specifies a location code for an item. | TableRelation [Table 14 "Location"](../table/14.md) (Location where("Use As In-Transit" = const(false))) |
| 29 | Last Date Modified | Date | — | not editable |
| 30 | User ID | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User."User Name"; not editable; DataClassification EndUserIdentifiableInformation |
| 32 | Work Type Code | Code[10] | Specifies which work type the resource applies to. Prices are updated based on this entry. | TableRelation [Table 200 "Work Type"](../table/200.md) (Work Type) |
| 33 | Customer Price Group | Code[10] | — | TableRelation [Table 6 "Customer Price Group"](../table/6.md) (Customer Price Group) |
| 79 | Country/Region Code | Code[10] | — | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region); not editable |
| 80 | Gen. Bus. Posting Group | Code[20] | Specifies the vendor's or customer's trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. | TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md) (Gen. Business Posting Group); not editable |
| 81 | Gen. Prod. Posting Group | Code[20] | Specifies the item's product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. | TableRelation [Table 251 "Gen. Product Posting Group"](../table/251.md) (Gen. Product Posting Group); not editable |
| 83 | Document Date | Date | — |  |
| 84 | Planning Due Date | Date | — |  |
| 900 | Qty. to Assemble | Decimal | — |  |
| 901 | Qty. to Assemble (Base) | Decimal | — |  |
| 902 | Assemble to Order | Boolean | — |  |
| 903 | BOM Item No. | Code[20] | — | TableRelation [Table 27 "Item"](../table/27.md) |
| 904 | Attached to Line No. | Integer | — |  |
| 1000 | Job Task No. | Code[20] | Specifies the number of the related project task. | TableRelation [Table 5136 "Job Task Archive"](../table/5136.md) ("Job Task Archive"."Job Task No." where("Job No." = field("Job No."))); NotBlank |
| 1001 | Line Amount (LCY) | Decimal | Specifies the amount in the local currency that will be posted to the project ledger. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 1002 | Unit Cost | Decimal | Specifies the cost of one unit of the item or resource on the line. |  |
| 1003 | Total Cost | Decimal | Specifies the total cost for the planning line. The total cost is in the project currency, which comes from the Currency Code field in the Project Card. | not editable |
| 1004 | Unit Price | Decimal | Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. |  |
| 1005 | Total Price | Decimal | Specifies the total price in the project currency on the planning line. | not editable |
| 1006 | Line Amount | Decimal | Specifies the amount that will be posted to the project ledger. |  |
| 1007 | Line Discount Amount | Decimal | Specifies the discount amount that is granted for the item on the line. |  |
| 1008 | Line Discount Amount (LCY) | Decimal | — | not editable |
| 1015 | Cost Factor | Decimal | — | not editable |
| 1019 | Serial No. | Code[50] | Specifies the serial number that is applied to the posted item if the planning line was created from the posting of a project journal line. | not editable |
| 1020 | Lot No. | Code[50] | Specifies the lot number that is applied to the posted item if the planning line was created from the posting of a project journal line. | not editable |
| 1021 | Line Discount % | Decimal | Specifies the discount percentage that is granted for the item on the line. |  |
| 1022 | Line Type | Enum "Job Planning Line Line Type" | Specifies the type of planning line. | enum [Enum 1003 "Job Planning Line Line Type"](../enum/1003.md) |
| 1023 | Currency Code | Code[10] | — | TableRelation [Table 4 "Currency"](../table/4.md); not editable |
| 1024 | Currency Date | Date | Specifies the date that will be used to find the exchange rate for the currency in the Currency Date field. |  |
| 1025 | Currency Factor | Decimal | — | not editable |
| 1026 | Schedule Line | Boolean | Budget Line <small>caption</small> | not editable |
| 1027 | Contract Line | Boolean | Specifies whether this line is a billable line. | not editable |
| 1030 | Job Contract Entry No. | Integer | Specifies the entry number of the project planning line that the sales line is linked to. | not editable |
| 1035 | Invoiced Amount (LCY) | Decimal | — |  |
| 1036 | Invoiced Cost Amount (LCY) | Decimal | — |  |
| 1037 | VAT Unit Price | Decimal | — |  |
| 1038 | VAT Line Discount Amount | Decimal | — |  |
| 1039 | VAT Line Amount | Decimal | — |  |
| 1041 | VAT % | Decimal | — |  |
| 1042 | Description 2 | Text[50] | Specifies information in addition to the description. |  |
| 1043 | Job Ledger Entry No. | Integer | Project Ledger Entry No. <small>caption</small> | TableRelation [Table 169 "Job Ledger Entry"](../table/169.md) (Job Ledger Entry); not editable |
| 1048 | Status | Enum "Job Planning Line Status" | — | enum [Enum 1048 "Job Planning Line Status"](../enum/1048.md); not editable |
| 1050 | Ledger Entry Type | Enum "Job Ledger Entry Type" | Specifies the entry type of the project ledger entry associated with the planning line. | enum [Enum 1026 "Job Ledger Entry Type"](../enum/1026.md) |
| 1051 | Ledger Entry No. | Integer | Specifies the entry number of the project ledger entry associated with the project planning line. | TableRelation [Table 17 "G/L Entry"](../table/17.md), [Table 203 "Res. Ledger Entry"](../table/203.md), [Table 32 "Item Ledger Entry"](../table/32.md) (if ("Ledger Entry Type" = const(Resource)) "Res. Ledger Entry" else if ("Ledger Entry Type" = const(Item)) "Item Ledger Entry" else if ("Ledger Entry Type" = const("G/L Account")) "G/L Entry") |
| 1052 | System-Created Entry | Boolean | Specifies that an entry has been created by Business Central and is related to a project ledger entry. The check box is selected automatically. |  |
| 1053 | Usage Link | Boolean | Specifies whether the Usage Link field applies to the project planning line. When this check box is selected, usage entries are linked to the project planning line. Selecting this check box creates a link to the project planning line from places where usage has been posted, such as the project journ... |  |
| 1060 | Remaining Qty. | Decimal | Specifies the remaining quantity of the resource, item, or G/L Account that remains to complete a project. The quantity is calculated as the difference between Quantity and Qty. Posted. | not editable |
| 1061 | Remaining Qty. (Base) | Decimal | — | not editable |
| 1062 | Remaining Total Cost | Decimal | Specifies the remaining total cost for the planning line. The total cost is in the project currency, which comes from the Currency Code field in the Project Card. | not editable |
| 1063 | Remaining Total Cost (LCY) | Decimal | Specifies the remaining total cost (LCY) for the planning line. The amount is in the local currency. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 1064 | Remaining Line Amount | Decimal | Specifies the amount that will be posted to the project ledger. | not editable |
| 1065 | Remaining Line Amount (LCY) | Decimal | Specifies the amount in the local currency that will be posted to the project ledger. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 1070 | Qty. Posted | Decimal | Specifies the quantity that has been posted to the project ledger, if the Usage Link check box has been selected. | not editable |
| 1071 | Qty. to Transfer to Journal | Decimal | Specifies the quantity you want to transfer to the project journal. Its default value is calculated as quantity minus the quantity that has already been posted, if the Apply Usage Link check box has been selected. |  |
| 1072 | Posted Total Cost | Decimal | Specifies the total cost that has been posted to the project ledger, if the Usage Link check box has been selected. | not editable |
| 1073 | Posted Total Cost (LCY) | Decimal | Specifies the total cost (LCY) that has been posted to the project ledger, if the Usage Link check box has been selected. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 1074 | Posted Line Amount | Decimal | Specifies the amount that has been posted to the project ledger. This field is only filled in if the Apply Usage Link check box selected on the project card. | not editable |
| 1075 | Posted Line Amount (LCY) | Decimal | Specifies the amount in the local currency that has been posted to the project ledger. This field is only filled in if the Apply Usage Link check box selected on the project card. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 1080 | Qty. Transferred to Invoice | Decimal | — |  |
| 1081 | Qty. to Transfer to Invoice | Decimal | Specifies the quantity you want to transfer to the sales invoice or credit memo. The value in this field is calculated as Quantity - Qty. Transferred to Invoice. |  |
| 1090 | Qty. Invoiced | Decimal | — |  |
| 1091 | Qty. to Invoice | Decimal | Specifies the quantity that remains to be invoiced. It is calculated as Quantity - Qty. Invoiced. | not editable |
| 1100 | Reserved Quantity | Decimal | Specifies the quantity of the item that is reserved for the project planning line. |  |
| 1101 | Reserved Qty. (Base) | Decimal | — |  |
| 1102 | Reserve | Enum "Reserve Method" | Specifies whether or not a reservation can be made for items on the current line. The field is not applicable if the Type field is set to Resource, Cost, or G/L Account. | enum [Enum 100 "Reserve Method"](../enum/100.md) |
| 1103 | Planned | Boolean | — | not editable |
| 5047 | Version No. | Integer | — |  |
| 5402 | Variant Code | Code[10] | Specifies the variant of the item on the line. | TableRelation [Table 5401 "Item Variant"](../table/5401.md) (if (Type = const(Item)) "Item Variant".Code where("Item No." = field("No."), Blocked = const(false))) |
| 5403 | Bin Code | Code[20] | Specifies the bin where the selected item will be put away or picked in warehouse and inventory processes. If you specify a bin code in the To-Project Bin Code field on the Location page, that bin will be suggested when you choose the location. | TableRelation [Table 7354 "Bin"](../table/7354.md) (Bin.Code where("Location Code" = field("Location Code"))) |
| 5404 | Qty. per Unit of Measure | Decimal | — | not editable |
| 5410 | Quantity (Base) | Decimal | Specifies the quantity expressed in the base units of measure. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> |  |
| 5790 | Requested Delivery Date | Date | — |  |
| 5791 | Promised Delivery Date | Date | — |  |
| 5794 | Planned Delivery Date | Date | Specifies the date that is planned to deliver the item connected to the project planning line. For a resource, the planned delivery date is the date that the resource performs services with respect to the project. |  |
| 6515 | Package No. | Code[50] | — | not editable |
| 7000 | Price Calculation Method | Enum "Price Calculation Method" | Specifies the method that will be used for price calculation in the item journal line. | enum [Enum 7000 "Price Calculation Method"](../enum/7000.md) |
| 7001 | Cost Calculation Method | Enum "Price Calculation Method" | Specifies the method that will be used for cost calculation in the item journal line. | enum [Enum 7000 "Price Calculation Method"](../enum/7000.md) |
| 7300 | Pick Qty. | Decimal | — |  |
| 7301 | Qty. Picked | Decimal | Specifies the quantity of the item you have picked for the project planning line. | not editable |
| 7302 | Qty. Picked (Base) | Decimal | Specifies the base quantity of the item you have picked for the project planning line. <small>via [Page 5182 "Job Planning Archive Lines"](../page/5182.md)</small> | not editable |
| 7303 | Completely Picked | Boolean | — | not editable |
| 7304 | Pick Qty. (Base) | Decimal | — |  |
| 7305 | Qty. on Journal | Decimal | — |  |

## Keys

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

## Relations

- drill-down page [Page 5182 "Job Planning Archive Lines"](../page/5182.md)
- lookup page [Page 5182 "Job Planning Archive Lines"](../page/5182.md)
- Location Code: TableRelation [Table 14 "Location"](../table/14.md)
- No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Resource Group No.: TableRelation [Table 152 "Resource Group"](../table/152.md)
- No.: TableRelation [Table 156 "Resource"](../table/156.md) (conditional)
- Job Ledger Entry No.: TableRelation [Table 169 "Job Ledger Entry"](../table/169.md)
- Ledger Entry No.: TableRelation [Table 17 "G/L Entry"](../table/17.md) (conditional)
- Work Type Code: TableRelation [Table 200 "Work Type"](../table/200.md)
- Ledger Entry No.: TableRelation [Table 203 "Res. Ledger Entry"](../table/203.md) (conditional)
- Unit of Measure Code: TableRelation [Table 204 "Unit of Measure"](../table/204.md) (conditional)
- Unit of Measure Code: TableRelation [Table 205 "Resource Unit of Measure"](../table/205.md) (conditional)
- Gen. Bus. Posting Group: TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md)
- Gen. Prod. Posting Group: TableRelation [Table 251 "Gen. Product Posting Group"](../table/251.md)
- BOM Item No.: TableRelation [Table 27 "Item"](../table/27.md)
- No.: TableRelation [Table 27 "Item"](../table/27.md) (conditional)
- Ledger Entry No.: TableRelation [Table 32 "Item Ledger Entry"](../table/32.md) (conditional)
- Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- Job No.: TableRelation [Table 5135 "Job Archive"](../table/5135.md)
- Job Task No.: TableRelation [Table 5136 "Job Task Archive"](../table/5136.md)
- Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Unit of Measure Code: TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md) (conditional)
- Customer Price Group: TableRelation [Table 6 "Customer Price Group"](../table/6.md)
- No.: TableRelation [Table 7 "Standard Text"](../table/7.md) (conditional)
- Bin Code: TableRelation [Table 7354 "Bin"](../table/7354.md)
- Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Referenced by

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

- [Table 5136 "Job Task Archive"](../table/5136.md): Contract (Total Cost), Contract (Total Price), End Date, Remaining (Total Cost), Remaining (Total Price), Schedule (Total Cost), Schedule (Total Price), Start Date
- [Table 5135 "Job Archive"](../table/5135.md): Completely Picked, Next Invoice Date, Scheduled Res. Gr. Qty., Scheduled Res. Qty.

## Pages and codeunits on this table

- [Page 5182 "Job Planning Archive Lines"](../page/5182.md) (source table)

## Extended by

- [Table extension 6461 "Serv. Job Planning Line Arch."](../tableextension/6461.md)

## Across versions

- Present in: BC24-30
- Changed (declaration) in: BC25, 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 Planning Line Archive")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.