Version 2023.01

Modifications in Infor Expense Management 2023.01. The new columns are highlighted.

CREATE TABLE alco_cost_center_config (
cost_center_config_id	int	NOT NULL
segment_count	int	NOT NULL
segment_separator	nvarchar(10)	NOT NULL
active_status	int
review_segment_label	nvarchar(255)
review_segment_display_element	nvarchar(80)
segment1_code	nvarchar(60)
segment1_label	nvarchar(255)
segment1_display_element	nvarchar(80)
segment2_label	nvarchar(255)
segment2_display_element	nvarchar(80)
segment2_optional	smallint	DEFAULT 0 NOT NULL
segment3_label	nvarchar(255)
segment3_display_element	nvarchar(80)
segment3_optional	smallint	DEFAULT 0 NOT NULL
segment4_label	nvarchar(255)
segment4_display_element	nvarchar(80)
segment4_optional	smallint	DEFAULT 0 NOT NULL
segment5_label	nvarchar(255)
segment5_display_element	nvarchar(80)
segment5_optional	smallint	DEFAULT 0 NOT NULL
segment6_label	nvarchar(255)
segment6_display_element	nvarchar(80)
segment6_optional	smallint	DEFAULT 0 NOT NULL
segment7_label	nvarchar(255)
segment7_display_element	nvarchar(80)
segment7_optional	smallint	DEFAULT 0 NOT NULL
segment8_label	nvarchar(255)
segment8_display_element	nvarchar(80)
segment8_optional	smallint	DEFAULT 0 NOT NULL
segment9_label	nvarchar(255)
segment9_display_element	nvarchar(80)
segment9_optional	smallint	DEFAULT 0 NOT NULL
change_timestamp	datetime
segment2_hidden	smallint	DEFAULT 0 NOT NULL
segment3_hidden	smallint	DEFAULT 0 NOT NULL
segment4_hidden	smallint	DEFAULT 0 NOT NULL
segment5_hidden	smallint	DEFAULT 0 NOT NULL
segment6_hidden	smallint	DEFAULT 0 NOT NULL
segment7_hidden	smallint	DEFAULT 0 NOT NULL
segment8_hidden	smallint	DEFAULT 0 NOT NULL
segment9_hidden	smallint	DEFAULT 0 NOT NULL
none_text	nvarchar(50)
segment1_hidden	smallint	DEFAULT 0 NOT NULL
segment1_display_index	int	DEFAULT 1 NOT NULL
segment2_display_index	int	DEFAULT 2 NOT NULL
segment3_display_index	int	DEFAULT 3 NOT NULL
segment4_display_index	int	DEFAULT 4 NOT NULL
segment5_display_index	int	DEFAULT 5 NOT NULL
segment6_display_index	int	DEFAULT 6 NOT NULL
segment7_display_index	int	DEFAULT 7 NOT NULL
segment8_display_index	int	DEFAULT 8 NOT NULL
segment9_display_index	int	DEFAULT 9 NOT NULL
CONSTRAINT PK536 PRIMARY KEY CLUSTERED ( cost_center_config_id )
)
go

CREATE TABLE alco_project_number (
project_number_id	int	NOT NULL
user_id	int
is_required	smallint	DEFAULT 0 NOT NULL
project_code	nvarchar(255)
project_name	nvarchar(255)
project_description	nvarchar(255)
level_1_leader_id	int
level_2_leader_id	int
level_3_leader_id	int
level_4_leader_id	int
default_reviewer_id	int
client_id	int
proj_num_active_status	smallint
parent_project_number_id	int
code_level	int
is_chargeable	smallint	DEFAULT 0 NOT NULL
start_date	datetime
end_date	datetime
charge_type_id	int
project_code_ref_id	int
top_project_code	nvarchar(255)
project_charge_code	nvarchar(255)	NOT NULL
hier_project_name	nvarchar(255)
office_id	int
alternate_reviewer_id	int
project_activity_type_id	int
change_timestamp	datetime
app_flags	int
project_accounting_entity_code	nvarchar(255)
CONSTRAINT PK__alc32AB8735 PRIMARY KEY CLUSTERED ( project_number_id )
)
go

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	numeric(18,7)
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
original_location	nvarchar(255)
dest_location	nvarchar(255)
is_base_amount_adjusted	smallint	DEFAULT 0 NOT NULL
export_date	datetime
imported_read_only	smallint
tax1	numeric(28,10)
tax1_id	int
tax2	numeric(28,10)
tax2_id	int
flex_field_ddlb_6_id	int
flex_field_ddlb_7_id	int
flex_field_ddlb_8_id	int
flex_field_ddlb_9_id	int
flex_field_ddlb_10_id	int
billing_period	int
last_user_update_timestamp	datetime
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id )
)
go

