Version 10.2.20

Modifications in Infor Expense Management 10.2.20

CREATE TABLE alco_fx_rate (
fx_rate_id	int	NOT NULL
currency_fmt_defn_id	int	NOT NULL
valid_date	datetime	NOT NULL
fx_rate	numeric(28,10)
change_timestamp	datetime
fx_rate_source_id	int	NOT NULL
CONSTRAINT PK__alc787EE5A0 PRIMARY KEY CLUSTERED ( fx_rate_id )
)

CREATE TABLE alco_mileage_rate (
mileage_rate_id	int	NOT NULL
reimburs_rate	float
take_effect_date	datetime	NOT NULL
mileage_active_status	smallint
expense_type_id	int
change_timestamp	datetime
description	nvarchar(40)	NOT NULL
expiration_date	datetime
per_passenger_rate	numeric(28,10)
distance_low	int
distance_high	int
mileage_threshold	int
rate_above_threshold	numeric(28,10)
distance_unit nchar(3)	NOT NULL
currency_id	int
CONSTRAINT PK__alc0E6E26BF PRIMARY KEY CLUSTERED ( mileage_rate_id )
)

CREATE TABLE alco_notice_trigger (
notice_trigger_id	int	NOT NULL
notice_event_id	int	NOT NULL
notice_event_type	nchar(1)	NOT NULL
notice_event_parameter	nchar(1)
event_parameter_value	int
notice_definition_id	int	NOT NULL
trigger_active_status	smallint	NOT NULL
notice_exception_only_flag	smallint
notice_max_sent_count	int
notice_adjustment_flag	smallint
launch_app_attachment	smallint
notice_send_frequency	int
notice_daily_start_time	int
rejected_exception_only	smallint
deadline_type	nchar(1)
user_notice_permission	nchar(1)
deadline_date	datetime
deadline_time_zone	nvarchar(25)
deadline_day	int
notice_audit_log_flag	smallint
notice_suspend_flag	smallint
CONSTRAINT PK386 PRIMARY KEY CLUSTERED ( notice_trigger_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)
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)
is_base_amount_adjusted	smallint	DEFAULT 0 NOT NULL
export_date	datetime
imported_read_only	smallint
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id )
)

CREATE TABLE alpd_conus_oconus_perdiem (
conus_oconus_perdiem_id	int	NOT NULL
location_id	int
max_lodging_amt_id	int
max_lodging_amt	numeric(28,10)
non_govt_meals_amt_id	int
non_govt_meals_amt	numeric(28,10)
proportional_meals_amt_id	int
proportional_meals_amt	numeric(28,10)
incidental_amt_id	int
incidental_amt	numeric(28,10)
footnote_amt_id	int
footnote_amt	numeric(28,10)
footnote_rate_amt_id	int
footnote_rate_amt	numeric(28,10)
per_diem_amt_id	int
per_diem_amt	numeric(28,10)
effective_date	datetime
active_status	int	NOT NULL
change_timestamp	datetime
season_start_month	int
season_start_day	int
season_end_month	int
season_end_day	int
until_date	datetime
CONSTRAINT PK440 PRIMARY KEY CLUSTERED ( conus_oconus_perdiem_id )
)

CREATE TABLE alpd_eur_rate (
pd_rate_id	int	NOT NULL
pd_definition_id	int	NOT NULL
location_id	int
min_time_at_location	smallint
per_hour	smallint
overnight_stay	smallint
first_day_of_trip	smallint
last_day_of_trip	smallint
rate_value	numeric(28,10)	NOT NULL
rate_value_id	int	NOT NULL
effective_date	datetime
active_status	smallint	NOT NULL
change_timestamp	datetime
until_date	datetime
CONSTRAINT PK__alpdrates PRIMARY KEY CLUSTERED ( pd_rate_id )
)

CREATE TABLE alpr_invoice_line_item (
invoice_line_item_id	int	NOT NULL
invoice_id	int	NOT NULL
item_number	nvarchar(255)
item_description	nvarchar(255)
invoiced_quantity	numeric(15,5)
unit_of_measure_id	int
unit_price_amount	numeric(28,10)
unit_price_amount_id	int
total_price_amount	numeric(28,10)
total_price_amount_id	int
check_request_type_id	int
chg_allocation_option	smallint
chg_balancing_option	smallint
doc_based_allocation	smallint
is_approved	smallint
expense_account_id	int
vat_account_id	int
guest_count	int
td_gl_account_override	nvarchar(255)
td_gl_subaccount_override	nvarchar(255)
guest_entry_mode	smallint	DEFAULT 0 NOT NULL
guest_amounts_equal	smallint	DEFAULT 1 NOT NULL
guest_no_show_count	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
export_status	int
void_status	int
reversal_line_item_id	int
export_date	datetime
imported_read_only	smallint
CONSTRAINT PK457 PRIMARY KEY CLUSTERED ( invoice_line_item_id )
)

