Version 2023.05

Modifications in Infor Expense Management 2023.05

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
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

CREATE TABLE alco_xmdbtool_pgp_keys (
xmdbtool_pgp_keys_id	int	NOT NULL
key_data	nvarchar(max)	NOT NULL
key_type	nvarchar(255)	NOT NULL
key_pass	nvarchar(max)	NOT NULL
is_active	int	NOT NULL
key_status	nvarchar(max)	NOT NULL
change_timestamp	datetime
is_kms	int	NOT NULL
encrypted_key	varbinary(max)
kms_cipher	varbinary(max)
random_number	varbinary(max)
recipient	nvarchar(255)
cc_format	nvarchar(255)
CONSTRAINT PK598 PRIMARY KEY CLUSTERED ( xmdbtool_pgp_keys_id )
)
go