Version 10.2.4

Modifications in Infor Expense Management 10.2.4

CREATE TABLE alco_user_preference (
user_pref_id	int	NOT NULL
user_id	int	NOT NULL
ccard_id	int
backup_prompt_freq	nvarchar(255)
toolbar_icons	nvarchar(255)
show_list_on_entry	smallint
auto_complete_flds	smallint
cct_filter_status	smallint
cct_filter_period	smallint
cct_filter_startdate	datetime
cct_filter_enddate	datetime
cct_filter_transaction_type	nvarchar(255)
cct_filter_card_name	nvarchar(255)
cct_filter_er_title	nvarchar(255)
cct_filter_er_Id	nvarchar(255)
wf_filter_status	smallint
wf_filter_er_created_beg	datetime
wf_filter_er_created_end	datetime
wf_filter_er_modified_beg	datetime
wf_filter_er_modified_end	datetime
wf_filter_er_queued_beg	datetime
wf_filter_er_queued_end	datetime
wf_filter_owner_option	smallint
wf_filter_activity_option	smallint
wf_filter_type_option	smallint
wf_filter_owner_fld	nvarchar(255)
wf_filter_activity_fld	nvarchar(255)
wf_filter_type_fld	nvarchar(255)
proxy_can_submit	smallint NOT NULL
route_to	nvarchar(max)
change_timestamp	datetime
default_currency_id	int
proxy_reviewer_can_submit	smallint	DEFAULT 0 NOT NULL
privacy_datetime_agreed	datetime
mobile_privacy_agreed	datetime
affirm_privacy_agreed	datetime
CONSTRAINT PK__alc51300E55 PRIMARY KEY CLUSTERED ( user_pref_id ) )

CREATE TABLE alob_online_booking_line_item (
olb_line_item_id	int
online_booking_data_id	int
expense_type	nvarchar(255)	NOT NULL
vendor_code	nvarchar(255)
vendor_name	nvarchar(255)
location_code	nvarchar(255)
location_name	nvarchar(255)
olb_date	datetime
olb_description	nvarchar(255)
olbli_native_amt_currency_code	nvarchar(255)
olbli_native_amt_currency_name	nvarchar(255)
olbli_native_amt	nvarchar(255)	NOT NULL
purpose	nvarchar(255)
origin_airport_code	nvarchar(255)
origin_airport_name	nvarchar(255)
dest_airport_code	nvarchar(255)
dest_airport_name	nvarchar(255)
ticket_status	nvarchar(255)
ticket_number	nvarchar(255)
airline_class_of_service_code	nvarchar(255)
airline_class_of_service_name	nvarchar(255)
route	nvarchar(255)
car_class_of_service_code	nvarchar(255)
car_class_of_service_name	nvarchar(255)
hotel_class_of_service_code	nvarchar(255)
hotel_class_of_service_name	nvarchar(255)
hotel_arrival_date	datetime
hotel_departure_date	datetime
city_code	nvarchar(255)
city_name	nvarchar(255)
state_code	nvarchar(255)
state_name	nvarchar(255)
country_code	nvarchar(255)
country_name	nvarchar(255)
departure_date	datetime
transaction_type	int
CONSTRAINT PK490 PRIMARY KEY CLUSTERED ( olb_line_item_id ) )

CREATE TABLE alcc_transaction (
cc_transaction_id	int	NOT NULL
ccard_id	int	NOT NULL
merchant_id	int
currency_fmt_defn_id	int
cct_reference	nvarchar(255)
cct_type	smallint
cct_amt_us_id	int
cct_amt_us	numeric(28,10)	NOT NULL
cct_posting_date	datetime	NOT NULL
cct_date	datetime
vat_amt_native_id	int
vat_amt_native	numeric(28,10)
cct_amt_native_id	int
cct_amt_native	numeric(28,10)
cct_currency_code	nchar(3)
cct_active_status	smallint	NOT NULL
cct_import_timestamp	datetime
external_system_id	nvarchar(255)
offline_user_id	int
doc_date_offlined	datetime
er_doc_id	int
location_id	int
expense_type_id	int
cct_description	nvarchar(255)
cc_transaction_detail_id	int
change_timestamp	datetime
cct_status_int	int
cct_sequence_number	int
cct_statement_date	datetime
primary_iso_currency_code	nchar(3)
market_code	nvarchar(50)
global_client_origin_id	nvarchar(50)
local_country_iso_code	nchar(3)
CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED ( cc_transaction_id ) )