Objects/Tables/Table 5136 Job Task Archive

Table 5136 Job Task Archive in 24

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

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

Versions171819202122232425 26 27 28 latest

Source29

Fields, 75

Id	Name	Type	Obsolete
1	Job No.	Code[20]	-
2	Job Task No.	Code[20]	-
3	Description	Text[100]	-
4	Job Task Type	Enum Job Task Type	-
6	WIP-Total	Option	-
7	Job Posting Group	Code[20]	-
9	WIP Method	Code[20]	-
10	Schedule (Total Cost)	Decimal	-
11	Schedule (Total Price)	Decimal	-
12	Usage (Total Cost)	Decimal	-
13	Usage (Total Price)	Decimal	-
14	Contract (Total Cost)	Decimal	-
15	Contract (Total Price)	Decimal	-
16	Contract (Invoiced Price)	Decimal	-
17	Contract (Invoiced Cost)	Decimal	-
19	Posting Date Filter	Date	-
20	Planning Date Filter	Date	-
21	Totaling	Text[250]	-
22	New Page	Boolean	-
23	No. of Blank Lines	Integer	-
24	Indentation	Integer	-
30	Location Code	Code[10]	-
31	Bin Code	Code[20]	-
34	Recognized Sales Amount	Decimal	-
37	Recognized Costs Amount	Decimal	-
41	Language Code	Code[10]	-
56	Recognized Sales G/L Amount	Decimal	-
57	Recognized Costs G/L Amount	Decimal	-
60	Global Dimension 1 Code	Code[20]	-
61	Global Dimension 2 Code	Code[20]	-
62	Outstanding Orders	Decimal	-
63	Amt. Rcd. Not Invoiced	Decimal	-
64	Remaining (Total Cost)	Decimal	-
65	Remaining (Total Price)	Decimal	-
66	Start Date	Date	-
67	End Date	Date	-
70	Bill-to Customer No.	Code[20]	-
71	Bill-to Name	Text[100]	-
72	Bill-to Address	Text[100]	-
73	Bill-to Address 2	Text[50]	-
74	Bill-to City	Text[30]	-
75	Bill-to County	Text[30]	-
76	Bill-to Post Code	Code[20]	-
77	Bill-to Country/Region Code	Code[10]	-
78	Bill-to Name 2	Text[50]	-
79	Bill-to Contact No.	Code[20]	-
80	Bill-to Contact	Text[100]	-
90	Sell-to Customer No.	Code[20]	-
91	Sell-to Customer Name	Text[100]	-
92	Sell-to Customer Name 2	Text[50]	-
93	Sell-to Address	Text[100]	-
94	Sell-to Address 2	Text[50]	-
95	Sell-to City	Text[30]	-
96	Sell-to Contact	Text[100]	-
97	Sell-to Post Code	Code[20]	-
98	Sell-to County	Text[30]	-
99	Sell-to Country/Region Code	Code[10]	-
100	Sell-to Contact No.	Code[20]	-
110	Ship-to Code	Code[10]	-
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]	-
116	Ship-to Contact	Text[100]	-
117	Ship-to Post Code	Code[20]	-
118	Ship-to County	Text[30]	-
119	Ship-to Country/Region Code	Code[10]	-
130	External Document No.	Code[35]	-
131	Payment Method Code	Code[10]	-
132	Payment Terms Code	Code[10]	-
133	Your Reference	Text[35]	-
134	Price Calculation Method	Enum Price Calculation Method	-
140	Invoice Currency Code	Code[10]	-
5047	Version No.	Integer	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	Job No., Job Task No., Version No.	-
Key2	Job Task No.	-