ERP/3.0/Developers Guide/Database Model/org.openbravo.service.externalsystem/C External System Http
C_External_System_Http
- Name:C_External_System_Http
- Classname:C_External_System_Http
This table contains the following columns:
Name | Nullable | Data Type | Description
|
Isactive | No | CHAR (1) | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions. |
Authorization_Type | No | VARCHAR (60) | Determine the credentials that must be set in order to access to an HTTP external system in a secure way |
C_External_System_Http_ID | No | VARCHAR (32) | Keeps the configuration data of an external system that uses the HTTP protocol |
C_External_System_ID | No | VARCHAR (32) | Keeps the configuration data that is required to communicate with an external system |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
Createdby | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
Oauth2_Auth_Server_Url | Yes | VARCHAR (1000) | This is the URL used in the OAuth 2.0 standard to ask for a new access token. In order to request this access token, it is mandatory to send the correct Cliend ID and Client Secret values. |
Oauth2_Client_Identifier | Yes | VARCHAR (60) | This is a unique identifier for the client application that is requesting the access token. The client ID is typically issued by the OAuth2 service provider when the client application is registered. |
Oauth2_Client_Secret | Yes | VARCHAR (255) | This is a secret value that is known only to the client application and the OAuth2 service provider. It is used to authenticate the client application and ensure that only authorized clients can request access tokens. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
Password | Yes | VARCHAR (255) | The Password indicates the Password for this User Id. Passwords are required to identify authorized users. |
Request_Method | No | VARCHAR (60) | The HTTP method used to indicate the desired action to be performed on an external system resource. Note that this method can be overwritten in the programmatic API used to communicate with the external system in order to use a different method. |
Timeout | No | DECIMAL (10,0) | The maximum time in seconds allowed to complete an HTTP request, including the time for processing the HTTP response. |
Url | No | VARCHAR (1000) | The URL defines an online address for this element. |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
Updatedby | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
Username | Yes | VARCHAR (60) | Name that identifies the user in the System |
Columns
Active
- Physical column name: Isactive
- Property Name: active
- Reference: YesNo
- Default value: Y
Authorization_Type
- Physical column name: Authorization_Type
- Property Name: authorizationType
- Reference: List
List values: Authorization Type
The allowed values for this list are:
- BASIC_ALWAYS_HEADER (Basic Auth (Always in Header)): Provides the basic authentication information by setting it always in the header of the HTTP requests
- NOAUTH (No Auth): No Authentication. It may be useful for development purposes.
- OAUTH2 (OAuth 2.0): Standard designed to allow access to resources hosted by other web apps on behalf of a user
- BASIC (Basic Auth): Standard HTTP basic authentication
C_External_System_Http_ID
- Physical column name: C_External_System_Http_ID
- Property Name: id
- Reference: ID
C_External_System_ID
- Physical column name: C_External_System_ID
- Property Name: externalSystem
- Reference: TableDir
- This column is a child for a business object (is Parent)
Foreign key column to C_External_System table, (column: C_External_System_ID)
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Oauth2_Auth_Server_Url
- Physical column name: Oauth2_Auth_Server_Url
- Property Name: oauth2AuthServerUrl
- Reference: String
Oauth2_Client_Identifier
- Physical column name: Oauth2_Client_Identifier
- Property Name: oauth2ClientIdentifier
- Reference: String
Oauth2_Client_Secret
- Physical column name: Oauth2_Client_Secret
- Property Name: oauth2ClientSecret
- Reference: Password (decryptable)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Password
- Physical column name: Password
- Property Name: password
- Reference: Password (decryptable)
Request Method
- Physical column name: Request_Method
- Property Name: requestMethod
- Reference: List
- Default value: POST
List values: HTTP Request Method
The allowed values for this list are:
- POST (POST)
Timeout
- Physical column name: Timeout
- Property Name: timeout
- Reference: Integer
- Default value: 10
URL
- Physical column name: Url
- Property Name: uRL
- Reference: String
- This column is part of the table's identifier
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: Updatedby
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Username
- Physical column name: Username
- Property Name: username
- Reference: String
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- C_EXT_SYS_HTTP_EXT_SYS Not Unique. Columns:
- C_EXTERNAL_SYSTEM_ID
- C_EXT_SYS_HTTP_UNIQ_EXT_SYS Unique. Columns:
- C_EXTERNAL_SYSTEM_ID
- ISACTIVE
Check Constraints
These are the check constraints for this table:
- C_EXT_HTTP_SYS_MIN_TIMEOUT: TIMEOUT > 0
- C_EXT_HTTP_SYSTEM_ACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- C_EXT_HTTP_SYSTEM_BASIC_AUTH: AUTHORIZATION_TYPE <> 'BASIC' OR USERNAME IS NOT NULL AND PASSWORD IS NOT NULL
- C_EXT_HTTP_SYSTEM_OAUTH2: AUTHORIZATION_TYPE <> 'OAUTH2' OR OAUTH2_CLIENT_IDENTIFIER IS NOT NULL AND OAUTH2_CLIENT_SECRET IS NOT NULL AND OAUTH2_AUTH_SERVER_URL IS NOT NULL