Version 10.2.18

Modifications in 10.2.18

CREATE TABLE aler_expense_export_line (
export_er_line_id	int	NOT NULL
export_er_hdr_id	int	NOT NULL
exli_exp_line_item_id	int	NOT NULL
export_er_line_status	smallint
export_line_status_datetime	datetime
exli_line_allocation_id	int	NOT NULL
exli_alloc_base_amt	numeric(28,10)
exli_alloc_base_amt_currency	nvarchar(10)
exli_alloc_native_amt	numeric(28, 10)
exli_alloc_native_amt_curr	nvarchar(10)
exli_expense_item_date	datetime
exli_erli_exch_rate	numeric(26, 16)
exli_alloc_percent_allotted	numeric(26, 16)
exli_alloc_cost_center_name	nvarchar(255)
exli_alloc_cost_center_code	nvarchar(255)
exli_alloc_project_code	nvarchar(255)
exli_alloc_parent_proj_code	nvarchar(255)
exli_alloc_top_project_code	nvarchar(255)
exli_line_payment_method_code	int
exli_line_is_personal_flag	smallint
exli_expense_type_label	nvarchar(255)
exli_expense_category_label	nvarchar(255)
exli_expense_gl_code	nvarchar(255)
exli_expense_category_class	smallint
exli_expense_special_code	int
exli_major_accoun t	nvarchar(255)
exli_expense_external_sysid	nvarchar(255)
exli_erli_amt_paid	numeric(28, 10)
exli_erli_native_amt	numeric(28, 10)
exli_erli_amt_paid_currency	nvarchar(10)
exli_erli_native_amt_currency	nvarchar(10)
exli_vendor_name	nvarchar(255)
exli_vendor_given_sic	nvarchar(255)
exli_purpose	nvarchar(255)
exli_expense_description	nvarchar(255)
exli_city	nvarchar(255)
exli_state	nvarchar(255)
exli_country	nvarchar(255)
exli_cc_card_number	nvarchar(255)
exli_cc_issuer	nvarchar(255)
exli_payment_type_label	nvarchar(255)
exli_alloc_project_charge_code	nvarchar(255)
exli_miles	numeric(15, 5)
exli_odometer_start	numeric(15, 5)
exli_odometer_end	numeric(15, 5)
exli_perdiem_amount	numeric(28, 10)
exli_perdiem_amount_currency	nvarchar(10)
exli_cct_reference	nvarchar(255)
exli_alloc_is_billable	smallint
exli_county	nvarchar(255)
exli_suburb	nvarchar(255)
exli_street	nvarchar(255)
alloc_base_currency_ekey	nvarchar(255)
alloc_native_currency_ekey	nvarchar(255)
alloc_cost_center_ekey	nvarchar(255)
alloc_project_ekey	nvarchar(255)
payment_type_ekey	nvarchar(255)
expense_type_ekey	nvarchar(255)
amt_paid_currency_ekey	nvarchar(255)
native_amt_currency_ekey	nvarchar(255)
vendor_ekey	nvarchar(255)
purpose_ekey	nvarchar(255)
location_ekey	nvarchar(255)
perdiem_amount_currency_ekey	nvarchar(255)
cc_transaction_id	int
expense_item_depart_date	datetime
origin_airport	nvarchar(10)
dest_airport	nvarchar(10)
booking_agent_name	nvarchar(50)
booking_agent_description	nvarchar(255)
booking_agent_ekey	nvarchar(255)
ticket_status_name	nvarchar(255)
ticket_status_ekey	nvarchar(255)
ticket_number	nvarchar(50)
car_rental_agreement	nvarchar(50)
air_service_class_code	nvarchar(4)
air_service_class_name	nvarchar(255)
air_service_class_ekey	nvarchar(255)
car_service_class_code	nvarchar(4)
car_service_class_name	nvarchar(255)
car_service_class_ekey	nvarchar(255)
hotel_service_class_code	nvarchar(4)
hotel_service_class_name	nvarchar(255)
hotel_service_class_ekey	nvarchar(255)
mileage_rate_name	nvarchar(40)
mileage_rate_ekey	nvarchar(255)
mileage_passenger_num	int
alloc_department_name	nvarchar(255)
alloc_department_code	nvarchar(255)
alloc_division_name	nvarchar(255)
alloc_division_code	nvarchar(255)
alloc_company_name	nvarchar(255)
alloc_company_code	nvarchar(255)
cc_level3_detail_id	int
guest_count	int
paid_amount	numeric(28, 10)
paid_amount_currency	nvarchar(10)
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_amt_1	numeric(28, 10)
flex_field_amt_1_currency	nvarchar(10)
flex_field_amt_2	numeric(28, 10)
flex_field_amt_2_currency	nvarchar(10)
flex_field_loc_1_ekey	nvarchar(255)
flex_field_loc_1_county	nvarchar(255)
flex_field_loc_1_state	nvarchar(255)
flex_field_loc_1_country	nvarchar(255)
flex_field_loc_1_city	nvarchar(255)
flex_field_loc_1_suburb	nvarchar(255)
flex_field_loc_1_street	nvarchar(255)
flex_field_ddlb_1_code	nvarchar(255)
flex_field_ddlb_1_value	nvarchar(255)
flex_field_ddlb_2_code	nvarchar(255)
flex_field_ddlb_2_value	nvarchar(255)
flex_field_ddlb_3_code	nvarchar(255)
flex_field_ddlb_3_value	nvarchar(255)
flex_field_ddlb_4_code	nvarchar(255)
flex_field_ddlb_4_value	nvarchar(255)
flex_field_ddlb_5_code	nvarchar(255)
flex_field_ddlb_5_value	nvarchar(255)
exli_pci_token	nvarchar(255)
alloc_segment1_name	nvarchar(255)
alloc_segment1_code	nvarchar(255)
alloc_segment2_name	nvarchar(255)
alloc_segment2_code	nvarchar(255)
alloc_segment3_name	nvarchar(255)
alloc_segment3_code	nvarchar(255)
alloc_segment4_name	nvarchar(255)
alloc_segment4_code	nvarchar(255)
alloc_segment5_name	nvarchar(255)
alloc_segment5_code	nvarchar(255)
alloc_segment6_name	nvarchar(255)
alloc_segment6_code	nvarchar(255)
alloc_segment7_name	nvarchar(255)
alloc_segment7_code	nvarchar(255)
alloc_segment8_name	nvarchar(255)
alloc_segment8_code	nvarchar(255)
alloc_segment9_name	nvarchar(255)
alloc_segment9_code	nvarchar(255)
segment_count	int
alloc_review_segment_name	nvarchar(255)
alloc_review_segment_code	nvarchar(255)
guest_entry_mode	smallint
guest_amounts_equal	smallint
guest_no_show_count	int
passenger_name	nvarchar(255)
export_status	int
void_status	int
reversal_line_item_id	int
export_date	datetime
CONSTRAINT pk__ale19aacf41 PRIMARY KEY CLUSTERED ( export_er_line_id )
)

