CONTENT
Índice |
---|
The Normative Instructions routine (MATA 950) enables the generation of the SCANC - System of Reception and Auditing of Fuel Annexes. The SCANC must be generated from typing and/or import of stocks and invoices (incoming and outgoing) and monthly transmitted to States and Suppliers according to Chapter V, of ICMS Agreement 03/99, of April 16th, 1999, to interstate operations with fuel derived from the petroleum in which tax was previously retained, or Anhydrous Ethyl Alcohol Fuel – AEAC whose operation occurred with tax suspension or deferral.
Who is it aimed at | Fuel distributors, carriers, retailers, and importers. |
---|---|
Purpose | Generating and sending fuel Annexes for States and suppliers. |
Delivery term | Monthly |
Reach | State - All States |
Application provided by Tax Authority | SCANC-CTB |
Version of the validator supported by Protheus | 2.0.11 |
Where to find the application made available by Tax Authority | http://scanc.fazenda.mg.gov.br/scanc (Available only for taxpayers) |
Legislation involved | Statute no. 3,665, November 20, 2000. |
Copy the SCANC.INI configuration files for the directory corresponding to \SYSTEM.
In the Tax Records module (SIGAFIS), access Miscellaneous/Magnetic Files/Normative Instructions (MATA950), and configure the routine parameters according to the following instructions:
Start Date?
Enter the calculation's initial date.
End Date?
Enter the calculation's final date.
Instr. Normative Instruction?
In this magnetic medium, enter the name of the Normative Instruction that will be calculated:
Target File?
Enter the name of the file where the information will be stored. Example: SCANC.TXT.
Target Directory?
Indicate the directory name where the text file generated from the calculation is saved.
Example: C:\TXTS\.
Select Branch?
Indicate if the branches to be processed are selected. When you select No, only the current branch is considered; when selecting Yes, the system displays a screen in which you must select branches to be considered.
For this record, the information is generated through the Company File and according to the filling of parameter MV_SCANC06.
For this record, the information is generated through the Suppliers File and/or Customers File, according to the filling of the parameters MV_SCANC01, MV_SCANC03, MV_SCANC04, and MV_SCANC05.
For this record, information is generated through headers and items of Incoming and Outgoing Invoices, and according to the completion of the parameters MV_SCANC01, MV_SCANC07, MV_SCANC08, MV_SCANC09, MV_SCANC10, MV_SCANC11, MV_SCANC12, MV_SCANCQT, MV_PRODIE, MV_PROGASA, and MV_SCANCQT.
For outgoing invoices: The filling of fields Plate considers fields F2_VEICUL1, F2_VEICUL2, and F2_VEICUL3.
For incoming invoices: The filling of fields Plate considers fields F1_PLACA or 1_VEICUL1, F1_VEICUL2, and F1_VEICUL3.
Informações | ||
---|---|---|
| ||
DCL Templates - Distribution of Fuels and Lubricants If it is necessary to use customized fields in the table SC5 to enter the PLATE fields, you must use parameters MV_SCANSP1, MV_SCANSP2, and MV_SCANSP3 to enter the new fields to be used for outgoing invoices. For incoming invoices, parameters MV_SCANSP1, MV_SCANSP2, and MV_SCANSP3 were created for when a single vehicle (F1_VEICUL1) registered in the DA3 is used and this record has fields customized with the content of the plates 2 and 3. |
For this record, the information is generated through the headers and items of incoming invoices, and outgoing invoices, and according to the filling of the parameters MV_SCANC01, MV_SCANEP2, MV_SCANEP3, MV_SCANSP1, MV_SCANSP2, and MV_SCANSP3.
For outgoing invoices: The filling of the Plate fields considers fields C5_PLACA1, C5_PLACA2, F2_VEICUL1, F2_VEICUL2, and F2_VEICUL3.
For incoming invoices: The filling of the Plate fields considers fields F1_PLACA or 1_VEICUL1, F1_VEICUL2, and F1_VEICUL3.
Aviso | ||
---|---|---|
| ||
This Technical Memo aims to meet what is written in the ICMS Agreement no. 199 of December 22, 2022, which discusses the single-phase taxation system of the ICMS in the operations with fuel under the terms of the Complementary Law no. 192/2022, and what is written in the SINIEF adjustment no. 01/2023 in relation to the new ICMS taxation status codes. NT 2023.001 Rdmake XML Building |
Code | Description | Unit |
---|---|---|
420102004 | DIESEL OIL A S500 | Liter |
420102005 | DIESEL OIL A S500 – WITH ADDITIVES | Liter |
420105001 | DIESEL OIL A S10 | Liter |
420201001 | MARINE DIESEL OIL (DMA-MGO) | Liter |
420201003 | MARINE DIESEL OIL (DMB-MDO) | Liter |
420301002 | OTHER DIESEL OILS (WITHOUT B100 ADDITION) | Liter |
820101001 | BIODIESEL B100 | Liter |
820101012 | DIESEL OIL B S500 - REGULAR | Liter |
820101013 | DIESEL OIL B S500 - WITH ADDITIVES | Liter |
820101033 | DIESEL OIL B S10 - WITH ADDITIVES | Liter |
820101034 | DIESEL OIL B S10 - REGULAR | Liter |
01 | TYPE OF RECORD | "45" |
02 | CALCULATION PERIOD | Parameters entered in the generation wizard by the Normative Instructions routine (MATA950) |
03 | CNPJ (EIN) | CNPJ (EIN) of the Customer/Supplier (A1_CGC or A2_CGC) |
04 | STATE REGISTRATION | State Registration of the Customer/Supplier (A1_INSCR or A2_INSCR) |
05 | State | State of the Customer/Supplier (A1_EST or A2_EST) |
06 | ISSUE DATE | Invoice Issue Date (D1_EMISSAO or D2_EMISSAO) |
07 | TEMPLATE | Invoice template according to the kind entered (F1_ESPECIE or F2_ESPECIE) |
08 | SERIES | Invoice Series (D1_SERIE or D2_SERIE) |
09 | NUMBER | Invoice Number (D1_DOC or D2_DOC) |
10 | CFOP | CFOP of the Invoice item (D1_CF or D2_CF) |
11 | FREIGHT TYPE | Type of freight entered in the related transaction or order |
12 | CARRIER CNPJ/CPF (EIN/SSN) | Carrier CGC (A4_CGC) |
13 | CARRIER STATE | Carrier State (A4_UF) |
14 | FIRST PLATE | Vehicle Plate (DA3_PLACA) entered in the invoice (F1_VEICUL1 or F2_VEICUL1) * |
15 | SECOND PLATE | Vehicle Plate (DA3_PLACA) entered in the invoice (F1_VEICUL2 or F2_VEICUL2) ** |
16 | THIRD PLATE | Vehicle Plate (DA3_PLACA) entered in the invoice (F1_VEICUL3 or F2_VEICUL3) ** |
17 | PRODUCT CODE | The code entered in the Product Additional Data field (SB5) *** |
18 | TOTAL QUANTITY | The quantity entered in the Invoice (D1_QUANT or D2_QUANT) |
19 | QUANTITY OF DIESEL OIL A |
|
20 | BIODIESEL QUANTITY (B100) | For the B100 product, the quantity will be the Mixture Ratio (CD6_PBIO * INVOICE QUANTITY) |
21 | AD REM RATE | The quantity entered in the field (D1_PICM or D2_PICM) |
22 | ICMS VALUE ON THE DIESEL A | Enter the ICMS value on Diesel Oil A. If the product is Diesel Oil B, enter the ICMS value on the Diesel Oil A contained in the mixture. (with two decimal places) |
23 | ICMS VALUE ON BIODIESEL (B100) | Enter the value of the ICMS on Biodiesel (B100) on Diesel Oil B; or the ICMS value on the Biodiesel (B100) previously withheld in the operations with Diesel Oil A (with two decimal places). |
24 | ICMS INFORMATION IN THE INVOICE | Operations with CST 02 and 15: Enter 1 - ICMS collected on the operationOperations with CST 53 and 61: Enter 0 - ICMS collected on the operation |
25 | CONSUMPTION STATE | State of consumption entered in the Fuel Complement file (CD6), field CD6_UFCONS |
26 | PRODUCT SOURCE | Enter the Source of the Field registered in the field (B1_ORIGEM) |
27 | SOURCE STATE OF THE PRODUCT | State of consumption entered in the Fuel Complement file (CD6), field CD6_UFORIG |
28 | PERCENTAGE OF THE SOURCE STATE | % referring to the source State entered in the Fuel Complement file (CD6), field CD6_PORIG. |
*If the vehicle record (DA3) is not found, the plate will be fetched from the F1_PLACA or F2_PLACA fields depending on the transaction, whether inflow or outflow.
**If the vehicle record (DA3) is not found, the plate will be fetched from the F1_PLACA or F2_PLACA fields depending on the transaction, whether inflow or outflow. If the Vehicles file (DA3) is found, the plate will be obtained from the DA3_PLACA field or, if the parameter MV_SCANEP2/MV_SCANEP3 is used, the parameter field will be read.
***Field of the SB5 table entered in the parameter MV_SCANC01.
For this record, the information is generated through the headers and items of incoming invoices, and outgoing invoices, and according to the filling of the parameters MV_SCANC01, MV_SCANEP2, MV_SCANEP3, MV_SCANSP1, MV_SCANSP2, and MV_SCANSP3.
For outgoing invoices: The filling of the Plate fields considers fields C5_PLACA1, C5_PLACA2, F2_VEICUL1, F2_VEICUL2, and F2_VEICUL3.
For incoming invoices: The filling of the Plate fields considers fields F1_PLACA or 1_VEICUL1, F1_VEICUL2, and F1_VEICUL3.
Aviso | ||
---|---|---|
| ||
This Technical Memo aims to meet what is written in the ICMS Agreement no. 199 of December 22, 2022, which discusses the single-phase taxation system of the ICMS in the operations with fuel under the terms of the Complementary Law no. 192/2022, and what is written in the SINIEF adjustment no. 01/2023 in relation to the new ICMS taxation status codes. NT 2023.001 Rdmake XML Building |
Code | Description | Unit |
---|---|---|
210203001 | GLP/GLGN | KG |
210203003 | COMMERCIAL PROPANE | KG |
210203004 | SPECIAL PROPANE | KG |
210203005 | COMMERCIAL BUTANE | KG |
01 | TYPE OF RECORD | "47" |
02 | CALCULATION PERIOD | Parameters entered in the generation wizard by the Normative Instructions routine (MATA950) |
03 | CNPJ (EIN) | CNPJ (EIN) of the Customer/Supplier (A1_CGC or A2_CGC) |
04 | STATE REGISTRATION | State Registration of the Customer/Supplier (A1_IE or A2_IE) |
05 | State | Acronym of the State of the Customer/Supplier (A1_UF or A2_UF) |
06 | ISSUE DATE | Issue date of the incoming or outgoing invoice (F1_EMISSAO or F2_EMISSAO) |
07 | TEMPLATE | Template of the invoice entered in the tax document (F1_ESPECIE or F2_ESPECIE) |
08 | SERIES | Series of the invoice entered in the tax document (F1_SERIE or F2_SERIE) |
09 | NUMBER | Invoice number (F1_DOC or F2_DOC) |
10 | CFOP | Tax Code of Operations and Provisions (D1_CF or D2_CF) |
11 | FREIGHT TYPE | Type of freight entered in the Sales Order or Incoming Document. |
12 | CNPJ/CPF OF THE CARRIER | The carrier code entered in the invoice, the CNPJ or CPF is fetched (A4_CGC). |
13 | CARRIER STATE | The carrier code entered in the invoice, the State is fetched (A4_EST). |
14 | FIRST PLATE | Vehicle Plate (DA3_PLACA) entered in the invoice (F1_VEICUL1 or F2_VEICUL1) * |
15 | SECOND PLATE | Vehicle Plate (DA3_PLACA) entered in the invoice (F1_VEICUL2 or F2_VEICUL2) ** |
16 | THIRD PLATE | Vehicle Plate (DA3_PLACA) entered in the invoice (F1_VEICUL3 or F2_VEICUL3) ** |
17 | PRODUCT CODE | The code entered in the Product Additional Data field (SB5) *** |
18 | TOTAL QUANTITY (KG) | The quantity entered in the field (D1_QUANT or D2_QUANT) |
19 | GLP RATIO (%) | The percentage of GLP entered in the Fuel Complement file (CD6), field CD6_PGLP. |
20 | GLGN RATIO (%) | The percentage of GLGNn entered in the Fuel Complement file (CD6), field CD6_PGNN. |
21 | GLGNi RATIO (%) | The percentage of GLGNI entered in the Fuel Complement file (CD6), field CD6_PGNI. |
22 | AD-REM RATE | The quantity entered in the field (D1_PICM or D2_PICM) |
23 | ICMS VALUE ON THE GLP | The ICMS value of the operation (D1_VALIMC or D2_VALICM) * Field 19 GLP Percentage (%) |
24 | ICMS VALUE ON THE GLGNn | The ICMS value of the operation (D1_VALIMC or D2_VALICM) * Field 20 GLPNn Percentage (%) |
25 | ICMS VALUE ON THE GLFNn | The ICMS value of the operation (D1_VALIMC or D2_VALICM) * Field 21 GLPNi Percentage (%) |
26 | ICMS INFORMATION IN THE INVOICE | Operations with CST 02 and 15: Enter 1 - ICMS collected on the operationOperations with CST 53 and 61: Enter 0 - ICMS collected on the operation |
27 | CONSUMPTION STATE | State of consumption entered in the Fuel Complement file (CD6), field CD6_UFCONS |
29 | CONSUMPTION SOURCE | Enter the Source of the Field registered in the field (B1_ORIGEM) |
29 | PRODUCT SOURCE STATE | The consumption state entered in the Fuel Complement file (CD6), field CD6_UFORIG field |
30 | PERCENTAGE OF THE SOURCE STATE | % referring to the source State entered in the Fuel Complement file (CD6), field CD6_PORIG. |
*If the vehicle record (DA3) is not found, the plate will be fetched from the F1_PLACA or F2_PLACA fields depending on the transaction, whether inflow or outflow.
**If the vehicle record (DA3) is not found, the plate will be fetched from the F1_PLACA or F2_PLACA fields depending on the transaction, whether inflow or outflow. If the Vehicles file (DA3) is found, the plate will be obtained from the DA3_PLACA field or, if the parameter MV_SCANEP2/MV_SCANEP3 is used, the parameter field will be read.
***Field of the SB5 table entered in the parameter MV_SCANC01.
For this record, the information is generated from the generic file of products, physical and financial balances, balances on third-party possession, and according to the content of the parameter MV_SCANC02.
Informações | ||
---|---|---|
| ||
After importing this record, the information referring to each product's Tax Replacement calculation base value (Field 05) must be manually entered into the SCANC-CTB program. The fields Average Rate (field 07) and ICMS Value (field 08) must also be entered manually into the SCANC-CTB program, but they must only be entered for stock of the product AEA - Fuel Anhydrous Ethyl Alcohol. |
For this record, the information must be manually entered into the SCANC-CTB program.
For this record, the information must be manually entered into the SCANC-CTB program.
For this record, the information must be manually entered into the SCANC-CTB program.
This record indicates the records total by type.
Field creation/Fields used
Table SB5 - Additional Product Data
Field | <field according to the customer> |
Type | C |
Size | 9 |
Format | 999999999 |
Title | Cod.Tab.41 |
Description | Code of table 41. |
Definition | Product code in table 4.1 of the guide. |
Example | B5_TAB41 |
Field | <field according to the customer> |
Type | C |
Size | 3 |
Format | @! |
Title | Cod.Tab.42 |
Description | Code of table 42. |
Definition | Product abbreviation code in Table 4.2 of the Guide |
Example | B5_TAB42 |
Field | <field according to the customer> |
Type | C |
Size | 3 |
Format | @! |
Title | Category |
Description | Site category. |
Definition | Site Category Code. |
Example | A1_CATEGOR |
Table SA2 - Suppliers File
Field | <field according to the customer> |
Type | C |
Size | 3 |
Format | @! |
Title | Category |
Description | Site category. |
Definition | Site Category Code. |
Example | A2_CATEGOR |
Field | <field according to the customer> |
Type | C |
Size | 18 |
Format | @! |
Title | State Reg. |
Description | State Registration of the supplier. |
Definition | Tax Replacement State registration of the supplier. |
Example | A2_IEST |
Field | <field according to the customer> |
Type | C |
Size | 7 |
Format | @R AAA-9999 |
Title | Plac.Scanc2 |
Description | SCANC Plate2 |
Definition | Vehicle Plate2 for SCANC |
Example | DA3_PLACA2 |
Field | <field according to the customer> |
Type | C |
Size | 7 |
Format | @R AAA-9999 |
Title | Plac.Scanc3 |
Description | SCANC Plate3 |
Definition | Vehicle Plate3 for SCANC |
Example | DA3_PLACA3 |
Field | <field according to the customer> |
Type | C |
Size | 7 |
Format | @R AAA-9999 |
Title | Plac.Scanc1 |
Description | SCANC Plate1 |
Definition | Vehicle Plate1 for SCANC |
Example | C5_PLACA1 |
Field | <field according to the customer> |
Type | C |
Size | 7 |
Format | @R AAA-9999 |
Title | Plac.Scanc2 |
Description | SCANC Plate2 |
Definition | Vehicle Plate2 for SCANC |
Example | C5_PLACA2 |
Field | <field according to the customer> |
Type | C |
Size | 7 |
Format | @R AAA-9999 |
Title | Plac.Scanc3 |
Description | SCANC Plate3 |
Definition | Vehicle Plate3 for SCANC |
Example | C5_PLACA3 |
Informações | ||
---|---|---|
| ||
The fields above are mandatory to generate the files referring to SCANC. |
Creation of parameters on file SX6– Parameters:
Name | MV_SCANC01 |
Type | Character |
Description | SB5 table field containing the product code (according to Table 4.1 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: B5_TAB41
Name | MV_SCANC02 |
Type | Character |
Description | SB5 table field containing the product acronym (according to Table 4.2 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: B5_TAB42
Name | MV_SCANC03 |
Type | Character |
Description | SA1 table field containing the site category (field 12 of Record 20 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: A1_CATEGOR
Name | MV_SCANC04 |
Type | Character |
Description | SA2 table field containing the site category (field 12 of Record 20 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: A2_CATEGOR
Name | MV_SCANC05 |
Type | Character |
Description | SA2 table field containing the Supplier's Tax Replacement state registration (field 04 of record 20 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: A2_IEST
Name | MV_SCANC06 |
Type | Character |
Description | Tax Replacement state registrations that the taxpayer has (Fields 06 and 07 of Record 10 of the Scanc Guide). |
Content | The substitute state registrations must be entered as follows: |
Example | 9901SP612000646114/9901SP562000646114 |
Suggestion of content: 9901SP612000646114/9901SP562000646114
Name | MV_SCANC07 |
Type | Character |
Description | Percentage of gasoline type "A" (Field 20 of Record Type 40 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: 75
Name | MV_SCANC08 |
Type | Character |
Description | States that do not adopt PMPF - Weighted Average Price to Final Consumer - when determining the aggregate value margin (field 22 of the |
Content | Enter the States not adopting PMPF, separated by slashes . |
Suggestion of content: BA/SP
Name | MV_SCANC09 |
Type | Character |
Description | CFOPs that are not considered in the generation of Record Type 40(Invoice - Scanc). |
Content | Enter the CFOPs to ignore, separated by slashes . |
Suggestion of content: 1102/5102
Name | MV_SCANC10 |
Type | Character |
Description | Codes of the products (table 4) that do not have the PMPF - Scanc. |
Content | Enter the codes of the products that do not have the Weighted Average Price to the Final Consumer (PMPF), |
Suggestion of content: 66575/66664
Name | MV_SCANC11 |
Type | Character |
Description | Codes of anhydrous ethyl ethanol fuel that must not be stated in internal transactions. |
Content | Enter the codes of the products that must not be declared in the Scanc according to chapter IV of the Cotepe Act 3/99, separated by slashes . |
Suggestion of content: 000001/000002/
Name | MV_SCANC12 |
Type | Numeric |
Description | Enter the percentage of Diesel (Field 20 of Record Type 40 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: 70
Name | MV_SCANC13 |
Type | Character |
Description | Percentage of Gas Type "C" (Field 20 of Record Type 40 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: 75
Name | MV_SCANC14 |
Type | Numeric |
Description | Enter the percentage of Diesel Type "B" (Field 20 of Record Type 40 of the Scanc Guide). |
Content | <field according to the customer> |
Suggestion of content: 70
Name | MV_SCANC15 |
Type | Character |
Description | TIOs that are not considered in the generation of Record Type 40 (Invoice - Scanc). |
Content | Enter the TIOs that must not be considered, separated by slashes . |
Suggestion of content: 001/501
Name | MV_SCANCQT |
Type | Logical |
Description | Indicates if the net weight defined in the product table) is considered in the quantity composition – Record 40 |
Content | .T. or .F. |
Name | MV_ULMES |
Type | Character |
Description | Date of the last stock closing. |
Content | <last closing day> |
Example | 20031231 |
Name | MV_PROGASA |
Type | Character |
Description | Enter the code of the product Gasoline A according to table 4.1 of the Scanc guide. |
Content | According to table 4.1 of the SCANC guide, the content of field B5_COD - Product code in the product complement must be considered, separated by /. |
Suggestion of content: 64300/62006
Name | MV_PROGASB |
Type | Character |
Description | Enter the code of the product Gasoline B according to table 4.1 of the Scanc guide. |
Content | According to table 4.1 of the SCANC guide, the content of field B5_COD - Product Code in the product complement must be considered, separated by /. |
Suggestion of content: 64300/62006
Name | MV_PRODIE |
Type | Character |
Description | Enter the code of the Diesel product according to table 4.1 of the Scanc guide. |
Content | According to table 4.1 of the SCANC guide, the content of field B5_COD - Product Code in the product complement must be considered, separated by /. |
Suggestion of content: 66591/66680
Name | MV_PRODIB |
Type | Character |
Description | Enter the code of the Diesel type B product according to table 4.1 of the Scanc manual. |
Content | According to table 4.1 of the SCANC guide, the content of field B5_COD - Product Code in the product complement must be considered, separated by /. |
Suggestion of content: 66591/66680
Name | MV_SCANEP2 |
Type | Character |
Description | The field of the DA3 table to be used to compose the field 15 - Second Plate in record 40, for incoming invoices in the SCANC file |
Content | <field according to the customer> |
Example | DA3_PLACA2 |
Suggestion of content: DA3_PLACA2
Name | MV_SCANEP3 |
Type | Character |
Description | The field of the DA3 table to be used to compose the field 16 - Third Plate in record 40, for incoming invoices in the SCANC file |
Content | <field according to the customer> |
Suggestion of content: DA3_PLACA3
Name | MV_SCANSP1 |
Type | Character |
Description | The field of the SC5 table to be used to compose the field 14 First Plate in record 40, for incoming invoices in the SCANC file |
Content | <field according to the customer> |
Suggestion of content: C5_PLACA1
Name | MV_SCANSP2 |
Type | Character |
Description | The field of the SC5 table to be used to compose the field 15 Second Plate in record 40, for outgoing invoices in the SCANC file |
Content | <field according to the customer> |
Suggestion of content: C5_PLACA2
Name | MV_SCANSP3 |
Type | Character |
Description | The field of the SC5 table to be used to compose the field 16 Third Plate in record 40, for outgoing invoices in the SCANC file |
Content | <field according to the customer> |
Example | C5_PLACA3 |
Suggestion of content: C5_PLACA3
Tables | SM0 – Companies File |
Routines | MATA950 – Normative Instructions |