In this article

Import Lease

The following tables provide information on the file formats for importing data entities. All data entities in Property Lease Management start with PLM.

Tip: To save time and work more efficiently, use the sample import files (PLM_ImportTemplates-YYYYMMDD.zip) that are provided with Property Lease Management installation download file. If a sample file does not exist, you can export the data entities.

When importing data entities from a Microsoft Excel file, set Skip staging to No. When data is imported with the staging, all Property Lease Management validations are performed on the data being imported. If any errors occur during import, you can review the staging data to check for data import issues.

Lease

Target entity: BssiPrmLeaseEntity

This imported data adds or updates data for the Lease Header FastTab on the Lease Details page.

This data entity is for importing the lease header data only.

Column Name Data Type Required Description
LEASENUMBER String Required Must be unique and follow the convention set up on the Number Sequences tab of the Property Lease Management Parameters page.
ALIGNTOMONTH Enum   Yes/No
CATEGORYNAME String Required  
CONSOLIDATE Enum   Yes/No
CURRENCY String Required  
CUSTACCOUNT String Required  
EXECUTIONDATE Date    
LEASECOMMDATE Date Required  
LEASENAME String    
LEASESTATUS Enum  

Active, On Hold, or Prospect

Status of Terminated is not allowed.
LEASETYPE Enum   Revenue or Expense
PERIODBYPERIODLEASE Enum   Yes/No
PRORATEPARTIALPERIODS Enum   Yes/No
RENTCOMMDATE Date Required  
VENDACCOUNT String    
MIGRATED Enum  

Indicates if the lease is migrated or not.

Yes/No
OLDLEASENUMBER String   Displays the old lease number if a lease is migrated.

Lease Term

Target entity: BssiPrmLeaseTermEntity

This imported data adds or updates data for the Lease Term FastTab on the Lease Details page.

Column Name Data Type Required Description
BSSIPRMLEASENUMBER String Required  
LINENUM Real Required  
BSSIPRMLEADTIME Integer    
BSSIPRMNOTICEREQUIREMENTS String    
BSSIPRMTERMENDDATE Date Required  
BSSIPRMTERMSTARTDATE Date Required If importing multiple lines of term for a lease, the start date of a subsequent term cannot start before the end date of a preceding term (i.e., cannot import terms that have overlapping dates for the same lease).
BSSIPRMTERMTYPE String    

Property Level 1 (Lease)

Target entity: PrmAllPropertiesLevel1

This imported data adds or updates data for the Levels 1, 2, 3 FastTab on the Lease Details page.

Column Name Data Type Required Description
BSSIPRMLEASENUMBER String Required  
BSSIPRMCATEGORYNAME String    
BSSIPRMLEVEL1NUMBER String    

Property Level 2 (Lease)

Target entity: PrmAllPropertiesLevel2

This imported data adds or updates data for the Levels 1, 2, 3 FastTab on the Lease Details page.

Column Name Data Type Required Description
BSSIPRMLEASENUMBER String Required  
BSSIPRMCATEGORYNAME String    
BSSIPRMLEVEL1NUMBER String    
BSSIPRMLEVEL2NUMBER String    

Property Level Lowest Level (Lease)

Target entity: PrmAllPropertiesLevel3

This imported data adds or updates data for the Levels 1, 2, 3 FastTab on the Lease Details page.

Column Name Data Type Required Description
LEASENUMBER String Required  
LEVEL1NUMBER String    
LEVEL2NUMBER String    
LEVEL3NUMBER String    
ENDDATE Date    
LEASEDAREA Real    
STARTDATE Date    

Charge (Lease)

Target entity: BssiPrmLeaseChargeEntity

This imported data adds or updates data for the Charges FastTab on the Lease Details page.

Migrated Charges

Review the following information when you are using this data entity to migrate leases with charges.

  • When you are following the standard import process you will need to enter some extra amounts which are already calculated in on-going lease charge in the old system.
  • When you are importing the charges, the charges are saved under the lease which is imported using the PLM lease data entity. The amortization schedule is created based on the amounts that you enter in the excel file.
  • For charges which are ongoing, you do not need to create an initial journal entry after you import a charge.
  • Imported charges are set as after the date of the last invoice period and amortization begins with the next period.
  • After the migration is complete, you are able to work with the imported charges as you work with any other charges, creating invoices and processing modifications, for example.

