Version 10.2.14

Modifications in Infor Expense Management 10.2.14


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,
CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED ( user_id ) )


CREATE TABLE alco_user_work_item_filter (
user_work_item_filter_id	int	NOT NULL,
user_id	int,
date_created_after	datetime,
date_created_before	datetime,
date_modified_after	datetime,
date_modified_before	datetime,
date_entered_queue_after	datetime,
date_entered_queue_before	datetime,
owner_id	int,
owner_id_operator	int,
document_type	int,
document_type_operator	int,
document_title	nvarchar(255),
document_title_operator	int,
activity_number	int,
activity_number_operator	int,
filter_flags	int,
audit_indicator	nvarchar(255),
audit_indicator_operator	int,
document_id	nvarchar(255),
document_id_operator	int,
user_er_filter_id	int,
change_timestamp	datetime,
filter_type	int	DEFAULT 1 NOT NULL,
date_range_type	nvarchar(20),
date_modified_range_type	nvarchar(20),
date_entered_queue_range_type	nvarchar(20),
audit_score_threshold	smallint,
audit_score_status	smallint,
audit_score_status_operator	smallint,
CONSTRAINT PK__alc531856C7 PRIMARY KEY CLUSTERED ( user_work_item_filter_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,
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_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,
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
CONSTRAINT PK__alt314D4EA8 PRIMARY KEY CLUSTERED ( tr_line_item_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
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
CONSTRAINT PK__alw025D5595 PRIMARY KEY CLUSTERED ( work_item_id )