Objects/Tables/Table 1003 Job Planning Line

Table 1003 Job Planning Line in 25

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

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

Fields, 101 Keys, 14 Procedures, 74 Events, 77

Versions17 18 19 20 21 22 23 242526 27 28 latest

Source29

Fields, 101

Id	Name	Type	Obsolete
1	Line No.	Integer	-
2	Job No.	Code[20]	-
3	Planning Date	Date	-
4	Document No.	Code[20]	-
5	Type	Enum Job Planning Line Type	-
7	No.	Code[20]	-
8	Description	Text[100]	-
9	Quantity	Decimal	-
11	Direct Unit Cost (LCY)	Decimal	-
12	Unit Cost (LCY)	Decimal	-
13	Total Cost (LCY)	Decimal	-
14	Unit Price (LCY)	Decimal	-
15	Total Price (LCY)	Decimal	-
16	Resource Group No.	Code[20]	-
17	Unit of Measure Code	Code[10]	-
18	Qty. Rounding Precision	Decimal	-
19	Qty. Rounding Precision (Base)	Decimal	-
20	Location Code	Code[10]	-
29	Last Date Modified	Date	-
30	User ID	Code[50]	-
32	Work Type Code	Code[10]	-
33	Customer Price Group	Code[10]	-
79	Country/Region Code	Code[10]	-
80	Gen. Bus. Posting Group	Code[20]	-
81	Gen. Prod. Posting Group	Code[20]	-
83	Document Date	Date	-
84	Planning Due Date	Date	-
900	Qty. to Assemble	Decimal	-
901	Qty. to Assemble (Base)	Decimal	-
902	Assemble to Order	Boolean	-
903	BOM Item No.	Code[20]	-
904	Attached to Line No.	Integer	-
1000	Job Task No.	Code[20]	-
1001	Line Amount (LCY)	Decimal	-
1002	Unit Cost	Decimal	-
1003	Total Cost	Decimal	-
1004	Unit Price	Decimal	-
1005	Total Price	Decimal	-
1006	Line Amount	Decimal	-
1007	Line Discount Amount	Decimal	-
1008	Line Discount Amount (LCY)	Decimal	-
1015	Cost Factor	Decimal	-
1019	Serial No.	Code[50]	-
1020	Lot No.	Code[50]	-
1021	Line Discount %	Decimal	-
1022	Line Type	Enum Job Planning Line Line Type	-
1023	Currency Code	Code[10]	-
1024	Currency Date	Date	-
1025	Currency Factor	Decimal	-
1026	Schedule Line	Boolean	-
1027	Contract Line	Boolean	-
1030	Job Contract Entry No.	Integer	-
1035	Invoiced Amount (LCY)	Decimal	-
1036	Invoiced Cost Amount (LCY)	Decimal	-
1037	VAT Unit Price	Decimal	-
1038	VAT Line Discount Amount	Decimal	-
1039	VAT Line Amount	Decimal	-
1041	VAT %	Decimal	-
1042	Description 2	Text[50]	-
1043	Job Ledger Entry No.	Integer	-
1048	Status	Enum Job Planning Line Status	-
1050	Ledger Entry Type	Enum Job Ledger Entry Type	-
1051	Ledger Entry No.	Integer	-
1052	System-Created Entry	Boolean	-
1053	Usage Link	Boolean	-
1060	Remaining Qty.	Decimal	-
1061	Remaining Qty. (Base)	Decimal	-
1062	Remaining Total Cost	Decimal	-
1063	Remaining Total Cost (LCY)	Decimal	-
1064	Remaining Line Amount	Decimal	-
1065	Remaining Line Amount (LCY)	Decimal	-
1070	Qty. Posted	Decimal	-
1071	Qty. to Transfer to Journal	Decimal	-
1072	Posted Total Cost	Decimal	-
1073	Posted Total Cost (LCY)	Decimal	-
1074	Posted Line Amount	Decimal	-
1075	Posted Line Amount (LCY)	Decimal	-
1080	Qty. Transferred to Invoice	Decimal	-
1081	Qty. to Transfer to Invoice	Decimal	-
1090	Qty. Invoiced	Decimal	-
1091	Qty. to Invoice	Decimal	-
1100	Reserved Quantity	Decimal	-
1101	Reserved Qty. (Base)	Decimal	-
1102	Reserve	Enum Reserve Method	-
1103	Planned	Boolean	-
5402	Variant Code	Code[10]	-
5403	Bin Code	Code[20]	-
5404	Qty. per Unit of Measure	Decimal	-
5410	Quantity (Base)	Decimal	-
5790	Requested Delivery Date	Date	-
5791	Promised Delivery Date	Date	-
5794	Planned Delivery Date	Date	-
6515	Package No.	Code[50]	-
7000	Price Calculation Method	Enum Price Calculation Method	-
7001	Cost Calculation Method	Enum Price Calculation Method	-
7300	Pick Qty.	Decimal	-
7301	Qty. Picked	Decimal	-
7302	Qty. Picked (Base)	Decimal	-
7303	Completely Picked	Boolean	-
7304	Pick Qty. (Base)	Decimal	-
7305	Qty. on Journal	Decimal	-

