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