Livability Dossier

    API Details

    Property Value
    Endpoint /tablesHousing/livabilityDossiers
    Table name Livability Dossier
    Table id 11024047
    Table caption Livability Dossier
    Data per company True
    Group Housing

    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
    eenheidnr Unit No. Code 20 OGE
    klachtsoort Complaint Type Code 20 Service Call Type
    description Description Text 100
    datum Date Date 4
    status Status Option 4 , In behandeling, Toestemming aangevraagd, Toestemming, Afwijzing, Afgewezen, Opdracht, Offerte, Opdracht gegund, Onderhoudsdienst, Opdracht gereed, Afgehandeld
    uitvoeringstermijn Execution Period Code 20 Urgency Code
    afhandeling Processed Option 4 Beheerder, Beheergever, Eerste lijn, Tweede lijn
    nrMelder No. Reporter Code 20 Contact
    contactsoort Contact Type Option 4 , Huurder, Beheergever, Klant, Leverancier, Contact, Resource, Werknemer
    naam Name Text 30
    naam2 Name 2 Text 30
    adres Address Text 100
    adres2 Address 2 Text 50
    postcode ZIP Code Code 20 Post Code
    plaats City Text 30
    telefoon Phone Text 30
    telefoon2 Phone 2 Text 30
    fax Fax Text 30
    email E-Mail Text 80
    regelnr Line No. Integer 4
    costCode Cost Code Text 10
    contactpersoon Contact Person Text 30
    bevestiging Confirmation Boolean 4
    bevestigingsdatum Confirmation Date Date 4
    no No. Code 20 *
    tijd Time Time 4
    spoed Urgent Boolean 4
    customerNo Customer No. Code 20 Customer
    customerName Customer Name Initiator Text 100
    customerName2 Name 2 Initiator Text 50
    customerAddress Address Initiator Text 100
    customerAddress2 Address 2 Initiator Text 50
    customerPostCode ZIP Code Initiator Code 20 Post Code
    customerCity City Initiator Text 30
    customerPhoneNo Phone Initiator Text 30
    customerPhoneNo2 Phone 2 Initiator Text 30
    customerFaxNo Fax Initiator Text 30
    customerEMail E-Mail Initiator Text 80
    customerContact Contact Person Initiator Text 50
    aanvragen Request Boolean 4
    datumAanvraag Request Date Date 4
    resultaatAanvraag Result Request Option 4 , Toestemming, Afwijzing
    resultaatMelden Report Result Boolean 4
    meldingsdatum Report Date Result Date 4
    opdrachtdatum Order Date Date 4
    afgehandeldDoor Processed By Code 50
    afgehandeldPer Processed At Date 4
    gereedmeldingPer Ready At Date 4
    nrreeks No. Series Code 20 No. Series
    uitersteDatum Final Date Date 4
    afwijzingsdatum Rejection Date Date 4
    datumToestemming Permission Date Date 4
    offertenr Offer No. Code 20
    ordernr Order No. Code 20
    tenLasteVan Charge To Option 4 Huurder, Beheergever
    opdrachtbon Order Ticket Boolean 4
    tenLasteVanHuurder Charge To Tenant Boolean 4
    pctTenLasteVanHuurder % Charge To Tenant Decimal 12
    bedragTlvHuurderLV Amount To Tenant Decimal 12
    clusternr Cluster No. Code 20
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    assignedPersonCode Assigned Person Code Code 20 Salesperson/Purchaser
    assignedTeamCode Assigned Team Code Code 10 Team
    oudNummer Old No. Code 20
    codeAfhandeling Code Processed Code 20 Service Call Settlement Code
    afhandelingIntern Processed Internal Code 20 Salesperson/Purchaser
    agressionType Agression Type Code 10 Agression Type
    initiator Initiator Code 20 Contact
    sortingLines Sortering regels Option 4 Line Created, Date ascending, Date descending
    urgencyCodeConversion Urgency Code Conversion Code 20
    dossiertype Dossier Type Code 10 Liv. Dossier Type
    dossierstatus File Status Code 10 Liv. Dossier Status
    controledatum Check Date Date 4
    peildatum Reference Date Date 4
    afhandelingsreden Closing Reason Code 10 Liv. Dossier Closing Reason
    schouwsjabloon Liv. Inspection Template Code 10 Liv. Inspection Sjabloon
    juridischeKosten Justice Cost Boolean 4
    budget Budget Decimal 12
    deurwaarder Bailiff Boolean 4
    contractleverancier Vendor Code 20 Vendor
    onderhoudscyclus Maintenance Cycle DateFormula 32
    open Open Boolean 4
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    countNonWorkingDays Count Non-working Days Boolean 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