Modifications in Infor Expense Management 10.2.5
| 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 |
float |
|
| 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 ) ) |
| 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 |
float |
|
| 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 ) ) |