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