Version 10.2.21

Modifications in Infor Expense Management 10.2.21

CREATE TABLE albr_br_violation(
brv_id	int	NOT NULL
brv_message	nvarchar(4000)
brv_severity	int
brv_bob_type_elem	nvarchar(255)
brv_bob_uid_elem	nvarchar(255)
brv_fixed	nchar(8)
brv_rule_id	int
brv_is_approved	smallint
doc_id	int
brv_explanation	nvarchar(max)
doc_type	int
brv_bob_uid	int
change_timestamp	datetime
review_policy_id	int
online_only_violation	smallint
brv_message_parameters	nvarchar(4000)
CONSTRAINT PK__alb0F975522 PRIMARY KEY CLUSTERED(brv_id)
)

CREATE TABLE alco_audit_list(
audit_list_id	int	NOT NULL
work_item_id	int
user_id	int	NOT NULL
notes	nvarchar(255)
reason	nvarchar(40)
change_timestamp	datetime
active_status	smallint	DEFAULT 1 NOT NULL
audit_score_user	smallint
CONSTRAINT PK_HIT_LIST PRIMARY KEY CLUSTERED(audit_list_id)
)

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

CREATE TABLE alco_cost_center_config(
cost_center_config_id	int	NOT NULL
segment_count	int	NOT NULL
segment_separator	nvarchar(10)	NOT NULL
active_status	int
review_segment_label	nvarchar(255)
review_segment_display_element	nvarchar(80)
segment1_code	nvarchar(60)
segment1_label	nvarchar(255)
segment1_display_element	nvarchar(80)
segment2_label	nvarchar(255)
segment2_display_element	nvarchar(80)
segment2_optional	smallint	DEFAULT 0 NOT NULL
segment3_label	nvarchar(255)
segment3_display_element	nvarchar(80)
segment3_optional	smallint	DEFAULT 0 NOT NULL
segment4_label	nvarchar(255)
segment4_display_element	nvarchar(80)
segment4_optional	smallint	DEFAULT 0 NOT NULL
segment5_label	nvarchar(255)
segment5_display_element	nvarchar(80)
segment5_optional	smallint	DEFAULT 0 NOT NULL
segment6_label	nvarchar(255)
segment6_display_element	nvarchar(80)
segment6_optional	smallint	DEFAULT 0 NOT NULL
segment7_label	nvarchar(255)
segment7_display_element	nvarchar(80)
segment7_optional	smallint	DEFAULT 0 NOT NULL
segment8_label	nvarchar(255)
segment8_display_element	nvarchar(80)
segment8_optional	smallint	DEFAULT 0 NOT NULL
segment9_label	nvarchar(255)
segment9_display_element	nvarchar(80)
segment9_optional	smallint	DEFAULT 0 NOT NULL
change_timestamp	datetime
segment2_hidden	smallint	DEFAULT 0 NOT NULL
segment3_hidden	smallint	DEFAULT 0 NOT NULL
segment4_hidden	smallint	DEFAULT 0 NOT NULL
segment5_hidden	smallint	DEFAULT 0 NOT NULL
segment6_hidden	smallint	DEFAULT 0 NOT NULL
segment7_hidden	smallint	DEFAULT 0 NOT NULL
segment8_hidden	smallint	DEFAULT 0 NOT NULL
segment9_hidden	smallint	DEFAULT 0 NOT NULL
CONSTRAINT PK536 PRIMARY KEY CLUSTERED(cost_center_config_id)
)

CREATE TABLE alco_cumulative_miles (
cumulative_mileage_id	int	NOT NULL
user_id	int	NOT NULL
period_id	int	NOT NULL
cumulative_miles	numeric(15,5)
change_timestamp	datetime
expense_type_id	int
CONSTRAINT PK446 PRIMARY KEY CLUSTERED ( cumulative_mileage_id )
)

CREATE TABLE alco_department (
department_id	int	NOT NULL
division_id	int
department_name	nvarchar(255)
department_code	nchar( 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	nchar( 60 )
division_active_status	smallint
change_timestamp	datetime
CONSTRAINT PK__alc5DCAEF64 PRIMARY KEY CLUSTERED ( division_id )
)

CREATE TABLE alco_mileage_rate_class (
mr_class_id	int	NOT NULL
expense_type_id	int	NOT NULL
class_name	nvarchar(50)	NOT NULL
active_status	smallint	NOT NULL
implementation_class	nvarchar(255)
change_timestamp	datetime
mileage_javascript_id	int
cumulative_mile_tracking	smallint	DEFAULT 0 NOT NULL
CONSTRAINT PK442 PRIMARY KEY CLUSTERED ( mr_class_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
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)
CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED ( user_id )
)