DefaultApprovalSettings: Bouw7 Default Approval Settings
insert REST
- Catalog:
Bouw7 - Schema:
Approval - Label: Default Approval Settings
Find the default approval settings for the current organization. Find the default approval settings.
Can retrieve data and change data using insert.
Summary
Find the default approval settings.
API Source
- Endpoint:
/approval-template/default-settings - Operation:
get /approval-template/default-settings
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 74 |
| Full scan rows per minute | 1,250 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Table Columns
The columns of the table DefaultApprovalSettings 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 |
|---|---|---|---|---|---|
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 1 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 1 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 1 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 1 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 1 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 1 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 2 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 2 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 2 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 2 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 2 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 2 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 3 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 3 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 3 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 3 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 3 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 3 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 4 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 4 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 4 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 4 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 4 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 4 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 5 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 5 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 5 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Contract Subcontractor Workflow Approver 5 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Contract Subcontractor Workflow Approver 5 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Approver 5 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
char |
Default Contract Subcontractor Workflow Approvers | filters on the platform, writable, default |
||
default |
datetime |
Default Contract Subcontractor Workflow Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Contract Subcontractor Workflow ID | filters on the platform, writable, default |
ID of the approval workflow. | |
default |
char |
Default Contract Subcontractor Workflow Is Deduplicated | filters on the platform, writable, default |
Whether the criteria has been deduplicated. | |
default |
char |
Default Contract Subcontractor Workflow Is Restricted | filters on the platform, writable, default |
Whether the criteria is restricted. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Name | filters on the platform, writable, default |
Name of the approval workflow. | |
default |
datetime |
Default Contract Subcontractor Workflow Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Contract Subcontractor Workflow Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 1 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 1 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 1 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 1 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 1 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 1 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 2 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 2 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 2 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 2 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 2 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 2 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 3 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 3 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 3 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 3 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 3 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 3 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 4 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 4 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 4 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 4 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 4 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 4 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 5 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 5 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 5 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Invoice Workflow Approver 5 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Invoice Workflow Approver 5 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Approver 5 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
char |
Default Purchase Invoice Workflow Approvers | filters on the platform, writable, default |
||
default |
datetime |
Default Purchase Invoice Workflow Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Invoice Workflow ID | filters on the platform, writable, default |
ID of the approval workflow. | |
default |
char |
Default Purchase Invoice Workflow Is Deduplicated | filters on the platform, writable, default |
Whether the criteria has been deduplicated. | |
default |
char |
Default Purchase Invoice Workflow Is Restricted | filters on the platform, writable, default |
Whether the criteria is restricted. | |
default |
varchar2 |
Default Purchase Invoice Workflow Name | filters on the platform, writable, default |
Name of the approval workflow. | |
default |
datetime |
Default Purchase Invoice Workflow Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Invoice Workflow Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Order Workflow Approver 1 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 1 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Order Workflow Approver 1 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Order Workflow Approver 1 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Order Workflow Approver 1 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 1 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Order Workflow Approver 2 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 2 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Order Workflow Approver 2 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Order Workflow Approver 2 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Order Workflow Approver 2 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 2 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Order Workflow Approver 3 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 3 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Order Workflow Approver 3 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Order Workflow Approver 3 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Order Workflow Approver 3 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 3 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Order Workflow Approver 4 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 4 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Order Workflow Approver 4 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Order Workflow Approver 4 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Order Workflow Approver 4 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 4 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
datetime |
Default Purchase Order Workflow Approver 5 Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 5 Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Order Workflow Approver 5 ID | filters on the platform, writable, default |
ID of the approver. | |
default |
int64 |
Default Purchase Order Workflow Approver 5 Type | filters on the platform, writable, default |
Approver type. | |
default |
datetime |
Default Purchase Order Workflow Approver 5 Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Approver 5 Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
default |
char |
Default Purchase Order Workflow Approvers | filters on the platform, writable, default |
||
default |
datetime |
Default Purchase Order Workflow Created At | filters on the platform, writable, default |
The creation time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Created By | filters on the platform, writable, default |
The user that created the entity. | |
default |
int64 |
Default Purchase Order Workflow ID | filters on the platform, writable, default |
ID of the approval workflow. | |
default |
char |
Default Purchase Order Workflow Is Deduplicated | filters on the platform, writable, default |
Whether the criteria has been deduplicated. | |
default |
char |
Default Purchase Order Workflow Is Restricted | filters on the platform, writable, default |
Whether the criteria is restricted. | |
default |
varchar2 |
Default Purchase Order Workflow Name | filters on the platform, writable, default |
Name of the approval workflow. | |
default |
datetime |
Default Purchase Order Workflow Updated At | filters on the platform, writable, default |
The last updated time of the entity. | |
default |
varchar2 |
Default Purchase Order Workflow Updated By | filters on the platform, writable, default |
The user that last updated the entity. | |
id |
int64 |
ID | filters on the platform, writable, id |
ID of the approval template setting. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: