Table of Contents

Table Sys_External_Applications

Entity

Entity: Systems.Security.ExternalApplications

List of external applications. Used to run external applications. Entity: Sys_External_Applications

Summary

Name Type Description
Access_Key_Id uniqueidentifier
Address nvarchar(max) The address (path) to the application. The address is platform-dependant.
Available_In_Mode nvarchar(6) Allowed: SINGLE, LIST, ALL Whether the application will be displayed to the end users when a single object is opened or when multiple objects are listed.
Entity_Name nvarchar(64) The entity, for which the application is defined.
Execute_For_All_Objects bit Whether to execute the application for all selected objects at once or to execute the application for each object, one by one.
External_Application_Id uniqueidentifier PK
External_Application_Name nvarchar(254) ML The name of the external application.
Is_Active bit Specifies whether the external application is currently used.
Notes nvarchar(max)
Platform nvarchar(12) Allowed: WINDOWS, WEBPAGE, WEBSERVICE, ANDROID, iOS The execution platform of the application.
Refresh_After_Finish bit Whether to refresh the data, displayed to the user, after the execution finishes. Not all platforms and/or applications support finish notification.
Row_Version timestamp
Save_Before_Start bit Whether to save the form data to the server before starting the application.

Columns

Access_Key_Id

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sec_Access_Keys
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Access_Key_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Address

The address (path) to the application. The address is platform-dependant.

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Available_In_Mode

Whether the application will be displayed to the end users when a single object is opened or when multiple objects are listed.

Property Value
Allowed Values SINGLE, LIST, ALL
Auto Complete no
Data Filter no
Default Value SINGLE
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 6
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(6)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Available_In_Mode - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Entity_Name

The entity, for which the application is defined.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name yes
Max Length 64
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable yes
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Entity_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Execute_For_All_Objects

Whether to execute the application for all selected objects at once or to execute the application for each object, one by one.

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Execute_For_All_Objects - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

External_Application_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

External_Application_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

External_Application_Name

The name of the external application.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 254
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

External_Application_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Like None no no

Is_Active

Specifies whether the external application is currently used.

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Is_Active - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Notes

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Platform

The execution platform of the application.

Property Value
Allowed Values WINDOWS, WEBPAGE, WEBSERVICE, ANDROID, iOS
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 12
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(12)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Platform - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Refresh_After_Finish

Whether to refresh the data, displayed to the user, after the execution finishes. Not all platforms and/or applications support finish notification.

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Refresh_After_Finish - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Save_Before_Start

Whether to save the form data to the server before starting the application.

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Save_Before_Start - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Suggest improvement to this page