Version 10.2.6

These transaction tables are added in Infor Expense Management 10.2.6

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