Meter charge

For a charge type of Consumption, the meter number is required.

Lease component

When LEASECOMPONENT = Yes, the lease component accounts can be imported for financial or operating expense leases and for charges where the period-by-period feature is not used (i.e., Period by period is No). Lease component accounts cannot be imported for short-term expense leases.

When a lease component account is imported, note the following: 

  • The numbers before the first dash represent the main account followed by financial dimensions (e.g., 110120-002-025).
  • The financial dimension values imported for the specific lease component account have precedence over the financial dimension values imported from the DIMENSIONDISPLAYVALUE.
  • If a lease component account is blank, the default values are from the CHARGEACCOUNT and DIMENSIONDISPLAYVALUE fields.

Financial dimension

In standard Microsoft Dynamics 365 for Finance and Operations, the selection and order of financial dimensions for dimension formats used by data entities is set up on the Ledger dimension integration of the Financial dimension configuration for integrating applications (Modules > General ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications).

When importing lease component accounts with financial dimensions, only the financial dimensions that have been set up can be imported and in the same order in which they are set up.

For example, the financial dimensions are set up in the following order: 

  • Business Unit
  • Cost Center
  • Department

A lease component uses the Business Unit of 001 and Department of 025. The lease component import value is in the format 110120-001--025, where the account format is as follows: MainAccount-BusinessUnit-CostCenter-Department. Since the lease component account does not use the Cost Center, a blank is left between the two dashes.

This information is important for importing the financial dimensions for the charge account and lease component accounts. Check the financial dimension configuration to ensure that you specify the information in the correct order.

Column Name Data Type Required Description
LEASENUMBER String Required  
LEVEL1NUMBER String   Levels 1, 2, 3 are required based on the category selected for the lease.
LEVEL2NUMBER String   Levels 1, 2, 3 are required based on the category selected for the lease.
LEVEL3NUMBER String   Levels 1, 2, 3 are required based on the category selected for the lease.
CHARGENUMBER String Required  
AMORTIZATIONEXPENSEACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
AMOUNT Real Required  
CHARGEACCOUNT String Required Imports the main account for the charge.
CHARGENAME String Required  
CHARGETYPE Enum Required Regular or Consumption
DIMENSIONDISPLAYVALUE String  

Lease charge financial dimension

When this value is empty, the financial dimensions are from the lowest level, customer/vendor, or charge.

DIRECTCOSTGLACCOUNTDISPLAYVALUE String  

Lease component accounts can be imported when LEASECOMPONENT = Yes.

The full account value can be used.

ECONOMICLIFE Real    
FREQUENCY Enum Required  
GAINONLEASEACCOUNTDISPLAYVALUE String    
INTERESTEXPENSEACCOUNTDISPLAYVALUE String    
ITEMNUMBER String    
LEASECOMPONENT Enum   Yes/No
LEASEEXPENSEACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
LEASELIABILITYACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
LEASEPAYABLECLEARINGACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
LOCATION String    
LOSSONLEASEACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
METERNUMBER String   Required when CHARGETYPE = Consumption
PERIODBYPERIODLEASE Enum   Yes/No
PURCHASINGOPTIONS Real    
QUANTITY Integer    
RESIDUALAMOUNT Real    
ACCUMULATIVEAMORTIZATIONACCOUNT String    
ROUASSETACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
ROUASSETADJUSTMENT Real    
ROUASSETADJUSTMENTACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
SEPARATEINVOICE Enum   Yes/No
SITE String    
TAXITEMGROUP String    
TENANTINCENTIVEGLACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.
UNIT String    
VARIABLERENTEXPENSEACCOUNTDISPLAYVALUE String   Lease component accounts can be imported when LEASECOMPONENT = Yes.

WAREHOUSE

 String    
SALESTAXGROUP String   When this value is empty, the default is from the customer or vendor record.
Billing Start Date   Required The start date of the lease charge.
Balance of Unguaranteed Residual Value (for Sales and Direct Finance type leases)     The present unguaranteed RV balance of the last invoiced period. If you enter a value here then you must also enter a value for the Unguaranteed RV on the lease header level.
Balance of Lease Receivable (for Sales and Direct Finance type leases)  

