Exibir origem

Easy Export Control Managerial Panels

The managerial panels of Easy Export Control display information pertaining to the user quotidian in a practical and efficient way.

Export Requests (Type 2 - Pie Template)

Reading of EE7 table based on the criteria of selection defined by the user. For each EE7 register, read the EE8 registers by index 1 (EE8_FILIAL+EE8_PEDIDO +...).

If the Balance of Items (EE8_SLDATU) is equal to the initial quantity (EE8_SLDINI) and the field EE8_RV is empty, the Request will be Pending. But only if ALL items follow this condition.

For requests out of the situation previously described (Pending), the following processing is accomplished:

•	For each register of EE8 table, the system performs a search in the table EE9 through index 1 (EE9_FILIAL+EE9_PEDIDO), verifying if there is any register. If any register is found, the Request is Forwarded (with RV or Shipment).

•	If any register is found in EE9 table, the content of the field EE9_PREEMB will be used in a search in the table EEC, to verify the filling of the Shipment Date (EEC_DTEMBA). If the date is found, the respective request will be Finished (Shipped).

The number of Requests for the situations Pending, Forwarded and Finished will be totalized in the panel.

Data Displayed:

•	Y-Axis – Amount of Processes.

•	Axle X – Types of Processes (Pending, Forwarded and Finished).

Selection Criteria:

•	The Date of Request (EE7_DTPROC) must be in accordance with the parameterization entry (initial date and final date) defined by the user.

Tables used:

Table	Description
EE7	Export Request Cover
EE8	Export Request Items
EEC	Export Shipment Cover
EE9	Export Shipment Items

Fields used:

Table	Field	Description
EE7	EE7_PEDIDO	Code of the request
EE7	EE7_DTPROC	Date of the request
EE8	EE8_SLDINI	Initial Quantity
EE8	EE8_SLDATU	Balance
EE8	EE8_PEDIDO	Code of the request
EE8	EE8_RV	RV number
EEC	EEC_PREEMB	Shipment Code
EEC	EEC_DTEMBA	Shipment date
EE9	EE9_PREEMB	Shipment Code
EE9	EE9_PEDIDO	Code of the request

Export per Period (Type 2 - Bars Model)

Reading of EEC table based on the criteria of selection defined by the user.

The total of Shipment (EEC_TOTPED) in the origin currency (EEC_MOEDA) is converted to US Dollar.

The totals in US$ per month are accrued.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Months (Example: Jan/2007, Feb/2007, Mar/2007, etc).

Selection Criteria:

•	The Shipment Date (EEC_DTEMBA) must be in accordance with the parameterization entry (initial date and final date in the format month/year), obligatorily defined by the user.

Tables used:

Table	Description
EEC	Export Shipment

Fields used:

Table	Field	Description
EEC	EEC_DTEMBA	Shipment date
EEC	EEC_MOEDA	Currency Negotiated
EEC	EEC_TOTPED	Shipment Value in the Currency Negotiated

Average Cost per Process (Type 2 - Bars Model)

Reading of EEC table based on the criteria of selection defined by the user, using the key BRANCH + EEC_PREEMB + Q, to select the Expenses of each Shipment (EET_VALORR) through Index 1 of Expenses (EET_FILIAL+EET_PEDIDO+EET_OCORRE ).

The field EET_OCORRE must be equal to Q, to indicate the expense is part of a Shipment.

The total of Expenses (EET_VALORR) in the origin currency (WB_MOEDA) of Shipment is converted to US Dollar.

The totals in US$ per Means of Transportation are accrued and divided by the number of processes to reach the average.

Data Displayed:

•	Axle X – Values in US$;

•	Axle Y – Means of Transportation.

Selection Criteria:

•	The Shipment Date (EEC_DTEMBA) must be in accordance with the parameterization entry (initial date and final date in the format month/year), obligatorily defined by the user.

Tables used:

Table	Description
EEC	Export Shipment
EET	Expenses per Process

Fields used:

Table	Field	Description
EEC	EEC_PREEMB	Shipment Code
EEC	EEC_DTEMBA	Shipment date
EEC	EEC_MOEDA	Shipment Currency
EEC	EEC_VIA	Means of transportation
EET	EET_PEDIDO	Request/Shipment
EET	EET_TIPOAG	Type of Agent
EET	EET_OCORRE	Phase of Expense Linkage
EET	EET_VALORR	Expense value

Pending Advance per Customer (Type 2 - Pie Model)

Reading of EEQ table based on selection criteria defined by the user, using the field EEQ_PREEMB (which is the Importer Code in this case) to find the importer Name in the table SA1.

The Balance of Advance (EEQ_SALDO) in the origin currency (EEQ_MOEDA) is converted to US Dollar.

The totals in US$ per importer will be accrued.

Data Displayed:

•	Axle Y – Advances not linked in US$;

•	Axle X – Description of Importers.

Selection Criteria:

•	Event(EEQ_EVENT) must be equal to 650;

•	Phase (EEQ_FASE) must be equal to C;

•	Type (EEQ_TIPO) must be equal to A;

•	Balance (EEQ_SALDO) cannot be zeroed.

Tables used:

Table	Description
EEQ	Exchange/Advance
SA1	Register of Importers

Fields used:

Table	Field	Description
EEQ	EEQ_EVENT	Accounting Event
EEQ	EEQ_FASE	Phase
EEQ	EEQ_TIPO	Type
EEQ	EEQ_SALDO	Balance to Relate
EEQ	EEQ_MOEDA	Currency
EEQ	EEQ_PREEMB	Importer Code (for Advances Customer Phase)
SA1	A1_COD	Importer Code
SA1	A1_NREDUZ	Reduced Description of Importer

Commission of Agents (Type 2 - Pie Model):

Reading of EEB table based on the selection criteria defined by the user, using the field EEB_PEDIDO to verify whether the Shipment Date is within the specified selection, through Index 1 of Shipment (EEC_FILIAL+EEC_PREEMB).

The total of Commissions (EEB_TOTCOM) in the origin currency (EEC_MOEDA) of Shipment is converted to US Dollar

The totals in US$ per Period will be accrued.

Data Displayed:

•	Axle Y – Commission Value;

•	Axle X – Period.

Selection Criteria:

•	Type of Left Agent(EEB_TIPOAG,1) must be equal to 3 – Receiver Agent of Commission;

•	Phase (EEB_OCORRE) must be equal to Q - Shipment;

•	The Shipment Date (EEC_DTEMBA) must be in accordance with the parameterization entry (initial date and final date in the format month/year), obligatorily defined by the user.

Tables used:

Table	Description
EEC	Export Shipment
EEB	Agents / Commissions

Fields used:

Table	Field	Description
EEC	EEC_PREEMB	Shipment Code
EEC	EEC_DTEMBA	Shipment date
EEC	EEC_MOEDA	Shipment Currency
EEB	EEB_PEDIDO	Request/Shipment
EEB	EEB_TIPOAG	Type of Agent
EEB	EEB_OCORRE	Agent Linkage Phase
EEB	EEB_TOTCOM	Commission Value

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, C=Clearance and A=Advance
SWB	WB_MOEDA	Currency
SWB	WB_FOB_MOE	Value
SWB	WB_CA_DT	Settlement Date

•	For the panels previously described (excepting Export Requests), 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.