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