# DefaultApprovalSettings: Bouw7 Default Approval Settings Find the default approval settings for the current organization. Find the default approval settings. - Catalog: `Bouw7` - Schema: `Approval` - Label: Default Approval Settings - Retrieve: True - Insert: True - Update: False - Delete: False ## 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `createdAt` | `datetime` | Created at | ☐ | The creation time of the entity. | | `createdBy` | `varchar2` | Created by | ☐ | The user that created the entity. | | `defaultContractSubcontractorWorkflow_approver1_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultContractSubcontractorWorkflow_approver1_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultContractSubcontractorWorkflow_approver1_id` | `int64` | | ☐ | ID of the approver. | | `defaultContractSubcontractorWorkflow_approver1_type` | `int64` | | ☐ | Approver type. | | `defaultContractSubcontractorWorkflow_approver1_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultContractSubcontractorWorkflow_approver1_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultContractSubcontractorWorkflow_approver2_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultContractSubcontractorWorkflow_approver2_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultContractSubcontractorWorkflow_approver2_id` | `int64` | | ☐ | ID of the approver. | | `defaultContractSubcontractorWorkflow_approver2_type` | `int64` | | ☐ | Approver type. | | `defaultContractSubcontractorWorkflow_approver2_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultContractSubcontractorWorkflow_approver2_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultContractSubcontractorWorkflow_approver3_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultContractSubcontractorWorkflow_approver3_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultContractSubcontractorWorkflow_approver3_id` | `int64` | | ☐ | ID of the approver. | | `defaultContractSubcontractorWorkflow_approver3_type` | `int64` | | ☐ | Approver type. | | `defaultContractSubcontractorWorkflow_approver3_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultContractSubcontractorWorkflow_approver3_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultContractSubcontractorWorkflow_approver4_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultContractSubcontractorWorkflow_approver4_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultContractSubcontractorWorkflow_approver4_id` | `int64` | | ☐ | ID of the approver. | | `defaultContractSubcontractorWorkflow_approver4_type` | `int64` | | ☐ | Approver type. | | `defaultContractSubcontractorWorkflow_approver4_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultContractSubcontractorWorkflow_approver4_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultContractSubcontractorWorkflow_approver5_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultContractSubcontractorWorkflow_approver5_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultContractSubcontractorWorkflow_approver5_id` | `int64` | | ☐ | ID of the approver. | | `defaultContractSubcontractorWorkflow_approver5_type` | `int64` | | ☐ | Approver type. | | `defaultContractSubcontractorWorkflow_approver5_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultContractSubcontractorWorkflow_approver5_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultContractSubcontractorWorkflow_approvers` | `char` | | ☐ | | | `defaultContractSubcontractorWorkflow_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultContractSubcontractorWorkflow_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultContractSubcontractorWorkflow_id` | `int64` | | ☐ | ID of the approval workflow. | | `defaultContractSubcontractorWorkflow_isDeduplicated` | `char` | | ☐ | Whether the criteria has been deduplicated. | | `defaultContractSubcontractorWorkflow_isRestricted` | `char` | | ☐ | Whether the criteria is restricted. | | `defaultContractSubcontractorWorkflow_name` | `varchar2`(255) | | ☐ | Name of the approval workflow. | | `defaultContractSubcontractorWorkflow_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultContractSubcontractorWorkflow_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseInvoiceWorkflow_approver1_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver1_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseInvoiceWorkflow_approver1_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseInvoiceWorkflow_approver1_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseInvoiceWorkflow_approver1_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver1_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseInvoiceWorkflow_approver2_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver2_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseInvoiceWorkflow_approver2_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseInvoiceWorkflow_approver2_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseInvoiceWorkflow_approver2_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver2_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseInvoiceWorkflow_approver3_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver3_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseInvoiceWorkflow_approver3_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseInvoiceWorkflow_approver3_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseInvoiceWorkflow_approver3_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver3_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseInvoiceWorkflow_approver4_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver4_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseInvoiceWorkflow_approver4_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseInvoiceWorkflow_approver4_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseInvoiceWorkflow_approver4_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver4_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseInvoiceWorkflow_approver5_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver5_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseInvoiceWorkflow_approver5_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseInvoiceWorkflow_approver5_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseInvoiceWorkflow_approver5_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseInvoiceWorkflow_approver5_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseInvoiceWorkflow_approvers` | `char` | | ☐ | | | `defaultPurchaseInvoiceWorkflow_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseInvoiceWorkflow_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseInvoiceWorkflow_id` | `int64` | | ☐ | ID of the approval workflow. | | `defaultPurchaseInvoiceWorkflow_isDeduplicated` | `char` | | ☐ | Whether the criteria has been deduplicated. | | `defaultPurchaseInvoiceWorkflow_isRestricted` | `char` | | ☐ | Whether the criteria is restricted. | | `defaultPurchaseInvoiceWorkflow_name` | `varchar2`(255) | | ☐ | Name of the approval workflow. | | `defaultPurchaseInvoiceWorkflow_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseInvoiceWorkflow_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseOrderWorkflow_approver1_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseOrderWorkflow_approver1_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseOrderWorkflow_approver1_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseOrderWorkflow_approver1_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseOrderWorkflow_approver1_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseOrderWorkflow_approver1_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseOrderWorkflow_approver2_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseOrderWorkflow_approver2_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseOrderWorkflow_approver2_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseOrderWorkflow_approver2_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseOrderWorkflow_approver2_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseOrderWorkflow_approver2_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseOrderWorkflow_approver3_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseOrderWorkflow_approver3_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseOrderWorkflow_approver3_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseOrderWorkflow_approver3_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseOrderWorkflow_approver3_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseOrderWorkflow_approver3_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseOrderWorkflow_approver4_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseOrderWorkflow_approver4_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseOrderWorkflow_approver4_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseOrderWorkflow_approver4_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseOrderWorkflow_approver4_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseOrderWorkflow_approver4_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseOrderWorkflow_approver5_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseOrderWorkflow_approver5_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseOrderWorkflow_approver5_id` | `int64` | | ☐ | ID of the approver. | | `defaultPurchaseOrderWorkflow_approver5_type` | `int64` | | ☐ | Approver type. | | `defaultPurchaseOrderWorkflow_approver5_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseOrderWorkflow_approver5_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `defaultPurchaseOrderWorkflow_approvers` | `char` | | ☐ | | | `defaultPurchaseOrderWorkflow_createdAt` | `datetime` | | ☐ | The creation time of the entity. | | `defaultPurchaseOrderWorkflow_createdBy` | `varchar2` | | ☐ | The user that created the entity. | | `defaultPurchaseOrderWorkflow_id` | `int64` | | ☐ | ID of the approval workflow. | | `defaultPurchaseOrderWorkflow_isDeduplicated` | `char` | | ☐ | Whether the criteria has been deduplicated. | | `defaultPurchaseOrderWorkflow_isRestricted` | `char` | | ☐ | Whether the criteria is restricted. | | `defaultPurchaseOrderWorkflow_name` | `varchar2`(255) | | ☐ | Name of the approval workflow. | | `defaultPurchaseOrderWorkflow_updatedAt` | `datetime` | | ☐ | The last updated time of the entity. | | `defaultPurchaseOrderWorkflow_updatedBy` | `varchar2` | | ☐ | The user that last updated the entity. | | `id` | `int64` | ID | ☐ | ID of the approval template setting. | | `updatedAt` | `datetime` | Updated At | ☐ | The last updated time of the entity. | | `updatedBy` | `varchar2` | Updated by | ☐ | The user that last updated the entity. |