ExtApp Table (133)
•
Environment: onsite, online
Some tooltip text!
• 9 minutes to read
• 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.