Version 10.2.19

These transaction tables are added in Infor Expense Management 10.2.19

CREATE TABLE alco_etl_table_modified (
start_date datetime
end_date datetime
table_name nvarchar(255) NOT NULL
flag int
bob_id int NOT NULL
)
CREATE TABLE alco_ocr_itemization_code (
ocr_itemization_code_id int NOT NULL
code int NOT NULL
expense_type_id int NOT NULL
change_timestamp datetime
active_status smallint NOT NULL
CONSTRAINT PK569 PRIMARY KEY CLUSTERED ( ocr_itemization_code_id )
)
CREATE TABLE alco_vat_period (
vat_period_id int NOT NULL
vat_account_id int NOT NULL
effective_date datetime
until_date datetime
CONSTRAINT PK570 PRIMARY KEY CLUSTERED ( vat_period_id )
)