Please enable JavaScript to view this site.

Navigation: Schema: Approval > Tabellen

DefaultApprovalSettings: Bouw7 Standaard Goedkeuringsinstellingen

Find the default approval settings for the current organization.Find the default approval settings.

Catalogus: Bouw7

Schema: Approval

Label: Standaard Goedkeuringsinstellingen

Dit is een alleen-lezen tabel. De Bouw7 API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive SQL-stuurprogramma voor Bouw7 ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Bouw7-API.

Tabelkolommen

De kolommen van de tabel DefaultApprovalSettings worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.

Naam

Datatype

Label

Verplicht

Documentatie

createdAt

string

Aangemaakt op

The creation time of the entity.

createdBy

string

Gemaakt door

The user that created the entity.

defaultContractSubcontractorWorkflow_approver1_createdAt

string

 

The creation time of the entity.

defaultContractSubcontractorWorkflow_approver1_createdBy

string

 

The user that created the entity.

defaultContractSubcontractorWorkflow_approver1_id

int64

 

ID of the approver.

defaultContractSubcontractorWorkflow_approver1_type

int64

 

Approver type.

defaultContractSubcontractorWorkflow_approver1_updatedAt

string

 

The last updated time of the entity.

defaultContractSubcontractorWorkflow_approver1_updatedBy

string

 

The user that last updated the entity.

defaultContractSubcontractorWorkflow_approver2_createdAt

string

 

The creation time of the entity.

defaultContractSubcontractorWorkflow_approver2_createdBy

string

 

The user that created the entity.

defaultContractSubcontractorWorkflow_approver2_id

int64

 

ID of the approver.

defaultContractSubcontractorWorkflow_approver2_type

int64

 

Approver type.

defaultContractSubcontractorWorkflow_approver2_updatedAt

string

 

The last updated time of the entity.

defaultContractSubcontractorWorkflow_approver2_updatedBy

string

 

The user that last updated the entity.

defaultContractSubcontractorWorkflow_approver3_createdAt

string

 

The creation time of the entity.

defaultContractSubcontractorWorkflow_approver3_createdBy

string

 

The user that created the entity.

defaultContractSubcontractorWorkflow_approver3_id

int64

 

ID of the approver.

defaultContractSubcontractorWorkflow_approver3_type

int64

 

Approver type.

defaultContractSubcontractorWorkflow_approver3_updatedAt

string

 

The last updated time of the entity.

defaultContractSubcontractorWorkflow_approver3_updatedBy

string

 

The user that last updated the entity.

defaultContractSubcontractorWorkflow_approver4_createdAt

string

 

The creation time of the entity.

defaultContractSubcontractorWorkflow_approver4_createdBy

string

 

The user that created the entity.

defaultContractSubcontractorWorkflow_approver4_id

int64

 

ID of the approver.

defaultContractSubcontractorWorkflow_approver4_type

int64

 

Approver type.

defaultContractSubcontractorWorkflow_approver4_updatedAt

string

 

The last updated time of the entity.

defaultContractSubcontractorWorkflow_approver4_updatedBy

string

 

The user that last updated the entity.

defaultContractSubcontractorWorkflow_approver5_createdAt

string

 

The creation time of the entity.

defaultContractSubcontractorWorkflow_approver5_createdBy

string

 

The user that created the entity.

defaultContractSubcontractorWorkflow_approver5_id

int64

 

ID of the approver.

defaultContractSubcontractorWorkflow_approver5_type

int64

 

Approver type.

defaultContractSubcontractorWorkflow_approver5_updatedAt

string

 

The last updated time of the entity.

defaultContractSubcontractorWorkflow_approver5_updatedBy

string

 

The user that last updated the entity.

defaultContractSubcontractorWorkflow_approvers

boolean

 

 

defaultContractSubcontractorWorkflow_createdAt

string

 

The creation time of the entity.

defaultContractSubcontractorWorkflow_createdBy

string

 

The user that created the entity.

defaultContractSubcontractorWorkflow_id

int64

 

ID of the approval workflow.

defaultContractSubcontractorWorkflow_isDeduplicated

boolean

 

Whether the criteria has been deduplicated.

defaultContractSubcontractorWorkflow_isRestricted

boolean

 

Whether the criteria is restricted.

defaultContractSubcontractorWorkflow_name

string(255)

 

Name of the approval workflow.

defaultContractSubcontractorWorkflow_updatedAt

string

 

The last updated time of the entity.

defaultContractSubcontractorWorkflow_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseInvoiceWorkflow_approver1_createdAt

string

 

The creation time of the entity.

defaultPurchaseInvoiceWorkflow_approver1_createdBy

string

 

The user that created the entity.

defaultPurchaseInvoiceWorkflow_approver1_id

int64

 

ID of the approver.

defaultPurchaseInvoiceWorkflow_approver1_type

int64

 

Approver type.

defaultPurchaseInvoiceWorkflow_approver1_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseInvoiceWorkflow_approver1_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseInvoiceWorkflow_approver2_createdAt

string

 

The creation time of the entity.

defaultPurchaseInvoiceWorkflow_approver2_createdBy

string

 

The user that created the entity.

defaultPurchaseInvoiceWorkflow_approver2_id

int64

 

ID of the approver.

defaultPurchaseInvoiceWorkflow_approver2_type

int64

 

Approver type.

defaultPurchaseInvoiceWorkflow_approver2_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseInvoiceWorkflow_approver2_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseInvoiceWorkflow_approver3_createdAt

string

 

The creation time of the entity.

