Version 10.2.20

Modifications in 10.2.20

CREATE TABLE alex_fx_rate (
currency_ekey	nvarchar(255)	NOT NULL
valid_date	datetime	NOT NULL
fx_rate	numeric(28,10)	NOT NULL
fx_source_ekey	nvarchar(255)
CONSTRAINT pk__ale336aa144 PRIMARY KEY CLUSTERED ( currency_ekey valid_date ) - This entry is removed
)

CREATE TABLE alex_import_er_line_item (
external_key	nvarchar(255)	NOT NULL
user_ekey	nvarchar(255)	NOT NULL
import_status	smallint	DEFAULT 1 NOT NULL
import_error_message	nvarchar(255)
import_change_timestamp	datetime
parent_type	smallint	DEFAULT 0 NOT NULL
parent_ekey	nvarchar(255)
payment_type_id_ekey	nvarchar(255)
expense_type_id_ekey	nvarchar(255)
vendor_id_ekey	nvarchar(255)
currency_fmt_defn_id_ekey	nvarchar(255)
cc_transaction_id_ekey	nvarchar(255)
expense_item_date	datetime
expense_description	nvarchar(255)
erli_native_amt_id_ekey	nvarchar(255)
erli_native_amt	numeric(28,10)
purpose_id_ekey	nvarchar(255)
odometer_start	numeric(15,5)
odometer_end	numeric(15,5)
miles	numeric(15,5)
reimburs_rate	float
erli_exch_rate	numeric(26,16)
item_gl_code	nchar(20)
erli_amt_approv_id_ekey	nvarchar(255)
erli_amt_approv	numeric(28,10)
has_receipt	smallint
receipt_checked	smallint
location_id_ekey	nvarchar(255)
is_personal	smallint
approved_exchange_rate	numeric(26,16)
vat_amount_override	numeric(28,10)
vat_amount_override_id_ekey	nvarchar(255)
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_ekey	nvarchar(255)
ticket_status_ekey	nvarchar(255)
ticket_number	nvarchar(50)
car_rental_agreement	nvarchar(50)
airline_class_of_service_ekey	nvarchar(255)
car_class_of_service_ekey	nvarchar(255)
hotel_class_of_service_ekey	nvarchar(255)
mileage_rate_id_ekey	nvarchar(255)
mileage_passenger_num	int
pst_amount_override	numeric(28,10)
pst_amount_override_id_ekey	nvarchar(255)
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_ekey	nvarchar(255)
flex_field_amount_2	numeric(28,10)
flex_field_amount_2_id_ekey	nvarchar(255)
flex_field_location_1_id_ekey	nvarchar(255)
flex_field_ddlb_1_id_ekey	nvarchar(255)
flex_field_ddlb_2_id_ekey	nvarchar(255)
flex_field_ddlb_3_id_ekey	nvarchar(255)
flex_field_ddlb_4_id_ekey	nvarchar(255)
flex_field_ddlb_5_id_ekey	nvarchar(255)
mileage_route_id_ekey	nvarchar(255)
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)
keyword_alloc_cost_center_ekey	nvarchar(255)
keyword_alloc_project_num_ekey	nvarchar(255)
keyword_guest_ekeys	nvarchar(max)
keyword_note	nvarchar(max)
imported_read_only	smallint
CONSTRAINT PK_alt3CBF0154ERLI PRIMARY KEY CLUSTERED ( external_key )
)

CREATE TABLE alex_import_pr_line_item (
external_key	nvarchar(255)	NOT NULL
user_ekey	nvarchar(255)	NOT NULL
import_status	smallint	DEFAULT 1 NOT NULL
import_error_message	nvarchar(255)
import_change_timestamp	datetime
parent_type	smallint	DEFAULT 0 NOT NULL
parent_ekey	nvarchar(255)
item_number	nvarchar(255)
item_description	nvarchar(255)
invoiced_quantity	int
unit_of_measure_id_ekey	nvarchar(255)
unit_price_amount	numeric(28,10)
unit_price_amount_id_ekey	nvarchar(255)
check_request_type_id_ekey	nvarchar(255)
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
keyword_alloc_cost_center_ekey	nvarchar(255)
keyword_alloc_project_num_ekey	nvarchar(255)
keyword_guest_ekeys	nvarchar(max)
keyword_note	nvarchar(max)
imported_read_only	smallint
CONSTRAINT PK142 PRIMARY KEY CLUSTERED ( external_key )
)

