These transaction tables are added in Infor Expense Management 10.2.0:
| CREATE TABLE alco_xm_release
( |
| xm_release_id |
int |
NOT NULL, |
| release_name |
nvarchar(255) |
NOT NULL, |
| release_date |
datetime |
NOT NULL, |
| build |
nvarchar(255) |
NOT NULL, |
| active_status |
smallint |
NOT NULL, |
| change_timestamp |
datetime |
NULL, |
| CONSTRAINT PK601 PRIMARY KEY
CLUSTERED (xm_release_id) ) |
| CREATE TABLE almt_duplicate_bob_info
( |
| bob_id CREATE TABLE alco_xm_release ( |
int |
NOT NULL, |
| table_name |
nvarchar(255) |
NOT NULL, |
| load_file |
nvarchar(255) |
NOT NULL, |
| load_file_line |
int |
NOT NULL, |
| CONSTRAINT PK599 PRIMARY KEY
CLUSTERED (bob_id, table_name) ) |
| CREATE TABLE almt_load_info (
|
| table_name |
nvarchar(255) |
NOT NULL, |
| absolute_file_path |
nvarchar(255) |
NOT NULL, |
| CREATE TABLE alco_xm_release (
last_modified_time_millis |
numeric(19, 0) |
NOT NULL, |
| CONSTRAINT PK600 PRIMARY KEY
CLUSTERED (table_name, absolute_file_path) ) |