Objects/Tables/Table 246 Requisition Line

Table 246 Requisition Line in 20

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

App: Base Application

Fields, 118 Keys, 13 Procedures, 65 Events, 95

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 118

Id	Name	Type	Obsolete
1	Worksheet Template Name	Code[10]	-
2	Journal Batch Name	Code[10]	-
3	Line No.	Integer	-
4	Type	Enum Requisition Line Type	-
5	No.	Code[20]	-
6	Description	Text[100]	-
7	Description 2	Text[50]	-
8	Quantity	Decimal	-
9	Vendor No.	Code[20]	-
10	Direct Unit Cost	Decimal	-
12	Due Date	Date	-
13	Requester ID	Code[50]	-
14	Confirmed	Boolean	-
15	Shortcut Dimension 1 Code	Code[20]	-
16	Shortcut Dimension 2 Code	Code[20]	-
17	Location Code	Code[10]	-
18	Recurring Method	Option	-
19	Expiration Date	Date	-
20	Recurring Frequency	DateFormula	-
21	Order Date	Date	-
22	Vendor Item No.	Text[50]	-
23	Sales Order No.	Code[20]	-
24	Sales Order Line No.	Integer	-
25	Sell-to Customer No.	Code[20]	-
26	Ship-to Code	Code[10]	-
28	Order Address Code	Code[10]	-
29	Currency Code	Code[10]	-
30	Currency Factor	Decimal	-
31	Reserved Quantity	Decimal	-
73	Drop Shipment	Boolean	-
480	Dimension Set ID	Integer	-
5401	Prod. Order No.	Code[20]	-
5402	Variant Code	Code[10]	-
5403	Bin Code	Code[20]	-
5404	Qty. per Unit of Measure	Decimal	-
5405	Qty. Rounding Precision	Decimal	-
5406	Qty. Rounding Precision (Base)	Decimal	-
5407	Unit of Measure Code	Code[10]	-
5408	Quantity (Base)	Decimal	-
5431	Reserved Qty. (Base)	Decimal	-
5520	Demand Type	Integer	-
5521	Demand Subtype	Option	-
5522	Demand Order No.	Code[20]	-
5525	Demand Line No.	Integer	-
5526	Demand Ref. No.	Integer	-
5527	Status	Option	-
5530	Demand Date	Date	-
5532	Demand Quantity	Decimal	-
5533	Demand Quantity (Base)	Decimal	-
5538	Needed Quantity	Decimal	-
5539	Needed Quantity (Base)	Decimal	-
5540	Reserve	Boolean	-
5541	Qty. per UOM (Demand)	Decimal	-
5542	Unit Of Measure Code (Demand)	Code[10]	-
5552	Supply From	Code[20]	-
5553	Original Item No.	Code[20]	-
5554	Original Variant Code	Code[10]	-
5560	Level	Integer	-
5563	Demand Qty. Available	Decimal	-
5590	User ID	Code[50]	-
5701	Item Category Code	Code[20]	-
5702	Nonstock	Boolean	-
5703	Purchasing Code	Code[10]	-
5705	Product Group Code	Code[10]	Removed 15.0
Product Groups became first level children of Item Categories.
5706	Transfer-from Code	Code[10]	-
5707	Transfer Shipment Date	Date	-
7000	Price Calculation Method	Enum Price Calculation Method	-
7002	Line Discount %	Decimal	-
7100	Blanket Purch. Order Exists	Boolean	-
7110	Custom Sorting Order	Code[50]	-
99000750	Routing No.	Code[20]	-
99000751	Operation No.	Code[10]	-
99000752	Work Center No.	Code[20]	-
99000754	Prod. Order Line No.	Integer	-
99000755	MPS Order	Boolean	-
99000756	Planning Flexibility	Enum Reservation Planning Flexibility	-
99000757	Routing Reference No.	Integer	-
99000882	Gen. Prod. Posting Group	Code[20]	-
99000883	Gen. Business Posting Group	Code[20]	-
99000884	Low-Level Code	Integer	-
99000885	Production BOM Version Code	Code[20]	-
99000886	Routing Version Code	Code[20]	-
99000887	Routing Type	Option	-
99000888	Original Quantity	Decimal	-
99000889	Finished Quantity	Decimal	-
99000890	Remaining Quantity	Decimal	-
99000891	Original Due Date	Date	-
99000892	Scrap %	Decimal	-
99000894	Starting Date	Date	-
99000895	Starting Time	Time	-
99000896	Ending Date	Date	-
99000897	Ending Time	Time	-
99000898	Production BOM No.	Code[20]	-
99000899	Indirect Cost %	Decimal	-
99000900	Overhead Rate	Decimal	-
99000901	Unit Cost	Decimal	-
99000902	Cost Amount	Decimal	-
99000903	Replenishment System	Enum Replenishment System	-
99000904	Ref. Order No.	Code[20]	-
99000905	Ref. Order Type	Option	-
99000906	Ref. Order Status	Option	-
99000907	Ref. Line No.	Integer	-
99000908	No. Series	Code[20]	-
99000909	Expected Operation Cost Amt.	Decimal	-
99000910	Expected Component Cost Amt.	Decimal	-
99000911	Finished Qty. (Base)	Decimal	-
99000912	Remaining Qty. (Base)	Decimal	-
99000913	Related to Planning Line	Integer	-
99000914	Planning Level	Integer	-
99000915	Planning Line Origin	Option	-
99000916	Action Message	Enum Action Message Type	-
99000917	Accept Action Message	Boolean	-
99000918	Net Quantity (Base)	Decimal	-
99000919	Starting Date-Time	DateTime	-
99000920	Ending Date-Time	DateTime	-
99000921	Order Promising ID	Code[20]	-
99000922	Order Promising Line No.	Integer	-
99000923	Order Promising Line ID	Integer	-

