CONTENT
01. OVERVIEW
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 | |
---|
Legislation involved | Statute no. 3,665, November 20, 2000. |
---|
02. EXAMPLE OF USE
a - How to Generate the Files
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.
b - Types of Generated Records
Type 10 – Accountant Identification
For this record, the information is generated through the Company File and according to the filling of parameter MV_SCANC06.
Type 20 – Suppliers / Customer File
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.
Type 45 – Invoices for Single-Phase Taxation of Diesel and Biodiesel Oil
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.
Products listed on Record 45
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 | - For Pure Product, the quantity will be from the field (D1_QUANT or D2_QUANT),
- For products with a mixture, a ratio of the (Invoice Quantity - (Mixture Ratio (CD6_PBIO * INVOICE QUANTITY)).
|
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.
Type 47 – GLP/GLGN Single Phase Taxation Invoice
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.
Products listed on Record 47
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.
Type 62 – Vendor Inventory
For this record, the information must be manually entered into the SCANC-CTB program.
Type 70 – Inventory Range
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.
Type 90 – File Totalizator
This record indicates the records total by type.
03. FIELDS
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 |
Table SA1 – Customers File
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 |
Table DA3 – Vehicles File
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 |
SC5 - Sales Order
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 |
04. PARAMETERS
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:
Enter the company code. Example: 99. Enter the company branch. Example: 01. Enter the company State. Example: SP. Enter the State Reg. Example: 6120006460114 (no dots, dashes, or any masks).
Example: 9901SP612000646114 If more than one registration exists, it will be typed in the same manner, but separated by a slash "/". Use the slashes only to separate the registrations. Do not use them at the beginning and the end. Example: 9901SP612000646114/9901SP562000646114 |
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 record 40 of the Scanc manual). |
Content | Enter the States not adopting PMPF, separated by slashes . This parameter is used to record the field "Calculation base value" record type 40 - Invoices, according to the layout). |
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), separated by slashes according to table 4 of the Scanc layout. Example: fuel oil. This parameter is used to record the field Calculation Base Value - Record Type 40 - Invoices. |
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 (If .T., consider; if .F., does not consider) |
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
05. TABLES
Tables | SM0 – Companies File SA1 – Customers File SA2 – Suppliers File SB1 – Products File SB5 – Products Complement SF1 – Incoming Invoice Header SD1 – Incoming Invoice Items SF2 – Outgoing Invoices Header |
Routines | MATA950 – Normative Instructions MATXMAG – Functions Library SCANC.INI - SCANC SCANC.PRW |