Version 10.2.17

Modifications in Infor Expense Management 10.2.17

CREATE TABLE alco_signatures (
signature_id int NOT NULL
doc_id int NOT NULL
doc_type int
user_id int
for_whom int
date_time datetime
how int
why nvarchar(255),
change_timestamp datetime
activity_id int
CONSTRAINT PK__alc44CA3770 PRIMARY KEY CLUSTERED ( signature_id )
)
CREATE TABLE alcc_transaction (
cc_transaction_id int NOT NULL
ccard_id int NOT NULL
merchant_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)
tax1_included smallint
tax2_included smallint
source_transaction_id int
marked_for_detach smallint DEFAULT 0 NOT NULL
CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED ( cc_transaction_id )
)
CREATE TABLE alco_address (
address_id int NOT NULL
user_id int
address_name nvarchar(255)
location_name nvarchar(255)
addr_line_1 nvarchar(255)
addr_line2 nvarchar(255)
city_name nvarchar(255)
state_id int
zip_code nvarchar(20)
country_id int
phone_nbr nvarchar(255)
url nvarchar(255)
active_status smallint NOT NULL
parent_id int
contact_name nvarchar(255)
contact_email_address nvarchar(255)
contact_phone_number nvarchar(255)
external_sys_id nvarchar(255)
address_type smallint
fax_phone_nbr nvarchar(40)
change_timestamp datetime
suggest_in_map smallint DEFAULT 0 NOT NULL
CONSTRAINT PK__alc398D8EEE PRIMARY KEY CLUSTERED ( address_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(6,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
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id )
)
CREATE TABLE aler_line_allocation (
line_allocation_id int
exp_line_item_id int
percent_allotted numeric(26,16)
base_amount_id int
base_amount numeric(28,10)
native_amount_id int
native_amount numeric(28,10)
is_approved smallint
cost_center_id int
project_number_id int
is_billable smallint
is_base_amount_adjusted smallint DEFAULT 0 NOT NULL
CONSTRAINT PK__ale251C81ED PRIMARY KEY CLUSTERED ( line_allocation_id )
)