Version 10.2.16

Modifications in Infor Expense Management 10.2.16

CREATE TABLE alwf_reviewer_list (
reviewer_list_id	int	NOT NULL
work_item_id	int	NOT NULL
user_id	int
group_id	int
reviewed	smallint	DEFAULT 0 NOT NULL
review_date	datetime
previous_reviewer_id	int
CONSTRAINT PK460 PRIMARY KEY CLUSTERED ( reviewer_list_id )
)

CREATE TABLE alcc_import_format (
cc_import_format_id	int	NOT NULL
cc_processor_id	int	NOT NULL
cc_format_name	nvarchar(255)	NOT NULL
cc_format_class_name	nvarchar(255)	NOT NULL
active_status	smallint	NOT NULL
change_timestamp	datetime
CONSTRAINT PK__alc286302EC PRIMARY KEY CLUSTERED ( cc_import_format_id )
)

CREATE TABLE alco_notice_definition (
notice_definition_id	int	NOT NULL
notice_identifier	nchar(10)
notice_title	nvarchar(255)	NOT NULL
notice_subject	nvarchar(255)	NOT NULL
notice_message	nvarchar(max)
notice_short_msg	nvarchar(220)
notice_active_status	smallint	NOT NULL
notice_description	nvarchar(255)
title_user_editable	int
change_timestamp	datetime
CONSTRAINT PK384 PRIMARY KEY CLUSTERED ( notice_definition_id )
)

CREATE TABLE alco_olbtobob_mapper (
olbtobob_mapper_id	int	NOT NULL
agency_id	int	NOT NULL
bus_obj_type_id	int	NOT NULL
agency_element_value	nvarchar(255)	NOT NULL
bob_uid	int	NOT NULL
change_timestamp	datetime
CONSTRAINT PK488 PRIMARY KEY CLUSTERED ( olbtobob_mapper_id )
)

CREATE TABLE altr_travel_item (
tr_item_type_id	int	NOT NULL
expense_type_id	int	NOT NULL
tr_item_label	nvarchar(255)	NOT NULL
tr_item_icon	nvarchar(255)
travel_category_id	int	NOT NULL
daily_rate_based	smallint	NOT NULL
taxable	smallint	NOT NULL
use_average_cost	smallint
active_status	smallint	NOT NULL
short_label	nvarchar(255)
default_offline_perdiem_amt_id	int
default_offline_perdiem_amt	numeric(28,10),
perdiem_subtype	smallint
pd_definition_id	int
include_last_day	smallint	DEFAULT 0 NOT NULL
instructions	nvarchar(max)
change_timestamp	datetime
CONSTRAINT PK__alt370627FE PRIMARY KEY CLUSTERED ( tr_item_type_id )
)

CREATE TABLE aler_overage (
overage_id	int	NOT NULL
parent_id	int	NOT NULL
overage_date	datetime	NOT NULL
total_actual_amount	numeric(28,10)
total_actual_amount_id	numeric(28,10)
total_actual_amount_id	int
total_perdiem_amount	numeric(28,10)
total_perdiem_amount_id	int
gl_account	nvarchar(255)
overage_group_id	int	NOT NULL
total_personal_amount	numeric(28,10)
total_personal_amount_id	int
overage_end_date	datetime
external_tracking_numbers	nvarchar(255)
CONSTRAINT PK307 PRIMARY KEY CLUSTERED ( overage_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
CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED ( user_id )
)

CREATE TABLE aler_expense_line_item (
exp_line_item_id	int	NOT NULL
parent_id	int
payment_type_id	int
expense_type_id	int
vendor_id	int
currency_fmt_defn_id	int
cc_transaction_id	int
cct_reference	nvarchar(255)
expense_item_date	datetime
expense_description	nvarchar(255)
erli_amt_paid_id	int
erli_amt_paid	numeric(28,10)
erli_native_amt_id	int
erli_native_amt	numeric(28,10)
purpose_id	int
odometer_start	numeric(15,5)
odometer_end	numeric(15,5)
miles	numeric(15,5)
reimburs_rate	float
erli_exch_rate	numeric(26,16)
exp_item_note	nchar(5)
item_gl_code	nchar(20)
erli_amt_approv_id	int
erli_amt_approv	numeric(28,10)
item_overridden	smallint
has_receipt	smallint
receipt_checked	smallint
is_approved	smallint
tr_number	nvarchar(255)
location_id	int
chg_allocation_option	smallint
chg_balancing_option	smallint
is_personal	smallint
is_itemized	smallint
is_itemization	smallint
has_notes	smallint
use_euro	smallint
doc_based_allocation	smallint
perdiem_amount_id	int
perdiem_amount	numeric(28,10)
hh_transaction_id	int
recurring_id	int
recurring_count	int
exch_rate_default	numeric(26,16)
expense_account_id	int
vat_account_id	int
td_amount_id	int
td_amount	numeric(28,10)
ntd_amount_id	int
ntd_amount	numeric(28,10)
vat_amount_id	int
vat_amount	numeric(28,10),
approved_exchange_rate	numeric(26,16)
vat_amount_override	numeric(28,10)
vat_amount_override_id	int
vat_miles_override	numeric(15,5)
vat_guests_override	int
expense_item_depart_date	datetime
origin_airport	nvarchar(10)
dest_airport	nvarchar(10)
booking_agent	int
ticket_status	int
ticket_number	nvarchar(50)
car_rental_agreement	nvarchar(50)
airline_class_of_service	int
car_class_of_service	int
hotel_class_of_service	int
is_vat_receipt	smallint
mileage_rate_id	int
mileage_passenger_num	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
pst_amount	numeric(28,10)
pst_amount_id	int
pst_amount_override	numeric(28,10)
pst_amount_override_id	int
vat_unclaimed_amount	numeric(28,10)
vat_unclaimed_amount_id	int
pst_unclaimed_amount	numeric(28,10)
pst_unclaimed_amount_id	int
guest_count	int
flex_field_string_1	nvarchar(255)
flex_field_string_2	nvarchar(255)
flex_field_string_3	nvarchar(255)
flex_field_string_4	nvarchar(255)
flex_field_integer_1	int
flex_field_integer_2	int
flex_field_date_1	datetime
flex_field_date_2	datetime
flex_field_amount_1	numeric(28,10)
flex_field_amount_1_id	int
flex_field_amount_2	numeric(28,10)
flex_field_amount_2_id	int
flex_field_location_1_id	int
flex_field_ddlb_1_id	int
flex_field_ddlb_2_id	int
flex_field_ddlb_3_id	int
flex_field_ddlb_4_id	int
flex_field_ddlb_5_id	int
is_quick_item	smallint
quick_item_error	smallint
mileage_route_id	int
original_vat_account_id	int
commute_miles	numeric(26,16)
guest_entry_mode	smallint	DEFAULT 0 NOT NULL
guest_amounts_equal	smallint	DEFAULT 1 NOT NULL
airline_domestic_or_intl	int
guest_no_show_count	int
passenger_name	nvarchar(255)
creator_client_type	int
round_trip	smallint
end_date	datetime
export_status	int
void_status	int
reversal_line_item_id	int
original_location	nvarchar(255)
dest_location	nvarchar(255)
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id )
)