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.

Charge (Lease)

Target entity: BssiPrmLeaseChargeEntity

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

Column Name	Data Type	Required	Description
ACCUMAMORTACCOUNTDISPLAYVALUE	String	No
AMORTIZATIONEXPENSEACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes.
AMOUNT	Real	Required	Amount for charge line.
ASSETCLEARINGACCOUNTDISPLAYVALUE	String	Required (Sales/DF)	Account used in journal distributions when terminating charges.
ASSETCOST	Real	Required (Sales/DF)	Value for a cost of an asset.
ASSETFAIRVALUE	Real	Required (Sales/DF)	Fair value for a lease charge.
ASSETRECLASSCLEARINGACCOUNTDISPLAYVALUE	String	Required (Sales/DF)	Account used when creating charge termination journal distributions.
CHARGEACCOUNT	String	Required	Imports the main account for the charge.
CHARGENAME	String	Required	Name of the lease charge.
CHARGENUMBER	String	Required	Number of the lease charge.
CHARGETYPE	Enum	Required	Regular or Consumption.
CLASSIFICATION	Enum	Required (for Component items)	Select one of the lease classifications: Sales, DF, Operating, or Exempt.
COSTOFSALEACCOUNTDISPLAYVALUE	String	Required (Sales/DF)	Cost of sale account used when creating journals for Sales and DF type charges.
DEFERREDLEASERECEIVABLEACCOUNT
DEFERREDLEASERECEIVABLEACCOUNTDISPLAYVALUE	String	Required (for deferred operating charges)	Account used by journal entries created for Operating charges.
DEFERREDPROFITACCOUNTDISPLAYVALUE	String	Required (for Direct Finance charges)	Account used when creating journals for direct finance charges.
DIMENSIONDISPLAYVALUE	String	No	Lease charge financial dimension. When this value is empty, the financial dimensions are from the lowest level, customer/vendor, or charge.
DIRECTCOST	Real	No	Direct cost value of a lease charge.
DIRECTCOSTCLEARINGACCOUNTDISPLAYVALUE	String	Required	Account is used in journal creation and clearing.
DIRECTCOSTEXPENSEACCOUNTDISPLAYVALUE	String	Required	Account is used in invoice distributions for lease component charges.
DIRECTCOSTGLACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes. The full account value can be used.
EARLYTERMINATION	Enum	No	Enable early termination for lease component charge.
ECONOMICLIFE	Real	No	Economic life for lease charge.
FREQUENCY	Enum	Required	Billing line frequency for lease charge.
GAINONLEASEACCOUNTDISPLAYVALUE	String	No	Account used for modification JEs.
GUARANTEEDRV	Real	No	Guaranteed RV for lease component charge.
IMPAIRMENTLOSSGLACCOUNTDISPLAYVALUE	String	Required (Only for DF and Sales type termination)	Account is used in JE distributions to capture loss during termination process.
IMPLICITINTERESTRATE	Real	Required (DF & Sales)	Implicit rate value used by Sales and DF lease component charges.
INTERESTEXPENSEACCOUNTDISPLAYVALUE	String	Required	Account is used in Expense Lease component charge invoice distributions.
INTERESTINCOMEACCOUNTDISPLAYVALUE	String	Required (DF & Sales)	Account is used in invoice distributions for Sales and DF lease component charges.
INTERESTINCOMELEASERECEIVABLEACCOUNTDISPLAYVALUE	String	(Required IFRS16 DF & sales)	Account is used in invoice distributions for IFRS 16 Sales and DF lease component charges.
INTERESTINCOMEUNGUARANTEEDRESIDUALVALUEACCOUNTDISPLAYVALUE	String	(Required IFRS16 DF & sales)	Account is used in invoice distributions for IFRS 16 Sales and DF lease component charges.
ITEMNUMBER	String	Required	Item number for a lease charge
LEASECOMPONENT	Enum	No	Yes/No
LEASEEXPENSEACCOUNTDISPLAYVALUE	String	Required (Expense Operating)	Account is used in Expense Lease component charge invoice distributions.
LEASELIABILITYACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes.
LEASENUMBER	String	Required	Lease number identifier for the lease charge.
LEASEPAYABLECLEARINGACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes.
LEASERECIEVABLEACCOUNTDISPLAYVALUE	String	Required	Account is used in invoice distributions for Sales and DF lease component charges.
LEVEL1NUMBER	String	No	Levels 1, 2, 3 are required based on the category selected for the lease.
LEVEL2NUMBER	String	No	Levels 1, 2, 3 are required based on the category selected for the lease.
LEVEL3NUMBER	String	No	Levels 1, 2, 3 are required based on the category selected for the lease.
LOCATION	String	No	Location code for the lease charge.
LOSSONLEASEACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes.
LOSSONTERMINATIONACCOUNTDISPLAYVALUE	String	Required (Operating termination)	Account is used in termination journal entry for operating leases.
MARKETRATE	Real	No	Market Rate for DF and Sales type component charges.
METERNUMBER	String	No	Required when CHARGETYPE = Consumption.
PERIODBYPERIODLEASE	Enum	No	Yes/No.
PURCHASINGOPTIONS	Real	No	Amount field for Expense IFRS/ASC charges.
QUANTITY	Integer	No	Quantity of the lease charge.
RESIDUALAMOUNT	Real	No	Calculated value for lease component charges.
RESIDUALVALUE	Real	No	Calculated field for Revenue DF and Sales type components.
REVENUEACCOUNTDISPLAYVALUE	String	Required	Account is used in invoice distributions for Sales and DF lease component charges.
ROUASSETACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes.
ROUASSETADJUSTMENT	Real	No	Asset adjustment amount for expense lease component charges.
ROUASSETADJUSTMENTACCOUNT	String	Required	Account is used in initial JE distributions for expense lease component charges.
ROUASSETADJUSTMENTACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes.
ROUNDINGOFFACCOUNTDISPLAYVALUE	String	No	Account that handles rounding difference at modification.
SEPARATEINVOICE	Enum	No	Yes/No.
SITE	String	No	Site dimension for a charge.
STLINECALC	Enum	No	Enable straight line calculation for revenue Operating lease component charges.
TAXGROUP	String	No	Charge tax group information.
TAXITEMGROUP	String	No	Item sales tax group info for the charge.
TENANTINCENTIVEGLACCOUNTDISPLAYVALUE	String	No	Account is used in journal entries for lease charges that use incentives.
TERMINATIONFEE	Real	No	Termination fee for a lease component charge.
TERMINATIONFEEPAYABLEDATE	Date	No	Termination fee payables date.
UNAMORTIZEDDIRECTCOSTACCOUNTDISPLAYVALUE	String	Required (Operating)	Account used for revenue operating charge journal entries.
UNEARNEDINCOMELEASERECEIVABLEACCOUNTDISPLAYVALUE	String	Required (IFRS - DF/Sales)	Account is used in invoice and journal distributions for Sales and DF lease component charges
UNEARNEDINCOMEUNGUARANTEEDRESIDUALVALUEACCOUNTDISPLAYVALUE	String	Required (IFRS - DF/Sales)	Account is used in invoice and journal distributions for Sales and DF lease component charges.
UNGUARANTEDRESIDUALVALUEACCOUNTDISPLAYVALUE	String	Required (DF and Sales)	Account is used in initial JE distributions for revenue lease component charges.
UNGUARANTEDRV	Real	No	Unguaranteed revenue for lease component charge.
UNIT	String	No	Unit for charge.
VARIABLEINCOME	Enum	No	Enable/disable variable income.
VARIABLEINCOMEACCOUNTDISPLAYVALUE	String	No	Account used for variable income amounts in journal distributions.
VARIABLERENTEXPENSEACCOUNT	String	No	Account used by expense lease component charges.
VARIABLERENTEXPENSEACCOUNTDISPLAYVALUE	String	No	Lease component accounts can be imported when LEASECOMPONENT = Yes.
WAREHOUSE	String	No	Warehouse for the lease charge.

