Fixture Column Definition

    API Details

    Property Value
    Endpoint /tablesRealEstate/fixtureColumnDefinitions
    Table name Fixture Column Definition
    Table id 11024200
    Table caption Fixture Column Definition
    Data per company True
    Group RealEstate

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    tabel Table Option 4 * Cluster, OGE, Template, Leefbaarheid
    fixtureCategory Category Option 4 * Fixture, Heating, Water, Other
    columnNo Column No. Integer 4 *
    description Description Text 30
    fieldType Field Type Option 4 Text, Boolean, Decimal, Date, Option, Integer, Formule
    optionValues Option Values Text 250
    formula Formula Text 250
    fieldFormat Field Format Option 4 , Datum kort, Datum lang, Gehele getallen, 1 decimaal, 2 decimalen, Overig
    specialFormat Special format Text 100
    sourceTableID Source Table ID Integer 4
    fieldNo FieldNo. Integer 4
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8