Modifications in Infor Expense Management 10.2.10
| CREATE TABLE alco_installed_application ( |
| app_bob_id |
int |
NOT NULL |
| app_display_string |
nchar(60) |
|
| app_version_string |
nchar(20) |
|
| app_build_string |
nchar(20) |
|
| app_id |
int |
NOT NULL |
| business_process_id |
int |
NOT NULL |
| app_help_directory |
nvarchar(255) |
|
| is_installed |
nvarchar(255) |
NOT NULL |
| expired_usage |
nvarchar(255) |
|
| change_timestamp |
datetime |
|
| CONSTRAINT PK__alc02FC7413 PRIMARY KEY CLUSTERED ( app_bob_id ) ) |
| CREATE TABLE alco_xmdbtool_pgp_keys ( |
| xmdbtool_pgp_keys_id |
int |
NOT NULL |
| key_data |
nvarchar(max) |
NOT NULL |
| key_type |
nvarchar(255) |
NOT NULL |
| key_pass |
nvarchar(max) |
NOT NULL |
| is_active |
int |
|
| key_status |
nvarchar(max) |
NOT NULL |
| change_timestamp |
datetime |
|
| is_kms |
int |
NOT NULL |
| encrypted_key |
varbinary(max) |
|
| kms_cipher |
varbinary(max) |
|
| random_number |
varbinary(max) |
|
| CONSTRAINT PK598 PRIMARY KEY CLUSTERED ( xmdbtool_pgp_keys_id ) ) |