Import leases

Skenarios support

Import leases

Leases are subject to property units and it is highly recommended that leases are imported in a separate sheet, where they are tied to a unit by the corresponding ID. Certain headers are mandatory in order to import a lease, but additional details can also be imported by optional headers.

SkenarioLabs Analytics assumes there is maximum one active lease per a unit. If a unit ID and an activation date are imported via Excel so that a lease with corresponding values is already in the database, the existing lease is updated.

Mandatory headers

Column title 

Description

Allowed values

Column title 

Description

Allowed values

Entity ID

Specifies the property class in a portfolio

String

Entity Type

Type of entity

PROPERTY_UNIT, PROPERTY_BUILDING, PROPERTY_GROUP

Rent

Monthly rent

Number

Activation date

Starting date of the lease

Date*
Format: 2019-12-24

Lease contract name

Name of the contract

Text, string

* Attempting to import date values if alignment is left it will cause fail. Edit date formatting such that alignment is on the right side.

Optional headers

Column title 

Description

Allowed values

Column title 

Description

Allowed values

Notice period duration

Lease notice period in days

Integer

Tenant

Free description of a tenant

String

Lease type**

Continuous or fixed term lease contract

Until further notice, Fixed length

Expiration date

Expiration date of a fixed term lease

Date

First possible termination date

First possible expiration date of a continuous lease contract

Date

Portfolio id

The id of the portfolio where the building should be imported.

If the portfolio id is set Organization key header became mandatory otherwise row will be skipped.

The portfolio id should exist within the organization used as organization key and user should be a part of the organization too otherwise row will be skipped.

Integer

Organization key

The key of the organization where the building should be imported.

If the Organization key is set Portfolio id header became mandatory otherwise row will be skipped.

The Organization key should exist as parent/child organization and user should be a part of the organization too otherwise row will be skipped.

Text

**Lease type is assumed to be continuous if lease type is not given.



SkenarioLabs