This transaction table is added in Infor Expense Management 2023.01
| CREATE TABLE alco_deleted_line_info ( |
|
|
| deleted_line_info_id |
int |
NOT NULL |
| parent_id |
int |
NOT NULL |
| deleted_line_item_id |
int |
NOT NULL |
| when_deleted_timestamp |
datetime |
NOT NULL |
| CONSTRAINT PK500 PRIMARY KEY CLUSTERED ( deleted_line_info_id ) |
|
|
| ) |
|
|
| go |
|
|
| CREATE TABLE alco_quick_note ( |
|
|
| quick_note_id |
int |
NOT NULL |
| user_id |
int |
|
| name |
nvarchar(255) |
NOT NULL |
| code |
nvarchar(255) |
|
| active_status |
smallint |
NOT NULL |
| change_timestamp |
datetime |
|
| CONSTRAINT PK__alc4AB81AF0X PRIMARY KEY CLUSTERED ( quick_note_id ) |
|
|
| ) |
|
|
| go |
|
|