Version 10.2.11

Modifications in Infor Expense Management 10.2.11

CREATE TABLE alco_mileage_route (
mileage_route_id int NOT NULL
route_name nvarchar(255) NOT NULL
user_id int
route_detail nvarchar(max) NOT NULL
distance numeric(15,5) NOT NULL
change_timestamp datetime
from_address_id int
to_address_id int
active_status smallint DEFAULT 1 NOT NULL
original_route_id int
billable smallint DEFAULT 0 NOT NULL
round_trip_not_allowed smallint
CONSTRAINT PK527 PRIMARY KEY CLUSTERED ( mileage_route_id ) )
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
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id ) )
CREATE TABLE alcc_transaction (
cc_transaction_id int NOT NULL
ccard_id int NOT NULL
merchant_id int
currency_fmt_defn_id int
cct_reference nvarchar(255)
cct_type smallint NOT NULL
cct_amt_us_id int
cct_amt_us numeric(28,10) NOT NULL
cct_posting_date datetime NOT NULL
cct_date datetime
vat_amt_native_id int
vat_amt_native numeric(28,10)
cct_amt_native_id int
cct_amt_native numeric(28,10)
cct_currency_code nchar(3)
cct_active_status smallint NOT NULL
cct_import_timestamp datetime
external_system_id nvarchar(255)
offline_user_id int
doc_date_offlined datetime
er_doc_id int
location_id int
expense_type_id int
cct_description nvarchar(255)
cc_transaction_detail_id int
change_timestamp datetime
cct_status_int int
cct_sequence_number int
cct_statement_date datetime
primary_iso_currency_code nchar(3)
market_code nvarchar(50)
global_client_origin_id nvarchar(50)
local_country_iso_code nchar(3)
transaction_type_code nvarchar(10)
tax1 numeric(28,10)
tax1_id int
tax2 numeric(28,10)
tax2_id int
tax1_included smallint
tax2_included smallint
CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED ( cc_transaction_id ) )