Project External Financing

Annual Financial Plan

Overview

This entity contains the list of “Annual financial plan” for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Annual Financial Plan

Annual Financial Plan Screen Fields

Fields	Descriptions
Code	Unique ID that identifies a Annual financial plan. Consecutive unique number automatically generated by the system.
Workflow Status	This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.
Fiscal Year	Fiscal Year of the Annual financial plan. Default current Fiscal Year where ‘Current Fiscal Year Budget Execution’ is True.
Institution	System will automatically display the Institution Code, based on the attribute "Institution Name" from Institution entity
Project ID	Unique identifier that identifies a Project with external financing.
Type	Allows to select type from dropdown list.
Plan Date	Default current system date.
Project Amount Dc	Calculated field, Display only. Shows Total Domestic Amount for the Annual financial plan
Counter Part Project Amount Dc	Calculated field, Display only. Shows Total Domestic Counterpart Amount for the whole Plan
Total Project Amount Dc	Calculated field, Display only. Total Domestic Project Amount” = “Domestic Project Amount” + “Domestic Counterpart Project Amount”
Created By	User who created the Project Plan. Populated automatically by the system.
Created Date	Date and time of creation the Plan Project with External Financing. Default current system date and time.
Approved By	User who approved the Plan Project with External Financing. Populated automatically by the system, when the document is approved.
Approved Date	Date and time in which the Plan Project with External Financing document turns to ‘Approved’ Status. Default current system date and time.

Annual Financial Plan Details

Overview

This entity contains the list of Annual financial plan Details for Projects with external financing.

Annual Financial Plan Details Tab Screen Fields

Fields	Descriptions
Sequence Number	Unique ID that identifies the Annual financial plan detail. It’s a consecutive number automatically generated by the system.
Fiscal Period	Fiscal Period of the voucher, manually update by the user
Project Current Account	Project Current account belongs to the Project external Financing in the header
Agreement Amount	Assigned Agreement Amount of Project Plan. Manually entered by the user
Domestic Amount	Assigned Domestic Amount of Project Plan.

Disbursement Request Application Voucher

Overview

This is used to record the Disbursement Request regarding expenditure done by a Spending Agency for submission to Donor for release of funds.

Navigation

Expenditures ► Project External Financing ► Disbursement Request Voucher-BTMS

Disbursement Request Application Voucher Screen and Tabs

Fields	Descriptions
Code	A unique identification code generated by the system.
Workflow Status	The workflow status of the Disbursement request application voucher. By default, its value is Created. It changes as per the approval stage.
Fiscal Year	The default value is the current Fiscal year. It allows the user to select the fiscal year for the Disbursement request application voucher, it should be open for the financial transactions.
Expending Agency	Expanding agency id, it holds the details of the spending agency. User can enter manually or select it using the lookup button.
Project External Financing	A unique identifier that identifies a Project with external financing.
Debt Instrument	Instrument the EVs area related to.
Voucher Date	The system automatically fetches the system current date.
Tranche	The tranche of the related instrument. User has to enter the details.
Currency	The default value is the country's domestic currency. The user can change it.
Total Domestic Amount	The total expense voucher details amount Domestic.
Total Foreign Amount	The total expense voucher details amount foreign.
Email Comments	Additional comments to be sent via email to the Donor.
Created By	The system automatically fetches the user details who has created the Disbursement Request Application Voucher.
Created Date	The system fetches the current system date.
Approved By	The user ID of the approver, it is automatically fetched by the system when the voucher gets approved.
Approved Date	The current system date when the voucher gets approved.
Disbursement Request Application Details Tab	Details of Expense Vouchers related to the Disbursement Request Voucher.
Attachments	This allows the user to attach the document for the Disbursement Request Application Voucher.

Attachment

Overview

This tab allows the user to attach the document for the Disbursement Request Application Voucher.

Attachment Screen and Tabs

Fields	Descriptions
ID	The unique identification code for the attachment.
Attachment Classification	The user selects the document type from the drop-down list.
Title	Title for the attachment.
Description	Description of the attachment.
Attachment	This feature allows the user to attach the file from the system.
Date Time	It fetches the system current date and time.
Date	The user can enter the date using the calendar feature.
User	System fetches the user details.

Disbursement Request Application Details

Overview

It records the expense voucher details which is related to a disbursement request expenditure done by spending agency. User selects the expense voucher which is linked to DR voucher.

Disbursment Request Application Details Screen and Tab

