Version 2025.10

Modifications in Infor Expense Management 2025.10

CREATE TABLE alco_db_version (
db_version_id	int	NOT NULL
major_version_id	int
minor_version_id	int
major_version_label	nchar(20)
minor_version_label	nchar(20)
build_number	int
build_label	nchar(20)
patch_number	int
CONSTRAINT PK__alc59FA5E80 PRIMARY KEY CLUSTERED (db_version_id)
)

CREATE TABLE alco_user_work_item_filter (
user_work_item_filter_id	int	NOT NULL
user_id	int
date_created_after	datetime
date_created_before	datetime
date_modified_after	datetime
date_modified_before	datetime
date_entered_queue_after	datetime
date_entered_queue_before	datetime
owner_id	int
owner_id_operator	int
document_type	int
document_type_operator	int
document_title	nvarchar(255)
document_title_operator	int
activity_number	int
activity_number_operator	int
filter_flags	int
audit_indicator	nvarchar(255)
audit_indicator_operator	int
document_id	nvarchar(255)
document_id_operator	int
user_er_filter_id	int
change_timestamp	datetime
filter_type	int	DEFAULT 1 NOT NULL
date_range_type	nvarchar(20)
date_modified_range_type	nvarchar(20)
date_entered_queue_range_type	nvarchar(20)
audit_score_threshold	smallint
audit_score_status	smallint
audit_score_status_operator	smallint
country_id	int
country_id_operator	int
cost_center_id	int
cost_center_id_operator	int
purpose_id	int
purpose_id_operator	int
pr_purpose_id	int
pr_purpose_id_operator	int
CONSTRAINT PK__alc531856C7 PRIMARY KEY CLUSTERED (user_work_item_filter_id)
)

CREATE TABLE alwf_work_item (
work_item_id	int	NOT NULL
parent_work_item_id	int
business_object_id	int	NOT NULL
document_id	nvarchar(255)	NOT NULL
activity_id	int	NOT NULL
doc_priority	int
doc_is_locked	smallint	NOT NULL
session_num	int
is_suspended	smallint	NOT NULL
appl_exceptions	smallint	DEFAULT 0 NOT NULL
overrides	smallint	DEFAULT 0 NOT NULL
doc_specific	nvarchar(255)
post_label	nvarchar(255)
doc_date_created	datetime
doc_date_modified	datetime
time_entered_queue	datetime	NOT NULL
creator_user_id	int
owner_user_id	int
locked_by_user_id	int
suspended_by_user_id	int
released_by_user_id	int
proxy_user_id	int
project_number_id	int
doc_description	nvarchar(255)
bus_obj_type_id	int
offline_user_id	int
activity_number	int
doc_date_offlined	datetime
offline_special_code	int
split_count	int
recall_state	int
last_transition	int
audit_indicator	nvarchar(255)
doc_specific_indicator	datetime
change_timestamp	datetime
rejected_exceptions	int	DEFAULT 0 NOT NULL
only_one_reviewer_needed	smallint	DEFAULT 0 NOT NULL
is_exported	smallint	DEFAULT 0 NOT NULL
doc_date_submitted	datetime
audit_log int	DEFAULT 0 NOT NULL
doc_specific_amount_id	int
doc_specific_amount	numeric(28,10)
doc_purpose	nvarchar(255)
doc_approved_amount_id	int
doc_approved_amount	numeric(28,10)
encumbrance_status	nvarchar(10)
audit_score	smallint
favorite_name	nvarchar(255)
purpose_id	int
pr_purpose_id	int
CONSTRAINT PK__alw025D5595 PRIMARY KEY CLUSTERED (work_item_id)
)