These staging tables are added in Infor Expense Management 10.2.21:
| CREATE TABLE alex_holiday_sched_name ( |
| external_key |
nvarchar(255) |
NOT NULL |
| holiday_sched_name |
nvarchar(255) |
|
| holiday_sched_active_status |
smallint |
NOT NULL |
| CONSTRAINT PK145 PRIMARY KEY CLUSTERED ( external_key ) |
|
|
| ) |
|
|
| CREATE TABLE alex_holidays ( |
| external_key |
nvarchar(255) |
NOT NULL |
| holiday_sched_name_ekey |
nvarchar(255) |
|
| holiday_name |
nchar(40) |
|
| holiday_date |
datetime |
|
| holiday_active_status |
smallint |
NOT NULL |
| CONSTRAINT PK146 PRIMARY KEY CLUSTERED ( external_key ) |
|
|
| ) |
|
|