Field	Description
Expense Voucher	The expense voucher code user needs to enter. The user can select it using the lookup feature.

Disbursement Request Voucher

Overview

This entity contains the list of Disbursement Request Voucher, these are the documents containing the registration and control of the management of project with external financing. And linkage to budgetary expenses and accounting documents.

Navigation

Expenditures ► Project External Financing ► Disbursement Request Voucher

Disbursement Request Voucher Screen Fields

Fields	Descriptions
Id	Unique ID that identifies a Disbursement Request Voucher.
Workflow Status	This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.
Fiscal Year	Fiscal Year of the Disbursement Request Voucher.
Fiscal Period	Fiscal Period of the voucher, Default current period
Institution	Unique identifier. Manually entered by the user. Or automatically assigned by the system according to parameter ‘Automatic Institution Unit ID’.
Project External Financing	Unique identifier that identifies a Project with external financing.
Agreement Project	Unique identifier that identifies an Agreement of project.
Disbursement Type	Unique identifier of Disbursement Type for Project with External Financing associated with Disbursement Request Voucher. Only one Disbursement Type can be linked.
Disbursement Request Voucher Date	Default current system date and time. Populated automatically by the system at creation time of the record.
Language	Country specific language
Disbursement Request Voucher Name	Voucher description, describes the Disbursement Request.
Date	By default, is Null, but can be manually entered by the user
Reference Number	Reference Number. Manually entered by the user.
Disbursement Request Date	Date and time Request of disbursement. Manually entered by the user
Item Code Financial Organism	System will automatically display the Elements to definition in the attribute “Item code financial organism” the entity Agreement Project
Is First Disbursement	Manually entered by the user. Value default False
Is Forwarded	Indicates the forwarded. Manually entered by the user. if True, was forwarded to higher level.
Is Submitted	Indicates the submitted. Manually entered by the user If True, was submitted to higher level.
Is Received ORG	Indicates the received by ORG. Manually entered by the user. If True, was received by ORG to higher level.
Received Date ORG	Date and time of received by ORG to higher level. Automatically populated by the system in time of received by ORG, but the user can modified.
Submitted Date	Date and time of Submitted. Automatically populated by the system in time of submit, but the user can modified
Requested Date	Date and time of Requested.
Real Account	Real Monetary Account of Project with External Financing associated with Disbursement Request Voucher.
Scriptural Account	Scriptural Monetary Account of Project with External Financing associated with Disbursement Request Voucher.
Currency
Exchange Rate	Exchange rate, of the Agreement Currency
Total Amount Requested(Domestic)	Displays the “Total Domestic Amount Requested” of all Disbursement Expense Details “attribute Domestic Requested mount”.
Total Amount Requested(Foreign)	Displays the “Total Foreign Amount Requested” of all Disbursement Expense Details “attribute Foreign Requested Amount”.
Total Amount Submitted(Domestic)	Displays the “Total Domestic Amount Submitted” of all Disbursement Expense Details “attribute Domestic Submitted mount”
Total Amount Submitted(Foreign)	Field Calculated/Updated, Display Only” displays the “Total Foreign Amount Submitted” of all Disbursement Expense Details“ attribute Foreign Submitted Amount”
Total Amount Disbursed(Domestic)	Field Calculated/Updated, Display Only” displays the “Total Domestic Amount Disbursed” of all Disbursement Expense Details “attribute Domestic Disbursed Amount”
Total Amount Disbursed(Foreign)	“Field Calculated/Updated, Display Only” displays the “Total Foreign Amount Disbursed” of all Disbursement Expense Details “attribute Foreign Disbursed Amount”
Beneficiary	Beneficiary Name associated with Disbursement Request Voucher.
Financial Institution Intermediary Name	Intermediary Financial Institution Name associated with Disbursement Request Voucher.
Financial Institution Depository Name	Depositary Financial Institution Name associated with Disbursement Request Voucher.
Created By	User who created the Disbursement Request Voucher. Populated automatically by the system.
Creation Date	Date and time of creation the Disbursement Request Voucher. Default current system date and time.
Approved By	User who approved the Disbursement Request Voucher. Populated automatically by the system, when the document is approved.
Approved Date	Date and time in which the Disbursement Request Voucher document turns to ‘Approved’ Status. Default current system date and time.

Disbursement Expense Details

Overview

This entity contains the list of Disbursement Expense Details that must be disbursed.

Disbursement Expense Details Tab Screen Fields

Fields	Descriptions
Expense Voucher	Expense Voucher Number corresponding to Expense Voucher.
Submitted Amount Dc	Submitted Amount corresponding to Disbursement Requested Voucher when Currency is Domestic.
Submitted Amount Fc	Submitted Amount corresponding to Disbursement Requested Voucher when Currency is not Domestic.
Disbursed Amount Dc	Disbursed Amount corresponding to Disbursement Requested Voucher when Currency is Domestic.
Disbursed Amount Fc	Disbursed Amount corresponding to Disbursement Requested Voucher when Currency is not Domestic.

Multiyear Financial Plan

Overview

This entity contains the list of “Multiyear financial plan” for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Multiyear Financial Plan

Multiyear Financial Plan Screen Fields

Fields	Descriptions
Id	Unique ID that identifies a Multiyear financial plan.
Fiscal Year	Fiscal Year Default current FY
Workflow Status	This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.
Institution	Name of Institution. System will automatically display the Institution Code, based on the attribute "Institution Name" from Institution entity.
Project ID	Unique identifier that identifies a Project with external financing. Only one Project External Financing can be linked.
Plan Date	Default current system date and time. Populated automatically by the system at creation time of the record.
Type	Allows to select type from dropdown list
Domestic Project Amount	Calculated field, Display. Only Shows Total Domestic Amount for the Multiyear financial plan,
Domestic Counterpart Project Amount	Shows Total Domestic Counterpart Amount for the whole Plan,
Total Domestic Project Amount	Calculated field, Display only
Created By	User who created the Project with External Financing.
Created Date	Date and time of creation the Plan Project with External Financing.
Approved By	User who approved the Plan Project with External Financing. Populated automatically by the system, when the document is approved.
Approved Date	Date and time in which the Plan Project with External Financing document turns to ‘Approved’ Status

Multiyear Financial Plan Details

Overview

This entity contains the list of Multiyear financial plan Details for Projects with external financing.

Multiyear Financial Plan Details Tab Screen Fields

Fields	Descriptions
Sequence Number	Unique ID that identifies the Multiyear financial plan detail.
Fiscal Year	Fiscal Year of the Multiyear financial plan details. Default current Fiscal Year where ‘Current Fiscal Year Budget Execution’ is True. User can modify the year
Project Current Account	Allows to select project current account from search functionality
Agreement Currency	Agreement currency of Line Plan.
Agreement Amount	Assigned Agreement Amount of Project Plan.
Domestic Amount	Domestic currency of Line Plan.

Nicaragua Reports

Reconciliation Of Bank Resource Report

Overview

The purpose is to list information related to agreement and disbursement request.

Navigation

Expenditures ► Project External Financing ► Nicaragua Reports ► Reconciliation Of Bank Resource Report

Reconciliation Of Bank Resource Report Screen Fields

Fields	Descriptions
Fiscal Year	Current Fiscal Year
Disbursement Request Voucher	Select the disbursement request voucher from search functionality.
Comment	Any comment defined by the user in the generation screen of the report

Status Of Project Execution

Overview

Control report to determine the execution status of each investment project at the level of expenditure categories, in national currency and currency of origin, by each funding agency and by national counterpart funds. Summarized by each source of financing, by each funding agency, indicating the data of the current budget, cumulative execution by categories of investment and available balances.

Navigation

Expenditures ► Project External Financing ► Nicaragua Reports ► Status Of Project Execution

Status Of Project Execution Screen Fields

Fields	Descriptions
Fiscal Year	Current Fiscal Year
Project Structure	If the user does not define any filters in the text, 'None' will appear. There is a drop-down list for selecting multiple filters (Component, Sub-Component, Development Action).
Currency	Display only the currencies defined for Nicaragua. (Ex: The filter should have the values: Cordoba, Dollars, Euros).
Print Amount	Allow the report to be filtered by Cordobas / thousands / millions. Based on the criteria selected by the user in this parameter, apply these criteria to display the amounts in the columns of the report.
Monetary Account	Must be selected by the user, otherwise display all accounts.
Entity OCE/OEP	It must be selected by the user, otherwise it presents all the entities.
Financial Organism	Display the name of all the Financial Organisms. Must be selected by the user, otherwise display all data
Source	Display the name of all the Sources. Must be required by the user, otherwise show all sources
Specific Source	Display the name of all the Specific Sources. Must be required by the user, otherwise show all sources
Number Of Agreement	Must be required by the user, otherwise show all agreements
Project	Must be required by the user, otherwise show all projects.
Comment	Any comment defined by the user in the generation screen of the report

Project current account

Overview

This entity contains the Current Account for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Project Current Account

Project current account Screen Fields

Fields	Descriptions
Id	Unique identifier that identifies a Project current account.
Institution	Id of the Institution code
Project ID	Unique identifier that identifies an ID of project.
Agreement ID	Unique identifier that identifies an Agreement of project.
Project Structure Code	Unique identifier that identifies a project structure code.
Expense Category Code	Unique identifier that identifies a Expense category code.
Counterpart	Default value false
Initial Assigned Amount	Default value zero
Reallocations Amount	Default value zero
Executed Amount Obligation	Default value zero
Executed Amount EV	Default value zero
Available Amount	Automatically calculated by the system
Initial Assigned Amount Agreement	Default value zero Read-only
Reallocations Amount Agreement	Default value zero Read-only
Executed Amount Obligation Agreement	Default value zero Read-only
Executed Amount EV Agreement	Default value zero Read-only
Available Amount Agreement	Automatically calculated by the system

Reallocation Voucher

Overview

This entity contains the list of Reallocation for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Reallocation Voucher

Reallocation Voucher Screen Fields

Fields	Descriptions
Code	Unique ID that identifies a Reallocation Voucher. Consecutive unique number automatically generated by the system.
Workflow Status	This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.
Voucher Type	Allows to select voucher type from dropdown list
Fiscal Year	Fiscal Year of the Disbursement Request Voucher.
Fiscal Period	Fiscal Period of the voucher, Default current period
Institution	Name of Institution. System will automatically display the Project Structure Code, based on the attribute "Institution Name" from Institution entity
Project External Financing	Unique identifier that identifies a Project with external financing. Only one Project External Financing can be linked.
Voucher Date	Default current system date and time. Populated automatically by the system at creation time of the record.
Document Type	Unique code that identifies the document type
Supporting Document Number	No. document that supports the transaction
Legal Provision	Number supporting legal of the reallocation
Legal Provision Date	Date on which passed the legal provision
Project Amount Domestic	Shows Total Domestic Amount for the whole Reallocation
Counterpart Project Amount Domestic	Shows Total Domestic Amount for the whole Reallocation
Total Project Amount Domestic	Calculated field, Display only. Total Domestic Project Amount” = “Domestic Project Amount” + “Domestic Counterpart Project Amount”
Created By	User who created the Project with External Financing. Populated automatically by the system.
Created Date	Date and time of creation the Project with External Financing. Default current system date and time.
Approved By	User who approved the Project with External Financing. Populated automatically by the system, when the document is approved.
Approved Date	Date and time in which the Project with External Financing document turns to ‘Approved’ Status. Default current system date and time. Populated automatically by the system in time of approved for registration.

Reallocation Voucher Details

Overview

This entity contains the list of Reallocation Details for Projects with external financing.

Reallocation Voucher Details Tab Screen Fields

Fields	Descriptions
Agreement Project	System will automatically display the Elements to definition in the Parameter where Concept Id is equal System string Parameter " Agreement"
Agreement Exchange Rate	Exchange rate, Domestic Currency of Project with external financing.
Project Structure Element	Name of Project Structure.
Expense Category Element	Name of Expense Category.
Is counter Part	It indicates whether the amount corresponds to funds domestic or counterpart.
Agreement Amount	Assigned Agreement Amount of Project with external financing.
Domestic Amount	Assigned Domestic Amount of Reallocation.

Support Entities

Disbursement Type

Overview

This entity contains the list of Disbursement type for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Support Entities ► Disbursement Type

Disbursement Type Screen Fields

Fields	Descriptions
Id	Unique ID that identifies the Disbursement type.
Language	Country specific language
Name	Short name of disbursement type. Manually entered by the user.
Description	Name or description of disbursement type. Manually entered by the user.
Active	To indicate if the Disbursement Type is Active or Restrictive.

Project External Financing

Overview

This entity contains the list of Project with External Financing which are opening management.

Navigation

Expenditures ► Project External Financing ► Support Entities ► Project External Financing

Project External Financing Screen Fields

Fields	Descriptions
Id	Unique ID that identifies the Project External Financing
Fiscal Year	Fiscal Year Default current FY
Workflow Status	This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.
Institution	System will automatically display the Project Structure Code, based on the attribute "Institution Name" from Institution entity.
Element	System will automatically display the Elements
Project Status	Basic Stages are: ’In process’, ’Execution’, ‘Finalized’, ‘Suspended’ Default = ‘In Process’
Opening Date	Opening date of Project with external financing. Manually entered by the user.
Closing Date	Closing date of Project with external financing.
Account Closing Date	Accounting Closing date of Project with external financing. Manually entered by the user. Default is Null.
Eligibility Date	Eligibility date of Project with external financing. Manually entered by the user. Default is Null.
Last Disbursement Date	Updated date of last disbursement for Project with external financing. Attribute Read Only. Default is Null.
Language	Country specific language
Name	Short name of Project with external financing according to their characteristics. Manually entered by the user.
Description	Full name of Project with external financing according to their characteristics.
Analytics Description	Analytics name of Project with external financing according to their characteristics.
Loan Condition	Loan conditions of Project with external financing.
Authorized No	Authorized No. of Project with external financing.
Project Manager	Project Manager of Project with external financing.
Domestic Project Amount	Shows Total Domestic Amount for the whole agreements,
Disbursement Project Domestic Amount	Shows the total amount of the sum of "Disbursement Domestic Amount" attribute of the entity Agreement Project for all agreements related to Project ID.
Domestic Counterpart Project Amount	Shows Total Domestic Amount for the whole agreements, the attribute “Domestic Amount” of the entity Agreement Project where the attribute “Counterpart” = True
Total Domestic Project Amount	Total Domestic Project Amount” = “Domestic Project Amount” + “Domestic Counterpart Project Amount”
Snip Code	Code of project, allocated in the SNIP (National Public Investment System) for Project with external financing.
Created By	User who created the Project with External Financing.
Creation Date	Date and time of creation the Project with External Financing.
Approved By	User who approved the Project with External Financing.
Approved Date	Date and time in which the Project with External Financing document turns to ‘Approved’ Status. Default current system date and time.

Agreement Project

Overview

List of one to many Agreements assigned to this Project with External Financing.

Agreement Project Tab Screen Fields

Fields	Descriptions
Correlative	Unique identifier that identifies a Agreement. It's assigned automatically by application. Attribute read only. Correlative Number
Sigade Code	Code of loan, allocated in the SIGADE (Management System and Debt Analysis) for Project with external financing. Manually entered by the user.
Agreement No	Code of Agreement. Manually entered by the user.
Is Counter Part	It indicates whether the amount corresponds to funds domestic or counterpart. Default value = false
Agreement Currency	Agreement currency of Project with external financing. Selection by the user manually.
Agreement Exchange Rate	Exchange rate, of the Agreement Currency. Read-only if the currency is Local then Exchange Rate = 1
Agreement Amount	Agreement Amount of Project with external financing.
Amount (Domestic)	Agreement Currency is Foreign then it will be read only auto calculated, if the currency is Local then its manually entered
Disbursement Foreign Amount	Automatically calculate and will be populated by the Revenues module
Disbursement Domestic Amount	Automatically calculate and will be populated when an Invoice Document related to "Agreement No" is Approved.
Country	Country director of the agency
Intermediary Bank	Intermediary bank of Project with external financing. Selection by the user manually. drop down
Financial Organism	System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Financial Organism"
Specified Source	System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Financing source"
Financing Source	System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Specified source"
Treasury Bank Account	Unique identifier of Bank Account Number associated with one Treasury Bank, Agreement Account.
Special Account Bcn	Unique identifier of Bank Account Number associated with one Treasury Bank, Special Account in BCN (Central Bank of Nicaragua).
Language	Country specific language
Abbreviation	Abbreviation or Short name of the Agreement.
Description	Full name of the Agreement.

Line Project

Overview

This entity contains the list of the Project Structure and Expense category, with amounts allocated.

Line Project Tab Screen Fields

Fields	Descriptions
Correlative	Unique identifier that identifies a Line of Project with external financing.
Agreement Amount	Assigned Agreement Amount of Project with external financing.
Amount (Domestic)	Assigned Domestic Amount of Project with external financing for the Line item
Project Structure	System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Project Structure"
Project Structure Name	Name of Project Structure. System will automatically display the Project Structure Name, based on the attribute "Project Structure Code" from Element entity.
Expense Category	System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “CATEGORY_EXPENSE"
Expense Category Name	Name of Expense Category. System will automatically display the Expense Category Name, based on the attribute "Expense Category Code" from Element entity.