Table 5093 Opportunity Entry

Base Application, Microsoft.CRM.Opportunity

8 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; "Opportunity No.")17-29
key(Key3; "Contact Company No.", "Contact No.", Active) { SumIndexFields = "Estimated Value (LCY)", "Calcd. Current Value (LCY)"; }17-29
key(Key4; "Campaign No.", Active) { SumIndexFields = "Estimated Value (LCY)", "Calcd. Current Value (LCY)"; }17-29
key(Key5; Active, "Sales Cycle Code", "Sales Cycle Stage", "Estimated Close Date") { SumIndexFields = "Estimated Value (LCY)", "Calcd. Current Value (LCY)", "Days Open"; }17-29
key(Key6; Active, "Opportunity No.") { SumIndexFields = "Estimated Value (LCY)", "Calcd. Current Value (LCY)", "Days Open"; }17-29
key(Key7; Active, "Salesperson Code", "Date of Change") { SumIndexFields = "Estimated Value (LCY)", "Calcd. Current Value (LCY)"; }17-29
key(Key8; "Close Opportunity Code")17-29