---
title: "ViewStatements"
url: "https://developer.tesma.com/apis/logistics-api-26/versions/484d1e1b-3201-4f8b-800b-867280d5b6a4/schemas/ViewStatements"
---

> Full API specification: https://developer.tesma.com/apis/logistics-api-26/versions/484d1e1b-3201-4f8b-800b-867280d5b6a4.md

# ViewStatements

## OpenAPI definition

```yaml
openapi: 3.1.1
info:
  title: " API v1"
  version: 26.13.0.0
components:
  schemas:
    StatementTable:
      properties:
        _changedProperties:
          type:
            - "null"
            - object
        _changedPropertyNames:
          items:
            type: string
          type:
            - "null"
            - array
        _internalReferenceID:
          type:
            - "null"
            - string
        additionalProperties:
          type:
            - "null"
            - object
        childTables:
          items:
            $ref: "#/components/schemas/StatementTable"
          type:
            - "null"
            - array
        condition:
          type:
            - "null"
            - string
        dataState:
          $ref: "#/components/schemas/BusinessObjectState"
        joinType:
          $ref: "#/components/schemas/SqlJoinTypes"
        joins:
          items:
            $ref: "#/components/schemas/StatementJoin"
          type:
            - "null"
            - array
        level:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        parentTable:
          $ref: "#/components/schemas/StatementTable"
        parentTableID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        sortIndex:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        tableID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        tableName:
          type:
            - "null"
            - string
        viewID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
      type: object
    BusinessObjectState:
      type: integer
    SqlJoinTypes:
      type: integer
    StatementJoin:
      properties:
        _changedProperties:
          type:
            - "null"
            - object
        _changedPropertyNames:
          items:
            type: string
          type:
            - "null"
            - array
        _internalReferenceID:
          type:
            - "null"
            - string
        additionalProperties:
          type:
            - "null"
            - object
        childField:
          $ref: "#/components/schemas/Field"
        childFieldID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        childTableID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        dataState:
          $ref: "#/components/schemas/BusinessObjectState"
        parentField:
          $ref: "#/components/schemas/Field"
        parentFieldID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        viewID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
      type: object
    Field:
      properties:
        businessObjectID:
          type:
            - "null"
            - string
        canBeSelected:
          type: boolean
        canBeUpdated:
          type: boolean
        caption:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        contentType:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        databaseAccessMode:
          $ref: "#/components/schemas/DatabaseAccessMode"
        decimalPlaces:
          format: int16
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        format:
          type:
            - "null"
            - string
        fullName:
          type:
            - "null"
            - string
        id:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        ignoreForChangeLog:
          type: boolean
        internalSchemaDataType:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - "null"
            - integer
            - string
        isClonable:
          type: boolean
        isPartOfPrimaryKey:
          type: boolean
        isRequired:
          type: boolean
        length:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        lookupID:
          type:
            - "null"
            - string
        maxValue:
          format: int64
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        metaDataType:
          $ref: "#/components/schemas/MetaDataType"
        minValue:
          format: int64
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        name:
          type:
            - "null"
            - string
        nextNumName:
          type:
            - "null"
            - string
        propertyName:
          type:
            - "null"
            - string
        schemaCharacterLength:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - "null"
            - integer
            - string
        schemaDataType:
          $ref: "#/components/schemas/SqlServerTypeId"
        schemaIsNullable:
          type: boolean
        schemaPrecision:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - "null"
            - integer
            - string
        schemaScale:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - "null"
            - integer
            - string
        securityFieldID:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        tableName:
          type:
            - "null"
            - string
        tooltip:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
        type:
          $ref: "#/components/schemas/SqlDataType"
      type: object
    DatabaseAccessMode:
      type: integer
    MetaDataType:
      type: integer
    SqlServerTypeId:
      type: integer
    SqlDataType:
      type: integer
    ViewStatements:
      properties:
        statementTables:
          items:
            $ref: "#/components/schemas/StatementTable"
          type:
            - "null"
            - array
        viewId:
          format: int32
          pattern: ^-?(?:0|[1-9]\d*)$
          type:
            - integer
            - string
      type: object
```