Keys, 13

Name	Fields	Obsolete
Key1, clustered	Worksheet Template Name, Journal Batch Name, Line No.	-
Key2	Worksheet Template Name, Journal Batch Name, Vendor No., Sell-to Customer No., Ship-to Code, Order Address Code, Currency Code, Ref. Order Type, Ref. Order Status, Ref. Order No., Location Code, Transfer-from Code, Purchasing Code	-
Key3	Type, No., Variant Code, Location Code, Sales Order No., Planning Line Origin, Due Date, Drop Shipment	-
Key4	Type, No., Variant Code, Location Code, Sales Order No., Order Date	-
Key5	Type, No., Variant Code, Location Code, Starting Date	-
Key6	Worksheet Template Name, Journal Batch Name, Type, No., Due Date	-
Key7	Ref. Order Type, Ref. Order Status, Ref. Order No., Ref. Line No.	-
Key8	Replenishment System, Type, No., Variant Code, Transfer-from Code, Transfer Shipment Date	-
Key9	Order Promising ID, Order Promising Line ID, Order Promising Line No.	-
Key10	User ID, Demand Type, Worksheet Template Name, Journal Batch Name, Line No.	-
Key11	User ID, Demand Type, Demand Subtype, Demand Order No., Demand Line No., Demand Ref. No.	-
Key12	User ID, Worksheet Template Name, Journal Batch Name, Line No.	-
Key13	Worksheet Template Name, Journal Batch Name, Custom Sorting Order	-

Procedures, 65

