Fixture

    API Details

    Property Value
    Endpoint /tablesRealEstate/fixtures
    Table name Fixture
    Table id 11024080
    Table caption Fixture
    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
    entryNo Entry No. Integer 4 *
    lineType Line Type Option 4 None, Title, Line
    group Group Code 20
    table Table Option 4 Cluster, OGE, ClusterTemplate, Leefbaarheid, OGETemplate, CATemplate
    no No. Code 20
    technicalClusterNo Technical Cluster No. Code 20
    category Category Option 4 Fixture, Heating, Water, Other
    fixtureItem Fixture item Code 20
    collective Collective Boolean 4
    fixtureItemType Fixture item type Code 20
    installDate Installation date fixture item Date 4
    yearOfManufacture Year of manufacture Integer 4
    vendorNo Vendor No. Code 20 Vendor
    maintVendorNo Maint. Vendor No. Code 20 Vendor
    warrantyPeriod Warranty Period DateFormula 32
    maintContractStartDate Maint. Contract Start Date Date 4
    maintContractEndDate Maint. Contract End Date Date 4
    zav ZAV Boolean 4
    warrantyValidTil Warranty Valid Til Date 4
    chimneySwept Schoorsteen geveegd Boolean 4
    politiekeurmerk Seal of police Boolean 4
    afgiftedatumPolitiekeurmerk Date of issue seal of police Date 4
    datumPrevOnderhoud Date previous maint. Date 4
    maintenancePeriod Maintenance Period DateFormula 32
    asbestosPresent Asbestos present Boolean 4
    locationAsbestos Location asbestos Text 30
    electrinstGetest Electr. settings tested Boolean 4
    elektrInstGetestOp Electr. settings tested on Date 4
    gasinstGetest Gas settings tested Boolean 4
    gasinstGetestOp Gas settings tested on Date 4
    flueChecked Flue checked Boolean 4
    flueCheckedOn Flue checked on Date 4
    flueCheckedBy Flue checked by name Code 20 Vendor
    serialNo Serial No. Text 30
    condensTstukAanwezig Condens. T-piece present Option 4 , Ja, Nee
    guarantor Guarantor Code 20 Vendor
    continueAutomatically Continue Automatically Boolean 4
    warningZAVActive Warning ZAV Active Boolean 4
    warningExternalActive Warning External Ownership Active Boolean 4
    warningMiscellaniousActive Warning Miscellaneous Active Boolean 4
    checkWith Check with Code 20
    checkType Check type Option 4 , , , ConstructionPart, Part
    chimneySweptOn Chimney swept on Date 4
    color Color Text 30
    location Location Text 30
    itemNo Item No. Code 20 Item
    description Description Text 100
    exist Exist Boolean 4
    surface Surface Decimal 12
    size Size Text 20
    brand Brand Text 30
    type Type Text 50
    quantity Quantity Decimal 12
    externalOwner Corp. Property Boolean 4
    remark Remarks Text 50
    inventory Inventory Boolean 4
    contract Contract Boolean 4
    documentNo Document No. Text 20
    owner Owner Code 20 Contact
    room Room Code 20 DM - Room Type
    gebruiksoppervlakM2 Usage surface (m2) Decimal 12
    expectedLifeCycle Expected Life Cycle Integer 4
    unitOfMeasure Unit of Measure Code 10 Unit of Measure
    maintenanceType Maintenance Type Code 20 Maintenance Type
    installVendorNo Install. Vendor No. Code 20 Vendor
    aanschafkostenExBTW Purchase costs (excl. VAT) Decimal 12
    maintenanceContractNo Maintenance Contract No. Code 20 Maintenance Contract
    userDefinedField1 Vrij veld 1 Text 50
    userDefinedField2 Vrij veld 2 Text 50
    userDefinedField3 Vrij veld 3 Text 50
    userDefinedField4 Vrij veld 4 Text 50
    userDefinedField5 Vrij veld 5 Text 50
    userDefinedField6 Vrij veld 6 Text 50
    userDefinedField7 Vrij veld 7 Text 50
    userDefinedField8 Vrij veld 8 Text 50
    userDefinedField9 Vrij veld 9 Text 50
    userDefinedField10 Vrij veld 10 Text 50
    userDefinedField11 Vrij veld 11 Text 50
    userDefinedField12 Vrij veld 12 Text 50
    userDefinedField13 Vrij veld 13 Text 50
    userDefinedField14 Vrij veld 14 Text 50
    userDefinedField15 Vrij veld 15 Text 50
    userDefinedField16 Vrij veld 16 Text 50
    userDefinedField17 Vrij veld 17 Text 50
    userDefinedField18 Vrij veld 18 Text 50
    userDefinedField19 Vrij veld 19 Text 50
    userDefinedField20 Vrij veld 20 Text 50
    indentation Indentation Integer 4
    address Address Text 100
    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