1 ADD INDEX "XAK1FlowTask" ON "FlowTask"
2 INDEX-FIELD "ActivityStatus" ASCENDING
3 INDEX-FIELD "DueDate" ASCENDING
4 INDEX-FIELD "FlowTaskNo" ASCENDING
6 ADD INDEX "XAK2FlowTask" ON "FlowTask"
7 INDEX-FIELD "EntityType" ASCENDING
8 INDEX-FIELD "EntityCode" ASCENDING
9 INDEX-FIELD "DueDate" ASCENDING
11 ADD INDEX "XAK3FlowTask" ON "FlowTask"
12 INDEX-FIELD "ActivityStatus" ASCENDING
13 INDEX-FIELD "EntityType" ASCENDING
14 INDEX-FIELD "EntityCode" ASCENDING
15 INDEX-FIELD "DueDate" ASCENDING
17 ADD INDEX "XAK4FlowTask" ON "FlowTask"
18 INDEX-FIELD "ActivityStatus" ASCENDING
19 INDEX-FIELD "AllocatedTo" ASCENDING
20 INDEX-FIELD "DueDate" ASCENDING
21 INDEX-FIELD "FlowTaskNo" ASCENDING
23 ADD INDEX "XAK1FlowStep" ON "FlowStep"
24 INDEX-FIELD "ActivityStatus" ASCENDING
25 INDEX-FIELD "DueDate" ASCENDING
26 INDEX-FIELD "FlowTaskNo" ASCENDING
27 INDEX-FIELD "FlowStepNo" ASCENDING
29 ADD INDEX "XAK2FlowStep" ON "FlowStep"
30 INDEX-FIELD "ActivityStatus" ASCENDING
31 INDEX-FIELD "AllocatedTo" ASCENDING
32 INDEX-FIELD "DueDate" ASCENDING
33 INDEX-FIELD "FlowTaskNo" ASCENDING
34 INDEX-FIELD "StepDueDate" ASCENDING
36 ADD INDEX "XAK3FlowStep" ON "FlowStep"
37 INDEX-FIELD "ActivityStatus" ASCENDING
38 INDEX-FIELD "Contractor" ASCENDING
39 INDEX-FIELD "DueDate" ASCENDING
40 INDEX-FIELD "FlowTaskNo" ASCENDING
41 INDEX-FIELD "StepDueDate" ASCENDING
43 ADD INDEX "XAK4FlowStep" ON "FlowStep"
44 INDEX-FIELD "ActivityStatus" ASCENDING
45 INDEX-FIELD "AllocatedTo" ASCENDING
46 INDEX-FIELD "NotifyDate" ASCENDING