Version 2026.07

Modifications in Infor Expense Management 2026.07.

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)
parent_external_id	nvarchar(255)
CONSTRAINT PK602 PRIMARY KEY CLUSTERED (import_line_item_id)
)
go

CREATE TABLE alco_user (
user_id	int	NOT NULL
cost_center_id	int
user_full_name	nvarchar(255)	NOT NULL
user_first_name	nvarchar(255)
user_middle_initial	nvarchar(255)
user_last_name	nvarchar(255)
employee_number	nvarchar(255)
user_password	nvarchar(255)	NOT NULL
user_title	nvarchar(255)
user_location	nvarchar(255)
user_telephone	nvarchar(255)
user_mailstop	nvarchar(255)
user_email_address	nvarchar(255)
email_product	nvarchar(255)
user_login	nvarchar(255)	COLLATE SQL_Latin1_General_CP1_CI_AS
user_dept_code	nvarchar(60)
user_company_code	nvarchar(60)
user_fax_number	nvarchar(255)
payroll_system_code	nvarchar(255)
active_status	smallint	NOT NULL
ssn	nvarchar(255)
creation_time	datetime	NOT NULL
currency_fmt_defn_id	int	NOT NULL
country_id	int
has_credit_cards	smallint
cc_expiration_date	datetime
pso_data	int
external_data	nvarchar(255)
set_of_books_id	int
remote_access_device_id	nvarchar(255)
auth_amount	numeric(28,10)
auth_amount_id	int
pr_auth_amount	numeric(28,10)
pr_auth_amount_id	int
system_code_1	nvarchar(255)
system_code_2	nvarchar(255)
system_code_3	nvarchar(255)
system_code_4	nvarchar(255)
system_code_5	nvarchar(255)
system_code_6	nvarchar(255)
system_code_7	nvarchar(255)
system_code_8	nvarchar(255)
start_date	datetime
end_date	datetime
system_date_1	datetime
system_date_2	datetime
office_id	int
out_of_office	smallint	DEFAULT 0 NOT NULL
change_timestamp	datetime
audit_group_id	int
default_mileage_rate_id	int
is_thin_client_user	smallint	NOT NULL
preferred_locale	nvarchar(32)
second_currency_id	int
user_email_address_2	nvarchar(255)
user_email_address_3	nvarchar(255)
commute_miles	numeric(26,16)
validation_id	nvarchar(255)
identity2	nvarchar(36)	COLLATE SQL_Latin1_General_CP1_CI_AS
preferred_timezone	nvarchar(255)
failed_login_attempts	int
audit_score	smallint
audit_score_frequent_offender	smallint
out_of_office_duration_flag	smallint
out_of_office_start_date	datetime
out_of_office_end_date	datetime
fx_rate_source_id	int
user_theme_preference	nvarchar(15)
long_user_id	nvarchar(128)
security_bod_control	nvarchar(16)
default_location_id	int
CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED (user_id)
)
go