Version 2022.09

This transaction table is added in Infor Expense Management 2022.09

CREATE TABLE EXTN_BODS_LOCK (
MESSAGE_ID	nvarchar(50)	NOT NULL
LOCK_ID	nvarchar(100)	NOT NULL
LOCK_TIMESTAMP	datetime	NOT NULL
CONSTRAINT EXTN_BODS_LOCK_PK PRIMARY KEY CLUSTERED ( MESSAGE_ID )

CREATE TABLE EXTN_INBOX (
MESSAGE_ID	nvarchar(50)	NOT NULL
MESSAGE_CONTENT	nvarchar(max)	NOT NULL
MESSAGE_TIMESTAMP	datetime	NOT NULL
MESSAGE_PROCESSED	int	NOT NULL
MESSAGE_PROCERROR	nvarchar(max)
MESSAGE_TENANT	nvarchar(255)	NOT NULL
MESSAGE_TYPE	nvarchar(255)
CONSTRAINT EXTN_INBOX_PK PRIMARY KEY CLUSTERED ( MESSAGE_ID )
)

CREATE TABLE EXTN_OUTBOX (
MESSAGE_ID	nvarchar(50)	NOT NULL
MESSAGE_CONTENT	nvarchar(max)	NOT NULL
MESSAGE_TIMESTAMP	datetime	NOT NULL
MESSAGE_PROCESSED	int	NOT NULL
MESSAGE_PROCERROR	nvarchar(max)
MESSAGE_TENANT	nvarchar(255)	NOT NULL
MESSAGE_TYPE	nvarchar(255)
TRACKING_NUMBER	nvarchar(255)
CONSTRAINT EXTN_OUTBOX_PK PRIMARY KEY CLUSTERED ( MESSAGE_ID )
)

CREATE TABLE alco_flex_ddlb_1 (
flex_ddlb_id	int	NOT NULL
flex_ddlb_code	nvarchar(255)
flex_ddlb_value	nvarchar(255)
user_id	int
active_status	smallint	NOT NULL
change_timestamp	datetime
CONSTRAINT alco_flex_ddlb_1_PK PRIMARY KEY CLUSTERED ( flex_ddlb_id )
)

CREATE TABLE alco_flex_ddlb_2 (
flex_ddlb_id	int	NOT NULL
flex_ddlb_code	nvarchar(255)
flex_ddlb_value	nvarchar(255)
user_id	int
active_status	smallint	NOT NULL
change_timestamp datetime
CONSTRAINT alco_flex_ddlb_2_PK PRIMARY KEY CLUSTERED ( flex_ddlb_id )
)

CREATE TABLE alco_flex_ddlb_3 (
flex_ddlb_id	int	NOT NULL
flex_ddlb_code	nvarchar(255)
flex_ddlb_value	nvarchar(255)
user_id	int
active_status	smallint	NOT NULL
change_timestamp datetime
CONSTRAINT alco_flex_ddlb_3_PK PRIMARY KEY CLUSTERED ( flex_ddlb_id )
)

CREATE TABLE alco_flex_ddlb_4 (
flex_ddlb_id	int	NOT NULL
flex_ddlb_code	nvarchar(255)
flex_ddlb_value	nvarchar(255)
user_id	int
active_status	smallint	NOT NULL
change_timestamp datetime
CONSTRAINT alco_flex_ddlb_4_PK PRIMARY KEY CLUSTERED ( flex_ddlb_id )
)

CREATE TABLE alco_flex_ddlb_5 (
flex_ddlb_id	int	NOT NULL
flex_ddlb_code	nvarchar(255)
flex_ddlb_value	nvarchar(255)
user_id	int
active_status	smallint	NOT NULL
change_timestamp	datetime
CONSTRAINT alco_flex_ddlb_5_PK PRIMARY KEY CLUSTERED ( flex_ddlb_id )
)