CREATE TABLE alex_import_tp_line_item (
external_key	nvarchar(255)	NOT NULL
user_ekey	nvarchar(255)	NOT NULL
import_status	smallint	DEFAULT 1 NOT NULL
import_error_message	nvarchar(255)
import_change_timestamp	datetime
parent_type	smallint	DEFAULT 0 NOT NULL
parent_ekey	nvarchar(255)
tr_item_type_id_ekey	nvarchar(255)	NOT NULL
tax_cost_id_ekey	nvarchar(255)
tax_cost	numeric(28,10)
purpose_ekey	nvarchar(255)
vendor_ekey	nvarchar(255)
from_location_ekey	nvarchar(255)
from_date	datetime
from_time	datetime
to_location_ekey	nvarchar(255)
to_date	datetime
to_time	datetime
class_of_service_ekey	nvarchar(255)
cust_def_1	nvarchar(255)
cust_def_2	nvarchar(255)
cust_def_3	nvarchar(255)
daily_rate_native_id_ekey	nvarchar(255)
daily_rate_native	numeric(28,10)
currency_fmt_defn_id_ekey	nvarchar(255)
exch_rate	numeric(26,16)
miles	numeric(15,5)
reimburse_rate	float
guest_count	int
guest_entry_mode	smallint	DEFAULT 0 NOT NULL
guest_amounts_equal	smallint	DEFAULT 1 NOT NULL
guest_no_show_count	int
keyword_guest_ekeys	nvarchar(max)
keyword_note	nvarchar(max)
imported_read_only	smallint
CONSTRAINT PK144 PRIMARY KEY CLUSTERED ( external_key )
)

CREATE TABLE alex_import_ts_line_item (
external_key	nvarchar(255)	NOT NULL
user_ekey	nvarchar(255)	NOT NULL
import_status	smallint	DEFAULT 1 NOT NULL
import_error_message	nvarchar(255)
import_change_timestamp	datetime
parent_type	smallint	DEFAULT 0 NOT NULL
parent_ekey	nvarchar(255)
project_number_id_ekey	nvarchar(255)
ts_date	datetime	NOT NULL
ts_hours	numeric(14,4)
hourly_charge_type_id_ekey	nvarchar(255)
charge_type_id_ekey	nvarchar(255)
ts_start_time	datetime
ts_end_time	datetime
location_id_ekey	nvarchar(255)
charge_role_id_ekey	nvarchar(255)
app_ts_hours	numeric(14,4)
app_hourly_charge_type_id_ekey	int
ts_billable_rate	numeric(28,10)
ts_billable_rate_id_ekey	nvarchar(255)
currency_fmt_defn_id_ekey	nvarchar(255)
cost_center_id_ekey	nvarchar(255)
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)
keyword_note	nvarchar(max)
imported_read_only	smallint
CONSTRAINT PK135 PRIMARY KEY CLUSTERED ( external_key )
)

CREATE TABLE alex_pd_eur_rate (
perdiem_definition_ekey	nvarchar(255)	NOT NULL
location_ekey	nvarchar(255)
min_time_at_location	smallint
perdiem_per_hour	smallint
overnight_stay	smallint	NOT NULL
first_day_of_trip	smallint	NOT NULL
last_day_of_trip	smallint	NOT NULL
effective_date	datetime
rate_value	numeric(28,10)	NOT NULL
rate_currency_ekey	nvarchar(255)	NOT NULL
active_status	smallint	NOT NULL
until_date	datetime
)

CREATE TABLE alex_user (
external_key	nvarchar(255)	NOT NULL
employee_number	nvarchar(255)
cost_center_ekey	nvarchar(255)	NOT NULL
user_first_name	nvarchar(255)	NOT NULL
user_middle_initial	nvarchar(1)
user_last_name	nvarchar(255)	NOT NULL
user_password	nvarchar(255)	NOT NULL
user_title	nvarchar(255)
user_location_name	nvarchar(255)
user_telephone	nvarchar(255)
user_mailstop	nvarchar(255)
user_email_address	nvarchar(255)
user_email_product	nvarchar(255)
user_login_name	nvarchar(255)	NOT NULL
fax_number	nvarchar(255)
payroll_system_code	nvarchar(255)
active_status	smallint	NOT NULL
user_ssn	nvarchar(40)
currency_ekey	nvarchar(255)	NOT NULL
country_ekey	nvarchar(255)
default_approver_user_ekey	nvarchar(255)
creation_date	datetime	NOT NULL
credit_card_ekey	nvarchar(255)
credit_card_number	nvarchar(40)
cc_processor_ekey	nvarchar(255)
cc_payment_type_ekey	nvarchar(255)
set_of_books_ekey	nvarchar(255)
auth_amount	numeric(28,10)
auth_amount_currency_ekey	nvarchar(255)
pr_auth_amount	numeric(28,10)
pr_auth_amount_currency_ekey	nvarchar(255)
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
out_of_office	smallint	NOT NULL
proxy_can_submit	smallint
audit_group_ekey	nvarchar(255)
is_html_client_user	smallint NOT NULL
second_currency_ekey	nvarchar(255)
proxy_reviewer_can_submit	smallint
commute_miles	numeric(26,16)
identity2	nvarchar(36)
preferred_timezone	nvarchar(255)
user_email_address_2	nvarchar(255)
user_email_address_3	nvarchar(255)
preferred_locale	nvarchar(255)
fx_source_ekey	nvarchar(255)
CONSTRAINT pk__al1367e606 PRIMARY KEY CLUSTERED ( external_key )
)