defaultPurchaseInvoiceWorkflow_approver3_createdBy

string

 

The user that created the entity.

defaultPurchaseInvoiceWorkflow_approver3_id

int64

 

ID of the approver.

defaultPurchaseInvoiceWorkflow_approver3_type

int64

 

Approver type.

defaultPurchaseInvoiceWorkflow_approver3_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseInvoiceWorkflow_approver3_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseInvoiceWorkflow_approver4_createdAt

string

 

The creation time of the entity.

defaultPurchaseInvoiceWorkflow_approver4_createdBy

string

 

The user that created the entity.

defaultPurchaseInvoiceWorkflow_approver4_id

int64

 

ID of the approver.

defaultPurchaseInvoiceWorkflow_approver4_type

int64

 

Approver type.

defaultPurchaseInvoiceWorkflow_approver4_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseInvoiceWorkflow_approver4_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseInvoiceWorkflow_approver5_createdAt

string

 

The creation time of the entity.

defaultPurchaseInvoiceWorkflow_approver5_createdBy

string

 

The user that created the entity.

defaultPurchaseInvoiceWorkflow_approver5_id

int64

 

ID of the approver.

defaultPurchaseInvoiceWorkflow_approver5_type

int64

 

Approver type.

defaultPurchaseInvoiceWorkflow_approver5_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseInvoiceWorkflow_approver5_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseInvoiceWorkflow_approvers

boolean

 

 

defaultPurchaseInvoiceWorkflow_createdAt

string

 

The creation time of the entity.

defaultPurchaseInvoiceWorkflow_createdBy

string

 

The user that created the entity.

defaultPurchaseInvoiceWorkflow_id

int64

 

ID of the approval workflow.

defaultPurchaseInvoiceWorkflow_isDeduplicated

boolean

 

Whether the criteria has been deduplicated.

defaultPurchaseInvoiceWorkflow_isRestricted

boolean

 

Whether the criteria is restricted.

defaultPurchaseInvoiceWorkflow_name

string(255)

 

Name of the approval workflow.

defaultPurchaseInvoiceWorkflow_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseInvoiceWorkflow_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseOrderWorkflow_approver1_createdAt

string

 

The creation time of the entity.

defaultPurchaseOrderWorkflow_approver1_createdBy

string

 

The user that created the entity.

defaultPurchaseOrderWorkflow_approver1_id

int64

 

ID of the approver.

defaultPurchaseOrderWorkflow_approver1_type

int64

 

Approver type.

defaultPurchaseOrderWorkflow_approver1_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseOrderWorkflow_approver1_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseOrderWorkflow_approver2_createdAt

string

 

The creation time of the entity.

defaultPurchaseOrderWorkflow_approver2_createdBy

string

 

The user that created the entity.

defaultPurchaseOrderWorkflow_approver2_id

int64

 

ID of the approver.

defaultPurchaseOrderWorkflow_approver2_type

int64

 

Approver type.

defaultPurchaseOrderWorkflow_approver2_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseOrderWorkflow_approver2_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseOrderWorkflow_approver3_createdAt

string

 

The creation time of the entity.

defaultPurchaseOrderWorkflow_approver3_createdBy

string

 

The user that created the entity.

defaultPurchaseOrderWorkflow_approver3_id

int64

 

ID of the approver.

defaultPurchaseOrderWorkflow_approver3_type

int64

 

Approver type.

defaultPurchaseOrderWorkflow_approver3_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseOrderWorkflow_approver3_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseOrderWorkflow_approver4_createdAt

string

 

The creation time of the entity.

defaultPurchaseOrderWorkflow_approver4_createdBy

string

 

The user that created the entity.

defaultPurchaseOrderWorkflow_approver4_id

int64

 

ID of the approver.

defaultPurchaseOrderWorkflow_approver4_type

int64

 

Approver type.

defaultPurchaseOrderWorkflow_approver4_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseOrderWorkflow_approver4_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseOrderWorkflow_approver5_createdAt

string

 

The creation time of the entity.

defaultPurchaseOrderWorkflow_approver5_createdBy

string

 

The user that created the entity.

defaultPurchaseOrderWorkflow_approver5_id

int64

 

ID of the approver.

defaultPurchaseOrderWorkflow_approver5_type

int64

 

Approver type.

defaultPurchaseOrderWorkflow_approver5_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseOrderWorkflow_approver5_updatedBy

string

 

The user that last updated the entity.

defaultPurchaseOrderWorkflow_approvers

boolean

 

 

defaultPurchaseOrderWorkflow_createdAt

string

 

The creation time of the entity.

defaultPurchaseOrderWorkflow_createdBy

string

 

The user that created the entity.

defaultPurchaseOrderWorkflow_id

int64

 

ID of the approval workflow.

defaultPurchaseOrderWorkflow_isDeduplicated

boolean

 

Whether the criteria has been deduplicated.

defaultPurchaseOrderWorkflow_isRestricted

boolean

 

Whether the criteria is restricted.

defaultPurchaseOrderWorkflow_name

string(255)

 

Name of the approval workflow.

defaultPurchaseOrderWorkflow_updatedAt

string

 

The last updated time of the entity.

defaultPurchaseOrderWorkflow_updatedBy

string

 

The user that last updated the entity.

id

int64

ID

ID of the approval template setting.

updatedAt

string

Bijgewerkt op

The last updated time of the entity.

updatedBy

string

Bijgewerkt door

The user that last updated the entity.

 

22-12-2022 21:20 Versie 22.1.101-BETA+3681