Table 39 Purchase Line

Base Application, Microsoft.Purchases.Document

17 keys

KeyVersions
key(Key1; "Document Type", "Document No.", "Line No.") { Clustered = true; }17-29
key(Key3; "Document Type", Type, "No.", "Variant Code", "Drop Shipment", "Location Code", "Expected Receipt Date") { IncludedFields = "Outstanding Qty. (Base)"; }17-29changed in 22
key(Key4; "Document Type", "Pay-to Vendor No.", "Currency Code", "Document No.") { IncludedFields = "Outstanding Amount", "Amt. Rcd. Not Invoiced", "Outstanding Amount (LCY)", "Amt. Rcd. Not Invoiced (LCY)", "Prepmt. Amount Inv. (LCY)", "Prepmt. VAT Amount Inv. (LCY)"; }17-29changed in 22, 23
key(Key7; "Document Type", "Blanket Order No.", "Blanket Order Line No.")17-29
key(Key9; "Document Type", "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "VAT Base Amount"; }17-29changed in 22, 26
key(Key10; "Document Type", "Receipt No.", "Receipt Line No.") { IncludedFields = Quantity; }17-29changed in 23
key(Key11; Type, "No.", "Variant Code", "Drop Shipment", "Location Code", "Document Type", "Expected Receipt Date")17-29
key(Key12; "Document Type", "Buy-from Vendor No.")17-29
key(Key13; "Document Type", "Job No.", "Job Task No.", "Document No.") { IncludedFields = "Outstanding Amt. Ex. VAT (LCY)", "A. Rcd. Not Inv. Ex. VAT (LCY)"; }17-29changed in 22
key(Key16; "Recalculate Invoice Disc.")17-29
key(Key18; "Location Code", "Quantity Invoiced")17-29
key(Key19; "Completely Received") { IncludedFields = Type, "Location Code"; }new in 21changed in 22
key(Key20; "Document Type", "Document No.", "Drop Shipment") { IncludedFields = Quantity; }new in 22
key(Key21; "Document Type", "Document No.", Type, "No.", "System-Created Entry") { IncludedFields = Quantity, "Outstanding Quantity", "Return Qty. Shipped", "Quantity Received", "Line Amount", Amount, "Amount Including VAT", "Inv. Discount Amount"; }new in 22
key(Key22; "Document Type", "Document No.", "VAT Identifier", "Line No.") { IncludedFields = "VAT %", "Tax Area Code", "Tax Group Code", "VAT Calculation Type", "Line Amount", "Inv. Discount Amount", Amount, "Amount Including VAT", "Quantity (Base)", "VAT Difference"; }new in 22
key(Key23; "Attached to Line No.")new in 22
key(Key24; "No.", Type)new in 23