Table 1001 Job Task in 24

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

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

Fields, 75 Keys, 3 Procedures, 27 Events, 14

Versions17 18 19 20 21 22 232425 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]	-
721	Coupled to Dataverse	Boolean	Pending 25.0
Field Service is moved to Field Service Integration app.

Keys, 3

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

Procedures, 27

Name	Parameters	Returns	Access	Obsolete
CalcEACTotalCost	()	Decimal	public	-
CalcEACTotalPrice	()	Decimal	public	-
Caption	()	Text	public	-
InitWIPFields	()		public	-
ValidateShortcutDimCode	(Integer, var Code[20])		public	-
ClearTempDim	()		public	-
ApplyPurchaseLineFilters	(var Record Purchase Line, Code[20], Code[20])		public	-
ToPriceSource	(var Record Price Source, Enum Price Type)		public	-
JobPlanningLineExist	()	Boolean	public	-
SalesJobLedgEntryExist	()	Boolean	public	-
SalesLineExist	()	Boolean	public	-
ShouldSearchForCustomerByName	(Code[20])	Boolean	public	-
UpdateSellToContact	(Code[20])		protected	-
BilltoContactLookup	()	Boolean	public	-
LookupSellToCustomerName	(var Text)	Boolean	public	-
SelltoCustomerNoOnAfterValidate	(var Record Job Task, var Record Job Task)		public	-
SelltoContactLookup	()	Boolean	public	-
ShipToNameEqualsSellToName	()	Boolean	public	-
BillToAddressEqualsSellToAddress	()	Boolean	public	-
ShipToAddressEqualsSellToAddress	()	Boolean	public	-
SyncShipToWithSellTo	()		public	-
JobLedgEntryExist	()	Boolean	public	-
JobPlanLineExist	()	Boolean	public	-
SendProfile	(var Record Document Sending Profile)		public	-
SetHideValidationDialog	(Boolean)		public	-
GetHideValidationDialog	()	Boolean	public	-
SuspendDeletionCheck	(Boolean)		public	-

Events, 14

Kind	Name	Parameters	Obsolete
Integration event	OnAfterValidateShortcutDimCode	(var Record Job Task, var Record Job Task, Integer, var Code[20])	-
Integration event	OnBeforeOnInsert	(var Record Job Task, var Boolean)	-
Integration event	OnInitWIPFieldsOnBeforeModify	(var Record Job Task)	-
Integration event	OnAfterOnInsert	(var Record Job Task, var Record Job Task)	-
Integration event	OnBeforeValidateJobTaskNo	(var Record Job Task, var Record Job Task, Integer, var Boolean)	-
Integration event	OnAfterApplyPurchaseLineFilters	(var Record Job Task, var Record Purchase Line)	-
Integration event	OnBeforeOnModify	(var Record Job Task, Record Job Task, var Boolean)	-
Integration event	OnBeforeValidateJobPostingGroup	(var Record Job Task, Record Job Task, Integer, var Boolean)	-
Integration event	OnJobLedgEntriesExistOnAfterSetFilter	(var Record Job Task, var Record Job Ledger Entry)	-
Integration event	OnBeforeCaption	(Record Job Task, var Boolean, var Text)	-
Integration event	OnBeforeValidateShortcutDimCode	(var Record Job Task, var Record Job Task, Integer, var Code[20], Record Job Task, var Boolean)	-
Integration event	OnAfterShipToAddressEqualsSellToAddress	(var Record Job Task, var Boolean)	-
Integration event	OnAfterSyncShipToWithSellTo	(var Record Job Task)	-
Integration event	OnUpdateCostPricesOnRelatedJobPlanningLinesOnBeforeConfirmUpdate	(var Record Job Task, var Boolean, var Boolean)	-