Table 246 Requisition Line in 19
- App
- Base Application
Fields, 118Keys, 13Procedures, 62Events, 81
Versions171819202122232425262728latest
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, 62
| 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 | - | ||||
| UpdateDim | (Integer, Code[20], Integer, Code[20]) | public | - | ||||
| 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 | - | |||
Events, 81
| 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]) | - |
| 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 | OnValidateLocationCodeOnBeforeGetDefaultBin | (Record Requisition Line, var Boolean, Record Location) | - |
| 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) | - |