Table 246 Requisition Line in 21

App
Base Application

Fields, 119Keys, 13Procedures, 66Events, 110

Versions171819202122232425262728latest

Source29

Fields, 119

IdNameTypeObsolete
1Worksheet Template NameCode[10]-
2Journal Batch NameCode[10]-
3Line No.Integer-
4TypeEnum Requisition Line Type-
5No.Code[20]-
6DescriptionText[100]-
7Description 2Text[50]-
8QuantityDecimal-
9Vendor No.Code[20]-
10Direct Unit CostDecimal-
12Due DateDate-
13Requester IDCode[50]-
14ConfirmedBoolean-
15Shortcut Dimension 1 CodeCode[20]-
16Shortcut Dimension 2 CodeCode[20]-
17Location CodeCode[10]-
18Recurring MethodOption-
19Expiration DateDate-
20Recurring FrequencyDateFormula-
21Order DateDate-
22Vendor Item No.Text[50]-
23Sales Order No.Code[20]-
24Sales Order Line No.Integer-
25Sell-to Customer No.Code[20]-
26Ship-to CodeCode[10]-
28Order Address CodeCode[10]-
29Currency CodeCode[10]-
30Currency FactorDecimal-
31Reserved QuantityDecimal-
43Purchaser CodeCode[20]-
73Drop ShipmentBoolean-
480Dimension Set IDInteger-
5401Prod. Order No.Code[20]-
5402Variant CodeCode[10]-
5403Bin CodeCode[20]-
5404Qty. per Unit of MeasureDecimal-
5405Qty. Rounding PrecisionDecimal-
5406Qty. Rounding Precision (Base)Decimal-
5407Unit of Measure CodeCode[10]-
5408Quantity (Base)Decimal-
5431Reserved Qty. (Base)Decimal-
5520Demand TypeInteger-
5521Demand SubtypeOption-
5522Demand Order No.Code[20]-
5525Demand Line No.Integer-
5526Demand Ref. No.Integer-
5527StatusOption-
5530Demand DateDate-
5532Demand QuantityDecimal-
5533Demand Quantity (Base)Decimal-
5538Needed QuantityDecimal-
5539Needed Quantity (Base)Decimal-
5540ReserveBoolean-
5541Qty. per UOM (Demand)Decimal-
5542Unit Of Measure Code (Demand)Code[10]-
5552Supply FromCode[20]-
5553Original Item No.Code[20]-
5554Original Variant CodeCode[10]-
5560LevelInteger-
5563Demand Qty. AvailableDecimal-
5590User IDCode[50]-
5701Item Category CodeCode[20]-
5702NonstockBoolean-
5703Purchasing CodeCode[10]-
5705Product Group CodeCode[10]Removed 15.0
Product Groups became first level children of Item Categories.
5706Transfer-from CodeCode[10]-
5707Transfer Shipment DateDate-
7000Price Calculation MethodEnum Price Calculation Method-
7002Line Discount %Decimal-
7100Blanket Purch. Order ExistsBoolean-
7110Custom Sorting OrderCode[50]-
99000750Routing No.Code[20]-
99000751Operation No.Code[10]-
99000752Work Center No.Code[20]-
99000754Prod. Order Line No.Integer-
99000755MPS OrderBoolean-
99000756Planning FlexibilityEnum Reservation Planning Flexibility-
99000757Routing Reference No.Integer-
99000882Gen. Prod. Posting GroupCode[20]-
99000883Gen. Business Posting GroupCode[20]-
99000884Low-Level CodeInteger-
99000885Production BOM Version CodeCode[20]-
99000886Routing Version CodeCode[20]-
99000887Routing TypeOption-
99000888Original QuantityDecimal-
99000889Finished QuantityDecimal-
99000890Remaining QuantityDecimal-
99000891Original Due DateDate-
99000892Scrap %Decimal-
99000894Starting DateDate-
99000895Starting TimeTime-
99000896Ending DateDate-
99000897Ending TimeTime-
99000898Production BOM No.Code[20]-
99000899Indirect Cost %Decimal-
99000900Overhead RateDecimal-
99000901Unit CostDecimal-
99000902Cost AmountDecimal-
99000903Replenishment SystemEnum Replenishment System-
99000904Ref. Order No.Code[20]-
99000905Ref. Order TypeOption-
99000906Ref. Order StatusOption-
99000907Ref. Line No.Integer-
99000908No. SeriesCode[20]-
99000909Expected Operation Cost Amt.Decimal-
99000910Expected Component Cost Amt.Decimal-
99000911Finished Qty. (Base)Decimal-
99000912Remaining Qty. (Base)Decimal-
99000913Related to Planning LineInteger-
99000914Planning LevelInteger-
99000915Planning Line OriginEnum Planning Line Origin Type-
99000916Action MessageEnum Action Message Type-
99000917Accept Action MessageBoolean-
99000918Net Quantity (Base)Decimal-
99000919Starting Date-TimeDateTime-
99000920Ending Date-TimeDateTime-
99000921Order Promising IDCode[20]-
99000922Order Promising Line No.Integer-
99000923Order Promising Line IDInteger-

