Version 10.2.8

Modifications in Infor Expense Management 10.2.8

CREATE TABLE alco_import_line_item (
import_line_item_id	int	NOT NULL
import_external_id	nvarchar(255)	NOT NULL
expense_category	nvarchar(255)
expense_type_id	int
payment_type_id	int
import_date	datetime
purchased_date	datetime
description	nvarchar(255)
native_amt_currency_code	nvarchar(255)
native_amt_currency_name	nvarchar(255)
native_amt_id	int
native_amt	numeric(28,10)
vat_amount_id	int
vat_amount	numeric(28,10)
vat_amt_currency_code	nvarchar(255)
purpose	nvarchar(255)
merchant_id	nvarchar(255)
vendor_code	nvarchar(255)
vendor_name	nvarchar(255)
location_code	nvarchar(255)
location_name	nvarchar(255)
city_code	nvarchar(255)
city_name	nvarchar(255)
state_code	nvarchar(255)
state_name	nvarchar(255)
country_code	nvarchar(255)
country_name	nvarchar(255)
import_status	nvarchar(255)
active_status	smallint	NOT NULL
user_id	int
raw_data	nvarchar(max)
line_item_id	int
document_tracking_number	nvarchar(255)
import_source	int
doc_id	int
flex_string_1	nvarchar(255)
flex_string_2	nvarchar(255)
flex_string_3	nvarchar(255)
flex_string_4	nvarchar(255)
flex_string_5	nvarchar(255)
flex_string_6	nvarchar(255)
flex_string_7	nvarchar(255)
flex_string_8	nvarchar(255)
flex_string_9	nvarchar(255)
flex_string_10	nvarchar(255)
CONSTRAINT PK602 PRIMARY KEY CLUSTERED ( import_line_item_id ) )

CREATE TABLE aler_review_policies (
review_policy_id	int	NOT NULL
review_type	int	NOT NULL
expense_type_id	int	NOT NULL
amount	numeric(28,10)	NOT NULL
amount_id	int	NOT NULL
currency_fmt_defn_id	int
change_timestamp	datetime
rule_title	nvarchar(255)
rule_policy	nvarchar(max)
rule_interact_message	nvarchar(510)
rule_report_message	nvarchar(510)
rule_severity	int
rule_notify	int
locale	int
active_status	int
routing_type_id	int
brv_visibility	int
CONSTRAINT PK1 PRIMARY KEY CLUSTERED ( review_policy_id ) )