Skip to main content

Data Dictionary for Business Views

Download a PDF version of the Design Studio guide.

Data Point (Column Name)

Business Description

Business View Included In

Account Code

Account Code assigned the specific account description during ledger configuration.

BVAccountBalance

BVAccountActivity

AccountDescription

Account Description based on LeaseAccelerator definitions.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Activity Functional Currency

Account activity by selected reporting period in the schedules’ assigned functional currency. These activities are remeasured into the functional currency. [See Functional Currency]. Refer to “LA User Guide - FX Reporting” for information regarding remeasurement.

BVAccountActivity

Activity Reporting Currency

Account activity by selected reporting period in the selected ledger’s assigned reporting currency. These activities are translated into the reporting currency. [See Reporting Currency]. Refer to “LA User Guide - FX Reporting” for information regarding translation.

BVAccountActivity

Activity Transaction Currency

Account activity by selected reporting period in the schedules’ transactional currency. [See Transactional Currency]

BVAccountActivity

Adjusting Entry

Fiscal year and/or fiscal month identifier (FM/FY) for which the entry is adjusting; Same as the FM/FY identifier in the Comments field.

BVLedgerExport

Advance/Arrears

Repayment mode for the schedule.

BVLedgerExport

Balance Functional Currency

Account balance by selected reporting period in the schedules’ assigned functional currency. These balances are remeasured into the functional currency. [See Functional Currency]. Refer to “LA User Guide - FX Reporting” for information regarding remeasurement.

BVAccountBalance

Balance Reporting Currency

Account balance by selected reporting period in the selected ledger’s assigned reporting currency. These balances are translated into the reporting currency. [See Reporting Currency]. Refer to “LA User Guide - FX Reporting” for information regarding translation.

BVAccountBalance

Balance Transaction Currency

Account balance by selected reporting period in the schedules’ transactional currency. [See Transactional Currency]

BVAccountBalance

Booking Ledger Date

Date when the schedule was booked into the selected ledger.

BVAccountBalance

BVAccountActivity

Business Unit

Client -defined operational group within the client organization.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Comments

Combination of the word “Schedule” along with the schedule number and adjusting entry fiscal month/fiscal year identifier (if applicable) associated with the ledger entry.

BVLedgerExport

Cost Center

Cost center associated with the reported balances based on client-defined cost center values.

BVAccountBalance

BVAccountActivity

Country

Client-assigned country name that governs the accounting and tax rules for a leasing transaction.

BVLedgerExport

CR

Credit entry valued in transactional currency; Should not be used with Posting Amount. Should be used only with Round Value parameter set to No.

BVLedgerExport

Deal ID

System-generated unique number associated with a specific schedule within a specific customer environment.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Deal Status (Long)

Word or phrase explaining the status of a schedule at a specific AtAt date taking into consideration pending end-of-term activities; Examples include Renewal in Process, Return in Process, and Buyout in process.

BVLedgerExport

Deal Status (Short)

One-word description explaining the status of a schedule at a specific AsAt date; Examples include Active, Evergreen, Disposed, etc. This is listed as Deal Status (Short) in the BVLedgerExport and simply Deal Status in the BVAccountBalance and BVAccountActivity.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Deal Tag

Client-assigned labels used to isolate specific schedules for reporting purposes.

BVLedgerExport

BVAccountBalance

BVAccountActivity

DR

Debit entry valued in transactional currency; Should not be used with Posting Amount. Should be used only with Round Amount parameter set to No.

BVLedgerExport

DRCR

Renders either “DR” or “CR” depending on whether the specific leg of the journal entry is a debit or credit; Provides DR or CR notation in a single column preferred by some ERP’s. Must be used with Posting Amount. Should be used only with Round Value parameter set to either Yes or Modified.

BVLedgerExport

Effective End Date

Current date which the schedule is anticipated to end when taking renewals and/or early terminations/buyouts into consideration. Schedules in Evergreen status will reflect the most recent month of generated evergreen payments as the Effective End Date.

BVAccountBalance

BVAccountActivity

Entity

Client-defined primary business entity.

BVLedgerExport

BVAccountBalance

BVAccountActivity

ExternalDocumentID

Document ID’s related to integration results.

BVLedgerExport

Functional Currency

Currency in which a business entity records its accounting records; A lease can only be assigned one functional currency.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Funder

Client-defined company providing financing for a lease; May refer to a Landlord on real estate leases. (Also referred to as Lessor.)

BVLedgerExport

BVAccountActivity

FX Conversion Date

Date associated with the Functional Conversion Rate used to convert transactional currency to functional currency.

BVLedgerExport

FX Rate Type

Type of rate used to convert transactional currency to functional currency; Options include Spot Rate or WeightedEndDate where the latter is based on the customer configuration option for P&L accounts.

BVLedgerExport

GL Coding Convention

Name of the GL Coding Convention in which the specific schedule has been assigned based on the selected ledger and its configuration. Schedules comprised of multiple assets assigned to various GL Coding Conventions will appear as ‘Multiple’.

BVAccountBalance

BVAccountActivity

JEShortDesc

LeaseAccelerator nomenclature providing a brief explanation of the basis of the journal entry.

BVLedgerExport

Lease Classification

Lease classification as of the system date of report generation.

BVAccountBalance

BVAccountActivity

Lease Genre

System assigned classification of either ‘Equipment’ or ‘Real Estate’ based on the selected Product Category.

BVAccountBalance

BVAccountActivity

Lease Start Date

Commencement date or takedown date. The date when the duration of the lease starts and therefore the payment schedule begins.

BVAccountBalance

BVAccountActivity

Lease Type

Type of contractual lease.

BVLedgerExport

Ledger Date

Date of record for the associated journal entry.

BVLedgerExport

Ledger ID

System assigned ledger number.

BVAccountBalance

BVAccountActivity

Ledger List

List of all ledgers to which the schedule has been booked.

BVAccountBalance

BVAccountActivity

LedgerEntryId

LeaseAccelerator nomenclature related to the specific journal entry leg. While this data point will remain active,

Important: THIS WILL BE PHASED OUT AS A MEANS OF RECONCILATION.

Please refer to additional documentation regarding new reconciliation methods. 

BVLedgerExport

LedgerEntryLineID

LeaseAccelerator nomenclature that allows clients to reconcile or suppress individual lines in the Journal Entry Report.

Important: THIS CAN REPLACE LedgerEntrySubID AS A MEANS OF RECONCILATION.

BVLedgerExport

LedgerEntrySubId

LeaseAccelerator nomenclature related to the specific journal entry leg at a more granular level than basic Posting Code. While this data point will remain active,

Important: THIS WILL BE PHASED OUT AS A MEANS OF RECONCILATION.

Please refer to additional documentation regarding new reconciliation methods. 

BVLedgerExport

Lessee

Client-defined company acting as the legal party agreeing to the leasing contract. (Real estate leases may refer to this as the Tenant.)

BVLedgerExport

BVAccountBalance

BVAccountActivity

Month End Date

Fiscal month-end date for which the account balances are reported. Balances on this month-end date should equate to the balances derived from a Journal Entries Report (aka Ledger Export) with the specific month-end date as the AsAt date.

BVAccountBalance

BVAccountActivity

Net

Net of the Debit (DR) and Credit (CR) entries for the specific entry valued in transactional currency. Must be used only with the separate DR and CR data elements. Should be used only with Round Amount parameter set to No.

BVLedgerExport

Original End Date

Date in which the schedule contractually would have ended not including renewals, early terminations/buyouts and/or evergreen activities.

BVAccountBalance

BVAccountActivity

Payment Frequency

Periodic nature of payments – monthly, quarterly, bi-monthly, annual, bi-annual, etc.

BVAccountActivity

PO Number

Internal Reference number that matches the client’s ERP Procurement Purchase Order Number to the Supplier’s.

BVAccountActivity

Posted Fiscal Month

Fiscal month in which the ledger date occurs.

BVLedgerExport

Posted Fiscal Year

Fiscal year in which the ledger date occurs.

BVLedgerExport

Posting Amount

Journal entry amount in transactional currency whether debit or credit. Appears as a positive number. Must be used with DRCR. Should be used only with Round Amount parameter set to either Yes or Modified.

BVLedgerExport

Posting Code

LeaseAccelerator nomenclature related to the specific journal entry leg.

BVLedgerExport

Posting ID

LeaseAccelerator nomenclature that groups accounting entries based on Deal Id, Ledger Date, Amount Type, and Currency. While this data point will remain active,

Important: THIS WILL BE PHASED OUT AS A MEANS OF RECONCILATION.

Please refer to additional documentation regarding new reconciliation methods. 

BVLedgerExport

PostingEntryID

LeaseAccelerator nomenclature that groups accounting entries based on Deal Id, Ledger Date, Amount Type, Currency, and Adjustment Date.

Important: THIS CAN REPLACE POSTING ID AS A MEANS OF RECONCILATION.

BVLedgerExport

Product Category

