Version 2024.10

Modifications in Infor Expense Management 2024.10

CREATE TABLE alco_company (
company_id	int	NOT NULL
company_name	nvarchar(255)
company_code	nvarchar(60)
active_status	smallint	NOT NULL
full_gl_format	smallint
change_timestamp	datetime
CONSTRAINT PK__alc4CA06362 PRIMARY KEY CLUSTERED (company_id)
)

CREATE TABLE alco_department (
department_id	int	NOT NULL
division_id	int
department_name	nvarchar(255)
department_code	nvarchar(60)
dept_active_status	smallint
change_timestamp	datetime
CONSTRAINT PK__alc5BE2A6F2 PRIMARY KEY CLUSTERED (department_id)
)

CREATE TABLE alco_division (
division_id	int	NOT NULL
company_id	int
division_name	nvarchar(255)
division_code	nvarchar(60)
division_active_status	smallint
change_timestamp	datetime
CONSTRAINT PK__alc5DCAEF64 PRIMARY KEY CLUSTERED (division_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)
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)
lc_user_login AS(lower(user_login))
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 alob_online_booking (
online_booking_data_id	int	NOT NULL
change_timestamp	datetime	NOT NULL
trip_name	nvarchar(255)
purpose_code	nvarchar(255)
purpose_name	nvarchar(255)
agency_id	int
original_data	nvarchar(max)
external_key	nvarchar(255)	NOT NULL
import_datetime	datetime	NOT NULL
booking_status	int
user_id	int
import_name	nvarchar(255)
trip_record_locator	nvarchar(255)
trip_ref_id	nvarchar(255)
CONSTRAINT PK489 PRIMARY KEY CLUSTERED (online_booking_data_id)
)