Table 5135 "Job Archive"

Base Application · Microsoft.Projects.Project.Archive · captioned “Project Archive” · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Project Archive
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	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.
2	Search Description Δ BC28	Code[100]	Specifies the additional name for the project. The field is used for searching purposes.
3	Description Δ BC28	Text[100]	Specifies a short description of the project.
4	Description 2	Text[50]	—
5	Bill-to Customer No. Δ BC28	Code[20]	Specifies the number of the customer who pays for the project.	TableRelation Table 18 “Customer”
12	Creation Date Δ BC28	Date	Specifies the date on which you set up the project.	not editable
13	Starting Date Δ BC28	Date	Specifies the date on which the project actually starts.
14	Ending Date Δ BC28	Date	Specifies the date on which the project is expected to be completed.
19	Status Δ BC28	Enum “Job Status”	Specifies a status for the current project. You can change the status for the project as it progresses. Final calculations can be made on completed projects.	enum Enum 1619 “Job Status”
20	Person Responsible Δ BC28	Code[20]	Specifies the person at your company who is responsible for the project.	TableRelation Table 156 “Resource” (Resource where(Type = const(Person)))
21	Global Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
22	Global Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
23	Job Posting Group Δ BC28	Code[20]	Specifies the posting group that links transactions made for the project with the appropriate general ledger accounts according to the general posting setup.	TableRelation Table 208 “Job Posting Group” (Job Posting Group)
24	Blocked Δ BC28	Enum “Job Blocked”	Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.	enum Enum 1624 “Job Blocked”
29	Last Date Modified Δ BC28	Date	Specifies when the project card was last modified.	not editable
30	Comment	Boolean	—	FlowField: exist(“Comment Line Archive” where(“Table Name” = const(Job), “No.” = field(“No.”), “Version No.” = field(“Version No.”))); not editable
31	Customer Disc. Group	Code[20]	—	TableRelation Table 340 “Customer Discount Group” (Customer Discount Group)
32	Customer Price Group	Code[10]	—	TableRelation Table 6 “Customer Price Group” (Customer Price Group)
35	Location Code Δ BC28	Code[10]	Specifies the location code of the project.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
36	Bin Code Δ BC28	Code[20]	Specifies a bin code for specific location of the project.	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
41	Language Code	Code[10]	—	TableRelation Table 8 “Language”
49	Scheduled Res. Qty. Δ BC28	Decimal	—	FlowField: sum(“Job Planning Line Archive”.“Quantity (Base)” where(“Job No.” = field(“No.”), “Schedule Line” = const(true), Type = const(Resource), “No.” = field(“Resource Filter”), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
50	Resource Filter	Code[20]	—	TableRelation Table 156 “Resource”; FlowFilter
51	Posting Date Filter	Date	—	FlowFilter
55	Resource Gr. Filter	Code[20]	—	TableRelation Table 152 “Resource Group” (Resource Group); FlowFilter
56	Scheduled Res. Gr. Qty. Δ BC28	Decimal	—	FlowField: sum(“Job Planning Line Archive”.“Quantity (Base)” where(“Job No.” = field(“No.”), “Schedule Line” = const(true), Type = const(Resource), “Resource Group No.” = field(“Resource Gr. Filter”), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
58	Bill-to Name Δ BC28	Text[100]	Specifies the name of the customer who pays for the project.	TableRelation Customer.Name
59	Bill-to Address Δ BC28	Text[100]	Specifies the address of the customer to whom you will send the invoice.
60	Bill-to Address 2 Δ BC28	Text[50]	Specifies an additional line of the address.
61	Bill-to City Δ 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”)))
63	Bill-to County Δ BC28	Text[30]	Specifies the county code of the customer’s billing address.
64	Bill-to Post Code Δ 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”)))
66	No. Series	Code[20]	—	TableRelation Table 308 “No. Series” (No. Series); not editable
67	Bill-to Country/Region Code Δ BC28	Code[10]	Specifies the country/region code of the customer’s billing address.	TableRelation Table 9 “Country/Region” (Country/Region)
68	Bill-to Name 2 Δ BC27	Text[50]	Specifies an additional part of the name of the customer who pays for the project.
80	Task Billing Method	Enum “Task Billing Method”	—	enum Enum 1004 “Task Billing Method”
117	Reserve	Enum “Reserve Method”	—	enum Enum 100 “Reserve Method”
140	Image	Media	—
210	Ship-to Phone No. + BC25 Δ BC28	Text[30]	Specifies the telephone number of the company’s shipping address.
1000	WIP Method Δ BC28	Code[20]	Specifies the method that is used to calculate the value of work in process for the project.	TableRelation Table 1006 “Job WIP Method” (“Job WIP Method”.Code where(Valid = const(true)))
1001	Currency Code Δ BC28	Code[10]	Specifies the currency code for the project. By default, the currency code is empty. If you enter a foreign currency code, it results in the project being planned and invoiced in that currency.	TableRelation Table 4 “Currency”
1002	Bill-to Contact No. Δ BC28	Code[20]	Specifies the number of the contact person at the customer’s billing address.
1003	Bill-to Contact Δ BC28	Text[100]	Specifies the name of the contact person at the customer who pays for the project.
1004	Planning Date Filter	Date	—	FlowFilter
1008	WIP Posting Date	Date	—	not editable
1011	Invoice Currency Code Δ 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”
1012	Exch. Calculation (Cost)	Option	Specifies how project costs are calculated if you change the Currency Date or the Currency Code fields on a project planning Line or run the Change Project Planning Line Dates batch project. Fixed LCY option: The project costs in the local currency are fixed. Any change in the currency exchange rate… via Page 5177 “Job Archive Card”	OptionCaption: Fixed FCY,Fixed LCY
1013	Exch. Calculation (Price)	Option	Specifies how project sales prices are calculated if you change the Currency Date or the Currency Code fields on a project planning Line or run the Change Project Planning Line Dates batch project. Fixed LCY option: The project prices in the local currency are fixed. Any change in the currency excha… via Page 5177 “Job Archive Card”	OptionCaption: Fixed FCY,Fixed LCY
1014	Allow Schedule/Contract Lines Δ BC28	Boolean	Specifies if you can add planning lines of both type Budget and type Billable to the project.
1015	Complete	Boolean	—
1024	Next Invoice Date Δ BC28	Date	Specifies the next invoice date for the project.	FlowField: min(“Job Planning Line Archive”.“Planning Date” where(“Job No.” = field(“No.”), “Version No.” = field(“Version No.”), “Contract Line” = const(true), “Qty. to Invoice” = filter(<> 0)))
1025	Apply Usage Link Δ BC28	Boolean	Specifies whether usage entries, from the project journal or purchase line, for example, are linked to project planning lines. Select this check box if you want to be able to track the quantities and amounts of the remaining work needed to complete a project and to create a relationship between dema…
1027	WIP Posting Method Δ BC28	Option	Specifies how WIP posting is performed. Per Project: The total WIP costs and the sales value is used to calculate WIP. Per Project Ledger Entry: The accumulated values of WIP costs and sales are used to calculate WIP.	OptionCaption: Per Project,Per Project Ledger Entry
1030	Calc. Recog. Sales Amount Δ BC28	Decimal	—	FlowField: sum(“Job Task Archive”.“Recognized Sales Amount” where(“Job No.” = field(“No.”), “Version No.” = field(“Version No.”))); not editable
1031	Calc. Recog. Costs Amount Δ BC28	Decimal	—	FlowField: sum(“Job Task Archive”.“Recognized Costs Amount” where(“Job No.” = field(“No.”), “Version No.” = field(“Version No.”))); not editable
1032	Calc. Recog. Sales G/L Amount Δ BC28	Decimal	—	FlowField: sum(“Job Task Archive”.“Recognized Sales G/L Amount” where(“Job No.” = field(“No.”), “Version No.” = field(“Version No.”))); not editable
1033	Calc. Recog. Costs G/L Amount Δ BC28	Decimal	—	FlowField: sum(“Job Task Archive”.“Recognized Costs G/L Amount” where(“Job No.” = field(“No.”), “Version No.” = field(“Version No.”))); not editable
1035	Over Budget	Boolean	—
1036	Project Manager Δ BC28	Code[50]	Specifies the person who is assigned to manage the project.	TableRelation Table 91 “User Setup” (User Setup)
2000	Sell-to Customer No. Δ BC28	Code[20]	Specifies the number of the customer who will receive the products and be billed by default.	TableRelation Table 18 “Customer”
2001	Sell-to Customer Name Δ BC28	Text[100]	Specifies the name of the customer who will receive the products and be billed by default.	TableRelation Customer.Name
2002	Sell-to Customer Name 2 Δ BC27	Text[50]	Specifies an additional part of the name of the customer who will receive the products and be billed by default.
2003	Sell-to Address Δ BC28	Text[100]	Specifies the address where the customer is located.
2004	Sell-to Address 2 Δ BC28	Text[50]	Specifies additional address information.
2005	Sell-to City Δ 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”)))
2006	Sell-to Contact Δ BC28	Text[100]	Specifies the name of the person to contact at the customer.
2007	Sell-to Post Code Δ 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”)))
2008	Sell-to County Δ BC28	Text[30]	Specifies the state, province or county of the address.
2009	Sell-to Country/Region Code Δ BC28	Code[10]	Specifies the country or region of the address.	TableRelation Table 9 “Country/Region” (Country/Region)
2010	Sell-to Phone No.	Text[30]	—
2011	Sell-to E-Mail	Text[80]	Email caption
2012	Sell-to Contact No. Δ BC28	Code[20]	Specifies the number of the contact person that the sales document will be sent to.	TableRelation Table 5050 “Contact”
3000	Ship-to Code Δ 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.”)))
3001	Ship-to Name Δ BC28	Text[100]	Specifies the name that products on the sales document will be shipped to.
3002	Ship-to Name 2 Δ BC28	Text[50]	Specifies an additional part of the name that products on the sales document will be shipped to.
3003	Ship-to Address Δ BC28	Text[100]	Specifies the address that products on the sales document will be shipped to.
3004	Ship-to Address 2 Δ BC28	Text[50]	Specifies additional address information.
3005	Ship-to City Δ 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”)))
3006	Ship-to Contact Δ BC28	Text[100]	Specifies the name of the contact person at the address that products on the sales document will be shipped to.
3007	Ship-to Post Code Δ 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”)))
3008	Ship-to County Δ BC28	Text[30]	Specifies the state, province or county of the address.
3009	Ship-to Country/Region Code Δ BC28	Code[10]	Specifies the customer’s country/region.	TableRelation Table 9 “Country/Region” (Country/Region)
3997	No. of Archived Versions	Integer	—	FlowField: max(“Job Archive”.“Version No.” where(“No.” = field(“No.”))); not editable
3998	Source Doc. Exists	Boolean	—	FlowField: exist(Job where(“No.” = field(“No.”))); not editable
3999	Last Archived Date	DateTime	—	FlowField: max(“Job Archive”.SystemCreatedAt where(“No.” = field(“No.”))); not editable
4000	External Document No. Δ BC28	Code[35]	Specifies a document number that refers to the customer’s or vendor’s numbering system.
4001	Payment Method Code	Code[10]	Specifies how to make payment, such as with bank transfer, cash, or check. via Page 5177 “Job Archive Card”	TableRelation Table 289 “Payment Method” (Payment Method)
4002	Payment Terms Code	Code[10]	Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. via Page 5177 “Job Archive Card”	TableRelation Table 3 “Payment Terms” (Payment Terms)
4003	Your Reference Δ BC28	Text[35]	Specifies the customer’s reference. The content will be printed on sales documents.
5043	Interaction Exist Δ BC28	Boolean	Specifies that the archived document is linked to an interaction log entry.
5044	Time Archived Δ BC28	Time	Specifies what time the document was archived.
5045	Date Archived Δ BC28	Date	Specifies the date when the document was archived.
5046	Archived By Δ BC28	Code[50]	Specifies the user ID of the person who archived this document.	TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
5047	Version No. Δ BC28	Integer	Specifies the version number of the archived document.
7000	Price Calculation Method Δ BC28	Enum “Price Calculation Method”	Specifies the default method of the unit price calculation.	enum Enum 7000 “Price Calculation Method”
7001	Cost Calculation Method Δ BC28	Enum “Price Calculation Method”	Specifies the default method of the unit cost calculation.	enum Enum 7000 “Price Calculation Method”
7300	Completely Picked	Boolean	—	FlowField: min(“Job Planning Line Archive”.“Completely Picked” where(“Job No.” = field(“No.”)))