Name	Parameters	Returns	Access	Obsolete
ShowReservation	()		public	-
ShowReservationEntries	(Boolean)		public	-
LookupVendor	(var Record Vendor, Boolean)	Boolean	public	-
UpdateDescription	()		public	-
BlockDynamicTracking	(Boolean)		public	-
BlockDynamicTrackingOnComp	(Boolean)		public	-
CreateDim	(Integer, Code[20], Integer, Code[20])		public	Pending 20.0
Replaced by CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
UpdateDim	(Integer, Code[20], Integer, Code[20])		public	Pending 20.0
Replaced by UpdateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
ValidateShortcutDimCode	(Integer, var Code[20])		public	-
LookupShortcutDimCode	(Integer, var Code[20])		public	-
ShowShortcutDimCode	(var Code[20])		public	-
OpenItemTrackingLines	()		public	-
DeleteRelations	()		public	-
DeleteMultiLevel	()		public	-
SetUpNewLine	(Record Requisition Line)		public	-
SetDueDate	()		public	-
SetCurrFieldNo	(Integer)		public	-
SetActionMessage	()		public	-
GetProdOrderLine	(Record Prod. Order Line)		public	-
GetPurchOrderLine	(Record Purchase Line)		public	-
GetTransLine	(Record Transfer Line)		public	-
GetAsmHeader	(Record Assembly Header)		public	-
GetActionMessages	()		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	-
SetRefFilter	(Option, Option, Code[20], Integer)		public	-
TransferFromProdOrderLine	(var Record Prod. Order Line)		public	-
TransferFromPurchaseLine	(var Record Purchase Line)		public	-
TransferFromAsmHeader	(var Record Assembly Header)		public	-
TransferFromTransLine	(var Record Transfer Line)		public	-
GetDimFromRefOrderLine	(Boolean)		public	-
TransferFromActionMessage	(var Record Action Message Entry)		public	-
TransferToTrackingEntry	(var Record Reservation Entry, Boolean)		public	-
UpdateDatetime	()		public	-
GetDirectCost	(Integer)		public	-
GetLineWithPrice	(var Interface Line With Price)		public	-
RowID1	()	Text[250]	public	-
CalcEndingDate	(Code[20])		public	-
CalcStartingDate	(Code[20])		public	-
SetSubcontracting	(Boolean)		public	-
TransferFromUnplannedDemand	(var Record Unplanned Demand)		public	-
SetSupplyDates	(Date)		public	-
SetSupplyQty	(Decimal, Decimal)		public	-
SetResiliencyOn	(Code[10], Code[10], Code[20])		public	-
GetResiliencyError	(var Record Planning Error Log)	Boolean	public	-
SetResiliencyError	(Text[250], Integer, Text[250])		public	-
FindLinesWithItemToPlan	(var Record Item)	Boolean	public	-
FilterLinesForReservation	(Record Reservation Entry, Text, Boolean)		public	-
FindCurrForecastName	(var Code[10])	Boolean	public	-
ShowDimensions	()		public	-
ShowTimeline	(Record Requisition Line)		public	-
GetOriginalQtyBase	()	Decimal	public	-
SetDropShipment	(Boolean)		public	Pending 19.0
Replaced by Drop Shipment field.
IsDropShipment	()	Boolean	public	-
GetJnlBatchNameForOrderPlanning	()	Code[10]	public	-
UpdateOrderReceiptDate	(DateFormula)		public	-
CopyFromItem	()		public	-
ValidateFields	()	Boolean	public	-
CreateDim	(List)		public	-
UpdateDim	(List)		public	-
CreateDimFromDefaultDim	()		public	-

Events, 95

