Version 2026.04

Modifications in Infor Expense Management 2026.04

CREATE TABLE alco_import_line_item (
import_line_item_id	int	NOT NULL
import_external_id	nvarchar(255)	NOT NULL
expense_category	nvarchar(255)
expense_type_id	int
payment_type_id	int
import_date	datetime
purchased_date	datetime
description	nvarchar(255)
native_amt_currency_code	nvarchar(255)
native_amt_currency_name	nvarchar(255)
native_amt_id	int
native_amt	numeric(28,10)
vat_amount_id	int
vat_amount	numeric(28,10)
vat_amt_currency_code	nvarchar(255)
purpose	nvarchar(255)
merchant_id	nvarchar(255)
vendor_code	nvarchar(255)
vendor_name	nvarchar(255)
location_code	nvarchar(255)
location_name	nvarchar(255)
city_code	nvarchar(255)
city_name	nvarchar(255)
state_code	nvarchar(255)
state_name	nvarchar(255)
country_code	nvarchar(255)
country_name	nvarchar(255)
import_status	nvarchar(255)
active_status	smallint	NOT NULL
user_id	int
raw_data	nvarchar(max)
line_item_id	int
document_tracking_number	nvarchar(255)
import_source	int
doc_id	int
flex_string_1	nvarchar(255)
flex_string_2	nvarchar(255)
flex_string_3	nvarchar(255)
flex_string_4	nvarchar(255)
flex_string_5	nvarchar(255)
flex_string_6	nvarchar(255)
flex_string_7	nvarchar(255)
flex_string_8	nvarchar(255)
flex_string_9	nvarchar(255)
flex_string_10	nvarchar(255)
is_automated	smallint NOT NULL
raw_payment_type	nvarchar(255)
CONSTRAINT PK602 PRIMARY KEY CLUSTERED (import_line_item_id)
)
go

CREATE TABLE alco_holidays (
holiday_id	int	NOT NULL
holiday_sched_name	_id int
holiday_name	nchar(40)
holiday_date	datetime
holiday_active_status	int	NOT NULL
change_timestamp	datetime
project_number_id	int
CONSTRAINT PK__alc00200768 PRIMARY KEY CLUSTERED (holiday_id)
)
go