For sales and direct finance type leases, it is required.

 The lease receivable balance of the last invoiced period.
Balance of Deferred Profit   For direct finance type leases which use the ASC 842 accounting standard, it is required. The deferred profit balance of the last invoiced period.
Implicit Rate (for Sales and Direct Finance type leases)   For sales and direct finance type leases, it is required.  
Implicit Rate CV   For direct finance type leases which use the ASC 842 accounting standard, it is required.  
Balance Unearned Finance Income – Unguaranteed RV   For sales and direct finance type leases which use the IFRS 16 accounting standard, it is required. The unearned finance income - unguaranteed RV of the last invoiced period.
Balance Unearned Finance Income - LR   For sales and direct finance type leases which use the IFRS 16 accounting standard, it is required. The unearned finance income - unguaranteed LR of the last invoiced period.
Balance of Deferred Rent Receivable (for Operating type lease)     The deferred rent receivable of the last invoiced period. You can enter zero as the value.
Straight Line Income   Required if Calculate straight line income is turned on. Straight line income is the same as it is calculated in the old lease.
Balance of Unamortized Direct Cost (for Operating type lease)     The unamortized direct cost of the last invoiced period. You can enter zero as the value.
Termination Fee      
Termination Fee Payable Date (the date must be after the Go Live Date)      
Net Investment Balance (IFRS 16 only)   Required The net investment balance of the last invoiced period, for IFRS 16 charges only. If you are using the ASC 842 lease accounting standard, then the net investment balance is calculated.

Insurance

Target entity: BSSIPrmInsurance

This imported data adds or updates data for the Insurance page.

Column Name Data Type Required Description
POLICYNUMBER String    
LEASENUMBER String Required  
ENDDATE Date    
POLICYAMOUNT Real    
POLICYCOST Real    
PROVIDER String    
STARTDATE Date    

Sales Reporting Line

Target entity: BSSIPrmSalesReportingLine

This imported data adds or updates data for the Sales Reporting page.

Column Name Data Type Required Description
SALESREPORTNUMBER String    
LEASENUMBER String Required  
YEAR      
PERIOD      
FROMDATE Date    
TODATE Date    
LASTDATEREPORT Date    
REPORTINGDATE Date    
AMOUNT Real    

Escalation

Target entity: BSSIPrmEscalation

This imported data adds or updates data for the Billing Lines section of the Billing Lines page. To update an existing escalation line, the start and end dates much match the existing line. If the start and end dates for a line do not match an existing escalation line, a new escalation line is created. Updates to existing lines affect only billing lines that have not yet been processed (i.e., invoice not yet created).

Column Name Data Type Required Description
LEASENUMBER String Required Lease ID number.
LEVEL1NUMBER String   Level 1 of the lease property.
LEVEL2NUMBER String   Level 2 of the lease property.
LEVEL3NUMBER String   Level 3 of the lease property.
CHARGENUMBER String   Charge ID number.
STARTDATE Date   Start date of the escalation.
ENDDATE Date   End date of the escalation.
AMOUNT Real   Amount of the escalation. One of the amount or percent is required.
CPISCHEDULEID String    
ESCALATIONDATE Date    
ESCALATIONFREQUENCY Enum    
ESCALATIONTYPE String    
PERCENT Real   Percent of the escalation. One of the amount or percent is required.
RATESCHEDULEID String    

Abatement

Target entity: BSSIPrmAbatement

This imported data adds data for the Billing Lines section of the Billing Lines page.

Column Name Data Type Required Description
LEASENUMBER String Required Lease ID number.
LEVEL1NUMBER String   Level 1 of the lease property.
LEVEL2NUMBER String   Level 2 of the lease property.
LEVEL3NUMBER String   Level 3 of the lease property.
CATEGORYNAME String   Property category name.
CHARGENUMBER String   Charge ID number.
STARTDATE Date   Start date of the abatement.
OPTION Enum   The type of abatement: Lump Sum or Recurring
ENDDATE Date  

End date of the abatement.

Required for a recurring abatement.

ABATEMENTAMOUNT Real   Amount of the abatement.
ACCOUNT String  

Main account for the abatement.

When empty, the default used is from the lease charge.