| 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 |