Version 2022.09

These staging tables are modified in Infor Expense Management 2022.09. The new column is highlighted.

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_account	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
tax1	numeric(28,10)
tax1_id	int
tax2	numeric(28,10)
tax2_id	int
billing_period	int
CONSTRAINT pk__ale19aacf41 PRIMARY KEY CLUSTERED ( export_er_line_id )
)
go

CREATE TABLE alex_charge_role (
external_key	nvarchar(255)	NOT NULL
charge_role_name	nvarchar(255)
charge_role_active_status	smallint	NOT NULL
charge_role_code	nvarchar(255)
CONSTRAINT PK111_1 PRIMARY KEY CLUSTERED ( external_key )
)
go

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	numeric(18,7)
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
recurring_count	int
end_date	datetime
dest_location	nvarchar(255)
round_trip	smallint
tax1	numeric(28,10)
tax_id_ekey	nvarchar(255)
tax2	numeric(28,10)
tax2_id_ekey	nvarchar(255)
CONSTRAINT PK_alt3CBF0154ERLI PRIMARY KEY CLUSTERED ( external_key )
)
go