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