Table 37 Sales Line

Base Application, Microsoft.Sales.Document

22 keys

KeyVersions
key(Key1; "Document Type", "Document No.", "Line No.") { Clustered = true; }17-29
key(Key2; "Document No.", "Line No.", "Document Type") { Enabled = false; }gone after 21
key(Key3; "Document Type", Type, "No.", "Variant Code", "Drop Shipment", "Location Code", "Shipment Date") { IncludedFields = "Outstanding Qty. (Base)"; }17-29changed in 22
key(Key4; "Document Type", "Bill-to Customer No.", "Currency Code", "Document No.") { IncludedFields = "Outstanding Amount", "Shipped Not Invoiced", "Outstanding Amount (LCY)", "Shipped Not Invoiced (LCY)", "Return Rcd. Not Invd. (LCY)", "Prepmt. Amount Inv. (LCY)", "Prepmt. VAT Amount Inv. (LCY)", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", "VAT %"; }17-29changed in 22, 23
key(Key5; "Document Type", Type, "No.", "Variant Code", "Drop Shipment", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", "Location Code", "Shipment Date") { Enabled = false; SumIndexFields = "Outstanding Qty. (Base)"; }gone after 21
key(Key6; "Document Type", "Bill-to Customer No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", "Currency Code", "Document No.") { Enabled = false; SumIndexFields = "Outstanding Amount", "Shipped Not Invoiced", "Outstanding Amount (LCY)", "Shipped Not Invoiced (LCY)"; }gone after 21
key(Key7; "Document Type", "Blanket Order No.", "Blanket Order Line No.")17-29
key(Key8; "Document Type", "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Outstanding Amount", "Shipped Not Invoiced", "Outstanding Amount (LCY)", "Shipped Not Invoiced (LCY)"; }17-29changed in 22
key(Key9; "Document Type", "Shipment No.", "Shipment Line No.")17-29
key(Key10; Type, "No.", "Variant Code", "Drop Shipment", "Location Code", "Document Type", "Shipment Date")17-29
key(Key11; "Document Type", "Sell-to Customer No.", "Shipment No.", "Document No.") { IncludedFields = "Outstanding Amount (LCY)"; }17-29changed in 22
key(Key12; "Job Contract Entry No.")17-29
key(Key13; "Document Type", "Document No.", "Qty. Shipped Not Invoiced") { Enabled = false; }gone after 21
key(Key14; "Document Type", "Document No.", Type, "No.") { Enabled = false; }gone after 21
key(Key15; "Recalculate Invoice Disc.")17-29
key(Key16; "Qty. Shipped Not Invoiced")17-29
key(Key17; "Qty. Shipped (Base)")17-29
key(Key18; "Shipment Date", "Outstanding Quantity")17-29
key(Key19; SystemModifiedAt)17-29
key(Key20; "Completely Shipped")new in 19
key(Key21; "Document Type", "Document No.", Type, "No.", "System-Created Entry") { IncludedFields = Quantity, "Outstanding Qty. (Base)"; }new in 22changed in 24
key(Key22; "Document No.", Type, "No.") { IncludedFields = Quantity; }new in 23