Bulk import leases

Columns

Required: the first eight. Blank ibr is taken from the IBR table. frequency: monthly, quarterly, annual. timing: advance or arrears. exemption: none, short_term, low_value. Dates are YYYY-MM-DD.

entity, reference, description, asset_class, lessor, commencement_date, term_months, payment_amount, frequency, timing, escalation_pct, escalation_every_years, cpi_indexed, rent_free_months, ibr, initial_direct_costs, incentives_received, prepaid_payments, restoration_cost, exemption, useful_life_months, ownership_transfers, extension_months, extension_reasonably_certain