id id
{
"name": "id",
"type": "primaryKey"
}dealId → deals (Deal the estate belongs to)
{
"name": "dealId",
"type": "foreignKey",
"table": "deals",
"note": "Deal the estate belongs to"
}mainImageFileId → files (Image that represents the estate)
{
"name": "mainImageFileId",
"type": "foreignKey",
"table": "files",
"note": "Image that represents the estate"
}apartmentNumber (Apartment number from housing association.)
{
"name": "apartmentNumber",
"type": "text",
"maxLength": 30,
"note": "Apartment number from housing association."
}governmentApartmentNumber (Official apartment number.)
{
"name": "governmentApartmentNumber",
"type": "text",
"maxLength": 30,
"note": "Official apartment number."
}housingAssociationName
{
"name": "housingAssociationName",
"type": "text",
"maxLength": 100
}housingAssociationIdentifier
{
"name": "housingAssociationIdentifier",
"type": "text",
"maxLength": 20
}housingAssociationFoundedYear
{
"name": "housingAssociationFoundedYear",
"type": "year"
}housingAssociationTaxationType E
{
"name": "housingAssociationTaxationType",
"type": "enum",
"enums": [
"ENUMS_HOUSING_ASSOCIATION_TAXATION_TYPE_NOT_PRIVATE (Ej privatbostadsföretag (oäkta))",
"ENUMS_HOUSING_ASSOCIATION_TAXATION_TYPE_PRIVATE (Privatbostadsföretag (äkta))"
]
}buildingArea
{
"name": "buildingArea",
"type": "decimal",
"digits": 7,
"decimals": 1
}totalLivingArea
{
"name": "totalLivingArea",
"type": "decimal",
"digits": 5,
"decimals": 1
}plotAreaComment T
{
"name": "plotAreaComment",
"type": "text",
"maxLength": 150,
"enums": [
"ENUMS_LIVINGAREACOMMENT_TYPE_NOTE_THAT_THE_EXACT_SIZE_IS_NOT_MEASURED (Arean är uppskattad)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_TAX_INFORMATION (Taxeringsinformationen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_THE_SELLER (Säljaren)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_SELLER_AND_HOUSING_ASSOCIATION (Säljaren och bostadsrättsföreningen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_DRAWING_(S) (Ritning(ar))",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_MEASURING (Mätning)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANDLORD (Hyresvärden)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_CONDOMINIUM_ASSOCIATION (Bostadsrättsföreningen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_OWNERS_OF (Bostadsföreningen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_NO_MEASURING (Mätning saknas)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANTMATERIET (Lantmäteriet)"
]
}note
{
"name": "note",
"type": "text"
}costAccuracy E
{
"name": "costAccuracy",
"type": "enum",
"enums": [
"ENUMS_ESTATE_COST_ACCURACY_ACTUALLY_COST (Faktisk kostnad)",
"ENUMS_ESTATE_COST_ACCURACY_STANDARD_COST (Schablon kostnad)"
]
}totalArea
{
"name": "totalArea",
"type": "decimal",
"digits": 15,
"decimals": 1
}propertyDesignation
{
"name": "propertyDesignation",
"type": "text",
"maxLength": 100
}propertyName
{
"name": "propertyName",
"type": "text",
"maxLength": 150
}identifier
{
"name": "identifier",
"type": "text",
"maxLength": 50
}{
"name": "countryId",
"type": "foreignKey",
"table": "countries",
"schema": "mspx_admin"
}{
"name": "objectTypeId",
"type": "foreignKey",
"table": "objectTypes",
"schema": "mspx_admin"
}{
"name": "objectSubTypeId",
"type": "foreignKey",
"table": "objectSubTypes",
"schema": "mspx_admin"
}objectSubTypeText (When objectSubTypeId is set to OBJECTSUBTYPES_OTHER, we allow the user to write their own sub type in this field.)
{
"name": "objectSubTypeText",
"type": "text",
"maxLength": 100,
"note": "When objectSubTypeId is set to OBJECTSUBTYPES_OTHER, we allow the user to write their own sub type in this field."
}numberOfRoom
{
"name": "numberOfRoom",
"type": "decimal",
"digits": 4,
"decimals": 1
}roomsDescription
{
"name": "roomsDescription",
"type": "text"
}roomsDescriptionMultiLang (Allowed languages: en, sv, es, de, da, fr, nl. Structure: {"en": "text", "sv": "text", "es": "texto" })
{
"name": "roomsDescriptionMultiLang",
"type": "jsonObject",
"validationSchema": {
"id": "estates/roomsDescriptionMultiLang",
"type": "object",
"additionalProperties": false,
"properties": {
"sv": {
"type": "string"
},
"en": {
"type": "string"
},
"es": {
"type": "string"
},
"de": {
"type": "string"
},
"da": {
"type": "string"
},
"fr": {
"type": "string"
},
"nl": {
"type": "string"
}
}
},
"note": "Allowed languages: en, sv, es, de, da, fr, nl. Structure: {\"en\": \"text\", \"sv\": \"text\", \"es\": \"texto\" }"
}numberOfBedrooms
{
"name": "numberOfBedrooms",
"type": "int",
"maxLength": 3
}numberOfBathrooms (Only used for international deals)
{
"name": "numberOfBathrooms",
"type": "int",
"maxLength": 3,
"note": "Only used for international deals"
}numberOfToilets (Only used for international deals)
{
"name": "numberOfToilets",
"type": "int",
"maxLength": 3,
"note": "Only used for international deals"
}swimmingPool E (Only used for international deals)
{
"name": "swimmingPool",
"type": "enum",
"enums": [
"ENUM_ESTATE_SWIMMING_POOL_INSIDE (Inomhus)",
"ENUM_ESTATE_SWIMMING_POOL_OUTSIDE (Utomhus)"
],
"note": "Only used for international deals"
}convertNumberOfBedRooms
{
"name": "convertNumberOfBedRooms",
"type": "int",
"maxLength": 3
}livingArea
{
"name": "livingArea",
"type": "decimal",
"digits": 5,
"decimals": 1
}livingAreaIsApproximate bit (The object description should show that the living area is approximate. livingAreaComment needs to be set to explain why its approximate.)
{
"name": "livingAreaIsApproximate",
"type": "bit",
"note": "The object description should show that the living area is approximate. livingAreaComment needs to be set to explain why its approximate."
}otherLivingArea
{
"name": "otherLivingArea",
"type": "decimal",
"digits": 5,
"decimals": 1
}livingAreaComment T
{
"name": "livingAreaComment",
"type": "text",
"maxLength": 150,
"enums": [
"ENUMS_LIVINGAREACOMMENT_TYPE_NOTE_THAT_THE_EXACT_SIZE_IS_NOT_MEASURED (Arean är uppskattad)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_TAX_INFORMATION (Taxeringsinformationen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_THE_SELLER (Säljaren)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_SELLER_AND_HOUSING_ASSOCIATION (Säljaren och bostadsrättsföreningen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_DRAWING_(S) (Ritning(ar))",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_MEASURING (Mätning)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANDLORD (Hyresvärden)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_CONDOMINIUM_ASSOCIATION (Bostadsrättsföreningen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_OWNERS_OF (Bostadsföreningen)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_NO_MEASURING (Mätning saknas)",
"ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANTMATERIET (Lantmäteriet)"
]
}isLeasehold bit
{
"name": "isLeasehold",
"type": "bit"
}isPartOf bit
{
"name": "isPartOf",
"type": "bit"
}isAcquisitionPermitNeeded bit (swe: förvärvstillstånd)
{
"name": "isAcquisitionPermitNeeded",
"type": "bit",
"note": "swe: förvärvstillstånd"
}isPropertyAssociation bit (Used in tenant ownership to mark a property association/Bostadsförening)
{
"name": "isPropertyAssociation",
"type": "bit",
"note": "Used in tenant ownership to mark a property association/Bostadsförening"
}plotArea
{
"name": "plotArea",
"type": "decimal",
"digits": 15,
"decimals": 1
}waterArea
{
"name": "waterArea",
"type": "decimal",
"digits": 15,
"decimals": 1
}district
{
"name": "district",
"type": "text",
"maxLength": 100
}streetAddress
{
"name": "streetAddress",
"type": "text",
"maxLength": 100
}postalCode
{
"name": "postalCode",
"type": "text",
"maxLength": 20
}city
{
"name": "city",
"type": "text",
"maxLength": 100
}isTenureHouse bit
{
"name": "isTenureHouse",
"type": "bit"
}tenureHouseCost $$ (Holds / year)
{
"name": "tenureHouseCost",
"type": "money",
"note": "Holds / year"
}tenureHousePeriod
{
"name": "tenureHousePeriod",
"type": "text",
"maxLength": 200
}tenureHouseLandLord
{
"name": "tenureHouseLandLord",
"type": "text"
}tenureHouseEndDate
{
"name": "tenureHouseEndDate",
"type": "date"
}feeDescription
{
"name": "feeDescription",
"type": "text"
}premiseType E
{
"name": "premiseType",
"type": "enum",
"enums": [
"ENUM_ESTATE_PREMISE_TYPE_INDUSTRY (Industrier/verkstäder)",
"ENUM_ESTATE_PREMISE_TYPE_OFFICE (Kontor)",
"ENUM_ESTATE_PREMISE_TYPE_OFFICE_HOTEL (Kontorshotell)",
"ENUM_ESTATE_PREMISE_TYPE_OTHER (Annat)",
"ENUM_ESTATE_PREMISE_TYPE_SHOP (Butiker)",
"ENUM_ESTATE_PREMISE_TYPE_STORAGE (Lager/logistik)"
]
}premiseNumber
{
"name": "premiseNumber",
"type": "text",
"maxLength": 30
}premiseTenantContractNumber
{
"name": "premiseTenantContractNumber",
"type": "text",
"maxLength": 30
}moduleArea (Used for premises)
{
"name": "moduleArea",
"type": "decimal",
"digits": 15,
"decimals": 1,
"note": "Used for premises"
}premiseTypeText
{
"name": "premiseTypeText",
"type": "text",
"maxLength": 100
}floorPlanDescription
{
"name": "floorPlanDescription",
"type": "text"
}localServicesDescription
{
"name": "localServicesDescription",
"type": "text"
}businessDescription
{
"name": "businessDescription",
"type": "text"
}displayPremiseRentAs E (Used for premises, only used to display rent on for example OD)
{
"name": "displayPremiseRentAs",
"type": "enum",
"enums": [
"ENUM_ESTATE_DISPLAY_PREMISE_RENT_AS_CURRENCY/MONTH (SEK/MÅNAD)",
"ENUM_ESTATE_DISPLAY_PREMISE_RENT_AS_CURRENCY/YEAR (SEK/ÅR)",
"ENUM_ESTATE_DISPLAY_PREMISE_RENT_AS_CURRENCY/YEAR/M2 (SEK/ÅR/M2)"
],
"note": "Used for premises, only used to display rent on for example OD"
}premiseIndex
{
"name": "premiseIndex",
"type": "text",
"maxLength": 100
}premiseEconomyValuesVATSetting T
{
"name": "premiseEconomyValuesVATSetting",
"type": "text",
"maxLength": 200,
"enums": [
"ENUM_ESTATE_PREMISE_ECONOMY_VALUES_VAT_SETTING_INCLUDED (Tillkommer)",
"ENUM_ESTATE_PREMISE_ECONOMY_VALUES_VAT_SETTING_NOT_INCLUDED (Utgår ej)"
],
"notes": "Used only on premises and will trigger if. "
}premiseHideRentOnMarketingPlaces bit
{
"name": "premiseHideRentOnMarketingPlaces",
"type": "bit"
}premiseHideRentInObjectDescription bit
{
"name": "premiseHideRentInObjectDescription",
"type": "bit"
}premiseRentIsNegotiable bit (If set, do not display the rent, but that the rent is negotiable.)
{
"name": "premiseRentIsNegotiable",
"type": "bit",
"note": "If set, do not display the rent, but that the rent is negotiable."
}businessTradeType E
{
"name": "businessTradeType",
"type": "enum",
"enums": [
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_CARE_AND_HEALTH (Vård & Hälsa)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_CARRIER (Transportföretag)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_COMMERCE/E-COMMERCE (Handel/e-handel)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_CONSTRUCTION (Byggverksamhet)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_HOTEL/TOURIST (Hotell/Turistföretag)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_MANUFACTURING (Tillverkande företag)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_OTHER (Övrigt)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_RESTAURANTS/CAFES (Restauranger/Caféer)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_SERVICE_COMPANY (Tjänsteföretag)",
"ENUM_ESTATE_BUSINESS_TRADE_TYPE_SHOPS (Butiker)"
]
}businessEquipment
{
"name": "businessEquipment",
"type": "text"
}businessEstablishedYear
{
"name": "businessEstablishedYear",
"type": "year"
}businessNumberOfEmployees
{
"name": "businessNumberOfEmployees",
"type": "int unsigned"
}businessNumberOfCustomers
{
"name": "businessNumberOfCustomers",
"type": "int unsigned"
}businessRevenue $$
{
"name": "businessRevenue",
"type": "money"
}businessProfit $$
{
"name": "businessProfit",
"type": "money"
}renovateYear
{
"name": "renovateYear",
"type": "text",
"maxLength": 100
}renovateDescription
{
"name": "renovateDescription",
"type": "text"
}upcomingRenovationsDescription
{
"name": "upcomingRenovationsDescription",
"type": "text"
}heatingType T
{
"name": "heatingType",
"type": "text",
"enums": [
"ENUMS_HEATINGTYPE_TYPE_COMBI_BOILER_WITH_WOOD_OR_ELECTRICITY (Kombipanna med ved eller el)",
"ENUMS_HEATINGTYPE_TYPE_COMBI_BOILER_WITH_OIL_OR_ELECTRICITY (Kombipanna med olja eller el)",
"ENUMS_HEATINGTYPE_TYPE_COMBI_BOILER_WITH_OIL_ELECTRICITY_OR_WOOD (Kombipanna med olja el eller ved)",
"ENUMS_HEATINGTYPE_TYPE_CERAMIC_TILE_FOR_WOOD (Keramikpanna för ved)",
"ENUMS_HEATINGTYPE_TYPE_GAS (Gasvärme)",
"ENUMS_HEATINGTYPE_TYPE_GAS_BOILER (Gaspanna)",
"ENUMS_HEATINGTYPE_TYPE_DISTRICT_HEATING (Fjärrvärme)",
"ENUMS_HEATINGTYPE_TYPE_ELECTRICITY-WATER_HEAT (El - vattenburen värme)",
"ENUMS_HEATINGTYPE_TYPE_EL-AIR_HEATING (El - luftburen värme)",
"ENUMS_HEATINGTYPE_TYPE_DIRECT_ELECTRIC (Direktverkande el)",
"ENUMS_HEATINGTYPE_TYPE_HEAT_PUMP (Värmepump)",
"ENUMS_HEATINGTYPE_TYPE_FIREWOOD (Ved)",
"ENUMS_HEATINGTYPE_TYPE_OIL-FILLED_ELECTRIC_RADIATORS (Oljefyllda el-element)",
"ENUMS_HEATINGTYPE_TYPE_OIL (Olja)",
"ENUMS_HEATINGTYPE_TYPE_PELLET (Pellets)",
"ENUMS_HEATINGTYPE_TYPE_WOODBURNER (Braskamin)",
"ENUMS_HEATINGTYPE_TYPE_HEATPUMP_AIR_TO_AIR (Värmepump luft-luft)",
"ENUMS_HEATINGTYPE_TYPE_HEATPUMP_AIR_TO_WATER (Värmepump luft-vatten)",
"ENUMS_HEATINGTYPE_TYPE_GEOTHERMAL (Bergvärmepump)"
],
"maxLength": 150
}heatingPlantCondition
{
"name": "heatingPlantCondition",
"type": "text",
"maxLength": 100
}heatingPlantAge
{
"name": "heatingPlantAge",
"type": "text",
"maxLength": 40
}heatingPlantBrand
{
"name": "heatingPlantBrand",
"type": "text",
"maxLength": 40
}heatingComment
{
"name": "heatingComment",
"type": "text"
}electricalStemsCondition T
{
"name": "electricalStemsCondition",
"type": "text",
"maxLength": 50,
"enums": [
"ENUMS_ELECTRICALSTEMSCONDITION_TYPE_WIRES_NOT_EXCHANGED (Ledningar ej bytta)",
"ENUMS_ELECTRICALSTEMSCONDITION_TYPE_WIRES_EXCHANGED (Ledningar bytta)"
]
}mainFuse T
{
"name": "mainFuse",
"type": "text",
"maxLength": 10,
"enums": [
"ENUMS_MAINFUSE_TYPE_25_A (25 A)",
"ENUMS_MAINFUSE_TYPE_20_A (20 A)",
"ENUMS_MAINFUSE_TYPE_16_A (16 A)",
"ENUMS_MAINFUSE_TYPE_10_A (10 A)"
]
}electricalComment
{
"name": "electricalComment",
"type": "text"
}standardPoints
{
"name": "standardPoints",
"type": "int"
}internetSummary
{
"name": "internetSummary",
"type": "text"
}electricSafety T
{
"name": "electricSafety",
"type": "text",
"maxLength": 50,
"enums": [
"ENUMS_ELECTRICSAFETY_TYPE_UNEARTHED (Ojordat)",
"ENUMS_ELECTRICSAFETY_TYPE_GROUNDED (Jordat)",
"ENUMS_ELECTRICSAFETY_TYPE_PARTIALLY_GROUNDED (Delvis jordat)"
]
}subFoundationType T
{
"name": "subFoundationType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_SUBFOUNDATIONTYPE_TYPE_SAND (Sand)",
"ENUMS_SUBFOUNDATIONTYPE_TYPE_MORAN (Morän)",
"ENUMS_SUBFOUNDATIONTYPE_TYPE_LERA (Lera)",
"ENUMS_SUBFOUNDATIONTYPE_TYPE_STONE (Sten)"
]
}foundationWallType T
{
"name": "foundationWallType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_FOUNDATIONWALLTYPE_TYPE_WALLS_OF_ROCK (Murar till berg)",
"ENUMS_FOUNDATIONWALLTYPE_TYPE_LECA-STONE (Lecablock)",
"ENUMS_FOUNDATIONWALLTYPE_TYPE_CARVED_IN_STONE (Huggen sten)",
"ENUMS_FOUNDATIONWALLTYPE_TYPE_CASTLEROCK (Gråsten)",
"ENUMS_FOUNDATIONWALLTYPE_TYPE_CONCRETE (Betong)",
"ENUMS_FOUNDATIONWALLTYPE_TYPE_CONCRETE_HOLLOW_BRICK (Betonghålsten)"
]
}foundationType T
{
"name": "foundationType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_FOUNDATIONTYPE_TYPE_TORPARGRUND (Torpargrund)",
"ENUMS_FOUNDATIONTYPE_TYPE_PILES (Pålar)",
"ENUMS_FOUNDATIONTYPE_TYPE_BLOCKS (Plintar)",
"ENUMS_FOUNDATIONTYPE_TYPE_SLAB_ON_GROUND (Platta på mark)",
"ENUMS_FOUNDATIONTYPE_TYPE_WALLS_OF_ROCK (Murar till berg)",
"ENUMS_FOUNDATIONTYPE_TYPE_LECA-STONE (Leca-sten)",
"ENUMS_FOUNDATIONTYPE_TYPE_CARVED_IN_STONE (Huggen sten)",
"ENUMS_FOUNDATIONTYPE_TYPE_CASTLEROCK (Gråsten)",
"ENUMS_FOUNDATIONTYPE_TYPE_FOOTINGS (Grundsula)",
"ENUMS_FOUNDATIONTYPE_TYPE_CONCRETE (Betong)",
"ENUMS_FOUNDATIONTYPE_TYPE_HOLLOW_FOUNDATION (Krypgrund)"
]
}frameType T
{
"name": "frameType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_FRAMETYPE_TYPE_WOOD (Trä)",
"ENUMS_FRAMETYPE_TYPE_BRICK (Tegel)",
"ENUMS_FRAMETYPE_TYPE_STEEL (Stål)",
"ENUMS_FRAMETYPE_TYPE_LIGHTWEIGHT_CONCRETE (Lättbetong)",
"ENUMS_FRAMETYPE_TYPE_CONCRETE (Betong)"
]
}joistType T
{
"name": "joistType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_JOISTTYPE_TYPE_WOOD (Trä)",
"ENUMS_JOISTTYPE_TYPE_LIGHTWEIGHT_CONCRETE (Lättbetong)",
"ENUMS_JOISTTYPE_TYPE_CAST_VAULT (Gjutna valv)",
"ENUMS_JOISTTYPE_TYPE_CONCRETE (Betong)"
]
}facadeType T
{
"name": "facadeType",
"type": "text",
"enums": [
"ENUMS_FACADETYPE_TYPE_WOOD (Träfasad)",
"ENUMS_FACADETYPE_TYPE_BRICK (Tegelstensfasad)",
"ENUMS_FACADETYPE_TYPE_STANDING_PANELED (Stående träpanel)",
"ENUMS_FACADETYPE_TYPE_POLISHES (Puts)",
"ENUMS_FACADETYPE_TYPE_MEXISTEN (Mexisten)",
"ENUMS_FACADETYPE_TYPE_HORIZONTAL_WOOD_PANELING (Liggande träpanel)",
"ENUMS_FACADETYPE_TYPE_LIMESTONE (Kalksandsten)",
"ENUMS_FACADETYPE_TYPE_ETERNIT (Eternit)"
]
}roofingType T
{
"name": "roofingType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_ROOFINGTYPE_TYPE_BRICK (Tegel)",
"ENUMS_ROOFINGTYPE_TYPE_ROOF (Takpannor)",
"ENUMS_ROOFINGTYPE_TYPE_TILES (Taktegel)",
"ENUMS_ROOFINGTYPE_TYPE_SHEET (Plåt)",
"ENUMS_ROOFINGTYPE_TYPE_PAPP (Papp)",
"ENUMS_ROOFINGTYPE_TYPE_COPPERPLATE (Kopparplåt)",
"ENUMS_ROOFINGTYPE_TYPE_ETERNIT (Eternit)",
"ENUMS_ROOFINGTYPE_TYPE_CONCRETE_TILES (Betongpannor)"
]
}guttersType T
{
"name": "guttersType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_GUTTERSTYPE_TYPE_SHEET (Plåt)",
"ENUMS_GUTTERSTYPE_TYPE_PLASTIC (Plast)",
"ENUMS_GUTTERSTYPE_TYPE_COPPER (Koppar)",
"ENUMS_GUTTERSTYPE_TYPE_GALVANIZED_SHEET_METAL_UNPAINTED (Galvaniserad omålad plåt)",
"ENUMS_GUTTERSTYPE_TYPE_GALVANIZED_PAINTED_PLATE (Galvaniserad målad plåt)"
]
}windowsType T
{
"name": "windowsType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_WINDOWSTYPE_TYPE_SIMPLE_WINDOW (Enkelglasfönster)",
"ENUMS_WINDOWSTYPE_TYPE_PAIRED_WINDOWS_WITH_TRANSOMS (Kopplade fönster med spröjs)",
"ENUMS_WINDOWSTYPE_TYPE_PAIRED_WINDOW (Kopplade fönster)",
"ENUMS_WINDOWSTYPE_TYPE_LIGHTWEIGHT_WINDOWS_WITH_TRANSOMS (Enkelglasfönster med spröjs)",
"ENUMS_WINDOWSTYPE_TYPE_GLAZED_WINDOWS_WITH_GLAZING_BARS (Isolerglasfönster med spröjs)",
"ENUMS_WINDOWSTYPE_TYPE_GLAZED (Isolerglasfönster)",
"ENUMS_WINDOWSTYPE_TYPE_3-GLAZED_INSULATING (3-glasfönster isoler)",
"ENUMS_WINDOWSTYPE_TYPE_3-GLASS_WINDOWS_WITH_TRANSOMS (3-glasfönster med spröjs)",
"ENUMS_WINDOWSTYPE_TYPE_3-GLASS_WINDOW (3-glasfönster)",
"ENUMS_WINDOWSTYPE_TYPE_2-GLAZED_WINDOWS_WITH_TRANSOMS (2-glasfönster med spröjs)",
"ENUMS_WINDOWSTYPE_TYPE_2-GLAZED_INSULATING_(SINGLE) (2-glasfönster isoler (enkel))",
"ENUMS_WINDOWSTYPE_TYPE_2-GLAZED_INSULATING (2-glasfönster isoler)",
"ENUMS_WINDOWSTYPE_TYPE_2-GLASS_WINDOWS (2-glasfönster)"
]
}ventilationType T
{
"name": "ventilationType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_VENTILATIONTYPE_TYPE_NATURAL_DRAFT (Självdrag)",
"ENUMS_VENTILATIONTYPE_TYPE_MECHANICAL_SUPPLY_AND_EXHAUST_AIR (Mekanisk till- och frånluft)",
"ENUMS_VENTILATIONTYPE_TYPE_MECHANICAL_EXHAUST_AIR (Mekanisk frånluft)"
]
}ventilationInspectionDate
{
"name": "ventilationInspectionDate",
"type": "date"
}chimneyType T
{
"name": "chimneyType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUMS_CHIMNEYTYPE_TYPE_STACK_OF_PLATES (Skorsten av plåt)",
"ENUMS_CHIMNEYTYPE_TYPE_BRICK_CHIMNEY_WITH_FLUE_LINER (Murad skorsten med insatsrör)",
"ENUMS_CHIMNEYTYPE_TYPE_BRICK_CHIMNEY (Murad skorsten)"
]
}chimneyLastUsedDate
{
"name": "chimneyLastUsedDate",
"type": "date"
}chimneyComment
{
"name": "chimneyComment",
"type": "text"
}waterType T
{
"name": "waterType",
"type": "text",
"maxLength": 200,
"enums": [
"ENUMS_WATERTYPE_TYPE_WATER_MISSING (Vatten saknas)",
"ENUMS_WATERTYPE_TYPE_MUNICIPAL_WATER (Kommunalt vatten)",
"ENUMS_WATERTYPE_TYPE_DUG_WELLS (Grävd brunn)",
"ENUMS_WATERTYPE_TYPE_INDIVIDUAL_WATER (Enskilt vatten)",
"ENUMS_WATERTYPE_TYPE_DEEP_DRILLED_WELL (Djupborrad brunn)"
]
}drainType T
{
"name": "drainType",
"type": "text",
"maxLength": 200,
"enums": [
"ENUMS_DRAINTYPE_TYPE_SANITATION (Kommunalt avlopp)",
"ENUMS_DRAINTYPE_TYPE_INDIVIDUAL_SEWAGE (Enskilt avlopp)",
"ENUMS_DRAINTYPE_TYPE_DRAIN_WITH_INFILTRATION (Avloppsbrunn med infiltration)",
"ENUMS_DRAINTYPE_TYPE_DRAIN_MISSING (Avlopp saknas)"
]
}hasRadon bit
{
"name": "hasRadon",
"type": "bit"
}radonComment
{
"name": "radonComment",
"type": "text"
}otherBuildings
{
"name": "otherBuildings",
"type": "text"
}isAllYear bit
{
"name": "isAllYear",
"type": "bit"
}createdDate
{
"name": "createdDate",
"type": "timestamp"
}costDescription
{
"name": "costDescription",
"type": "text"
}latitude
{
"name": "latitude",
"type": "text",
"maxLength": 22
}longitude
{
"name": "longitude",
"type": "text",
"maxLength": 22
}zoomLevel
{
"name": "zoomLevel",
"type": "smallint"
}directions
{
"name": "directions",
"type": "text"
}communications
{
"name": "communications",
"type": "text"
}locationComment
{
"name": "locationComment",
"type": "text"
}locationCommentMultiLang (Allowed languages: en, sv, es, de, da, fr, nl. Structure: {"en": "text", "sv": "text", "es": "texto" })
{
"name": "locationCommentMultiLang",
"type": "jsonObject",
"validationSchema": {
"id": "estates/locationCommentMultiLang",
"type": "object",
"additionalProperties": false,
"properties": {
"sv": {
"type": "string"
},
"en": {
"type": "string"
},
"es": {
"type": "string"
},
"de": {
"type": "string"
},
"da": {
"type": "string"
},
"fr": {
"type": "string"
},
"nl": {
"type": "string"
}
}
},
"note": "Allowed languages: en, sv, es, de, da, fr, nl. Structure: {\"en\": \"text\", \"sv\": \"text\", \"es\": \"texto\" }"
}description
{
"name": "description",
"type": "text"
}floorNr
{
"name": "floorNr",
"type": "text",
"maxLength": 40
}floorsInTotal
{
"name": "floorsInTotal",
"type": "int",
"maxLength": 3
}floorNrComment
{
"name": "floorNrComment",
"type": "text",
"maxLength": 200,
"isDeprecated": "true"
}tenantOwnershipLandComment T
{
"name": "tenantOwnershipLandComment",
"type": "text",
"enums": [
"ENUMS_ESTATE_TENANT_OWNER_SHIP_LAND_COMMENT_TYPE_PATIO_MARK (Uteplatsen/marken är upplåten med bostadsrätten (ingår i bostadsrätten))",
"ENUMS_ESTATE_TENANT_OWNER_SHIP_LAND_COMMENT_TYPE_PATIO_MARK_UNCLEAR (Det är oklart med vilken rätt uteplatsen/marken nyttjas)",
"ENUMS_ESTATE_TENANT_OWNER_SHIP_LAND_COMMENT_TYPE_GRANTED_WITH_OTHER_RIGHT_THAN_TENANT_OWNERSHIP (Upplåten med annan nyttjanderätt än bostadsrätt)"
]
}hasDoorCode bit
{
"name": "hasDoorCode",
"type": "bit"
}doorCode
{
"name": "doorCode",
"type": "text",
"maxLength": 16
}hasKey bit
{
"name": "hasKey",
"type": "bit"
}keyComment
{
"name": "keyComment",
"type": "text"
}keyInDate
{
"name": "keyInDate",
"type": "date"
}keyInPersonName
{
"name": "keyInPersonName",
"type": "text",
"maxLength": 60
}keyOutDate
{
"name": "keyOutDate",
"type": "date"
}keyOutPersonName
{
"name": "keyOutPersonName",
"type": "text",
"maxLength": 60
}hasBurglarAlarm bit
{
"name": "hasBurglarAlarm",
"type": "bit"
}burglarAlarmType
{
"name": "burglarAlarmType",
"type": "text",
"maxLength": 50
}burglarAlarmCode
{
"name": "burglarAlarmCode",
"type": "text",
"maxLength": 10
}burglarAlarmComment
{
"name": "burglarAlarmComment",
"type": "text",
"maxLength": 150
}showBurglarAlarmOnMarketingPlaces bit (Bit that says if burglar alarm should be showed on object description and website)
{
"name": "showBurglarAlarmOnMarketingPlaces",
"type": "bit",
"note": "Bit that says if burglar alarm should be showed on object description and website"
}hasLiftSetting E
{
"name": "hasLiftSetting",
"type": "enum",
"enums": [
"ENUM_HAS_LIFT_SETTING_NO (Nej)",
"ENUM_HAS_LIFT_SETTING_YES (Ja)"
]
}liftComment
{
"name": "liftComment",
"type": "text"
}feeChanges
{
"name": "feeChanges",
"type": "text"
}housingAssociationPlotOwnership E
{
"name": "housingAssociationPlotOwnership",
"type": "enum",
"enums": [
"ENUMS_HOUSING_ASSOCIATION_PLOT_OWNERSHIP_LEASEHOLD (Marken är tomträtt)",
"ENUMS_HOUSING_ASSOCIATION_PLOT_OWNERSHIP_OWNS (Föreningen äger marken)"
]
}storageDescription
{
"name": "storageDescription",
"type": "text"
}{
"name": "cashFlowAnalysisId",
"type": "foreignKey",
"table": "cashFlowAnalysis",
"unique": true
}cashFlowAnalysisIgnoreFields (Fields in this json will not be included in the sum: 'cashFlowAnalysisSumRevenue'. Structure: ['cashFlowAnalysisSumRevenue', 'cashFlowAnalysisSumVacancies'])
{
"name": "cashFlowAnalysisIgnoreFields",
"type": "jsonObject",
"note": "Fields in this json will not be included in the sum: 'cashFlowAnalysisSumRevenue'. Structure: ['cashFlowAnalysisSumRevenue', 'cashFlowAnalysisSumVacancies']"
}cashFlowAnalysisComment
{
"name": "cashFlowAnalysisComment",
"type": "text"
}cashFlowAnalysisYield
{
"name": "cashFlowAnalysisYield",
"type": "percentage"
}isCashFlowAnalysisCalculationSetManually bit (Toggles if the values are set manually or retrieved automatically)
{
"name": "isCashFlowAnalysisCalculationSetManually",
"type": "bit",
"note": "Toggles if the values are set manually or retrieved automatically"
}cashFlowAnalysisSumRevenue $$
{
"name": "cashFlowAnalysisSumRevenue",
"type": "money"
}cashFlowAnalysisSumOtherIncomes $$
{
"name": "cashFlowAnalysisSumOtherIncomes",
"type": "money"
}cashFlowAnalysisSumVacancies $$
{
"name": "cashFlowAnalysisSumVacancies",
"type": "money"
}cashFlowAnalysisCosts $$
{
"name": "cashFlowAnalysisCosts",
"type": "money"
}cashFlowAnalysisMaintenanceCost $$
{
"name": "cashFlowAnalysisMaintenanceCost",
"type": "money"
}cashFlowAnalysisPropertyTax $$
{
"name": "cashFlowAnalysisPropertyTax",
"type": "money"
}cashFlowAnalysisYearlyGroundRend $$
{
"name": "cashFlowAnalysisYearlyGroundRend",
"type": "money"
}cashFlowAnalysisGeneralizedOperationAndMaintenanceCost $$
{
"name": "cashFlowAnalysisGeneralizedOperationAndMaintenanceCost",
"type": "money"
}cashFlowAnalysisGeneralizedOperationCost $$
{
"name": "cashFlowAnalysisGeneralizedOperationCost",
"type": "money"
}cashFlowAnalysisGeneralizedMaintenanceCost $$
{
"name": "cashFlowAnalysisGeneralizedMaintenanceCost",
"type": "money"
}isCashFlowAnalysisMaintenanceCostPerAreaSetManually bit (Toggles if the value is set manually or calculated from areas)
{
"name": "isCashFlowAnalysisMaintenanceCostPerAreaSetManually",
"type": "bit",
"note": "Toggles if the value is set manually or calculated from areas"
}cashFlowAnalysisMaintenanceCostPerArea $$ (cost/m2)
{
"name": "cashFlowAnalysisMaintenanceCostPerArea",
"type": "money",
"note": "cost/m2"
}isCashFlowAnalysisCostPerAreaSetManually bit (Toggles if the value is set manually or calculated from areas)
{
"name": "isCashFlowAnalysisCostPerAreaSetManually",
"type": "bit",
"note": "Toggles if the value is set manually or calculated from areas"
}cashFlowAnalysisCostPerArea $$ (cost/m2)
{
"name": "cashFlowAnalysisCostPerArea",
"type": "money",
"note": "cost/m2"
}companyTransferValuesFromDate
{
"name": "companyTransferValuesFromDate",
"type": "date"
}companyTransferBookedEstateValue $$
{
"name": "companyTransferBookedEstateValue",
"type": "money"
}companyTransferBookedInventoryValue $$
{
"name": "companyTransferBookedInventoryValue",
"type": "money"
}companyTransferBookedSum $$
{
"name": "companyTransferBookedSum",
"type": "money"
}companyTransferTaxResidualEstateValue $$
{
"name": "companyTransferTaxResidualEstateValue",
"type": "money"
}companyTransferTaxResidualInventoryValue $$
{
"name": "companyTransferTaxResidualInventoryValue",
"type": "money"
}companyTransferTaxResidualSum $$
{
"name": "companyTransferTaxResidualSum",
"type": "money"
}plotDescription
{
"name": "plotDescription",
"type": "text"
}livingAreaDescription
{
"name": "livingAreaDescription",
"type": "text"
}farmingPurposeText (Used to write purposes that are not in farmingPurpose table)
{
"name": "farmingPurposeText",
"type": "text",
"maxLength": 100,
"note": "Used to write purposes that are not in farmingPurpose table"
}patioSummary
{
"name": "patioSummary",
"type": "text"
}parkingSummary
{
"name": "parkingSummary",
"type": "text"
}{
"name": "estateEconomicTypeCodeId",
"type": "foreignKey",
"table": "estateEconomicTypeCodes",
"schema": "mspx_admin"
}assessmentYear
{
"name": "assessmentYear",
"type": "year"
}assessValueYear
{
"name": "assessValueYear",
"type": "year"
}assessValueBuilding $$
{
"name": "assessValueBuilding",
"type": "money"
}assessValueLand $$
{
"name": "assessValueLand",
"type": "money"
}assessValueTotal $$
{
"name": "assessValueTotal",
"type": "money"
}assessValueDescription
{
"name": "assessValueDescription",
"type": "text"
}assessmentValueAccuracy E
{
"name": "assessmentValueAccuracy",
"type": "enum",
"enums": [
"ENUMS_ASSESSMENTVALUEACCURACY_TYPE_APPRECIATED (Uppskattat)",
"ENUMS_ASSESSMENTVALUEACCURACY_TYPE_CALCULATED (Beräknat)",
"ENUMS_ASSESSMENTVALUEACCURACY_TYPE_DETERMINED (Fastställt)",
"ENUMS_ASSESSMENTVALUEACCURACY_TYPE_NOT_DETERMINED (Ej fastställt)",
"ENUMS_ASSESSMENTVALUEACCURACY_TYPE_PRELIMINARY (Preliminärt)",
"ENUMS_ASSESSMENTVALUEACCURACY_TYPE_PROPOSED (Föreslaget)"
]
}yearlyGroundRent $$
{
"name": "yearlyGroundRent",
"type": "money"
}groundRentEndDate
{
"name": "groundRentEndDate",
"type": "date"
}groundRentPeriod
{
"name": "groundRentPeriod",
"type": "text",
"maxLength": 50
}groundRentLandlord
{
"name": "groundRentLandlord",
"type": "text",
"maxLength": 250
}monthlyRent $$
{
"name": "monthlyRent",
"type": "money"
}isHeatIncluded bit
{
"name": "isHeatIncluded",
"type": "bit"
}isWaterIncluded bit
{
"name": "isWaterIncluded",
"type": "bit"
}isElectricityIncluded bit
{
"name": "isElectricityIncluded",
"type": "bit"
}isCableTVIncluded bit
{
"name": "isCableTVIncluded",
"type": "bit"
}isInternetIncluded bit
{
"name": "isInternetIncluded",
"type": "bit"
}isCoolingIncluded bit
{
"name": "isCoolingIncluded",
"type": "bit"
}isGarageIncluded bit
{
"name": "isGarageIncluded",
"type": "bit"
}isCarportIncluded bit
{
"name": "isCarportIncluded",
"type": "bit"
}isParkingSpaceIncluded bit
{
"name": "isParkingSpaceIncluded",
"type": "bit"
}isCondominiumSupplementIncluded bit
{
"name": "isCondominiumSupplementIncluded",
"type": "bit"
}isHotWaterIncluded bit
{
"name": "isHotWaterIncluded",
"type": "bit"
}isColdWaterIncluded bit
{
"name": "isColdWaterIncluded",
"type": "bit"
}isIPTVIncluded bit
{
"name": "isIPTVIncluded",
"type": "bit"
}isIPTelephonyIncluded bit
{
"name": "isIPTelephonyIncluded",
"type": "bit"
}otherFeeIncludedComment
{
"name": "otherFeeIncludedComment",
"type": "text"
}livingCostAnalysisComment
{
"name": "livingCostAnalysisComment",
"type": "text"
}bboxObjectJSON (Expected structure: {minY : 1,minX: 2,maxY : 2,maxX : 3})
{
"name": "bboxObjectJSON",
"type": "jsonObject",
"note": "Expected structure: {minY : 1,minX: 2,maxY : 2,maxX : 3}"
}polygonListJSON (Expected structure: [ [{x:19.232323, y:56.3434343}, {x:15.33434, y:70.444}...], [{x:15.232323, y:50.3434343}, {x:16.33434, y:45.444}...]...]. A list that contains polygons which is a list with coordinates)
{
"name": "polygonListJSON",
"type": "jsonObject",
"note": "Expected structure: [ [{x:19.232323, y:56.3434343}, {x:15.33434, y:70.444}...], [{x:15.232323, y:50.3434343}, {x:16.33434, y:45.444}...]...]. A list that contains polygons which is a list with coordinates"
}monthlyRentSummary
{
"name": "monthlyRentSummary",
"type": "text"
}transferFee
{
"name": "transferFee",
"type": "text",
"maxLength": 120
}pledgingFee
{
"name": "pledgingFee",
"type": "text",
"maxLength": 120
}condominiumSupplement $$
{
"name": "condominiumSupplement",
"type": "money"
}repairFundSetting E
{
"name": "repairFundSetting",
"type": "enum",
"enums": [
"ENUM_ESTATE_REPAIR_FUND_SETTING_EXISTS (Inre reparationsfond finns)",
"ENUM_ESTATE_REPAIR_FUND_SETTING_MISSING (Inre reparationsfond saknas)",
"ENUM_ESTATE_REPAIR_FUND_SETTING_NOT_CHECKED (Inre reparationsfond inte kontrollerad)"
]
}repairFund $$
{
"name": "repairFund",
"type": "money"
}repairFundDescription
{
"name": "repairFundDescription",
"type": "text"
}repairFundCheckDate
{
"name": "repairFundCheckDate",
"type": "date"
}transferFeePaidBy E
{
"name": "transferFeePaidBy",
"type": "enum",
"enums": [
"ENUMS_HOUSING_ASSOCIATION_TRANSFER_FEE_PAID_BY_BUYER (Köpare)",
"ENUMS_HOUSING_ASSOCIATION_TRANSFER_FEE_PAID_BY_NO_FEE (Ingen avgift)",
"ENUMS_HOUSING_ASSOCIATION_TRANSFER_FEE_PAID_BY_SELLER (Säljare)"
]
}shareInCondo T
{
"name": "shareInCondo",
"type": "text",
"maxLength": 100,
"enums": [
"ENUM_ESTATE_SHARE_IN_CONDO_NOT_POSSIBLE_TO_OBTAIN (Uppgiften har ej gått att få fram)",
"ENUM_ESTATE_SHARE_IN_CONDO_MISSING_IN_HA_REGISTER (Uppgiften saknas i föreningens register)"
]
}shareInCondoContribution T
{
"name": "shareInCondoContribution",
"type": "text",
"maxLength": 100,
"enums": [
"ENUM_ESTATE_SHARE_IN_CONDO_NOT_POSSIBLE_TO_OBTAIN (Uppgiften har ej gått att få fram)",
"ENUM_ESTATE_SHARE_IN_CONDO_MISSING_IN_HA_REGISTER (Uppgiften saknas i föreningens register)"
]
}shareInCondoFee T
{
"name": "shareInCondoFee",
"type": "text",
"maxLength": 100,
"enums": [
"ENUM_ESTATE_SHARE_IN_CONDO_NOT_POSSIBLE_TO_OBTAIN (Uppgiften har ej gått att få fram)",
"ENUM_ESTATE_SHARE_IN_CONDO_MISSING_IN_HA_REGISTER (Uppgiften saknas i föreningens register)"
]
}shareInCondoComment
{
"name": "shareInCondoComment",
"type": "text"
}isSharedOwnership bit
{
"name": "isSharedOwnership",
"type": "bit"
}sharedOwnershipDescription
{
"name": "sharedOwnershipDescription",
"type": "text"
}sharedOwnershipName
{
"name": "sharedOwnershipName",
"type": "text",
"maxLength": 30
}sharedOwnershipFee $$
{
"name": "sharedOwnershipFee",
"type": "money"
}sharedOwnershipFeePeriod E
{
"name": "sharedOwnershipFeePeriod",
"type": "enum",
"enums": [
"ENUMS_ESTATE_SHARED_OWNERSHIP_FEE_PERIOD_MONTH (SEK/MÅNAD)",
"ENUMS_ESTATE_SHARED_OWNERSHIP_FEE_PERIOD_YEAR (SEK/ÅR)",
"ENUMS_ESTATE_SHARED_OWNERSHIP_FEE_PERIOD_QUARTER (SEK/KVARTAL)"
]
}pawnedSetting T
{
"name": "pawnedSetting",
"type": "text",
"maxLength": 200,
"enums": [
"ENUM_ESTATE_PAWNED_SETTING_IS_PAWNED (är pantsatt)",
"ENUM_ESTATE_PAWNED_SETTING_IS_NOT_PAWNED (är inte pantsatt)",
"ENUM_ESTATE_PAWNED_SETTING_IS_NOT_CHECKED (är inte kontrollerad)"
]
}pawnedAmountCheckDate
{
"name": "pawnedAmountCheckDate",
"type": "date"
}heatingCost $$
{
"name": "heatingCost",
"type": "money"
}chimneySweepingCost $$
{
"name": "chimneySweepingCost",
"type": "money"
}communityFee $$
{
"name": "communityFee",
"type": "money"
}insuranceFee $$ (For tenant ownership homeinsurance fee will be stored here, for other object types it will be a sum of all needed insurances)
{
"name": "insuranceFee",
"type": "money",
"note": "For tenant ownership homeinsurance fee will be stored here, for other object types it will be a sum of all needed insurances"
}insuranceDescription
{
"name": "insuranceDescription",
"type": "text"
}maintenanceCost $$
{
"name": "maintenanceCost",
"type": "money"
}waterAndDrainFee $$
{
"name": "waterAndDrainFee",
"type": "money"
}roadFee $$
{
"name": "roadFee",
"type": "money"
}sanitationFee $$
{
"name": "sanitationFee",
"type": "money"
}householdElectricityCost $$
{
"name": "householdElectricityCost",
"type": "money"
}electricityCost $$ (Can be used instead of dividing into householdElectricityCost and heatingCost)
{
"name": "electricityCost",
"type": "money",
"note": "Can be used instead of dividing into householdElectricityCost and heatingCost"
}operationalComment
{
"name": "operationalComment",
"type": "text"
}securityCost $$
{
"name": "securityCost",
"type": "money"
}operatingCostSum $$
{
"name": "operatingCostSum",
"type": "money"
}isOperatingCostSumSetManually bit
{
"name": "isOperatingCostSumSetManually",
"type": "bit"
}energyClass E
{
"name": "energyClass",
"type": "enum",
"enums": [
"ENUMS_ENERGYCLASS_TYPE_A (A)",
"ENUMS_ENERGYCLASS_TYPE_B (B)",
"ENUMS_ENERGYCLASS_TYPE_C (C)",
"ENUMS_ENERGYCLASS_TYPE_D (D)",
"ENUMS_ENERGYCLASS_TYPE_E (E)",
"ENUMS_ENERGYCLASS_TYPE_F (F)",
"ENUMS_ENERGYCLASS_TYPE_G (G)"
]
}energyPerformance (kWh/m2)
{
"name": "energyPerformance",
"type": "int",
"note": "kWh/m2"
}energyPrimaryPerformance (kWh/m2, introduced in 2018. sv: primärenergital)
{
"name": "energyPrimaryPerformance",
"type": "int",
"note": "kWh/m2, introduced in 2018. sv: primärenergital"
}energyDescription
{
"name": "energyDescription",
"type": "text"
}energyStatus E
{
"name": "energyStatus",
"type": "enum",
"enums": [
"ENUMS_EnergyStatus_TYPE_ENERGY_AUDITS_ARE_COMMISSIONED (Energideklaration är beställd)",
"ENUMS_EnergyStatus_TYPE_ENERGY_AUDITS_NOT_PERFORMED (Energideklaration ej utförd)",
"ENUMS_EnergyStatus_TYPE_ENERGY_USE_IN_PROGRESS (Energideklaration pågår)",
"ENUMS_EnergyStatus_TYPE_ENERGY_USE_IS_MADE (Energideklaration är utförd)",
"ENUMS_EnergyStatus_TYPE_ENERGY_USE_IS_NOT_NEEDED (Energideklaration behövs ej)"
]
}energyStatusDate
{
"name": "energyStatusDate",
"type": "date"
}energyStatusEntrepreneur
{
"name": "energyStatusEntrepreneur",
"type": "text",
"maxLength": 100
}energyStatusSummary
{
"name": "energyStatusSummary",
"type": "text"
}energyConsumption (kWh)
{
"name": "energyConsumption",
"type": "int",
"note": "kWh"
}personsInHousehold
{
"name": "personsInHousehold",
"type": "int"
}buildingComment
{
"name": "buildingComment",
"type": "text"
}otherAreasComment
{
"name": "otherAreasComment",
"type": "text"
}landComment
{
"name": "landComment",
"type": "text"
}buildingRightsLandDescription
{
"name": "buildingRightsLandDescription",
"type": "text"
}mortgageComment
{
"name": "mortgageComment",
"type": "text"
}hasNoMortgages bit (If set it should override any mortages connected to the estate. Should print a text that no mortgages is present on the estate.)
{
"name": "hasNoMortgages",
"type": "bit",
"note": "If set it should override any mortages connected to the estate. Should print a text that no mortgages is present on the estate."
}loanComment
{
"name": "loanComment",
"type": "text"
}areaComment
{
"name": "areaComment",
"type": "text"
}areaType T
{
"name": "areaType",
"type": "text",
"maxLength": 100,
"enums": [
"ENUM_ESTATE_AREA_TYPE_TAXABLEAREA (Taxerad areal)",
"ENUM_ESTATE_AREA_TYPE_FORESTRYPLAN (Skogsbruksplan)",
"ENUM_ESTATE_AREA_TYPE_SAMAPPLICATION (SAM-ansökan)",
"ENUM_ESTATE_AREA_TYPE_PLANONPROPERTY (Uppmätning på fastighetskarta)",
"ENUM_ESTATE_AREA_TYPE_AREAUNDERREGISTER (Areal enligt fastighetsbok)",
"ENUM_ESTATE_AREA_TYPE_SELLERS_DATA (Säljarens uppgifter)"
]
}easementsAndDetailsComment
{
"name": "easementsAndDetailsComment",
"type": "text"
}faultsAndDefectsComment
{
"name": "faultsAndDefectsComment",
"type": "text"
}residentialArea
{
"name": "residentialArea",
"type": "text",
"maxLength": 150
}propertyTax $$
{
"name": "propertyTax",
"type": "money"
}propertyTaxPaidByTenants $$ (Used in commercial)
{
"name": "propertyTaxPaidByTenants",
"type": "money",
"note": "Used in commercial"
}netPropertyTax $$ (Used in commercial)
{
"name": "netPropertyTax",
"type": "money",
"note": "Used in commercial"
}premiseComment
{
"name": "premiseComment",
"type": "text"
}buildingType
{
"name": "buildingType",
"type": "text",
"maxLength": 100
}buildYear
{
"name": "buildYear",
"type": "text",
"maxLength": 20
}tenantsIncomeComment T
{
"name": "tenantsIncomeComment",
"type": "text",
"maxLength": 150,
"enums": [
"ENUM_ESTATE_TENANTS_INCOME_COMMENT_FROM_RENTAL_LISTINGS (Hyreslistor)",
"ENUM_ESTATE_TENANTS_INCOME_COMMENT_FROM_APPROXIMATING (Schablonberäkning)",
"ENUM_ESTATE_TENANTS_INCOME_COMMENT_FROM_SELLER (Säljaren)"
]
}generalInformation
{
"name": "generalInformation",
"type": "text"
}electricityConsumption (kWh)
{
"name": "electricityConsumption",
"type": "int",
"note": "kWh"
}grantingFee $$ (Only used in tenant ownership)
{
"name": "grantingFee",
"type": "money",
"note": "Only used in tenant ownership"
}contributionFee $$ (Only used in tenant ownership)
{
"name": "contributionFee",
"type": "money",
"note": "Only used in tenant ownership"
}keyIdentifier (The identifier on the physical house key)
{
"name": "keyIdentifier",
"type": "text",
"maxLength": 20,
"note": "The identifier on the physical house key"
}valueIndication (We store data from valuation services, for now we only use valueguard.)
{
"name": "valueIndication",
"type": "jsonObject",
"note": "We store data from valuation services, for now we only use valueguard."
}updatedDate
{
"name": "updatedDate",
"type": "updated"
}