CREATE TABLE aler_expense_report (
exp_rep_data_id	int	NOT NULL
user_id	int
cash_adv_amount_id	int
cash_adv_amount	numeric(28,10)
company_charges_id	int
company_charges	numeric(28,10)
amount_due_emp_id	int
amount_due_emp	numeric(28,10)
amount_due_co_id	int
amount_due_co	numeric(28,10)
auth_amt_id	int
auth_amt	numeric(28,10)
total_expense_id	int
total_expense	numeric(28,10)
exp_rep_date_created	datetime
exp_rep_date_filed	datetime
er_date_from	datetime
er_date_to	datetime
show_currency	smallint
show_bill_to	smallint
separate_bill	smallint
per_diem	nchar(6)
doc_status	int
exp_rep_is_approved	nchar(6)
er_paid_on	datetime
er_amt_paid	numeric(28,10)
er_amt_paid_id	int
er_payment_number	nvarchar(255)
exp_rep_title	nvarchar(255)
envelope_id	nvarchar(255)
purpose_id	int
exp_emp_dept	nvarchar(255)
exp_emp_company	nvarchar(255)
applied_lcf_id	int
applied_lcf	numeric(28,10)
applied_adj_id	int
applied_adj	numeric(28,10)
corp_charge_total_id	int
corp_charge_total	numeric(28,10)
remaining_lcf_id	int
remaining_lcf	numeric(28,10)
corp_charge_date	datetime
corp_charge_amt_paid_id	int
corp_charge_amt_paid	numeric(28,10)
exp_note	nvarchar(5)
chg_allocation_option	smallint
chg_balancing_option	smallint
corp_card_type	smallint
business_model	smallint
company_pays_cards	numeric(28,10)
company_pays_cards_id	int
generated_lcf_id	int
generated_lcf	numeric(28,10)
receipt_received	datetime
date_approved	datetime
payment_made	numeric(28,10)
payment_made_id	int
receipt_packet_expected	smallint
receipt_email_deadline_date	datetime
receipt_hitlist_deadline_date	datetime
create_location_id	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_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
last_user_update_timestamp	datetime
CONSTRAINT PK__ale1F63A897 PRIMARY KEY CLUSTERED ( exp_rep_data_id )
)
go

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	numeric(18,7)
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
export_date	datetime
imported_read_only	smallint
round_trip	smallint
CONSTRAINT PK__alt314D4EA8 PRIMARY KEY CLUSTERED ( tr_line_item_id )
)
go

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
export_date	datetime
imported_read_only	smallint
ref_doc_id	nvarchar(255)
CONSTRAINT PK__alt51BA1E3A PRIMARY KEY CLUSTERED ( ts_line_item_id )
)
go

CREATE TABLE alco_note_entry (
note_entry_id	int	NOT NULL
parent_id	int	NOT NULL
note_type	nvarchar(255)	NOT NULL
message_text	nvarchar(max)
user_id	int	NOT NULL
note_datetime	datetime
change_timestamp	datetime
is_editable	int
quick_note_id	int
CONSTRAINT PK__alc123EB7A3 PRIMARY KEY CLUSTERED ( note_entry_id )
)
go