Keys, 13

NameFieldsObsolete
Key1, clusteredWorksheet Template Name, Journal Batch Name, Line No.-
Key2Worksheet 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-
Key3Type, No., Variant Code, Location Code, Sales Order No., Planning Line Origin, Due Date, Drop Shipment-
Key4Type, No., Variant Code, Location Code, Sales Order No., Order Date-
Key5Type, No., Variant Code, Location Code, Starting Date-
Key6Worksheet Template Name, Journal Batch Name, Type, No., Due Date-
Key7Ref. Order Type, Ref. Order Status, Ref. Order No., Ref. Line No.-
Key8Replenishment System, Type, No., Variant Code, Transfer-from Code, Transfer Shipment Date-
Key9Order Promising ID, Order Promising Line ID, Order Promising Line No.-
Key10User ID, Demand Type, Worksheet Template Name, Journal Batch Name, Line No.-
Key11User ID, Demand Type, Demand Subtype, Demand Order No., Demand Line No., Demand Ref. No.-
Key12User ID, Worksheet Template Name, Journal Batch Name, Line No.-
Key13Worksheet Template Name, Journal Batch Name, Custom Sorting Order-

Procedures, 66

NameParametersReturnsAccessObsolete
ShowReservation()public-
ShowReservationEntries(Boolean)public-
LookupVendor(var Record Vendor, Boolean)Booleanpublic-
UpdateDescription()public-
BlockDynamicTracking(Boolean)public-
BlockDynamicTrackingOnComp(Boolean)public-
CreateDim(Integer, Code[20], Integer, Code[20])publicPending 20.0
Replaced by CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
UpdateDim(Integer, Code[20], Integer, Code[20])publicPending 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)Decimalpublic-
GetSourceCaption()Textpublic-
SetReservationEntry(var Record Reservation Entry)public-
SetReservationFilters(var Record Reservation Entry)public-
ReservEntryExist()Booleanpublic-
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)Booleanpublic-
SetResiliencyError(Text[250], Integer, Text[250])public-
FindLinesWithItemToPlan(var Record Item)Booleanpublic-
FilterLinesForReservation(Record Reservation Entry, Text, Boolean)public-
FindCurrForecastName(var Code[10])Booleanpublic-
ShowDimensions()public-
ShowTimeline(Record Requisition Line)publicPending 21.0
This procedure is discontinued because the TimelineVisualizer control has been deprecated.
GetOriginalQtyBase()Decimalpublic-
SetDropShipment(Boolean)publicPending 19.0
Replaced by Drop Shipment field.
IsDropShipment()Booleanpublic-
GetJnlBatchNameForOrderPlanning()Code[10]public-
UpdateOrderReceiptDate(DateFormula)public-
CopyFromItem()public-
ValidateFields()Booleanpublic-
CreateDim(List)public-
UpdateDim(List)public-
CreateDimFromDefaultDim()public-
LookupFromLocation(var Record Location)Booleanpublic-

Events, 110

