Changes to Indices in Staging Tables

This chapter lists the indices added or modified in the Infor Expense Management application.

Version 10.2.0

These indices are modified in version 10.2.0:

  • CREATE INDEX idx_export_er_hdr_id ON aler_export_external_data(export_er_hdr_id)
  • CREATE INDEX idx_update_status ON aler_export_external_data(update_status)

Version 10.2.10

These indices were added in version 10.2.10:

  • CREATE INDEX idx_erdoc_user_ekey ON alex_import_er_document ( user_ekey ASC )
  • CREATE INDEX idx_erdoc_import_status ON alex_import_er_document ( import_status ASC )
  • CREATE INDEX idx_erdoc_submit_status ON alex_import_er_document ( submit_status ASC )
  • CREATE INDEX idx_erli_user_ekey ON alex_import_er_line_item ( user_ekey ASC )
  • CREATE INDEX idx_erli_import_status ON alex_import_er_line_item ( import_status ASC )
  • CREATE INDEX idx_prdoc_user_ekey ON alex_import_pr_document ( user_ekey ASC )
  • CREATE INDEX idx_prdoc_import_status ON alex_import_pr_document ( import_status ASC )
  • CREATE INDEX idx_prdoc_submit_status ON alex_import_pr_document ( submit_status ASC )
  • CREATE INDEX idx_prli_user_ekey ON alex_import_pr_line_item ( user_ekey ASC )
  • CREATE INDEX idx_prli_import_status ON alex_import_pr_line_item ( import_status ASC )
  • CREATE INDEX idx_tpdoc_user_ekey ON alex_import_tp_document ( user_ekey ASC )
  • CREATE INDEX idx_tpdoc_import_status ON alex_import_tp_document ( import_status ASC )
  • CREATE INDEX idx_tpdoc_submit_status ON alex_import_tp_document ( submit_status ASC )
  • CREATE INDEX idx_tpli_user_ekey ON alex_import_tp_line_item ( user_ekey ASC )
  • CREATE INDEX idx_tpli_import_status ON alex_import_tp_line_item ( import_status ASC )

Version 2022.09

This index is added in the version 2022.09

CREATE UNIQUE INDEX alex_xmdbtool__IDX ON

alex_xmdbtool (

table_name

ASC,

xmtype

ASC,

module

ASC,

active_status

ASC )

go

Version 2024.04

No new index added.

Version 2024.07

No new index added.

Version 2024.10

No new index added

Version 2025.01

No new index added

Version 2025.04

No new index added

Version 2025.10

No new index added