Rental Justification

    API Details

    Property Value
    Endpoint /tablesHousing/rentalJustifications
    Table name Rental Justification
    Table id 11152113
    Table caption Rental Justification
    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
    realtyObjectNo Realty Object No. Code 20 * OGE
    entryNo Rental Proposal Entry No. Integer 4 *
    versionNo Version No. Integer 4 *
    daebIndicator DAEB Indicator Option 4 , Non-House - DAEB, Non-House - Non-DAEB, House - DAEB, House - Non-DAEB
    nonHouse Appropriateness Test Not Applicable Boolean 4
    daebNotApplicable State Aid Regulation Not Applicable Boolean 4
    netRentalPrice Proposal Rent Decimal 12
    rentalPriceCategory Rent Price Category Code 10 Capping Limit Rent Surcharge
    rentalPriceExceedsLibLimit Rental Above Liberalization Limit Boolean 4
    currentTenant Current Tenant Boolean 4
    legalEntityTenant Legal Entity Tenant Boolean 4
    subletThroughLegalEntity Sublet Through Legal Entity Boolean 4
    targetGroupApprCode Target Group Appr. Code Code 10
    targetGroupStateAidCode Target Group State Aid Code Code 10
    noOfNamesOnContract No. of Contract Partners Integer 4
    noOfPeopleInHousehold No. of People in Household Integer 4
    birthdateBreadwinner Birth Date Eldest Person Date 4
    statePensionEntitled State Pension Entitled Option 4 Indeterminable, Not Entitled, Entitled
    householdIncome Reviewed Household Income Decimal 12
    incomeCategoryAppropriatenes Income Category Appropriatenes Code 10
    incomeCategoryDAEBtest Income Category DAEB Test Option 4 , Income <= Income Limit Low, Income between Income Limit Low and High, Income > Income Limit High
    startDateRentalContract Start Date Rental Contract Date 4
    appropriatenessCategory Appropriateness Category Integer 4
    nonAppropriateRented Non-Appropriate Rented Boolean 4
    nonAppropriateRentedReason Non-Appropriate Rented Reason Code 10 Reason Non-appropriate Rented
    incompleteDossier Incomplete Dossier Boolean 4
    incompleteDossierReason Incomplete Dossier Reason Code 10 Incomplete Justif. Reason Code
    daebTestCategory DAEB Test Category Option 4 Empty, RentalProposalCurrentTenantNotTested, RentedNonHouseOrNotDAEBNotTested, DAEBRentedToTargetGroup, DAEBRentedIncomeLimitLow, DAEBRentedIncomeLimitLowToHigh, NotDAEBRented, DAEBRentedMultiPersonHHIncomeLimitLowToHigh, RentedToLegalEntityNotTested
    nonDAEBRentedOut Non-DAEB Rented Out Boolean 4
    nonDAEBRentedOutReason Non-DAEB Rented Out Reason Code 10 Income Exceeded Reason
    testedForAppropriateness Tested for Appropriateness Option 4 , Not Tested, Appropriately Rented Out, Not Appropriately Rented Out
    testedForDAEB Tested for DAEB Option 4 , Not DAEB Tested, DAEB Tested
    activeUser Active User Code 20 Salesperson/Purchaser
    nameActiveUser Name Active User Text 100
    testFinished Justification Definitive Boolean 4
    noOfExtraPersons No. of Extra Persons Integer 4
    extraPersonsReasonCode Extra Persons Reason Code Code 20 Extra Pers Rental Just. Reason
    daebIndicatorAdmOwner DAEB Indicator Administrative Owner Option 4 DAEB, Non-DAEB,
    justifyAsHouse Justify as House Option 4 , Yes, No
    detHouseholdDetailsManually Determine Household Details Manually Boolean 4
    contractPartnerRoleCode Contract Partner Role Code Code 10 Role
    personsAndIncomeCleared Persons and Income Cleared Boolean 4
    auditingDate Auditing Date Date 4
    clearingReferenceDate Clearing Reference Date Date 4
    municipalityCode Municipality Code Code 10
    municipalityName Municipality Name Text 250
    reviewedHouseholdCapital Reviewed Household Capital Decimal 12
    capitalCategoryAppropriateCode Capital Category Appropriateness Code Code 10 CapitalLimitAppropriatenTest
    expired Expired 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