KindNameParametersObsolete
Integration eventOnAfterCreateDim(var Record Requisition Line, Record Requisition Line)-
Integration eventOnAfterCreateDimTableIDs(var Record Requisition Line, var Integer, var Integer, var Code[20])Pending 20.0
Temporary event for compatibility
Integration eventOnAfterDeleteMultiLevel(var Record Requisition Line)-
Integration eventOnAfterDeleteRelations(var Record Requisition Line)-
Integration eventOnAfterFilterLinesWithItemToPlan(var Record Requisition Line, var Record Item)-
Integration eventOnAfterGetDirectCost(var Record Requisition Line, Integer)-
Integration eventOnAfterGetLineWithPrice(var Interface Line With Price)-
Integration eventOnAfterSetReplenishmentSystemFromPurchase(var Record Requisition Line, Record Item, Record Stockkeeping Unit)-
Integration eventOnAfterSetReplenishmentSystemFromProdOrder(var Record Requisition Line, Record Item)-
Integration eventOnSetReplenishmentSystemFromProdOrderOnAfterSetProdFields(var Record Requisition Line, Record Item, Boolean)-
Integration eventOnSetReplenishmentSystemFromProdOrderOnBeforeSetProdFields(var Record Requisition Line, Record Item, Boolean, Boolean, var Record Planning Error Log)-
Integration eventOnAfterSetReplenishmentSystemFromAssembly(var Record Requisition Line, Record Item)-
Integration eventOnAfterSetReservationFilters(var Record Reservation Entry, Record Requisition Line)-
Integration eventOnAfterTransferFromProdOrderLine(var Record Requisition Line, Record Prod. Order Line)-
Integration eventOnAfterTransferFromPurchaseLine(var Record Requisition Line, Record Purchase Line)-
Integration eventOnAfterTransferFromAsmHeader(var Record Requisition Line, Record Assembly Header)-
Integration eventOnAfterTransferFromTransLine(var Record Requisition Line, Record Transfer Line)-
Integration eventOnAfterTransferFromUnplannedDemand(var Record Requisition Line, Record Unplanned Demand)-
Integration eventOnAfterTransferToTrackingEntry(var Record Reservation Entry, Record Requisition Line)-
Integration eventOnAfterValidateShortcutDimCode(var Record Requisition Line, Record Requisition Line, Integer, var Code[20])-
Integration eventOnBeforeCopyFromItem(var Record Requisition Line, Record Item, Record Requisition Line, Integer, var Record Planning Error Log, Boolean)-
Integration eventOnBeforeCheckEndingDate(var Record Requisition Line, var Boolean, var Boolean)-
Integration eventOnBeforeDeleteMultiLevel(var Record Requisition Line)-
Integration eventOnBeforeGetDefaultBin(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeGetDirectCost(var Record Requisition Line, Record Requisition Line, Integer, Integer, Boolean, var Boolean)-
Integration eventOnBeforeLookupVendor(var Record Requisition Line, var Record Vendor, var Boolean, var Boolean, var Boolean)-
Integration eventOnBeforeLookupVendorNo(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeOnDelete(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeSetFromBinCode(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeValidateItemDescriptionAndQuantity(var Record Requisition Line, Record Vendor, var Boolean)-
Integration eventOnBeforeValidateShortcutDimCode(var Record Requisition Line, Record Requisition Line, Integer, var Code[20])-
Integration eventOnBeforeUpdateDescription(var Record Requisition Line, Integer, var Boolean)-
Integration eventOnBeforeUpdateOrderReceiptDate(var Record Requisition Line, DateFormula, var Boolean)-
Integration eventOnBeforeValidateReplenishmentSystem(var Record Requisition Line, Record Stockkeeping Unit, var Boolean)-
Integration eventOnGetLocationCodeOnBeforeUpdate(var Record Requisition Line, Integer, var Boolean)-
Integration eventOnLookupSupplyFromOnCaseReplenishmentSystemElse(var Record Requisition Line)-
Integration eventOnValidateSupplyFromOnCaseReplenishmentSystemElse(var Record Requisition Line)-
Integration eventOnUpdateDescriptionFromItem(var Record Requisition Line, Record Item)-
Integration eventOnUpdateDescriptionFromItemVariant(var Record Requisition Line, Record Item Variant)-
Integration eventOnUpdateDescriptionFromItemTranslation(var Record Requisition Line, Record Item Translation)-
Integration eventOnUpdateDescriptionFromSalesLine(var Record Requisition Line, Record Sales Line)-
Integration eventOnValidateEndingTimeOnBeforeSetDueDate(var Record Requisition Line, var Boolean)-
Integration eventOnValidateReplenishmentSystemCaseElse(var Record Requisition Line)-
Integration eventOnValidateVendorNoOnAfterGetLocationCode(var Record Requisition Line)-
Integration eventOnBeforeCopyDescriptionFromGLAcc(var Record Requisition Line, var Boolean)-
Integration eventOnAfterLookupVendorNo(var Record Requisition Line, var Record Vendor)-
Integration eventOnBeforeValidateLocationChange(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeGetLocation(var Record Requisition Line, var Record Location, Code[10], var Boolean)-
Integration eventOnAfterSetUpNewLine(var Record Requisition Line, Record Requisition Line)-
Integration eventOnTransferFromUnplannedDemandOnBeforeSetType(var Record Requisition Line)-
Integration eventOnDeleteRelationsOnBeforePlanningComponentDelete(var Record Requisition Line, var Boolean)-
Integration eventOnTransferFromUnplannedDemandOnBeforeSetStatus(var Record Requisition Line, var Record Unplanned Demand)-
Integration eventOnBeforeValidateActionMessage(var Record Requisition Line, var Record Requisition Line, var Boolean)-
Integration eventOnSetReplenishmentSystemFromProdOrderOnBeforeAssignProdFields(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeSetReplenishmentSystemFromProdOrder(var Record Requisition Line)-
Integration eventOnAfterSetSupplyDates(var Record Requisition Line)-
Integration eventOnValidateUnitofMeasureCodeOnBeforeGetDirectCost(var Record Requisition Line, var Record Item)-
Integration eventOnBeforeUpdateUnitOfMeasureCodeFromItemBaseUnitOfMeasure(var Record Requisition Line, var Record Item, var Boolean)-
Integration eventOnBeforeUpdateUnitOfMeasureCodeFromItemPurchUnitOfMeasure(var Record Requisition Line, var Record Item, var Boolean)-
Integration eventOnAfterSetDueDate(var Record Requisition Line)-
Integration eventOnAfterTransferFromActionMessage(var Record Requisition Line, var Record Action Message Entry)-
Integration eventOnAfterSetReplenishmentSystemFromTransfer(var Record Requisition Line, Record Item, Record Stockkeeping Unit, Integer)-
Integration eventOnAfterUpdateOrderReceiptDate(var Record Requisition Line, DateFormula)-
Integration eventOnBeforeInitRecordForOrderPlanning(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeValidateUnitCost(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeCalcStartingDate(var Record Requisition Line, var Code[20])-
Integration eventOnBeforeCalcEndingDate(var Record Requisition Line, var Code[20])-
Integration eventOnBeforeValidateStartingTime(var Record Requisition Line, var Boolean, var Boolean, Integer, Integer, Record Requisition Line)-
Integration eventOnBeforeValidateEndingTime(var Record Requisition Line, var Boolean, var Boolean, Integer, Integer)-
Integration eventOnSetReplenishmentSystemFromProdOrderOnBeforeProcessPlannedOrderNosField(var Record Requisition Line, var Boolean, Record Requisition Line)-
Integration eventOnLookupFromLocationOnAfterSetFilters(Record Requisition Line, var Record Location)-
Integration eventOnAfterValidateProductionBOMNo(var Record Requisition Line, Record Requisition Line, Record Production BOM Header)-
Integration eventOnAfterValidateProductionBOMVersionCode(var Record Requisition Line, Record Requisition Line, Record Production BOM Version)-
Integration eventOnBeforeCheckVendorBlocked(var Record Requisition Line, var Record Vendor, var Boolean, Integer)-
Integration eventOnBeforeValidateQuantityBase(var Record Requisition Line, var Boolean, Record Requisition Line, Integer, Integer)-
Integration eventOnValidateNoOfAfterCalcShouldValidateUnitofMeasureCode(var Record Requisition Line, Record Requisition Line, Record Item, var Boolean)-
Integration eventOnValidateQuantityOnBeforeUnitCost(var Record Requisition Line, Integer, Integer)-
Integration eventOnBeforeRunEventOnAfterCreateDimTableIDs(var Record Requisition Line, var List, var Boolean)Pending 20.0
Temporary event for compatibility
Integration eventOnAfterFilterLinesForReservation(var Record Requisition Line, var Record Reservation Entry)-
Integration eventOnAfterOnInsert(var Record Requisition Line, Record Req. Wksh. Template, Record Requisition Wksh. Name)-
Integration eventOnAfterSetRemaningQuantity(var Record Requisition Line, Record Requisition Line, Integer, Integer)-
Integration eventOnBeforeGetReservationQty(var Record Requisition Line, var Decimal, var Decimal, var Decimal, var Decimal, var Decimal, var Boolean)-
Integration eventOnValidateLocationCodeOnBeforeGetDefaultBin(Record Requisition Line, var Boolean, Record Location, Integer)-
Integration eventOnBeforeShowReservation(var Record Requisition Line, var Boolean)-
Integration eventOnAfterUpdateDim(var Record Requisition Line, List)-
Integration eventOnBeforeCheckReqWkshTmpl(var Record Requisition Line, Record Item, var Boolean)-
Integration eventOnAfterCalcEndingDate(var Record Requisition Line, Code[20])-
Integration eventOnGetDirectCostOnBeforePriceCalculation(var Record Requisition Line, var Boolean)-
Integration eventOnCalcStartingDateOnBeforeValidateOrderDate(var Record Requisition Line, var Code[20], var Boolean)-
Integration eventOnBeforeSetReplenishmentSystemFromTransfer(var Record Requisition Line, Record Item, Record Stockkeeping Unit, Integer)-
Integration eventOnBeforeCalcTransferShipmentDate(var Record Requisition Line, var Boolean)-
Integration eventOnAfterInitDefaultDimensionSources(var Record Requisition Line, var List, Integer)-
Integration eventOnAfterUpdateDescription(Record Requisition Line, Record Item, Record Item Variant, Integer)-
Integration eventOnAfterCopyFromItem(var Record Requisition Line, Record Item, Integer)-
Integration eventOnAfterSetReservationEntry(var Record Reservation Entry, Record Requisition Line)-
Integration eventOnAfterValidateFields(Record Requisition Line, Integer, Integer, var Boolean)-
Integration eventOnBeforeValidateVendorNoWithStockkeepingUnit(var Record Requisition Line, Record Stockkeeping Unit, var Boolean)-
Integration eventOnValidateStartingTimeOnBeforeSetDueDate(var Record Requisition Line, var Boolean, Record Requisition Line, Integer, Integer)-
Integration eventOnValidateReplenishmentSystemOnAfterSetStockkeepingUnit(var Record Requisition Line, var Record Stockkeeping Unit, Boolean)-
Integration eventOnDeleteMultiLevelOnAfterSetFilterReqLine2(Record Requisition Line, var Record Requisition Line)-
Integration eventOnLookupRefOrderNoOnBeforeOpenPage(var Record Requisition Line, var Boolean)-
Integration eventOnGetDimFromRefOrderLineOnBeforeSetDimSetIDTypeTransfer(Record Requisition Line, var Integer, Integer, var Boolean)-
Integration eventOnValidateCurrencyCodeOnBeforeUpdateCurrencyFactor(var Record Requisition Line, Record Currency Exchange Rate)-
Integration eventOnBeforeOnValidateShipToCode(var Record Requisition Line, var Boolean)-
Integration eventOnBeforeAssignItemUnitCostAndQuantitiesForUOM(var Record Requisition Line, Record Requisition Line, Record Item, var Boolean)-
Integration eventOnValidateQuantityOnBeforeGetDirectCost(var Record Requisition Line, Record Requisition Line, Integer)-
Integration eventOnValidateDueDateOnAfterCalcShouldExitDueDate(var Record Requisition Line, Record Requisition Line, Integer, var Boolean)-
Integration eventOnValidateVendorNoOnBeforeSetVendorItemNoFromItemVend(var Record Requisition Line, var Boolean)-
Integration eventOnValidateVendorNoOnBeforeGetDirectCost(var Record Requisition Line, Record Requisition Line, Integer)-
Integration eventOnBeforeSetPurchaserCode(var Record Requisition Line, Code[20], var Code[20], var Boolean)-