Table 246 Requisition Line

Base Application, Microsoft.Inventory.Requisition

14 keys

KeyVersions
key(Key1; "Worksheet Template Name", "Journal Batch Name", "Line No.") { Clustered = true; }17-29
key(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")17-29
key(Key3; Type, "No.", "Variant Code", "Location Code", "Sales Order No.", "Planning Line Origin", "Due Date", "Drop Shipment") { IncludedFields = "Quantity (Base)"; }17-29changed in 19, 22
key(Key4; Type, "No.", "Variant Code", "Location Code", "Sales Order No.", "Order Date") { IncludedFields = "Quantity (Base)"; }17-29changed in 22
key(Key5; Type, "No.", "Variant Code", "Location Code", "Starting Date") { IncludedFields = "Quantity (Base)"; }17-29changed in 22
key(Key6; "Worksheet Template Name", "Journal Batch Name", Type, "No.", "Due Date")17-29
key(Key7; "Ref. Order Type", "Ref. Order Status", "Ref. Order No.", "Ref. Line No.")17-29
key(Key8; "Replenishment System", Type, "No.", "Variant Code", "Transfer-from Code", "Transfer Shipment Date") { IncludedFields = "Quantity (Base)"; }17-29changed in 22
key(Key9; "Order Promising ID", "Order Promising Line ID", "Order Promising Line No.")17-29
key(Key10; "User ID", "Demand Type", "Worksheet Template Name", "Journal Batch Name", "Line No.")17-29
key(Key11; "User ID", "Demand Type", "Demand Subtype", "Demand Order No.", "Demand Line No.", "Demand Ref. No.")17-29
key(Key12; "User ID", "Worksheet Template Name", "Journal Batch Name", "Line No.")17-29
key(Key13; "Worksheet Template Name", "Journal Batch Name", "Custom Sorting Order")17-29
key(Key14; "Demand Order No.", "Demand Ref. No.", "Demand Subtype", "Demand Line No.", "Demand Type") { IncludedFields = "User ID"; }new in 22