These transaction tables are added in Infor Expense Management 10.2.15
CREATE TABLE alco_olt_receipt (
|
olt_receipt_id |
int |
NOT NULL |
receipt_name |
nvarchar(255) |
|
user_id |
int |
|
rec_receipt_id |
int |
|
receipt_type |
int |
|
change_timestamp |
datetime |
|
active_status |
smallint |
NOT NULL |
CONSTRAINT PK__olt_receipt_id
PRIMARY KEY CLUSTERED ( olt_receipt_id ) ) |
CREATE TABLE alco_olt_receipt_shell ( |
olt_receipt_shell_id |
int |
NOT NULL |
parent_id |
int |
NOT NULL |
olt_receipt_id |
int |
NOT NULL |
change_timestamp |
datetime |
|
active_status |
smallint |
NOT NULL |
CONSTRAINT PK__olt_receipt_shell_id PRIMARY KEY CLUSTERED (olt_receipt_shell_id) |
|
|