Version 10.2.12

Modifications in Infor Expense Management 10.2.12

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 float
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
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id )
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
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 float
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
CONSTRAINT PK__alt314D4EA8 PRIMARY KEY CLUSTERED ( tr_line_item_id ) )
CREATE TABLE alpr_invoice_line_item (
invoice_line_item_id int NOT NULL
invoice_id int NOT NULL
item_number nvarchar(255)
item_description nvarchar(255)
invoiced_quantity numeric(15,5)
unit_of_measure_id int
unit_price_amount numeric(28,10)
unit_price_amount_id int
total_price_amount numeric(28,10)
total_price_amount_id int
check_request_type_id int
chg_allocation_option smallint
chg_balancing_option smallint
doc_based_allocation smallint
is_approved smallint
expense_account_id int
vat_account_id int
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
is_incomplete smallint DEFAULT 0 NOT NULL
creator_client_type int
CONSTRAINT PK457 PRIMARY KEY CLUSTERED ( invoice_line_item_id )
CREATE TABLE alco_mileage_waypoint (
waypoint_id int NOT NULL
mileage_route_id int NOT NULL
address nvarchar(255)
sequence int NOT NULL
latitude numeric(38,16)
longitude numeric(38,16)
locale_string nvarchar(10)
distance numeric(15,5)
change_timestamp datetime
is_via_waypoint int
CONSTRAINT PK548 PRIMARY KEY CLUSTERED ( waypoint_id )