Keys, 14

Name	Fields	Obsolete
Key1, clustered	Job No., Job Task No., Line No.	-
Key2	Job No., Job Task No., Schedule Line, Planning Date	-
Key3	Job No., Job Task No., Contract Line, Planning Date	-
Key4	Job No., Job Task No., Schedule Line, Currency Date	-
Key5	Job No., Job Task No., Contract Line, Currency Date	-
Key6	Job No., Schedule Line, Type, No., Planning Date	-
Key7	Job No., Schedule Line, Type, Resource Group No., Planning Date	-
Key8	Status, Schedule Line, Type, No., Planning Date	-
Key9	Status, Schedule Line, Type, Resource Group No., Planning Date	-
Key10	Job No., Contract Line	-
Key11	Job Contract Entry No.	-
Key12	Type, No., Job No., Job Task No., Usage Link, System-Created Entry	-
Key13	Status, Type, No., Variant Code, Location Code, Planning Date	-
Key14	Job No., Planning Date, Document No.	-

Procedures, 74

Name	Parameters	Returns	Access	Obsolete
UpdateCurrencyFactor	()		public	-
Caption	()	Text	public	-
SetUpNewLine	(Record Job Planning Line)		public	-
InitJobPlanningLine	()		public	-
GetRemainingQty	(var Decimal, var Decimal)		public	-
GetReservationQty	(var Decimal, var Decimal, var Decimal, var Decimal)	Decimal	public	-
GetSourceCaption	()	Text	public	-
SetReservationEntry	(var Record Reservation Entry)		public	-
SetReservationFilters	(var Record Reservation Entry)		public	-
ReservEntryExist	()	Boolean	public	-
AfterResourceFindCost	(var Record Resource Cost)		public	Pending 17.0
Replaced by the new implementation (V16) of price calculation.
ApplyPrice	(Enum Price Type, Integer)		public	-
GetLineWithPrice	(var Interface Line With Price)		public	-
Use	(Decimal, Decimal, Decimal, Date, Decimal)		public	-
UpdateQtyToTransfer	()		public	-
UpdateQtyToInvoice	()		public	-
UpdatePostedTotalCost	(Decimal, Decimal)		public	-
Overdue	()	Boolean	public	-
SetBypassQtyValidation	(Boolean)		public	-
ShowReservation	()		public	-
ShowReservationEntries	(Boolean)		public	-
AutoReserve	()		public	-
ShowTracking	()		public	-
ShowOrderPromisingLine	()		public	-
FilterLinesWithItemToPlan	(var Record Item)		public	-
FindLinesWithItemToPlan	(var Record Item)	Boolean	public	-
LinesWithItemToPlanExist	(var Record Item)	Boolean	public	-
FilterLinesForReservation	(Record Reservation Entry, Option, Text, Boolean)		public	-
DrillDownJobInvoices	()		public	-
RowID1	()	Text[250]	public	-
UpdatePlanned	()	Boolean	public	-
ClearValues	()		public	-
InitFromJobPlanningLine	(Record Job Planning Line, Decimal)		public	-
IsNonInventoriableItem	()	Boolean	public	-
CopyTrackingFromJobJnlLine	(Record Job Journal Line)		public	-
CopyTrackingFromJobLedgEntry	(Record Job Ledger Entry)		public	-
InitRoundingPrecisions	()		public	-
UpdatePlannedDueDate	()	Boolean	public	-
ClearTracking	()		public	-
ConvertToJobLineType	()	Enum Job Line Type	public	-
ConvertFromJobLineType	(Enum Job Line Type)	Enum Job Planning Line Line Type	public	-
CheckItemAvailable	(Integer)		public	-
UpdateReservation	(Integer)		public	-
GetNextJobLineNo	(Record Job Planning Line)	Integer	protected	-
CreateWarehouseRequest	()		internal	-
OpenItemTrackingLines	()		internal	-
IsInbound	()	Boolean	internal	-
RowID2	()	Text[250]	internal	-
TestStatusOpen	()		public	-
UpdateAllAmounts	()		public	-
FindPriceAndDiscount	(Integer)		public	-
UpdateAmountsAndDiscounts	()		public	-
ValidateModification	(Boolean, Integer)		public	-
IsInventoriableItem	()	Boolean	public	-
CheckIfJobPlngLineMeetsReservedFromStockSetting	(Decimal, Enum Reservation From Stock)	Boolean	public	-
GetJob	()		public	-
RetrieveCostPrice	(Integer)	Boolean	protected	-
IsAsmToOrderAllowed	()	Boolean	public	-
QtyToAsmBaseOnATO	()	Decimal	public	-
ShowAsmToJobPlanningLines	()		public	-
CheckAsmToOrder	(Record Assembly Header)		public	-
AsmToOrderExists	(var Record Assembly Header)	Boolean	public	-
InitQtyToAsm	()		protected	-
AssembledQuantity	(var Decimal, var Decimal)		public	-
IsAsmToOrderRequired	()	Boolean	public	-
SelectMultipleItems	()		public	-
GetATOBin	(Record Location, var Code[20])	Boolean	public	-
IsExtendedText	()	Boolean	public	-
SetSkipCheckForMultipleJobsOnSalesLine	(Boolean)		public	-
GetSkipCheckForMultipleJobsOnSalesLine	()	Boolean	public	-
SuspendDeletionCheck	(Boolean)		public	-
SetJob	(Record Job)		public	-
CopyFieldsFromJob	()		public	-
SetPurchLineFilters	(var Record Purchase Line)		public	-