CREATE TABLE alex_address (
external_key	nvarchar(255)	NOT NULL
address_name	nvarchar(255)	NOT NULL
location_name	nvarchar(255)
addr_line_1	nvarchar(255)
addr_line_2	nvarchar(255)
city_name	nvarchar(255)
state_ekey	nvarchar(255)
zip_code	nvarchar(20)
country_ekey	nvarchar(255)
phone_nbr	nvarchar(255)
url	nvarchar(255)
active_status	smallint	NOT NULL
company_ekey	nvarchar(255)
contact_name	nvarchar(255)
contact_email_address	nvarchar(255)
contact_phone_number	nvarchar(255)
external_sys_id	nvarchar(255)
suggest_in_map	smallint
CONSTRAINT pk300 PRIMARY KEY CLUSTERED ( external_key )
)

CREATE TABLE alex_invoice_export_line (
export_invoice_line_id	int	NOT NULL
export_invoice_hdr_id	int	NOT NULL
invoice_line_item_id	int	NOT NULL
item_number	nvarchar(255)
item_description	nvarchar(255)
item_quantity	numeric(15, 5)
unit_of_measure_code	nvarchar(255)
unit_of_measure_ekey	nvarchar(255)
unit_price	numeric(28, 10)
total_price	numeric(28, 10)
check_request_type_name	nvarchar(255)
check_request_type_ekey	nvarchar(255)
check_request_type	smallint
guest_count	int
guest_entry_mode	smallint
guest_amounts_equal	smallint
guest_no_show_count	int
export_line_status	smallint
export_line_status_datetime	datetime
export_status	int
void_status	int
reversal_line_item_id	int
export_date	datetime
CONSTRAINT PK72 PRIMARY KEY CLUSTERED ( export_invoice_line_id )
)