Keys

Key1: No., Version No. (clustered)
Key2: Bill-to Customer No.
Key3: Description
Key4: Status

Events published

OnAfterShipToAddressEqualsSellToAddress(var JobArchive: Record "Job Archive"; var Result: Boolean) (integration)

Procedures

DisplayMap()
ShouldSearchForCustomerByName(CustomerNo: Code[20]): Boolean
ShipToNameEqualsSellToName(): Boolean
ShipToAddressEqualsSellToAddress(): Boolean
BillToAddressEqualsSellToAddress(): Boolean

Triggers

OnDelete

Relations

drill-down page Page 5176 “Job Archive List”
lookup page Page 5176 “Job Archive List”
WIP Method: TableRelation Table 1006 “Job WIP Method”
Location Code: TableRelation Table 14 “Location”
Resource Gr. Filter: TableRelation Table 152 “Resource Group”
Person Responsible: TableRelation Table 156 “Resource”
Resource Filter: TableRelation Table 156 “Resource”
Source Doc. Exists: CalcFormula Table 167 “Job”
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”
No. Series: TableRelation Table 308 “No. Series”
Customer Disc. Group: TableRelation Table 340 “Customer Discount Group”
Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Currency Code: TableRelation Table 4 “Currency”
Invoice Currency Code: TableRelation Table 4 “Currency”
Sell-to Contact No.: TableRelation Table 5050 “Contact”
Last Archived Date: CalcFormula Table 5135 “Job Archive”
No. of Archived Versions: CalcFormula Table 5135 “Job Archive”
Calc. Recog. Costs Amount: CalcFormula Table 5136 “Job Task Archive”
Calc. Recog. Costs G/L Amount: CalcFormula Table 5136 “Job Task Archive”
Calc. Recog. Sales Amount: CalcFormula Table 5136 “Job Task Archive”
Calc. Recog. Sales G/L Amount: CalcFormula Table 5136 “Job Task Archive”
Completely Picked: CalcFormula Table 5137 “Job Planning Line Archive”
Next Invoice Date: CalcFormula Table 5137 “Job Planning Line Archive”
Scheduled Res. Gr. Qty.: CalcFormula Table 5137 “Job Planning Line Archive”
Scheduled Res. Qty.: CalcFormula Table 5137 “Job Planning Line Archive”
Comment: CalcFormula Table 5138 “Comment Line Archive”
Customer Price Group: TableRelation Table 6 “Customer Price Group”
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”
Project Manager: TableRelation Table 91 “User Setup”

Referenced by

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

Table 5135 “Job Archive”: Last Archived Date, No. of Archived Versions
Table 167 “Job”: No. of Archived Versions
Table 5136 “Job Task Archive”: Job No.
Table 5137 “Job Planning Line Archive”: Job No.
Table 5140 “Job Assigned Resource Archive”: Job No.

Pages and codeunits on this table

Page 5176 “Job Archive List” (source table)
Page 5177 “Job Archive Card” (source table)

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 802 “Online Map Management” (1 call: DisplayMap → MakeSelectionIfMapEnabled)

Recent changes

2026-07-14 #9315 [Projects] Add Assigned Resources to projects and project tasks (main, BC30, feature)

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

Across versions

Neighbourhood 31 connected objects and pages