Kind	Name	Parameters	Obsolete
Integration event	OnAfterCopyFromItem	(var Record Requisition Line, Record Item)	-
Integration event	OnAfterCreateDim	(var Record Requisition Line, Record Requisition Line)	-
Integration event	OnAfterCreateDimTableIDs	(var Record Requisition Line, var Integer, var Integer, var Code[20])	Pending 20.0
Temporary event for compatibility
Integration event	OnAfterDeleteMultiLevel	(var Record Requisition Line)	-
Integration event	OnAfterDeleteRelations	(var Record Requisition Line)	-
Integration event	OnAfterFilterLinesWithItemToPlan	(var Record Requisition Line, var Record Item)	-
Integration event	OnAfterGetDirectCost	(var Record Requisition Line, Integer)	-
Integration event	OnAfterGetLineWithPrice	(var Interface Line With Price)	-
Integration event	OnAfterSetReplenishmentSystemFromPurchase	(var Record Requisition Line, Record Item, Record Stockkeeping Unit)	-
Integration event	OnAfterSetReplenishmentSystemFromProdOrder	(var Record Requisition Line, Record Item)	-
Integration event	OnSetReplenishmentSystemFromProdOrderOnAfterSetProdFields	(var Record Requisition Line, Record Item, Boolean)	-
Integration event	OnSetReplenishmentSystemFromProdOrderOnBeforeSetProdFields	(var Record Requisition Line, Record Item, Boolean, Boolean, var Record Planning Error Log)	-
Integration event	OnAfterSetReplenishmentSystemFromAssembly	(var Record Requisition Line, Record Item)	-
Integration event	OnAfterSetReservationFilters	(var Record Reservation Entry, Record Requisition Line)	-
Integration event	OnAfterTransferFromProdOrderLine	(var Record Requisition Line, Record Prod. Order Line)	-
Integration event	OnAfterTransferFromPurchaseLine	(var Record Requisition Line, Record Purchase Line)	-
Integration event	OnAfterTransferFromAsmHeader	(var Record Requisition Line, Record Assembly Header)	-
Integration event	OnAfterTransferFromTransLine	(var Record Requisition Line, Record Transfer Line)	-
Integration event	OnAfterTransferFromUnplannedDemand	(var Record Requisition Line, Record Unplanned Demand)	-
Integration event	OnAfterTransferToTrackingEntry	(var Record Reservation Entry, Record Requisition Line)	-
Integration event	OnAfterValidateShortcutDimCode	(var Record Requisition Line, Record Requisition Line, Integer, var Code[20])	-
Integration event	OnBeforeCopyFromItem	(var Record Requisition Line, Record Item, Record Requisition Line, Integer, var Record Planning Error Log, Boolean)	-
Integration event	OnBeforeCheckEndingDate	(var Record Requisition Line, var Boolean, var Boolean)	-
Integration event	OnBeforeDeleteMultiLevel	(var Record Requisition Line)	-
Integration event	OnBeforeGetDefaultBin	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeGetDirectCost	(var Record Requisition Line, Record Requisition Line, Integer, Integer, Boolean, var Boolean)	-
Integration event	OnBeforeLookupVendor	(var Record Requisition Line, var Record Vendor, var Boolean, var Boolean, var Boolean)	-
Integration event	OnBeforeLookupVendorNo	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeOnDelete	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeSetFromBinCode	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeValidateItemDescriptionAndQuantity	(var Record Requisition Line, Record Vendor, var Boolean)	-
Integration event	OnBeforeValidateShortcutDimCode	(var Record Requisition Line, Record Requisition Line, Integer, var Code[20])	-
Integration event	OnBeforeUpdateDescription	(var Record Requisition Line, Integer, var Boolean)	-
Integration event	OnBeforeUpdateOrderReceiptDate	(var Record Requisition Line, DateFormula, var Boolean)	-
Integration event	OnBeforeValidateReplenishmentSystem	(var Record Requisition Line, Record Stockkeeping Unit, var Boolean)	-
Integration event	OnGetLocationCodeOnBeforeUpdate	(var Record Requisition Line, Integer, var Boolean)	-
Integration event	OnLookupSupplyFromOnCaseReplenishmentSystemElse	(var Record Requisition Line)	-
Integration event	OnValidateSupplyFromOnCaseReplenishmentSystemElse	(var Record Requisition Line)	-
Integration event	OnUpdateDescriptionFromItem	(var Record Requisition Line, Record Item)	-
Integration event	OnUpdateDescriptionFromItemVariant	(var Record Requisition Line, Record Item Variant)	-
Integration event	OnUpdateDescriptionFromItemTranslation	(var Record Requisition Line, Record Item Translation)	-
Integration event	OnUpdateDescriptionFromSalesLine	(var Record Requisition Line, Record Sales Line)	-
Integration event	OnValidateEndingTimeOnBeforeSetDueDate	(var Record Requisition Line, var Boolean)	-
Integration event	OnValidateStartingTimeOnBeforeSetDueDate	(var Record Requisition Line, var Boolean)	-
Integration event	OnValidateReplenishmentSystemCaseElse	(var Record Requisition Line)	-
Integration event	OnValidateVendorNoOnAfterGetLocationCode	(var Record Requisition Line)	-
Integration event	OnBeforeCopyDescriptionFromGLAcc	(var Record Requisition Line, var Boolean)	-
Integration event	OnAfterLookupVendorNo	(var Record Requisition Line, var Record Vendor)	-
Integration event	OnBeforeValidateLocationChange	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeGetLocation	(var Record Requisition Line, var Record Location, Code[10], var Boolean)	-
Integration event	OnAfterSetUpNewLine	(var Record Requisition Line, Record Requisition Line)	-
Integration event	OnTransferFromUnplannedDemandOnBeforeSetType	(var Record Requisition Line)	-
Integration event	OnDeleteRelationsOnBeforePlanningComponentDelete	(var Record Requisition Line, var Boolean)	-
Integration event	OnTransferFromUnplannedDemandOnBeforeSetStatus	(var Record Requisition Line, var Record Unplanned Demand)	-
Integration event	OnBeforeValidateActionMessage	(var Record Requisition Line, var Record Requisition Line, var Boolean)	-
Integration event	OnSetReplenishmentSystemFromProdOrderOnBeforeAssignProdFields	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeSetReplenishmentSystemFromProdOrder	(var Record Requisition Line)	-
Integration event	OnAfterSetSupplyDates	(var Record Requisition Line)	-
Integration event	OnValidateUnitofMeasureCodeOnBeforeGetDirectCost	(var Record Requisition Line, var Record Item)	-
Integration event	OnBeforeUpdateUnitOfMeasureCodeFromItemBaseUnitOfMeasure	(var Record Requisition Line, var Record Item, var Boolean)	-
Integration event	OnBeforeUpdateUnitOfMeasureCodeFromItemPurchUnitOfMeasure	(var Record Requisition Line, var Record Item, var Boolean)	-
Integration event	OnAfterSetDueDate	(var Record Requisition Line)	-
Integration event	OnAfterTransferFromActionMessage	(var Record Requisition Line, var Record Action Message Entry)	-
Integration event	OnAfterSetReplenishmentSystemFromTransfer	(var Record Requisition Line, Record Item, Record Stockkeeping Unit, Integer)	-
Integration event	OnAfterUpdateOrderReceiptDate	(var Record Requisition Line, DateFormula)	-
Integration event	OnBeforeInitRecordForOrderPlanning	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeValidateVendorNoWithStockkeepingUnit	(var Record Requisition Line, Record Stockkeeping Unit)	-
Integration event	OnBeforeValidateUnitCost	(var Record Requisition Line, var Boolean)	-
Integration event	OnBeforeCalcStartingDate	(var Record Requisition Line, var Code[20])	-
Integration event	OnBeforeCalcEndingDate	(var Record Requisition Line, var Code[20])	-
Integration event	OnBeforeValidateStartingTime	(var Record Requisition Line, var Boolean, var Boolean, Integer, Integer, Record Requisition Line)	-
Integration event	OnBeforeValidateEndingTime	(var Record Requisition Line, var Boolean, var Boolean, Integer, Integer)	-
Integration event	OnSetReplenishmentSystemFromProdOrderOnBeforeProcessPlannedOrderNosField	(var Record Requisition Line, var Boolean, Record Requisition Line)	-
Integration event	OnLookupFromLocationOnAfterSetFilters	(Record Requisition Line, var Record Location)	-
Integration event	OnAfterValidateProductionBOMNo	(var Record Requisition Line, Record Requisition Line, Record Production BOM Header)	-
Integration event	OnAfterValidateProductionBOMVersionCode	(var Record Requisition Line, Record Requisition Line, Record Production BOM Version)	-
Integration event	OnBeforeCheckVendorBlocked	(var Record Requisition Line, var Record Vendor, var Boolean, Integer)	-
Integration event	OnBeforeValidateQuantityBase	(var Record Requisition Line, var Boolean, Record Requisition Line, Integer, Integer)	-
Integration event	OnValidateNoOfAfterCalcShouldValidateUnitofMeasureCode	(var Record Requisition Line, Record Requisition Line, Record Item, var Boolean)	-
Integration event	OnValidateQuantityOnBeforeUnitCost	(var Record Requisition Line, Integer, Integer)	-
Integration event	OnBeforeRunEventOnAfterCreateDimTableIDs	(var Record Requisition Line, var List, var Boolean)	Pending 20.0
Temporary event for compatibility
Integration event	OnAfterInitDefaultDimensionSources	(var Record Requisition Line, var List)	-
Integration event	OnAfterFilterLinesForReservation	(var Record Requisition Line, var Record Reservation Entry)	-
Integration event	OnAfterOnInsert	(var Record Requisition Line, Record Req. Wksh. Template, Record Requisition Wksh. Name)	-
Integration event	OnAfterSetRemaningQuantity	(var Record Requisition Line, Record Requisition Line, Integer, Integer)	-
Integration event	OnBeforeGetReservationQty	(var Record Requisition Line, var Decimal, var Decimal, var Decimal, var Decimal, var Decimal, var Boolean)	-
Integration event	OnValidateLocationCodeOnBeforeGetDefaultBin	(Record Requisition Line, var Boolean, Record Location, Integer)	-
Integration event	OnBeforeShowReservation	(var Record Requisition Line, var Boolean)	-
Integration event	OnAfterUpdateDim	(var Record Requisition Line, List)	-
Integration event	OnBeforeCheckReqWkshTmpl	(var Record Requisition Line, Record Item, var Boolean)	-
Integration event	OnAfterCalcEndingDate	(var Record Requisition Line, Code[20])	-
Integration event	OnGetDirectCostOnBeforePriceCalculation	(var Record Requisition Line, var Boolean)	-
Integration event	OnCalcStartingDateOnBeforeValidateOrderDate	(var Record Requisition Line, var Code[20], var Boolean)	-
Integration event	OnBeforeSetReplenishmentSystemFromTransfer	(var Record Requisition Line, Record Item, Record Stockkeeping Unit, Integer)	-
Integration event	OnBeforeCalcTransferShipmentDate	(var Record Requisition Line, var Boolean)	-