Table 17 G/L Entry

Base Application, Microsoft.Finance.GeneralLedger.Ledger

14 keys

KeyVersions
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