---
title: "Table 5135 Job Archive"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/5135-job-archive/
type: table
id: 5135
name: "Job Archive"
app: "Base Application"
namespace: Microsoft.Projects.Project.Archive
versions: "24-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/5135-job-archive/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 5135 Job Archive

Jonas Paprotka, https://jonas-paprotka.de/ref/table/5135-job-archive/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Projects.Project.Archive |
| Versions | 24-28 |
| Source file | Projects/Project/Archive/JobArchive.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | No. | Code[20] | 24-28 | - | - |
| 2 | Search Description | Code[100] | 24-28 | - | - |
| 3 | Description | Text[100] | 24-28 | - | - |
| 4 | Description 2 | Text[50] | 24-28 | - | - |
| 5 | Bill-to Customer No. | Code[20] | 24-28 | - | - |
| 12 | Creation Date | Date | 24-28 | - | - |
| 13 | Starting Date | Date | 24-28 | - | - |
| 14 | Ending Date | Date | 24-28 | - | - |
| 19 | Status | Enum Job Status | 24-28 | - | - |
| 20 | Person Responsible | Code[20] | 24-28 | - | - |
| 21 | Global Dimension 1 Code | Code[20] | 24-28 | - | - |
| 22 | Global Dimension 2 Code | Code[20] | 24-28 | - | - |
| 23 | Job Posting Group | Code[20] | 24-28 | - | - |
| 24 | Blocked | Enum Job Blocked | 24-28 | - | - |
| 29 | Last Date Modified | Date | 24-28 | - | - |
| 30 | Comment | Boolean | 24-28 | - | - |
| 31 | Customer Disc. Group | Code[20] | 24-28 | - | - |
| 32 | Customer Price Group | Code[10] | 24-28 | - | - |
| 35 | Location Code | Code[10] | 24-28 | - | - |
| 36 | Bin Code | Code[20] | 24-28 | - | - |
| 41 | Language Code | Code[10] | 24-28 | - | - |
| 49 | Scheduled Res. Qty. | Decimal | 24-28 | - | - |
| 50 | Resource Filter | Code[20] | 24-28 | - | - |
| 51 | Posting Date Filter | Date | 24-28 | - | - |
| 55 | Resource Gr. Filter | Code[20] | 24-28 | - | - |
| 56 | Scheduled Res. Gr. Qty. | Decimal | 24-28 | - | - |
| 58 | Bill-to Name | Text[100] | 24-28 | - | - |
| 59 | Bill-to Address | Text[100] | 24-28 | - | - |
| 60 | Bill-to Address 2 | Text[50] | 24-28 | - | - |
| 61 | Bill-to City | Text[30] | 24-28 | - | - |
| 63 | Bill-to County | Text[30] | 24-28 | - | - |
| 64 | Bill-to Post Code | Code[20] | 24-28 | - | - |
| 66 | No. Series | Code[20] | 24-28 | - | - |
| 67 | Bill-to Country/Region Code | Code[10] | 24-28 | - | - |
| 68 | Bill-to Name 2 | Text[50] | 24-28 | - | - |
| 80 | Task Billing Method | Enum Task Billing Method | 24-28 | - | - |
| 117 | Reserve | Enum Reserve Method | 24-28 | - | - |
| 140 | Image | Media | 24-28 | - | - |
| 210 | Ship-to Phone No. | Text[30] | 25-28 | - | - |
| 1000 | WIP Method | Code[20] | 24-28 | - | - |
| 1001 | Currency Code | Code[10] | 24-28 | - | - |
| 1002 | Bill-to Contact No. | Code[20] | 24-28 | - | - |
| 1003 | Bill-to Contact | Text[100] | 24-28 | - | - |
| 1004 | Planning Date Filter | Date | 24-28 | - | - |
| 1008 | WIP Posting Date | Date | 24-28 | - | - |
| 1011 | Invoice Currency Code | Code[10] | 24-28 | - | - |
| 1012 | Exch. Calculation (Cost) | Option | 24-28 | - | - |
| 1013 | Exch. Calculation (Price) | Option | 24-28 | - | - |
| 1014 | Allow Schedule/Contract Lines | Boolean | 24-28 | - | - |
| 1015 | Complete | Boolean | 24-28 | - | - |
| 1024 | Next Invoice Date | Date | 24-28 | - | - |
| 1025 | Apply Usage Link | Boolean | 24-28 | - | - |
| 1027 | WIP Posting Method | Option | 24-28 | - | - |
| 1030 | Calc. Recog. Sales Amount | Decimal | 24-28 | - | - |
| 1031 | Calc. Recog. Costs Amount | Decimal | 24-28 | - | - |
| 1032 | Calc. Recog. Sales G/L Amount | Decimal | 24-28 | - | - |
| 1033 | Calc. Recog. Costs G/L Amount | Decimal | 24-28 | - | - |
| 1035 | Over Budget | Boolean | 24-28 | - | - |
| 1036 | Project Manager | Code[50] | 24-28 | - | - |
| 2000 | Sell-to Customer No. | Code[20] | 24-28 | - | - |
| 2001 | Sell-to Customer Name | Text[100] | 24-28 | - | - |
| 2002 | Sell-to Customer Name 2 | Text[50] | 24-28 | - | - |
| 2003 | Sell-to Address | Text[100] | 24-28 | - | - |
| 2004 | Sell-to Address 2 | Text[50] | 24-28 | - | - |
| 2005 | Sell-to City | Text[30] | 24-28 | - | - |
| 2006 | Sell-to Contact | Text[100] | 24-28 | - | - |
| 2007 | Sell-to Post Code | Code[20] | 24-28 | - | - |
| 2008 | Sell-to County | Text[30] | 24-28 | - | - |
| 2009 | Sell-to Country/Region Code | Code[10] | 24-28 | - | - |
| 2010 | Sell-to Phone No. | Text[30] | 24-28 | - | - |
| 2011 | Sell-to E-Mail | Text[80] | 24-28 | - | - |
| 2012 | Sell-to Contact No. | Code[20] | 24-28 | - | - |
| 3000 | Ship-to Code | Code[10] | 24-28 | - | - |
| 3001 | Ship-to Name | Text[100] | 24-28 | - | - |
| 3002 | Ship-to Name 2 | Text[50] | 24-28 | - | - |
| 3003 | Ship-to Address | Text[100] | 24-28 | - | - |
| 3004 | Ship-to Address 2 | Text[50] | 24-28 | - | - |
| 3005 | Ship-to City | Text[30] | 24-28 | - | - |
| 3006 | Ship-to Contact | Text[100] | 24-28 | - | - |
| 3007 | Ship-to Post Code | Code[20] | 24-28 | - | - |
| 3008 | Ship-to County | Text[30] | 24-28 | - | - |
| 3009 | Ship-to Country/Region Code | Code[10] | 24-28 | - | - |
| 3997 | No. of Archived Versions | Integer | 24-28 | - | - |
| 3998 | Source Doc. Exists | Boolean | 24-28 | - | - |
| 3999 | Last Archived Date | DateTime | 24-28 | - | - |
| 4000 | External Document No. | Code[35] | 24-28 | - | - |
| 4001 | Payment Method Code | Code[10] | 24-28 | - | - |
| 4002 | Payment Terms Code | Code[10] | 24-28 | - | - |
| 4003 | Your Reference | Text[35] | 24-28 | - | - |
| 5043 | Interaction Exist | Boolean | 24-28 | - | - |
| 5044 | Time Archived | Time | 24-28 | - | - |
| 5045 | Date Archived | Date | 24-28 | - | - |
| 5046 | Archived By | Code[50] | 24-28 | - | - |
| 5047 | Version No. | Integer | 24-28 | - | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | 24-28 | - | - |
| 7001 | Cost Calculation Method | Enum Price Calculation Method | 24-28 | - | - |
| 7300 | Completely Picked | Boolean | 24-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | No., Version No. | 24-28 |
| Key2 | Bill-to Customer No. | 24-28 |
| Key3 | Description | 24-28 |
| Key4 | Status | 24-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| DisplayMap | () | - | public | 24-28 | - | - |
| ShouldSearchForCustomerByName | (Code[20]) | Boolean | public | 24-28 | - | - |
| ShipToNameEqualsSellToName | () | Boolean | public | 24-28 | - | - |
| ShipToAddressEqualsSellToAddress | () | Boolean | public | 24-28 | - | - |
| BillToAddressEqualsSellToAddress | () | Boolean | public | 24-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterShipToAddressEqualsSellToAddress | (var Record Job Archive, var Boolean) | 24-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.