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 )
)