Exibir origem

Easy Drawback Control Managerial Panels

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

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

Export Orders (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 no register is found, the Request will be Forwarded (with RV or Shipment).

•	If a register is found on the EE9 table, the content of the EE9_PREEMB field is used to search the EEC table, to check the Shipment Date (EEC_DTEMBA) entry. If the date is found, the corresponding request is Finished (Shipped).

The number of Pending, Forwarded and Finished requests is totaled on 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

Imports (Type 2 - Bar Model)

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

Reading of all Invoices (SW9) for each SW6 record. Remember that the access key is the index 3 of SW9 (W9_FILIAL+W9_HAWB).

Invoice Total (W9_FOB_TOT) in the origin currency (W9_MOE_FOB) of Invoices is converted into 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:

•	Type of Closing (W6_TIPOFEC) must be equal to DI or DIN.

•	Clearance Date (W6_DTDESE) must be in compliance with the parameterization entry (initial and final date in month/year format) compulsorily defined by the user.

Tables used:

Table	Description
SW6	Clearance Process
SW9	Invoice

Fields used:

Table	Field	Description
SW6	W6_DTDESE	Clearance Date
SW6	W6_TIPOFEC	Type of Closing: • DA – Declaration of Temporary Admission (warehouse) • DI – Import Declaration • DIN – Nationalization DI
SW9	W9_MOE_FOB	Invoice Currency
SW9	W9_FOB_TOT	Invoice Total

Purchase Orders (Type 2 - Pie Model)

Reading of SW2 table based on the selection criteria defined by the user. For each SW2 record, read W3 records by index 1 (W3_FILIAL+W3_PO_NUM+...).

If all items of a PO have only the ZERO sequence (W3_SEQ = 0), the order is Pending.

For Sent or Closed orders, the following processing is made:

•	Creation of an array in SW3 for each PO. This array is only composed of ZERO Sequence records (W3_SEQ = 0).

•	SW7 is selected with index 2 (W7_FILIAL+W7_PO_NUM+...), and SW6 with index 1 (W6_FILIAL+W6_HAWB). If the field W6_DT_ENTR is empty, PO is classified as Sent. Then, the same process is repeated for the next SW2 record.

•	Reading of all PO records in SW7. For each record with the field W6_DT_ENTR filled out, the amount (W7_QTDE) is subtracted from the array according to the field Status.

•	After finishing record reading in SW7 for the current PO, the system checks if there is balance left in the array. If no, PO is classified as Closed.

The amount of records per Type of Process (Pending, Sent, or Closed) is totalized in the panel.

Data Displayed:

•	Y-Axis – Amount of Processes.

•	X-Axis – Types of Processes (Pending, Sent, and Closed).

Selection Criteria:

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

Tables used:

Table	Description
SW2	Purchase Orders
SW3	PO Items
SW6	Clearance
SW7	Clearance Items

Fields used:

Table	Field	Description
SW2	W2_PO_NUM	No. P.O.
SW2	W2_PO_DT	P.O. Date
SW3	W3_SEQ	Sequence
SW3	W3_POSICAO	Position
SW3	W3_QTDE	Amt.
SW6	W6_DT_ENTR	Delivery Date
SW7	W7_QTDE	Amt.

Drawback Summary (Type 1 - 1 Dimension)

Displays the total quantity of Drawback Orders, the total quantity of Concessions and the balance Import/Export (US$).

Selection Criteria:

•	Total quantity of existing Drawback Orders (ED0).

•	Total quantity of Concessions approved (field Ed0_AC completed).

•	Balance to Import in Drawback in US$:

•	Sum of all balance to import existing in the Orders (ED4_VL_LI);

•	Consider only the Orders with approved Concessions (ED0_AC completed);

•	Do not consider the balances of the closed Orders (ED0_DT_ENC completed).

•	Balance to Export in Drawback in US$:

•	Sum of all balance to export existing in the Orders (ED4_VL_LI);

•	Consider only the Orders with approved Concessions (ED0_AC completed);

•	Do not consider the balances of the closed Orders (ED0_DT_ENC completed).

Tables used:

Table	Description
ED0	Drawback Request Cover
ED3	Balance of Products to Export
ED4	Balance of Items to Import

Fields used:

Table	Field	Description
ED0	ED0_AC	Concession
ED0	ED0_DT_ENC	Closing Date
ED3	ED3_SALDO	Balance (Qty. to Export)
ED4	ED4_VL_LI	Balances in Value in the LI

Taxes Earnings (Type 2 - Bars Model)

Displays the earnings value with taxes ((II, IPI, ICMS and Merchant Marine / Warehouse) per month (US$).

Data Displayed:

•	Y-Axis – Values in US$.

•	Axle X – Months.

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.