Version 10.2.10

These staging tables are added in Infor Expense Management 10.2.10:

CREATE TABLE alex_import_er_document (
external_key nvarchar(255 ) NOT NULL
user_ekey nvarchar(255) NOT NULL
import_status smallint DEFAULT 1NOT NULL
import_error_message nvarchar(255)
import_change_timestamp datetime
submit_status smallint DEFAULT 0 NOT NULL
submit_error_message nvarchar(255)
submit_change_timestamp datetime
er_paid_on datetime
er_amt_paid numeric(28,10)
er_amt_paid_id_ekey nvarchar(255)
er_payment_number nvarchar(255)
exp_rep_title nvarchar(255)
purpose_id_ekey nvarchar(255)
corp_charge_date datetime
corp_charge_amt_paid_id_ekey nvarchar(255)
corp_charge_amt_paid numeric(28,10)
create_location_id_ekey nvarchar(255)
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)
keyword_note nvarchar(max)
CONSTRAINT PK_alt3CBF0154ER PRIMARY KEY CLUSTERED ( external_key ) )
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)
CONSTRAINT PK_alt3CBF0154ERLI PRIMARY KEY CLUSTERED ( external_key ) )
CREATE TABLE alex_import_pr_document (
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
submit_status smallint DEFAULT 0 NOT NULL
submit_error_message nvarchar(255)
submit_change_timestamp datetime
title nvarchar(255)
invoice_number nvarchar(255)
invoice_date datetime
total_amount numeric(28,10)
total_amount_id_ekey nvarchar(255)
paid_date datetime
paid_amount numeric(28,10)
paid_amount_id_ekey nvarchar(255)
payment_number nvarchar(255)
pr_vendor_id_ekey nvarchar(255)
send_to_id smallint NOT NULL
pr_purpose_id_ekey nvarchar(255)
requested_payment_date datetime
voucher_number nvarchar(255)
special_handling nvarchar(255)
keyword_note nvarchar(max)
CONSTRAINT PK139 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)
CONSTRAINT PK142 PRIMARY KEY CLUSTERED ( external_key ) )
CREATE TABLE alex_import_tp_document (
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
submit_status smallint DEFAULT 0 NOT NULL
submit_error_message nvarchar(255)
submit_change_timestamp datetime
tr_title nvarchar(255)
tr_purpose_ekey nvarchar(255)
tr_num_going int
trip_type_id_ekey nvarchar(255)
create_location_id_ekey nvarchar(255)
keyword_alloc_cost_center_ekey nvarchar(255)
keyword_alloc_project_num_ekey nvarchar(255)
keyword_note nvarchar(max)
CONSTRAINT PK143 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)
CONSTRAINT PK144 PRIMARY KEY CLUSTERED ( external_key )
)