Table 5135 Job Archive in 24

Jonas Paprotka, Base Application 24.5.23489.36097, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Projects.Project.Archive

Fields, 96 Keys, 4 Procedures, 5 Events, 1

Versions171819202122232425 26 27 28 latest

Source29

Fields, 96

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

Keys, 4

Name	Fields	Obsolete
Key1, clustered	No., Version No.	-
Key2	Bill-to Customer No.	-
Key3	Description	-
Key4	Status	-

Procedures, 5

Name	Parameters	Returns	Access	Obsolete
DisplayMap	()		public	-
ShouldSearchForCustomerByName	(Code[20])	Boolean	public	-
ShipToNameEqualsSellToName	()	Boolean	public	-
ShipToAddressEqualsSellToAddress	()	Boolean	public	-
BillToAddressEqualsSellToAddress	()	Boolean	public	-

Events, 1

Kind	Name	Parameters	Obsolete
Integration event	OnAfterShipToAddressEqualsSellToAddress	(var Record Job Archive, var Boolean)	-