AppDetails: Exact Online Exact Online App Store App Details
read only
- Catalog:
ExactOnlineREST - Schema:
AppCenter - Label: Exact Online App Store App Details
Exact Online App Store app details.
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 AppDetails 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 | |||
APPINFOURI |
varchar2 |
fetched only when named | |||
APPLICATIONNAME |
varchar2 |
fetched only when named | |||
APPLICATIONPUBLISHINGTYPE |
varchar2 |
fetched only when named | |||
APPLICATIONSTATUSID |
number |
fetched only when named | |||
APPLICATIONURL |
varchar2 |
fetched only when named | |||
APPLICATIONWEBSITE |
varchar2 |
fetched only when named | |||
AVERAGERATING |
number |
fetched only when named | |||
COUNTRYAPPLICATIONID |
uniqueidentifier |
fetched only when named | |||
COUNTRY_ |
varchar2 |
Country Name | |||
CURRENCY |
varchar2 |
fetched only when named | |||
DEPROVISIONINGURL |
varchar2 |
fetched only when named | |||
EDITABLE |
bit |
fetched only when named | |||
EMAIL |
varchar2 |
fetched only when named | |||
EOLACCOUNTID |
uniqueidentifier |
fetched only when named | |||
EOLAPP |
varchar2 |
fetched only when named | |||
EOLCLIENTID |
uniqueidentifier |
fetched only when named | |||
EOLSOLUTIONS |
varchar2 |
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 | ||
ISEXACTAPP2 |
bit |
fetched only when named | |||
ISPARTNERTERMSACCEPTED |
bit |
fetched only when named | |||
ISTRIALUSER |
bit |
fetched only when named | |||
LOGOURL |
varchar2 |
fetched only when named | |||
MARKETINGDETAILREVIEWSTATUSID |
number |
fetched only when named | |||
NUMBEROFCONNECTEDCUSTOMERS |
number |
Number of Connected Customers | fetched only when named | ||
NUMBEROFTRIALDAYS |
number |
fetched only when named | |||
NUMBEROFVOTES |
number |
fetched only when named | |||
OVERVIEW |
varchar2 |
fetched only when named | |||
PARTNERID |
uniqueidentifier |
fetched only when named | |||
PARTNERNAME |
varchar2 |
fetched only when named | |||
PHONE |
varchar2 |
fetched only when named | |||
PROVISIONINGURL |
varchar2 |
fetched only when named | |||
RATINGSCORE |
number |
fetched only when named | |||
SEONAME |
varchar2 |
SEO Name | fetched only when named | ||
USERREVIEW |
varchar2 |
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: