ESTAGRO - Bi-annual Tracking Report on the Stock of Pesticides

01. OVERVIEW

The Bi-annual Tracking Report on the Stock of Pesticides (MATR936) is available. It contains information on the control of the production, trade, use, consumption, transport, and storage of pesticides, their components and the like, as well as their waste and packaging.

It is intended for sites that produce, market, consume, transport, or store pesticides, their components and the like. In order to track these operations in the territory.

02. DEPLOYMENT PROCEDURE

Fields

Table SB5 – Product Complement File

Field	B5_INGATV
Type	Character
Size	40
Decimal	0
Format	@!
Title	Act Ingr Name
Description	Active Ingredient Name
Help	Name of the Active Ingredient referring to phytosanitary pesticides.

Field	B5_FORCAO
Type	Character
Size	70
Decimal	0
Format	@!
Title	Formulation
Description	Formulation
Help	Formulation related to phytosanitary pesticides.

Field	B5_CLASSE
Type	Character
Size	70
Decimal	0
Format	@!
Title	Pest. Class.
Description	Pesticide Class
Help	Class referring to phytosanitary pesticides.

Field	B5_CONCEN
Type	Character
Size	25
Decimal	0
Format	@!
Title	Concentration
Description	Concentration
Help	Concentration related to phytosanitary pesticides.

Table SD1 - Incoming Invoice Items

Field	D1_NRECAGR
Type	Character
Size	5
Decimal	0
Format	@!
Title	Agr Presc No.
Description	Number of Agronomic Prescription
Help	Number of the agronomic prescription for phytosanitary pesticides.

Table SD1 - Outgoing Invoice Items

Field	D2_NRECAGR
Type	Character
Size	5
Decimal	0
Format	@!
Title	Agr Presc No.
Description	Number of Agronomic Prescription
Help	Number of the agronomic prescription for phytosanitary pesticides.

Table SC6 - Sales Order Items

Field	C6_NRECAGR
Type	Character
Size	5
Decimal	0
Format	@!
Title	Agr Presc No.
Description	Number of Agronomic Prescription
Help	Number of the agronomic prescription for phytosanitary pesticides.

03. SETUP PROCEDURE

From the Configuration Tool (SIGACFG), go to Database/Dictionary/Database and create/edit the following field(s):

Field	<field according to the customer>
Type	Character
Size	50
Decimal	0
Format	@!
Title	Active
Description	Active Ingredient
Help	Enter the active ingredient that makes up the pesticide.

Example of field: B5_PATIVO

Field	<field according to the customer>
Type	Numeric
Length	5
Decimal	2
Format	@e 99.99
Title	Ingr. Perc.
Description	Active Ingr. Perc.
Help	Enter the percentage of the active ingredient that makes up the pesticide.

Example of field: B5_PPATIV

Field	<field according to the customer>
Type	Character
Length	3
Decimal	0
Format	@!
Title	Tox. Class
Description	Toxicological Class
Options List	1=Extremely Toxic;2=Highly Toxic;3=Moderately Toxic;4=Little Toxic
Help	Enter the toxicological class of the pesticide, being: I - Extremely Toxic; II - Highly Toxic; III - Moderately Toxic; IV - Little Toxic.

Example of field: B5_CLTOXI

Field	<field according to the customer>
Type	Character
Length	20
Decimal	2
Format	@!
Title	Pack. Tp.
Description	Type of Package
Help	Enter the type of packaging in which the pesticide is presented.

Example of field: B5_TPEMBA

In the Configuration Tool (SIGACFG), access Environments/Files/Parameters. Create/edit the following parameter(s):

Items/Folders	Description
Name	MV_PPATIV
Type	Character
Por. Cont.	<field according to the customer>
Description	Enter the SB5 table field containing the percentage of the product's active ingredient.

Example of completion: B5_PPATIV

Items/Folder	Description
Name	MV_CLTOXI
Type	Character
Por. Cont.	<field according to the customer>
Description	Enter the SB5 table field containing the product's toxicological class.

Example of completion: B5_CLTOXI

Items/Folder	Description
Name	MV_TPEMBA
Type	Character
Por. Cont.	<field according to the customer>
Description	Enter the SB5 table field containing the type of product packaging.

Example of completion: B5_TPEMBA

04. USAGE PROCEDURE

If the report menu option does not exist, it must be entered manually in the Configuration Tool (SIGACFG). Access Environments/File/Menu.Enter the new MATR936 menu option as follows:

Menu	Sub-menu	Routine Name	Program	Module	Tables
Reports	Official Tax Records	Pesticide Track.	MATR936	Tax Records	SF2, SD2, SF1, SD1, SA1, SA2, SB1, SB5, SF4

In the Tax Records module, option Reports/Official Tax Records/Pesticide Track., check the values of the routine parameters according to the following instruction:

From Date?

Enter the initial date for processing the report.

To Date?

Enter the final date for processing the report.

From Product?

Enter the initial product to be processed.

To Product?

Enter the final product to be processed.

From Group?

Enter the initial group of products to be processed.

To Group?

Enter the final group of products to be processed.

Merchant's name?

Enter the name of the merchant responsible for the supplied data.

CIDASC or IDAF no.

Enter the registration number of the establishment at CIDASC (Integrated Company of Agricultural Development of Santa Catarina) or IDAF (Institute of Agricultural and Forestry Defense of ES).

Category?

Enter the category in which the establishment fits to print the report header.

Closing Dt. ?

Enter the date of the last stock closure that should be considered to issue the report. It is worth remembering that this date will be the starting point of the report, that is, the stock found on the date entered in this question will be the initial stock. The final stock will be calculated by adding the entries and subtracting the outputs from the initial stock period found.

05. TABLES

SF2 – Outgoing Invoice Headers
SD2 – Invoice Sales Items
SF1 – Incoming Invoice Headers
SD1 – Incoming Invoice Items
SA1 – Customers
SA2 – Suppliers
SB1 – Generic Product Description
SB2 – Physical and Financial Balances
SB5 – Additional Product Data
SF4 – Types of Inflow and Outflow

06. ADDITIONAL INFORMATION

Legislation: http://www.planalto.gov.br/ccivil_03/decreto/2002/d4074.htm

Páginas filhas