Objects/Tables/Table 1003 Job Planning Line

Table 1003 Job Planning Line in 28

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

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

Fields, 101 Keys, 14 Procedures, 76 Events, 79

Versions17 18 19 20 21 22 23 24 25 26 2728latest

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, 76

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	-
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	-
RenameNo	(Enum Job Planning Line Type, Code[20], Code[20])		public	-
RecalculateAmounts	(Option, Decimal, var Decimal, var Decimal)		public	-

Events, 79

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)	-
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	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)	-
Integration event	OnBeforeValidateQuantity	(Record Job Planning Line, Record Job Planning Line, var Boolean)	-
Integration event	OnBeforeFindOrCreateRecordByNo	(var Record Job Planning Line, Record Job Planning Line, Integer, var Boolean)	-
Integration event	OnGetType	(Enum Job Planning Line Type, var Integer)	-