ExtApp Table (133)
• 9 minutes to read
ExtApp MDO list item table.
ExtApp list table. Applications startable from SuperOffice
Fields
| Name |
Description |
Type |
Null |
| ExtApp_id |
Primary key |
PK |
|
| name |
The list item |
String(239) |
|
| rank |
Rank order |
UShort |
● |
| tooltip |
Tooltip or other description |
String(254) |
● |
| deleted |
0 -> record is active 1 -> record is 'deleted' and should not be shown in lists |
UShort |
● |
| path |
Path where the programfile is located; if empty, PATH is used |
String(239) |
● |
| filename |
Filename of the programfile |
String(239) |
|
| parameters |
<template variable> <other template variable> |
String(239) |
● |
| workdir |
Directory set to current when loading the application, if different from application's own |
String(239) |
● |
| icon |
0 indicates default Icon (from app exe file), otherwise reference to a predefined icon resource in SO |
UShort |
● |
| availableInState |
When should this application be available from SO: 0=always, 1=on central db, 2=on travel db,4 on satellite. The value 5 (1+4) indicates that this application is available when logged in to a central or satellite db |
Enum AppAvailState |
|
| executeOnEvent |
Events that cause automatic execution of this app |
Enum ExecuteOnEvent |
|
| navigation |
0=from menu, 1 = from Navigator(integration), 2 = From navigator |
Enum Navigation |
|
| showState |
Maximized / minimized / restored |
Enum ShowState |
|
| registered |
Registered when |
UtcDateTime |
|
| registered_associate_id |
Registered by whom |
FK associate |
|
| updated |
Last updated when |
UtcDateTime |
|
| updated_associate_id |
Last updated by whom |
FK associate |
|
| updatedCount |
Number of updates made to this record |
UShort |
|
| appType |
Application type: 1 = exe, 2 = integrated html, 3 = integrated url, 4 = browser url, 5 = external url |
Enum AppType |
● |
| waitToFinish |
If 1, we wait synchronously for the pplication to finish before we go on |
Bool |
● |
| windowName |
The window which the URL address is to open in (webpanel only) |
String(254) |
● |
| url1 |
URL, supports long strings up to 1k |
String(1023) |
● |
| url2 |
Obsolete - do not use this field |
String(254) |
● |
| configInfo |
Extra configuration information |
String(2047) |
● |
Value for the availableInState field in table ExtApp
The enums here may be combined.
| availableInState |
ID |
Comment |
| Always |
0 |
This application is always available |
| Central db |
1 |
This application is only available on the Central database |
| Satellite db |
2 |
This application is only available on a Satellite database |
| Travel db |
4 |
This application is only available on a Travel database |
| Sales & Marketing web |
8 |
This application is available on Sales & Marketing Web |
Value for the executeOnEvent field in table ExtApp
| executeOnEvent |
ID |
Comment |
| Never |
0 |
This application is never executed automatically |
| Log on |
1 |
Execute this application during logon |
| Log off |
2 |
Execute this application before logoff |
| LocalUpdate |
3 |
Execute this application before a local update (start travelling) |
| Wait |
16384 |
When executing this application, wait for it to start |
| ShowState |
ID |
Comment |
| Minimized |
0 |
Start application in minimized state |
| Maximized |
1 |
Start application in maximized state |
| Default |
2 |
Start application with default window size and position |
| Toolbar |
256 |
Show the Browser toolbar |
| AddressBar |
512 |
Show the Browser addressbar (where the user can type URLs) |
| StatusBar |
1024 |
Show the Browser statusbar |
| MenuBar |
2048 |
Show the Browser Menu bar (currently not implemeted) |
Value for the navigation field in table ExtApp
| navigation |
ID |
Comment |
| Invisible |
0 |
This application is always available |
| ToolboxMenu |
1 |
This application is only available on the Central database |
| NavigatorButton |
2 |
This application is only available on a Satellite database |
| ViewMenu |
3 |
This application is only available on a Travel database |
| SelectionTaskCard |
4 |
(not yet implemented) This application appears as a Task in the Selection Task |
| ContactCard |
5 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab on |
| ContactArchive |
6 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab on |
| ProjectCard |
7 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab on |
| ProjectArchive |
8 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab on the Project Archive |
| SaleCard |
9 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab in |
| PersonDialog |
10 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab in |
| ActivityDialog |
11 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab in |
| DocumentDialog |
12 |
This application (type IntegratedHTML or IntegratedURL) appears as a tab in |
| BrowserPanel |
13 |
In the Browser panel |
| ContSelectionTask |
14 |
Task button visible on the Contact Selection task panel |
| AppntSelectionTask |
15 |
Task button visible on the Appointment Selection task panel |
| SaleSelectionTask |
16 |
Task button visible on the Sale Selection task panel |
| DocSelectionTask |
17 |
Task button visible on the Document Selection task panel |
| ProjSelectionTask |
18 |
Task button visible on the Project Selection task panel |
| CompanyMinicard |
19 |
In company minicard |
| ProjectMinicard |
20 |
In project minicard |
| DiaryMinicard |
21 |
In diary minicard |
| SelectionMinicard |
22 |
In selection minicard |
| ButtonPanelTask |
23 |
In the main ButtonBar |
| AppointmentDialogTask |
24 |
In the appointment dialog |
| SaleDialogTask |
25 |
In the sale dialog |
| DocumentDialogTask |
26 |
In the document dialog |
| PersonDialogTask |
27 |
In the person dialog |
| SaleMinicard |
28 |
In the sale minicard |
| SaleArchive |
29 |
In the sale archive |
| AppntSelectionShadowTask |
30 |
Task tab for appointment selection, while showing shadow selection |
| SaleSelectionShadowTask |
31 |
Task tab for sale selection, while showing shadow selection |
| DocSelectionShadowTask |
32 |
Task tab for document selection, while showing shadow selection |
| ProjSelectionShadowTask |
33 |
Task tab for project selection, while showing shadow selection |
| DiaryArchive |
34 |
Context (popup) menu in Diary archive |
| SelectionContactArchive |
35 |
Context (popup) menu in Contact selection |
| SelectionProjectArchive |
36 |
Context (popup) menu in Project archive |
| SelectionSaleArchive |
37 |
Context (popup) menu in Sale archive |
| SelectionAppointmentArchive |
38 |
Context (popup) menu in Appointment archive |
| SelectionDocumentArchive |
39 |
Context (popup) menu in Document archive |
| ContSelectionCustomTask |
40 |
Task card in Contact selection, when a custom archive is shown |
| AppntSelectionCustomTask |
41 |
Task card in Appointment selection, when a custom archive is shown |
| SaleSelectionCustomTask |
42 |
Task card in Sale selection, when a custom archive is shown |
| DocSelectionCustomTask |
43 |
Task card in Document selection, when a custom archive is shown |
| ProjSelectionCustomTask |
44 |
Task card in Project selection, when a custom archive is shown |
| CustomArchiveMiniCard |
45 |
|
| SelectionCard |
46 |
|
| ReportMinicard |
47 |
In the Reporter panel minicard, so far only in Web |
| QuoteDialog |
48 |
|
| QuoteDialogTask |
49 |
|
| QuoteDialogArchive |
50 |
|
| QuoteLineDialogTask |
51 |
|
| QuoteLineDialog |
52 |
|
| QuoteLineSelectionMainTask |
53 |
|
| QuoteLineSelectionShadowTask |
54 |
|
| SelectionQuoteLineArchive |
55 |
|
| QuoteLineSelectionCustomTask |
56 |
|
| FindSystem |
57 |
|
Indexes
| Fields |
Types |
Description |
| ExtApp_id |
PK |
Clustered, Unique |
| name |
String(239) |
Unique |
Relationships
| Table |
Description |
| associate |
Employees, resources and other users - except for External persons |
| document |
Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this. |
| ExtAppGroupLink |
User group link table for ExtApp, for MDO item hiding |
| ExtAppHeadingLink |
Heading link table for ExtApp, for MDO headers |
Replication Flags
- Replicate changes DOWN from central to satellites and travellers.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.