Version 10.2.9

Modifications in Infor Expense Management 10.2.9

CREATE TABLE alco_import_line_item_link (
exp_line_item_id	int	NOT NULL
import_line_item_link_id	int	NOT NULL
import_item_id	int	NOT NULL
confirm	smallint	NOT NULL
tracking_num	nvarchar(255)	NOT NULL
change_timestamp	datetime
CONSTRAINT PK604 PRIMARY KEY CLUSTERED ( import_line_item_link_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	nchar(10)
user_company_code	nchar(10)
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
CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED ( user_id ) )

CREATE TABLE alco_installed_application (
app_bob_id	int	NOT NULL
app_display_string	nchar(60)
app_version_string	nchar(10)
app_build_string	nchar(20)
app_id	int	NOT NULL
business_process_id	int	NOT NULL
app_help_directory	nvarchar(255)
is_installed	nvarchar(255)	NOT NULL
expired_usage	nvarchar(255)
change_timestamp	datetime
CONSTRAINT PK__alc02FC7413 PRIMARY KEY CLUSTERED ( app_bob_id ) )