CREATE TABLE altr_line_item (
tr_line_item_id	int	NOT NULL
tr_document_id	int	NOT NULL
tr_item_type_id	int	NOT NULL
cost_id	int
cost	numeric(28,10)
tax_cost_id	int
tax_cost	numeric(28,10)
note	nvarchar(max)
purpose	int
vendor	int
from_location	int
from_date	datetime
from_time	datetime
to_location	int
to_date	datetime
to_time	datetime
class_of_service	int
daily_rate_id	int
daily_rate	numeric(28,10)
cust_def_1	nvarchar(255)
cust_def_2	nvarchar(255)
cust_def_3	nvarchar(255)
daily_rate_native_id	int
daily_rate_native	numeric(28,10)
currency_fmt_defn_id	int
exch_rate	numeric(26,16)
use_euro	smallint
miles	numeric(15,5)
reimburse_rate	float
has_notes	smallint
average_cost_id	int
average_cost	numeric(28,10)
is_imported	smallint
description1	nvarchar(255)
description2	nvarchar(255)
ext_booking_key	nvarchar(255)
exch_rate_default	numeric(26,16)
trip_type	nchar(2)
from_airport_code	nchar(3)
to_airport_code	nchar(3)
lowest_airfare	numeric(28,10)
lowest_airfare_id	int
lowest_hotel_rate	numeric(28,10)
lowest_hotel_rate_id	int
booking_source	nchar(2)
agency_name	nvarchar(40)
guest_count	int
guest_entry_mode	smallint	DEFAULT 0 NOT NULL
guest_amounts_equal	smallint	DEFAULT 1 NOT NULL
guest_no_show_count	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
mileage_route_id	int
export_status	int
void_status	int
reversal_line_item_id	int
export_date	datetime
imported_read_only	smallint
CONSTRAINT PK__alt314D4EA8 PRIMARY KEY CLUSTERED ( tr_line_item_id )
)

CREATE TABLE altr_travel_request (
tr_document_id	int	NOT NULL
user_id	int	NOT NULL
tr_title	nvarchar(255)
tr_purpose	int
tr_num_going	int
tr_date_created	datetime
tr_date_filed	datetime
tr_date_from	datetime
tr_date_to	datetime
tr_tot_air_id	int
tr_tot_air	numeric(28,10)
tr_tot_hotel_id	int
tr_tot_hotel	numeric(28,10)
tr_tot_htax_id	int
tr_tot_htax	numeric(28,10)
tr_tot_car_id	int
tr_tot_car	numeric(28,10)
tr_tot_ctax_id	int
tr_tot_ctax	numeric(28,10)
tr_tot_meals_id	int
tr_tot_meals	numeric(28,10)
tr_tot_other_id	int
tr_tot_other	numeric(28,10)
tr_total_cost_id	int
tr_total_cost	numeric(28,10)
tr_emp_comp	nvarchar(255)
tr_emp_dept	nvarchar(255)
tr_tracking_num	nvarchar(255)
doc_note	nvarchar(5)
trip_type_id	int
tr_date_approved	datetime
chg_allocation_option	smallint
chg_balancing_option	smallint
ord_key	nvarchar(255)
integration_partner_id	int
max_air_ticket_amt_id	int
max_air_ticket_amt	numeric(28,10)
itinerary_state	int
create_location_id	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
import_visibility	int
CONSTRAINT PK__alt3CBF0154 PRIMARY KEY CLUSTERED ( tr_document_id )
)

CREATE TABLE alts_line_item (
ts_line_item_id	int	NOT NULL
ts_document_id	int	NOT NULL
project_number_id	int
ts_date	datetime	NOT NULL
ts_hours	numeric(14,4)
hourly_charge_type_id	int
charge_type_id	int
ts_start_time	datetime
ts_end_time	datetime
location_id	int
charge_role_id	int
ts_note	nchar(5)
pa_export_status	int
app_ts_hours	numeric(14,4)
app_hourly_charge_type_id	int
ts_billable_rate	numeric(28,10)
ts_billable_rate_id	int
currency_fmt_defn_id	int
cost_center_id	int
change_timestamp	datetime
description	nvarchar(255)
attd_in1	datetime
attd_out1	datetime
attd_in2	datetime
attd_out2	datetime
attd_in3	datetime
attd_out3	datetime
attd_in4	datetime
attd_out4	datetime
attd_in5	datetime
attd_out5	datetime
attd_in6	datetime
attd_out6	datetime
attd_absence_hours	numeric(14,4)
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
export_status	int
void_status	int
reversal_line_item_id	int
export_date	datetime
imported_read_only	smallint
CONSTRAINT PK__alt51BA1E3A PRIMARY KEY CLUSTERED ( ts_line_item_id )
)

CREATE TABLE alwf_work_item (
work_item_id	int	NOT NULL
parent_work_item_id	int
business_object_id	int	NOT NULL
document_id	nvarchar(255)	NOT NULL
activity_id	int	NOT NULL
doc_priority	int
doc_is_locked	smallint	NOT NULL
session_num	int
is_suspended	smallint	NOT NULL
appl_exceptions	smallint	DEFAULT 0 NOT NULL
overrides	smallint	DEFAULT 0 NOT NULL
doc_specific	nvarchar(255)
post_label	nvarchar(255)
doc_date_created	datetime
doc_date_modified	datetime
time_entered_queue	datetime	NOT NULL
creator_user_id	int
owner_user_id	int
locked_by_user_id	int
suspended_by_user_id	int
released_by_user_id	int
proxy_user_id	int
project_number_id	int
doc_description	nvarchar(255)
bus_obj_type_id	int
offline_user_id	int
activity_number	int
doc_date_offlined	datetime
offline_special_code	int
split_count	int
recall_state	int
last_transition	int
audit_indicator	nvarchar(255)
doc_specific_indicator	datetime
change_timestamp	datetime
rejected_exceptions	int	DEFAULT 0 NOT NULL
only_one_reviewer_needed	smallint	DEFAULT 0 NOT NULL
is_exported	smallint	DEFAULT 0 NOT NULL
doc_date_submitted	datetime
audit_log	int	DEFAULT 0 NOT NULL
doc_specific_amount_id	int
doc_specific_amount	numeric(28,10)
doc_purpose	nvarchar(255)
doc_approved_amount_id	int
doc_approved_amount	numeric(28,10)
encumbrance_status	nvarchar(10)
audit_score	smallint
favorite_name	nvarchar(255)
CONSTRAINT PK__alw025D5595 PRIMARY KEY CLUSTERED ( work_item_id )
)