Table 5802 Value Entry

Base Application, Microsoft.Inventory.Ledger

17 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; "Item Ledger Entry No.", "Entry Type") { IncludedFields = "Invoiced Quantity", "Sales Amount (Expected)", "Sales Amount (Actual)", "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Non-Invtbl.)", "Cost Amount (Expected) (ACY)", "Cost Amount (Actual) (ACY)", "Cost Amount (Non-Invtbl.)(ACY)", "Purchase Amount (Actual)", "Purchase Amount (Expected)", "Discount Amount", "Item Charge No.", "Variance Type", "Applies-to Entry", Inventoriable; }17-29changed in 20, 23, 24, 26
key(Key3; "Item Ledger Entry No.", "Document No.", "Document Line No.") { IncludedFields = "Invoiced Quantity", "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Expected) (ACY)", "Cost Amount (Actual) (ACY)", "Entry Type", "Expected Cost", "Item Charge No."; }17-29changed in 20, 24
key(Key5; "Item No.", "Posting Date", "Item Ledger Entry Type", "Entry Type", "Variance Type", "Item Charge No.", "Location Code", "Variant Code", "Global Dimension 1 Code", "Global Dimension 2 Code", "Source Type", "Source No.") { IncludedFields = "Invoiced Quantity", "Sales Amount (Expected)", "Sales Amount (Actual)", "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Non-Invtbl.)", "Purchase Amount (Actual)", "Expected Cost Posted to G/L", "Cost Posted to G/L", "Item Ledger Entry Quantity"; }17-29changed in 20, 26, 28
key(Key6; "Document No.")17-29
key(Key7; "Item No.", "Valuation Date", "Location Code", "Variant Code", "SIFT Bucket No.") { IncludedFields = "Item Ledger Entry Type"; SumIndexFields = "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Expected) (ACY)", "Cost Amount (Actual) (ACY)", "Item Ledger Entry Quantity", "Invoiced Quantity"; }17-29changed in 19, 26
key(Key8; "Source Type", "Source No.", "Item No.", "Posting Date", "Entry Type", Adjustment, "Item Ledger Entry Type") { IncludedFields = "Discount Amount", "Cost Amount (Non-Invtbl.)", "Cost Amount (Actual)", "Cost Amount (Expected)", "Sales Amount (Actual)", "Sales Amount (Expected)", "Invoiced Quantity", "Global Dimension 1 Code", "Global Dimension 2 Code"; }17-29changed in 26, 28
key(Key9; "Item Charge No.", "Inventory Posting Group", "Item No.")17-29
key(Key10; "Capacity Ledger Entry No.", "Entry Type") { IncludedFields = "Cost Amount (Actual)", "Cost Amount (Actual) (ACY)"; }17-29changed in 20
key(Key11; "Order Type", "Order No.", "Order Line No.") { IncludedFields = "Item No.", "Valuation Date", "Item Ledger Entry Type", "Variant Code", "Location Code"; }17-29changed in 26
key(Key13; "Job No.", "Job Task No.", "Document No.")17-29
key(Key14; "Item Ledger Entry Type", "Posting Date", "Item No.", "Inventory Posting Group", "Dimension Set ID") { IncludedFields = "Invoiced Quantity", "Sales Amount (Actual)", "Purchase Amount (Actual)"; }17-29changed in 26
key(Key15; "Item Ledger Entry No.", "Valuation Date", "Posting Date") { IncludedFields = "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Expected) (ACY)", "Cost Amount (Actual) (ACY)", "Valued Quantity", "Expected Cost", "Entry Type"; }17-29changed in 20, 23, 26
key(Key16; "Location Code", "Inventory Posting Group")17-29
key(Key17; "Item Ledger Entry Type", "Order No.", "Valuation Date")17-29changed in 20
key(Key18; "Item No.", "Item Ledger Entry Type", "Order Type", "Order No.", "Order Line No.")17-29changed in 20
key(Key19; "Document No.", "Document Line No.", "Document Type") { IncludedFields = "Cost Amount (Actual)", "Entry Type"; }17-19, 23-29