Changes to indices in Reporting Database

This index was added in Infor Expense Management 10.2.16.

• create index parent_note_entry on NOTE_ENTRY(PARENT_ID)

These indices were removed in Infor Expense Management 10.2.20

• create index activity_id_doc_act on DOCUMENT_ACTIVITY(ACTIVITY_ID)
• create index user_id_user on EXT_USER(USER_ID)
• create index location_id_location on LOCATION(LOCATION_ID)
• create index cc_id_org on ORGANIZATION(COST_CENTER_ID)
• create index user_id_user on EXT_USER(USER_ID)
• create index location_id_location on LOCATION(LOCATION_ID)
• create index cc_id_org on ORGANIZATION(COST_CENTER_ID)
• create index pn_id_proj_num on PROJECT_NUMBER(PROJECT_NUMBER_ID)
• create index doc_id_exp_rep on EXPENSE_REPORT(DOCUMENT_ID)
• create index doc_id_er_adc on EXPENSE_REPORT_ADC(DOCUMENT_ID)
• create index li_id_erli_vat on EXPENSE_REPORT_LINE_ITEM_VAT(LINE_ITEM_ID)
• create index overage_id_er_overage on EXPENSE_REPORT_OVERAGE(OVERAGE_ID)
• create index exp_type_id_exp_type on EXPENSE_TYPE(EXPENSE_TYPE_ID)
• create index pay_type_id_pay_type on PAYMENT_TYPE(PAYMENT_TYPE_ID)
• create index doc_id_ts on TIMESHEET_DOCUMENT(DOCUMENT_ID)
• create index doc_id_ts_adc on TIMESHEET_ADC(DOCUMENT_ID)
• create index li_id_tsli on TIMESHEET_LINE_ITEM(LINE_ITEM_ID)
• create index li_id_tsli_adc on TIMESHEET_LINE_ITEM_ADC(LINE_ITEM_ID)
• create index address_id_address on ADDRESS(ADDRESS_ID)
• create index li_id_prli on PURCHASE_LINE_ITEM(LINE_ITEM_ID)
• create index li_id_prli_adc on PURCHASE_LINE_ITEM_ADC(LINE_ITEM_ID)
• create index doc_id_pr on PURCHASE_REQUISITION(DOCUMENT_ID)
• create index doc_id_pr_adc on PURCHASE_REQUISITION_ADC(DOCUMENT_ID)
• create index doc_id_pr_adc on PURCHASE_TYPE(PURCHASE_TYPE_ID)
• create index vendor_id_pr_vendor on PR_VENDOR(VENDOR_ID)
• create index doc_id_tp on TRAVEL_PLAN(DOCUMENT_ID)
• create index doc_id_tp_adc on TRAVEL_PLAN_ADC(DOCUMENT_ID)
• create index li_id_tpli on TRAVEL_LINE_ITEM(LINE_ITEM_ID)
• create index li_id_tpli_adc on TRAVEL_LINE_ITEM_ADC(LINE_ITEM_ID)
• create index trav_exp_id_trav_exp_type on TRAVEL_EXPENSE_TYPE(TRAVEL_EXPENSE_ID)
• create index li_id_invli on INVOICE_LINE_ITEM(LINE_ITEM_ID)
• create index li_id_invli_adc on INVOICE_LINE_ITEM_ADC(LINE_ITEM_ID)
• create index doc_id_inv on INVOICE_DOCUMENT(DOCUMENT_ID)
• create index doc_id_inv_adc on INVOICE_DOCUMENT_ADC(DOCUMENT_ID)