Events, 77

Kind	Name	Parameters	Obsolete
Integration event	OnAfterCopyFromItem	(var Record Job Planning Line, Record Job, Record Item)	-
Integration event	OnAfterCopyTrackingFromJobJnlLine	(var Record Job Planning Line, Record Job Journal Line)	-
Integration event	OnAfterCopyTrackingFromJobLedgEntry	(var Record Job Planning Line, Record Job Ledger Entry)	-
Integration event	OnAfterDeleteAmounts	(var Record Job Planning Line)	-
Integration event	OnAfterGetSKU	(Record Job Planning Line, var Boolean)	-
Integration event	OnAfterGetRemainingQty	(Record Job Planning Line, var Decimal, var Decimal)	-
Integration event	OnAfterFilterLinesWithItemToPlan	(var Record Job Planning Line, var Record Item)	-
Integration event	OnAfterGetLineWithPrice	(var Interface Line With Price)	-
Integration event	OnAfterHandleCostFactor	(var Record Job Planning Line, Record Job Planning Line, Record Item)	-
Integration event	OnAfterInitJobPlanningLine	(var Record Job Planning Line)	-
Integration event	OnAfterInitFromJobPlanningLine	(var Record Job Planning Line, Record Job Planning Line)	-
Integration event	OnAfterResourceFindCost	(var Record Job Planning Line, var Record Resource Cost)	Pending 17.0
Replaced by the new implementation (V16) of price calculation.
Integration event	OnAfterSetReservationFilters	(var Record Reservation Entry, Record Job Planning Line)	-
Integration event	OnAfterSetupNewLine	(var Record Job Planning Line, Record Job Planning Line)	-
Integration event	OnAfterUpdateTotalPrice	(var Record Job Planning Line)	-
Integration event	OnBeforeCalcQuantityBase	(var Record Job Planning Line, Record Job Planning Line, Integer, var Boolean)	-
Integration event	OnBeforeCopyFromResource	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeHandleCostFactor	(var Record Job Planning Line, var Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeUpdateAmountsAndDiscounts	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeValidateWorkTypeCode	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeValidateQtyToTransferToInvoice	(var Record Job Planning Line, var Record Job Planning Line, var Boolean)	-
Integration event	OnControlUsageLinkOnAfterGetJob	(var Record Job Planning Line, Record Job, Integer, var Boolean)	-
Integration event	OnAfterCopyFromGLAccount	(var Record Job Planning Line, Record Job, Record G/L Account)	-
Integration event	OnAfterClearTracking	(var Record Job Planning Line)	-
Integration event	OnAfterFilterLinesForReservation	(var Record Job Planning Line, Record Reservation Entry, Option, Text, Boolean)	-
Integration event	OnAfterUpdateAllAmounts	(var Record Job Planning Line, var Record Job Planning Line)	-
Integration event	OnBeforeCheckQuantityPosted	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeFindPriceAndDiscount	(Integer, var Boolean, var Record Job Planning Line, Record Job Planning Line)	-
Integration event	OnBeforeUpdateRemainingQuantity	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnUpdateCurrencyFactorOnBeforeGetExchangeRate	(Record Job Planning Line, var Record Currency Exchange Rate)	-
Integration event	OnValidateNoOnAfterCopyFromAccount	(var Record Job Planning Line, var Record Job Planning Line, var Record Job)	-
Integration event	OnBeforeEnsureDirectedPutawayandPickFalse	(var Record Job Planning Line, Record Location, var Boolean)	Pending 25.0
Event no longer used as procedure EnsureDirectedPutawayandPickFalse is deleted.
Integration event	OnBeforeValidateQuantityBase	(var Record Job Planning Line, Record Job Planning Line, Integer, var Boolean)	-
Integration event	OnAfterConvertToJobLineType	(var Record Job Planning Line, var Enum Job Line Type)	-
Integration event	OnAfterConvertFromJobLineType	(var Record Job Planning Line, var Enum Job Line Type, var Enum Job Planning Line Line Type)	-
Integration event	OnBeforeRetrieveCostPrice	(var Record Job Planning Line, Record Job Planning Line, var Boolean, var Boolean, Integer)	-
Integration event	OnBeforeUpdateRemainingQuantityFromUse	(var Record Job Planning Line, Record Job Planning Line, Decimal, var Boolean)	-
Integration event	OnBeforeUpdateReservation	(var Record Job Planning Line, var Record Job Planning Line, Integer, var Boolean, Integer)	-
Integration event	OnAfterCalculateRetrievedCost	(var Record Job Planning Line, Record Job Planning Line, Record Stockkeeping Unit, Record Item, var Decimal)	-
Integration event	OnAfterCopyFieldsFromJob	(var Record Job Planning Line, Record Job Planning Line, Record Job)	-
Integration event	OnAfterGetJob	(var Record Job Planning Line, var Record Job)	-
Integration event	OnAfterUpdateCurrencyFactor	(var Record Job Planning Line)	-
Integration event	OnAfterUpdateUnitPrice	(var Record Job Planning Line, Record Job Planning Line, var Decimal, var Decimal)	-
Integration event	OnAfterUpdateAmountsAndDiscounts	(var Record Job Planning Line, Record Job Planning Line)	-
Integration event	OnAfterValidateModification	(var Record Job Planning Line, Boolean, Integer)	-
Integration event	OnBeforeCheckRelatedJobPlanningLineInvoice	(Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeInitJobPlanningLine	(var Record Job Planning Line, Record Job, var Boolean)	-
Integration event	OnBeforeInitRoundingPrecisions	(Record Job Planning Line, var Decimal, var Decimal, var Decimal, var Decimal, var Boolean)	-
Integration event	OnBeforeUpdatePlannedDueDate	(var Record Job Planning Line, var Boolean, var Boolean)	-
Integration event	OnBeforeOnInsert	(var Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeUpdateDescription	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeValidateModification	(var Record Job Planning Line, var Boolean, Record Job Planning Line, Integer)	-
Integration event	OnBeforeValidatePlanningDate	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnUseOnBeforeModify	(var Record Job Planning Line, Record Job Planning Line, Decimal, Decimal, Decimal, Decimal)	-
Integration event	OnBeforeLinesWithItemToPlanExist	(var Record Item, var Boolean, var Boolean)	-
Integration event	OnBeforeValidateUsageLink	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnDeleteOnAfterSetFilterOnJobUsageLink	(Record Job Planning Line, var Record Job Usage Link, var Boolean)	-
Integration event	OnBeforeOnRename	(var Record Job Planning Line, var Boolean)	-
Integration event	OnControlUsageLinkOnAfterSetFilterJobUsageLink	(var Record Job Planning Line, var Record Job Usage Link, Record Job, Integer, var Boolean)	-
Integration event	OnBeforeFindBin	(var Record Job Planning Line, var Code[20], var Boolean)	-
Integration event	OnAfterFindPriceAndDiscount	(var Record Job Planning Line, Record Job Planning Line, Integer)	-
Integration event	OnBeforeCaption	(Record Job Planning Line, var Boolean, var Text)	-
Integration event	OnBeforeRecalculateAmounts	(var Record Job Planning Line, var Record Job Planning Line, var Decimal, var Boolean, var Decimal)	-
Integration event	OnBeforeUpdateUnitCost	(var Record Job Planning Line, var Boolean, Record Job Planning Line)	-
Integration event	OnCheckIfJobPlngLineMeetsReservedFromStockSetting	(Decimal, Enum Reservation From Stock, var Boolean)	-
Integration event	OnBeforeUpdateUnitPrice	(var Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeUpdateTotalCost	(var Record Job Planning Line, Decimal, Decimal, var Boolean)	-
Integration event	OnAfterClearValues	(var Record Job Planning Line)	-
Integration event	OnAfterControlUsageLink	(var Record Job Planning Line, Record Job, Integer)	-
Integration event	OnBeforeCopyFromGLAccount	(var Record Job Planning Line, var Boolean, Record Job)	-
Integration event	OnBeforeUpdateRemainingCostsAndAmounts	(var Record Job Planning Line, Date, Decimal, Decimal, Decimal, var Boolean)	-
Integration event	OnBeforeSelectMultipleItems	(var Record Job Planning Line)	-
Integration event	OnAfterSelectMultipleItems	(var Record Job Planning Line)	-
Integration event	OnBeforeAddItems	(var Record Job Planning Line, Text, var Boolean)	-
Integration event	OnAfterCopyFromResource	(var Record Job Planning Line, Record Job, Record Resource)	-
Integration event	OnBeforeUpdateQtyToTransfer	(var Record Job Planning Line, Integer, var Boolean)	-
Integration event	OnBeforeUpdateAllAmounts	(var Record Job Planning Line, var Record Job Planning Line, var Boolean, Integer)	-