Apps: Exact Online Exact Online App Store Apps
read only
- Catalog:
ExactOnlineREST - Schema:
AppCenter - Label: Exact Online App Store Apps
Exact Online App Store apps.
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 432 |
| Full scan rows per minute | 50,300 |
| Point query rows per minute | 138 |
The result can be cached on the client.
Table Columns
The columns of the table Apps are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ALLOWFREETRIAL |
bit |
fetched only when named | |||
APPLICATIONDETAILID |
uniqueidentifier |
Application Detail ID | fetched only when named | ||
APPLICATIONEXACTPRODUCT |
varchar2 |
fetched only when named | |||
APPLICATIONNAME |
varchar2 |
Application Name | fetched only when named | ||
APPLICATIONPUBLISHINGTYPE |
varchar2 |
fetched only when named | |||
APPLICATIONURL |
varchar2 |
fetched only when named | |||
APPLICATIONWEBSITE |
varchar2 |
fetched only when named | |||
APP_ |
varchar2 |
||||
AVERAGERATING |
number |
Average Rating | fetched only when named | ||
COUNTRYAPPLICATIONID |
uniqueidentifier |
Country Application ID | fetched only when named | ||
COUNTRY_ |
varchar2 |
Country Name | |||
CURRENCY |
varchar2 |
fetched only when named | |||
EDITABLE |
bit |
fetched only when named | |||
EMAIL |
varchar2 |
fetched only when named | |||
HASMOREREVIEWS |
bit |
fetched only when named | |||
HASPROVISIONINGURL |
bit |
fetched only when named | |||
INSTALLED |
bit |
fetched only when named | |||
ISAPPINSTALLED |
bit |
fetched only when named | |||
ISAUTHENTICATED |
bit |
fetched only when named | |||
ISEXACTAPP |
bit |
Is Exact App | fetched only when named | ||
ISPARTNERTERMSACCEPTED |
bit |
fetched only when named | |||
ISREVIEWENABLED |
bit |
fetched only when named | |||
ISTRIALUSER |
bit |
fetched only when named | |||
LOGOFILENAME |
varchar2 |
Logo File Name | fetched only when named | ||
LOGOURL |
varchar2 |
Logo (URL) | fetched only when named | ||
MARKETINGDETAILREVIEWSTATUSID |
integer |
fetched only when named | |||
NUMBEROFCONNECTEDCUSTOMERS |
number |
Number of Connected Customers | fetched only when named | ||
NUMBEROFTRIALDAYS |
integer |
fetched only when named | |||
NUMBEROFVOTES |
number |
Number of Votes | fetched only when named | ||
PARTNERID |
uniqueidentifier |
Partner ID | fetched only when named | ||
PARTNERNAME |
varchar2 |
Partner Name | fetched only when named | ||
PHONE |
varchar2 |
fetched only when named | |||
RATINGSCORE |
number |
Rating Score | fetched only when named | ||
SEONAME |
varchar2 |
SEO Name | fetched only when named | ||
TEASER |
varchar2 |
Teaser | fetched only when named | ||
WEBSITE |
varchar2 |
fetched only when named |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: