Exibir origem

Easy Financing Management Panels

The Easy Financing management panels display in a functional and efficient way information pertinent to the daily experience of system users.

Export Exchange (Type 2 - Bars Model)

Reading of SWB table based on the selection criteria defined by the user, considering only the exchange installments related to the clearance (field WB_PO_DI = D).

The Exchange Total (WB_FOB_MOE) in the origin currency (WB_MOEDA) of Shipment is converted to US Dollar.

To accrue the Total per month, the system considers that the completion of Settlement Date (WB_CA_DT) classifies the exchange as PAID. If this date is blank, the exchange is PAYABLE.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Months (with two columns for each month: Payable and Paid).

Selection Criteria:

•	Due Date (WB_DT_VEN) must be in compliance with the parameterization entry (initial and final date) defined by the user.

Tables used:

Table	Description
SWB	Import Exchange

Fields used:

Table	Field	Description
SWB	WB_DT_VEN	Due Date
SWB	WB_PO_DI	Exchange Type, being C=Clearance and A=Advance
SWB	WB_MOEDA	Currency
SWB	WB_FOB_MOE	Amount
SWB	WB_CA_DT	Settlement Date

Import Exchange (Type 2 - Bar Model)

Reading of SWB table based on the selection criteria defined by the user, considering only the exchange installments concerning Clearance (WB_PO_DI = \"D\").

Exchange Total (WB_FOB_MOE) in the origin currency (WB_MOEDA) is converted into US Dollar.

To accrue the Total per month, the system considers that the completion of Settlement Date (WB_CA_DT) classifies the exchange as PAID. If this date is blank, the exchange is PAYABLE.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Months (with two columns for each month: Payable and Paid).

Selection Criteria:

•	Due Date (WB_DT_VEN) must be in compliance with the parameterization entry (initial and final date) defined by the user.

Tables used:

Table	Description
SWB	Import Exchange

Fields used:

Table	Field	Description
SWB	WB_DT_VEN	Due Date
SWB	WB_PO_DI	Type of Exchange, where D = Clearance and A = Advance
SWB	WB_MOEDA	Currency
SWB	WB_FOB_MOE	Amount
SWB	WB_CA_DT	Settlement Date

Average Interest Rate for Financing (Type 1-1 Dimension)

It displays the average rate of interests of Import and Export, the number of pending contracts and Invoices to settle (Import and Export).

•	Average rate of interests of export financing:

To calculate the average rate of interests of export financing, the system must consider contracts from the Table of Financing Contracts (EF1), where the Contract Type is Export (EF1_TPMODU = \"E\").

The calculation will be the average from the interests rates of the contracts, weighted by their values.

Contract Value = Total value of financing in Brazilian Real (BRL).

Rate Average Contract = Average rate of contract interests, considering the average from the periods of the contract weighted by the number of days.

With Payment Installments = the average of the contract rate will be the sum of the averages of the rates from the different types of interests.

•	Number of pending Export Contracts:

To calculate the number of export financing contracts, the system must consider contracts from the EF1 Table, where the Type of Contract is Export (EF1_TPMODU = \"E\").

For contracts with the same key (EF1_FILIAL+EF1_TPMODU+EF1_CONTRA+EF1_BAN_FI+EF1_PRACA), but with different sequences (EF1_SEQCNT), the system verifies if there is at least one pending sequence; if any, it is considered just a pending contract. If there is more than one pending sequence, they must not be considered in the calculation.

•	Number of pending Import Contracts:

To calculate the number of import financing contracts, the system must consider contracts from the EF1 Table, where the Type of Contract is Import (EF1_TPMODU = I).

For contracts with the same key (EF1_FILIAL+EF1_TPMODU+EF1_CONTRA+EF1_BAN_FI+EF1_PRACA), but with different sequences (EF1_SEQCNT), the system verifies if there is at least one pending sequence; if any, it is considered just a pending contract. If there is more than one pending sequence, they must not be considered in the calculation.

•	Number of Pending Invoices linked to Export contracts:

To calculate the number of pending invoices linked to export financing contracts, the system must consider contracts from the EF1 Table, where the Type of Contract is Export (EF1_TPMODU = E).

Tables used:

Table	Description
EF1	Cover of Export Financing
EF3	Contract Events

Fields used:

Table	Field	Description
EF1	EF1_VL_MOE	Value of Financing in the Currency
EF1	EF1_TP_FIN	Type of Financing
EF1	EF1_DT_ENC	Closing Date
EF1	EF1_DT_CON	Contract Date
EF1	EF1_DT_VEN	Contract Due Date
EF1	EF1_DT_JUR	Initial Date of Interests
EF1	EF1_BAN_FI	Closing Bank
EF1	EF1_CONTRA	Contract Number
EF3	EF3_CODEVE	Event Code

Type of Financing Contracts (Type 2 - Pie Model)

Total value (EF1_VL_MOE) of financing contracts (ACC, ACE, etc.) will be converted into American Dollars and separated by type of financing (EF1_TP_FIN).

Only contracts that met the following conditions will be considered:

•	Not closed: EF1_DT_ENC field must be blanc;

•	Start of the contract before or during the period: EF1_DT_CON field lower than end period;

•	Not Due: EF1_DT_VEN field greater than start period;

•	It must not be closed: EF3_CODEVE field == “180”;

•	It must not have balance transfer: EF3_CODEVE field == “190”;

•	To finance import, have interest start date: EF1_DT_JUR field completed and lower than end period.

Selection Criteria:

•	Period parameterization (start date and end date) defined by user.

•	Filter by Financing Type (table EF7) according to the filter, the following information should be shown:

•	Contract Number (EF1_CONTRA);

•	Contract Value(EF1_VL_MOE);

•	Contract Bank (EF1_BAN_FI).

Tables used:

Table	Description
EF1	Cover of Export Financing
EF3	Contract Events

Fields used:

Table	Field	Description
EF1	EF1_VL_MOE	Value of Financing in the Currency
EF1	EF1_TP_FIN	Type of Financing
EF1	EF1_DT_ENC	Closing Date
EF1	EF1_DT_CON	Contract Date
EF1	EF1_DT_VEN	Contract Due Date
EF1	EF1_DT_JUR	Initial Date of Interests
EF1	EF1_BAN_FI	Closing Bank
EF1	EF1_CONTRA	Contract Number
EF3	EF3_CODEVE	Event Code

Financing Comparative (Type 2 - Bar Model)

Bars are related to Import and Export type, and the following indicators are used:

•	Import or Export - Total Amount;

•	Import or Export - Financed Amount.

Used amounts are converted to American Dollars on the date of processing.

•	General export amount;

•	Sum of amounts of Financed Exports:

•	Check the existence of registers containing the field EF3_TPMODU == E and EF3_CODEVE == 600 on EF3 table.

•	Sum of the field EF3_VL_INV, using the field EF3_MOE_IN for the conversion.

•	Subtraction of register amounts containing the field EF3_EV_EST completed with 600.

•	General import amount;

•	Sum of amounts of Financed Imports:

•	Check the existence of registers containing the field EF3_TPMODU == I and EF3_CODEVE == 600 on EF3 table.

•	Sum of the field EF3_VL_INV, using the field EF3_MOE_IN for the conversion.

•	Subtraction of register amounts containing the field EF3_EV_EST completed with 600.

The description on the panel show the Dollar rate considered for conversion and corresponding date.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Export (two columns: Export and Financed Export) and Import (two columns: Import and Financed Import).

Selection Criteria:

•	Parameterization (start date and end date) defined by user.

Tables used:

Table	Description
EF3	Contract Events

Fields used:

Table	Field	Description
EF3	EF3_TPMODU	Module Type
EF3	EF3_CODEVE	Event Code
EF3	EF3_VL_INV	Amount in invoice currency
EF3	EF3_MOE_IN	Invoice Currency
EF3	EF3_EV_EST	Reverse Event Code

For the panels previously described, you must note the following details:

•	The currency symbol US$ must be read from the parameter MV_EECUSS. Hence, the correct completion of this parameter is a requirement for the routine operation.

•	If the origin currency is US Dollar, conversion is not executed.