| key(Key1; "Entry No.") { Clustered = true; } | 17-29 |
| key(Key2; "G/L Account No.", "Posting Date") { IncludedFields = Amount, "Additional-Currency Amount"; SumIndexFields = Amount, "Debit Amount", "Credit Amount", "Additional-Currency Amount", "Add.-Currency Debit Amount", "Add.-Currency Credit Amount", "VAT Amount", Quantity, "Source Currency Amount", "Source Currency VAT Amount"; } | 17-29changed in 20, 24, 25 |
| key(Key3; "G/L Account No.", "Global Dimension 1 Code", "Global Dimension 2 Code", "Posting Date", "VAT Reporting Date", "Source Currency Code") { SumIndexFields = Amount, "Debit Amount", "Credit Amount", "Additional-Currency Amount", "Add.-Currency Debit Amount", "Add.-Currency Credit Amount", "VAT Amount", "Source Currency Amount", "Source Currency VAT Amount"; } | 17-29changed in 21, 24, 25 |
| key(Key4; "G/L Account No.", "Business Unit Code", "Posting Date") { Enabled = false; SumIndexFields = Amount, "Debit Amount", "Credit Amount", "Additional-Currency Amount", "Add.-Currency Debit Amount", "Add.-Currency Credit Amount"; } | 17-29 |
| key(Key5; "G/L Account No.", "Business Unit Code", "Global Dimension 1 Code", "Global Dimension 2 Code", "Posting Date") { Enabled = false; SumIndexFields = Amount, "Debit Amount", "Credit Amount", "Additional-Currency Amount", "Add.-Currency Debit Amount", "Add.-Currency Credit Amount"; } | 17-29 |
| key(Key6; "Document No.", "Posting Date") { SumIndexFields = Amount, "Debit Amount", "Credit Amount", "Additional-Currency Amount", "Add.-Currency Debit Amount", "Add.-Currency Credit Amount", "VAT Amount"; } | 17-29 |
| key(Key7; "Transaction No.") | 17-29 |
| key(Key8; "IC Partner Code") | 17-29 |
| key(Key9; "G/L Account No.", "Job No.", "Posting Date") { SumIndexFields = Amount; } | 17-29 |
| key(Key10; "Posting Date", "G/L Account No.", "Dimension Set ID") { SumIndexFields = Amount; } | 17-29 |
| key(Key11; "Gen. Bus. Posting Group", "Gen. Prod. Posting Group") | 17-29 |
| key(Key12; "VAT Bus. Posting Group", "VAT Prod. Posting Group") | 17-29 |
| key(Key13; "External Document No.", "Posting Date") { Enabled = false; } | 17-29 |
| key(Key14; "Dimension Set ID") | new in 18 |