Version 10.2.13

Modifications in Infor Expense Management 10.2.13

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

CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_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)

CONSTRAINT PK__alw025D5595 PRIMARY KEY CLUSTERED ( work_item_id )

)

CREATE TABLE alat_admin_log (
admin_log_id int NOT NULL
admin_log_date datetime NOT NULL
admin_log_user_id int
admin_log_action_id int
admin_log_data_id int
admin_log_description nvarchar(max)
admin_log_bob_type int

CONSTRAINT PK__ala09DE7BCC PRIMARY KEY CLUSTERED ( admin_log_id )

)