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:
|
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 |