Changes to indices in Transaction Tables

This chapter lists the new and modified indices in the Infor Expense Management application.

Version 10.2.0

These indices are modified in version 10.2.0:

  • CREATE INDEX IDX_OVERAGE_LINES_OVERAGE_ID ON aler_overage_lines(overage_id)
  • CREATE INDEX IDX_WI_HISTORY_TIME_MODIFIED ON alwf_wi_history(time_modified)

Version 10.2.4

This index is added in version 10.2.4:
  • CREATE UNIQUE INDEX uniqueBkgProcessId__IDX ON alco_background_process_status(bkg_process_id);

Version 10.2.6

This index is added in version 10.2.6:

  • CREATE UNIQUE INDEX idx_import_li_external_id ON alco_import_line_item (import_external_id);

Version 10.2.13

This index is added in version 10.2.13:

  • CREATE INDEX idx_user_login_active_status ON alco_user ( user_login ASC, active_status ASC )

Version 10.2.16

These indices are added in version 10.2.16:

  • CREATE INDEX idx_wi_hist_rev_list_id ON alwf_wi_history_reviewers ( wi_history_id ASC )
  • CREATE INDEX idx_wi_hist_rev_user_id ON alwf_wi_history_reviewers ( user_id ASC )
  • CREATE INDEX idx_wi_hist_rev_grp_id ON alwf_wi_history_reviewers ( group_id ASC )

Version 10.2.17

This index is added in version 10.2.17:

CREATE INDEX IDX_WI_HISTORY_TRANSITION_ID ON alwf_wi_history (transition_id, work_item_id, author_user_id, time_modified, proxy);

Version 10.2.18

This index is added in version 10.2.18:

CREATE UNIQUE INDEX XAK1alco_user ON alco_user (identity2) where identity2 is not null;

Version 10.2.19

These indices are added in version 10.2.19:

CREATE INDEX alco_etl_table_modified__IDX ON alco_etl_table_modified ( table_name ASC ).

Version 10.2.20

This index is added in version 10.2.20:

CREATE INDEX idx_rate_source_id ON alco_fx_rate ( fx_rate_source_id ASC )

This index is modified in 10.2.20:

CREATE UNIQUE INDEX XAK1alc_fx_rate ON

alco_fx_rate (

fx_rate_source_id

ASC,

valid_date

ASC,

currency_fmt_defn_id

ASC )

Version 2022.01

This index is added in version 2022.01:

CREATE INDEX IDX_NOTIFICATION_TRACK_WI ON

alco_notification_tracking ( work_item_id ASC )

This index is modified in version 2022.01

CREATE UNIQUE INDEX XAK1alclcc_card ON

alcc_card ( ccard_account ASC,

cardholder_id ASC )

Version 2022.05

CREATE INDEX XIF801admin_log ON

alat_admin_log ( admin_log_date ASC )

go

Version 2022.09

These indices are added in version 2022.09

  • CREATE INDEX idx_fmt_defn_id_valid_date ON

    alco_fx_rate ( currency_fmt_defn_id ASC,

    valid_date ASC )

    go

  • CREATE INDEX IX_MESSAGE_TENANT_INBOX ON

    EXTN_INBOX ( MESSAGE_PROCESSED ASC,

    MESSAGE_TENANT ASC )

    go

  • CREATE INDEX IX_MESSAGE_TENANT_OUTBOX ON

    EXTN_OUTBOX ( MESSAGE_PROCESSED ASC,

    MESSAGE_TENANT ASC )

    go

Version 2023.10

CREATE INDEX IDX_XMDBTOOL_THREAD_STATUS ON

alco_xmdbtool_thread_status ( thread_id ASC,

command ASC )

WITH (DATA_COMPRESSION = PAGE);

go