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.