# OAuthClients: Exact Online OAuth Clients
- Catalog: `ExactOnlineREST`
- Schema: `Licence`
- Primary Keys: `ID`
- Label: OAuth Clients
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `OAuthClients` 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 | Documentation |
|---|:---:|---|:---:|---|
| `Account` | `guid` | Account | ☐ | |
| `AccountName` | `varchar2` | Account Name | ☐ | |
| `ActionCreatePartnerKey` | `char` | | ☐ | |
| `AllowEarlyTokenRefreshing` | `char` | | ☑ | |
| `AllowedFlows` | `int32` | Allowed Flows | ☑ | |
| `AllowExternalDivisions` | `char` | | ☑ | |
| `AllowOldRefreshToken` | `char` | | ☐ | |
| `ApplicationName` | `varchar2` | Application Name | ☐ | |
| `BlockNewConnections` | `char` | Block New Connections | ☑ | |
| `ClientSecret` | `varchar2` | | ☐ | |
| `Created` | `datetime` | Created | ☐ | Creation date. |
| `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. |
| `Creator` | `guid` | Creator | ☐ | User ID of creator. |
| `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. |
| `Description` | `varchar2` | Description | ☐ | |
| `EnableExactMatch` | `char` | Enable Exact Match | ☑ | |
| `EnableMandatoryFiltering` | `char` | | ☑ | |
| `EndDate` | `datetime` | End Date | ☐ | |
| `EnforceScopes` | `char` | Enforce Scopes | ☑ | |
| `HideRecommendedApp` | `char` | Hide Recommended App | ☑ | |
| `ID` | `guid` | ID | ☑ | Primary key. |
| `IsInternal` | `char` | Is Internal | ☑ | |
| `Logo` | `blob` | Logo | ☐ | Logo in binary format. |
| `LogoFileName` | `varchar2` | Logo File Name | ☐ | |
| `LogoThumbnailUrl` | `varchar2` | Logo Thumbnail (URL) | ☐ | URL of application logo thumbnail. |
| `LogoUrl` | `varchar2` | Logo (URL) | ☐ | URL of application logo. |
| `Modified` | `datetime` | Modified | ☐ | Last modified date. |
| `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. |
| `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. |
| `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. |
| `PrivilegedAccess` | `char` | Privileged Access | ☑ | |
| `PublishDate` | `datetime` | Publish Date | ☐ | Date of publication. |
| `RefreshTokenChainLimit` | `int32` | | ☐ | |
| `ReturnUrl` | `varchar2` | Return URL | ☐ | Return URL. |
| `StartDate` | `datetime` | Start Date | ☐ | |
| `Type` | `int16` | Type | ☐ | |
| `WebHookSecret` | `varchar2` | Webhook Secret | ☐ | Secret to be used to validate incoming webhook messages. |