Rental Mutation

    API Details

    Property Value
    Endpoint /tablesHousing/rentalMutations
    Table name RentalMutationHSG
    Table id 11282361
    Table caption Rental Mutation
    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
    entryNo No. Integer 4 *
    realtyObjectNo Realty Object No. Code 20
    termContractEntryNo Terminated Contract Entry No. Integer 4
    termContractCustNo Terminated Contract Customer No. Code 20
    termContractStartingDate Terminated Contract Starting Date Date 4
    termContractEndingDate Terminated Contract Ending Date Date 4
    termContractStatus Terminated Contract Status Option 4 New, Current, Old, , , , , , ,
    termContractProposalForm Terminated Contract Proposal Form Code 20
    termContractProposalType Terminated Contract Proposal Type Code 20
    veraDestinationCode VERA Destination Code Code 10
    realtyObjectStreet Realty Object Street Text 50
    realtyObjectHouseNo Realty Object House No. Code 20
    realtyObjectAddition Realty Object Addition Code 20
    realtyObjectPostCode Realty Object Post Code Code 20
    realtyObjectCity Realty Object City Text 30
    municipalityCode Municipality Code Code 10
    cbsNeighborhoodCode CBS Neighborhood Code Code 8
    cbsDistrictCode CBS District Code Code 6
    justifyAsHouse Justify as House Option 4 , Yes, No
    livingSpace Property Valuation System Option 4 IndependentLivingSpace, SharedAccommodation, MobileHome, Stand, None
    daebIndicator DAEB Indicator Text 20
    responsibilityCenter Responsibility Center Code 10
    currentLabelCondition Destination Code 20
    realtyObjectType Realty Object Type Code 10
    targetGroupCode Target Group Code Code 10
    veraUnitTypeCode VERA Unit Type Code Code 10
    veraUnitDetailTypeCode VERA Unit Detail Type Code Code 10
    veraTargetGroupCode VERA Target Group Code Code 10
    veraLivingFormCode VERA Living Form Code Code 10
    veraQualityLevelCode VERA Quality Level Code Code 10
    workAreaCode Work Area Code Code 20
    resignationReceptionDate Resignation Reception Date Date 4
    resignationReasonCode Resignation Reason Code Code 20
    contactDetailsChangeDate Contact Details Change Date Date 4
    resignationTreatingEmployee Resignation Treating Employee Code 20
    preInspectionCount Pre-Inspection Count Integer 4
    finalInspectionCount Final Inspection Count Integer 4
    mutationType Mutation Type Code 20
    changeType Change Type Code 20
    upcomingInspectionDate Upcoming Inspection Date Date 4
    upcomingInspPerformerCode Upcoming Inspection Performer Code 20
    rentalProposalEntryNo Rental Proposal Entry No. Integer 4
    rentalProposalStatus Rental Proposal Status Option 4 Current Offer, Accepted, Expired, , , , , , ,
    rentalAppStatus RentalApp Status Option 4 , In Process, Completed, Canceled
    visitDate Delivery Date Date 4
    visitTime Delivery Time Time 4
    rentalAgentCode Rental Agent Code Code 20
    rentPropTreatingEmployee Proposal Treating Employee Code 20
    newContractProposalForm New Contract Proposal Form Code 20
    newContractProposalType New Contract Proposal Type Code 20
    newContractStartingDate New Contract Starting Date Date 4
    newContractNetRent New Contract Net Rent Decimal 12
    newContractGrossRent New Contract Gross Rent Decimal 12
    maintenanceRequestNo Maintenance Request No. Code 20
    resignationConfirmationSent Rental Resignation Confirmation is Sent Option 4 No, Yes
    floorPlansUpdated Floor Plans are Updated Option 4 No, Yes
    announcementToComakerSent Announcement to Comaker is Sent Option 4 No, Yes
    propertyValuationUpdated Property Valuation is Updated Option 4 No, Yes, N/A
    publicationForWrvClosed Publication for WRV is Closed Option 4 No, Yes
    candidatesSelectedInWrv Candidates are Selected in WRV Option 4 No, Yes
    candidateInvitedForChecking Candidate is Invited for Checking Option 4 No, Yes
    draftRentalContractSent Draft Rental Contract is Sent Option 4 No, Yes
    candidateHasRefused Candidate has Refused Option 4 No, Yes
    candidatesInvitedForSigning Candidates are Invited for Signing Option 4 No, Yes
    rentalContractSigned Rental Contract is Signed Option 4 No, Yes
    rentalResignationRegistered Rental Resignation is Registered Option 4 No, Yes
    allInspectionsPlanned All Inspections are Planned Option 4 No, Yes, N/A
    firstInspectionCompleted First Inspection is Completed Option 4 No, Yes, N/A
    finalSettlementSent Final Settlement was Sent Option 4 No, Yes
    allMaintenanceOrdersCompleted All Maintenance Orders are Completed Option 4 No, Yes
    proposalRentDetermined Proposal Rent is Determined Option 4 No, Yes
    lettablePerDateMarkedDef Lettable per Date is Marked as Definitive Option 4 No, Yes
    lettablePerDate Lettable per Date Date 4
    proposalContractAccepted Proposal Contract is Accepted Option 4 No, Yes
    proposalRentAuthorized Proposal Rent is Authorized Option 4 No, Yes, N/A
    proposalRentApproved Proposal Rent is Approved Option 4 No, Yes, N/A
    rentalJustificationComplete Rental Justification is Complete Option 4 No, Yes
    availableRealtyObjectSent Available Realty Object is Sent Option 4 No, Yes
    rentalProposalAccepted Rental Proposal is Accepted Option 4 No, Yes
    proposalRentDeviatReasonSel Deviation Reason for Proposal Rent is Selected Option 4 No, Yes, N/A
    rentalJustificationFinalized Rental Justification is Finalized Option 4 No, Yes
    mutationCompleted Mutation is Completed Boolean 4
    allInspectionsCompleted All Inspections are Completed Option 4 No, Yes, N/A
    floorPlanNotUpToDate Floor Plan is Not Up To Date Option 4 No, Yes
    leavingTenantSubProcCompleted Leaving Tenant Sub-process is Completed Boolean 4
    newRentalSubProcCompleted New Rental Sub-process is Completed Boolean 4
    realtyObjectAddress Realty Object Address Text 100
    realtyObjectInRentalMediation Realty Object is in Rental Mediation Option 4 No, Yes
    signedRentalContrSent Signed Rental Contract is Sent Option 4 No, Yes
    automaticallyComplete Automatically Complete Boolean 4
    assignedUserId Assigned User ID Code 50 User Setup
    keysAreReceived Keys are Received Option 4 No, Yes
    digitalSigningProcessStatus Digital Signing Process Status Option 4 NotApplicable, NotStarted, StartedDocEditable, StartedDocInSigning, Completed, Rejected
    newRentalCustomerNo New Rental Customer No. Code 20
    newRentalCustomerName New Rental Customer Name 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