Asset type(s) included on the schedule; If more than one, “Multiple” will be used.

BVLedgerExport

BVAccountBalance

BVAccountActivity

RCHP (in Months)

Number of months that the assets contained in the lease are expected to be used. This may be shorter than the contractual term if assets are typically bought out early or may be longer than the contractual term if renewal periods are typically exercised or evergreen is typically incurred.

BVAccountBalance

BVAccountActivity

RCHP End Date

The Reasonably Certain Holding Period (in Months) expressed as a date from the lease start date. Note: This may not match the RCHP End Date in the Quantitative Analysis Report (QAR) for schedules with early terminations or modifications. The QAR overrides the original RCHP End Date to match the Effective End Date to properly account for the Remaining Term which is used in the weighted average calculations.

BVAccountBalance

BVAccountActivity

Reporting Currency

Currency in which a parent company reports its financial statements; Can also refer to Local currency for foreign entities; A lease may have multiple reporting currencies if it is booked into different ledgers configured with different reporting currencies.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Reporting Period

Assigned reporting period based on the configured fiscal calendar in conjunction with the parameter selection for the Account Activity Trend reports. These values are used to create the Summary page. Output includes:

  • ‘Month’ = Fiscal month name associated with the entry.

  • ‘Quarter’ = “Q#20YY” is displayed based on which fiscal quarter the entry is associated.

  • ‘Annual’ = “20YY” is displayed based on which fiscal year the entry is associated.

BVAccountActivity

Schedule Number

Client provided identifier for a specific lease. Some BV’s may shorten the name to Schedule.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Segment1 thru Segment11

Client-defined segment based on ledger configuration.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Status

Status of the journal entry relating to integration only. This is not related to the status of the schedule.

BVLedgerExport

Transactional Currency

Currency in which a lease is denominated; A lease can only have one transactional currency.

BVLedgerExport

BVAccountBalance

BVAccountActivity

Exhibit B 

BVLedgerExport - Entry Types 

Accretion 

Additions 

Adjustment 

Amortization 

Closing

Balance 

Impairment 

LT/ST 

Opening

Balance 

Other 

Payment 

Purchase 

Reallocation 

Receipt 

Takedown Adjustment 

Variable Expense 

Writeoff 

BVLedgerExport - Affected Components 

Accrued Interest Balance 

ARO 

ARO Balance 

Asset Purchase 

Base Lease 

CAMS 

Deferred Rent/SPTA Balance 

FX 

Guaranteed Residual Value 

IDC 

IDC Balance 

IFRS Transition Alternate Valuation 

Impairment 

Interim Rent 

Late Fees 

Lease Incentive 

Net Balance 

Net Writeoff 

Nonremeasuring Payment Adjustment 

Other Related Expense 

Prepayment 

Property Insurance 

Purchase Option Liability 

Real Estate Tax 

Reduction in Scope 

Refund of Deposit 

Reinstated ARO Amortization 

Reinstated Depreciation 

Reinstated Impairment 

Return/Early Termination Fee 

Security Deposit 

Special Deposit 

Unamortized Portion of Lease Incentive 

Unpaid Lease Incentive 

Variable Expense 

Translation Adjustment 

BVLedgerExport - Triggering Events 

A/P Reconciliation 

Buyout 

Closing Balance 

Functional Currency Remeasurement 

Impairment 

Incurred 

Modification 

Modification (Correcting) 

Monthly Activity 

Opening Balance 

Original Contract Term 

Original Contract Term (Correcting) 

Reallocation 

Reallocation (Correcting) 

Remeasurement Due to Implicit Changes in Estimates 

Remeasurement Due to Implicit Changes in Estimates (Correcting) 

Remeasurement Due to Payment Adjustment 

Remeasurement Due to Payment Adjustment (Correcting) 

Renewal 

Renewal (Correcting) 

Reporting Currency Remeasurement 

Reporting Currency Translation 

Return 

Return (Correcting) 

Rounding Adjustment 

Rounding Adjustment (Correcting) 

Transition 

Transition (Correcting) 

Unknown (Correcting) 

Unknown (Historical) 

Evergreen

Remeasurement to Accommodate Externally-Applied Balance Adjustment

Other

Scheduled

BVLedgerExport - JE Types 

Balance 

Catch-up entry for backdated activity 

Correcting entry for closed journal entries 

Entry improperly backdated from subsequent period 

FX Remeasurement 

Month 13 

Normal 

Normal (Historical) 

Rounding 

RPT FX Translation 

Was this article helpful?

We're sorry to hear that.