Version 2025.04

Modifications in Infor Expense Management 2025.04

CREATE TABLE alco_bobref (
table_bobid int NOT NULL
table_name nvarchar(2000) NOT NULL
table_pk nvarchar(2000) NOT NULL
client_assigned_value int NOT NULL
remapped_value int NOT NULL
alco_bobref_id int IDENTITY(1,1) NOT NULL
CONSTRAINT PK__alco_bobref PRIMARY KEY CLUSTERED (alco_bobref_id)
)
CREATE TABLE alco_datalake_modified_docs (
date_modified datetime
document_id nvarchar(255)
work_item_id int
alco_datalake_modified_docs_id int IDENTITY(1,1) NOT NULL
CONSTRAINT PK__alco_datalake_modified_docs PRIMARY KEY CLUSTERED (alco_datalake_modified_docs_id )
)
CREATE TABLE alco_etl_doc_modified (
date_range nvarchar(255)
document_id nvarchar(255)
work_item_id int
alco_etl_doc_modified_id int IDENTITY(1,1) NOT NULL
CONSTRAINT alco_etl_doc_modified_PK PRIMARY KEY CLUSTERED (alco_etl_doc_modified_id)
)
CREATE TABLE alco_etl_table_modified (
start_date datetime
end_date datetime
table_name nvarchar(255) NOT NULL
flag int
bob_id int NOT NULL
alco_etl_table_modified_id int IDENTITY(1,1) NOT NULL
CONSTRAINT PK__alco_etl_table_modified PRIMARY KEY CLUSTERED (alco_etl_table_modified_id)
)
CREATE TABLE alco_login_session (
login_session_id int NOT NULL
session_num int
login_time datetime
server nvarchar(255)
user_id int
connection_id nvarchar(255)
proxy_user_id int
infor_session_id nvarchar(255)
CONSTRAINT PK__alc0A9D95DB PRIMARY KEY CLUSTERED (login_session_id)
)
CREATE TABLE alco_published_bobs (
document_name nvarchar(255) NOT NULL
variation_id bigint NOT NULL
record_count bigint NOT NULL
start_date datetime NOT NULL
end_date datetime NOT NULL
change_timestamp datetime DEFAULT current_timestamp NOT NULL
is_datalake smallint NOT NULL
alco_published_bobs_id int IDENTITY(1,1) NOT NULL
CONSTRAINT PK__alco_published_bobs PRIMARY KEY CLUSTERED (alco_published_bobs_id)
)
CREATE TABLE alco_temp_bobid (
unloaded_bob_id int NOT NULL
table_name nvarchar(2000)
table_bobid int
column_name nvarchar(2000)
alco_temp_bobid_id int IDENTITY(1,1) NOT NULL
CONSTRAINT PK__alco_temp_bobid PRIMARY KEY CLUSTERED (alco_temp_bobid_id)
)
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 nchar(1)
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
lc_user_login AS(lower(user_login))
Note: This column now exists only in Oracle. This column has been removed from MSSQL and PostgreSQL.
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)
)
CREATE TABLE alco_xmdbtool_thread_status (
thread_id bigint NOT NULL
command nvarchar(255) NOT NULL
status nvarchar(255)
change_timestamp datetime
alco_xmdbtool_thread_status_id int IDENTITY(1,1) NOT NULL
CONSTRAINT PK__alco_xmdbtool_thread_status PRIMARY KEY CLUSTERED (alco_xmdbtool_thread_status_id )
)
CREATE TABLE almt_extension (
extension_id int
name nvarchar(255) NOT NULL
type int NOT NULL
value_int int
value_float float
value_date datetime
value_string nvarchar(510)
value_hours numeric(14,4)
value_currency_id int
value_currency numeric(28,10)
value_bobref_type int
value_bobref int
parent_id int NOT NULL
almt_extension_id int IDENTITY(1,1) NOT NULL
CONSTRAINT PK__almt_extension PRIMARY KEY CLUSTERED (almt_extension_id)
)