PLM - Sales Reporting Lines

Target entity: BssiPrmSBRSalesReportingLinesEntity

Using this data entity users can create sales reporting line records.

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.
SALESREPORTINGNUMBER	String	Required	Sales reporting number.
LINENUMBER	Real	Required	Line number.
AMOUNT	Real	No	Amount for reporting lines
FROMDATE	Date	No	From date
LASTDATETOREPORT	Date	No	Last date to report.
NAME	String	No	Name.
PERIOD	Integer	No	Period number.
REPORTINGDATE	Date	No	Reporting date.
SALESREPORTINGSTATUS	Enum	No	Reporting status for sales reporting line.
TODATE	Date	No	To date.
YEAR	Integer	No	Year value.

 

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
ACCUMAMORTACCOUNTDISPLAYVALUE	String
ACCUMULATIVEAMORTIZATIONACCOUNT	String
AMORTIZATIONEXPENSEACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
AMORTIZATONEXPENSE	Real
AMOUNT	Real	Required
APPLYFEES	Enum
ASSETCLEARINGACCOUNTDISPLAYVALUE	String
ASSETCOST	Real
ASSETFAIRVALUE	Real
ASSETRECLASSCLEARINGACCOUNTDISPLAYVALUE	String
ASSETREVALUE	Real
BALANCENETINVESTMENT	Real
BALANCEOFDEFERREDPROFIT	Real
BALANCEOFDEFERREDRENTRECEIVABLE	Real
BALANCEOFLEASERECEIVABLE	Real
BALANCEOFUNAMORTIZEDDIRECTCOST	Real
BALANCEOFUNGUARANTEDRV	Real
BALANCEUNEARNEDINCOMELEASERECEIVABLE	Real
BALANCEUNEARNEDINCOMEUNGUARANTEEDRESIDUALVALUE	Real
CAMCHARGEABLEAREA	Real
CATEGORYNAME	String
CHARGEACCOUNT	String	Required	Imports the main account for the charge.
CHARGENAME	String	Required
CHARGESTATUS	Enum
CHARGETYPE	Enum	Required	Regular or Consumption
CLASSIFICATION	Enum
COSTOFSALEACCOUNTDISPLAYVALUE	String
COSTOFSALEAMORTIZATION	Real
CUSTPOSTINGPROFILE	String
DEFERREDLEASERECEIVABLEACCOUNTDISPLAYVALUE	String
DEFERREDPROFITACCOUNTDISPLAYVALUE	String
DIMENSIONDISPLAYVALUE	String		Lease charge financial dimension When this value is empty, the financial dimensions are from the lowest level, customer/vendor, or charge.
DIRECTCOST	Real
DIRECTCOSTATMODIFICATION	Real
DIRECTCOSTCLEARINGACCOUNTDISPLAYVALUE	String
DIRECTCOSTEXPENSEACCOUNTDISPLAYVALUE	String
DIRECTCOSTEXPENSEDEFERRED	Int64
DIRECTCOSTEXPENSEOPERATING	Real
DIRECTCOSTGLACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes. The full account value can be used.
EARLYTERMINATION	Enum
ECONOMICLIFE	Real
EIGHTFORTYTWOSTARTDATE	Date
FAIRVALUEAMT	Real
FREQUENCY	Enum	Required
GAINLOSSONMODIFICATION	Real
GAINONLEASEACCOUNTDISPLAYVALUE	String
GROSSPROFITLOSS	Real
GUARANTEEDRV	Real
IFRSSUBSTANTIALNONSUBSTANTIAL	Enum
IMPAIRMENTLOSSAMOUNT	Real
IMPAIRMENTLOSSGLACCOUNTDISPLAYVALUE	String
IMPLICITCVRATE	Real
IMPLICITINTERESTRATE	Real
INCLUDETAXONFEECALCULATION	Enum
INITDIRECTCOST	Real
INTERESTEXPENSEACCOUNTDISPLAYVALUE	String
INTERESTINCOMEACCOUNTDISPLAYVALUE	String
INTERESTINCOMEDEFERRED	Int64
INTERESTINCOMELEASERECEIVABLE	Real
INTERESTINCOMELEASERECEIVABLEACCOUNTDISPLAYVALUE	String
INTERESTINCOMEUNGUARANTEEDRESIDUALVALUE	Real
INTERESTINCOMEUNGUARANTEEDRESIDUALVALUEACCOUNTDISPLAYVALUE	String
INVENTDIMID	String
ISCAMRECOVERABLECHARGE	Enum
ITEMNUMBER	String
LEASECOMPONENT	Enum		Yes/No
LEASEEXPENSE	Real
LEASEEXPENSEACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
LEASEINCENTIVES	Real
LEASELIABILITYACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
LEASEPAYABLECLEARINGACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
LEASEPAYMENTS	Real
LEASERECIEVABLEACCOUNTDISPLAYVALUE	String
LOCATION	String
LOSSONLEASEACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
LOSSONTERMINATIONACCOUNTDISPLAYVALUE	String
LOSSONTERMINATIONAMOUNT	Real
MARKETRATE	Real
METERNUMBER	String		Required when CHARGETYPE = Consumption
MIGRATED
NEEDSREMEASUREMENT
NETPRESENTVALUE
PAYMADVANCEARREAR		Required
PERIODBYPERIODLEASE	Enum		Yes/No
PURCHASINGOPTIONS	Real
PURCHASINGOPTIONSBEFORETERMINATE	Real
QUANTITY	Integer
REPORTSTARTDATE	Date
RESIDUALAMOUNT	Real
RESIDUALBEFORETERMINATE	Real
RESIDUALVALUE	Real
REVENUEACCOUNTDISPLAYVALUE	String
REVENUEAMORTIZATION	Real
ROUASSETACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
ROUASSETADJUSTMENT	Real
ROUASSETADJUSTMENTACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
ROUASSETBALANCE	Real
ROULEASELIABILITYBALANCE	Real
ROUNDINGOFFACCOUNTDISPLAYVALUE	String
SALESLINEAMOUNT	Real
SALESTAXGROUP	String		When this value is empty, the default is from the customer or vendor record.
SEPARATEINVOICE	Enum		Yes/No
SITE	String
STARTDATE	Date
STLINECALC	Enum
STLINEINCOME	Real
TAXGROUP	String
TAXITEMGROUP	String
TENANTINCENTIVEGLACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
TERMINATIONDATE	Date
TERMINATIONFEE	Real
TERMINATIONFEEPAYABLEDATE	Date
TERMINATIONTYPE	Enum
UNAMORTIZEDDIRECTCOSTACCOUNTDISPLAYVALUE	String
UNEARNEDINCOMELEASERECEIVABLEACCOUNTDISPLAYVALUE	String
UNEARNEDINCOMEUNGUARANTEEDRESIDUALVALUEACCOUNTDISPLAYVALUE	String
UNGUARANTEDRESIDUALVALUEACCOUNTDISPLAYVALUE	String
UNGUARANTEDRV	Real
UNIT	String
USECUSTOMERPOSTINGPROFILE	Enum
VARIABLEINCOME	Enum
VARIABLEINCOMEACCOUNTDISPLAYVALUE	String
VARIABLERENTEXPENSEACCOUNTDISPLAYVALUE	String		Lease component accounts can be imported when LEASECOMPONENT = Yes.
WAREHOUSE	String
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.