Operational Payment Report
This template is supported by the BVOperationalPayment Business View. It is a 2-page report that includes contractual payments in transactional and reporting currency along with other pertinent payment types (EX: CAMS, Asset Purchase, etc.). Data items associated with a lease’s operational payments are also included as well as a parameters page. The contractual payments includes non-remeasuring payment adjustments in transactional currency which mirror the payment schedule appearing in Deal Summary for a particular schedule. Please refer to the Data Dictionary for more information regarding the individual data elements included in the business view.
The template does not include an AsAt date. Values are based on the system date of report generation.
It is located under the Design Studio tile in the Reporting workspace.
Below is an example of the parameters included in the Operational Payment Report.
Report Parameter Definitions – Operational Payment Report
Parameter |
Definition |
|---|---|
Starting Fiscal Period |
First fiscal month-end date of which the report will provide account activity values. REQUIRED FIELD. |
Ending Fiscal Period |
Final fiscal month-end date of which the report will provide account activity values. REQUIRED FIELD |
Ledger |
Filter of client configured ledgers via a drop-down menu. Only one ledger can be selected at a time. Not a required field. Note: If no ledger is selected, the report employs the same logic used to display the Deal Summary payment schedule. |
Show Evergreen Payments |
Yes/No option with No as the default. No: Evergreen payments will not be included in the report output. Yes: Evergreen payments (to the extent they have been created in the system) will be included in the report output. REQUIRED FIELD |
Schedule |
Available filtering on a single or multiple specific schedule(s). The wildcard character (*) can be used to isolate a specific group of schedules. |
Entity |
Available filter of client-defined Entities via drop-down menu. Only one Entity can be selected at a time. |
Business Unit |
Available filter of client-defined Business Units via drop-down menu. Only one Business Unit can be selected at a time. |
Changes Made From |
Month-Day-Year fields. Calendar widget appears after Month field populated. Available filter to isolate schedules with deal or asset level changes recorded with system dates during the selected date range. |
Results contain two separate pages: Operational Payment and Parameters. You can switch between the pages by using the Go To option in the menu bar.
The Operational Payment page presents contractual payments by schedule, by fiscal month based on the number of months included in the parameters.
Last Payment and Next Payment information are based on the system date of report generation and do not adjust for each month listed on the report.
As the Ledger parameter is not required on this report (unlike the accounting-based reports), subsequent parameters are not dynamic meaning they do not adjust options based on the selected ledger.