CREATE TABLE altr_travel_plan_export_line (
export_tr_line_id	int	NOT NULL
export_tr_hdr_id	int
extr_export_line_status	int
extr_line_status_datetime	datetime
extr_tr_line_item_id	int
extrli_item_type	nvarchar(255)
extrli_purpose	nvarchar(255)
extrli_from_date	datetime
extrli_from_time	datetime
extrli_to_date	datetime
extrli_to_time	datetime
extrli_currency_iso	nchar(3)
extrli_cost	numeric(28, 10)
extrli_tax_cost	numeric(28, 10)
extrli_daily_rate	numeric(28, 10)
extrli_native_currency_iso	nchar(3)
extrli_daily_rate_native	numeric(28, 10)
extrli_exchange_rate	numeric(28, 10)
extrli_reimburse_rate	numeric(28, 10)
extrli_average_cost	numeric(28, 10)
extrli_miles	numeric(15, 5)
extrli_description_1	nvarchar(255)
extrli_description_2	nvarchar(255)
extrli_ext_booking_key	nvarchar(255)
extrli_cust_def_1	nvarchar(255)
extrli_cust_def_2	nvarchar(255)
extrli_cust_def_3	nvarchar(255)
extrli_charge_to_string	nvarchar(255)
extrli_charge_to_code	int
extrli_alloc_base_amt	numeric(28, 10)
extrli_alloc_base_amt_iso	nvarchar(10)
extrli_alloc_native_amt	numeric(28, 10)
extrli_alloc_native_amt_iso	nvarchar(10)
extrli_alloc_exch_rate	numeric(28, 10)
extrli_alloc_percent_allotted	numeric(26, 16)
extrli_alloc_cost_center_name	nvarchar(255)
extrli_alloc_cost_center_code	nvarchar(255)
extrli_alloc_project_code	nvarchar(255)
extrli_alloc_parent_project_cd	nvarchar(255)
extrli_alloc_top_project_code	nvarchar(255)
extrli_alloc_project_num_bobid	int
extrli_aler_alloc_line_id	int
extrli_exptype_special_code	int
extrli_from_street	nvarchar(255)
extrli_from_suburb	nvarchar(255)
extrli_from_city	nvarchar(255)
extrli_from_county	nvarchar(255)
extrli_from_state	nvarchar(255)
extrli_from_country	nvarchar(255)
extrli_to_street	nvarchar(255)
extrli_to_suburb	nvarchar(255)
extrli_to_city	nvarchar(255)
extrli_to_county	nvarchar(255)
extrli_to_state	nvarchar(255)
extrli_to_country	nvarchar(255)
extrli_alloc_is_billable	smallint
travel_item_ekey	nvarchar(255)
purpose_ekey	nvarchar(255)
currency_ekey	nvarchar(255)
native_currency_ekey	nvarchar(255)
alloc_base_currency_ekey	nvarchar(255)
alloc_native_currency_ekey	nvarchar(255)
alloc_cost_center_ekey	nvarchar(255)
alloc_project_ekey	nvarchar(255)
from_location_ekey	nvarchar(255)
to_location_ekey	nvarchar(255)
trip_type	nchar(2)
from_airport_code	nchar(3)
to_airport_code	nchar(3)
lowest_airfare	numeric(28, 10)
lowest_airfare_currency_iso	nchar(3)
lowest_airfare_currency_ekey	nvarchar(255)
lowest_hotel_rate	numeric(28, 10)
lowest_hotel_rate_curr_iso	nchar(3)
lowest_hotel_rate_curr_ekey	nvarchar(255)
booking_source	nchar(2)
agency_name	nvarchar(40)
guest_count	int
guest_entry_mode	smallint
guest_amounts_equal	smallint
guest_no_show_count	int
export_status	int
void_status	int
reversal_line_item_id	int
export_date	datetime
CONSTRAINT pk__alt3ad6b8e2 PRIMARY KEY CLUSTERED ( export_tr_line_id )
)

CREATE TABLE alts_export_line (
export_line_id	int	NOT NULL
ts_line_item_id	int	NOT NULL
export_hdr_id	int	NOT NULL
export_line_status	smallint	NOT NULL
line_item_date	datetime	NOT NULL
top_project_code	nvarchar(255)	NOT NULL
project_code	nvarchar(255)	NOT NULL
hours	numeric(20, 10)	NOT NULL
approved_hours	numeric(20, 10)	NOT NULL
hourly_charge_type	nvarchar(255)
app_hourly_charge_type	nvarchar(255)
charge_type	nvarchar(255)
location	nvarchar(255)
charge_role	nvarchar(255)
billable_rate	numeric(28, 10)
billable_rate_currency_iso	nchar(3)
start_time	datetime
end_time	datetime
note	nvarchar(max)
cost_center_name	nvarchar(255)
cost_center_code	nvarchar(255)
project_ekey	nvarchar(255)
hourly_charge_type_ekey	nvarchar(255)
app_hourly_charge_type_ekey	nvarchar(255)
charge_type_ekey	nvarchar(255)
location_ekey	nvarchar(255)
charge_role_ekey	nvarchar(255)
billable_rate_currency_ekey	nvarchar(255)
cost_center_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)
company_name	nvarchar(255)
company_code	nvarchar(255)
division_name	nvarchar(255)
division_code	nvarchar(255)
department_name	nvarchar(255)
department_code	nvarchar(255)
segment_count	int
segment1_name	nvarchar(255)
segment1_code	nvarchar(255)
segment2_name	nvarchar(255)
segment2_code	nvarchar(255)
segment3_name	nvarchar(255)
segment3_code	nvarchar(255)
segment4_name	nvarchar(255)
segment4_code	nvarchar(255)
segment5_name	nvarchar(255)
segment5_code	nvarchar(255)
segment6_name	nvarchar(255)
segment6_code	nvarchar(255)
segment7_name	nvarchar(255)
segment7_code	nvarchar(255)
segment8_name	nvarchar(255)
segment8_code	nvarchar(255)
segment9_name	nvarchar(255)
segment9_code	nvarchar(255)
review_segment_name	nvarchar(255)
review_segment_code	nvarchar(255)
export_line_status_datetime	datetime
export_status	int
void_status	int
reversal_line_item_id	int
export_date	datetime
CONSTRAINT pk__alt4de98d56 PRIMARY KEY CLUSTERED ( export_line_id )
)