Version 2023.10

Modifications in Infor Expense Management 2023.10

CREATE TABLE albr_parameter (
br_parameter_id	int	NOT NULL
br_instance_id	int
param_order	int
param_type	nchar(2)
param_name	nvarchar(255)
string_value	nvarchar(1500)
int_value	int
float_value	numeric(18, 7)
date_value	datetime
money_value	numeric(28,10)
money_value_id	int
corp_data_name	nvarchar(65)
active_status	smallint	NOT NULL
hours_value	numeric(14,4)
change_timestamp	datetime
gmt_date_value	datetime
CONSTRAINT PK__alb1CF15040 PRIMARY KEY CLUSTERED ( br_parameter_id )
)
go

CREATE TABLE albr_parameter_template (
br_parameter_template_id	int	NOT NULL
template_id	int
param_order	int
param_type	nchar(2)
param_name	nvarchar(255)
string_value	nvarchar(1500)
int_value	int
float_value	numeric(18,7)
date_value	datetime
money_value	numeric(28,10)
money_value_id	int
hours_value	numeric(14,4)
corp_data_name	nvarchar(65)
control_id	int
active_status	smallint	NOT NULL
change_timestamp	datetime
gmt_date_value	datetime
CONSTRAINT PK__alb20C1E124 PRIMARY KEY CLUSTERED ( br_parameter_template_id )
)
go

CREATE TABLE alwf_expediter (
expediter_id	int	NOT NULL
activity_id	int	NOT NULL
expedite_at	int	NOT NULL
expedite_email_recip	smallint
router	nvarchar(255)	NOT NULL
expedite_status	int	NOT NULL
expedite_active_status	int	NOT NULL
exception_status	int
exception_email_recip	smallint
end_group	int
end_status	int
end_email_recip	smallint
add_esig	smallint
change_timestamp	datetime
end_group_applicable_to	smallint
selecter	nvarchar(255)
expediter_name	nvarchar(255)
include_locked	smallint
date_element_name	nvarchar(255)
expediter_javascript_name	nvarchar(255)
CONSTRAINT PK447 PRIMARY KEY CLUSTERED ( expediter_id )
)
go